|
|
unit u_code_fee_project;
|
|
|
|
|
|
interface
|
|
|
|
|
|
uses
|
|
|
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
|
|
|
Dialogs, BusinessSkinForm, DB, ADODB, bsSkinCtrls, ExtCtrls, Grids,
|
|
|
Wwdbigrd, Wwdbgrid, StdCtrls, Mask, wwdbedit, Wwdotdot, Wwdbcomb,
|
|
|
wwdblook, RxMemDS, DBCtrls;
|
|
|
|
|
|
type
|
|
|
Tfrm_code_fee_project = class(TForm)
|
|
|
t_ch_project: TADOQuery;
|
|
|
t_ch_project1: TDataSource;
|
|
|
t_ch_project_fee: TADOQuery;
|
|
|
t_ch_project_fee1: TDataSource;
|
|
|
t_ch_project_standard: TADOQuery;
|
|
|
t_ch_project_standard1: TDataSource;
|
|
|
Panel1: TPanel;
|
|
|
Panel2: TPanel;
|
|
|
Panel3: TPanel;
|
|
|
wwDBGrid1: TwwDBGrid;
|
|
|
Panel4: TPanel;
|
|
|
wwDBGrid2: TwwDBGrid;
|
|
|
bsSkinButton1: TbsSkinButton;
|
|
|
bsSkinButton2: TbsSkinButton;
|
|
|
bsSkinButton4: TbsSkinButton;
|
|
|
bsSkinButton3: TbsSkinButton;
|
|
|
bsSkinButton5: TbsSkinButton;
|
|
|
bsSkinButton6: TbsSkinButton;
|
|
|
bsSkinButton7: TbsSkinButton;
|
|
|
bsSkinButton8: TbsSkinButton;
|
|
|
bsSkinButton9: TbsSkinButton;
|
|
|
wwDBComboBox1: TwwDBComboBox;
|
|
|
wwDBComboBox2: TwwDBComboBox;
|
|
|
wwDBLookupCombo2: TwwDBLookupCombo;
|
|
|
wwDBLookupCombo3: TwwDBLookupCombo;
|
|
|
wwDBLookupCombo1: TwwDBLookupCombo;
|
|
|
t_bz_balance: TRxMemoryData;
|
|
|
wwDBLookupCombo4: TwwDBLookupCombo;
|
|
|
t_bz_client: TRxMemoryData;
|
|
|
wwDBLookupCombo5: TwwDBLookupCombo;
|
|
|
wwDBLookupCombo6: TwwDBLookupCombo;
|
|
|
bsSkinButton14: TbsSkinButton;
|
|
|
t_ch_project_old: TADOQuery;
|
|
|
t_ch_project_old1: TDataSource;
|
|
|
t_ch_project_fee_old1: TDataSource;
|
|
|
t_ch_project_fee_old: TADOQuery;
|
|
|
t_ch_project_standard_old: TADOQuery;
|
|
|
t_ch_project_standard_old1: TDataSource;
|
|
|
Panel6: TPanel;
|
|
|
Panel5: TPanel;
|
|
|
bsSkinButton10: TbsSkinButton;
|
|
|
bsSkinButton11: TbsSkinButton;
|
|
|
bsSkinButton12: TbsSkinButton;
|
|
|
bsSkinButton13: TbsSkinButton;
|
|
|
wwDBGrid3: TwwDBGrid;
|
|
|
DBEdit1: TDBEdit;
|
|
|
procedure FormClose(Sender: TObject; var Action: TCloseAction);
|
|
|
procedure FormShow(Sender: TObject);
|
|
|
procedure Panel3Resize(Sender: TObject);
|
|
|
procedure bsSkinButton9Click(Sender: TObject);
|
|
|
procedure bsSkinButton1Click(Sender: TObject);
|
|
|
procedure bsSkinButton2Click(Sender: TObject);
|
|
|
procedure bsSkinButton4Click(Sender: TObject);
|
|
|
procedure bsSkinButton3Click(Sender: TObject);
|
|
|
procedure bsSkinButton5Click(Sender: TObject);
|
|
|
procedure bsSkinButton6Click(Sender: TObject);
|
|
|
procedure bsSkinButton7Click(Sender: TObject);
|
|
|
procedure bsSkinButton8Click(Sender: TObject);
|
|
|
procedure bsSkinButton10Click(Sender: TObject);
|
|
|
procedure bsSkinButton11Click(Sender: TObject);
|
|
|
procedure bsSkinButton12Click(Sender: TObject);
|
|
|
procedure bsSkinButton13Click(Sender: TObject);
|
|
|
procedure t_ch_projectAfterInsert(DataSet: TDataSet);
|
|
|
procedure t_ch_projectBeforePost(DataSet: TDataSet);
|
|
|
procedure t_ch_project_feeBeforePost(DataSet: TDataSet);
|
|
|
procedure t_ch_project_feeBeforeInsert(DataSet: TDataSet);
|
|
|
procedure t_ch_project_standardBeforeInsert(DataSet: TDataSet);
|
|
|
procedure t_ch_projectAfterScroll(DataSet: TDataSet);
|
|
|
procedure wwDBLookupCombo1Change(Sender: TObject);
|
|
|
procedure wwDBLookupCombo3Change(Sender: TObject);
|
|
|
procedure t_ch_projectBeforeEdit(DataSet: TDataSet);
|
|
|
procedure wwDBLookupCombo6Change(Sender: TObject);
|
|
|
procedure t_ch_project_standardBeforePost(DataSet: TDataSet);
|
|
|
procedure t_ch_projectPostError(DataSet: TDataSet; E: EDatabaseError;
|
|
|
var Action: TDataAction);
|
|
|
procedure wwDBLookupCombo2Enter(Sender: TObject);
|
|
|
procedure bsSkinButton14Click(Sender: TObject);
|
|
|
procedure DBEdit1Change(Sender: TObject);
|
|
|
procedure t_ch_project_feeAfterOpen(DataSet: TDataSet);
|
|
|
private
|
|
|
procedure t_ch_feecurrcharge(Sender: TField);
|
|
|
|
|
|
{ Private declarations }
|
|
|
public
|
|
|
{ Public declarations }
|
|
|
end;
|
|
|
|
|
|
var
|
|
|
frm_code_fee_project: Tfrm_code_fee_project;
|
|
|
|
|
|
implementation
|
|
|
|
|
|
uses u_main, u_data_share, my_sys_function, u_code_fee_project_copy;
|
|
|
|
|
|
{$R *.dfm}
|
|
|
|
|
|
|
|
|
procedure Tfrm_code_fee_project.FormClose(Sender: TObject;
|
|
|
var Action: TCloseAction);
|
|
|
begin
|
|
|
frm_code_fee_project.Hide;
|
|
|
frm_code_fee_project.ManualFloat(frm_code_fee_project.BoundsRect );
|
|
|
frm_main.freeTabs('frm_code_fee_project');
|
|
|
action:=cafree;
|
|
|
frm_code_fee_project:=nil;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.FormShow(Sender: TObject);
|
|
|
begin
|
|
|
t_ch_project.SQL.clear;
|
|
|
t_ch_project.sql.add('select * from t_ch_project ');
|
|
|
t_ch_project.SQL.Add(' where '+open_data('8005','¼<><C2BC><EFBFBD><EFBFBD>','no','no','no','no')
|
|
|
+'order by <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
|
|
|
t_ch_project.open;
|
|
|
t_ch_project_fee.open;
|
|
|
t_ch_project_standard.open;
|
|
|
|
|
|
frm_data_share.t_code_fee.requery;
|
|
|
frm_data_share.t_crm_client.requery;
|
|
|
frm_data_share.t_code_currency.requery;
|
|
|
frm_data_share.t_code_ctn.requery;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.Panel3Resize(Sender: TObject);
|
|
|
var
|
|
|
i:integer;
|
|
|
begin
|
|
|
i:=round(Panel3.width/5);
|
|
|
bsSkinButton1.width:=i;
|
|
|
bsSkinButton14.width:=i;
|
|
|
bsSkinButton2.width:=i;
|
|
|
bsSkinButton4.width:=i;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton9Click(Sender: TObject);
|
|
|
begin
|
|
|
close;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton1Click(Sender: TObject);
|
|
|
begin
|
|
|
t_ch_project.insert;
|
|
|
end;
|
|
|
procedure Tfrm_code_fee_project.t_ch_feecurrcharge(Sender: TField);
|
|
|
begin
|
|
|
if (t_ch_project_fee.state=dsedit)or(t_ch_project_fee.state=dsinsert)then
|
|
|
begin
|
|
|
if t_ch_project_fee.FieldByName('<27>ұ<EFBFBD>').AsString='RMB' then begin
|
|
|
t_ch_project_fee.FieldByName('<27><><EFBFBD><EFBFBD>').Asfloat:=1;
|
|
|
end else begin
|
|
|
IF frm_data_share.t_code_currency.Locate('<27>ұ<EFBFBD>',t_ch_project_fee.FieldByName('<27>ұ<EFBFBD>').AsString,[])then
|
|
|
t_ch_project_fee['<27><><EFBFBD><EFBFBD>']:=frm_data_share.t_code_currency.fieldbyname('<27><><EFBFBD><EFBFBD>').asfloat;
|
|
|
|
|
|
end;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton2Click(Sender: TObject);
|
|
|
begin
|
|
|
table_post(t_ch_project);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton4Click(Sender: TObject);
|
|
|
begin
|
|
|
table_delete(t_ch_project);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton3Click(Sender: TObject);
|
|
|
begin
|
|
|
table_cancel(t_ch_project);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton5Click(Sender: TObject);
|
|
|
begin
|
|
|
t_ch_project_fee.insert;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton6Click(Sender: TObject);
|
|
|
begin
|
|
|
table_post(t_ch_project_fee);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton7Click(Sender: TObject);
|
|
|
begin
|
|
|
table_delete(t_ch_project_fee);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton8Click(Sender: TObject);
|
|
|
begin
|
|
|
table_cancel(t_ch_project_fee);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton10Click(Sender: TObject);
|
|
|
begin
|
|
|
t_ch_project_standard.insert;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton11Click(Sender: TObject);
|
|
|
begin
|
|
|
table_post(t_ch_project_standard);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton12Click(Sender: TObject);
|
|
|
begin
|
|
|
table_delete(t_ch_project_standard);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton13Click(Sender: TObject);
|
|
|
begin
|
|
|
table_cancel(t_ch_project_standard);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_projectAfterInsert(DataSet: TDataSet);
|
|
|
begin
|
|
|
t_ch_project['¼<><C2BC><EFBFBD><EFBFBD>']:=employee;
|
|
|
t_ch_project['¼<><C2BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_projectBeforePost(DataSet: TDataSet);
|
|
|
begin
|
|
|
table_before_post(t_ch_project,'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
|
|
|
table_before_post(t_ch_project,'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
|
|
|
table_before_post(t_ch_project,'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_project_feeBeforePost(
|
|
|
DataSet: TDataSet);
|
|
|
begin
|
|
|
table_before_post(t_ch_project_fee,'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>');
|
|
|
table_before_post(t_ch_project_fee,'<27>ұ<EFBFBD>');
|
|
|
table_before_post(t_ch_project_fee,'<27><><EFBFBD><EFBFBD>');
|
|
|
table_before_post(t_ch_project_fee,'<27><>');
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_project_feeBeforeInsert(
|
|
|
DataSet: TDataSet);
|
|
|
begin
|
|
|
table_before_insert(t_ch_project);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_project_standardBeforeInsert(
|
|
|
DataSet: TDataSet);
|
|
|
begin
|
|
|
if do_data('8005',t_ch_project.fieldbyname('¼<><C2BC><EFBFBD><EFBFBD>').asstring,'','','','','')=false then
|
|
|
begin
|
|
|
showmessage('<27>Բ<EFBFBD><D4B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ȩ<EFBFBD>Ĵ<DEB8><C4B4><EFBFBD><EFBFBD>ݣ<EFBFBD><DDA3><EFBFBD>');
|
|
|
abort;
|
|
|
end;
|
|
|
table_before_insert(t_ch_project_fee);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_projectAfterScroll(DataSet: TDataSet);
|
|
|
var
|
|
|
i:integer;
|
|
|
begin
|
|
|
if (copy(t_ch_project.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring,1,4)='<27><><EFBFBD><EFBFBD>') then
|
|
|
begin
|
|
|
frm_data_share.t_code_fee_unit.Filtered:=false;
|
|
|
frm_data_share.t_code_fee_unit.Filter:='<27><><EFBFBD><EFBFBD>=1';
|
|
|
frm_data_share.t_code_fee_unit.Filtered:=true;
|
|
|
|
|
|
t_bz_balance.close;
|
|
|
t_bz_balance.open;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='1-<2D><>Ʊ';
|
|
|
t_bz_balance['two']:='<27><>Ʊ';
|
|
|
t_bz_balance['three']:='<27><>Ʊ';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='2-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='3-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='4-<2D>ƷѶ<C6B7>';
|
|
|
t_bz_balance['two']:='<27>ƷѶ<C6B7>';
|
|
|
t_bz_balance['three']:='<27>ƷѶ<C6B7>';
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='5-TEU';
|
|
|
t_bz_balance['two']:='TEU';
|
|
|
t_bz_balance['three']:='TEU';
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='6-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
|
|
|
frm_data_share.t_code_fee_unit.First;
|
|
|
while not frm_data_share.t_code_fee_unit.eof do begin
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:=frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><EFBFBD>').asstring+'-'+frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><D7BC><EFBFBD><EFBFBD>').asstring;
|
|
|
t_bz_balance['two']:=frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><D7BC><EFBFBD><EFBFBD>').asstring;
|
|
|
t_bz_balance['three']:=frm_data_share.t_code_fee_unit.fieldbyname('Ĭ<><C4AC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asfloat;
|
|
|
t_bz_balance.post;
|
|
|
frm_data_share.t_code_fee_unit.next;
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
|
|
t_bz_client.close;
|
|
|
t_bz_client.open;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='0-ί<>е<EFBFBD>λ';
|
|
|
t_bz_client['two']:='ί<>е<EFBFBD>λ';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='1-<2D><> <20><> ˾';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD>˾';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='2-<2D><> վ';
|
|
|
t_bz_client['two']:='<27><>վ';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='3-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='4-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='5-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='6-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='7-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='8-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27>ջ<EFBFBD><D5BB><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='9-ͨ ֪ <20><>';
|
|
|
t_bz_client['two']:='֪ͨ<CDA8><D6AA>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='10-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD>ͻ<EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
|
|
|
frm_data_share.t_code_fee.Filtered:=false;
|
|
|
frm_data_share.t_code_fee.Filter:='<27><><EFBFBD><EFBFBD>=1';
|
|
|
frm_data_share.t_code_fee.Filtered:=true;
|
|
|
end
|
|
|
else
|
|
|
if (copy(t_ch_project.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring,1,4)='<27><><EFBFBD><EFBFBD>') then
|
|
|
begin
|
|
|
frm_data_share.t_code_fee_unit.Filtered:=false;
|
|
|
frm_data_share.t_code_fee_unit.Filter:='<27><><EFBFBD><EFBFBD>=1';
|
|
|
frm_data_share.t_code_fee_unit.Filtered:=true;
|
|
|
|
|
|
t_bz_balance.close;
|
|
|
t_bz_balance.open;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='1-<2D><>Ʊ';
|
|
|
t_bz_balance['two']:='<27><>Ʊ';
|
|
|
t_bz_balance['three']:='<27><>Ʊ';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='2-<2D>Ƽ<EFBFBD><C6BC><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27>Ƽ<EFBFBD><C6BC><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27>Ƽ<EFBFBD><C6BC><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='3-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
|
|
|
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='4-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
|
|
|
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='5-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='6-ë<><C3AB>';
|
|
|
t_bz_balance['two']:='ë<><C3AB>';
|
|
|
t_bz_balance['three']:='ë<><C3AB>';
|
|
|
t_bz_balance.post;
|
|
|
|
|
|
|
|
|
frm_data_share.t_code_fee_unit.First;
|
|
|
while not frm_data_share.t_code_fee_unit.eof do begin
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:=frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><EFBFBD>').asstring+'-'+frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><D7BC><EFBFBD><EFBFBD>').asstring;
|
|
|
t_bz_balance['two']:=frm_data_share.t_code_fee_unit.fieldbyname('<27><><EFBFBD><D7BC><EFBFBD><EFBFBD>').asstring;
|
|
|
t_bz_balance['three']:=frm_data_share.t_code_fee_unit.fieldbyname('Ĭ<><C4AC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asfloat;
|
|
|
t_bz_balance.post;
|
|
|
frm_data_share.t_code_fee_unit.next;
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
t_bz_client.close;
|
|
|
t_bz_client.open;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='1-ί<>е<EFBFBD>λ';
|
|
|
t_bz_client['two']:='ί<>е<EFBFBD>λ';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='2-<2D><><EFBFBD>չ<EFBFBD>˾';
|
|
|
t_bz_client['two']:='<27><><EFBFBD>չ<EFBFBD>˾';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='3-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='4-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='5-<2D><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD>ͻ<EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='6-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='7-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27>ջ<EFBFBD><D5BB><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='8-<2D><><EFBFBD>մ<EFBFBD><D5B4><EFBFBD>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD>մ<EFBFBD><D5B4><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='9-ж<><D0B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client['two']:='ж<><D0B6><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
|
|
|
|
|
|
frm_data_share.t_code_fee.Filtered:=false;
|
|
|
frm_data_share.t_code_fee.Filter:='<27><><EFBFBD><EFBFBD>=1';
|
|
|
frm_data_share.t_code_fee.Filtered:=true;
|
|
|
end else if (t_ch_project.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring='<27><>·<EFBFBD><C2B7><EFBFBD><EFBFBD>') then begin
|
|
|
t_bz_balance.close;
|
|
|
t_bz_balance.open;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='1-<2D><>Ʊ';
|
|
|
t_bz_balance['two']:='<27><>Ʊ';
|
|
|
t_bz_balance['three']:='<27><>Ʊ';
|
|
|
t_bz_balance.post;
|
|
|
t_bz_balance.Append;
|
|
|
t_bz_balance['one']:='2-<2D><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['two']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance['three']:='<27><><EFBFBD><EFBFBD>';
|
|
|
t_bz_balance.post;
|
|
|
|
|
|
|
|
|
t_bz_client.close;
|
|
|
t_bz_client.open;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='1-ί<>е<EFBFBD>λ';
|
|
|
t_bz_client['two']:='ί<>е<EFBFBD>λ';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='2-<2D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='3-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
t_bz_client.Append;
|
|
|
t_bz_client['one']:='4-<2D><> <20><> <20><>';
|
|
|
t_bz_client['two']:='<27>ջ<EFBFBD><D5BB><EFBFBD>';
|
|
|
t_bz_client.post;
|
|
|
frm_data_share.t_code_fee.Filtered:=false;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.wwDBLookupCombo1Change(Sender: TObject);
|
|
|
begin
|
|
|
if (t_ch_project_fee.state=dsinsert)or(t_ch_project_fee.state=dsedit) then
|
|
|
begin
|
|
|
t_ch_project_fee['<27>ұ<EFBFBD>']:=frm_data_share.t_code_fee.fieldbyname('Ĭ<>ϱұ<CFB1>').asstring;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.wwDBLookupCombo3Change(Sender: TObject);
|
|
|
begin
|
|
|
{
|
|
|
if (t_ch_project_fee.state=dsinsert)or(t_ch_project_fee.state=dsedit) then
|
|
|
begin
|
|
|
IF frm_data_share.t_code_currency.Locate('<27>ұ<EFBFBD>',wwDBLookupCombo3.text,[])then
|
|
|
t_ch_project_fee['<27><><EFBFBD><EFBFBD>']:=frm_data_share.t_code_currency.fieldbyname('<27><><EFBFBD><EFBFBD>').asfloat;
|
|
|
end;
|
|
|
}
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_projectBeforeEdit(DataSet: TDataSet);
|
|
|
begin
|
|
|
if do_data('8005',t_ch_project.fieldbyname('¼<><C2BC><EFBFBD><EFBFBD>').asstring,'','','','','')=false then
|
|
|
begin
|
|
|
showmessage('<27>Բ<EFBFBD><D4B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ȩ<EFBFBD>Ĵ<DEB8><C4B4><EFBFBD><EFBFBD>ݣ<EFBFBD><DDA3><EFBFBD>');
|
|
|
abort;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.wwDBLookupCombo6Change(Sender: TObject);
|
|
|
begin
|
|
|
if (t_ch_project_standard.State=dsedit)or(t_ch_project_standard.State=dsinsert) then
|
|
|
begin
|
|
|
if frm_data_share.t_code_ctn.Locate('<27><><EFBFBD><EFBFBD>',wwDBLookupCombo6.text,[]) then
|
|
|
begin
|
|
|
t_ch_project_standard['<27><>']:=frm_data_share.t_code_ctn['<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʽ'];
|
|
|
end
|
|
|
else
|
|
|
begin
|
|
|
t_ch_project_standard['<27><>']:='';
|
|
|
end;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_project_standardBeforePost(
|
|
|
DataSet: TDataSet);
|
|
|
begin
|
|
|
table_before_post(t_ch_project_standard,'<27><><EFBFBD>ʹ<EFBFBD><CDB4><EFBFBD>');
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_projectPostError(DataSet: TDataSet;
|
|
|
E: EDatabaseError; var Action: TDataAction);
|
|
|
begin
|
|
|
table_post_error_primary('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',E);
|
|
|
table_post_error_primary('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',E);
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.wwDBLookupCombo2Enter(Sender: TObject);
|
|
|
begin
|
|
|
if t_ch_project_fee.FieldByName('<27><><EFBFBD>㵥λ').asstring<>''then
|
|
|
begin
|
|
|
frm_data_share.t_crm_client.Filtered:=false;
|
|
|
frm_data_share.t_crm_client.Filter:=t_ch_project_fee.FieldByName('<27><><EFBFBD>㵥λ').asstring+'=1';
|
|
|
frm_data_share.t_crm_client.Filtered:=true;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.bsSkinButton14Click(Sender: TObject);
|
|
|
begin
|
|
|
if t_ch_project.IsEmpty then
|
|
|
exit;
|
|
|
table_post(t_ch_project);
|
|
|
|
|
|
t_ch_project_old.Close;
|
|
|
t_ch_project_fee_old.close;
|
|
|
t_ch_project_standard_old.close;
|
|
|
t_ch_project_old.Parameters[0].value:=t_ch_project.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring;
|
|
|
t_ch_project_old.open;
|
|
|
t_ch_project_fee_old.open;
|
|
|
t_ch_project_standard_old.open;
|
|
|
|
|
|
try
|
|
|
frm_code_fee_project_copy:=tfrm_code_fee_project_copy.Create (self);
|
|
|
t_ch_project.insert;
|
|
|
t_ch_project['<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=t_ch_project_old['<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'];
|
|
|
t_ch_project['<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=t_ch_project_old['<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'];
|
|
|
t_ch_project['ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=t_ch_project_old['ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'];
|
|
|
frm_code_fee_project_copy.ShowModal;
|
|
|
finally
|
|
|
frm_code_fee_project_copy.Free;
|
|
|
frm_code_fee_project_copy:=nil;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.DBEdit1Change(Sender: TObject);
|
|
|
begin
|
|
|
if DBEdit1.Text<>'<27><><EFBFBD><EFBFBD>' then
|
|
|
begin
|
|
|
Panel6.Visible:=false;
|
|
|
end
|
|
|
else
|
|
|
begin
|
|
|
Panel6.Visible:=true;
|
|
|
end;
|
|
|
end;
|
|
|
|
|
|
procedure Tfrm_code_fee_project.t_ch_project_feeAfterOpen(
|
|
|
DataSet: TDataSet);
|
|
|
begin
|
|
|
t_ch_project_fee.FieldByName('<27>ұ<EFBFBD>').OnChange:=t_ch_feecurrcharge;
|
|
|
end;
|
|
|
|
|
|
end.
|