{$INCLUDE t_main.inc} unit u_ch_balance_query; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, BusinessSkinForm, bsSkinCtrls, RxLookup, wwdbdatetimepicker,inifiles, StdCtrls, Mask, wwdbedit, Wwdotdot, Wwdbcomb, ComCtrls, bsSkinTabs; type Tfrm_ch_balance_query = class(TForm) bsSkinGroupBox1: TbsSkinGroupBox; Label6: TLabel; Label3: TLabel; Label9: TLabel; Label2: TLabel; Label5: TLabel; Label11: TLabel; Label14: TLabel; Label4: TLabel; Label8: TLabel; Label10: TLabel; Label1: TLabel; Label7: TLabel; wwDBComboBox15: TwwDBComboBox; Edit2: TEdit; wwDBComboBox4: TwwDBComboBox; Edit4: TEdit; wwDBComboBox21: TwwDBComboBox; RxDBLookupCombo2: TRxDBLookupCombo; wwDBComboBox14: TwwDBComboBox; wwDBComboBox11: TwwDBComboBox; wwDBComboBox6: TwwDBComboBox; RxDBLookupCombo1: TRxDBLookupCombo; wwDBDateTimePicker2: TwwDBDateTimePicker; wwDBDateTimePicker4: TwwDBDateTimePicker; RxDBLookupCombo3: TRxDBLookupCombo; RxDBLookupCombo4: TRxDBLookupCombo; wwDBDateTimePicker3: TwwDBDateTimePicker; wwDBDateTimePicker1: TwwDBDateTimePicker; Edit1: TEdit; wwDBComboBox1: TwwDBComboBox; wwDBComboBox17: TwwDBComboBox; wwDBComboBox2: TwwDBComboBox; wwDBComboBox18: TwwDBComboBox; wwDBComboBox19: TwwDBComboBox; wwDBComboBox5: TwwDBComboBox; wwDBComboBox3: TwwDBComboBox; bsBusinessSkinForm1: TbsBusinessSkinForm; bsSkinPageControl1: TbsSkinPageControl; bsSkinTabSheet1: TbsSkinTabSheet; Label12: TLabel; Label13: TLabel; Label15: TLabel; Label16: TLabel; Label17: TLabel; Label18: TLabel; Label19: TLabel; Label20: TLabel; Label21: TLabel; Label22: TLabel; Label23: TLabel; Label24: TLabel; wwDBComboBox7: TwwDBComboBox; Edit3: TEdit; wwDBComboBox8: TwwDBComboBox; Edit5: TEdit; wwDBComboBox16: TwwDBComboBox; Edit6: TEdit; wwDBComboBox9: TwwDBComboBox; Edit7: TEdit; wwDBComboBox10: TwwDBComboBox; wwDBDateTimePicker5: TwwDBDateTimePicker; wwDBComboBox12: TwwDBComboBox; wwDBDateTimePicker6: TwwDBDateTimePicker; wwDBDateTimePicker7: TwwDBDateTimePicker; wwDBComboBox13: TwwDBComboBox; wwDBDateTimePicker8: TwwDBDateTimePicker; wwDBComboBox20: TwwDBComboBox; wwDBComboBox24: TwwDBComboBox; RxDBLookupCombo5: TRxDBLookupCombo; wwDBComboBox22: TwwDBComboBox; RxDBLookupCombo6: TRxDBLookupCombo; RxDBLookupCombo7: TRxDBLookupCombo; wwDBComboBox23: TwwDBComboBox; wwDBComboBox25: TwwDBComboBox; RxDBLookupCombo8: TRxDBLookupCombo; bsSkinTabSheet2: TbsSkinTabSheet; Label25: TLabel; Label26: TLabel; Label27: TLabel; Label28: TLabel; Label29: TLabel; Label30: TLabel; Label31: TLabel; Label32: TLabel; Label33: TLabel; Label34: TLabel; Label35: TLabel; Label36: TLabel; wwDBComboBox26: TwwDBComboBox; Edit8: TEdit; wwDBComboBox27: TwwDBComboBox; Edit9: TEdit; wwDBComboBox28: TwwDBComboBox; Edit10: TEdit; wwDBComboBox29: TwwDBComboBox; Edit11: TEdit; wwDBComboBox30: TwwDBComboBox; wwDBDateTimePicker9: TwwDBDateTimePicker; wwDBComboBox31: TwwDBComboBox; wwDBDateTimePicker10: TwwDBDateTimePicker; wwDBComboBox32: TwwDBComboBox; wwDBDateTimePicker11: TwwDBDateTimePicker; wwDBComboBox33: TwwDBComboBox; wwDBDateTimePicker12: TwwDBDateTimePicker; RxDBLookupCombo9: TRxDBLookupCombo; wwDBComboBox34: TwwDBComboBox; RxDBLookupCombo10: TRxDBLookupCombo; wwDBComboBox35: TwwDBComboBox; wwDBComboBox36: TwwDBComboBox; RxDBLookupCombo11: TRxDBLookupCombo; wwDBComboBox37: TwwDBComboBox; RxDBLookupCombo12: TRxDBLookupCombo; bsSkinTabSheet3: TbsSkinTabSheet; Label37: TLabel; Label38: TLabel; Label39: TLabel; Label40: TLabel; Label41: TLabel; Label42: TLabel; Label43: TLabel; Label44: TLabel; Label45: TLabel; Label46: TLabel; Label47: TLabel; Label48: TLabel; wwDBComboBox38: TwwDBComboBox; Edit12: TEdit; wwDBComboBox39: TwwDBComboBox; Edit13: TEdit; Edit14: TEdit; wwDBComboBox40: TwwDBComboBox; Edit15: TEdit; wwDBComboBox41: TwwDBComboBox; wwDBComboBox42: TwwDBComboBox; wwDBDateTimePicker13: TwwDBDateTimePicker; wwDBComboBox43: TwwDBComboBox; wwDBDateTimePicker14: TwwDBDateTimePicker; wwDBDateTimePicker15: TwwDBDateTimePicker; wwDBComboBox44: TwwDBComboBox; wwDBDateTimePicker16: TwwDBDateTimePicker; wwDBComboBox45: TwwDBComboBox; wwDBComboBox46: TwwDBComboBox; RxDBLookupCombo13: TRxDBLookupCombo; wwDBComboBox47: TwwDBComboBox; RxDBLookupCombo14: TRxDBLookupCombo; RxDBLookupCombo15: TRxDBLookupCombo; wwDBComboBox48: TwwDBComboBox; RxDBLookupCombo16: TRxDBLookupCombo; wwDBComboBox49: TwwDBComboBox; bsSkinTabSheet4: TbsSkinTabSheet; Label49: TLabel; Label50: TLabel; Label51: TLabel; Label52: TLabel; Label53: TLabel; Label54: TLabel; Label55: TLabel; Label56: TLabel; Label57: TLabel; Label58: TLabel; Label59: TLabel; Label60: TLabel; wwDBComboBox50: TwwDBComboBox; Edit16: TEdit; wwDBComboBox51: TwwDBComboBox; Edit17: TEdit; Edit18: TEdit; wwDBComboBox52: TwwDBComboBox; Edit19: TEdit; wwDBComboBox53: TwwDBComboBox; wwDBComboBox54: TwwDBComboBox; wwDBDateTimePicker17: TwwDBDateTimePicker; wwDBComboBox55: TwwDBComboBox; wwDBDateTimePicker18: TwwDBDateTimePicker; wwDBDateTimePicker19: TwwDBDateTimePicker; wwDBComboBox56: TwwDBComboBox; wwDBDateTimePicker20: TwwDBDateTimePicker; wwDBComboBox57: TwwDBComboBox; wwDBComboBox58: TwwDBComboBox; RxDBLookupCombo17: TRxDBLookupCombo; wwDBComboBox59: TwwDBComboBox; RxDBLookupCombo18: TRxDBLookupCombo; RxDBLookupCombo19: TRxDBLookupCombo; wwDBComboBox60: TwwDBComboBox; RxDBLookupCombo20: TRxDBLookupCombo; wwDBComboBox61: TwwDBComboBox; bsSkinGroupBox2: TbsSkinGroupBox; Label61: TLabel; wwDBComboBox62: TwwDBComboBox; Edit20: TEdit; Label62: TLabel; wwDBComboBox63: TwwDBComboBox; RxDBLookupCombo21: TRxDBLookupCombo; Label63: TLabel; wwDBComboBox64: TwwDBComboBox; wwDBDateTimePicker21: TwwDBDateTimePicker; Label64: TLabel; wwDBComboBox65: TwwDBComboBox; wwDBDateTimePicker22: TwwDBDateTimePicker; Label65: TLabel; wwDBComboBox66: TwwDBComboBox; Edit21: TEdit; Label66: TLabel; wwDBComboBox67: TwwDBComboBox; Edit22: TEdit; bsSkinPanel1: TbsSkinPanel; bsSkinButton1: TbsSkinButton; bsSkinButton10: TbsSkinButton; bsSkinButton5: TbsSkinButton; bsSkinCheckRadioBox1: TbsSkinCheckRadioBox; Label67: TLabel; Edit23: TEdit; Label68: TLabel; Edit24: TEdit; Label69: TLabel; Edit25: TEdit; Label70: TLabel; Edit26: TEdit; Label71: TLabel; wwDBComboBox68: TwwDBComboBox; RxDBLookupCombo22: TRxDBLookupCombo; Label72: TLabel; Label73: TLabel; wwDBComboBox69: TwwDBComboBox; wwDBDateTimePicker23: TwwDBDateTimePicker; wwDBDateTimePicker24: TwwDBDateTimePicker; wwDBComboBox70: TwwDBComboBox; bsSkinTabSheet5: TbsSkinTabSheet; Label74: TLabel; Label75: TLabel; Label76: TLabel; Label77: TLabel; Label78: TLabel; Label79: TLabel; Label80: TLabel; Label81: TLabel; Label82: TLabel; Label83: TLabel; Label84: TLabel; Label85: TLabel; Label86: TLabel; Label87: TLabel; wwDBComboBox71: TwwDBComboBox; Edit27: TEdit; wwDBComboBox72: TwwDBComboBox; Edit28: TEdit; wwDBComboBox73: TwwDBComboBox; Edit29: TEdit; wwDBComboBox74: TwwDBComboBox; Edit30: TEdit; wwDBComboBox75: TwwDBComboBox; wwDBDateTimePicker25: TwwDBDateTimePicker; wwDBComboBox76: TwwDBComboBox; wwDBDateTimePicker26: TwwDBDateTimePicker; wwDBDateTimePicker27: TwwDBDateTimePicker; wwDBComboBox77: TwwDBComboBox; wwDBDateTimePicker28: TwwDBDateTimePicker; wwDBComboBox78: TwwDBComboBox; wwDBComboBox79: TwwDBComboBox; RxDBLookupCombo23: TRxDBLookupCombo; wwDBComboBox80: TwwDBComboBox; RxDBLookupCombo24: TRxDBLookupCombo; RxDBLookupCombo25: TRxDBLookupCombo; wwDBComboBox81: TwwDBComboBox; wwDBComboBox82: TwwDBComboBox; RxDBLookupCombo26: TRxDBLookupCombo; Edit31: TEdit; wwDBComboBox83: TwwDBComboBox; RxDBLookupCombo27: TRxDBLookupCombo; Label88: TLabel; Label89: TLabel; wwDBComboBox84: TwwDBComboBox; wwDBDateTimePicker29: TwwDBDateTimePicker; wwDBComboBox85: TwwDBComboBox; wwDBDateTimePicker30: TwwDBDateTimePicker; procedure FormShow(Sender: TObject); procedure bsSkinButton10Click(Sender: TObject); procedure bsSkinButton5Click(Sender: TObject); procedure bsSkinButton1Click(Sender: TObject); procedure wwDBComboBox15KeyPress(Sender: TObject; var Key: Char); private procedure loadFindIni ; procedure writeFindIni ; { Private declarations } public { Public declarations } end; var frm_ch_balance_query: Tfrm_ch_balance_query; balance_query_type:integer; implementation uses u_ch_balance_accept, u_ch_balance_pay, my_sys_function, u_data_share, u_main, {$IFDEF SFLIUCHENG}u_ch_balance_accept_deng, u_ch_balance_accept_hexiao, u_ch_balance_accept_check,{$ENDIF} u_rp_ch_balance_accept, u_rp_ch_balance_pay, u_rp_ch_balance_detail; {$R *.dfm} procedure Tfrm_ch_balance_query.FormShow(Sender: TObject); begin loadFindIni; wwDBComboBox15.text:='模糊'; wwDBComboBox17.text:='等于'; wwDBComboBox2.text:='等于'; wwDBComboBox18.text:='大于'; wwDBComboBox70.text:='大于'; wwDBComboBox19.text:='大于'; wwDBComboBox5.text:='等于'; wwDBComboBox21.text:='等于'; wwDBComboBox4.text:='模糊'; wwDBComboBox3.text:='等于'; wwDBComboBox6.text:='小于'; wwDBComboBox69.text:='小于'; wwDBComboBox11.text:='小于'; wwDBComboBox14.text:='等于'; wwDBComboBox7.text:='模糊'; wwDBComboBox16.text:='模糊'; wwDBComboBox10.text:='大于'; wwDBComboBox20.text:='大于'; wwDBComboBox24.text:='等于'; wwDBComboBox25.text:='等于'; wwDBComboBox8.text:='模糊'; wwDBComboBox9.text:='模糊'; wwDBComboBox12.text:='小于'; wwDBComboBox13.text:='小于'; wwDBComboBox22.text:='等于'; wwDBComboBox23.text:='等于'; wwDBComboBox66.text:='模糊'; wwDBComboBox67.text:='模糊'; wwDBComboBox26.text:='模糊'; wwDBComboBox28.text:='模糊'; wwDBComboBox30.text:='大于'; wwDBComboBox32.text:='大于'; wwDBComboBox35.text:='等于'; wwDBComboBox36.text:='等于'; wwDBComboBox27.text:='模糊'; wwDBComboBox29.text:='模糊'; wwDBComboBox31.text:='小于'; wwDBComboBox33.text:='小于'; wwDBComboBox34.text:='等于'; wwDBComboBox37.text:='等于'; wwDBComboBox38.text:='模糊'; wwDBComboBox39.text:='模糊'; wwDBComboBox40.text:='模糊'; wwDBComboBox41.text:='模糊'; wwDBComboBox42.text:='大于'; wwDBComboBox43.text:='小于'; wwDBComboBox44.text:='小于'; wwDBComboBox45.text:='大于'; wwDBComboBox46.text:='等于'; wwDBComboBox47.text:='等于'; wwDBComboBox48.text:='等于'; wwDBComboBox49.text:='等于'; wwDBComboBox50.text:='模糊'; wwDBComboBox51.text:='模糊'; wwDBComboBox52.text:='模糊'; wwDBComboBox53.text:='模糊'; wwDBComboBox54.text:='大于'; wwDBComboBox55.text:='小于'; wwDBComboBox56.text:='小于'; wwDBComboBox57.text:='大于'; wwDBComboBox58.text:='等于'; wwDBComboBox59.text:='等于'; wwDBComboBox60.text:='等于'; wwDBComboBox61.text:='等于'; wwDBComboBox62.text:='模糊'; wwDBComboBox63.text:='等于'; wwDBComboBox64.text:='等于'; wwDBComboBox65.text:='等于'; wwDBComboBox68.text:='等于'; wwDBComboBox71.text:='模糊'; wwDBComboBox72.text:='模糊'; wwDBComboBox73.text:='模糊'; wwDBComboBox74.text:='模糊'; wwDBComboBox75.text:='大于'; wwDBComboBox76.text:='小于'; wwDBComboBox77.text:='小于'; wwDBComboBox78.text:='大于'; wwDBComboBox79.text:='等于'; wwDBComboBox80.text:='等于'; wwDBComboBox81.text:='等于'; wwDBComboBox82.text:='等于'; wwDBComboBox83.text:='等于'; wwDBComboBox84.text:='大于'; wwDBComboBox85.text:='小于'; frm_data_share.t_crm_client_all.requery; frm_data_share.t_code_currency.requery; frm_data_share.t_sys_bank.requery; frm_data_share.t_sys_employee.requery; end; procedure Tfrm_ch_balance_query.bsSkinButton10Click(Sender: TObject); begin Edit2.text:=''; wwDBComboBox1.text:=''; Edit1.text:=''; wwDBDateTimePicker1.Clear; wwDBDateTimePicker24.Clear; wwDBDateTimePicker23.Clear; wwDBDateTimePicker3.Clear; RxDBLookupCombo4.ClearValue; Edit4.text:=''; RxDBLookupCombo2.ClearValue; RxDBLookupCombo1.ClearValue; wwDBDateTimePicker2.Clear; wwDBDateTimePicker4.Clear; RxDBLookupCombo3.ClearValue; Edit22.text:=''; Edit21.text:=''; Edit3.text:=''; Edit5.text:=''; Edit6.text:=''; Edit7.text:=''; Edit8.text:=''; Edit9.text:=''; Edit10.text:=''; Edit11.text:=''; Edit12.text:=''; Edit13.text:=''; Edit14.text:=''; Edit15.text:=''; Edit16.text:=''; Edit17.text:=''; Edit18.text:=''; Edit19.text:=''; wwDBDateTimePicker5.Clear; wwDBDateTimePicker6.Clear; wwDBDateTimePicker7.Clear; wwDBDateTimePicker8.Clear; wwDBDateTimePicker9.Clear; wwDBDateTimePicker10.Clear; wwDBDateTimePicker11.Clear; wwDBDateTimePicker12.Clear; wwDBDateTimePicker13.Clear; wwDBDateTimePicker14.Clear; wwDBDateTimePicker15.Clear; wwDBDateTimePicker16.Clear; wwDBDateTimePicker17.Clear; wwDBDateTimePicker18.Clear; wwDBDateTimePicker19.Clear; wwDBDateTimePicker20.Clear; RxDBLookupCombo5.ClearValue; RxDBLookupCombo6.ClearValue; RxDBLookupCombo7.ClearValue; RxDBLookupCombo8.ClearValue; RxDBLookupCombo9.ClearValue; RxDBLookupCombo10.ClearValue; RxDBLookupCombo11.ClearValue; RxDBLookupCombo12.ClearValue; RxDBLookupCombo13.ClearValue; RxDBLookupCombo14.ClearValue; RxDBLookupCombo15.ClearValue; RxDBLookupCombo16.ClearValue; RxDBLookupCombo17.ClearValue; RxDBLookupCombo18.ClearValue; RxDBLookupCombo19.ClearValue; RxDBLookupCombo20.ClearValue; Edit20.text:=''; RxDBLookupCombo21.ClearValue; wwDBDateTimePicker21.text:=''; wwDBDateTimePicker22.text:=''; Edit27.text:=''; Edit28.text:=''; Edit29.text:=''; Edit30.text:=''; Edit31.text:=''; RxDBLookupCombo21.ClearValue; wwDBDateTimePicker25.text:=''; wwDBDateTimePicker26.text:=''; wwDBDateTimePicker27.text:=''; wwDBDateTimePicker28.text:=''; RxDBLookupCombo23.ClearValue; RxDBLookupCombo24.ClearValue; RxDBLookupCombo25.ClearValue; RxDBLookupCombo26.ClearValue; RxDBLookupCombo27.ClearValue; end; procedure Tfrm_ch_balance_query.bsSkinButton5Click(Sender: TObject); begin close; end; procedure Tfrm_ch_balance_query.bsSkinButton1Click(Sender: TObject); var shen_string,op_string,aa_str,bb_str:widestring; begin writeFindIni; shen_string:=''; op_string:=''; case balance_query_type of 1: begin shen_string:='where 类型='+''''+'收'+''''+' and 结算类别='+''''+'流程'+''''; end; 2: begin shen_string:='where 类型='+''''+'收'+''''+' and 结算类别='+''''+'流程'+''''+' and 核销人='+''''+employee+''''; end; 3,6: begin shen_string:='where 类型='+''''+'收'+''''; end; 4,7: begin shen_string:='where 类型='+''''+'付'+''''; end; 5: begin shen_string:='where 类型='+''''+'收'+''''+' and 结算类别='+''''+'流程'+''''; end; 8: begin shen_string:='where 1=1 '; end; end; aa_str:=query_tiaojian(1,aa_str,'申请编号',wwDBComboBox62.text,Edit20.text); aa_str:=query_tiaojian(1,aa_str,'申请人',wwDBComboBox63.text,RxDBLookupCombo21.DisplayValues[0]); aa_str:=query_tiaojian(1,aa_str,'申请日期',wwDBComboBox64.text,wwDBDateTimePicker21.text); aa_str:=query_tiaojian(1,aa_str,'申请日期',wwDBComboBox65.text,wwDBDateTimePicker22.text); shen_string:=query_tiaojian(1,shen_string,'相关号码',wwDBComboBox67.text,Edit22.text); shen_string:=query_tiaojian(1,shen_string,'帐单状态',wwDBComboBox17.text,wwDBComboBox1.text); shen_string:=query_tiaojian(2,shen_string,'结算金额',wwDBComboBox2.text,Edit1.text); shen_string:=query_tiaojian(1,shen_string,'结算日期',wwDBComboBox18.text,wwDBDateTimePicker1.text); shen_string:=query_tiaojian(1,shen_string,'核销日期',wwDBComboBox70.text,wwDBDateTimePicker24.text); shen_string:=query_tiaojian(1,shen_string,'审核日期',wwDBComboBox19.text,wwDBDateTimePicker3.text); shen_string:=query_tiaojian(1,shen_string,'结算人',wwDBComboBox5.text,RxDBLookupCombo4.DisplayValues[0]); shen_string:=query_tiaojian(1,shen_string,'凭证号码',wwDBComboBox4.text,Edit4.text); shen_string:=query_tiaojian(1,shen_string,'客户名称',wwDBComboBox21.text,RxDBLookupCombo2.DisplayValues[1]); shen_string:=query_tiaojian(1,shen_string,'币别',wwDBComboBox3.text,RxDBLookupCombo1.DisplayValues[0]); shen_string:=query_tiaojian(1,shen_string,'结算日期',wwDBComboBox6.text,wwDBDateTimePicker2.text); shen_string:=query_tiaojian(1,shen_string,'核销日期',wwDBComboBox69.text,wwDBDateTimePicker23.text); shen_string:=query_tiaojian(1,shen_string,'审核日期',wwDBComboBox11.text,wwDBDateTimePicker4.text); shen_string:=query_tiaojian(1,shen_string,'审核人',wwDBComboBox14.text,RxDBLookupCombo3.DisplayValues[0]); if shen_string='' then shen_string:='where '+open_data('1003','核销人','结算人','no','no','no') else shen_string:=shen_string+' and '+open_data('1003','核销人','结算人','no','no','no'); if (Edit2.text<>'')and(Edit21.text<>'') then begin if shen_string='' then shen_string:='where 帐单编号 between '+''''+Edit2.text+''''+' and '+''''+Edit21.text+'''' else shen_string:=shen_string+' and 帐单编号 between '+''''+Edit2.text+''''+' and '+''''+Edit21.text+''''; end else begin shen_string:=query_tiaojian(1,shen_string,'帐单编号',wwDBComboBox15.text,Edit2.text); shen_string:=query_tiaojian(1,shen_string,'帐单编号',wwDBComboBox66.text,Edit21.text); end; if bsSkinTabSheet1.Showing then begin op_string:=query_tiaojian(1,op_string,'业务编号',wwDBComboBox7.text,Edit3.text); op_string:=query_tiaojian(1,op_string,'主提单号',wwDBComboBox16.text,Edit6.text); op_string:=query_tiaojian(1,op_string,'开船日期',wwDBComboBox10.text,wwDBDateTimePicker5.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox20.text,wwDBDateTimePicker8.text); op_string:=query_tiaojian(1,op_string,'客服员',wwDBComboBox24.text,RxDBLookupCombo5.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'操作员',wwDBComboBox25.text,RxDBLookupCombo8.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'委托编号',wwDBComboBox8.text,Edit5.text); op_string:=query_tiaojian(1,op_string,'分提单号',wwDBComboBox9.text,Edit7.text); op_string:=query_tiaojian(1,op_string,'开船日期',wwDBComboBox12.text,wwDBDateTimePicker6.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox13.text,wwDBDateTimePicker7.text); op_string:=query_tiaojian(1,op_string,'揽货人',wwDBComboBox22.text,RxDBLookupCombo6.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'录入人',wwDBComboBox23.text,RxDBLookupCombo7.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'分部名称',wwDBComboBox68.text,RxDBLookupCombo22.DisplayValue); if Edit23.Text<>'' then begin if trim(op_string)<>'' then begin op_string:=op_string+' and (t_op_seae.订舱单号 like '+''''+'%'+Edit16.text+'%'+''' or t_op_seae.主提单号 like '+''''+'%'+Edit23.text+'%'+''' or t_op_seae.分提单号 like '+''''+'%'+Edit23.text+'%'+''' or t_op_seae.委托编号 like '+''''+'%'+Edit23.text+'%'+''')'; end else begin op_string:=' where (t_op_seae.订舱单号 like '+''''+'%'+Edit16.text+'%'+''' or t_op_seae.主提单号 like '+''''+'%'+Edit23.text+'%'+''' or t_op_seae.分提单号 like '+''''+'%'+Edit23.text+'%'+''' or t_op_seae.委托编号 like '+''''+'%'+Edit23.text+'%'+''')'; end; end; if trim(op_string)<>''then begin op_string:='(select 编号 from t_op_seae '+op_string+')'; end; end; if bsSkinTabSheet2.Showing then begin op_string:=query_tiaojian(1,op_string,'业务编号',wwDBComboBox26.text,Edit8.text); op_string:=query_tiaojian(1,op_string,'主提单号',wwDBComboBox28.text,Edit10.text); op_string:=query_tiaojian(1,op_string,'进口日期',wwDBComboBox30.text,wwDBDateTimePicker9.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox32.text,wwDBDateTimePicker11.text); op_string:=query_tiaojian(1,op_string,'客服员',wwDBComboBox35.text,RxDBLookupCombo10.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'操作员',wwDBComboBox36.text,RxDBLookupCombo11.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'委托编号',wwDBComboBox27.text,Edit9.text); op_string:=query_tiaojian(1,op_string,'分提单号',wwDBComboBox29.text,Edit11.text); op_string:=query_tiaojian(1,op_string,'进口日期',wwDBComboBox31.text,wwDBDateTimePicker10.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox33.text,wwDBDateTimePicker12.text); op_string:=query_tiaojian(1,op_string,'揽货人',wwDBComboBox34.text,RxDBLookupCombo9.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'录入人',wwDBComboBox37.text,RxDBLookupCombo12.DisplayValues[0]); if Edit24.Text<>'' then begin if trim(op_string)<>'' then begin op_string:=op_string+' and (t_op_seai.主提单号 like '+''''+'%'+Edit24.text+'%'+''' or t_op_seai.分提单号 like '+''''+'%'+Edit24.text+'%'+''' or t_op_seai.委托编号 like '+''''+'%'+Edit24.text+'%'+''')'; end else begin op_string:=' where (t_op_seai.主提单号 like '+''''+'%'+Edit24.text+'%'+''' or t_op_seai.分提单号 like '+''''+'%'+Edit24.text+'%'+''' or t_op_seai.委托编号 like '+''''+'%'+Edit24.text+'%'+''')'; end; end; if trim(op_string)<>''then op_string:='(select 编号 from t_op_seai '+op_string+')'; end; if bsSkinTabSheet3.Showing then begin op_string:=query_tiaojian(1,op_string,'业务编号',wwDBComboBox38.text,Edit12.text); op_string:=query_tiaojian(1,op_string,'主运单号',wwDBComboBox41.text,Edit15.text); op_string:=query_tiaojian(1,op_string,'委托编号',wwDBComboBox39.text,Edit13.text); op_string:=query_tiaojian(1,op_string,'分运单号',wwDBComboBox40.text,Edit14.text); op_string:=query_tiaojian(1,op_string,'一程开航日期',wwDBComboBox42.text,wwDBDateTimePicker13.text); op_string:=query_tiaojian(1,op_string,'一程开航日期',wwDBComboBox43.text,wwDBDateTimePicker14.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox45.text,wwDBDateTimePicker16.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox44.text,wwDBDateTimePicker15.text); op_string:=query_tiaojian(1,op_string,'客服员',wwDBComboBox46.text,RxDBLookupCombo13.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'操作员',wwDBComboBox49.text,RxDBLookupCombo16.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'揽货人',wwDBComboBox47.text,RxDBLookupCombo14.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'录入人',wwDBComboBox48.text,RxDBLookupCombo15.DisplayValues[0]); if Edit25.Text<>'' then begin if trim(op_string)<>'' then begin op_string:=op_string+' and (t_op_aire.主运单号 like '+''''+'%'+Edit25.text+'%'+''' or t_op_aire.分运单号 like '+''''+'%'+Edit25.text+'%'+''' or t_op_aire.委托编号 like '+''''+'%'+Edit25.text+'%'+''')'; end else begin op_string:=' where (t_op_aire.主运单号 like '+''''+'%'+Edit25.text+'%'+''' or t_op_aire.分运单号 like '+''''+'%'+Edit25.text+'%'+''' or t_op_aire.委托编号 like '+''''+'%'+Edit25.text+'%'+''')'; end; end; if trim(op_string)<>''then op_string:='(select 编号 from t_op_aire '+op_string+')'; end; if bsSkinTabSheet4.Showing then begin op_string:=query_tiaojian(1,op_string,'业务编号',wwDBComboBox50.text,Edit16.text); op_string:=query_tiaojian(1,op_string,'主运单号',wwDBComboBox53.text,Edit19.text); op_string:=query_tiaojian(1,op_string,'委托编号',wwDBComboBox51.text,Edit17.text); op_string:=query_tiaojian(1,op_string,'分运单号',wwDBComboBox52.text,Edit18.text); op_string:=query_tiaojian(1,op_string,'进口日期',wwDBComboBox54.text,wwDBDateTimePicker17.text); op_string:=query_tiaojian(1,op_string,'进口日期',wwDBComboBox55.text,wwDBDateTimePicker18.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox57.text,wwDBDateTimePicker20.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox56.text,wwDBDateTimePicker19.text); op_string:=query_tiaojian(1,op_string,'客服员',wwDBComboBox58.text,RxDBLookupCombo17.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'操作员',wwDBComboBox61.text,RxDBLookupCombo20.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'揽货人',wwDBComboBox59.text,RxDBLookupCombo18.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'录入人',wwDBComboBox60.text,RxDBLookupCombo19.DisplayValues[0]); if Edit26.Text<>'' then begin if trim(op_string)<>'' then begin op_string:=op_string+' and (t_op_airi.主运单号 like '+''''+'%'+Edit26.text+'%'+''' or t_op_airi.分运单号 like '+''''+'%'+Edit26.text+'%'+''' or t_op_airi.委托编号 like '+''''+'%'+Edit26.text+'%'+''')'; end else begin op_string:=' where (t_op_airi.主运单号 like '+''''+'%'+Edit26.text+'%'+''' or t_op_airi.分运单号 like '+''''+'%'+Edit26.text+'%'+''' or t_op_airi.委托编号 like '+''''+'%'+Edit26.text+'%'+''')'; end; end; if trim(op_string)<>''then op_string:='(select 编号 from t_op_airi '+op_string+')'; end; if bsSkinTabSheet5.Showing then begin op_string:=query_tiaojian(1,op_string,'业务编号',wwDBComboBox71.text,Edit27.text); op_string:=query_tiaojian(1,op_string,'委托编号',wwDBComboBox72.text,Edit28.text); op_string:=query_tiaojian(1,op_string,'主提单号',wwDBComboBox73.text,Edit29.text); op_string:=query_tiaojian(1,op_string,'分提单号',wwDBComboBox74.text,Edit30.text); op_string:=query_tiaojian(1,op_string,'开船日期',wwDBComboBox75.text,wwDBDateTimePicker25.text); op_string:=query_tiaojian(1,op_string,'开船日期',wwDBComboBox76.text,wwDBDateTimePicker26.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox78.text,wwDBDateTimePicker28.text); op_string:=query_tiaojian(1,op_string,'会计期间',wwDBComboBox77.text,wwDBDateTimePicker27.text); op_string:=query_tiaojian(1,op_string,'客服员',wwDBComboBox79.text,RxDBLookupCombo23.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'揽货人',wwDBComboBox80.text,RxDBLookupCombo24.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'操作员',wwDBComboBox82.text,RxDBLookupCombo26.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'录入人',wwDBComboBox81.text,RxDBLookupCombo25.DisplayValues[0]); op_string:=query_tiaojian(1,op_string,'分部名称',wwDBComboBox83.text,RxDBLookupCombo27.DisplayValue); op_string:=query_tiaojian(1,op_string,'费用封帐日期',wwDBComboBox84.text,wwDBDateTimePicker29.text); op_string:=query_tiaojian(1,op_string,'费用封帐日期',wwDBComboBox85.text,wwDBDateTimePicker30.text); if Edit31.Text<>'' then begin if trim(op_string)<>'' then begin op_string:=op_string+' and (V_op_bscard_All.订舱单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.主提单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.分提单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.委托编号 like '+''''+'%'+Edit31.text+'%'+''')'; end else begin op_string:=' where (V_op_bscard_All.订舱单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.主提单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.分提单号 like '+''''+'%'+Edit31.text+'%'+''' or V_op_bscard_All.委托编号 like '+''''+'%'+Edit31.text+'%'+''')'; end; end; if trim(op_string)<>''then begin op_string:='(select 编号 from V_op_bscard_All '+op_string+')'; end; end; if (balance_query_type=6)or(balance_query_type=7) then begin if trim(op_string)<>''then begin if trim(shen_string)='' then shen_string:='where 帐单编号 in (select 工作编号 from t_ch_fee_do where 类型='+''''+inttostr(balance_query_type-3)+'''' +' and 业务编号 in '+op_string+')' else shen_string:=shen_string+' and 帐单编号 in (select 工作编号 from t_ch_fee_do where 类型='+''''+inttostr(balance_query_type-3)+'''' +' and 业务编号 in '+op_string+')' ; end; end else if (balance_query_type<>8) then begin if trim(op_string)<>''then begin if trim(shen_string)='' then shen_string:='where 帐单编号 in (select 工作编号 from t_ch_fee_do where 类型='+''''+inttostr(balance_query_type)+'''' +' and 业务编号 in '+op_string+')' else shen_string:=shen_string+' and 帐单编号 in (select 工作编号 from t_ch_fee_do where 类型='+''''+inttostr(balance_query_type)+'''' +' and 业务编号 in '+op_string+')' ; end; end; { if (balance_query_type=8) then begin if trim(op_string)<>''then begin if trim(shen_string)='' then shen_string:='where 帐单编号 in (select 工作编号 from t_ch_fee_do where 业务编号 in '+op_string+')' else shen_string:=shen_string+' and 帐单编号 in (select 工作编号 from t_ch_fee_do where 业务编号 in '+op_string+')' ; end; end; } if aa_str<>''then begin if trim(shen_string)='' then shen_string:='where 帐单编号 in (select 帐单编号 from t_ch_check '+aa_str+')' else shen_string:=shen_string+' and 帐单编号 in (select 帐单编号 from t_ch_check '+aa_str+')'; end; case balance_query_type of {$IFDEF SFLIUCHENG} 1: begin frm_ch_balance_accept_deng.t_ch_balance.Close; frm_ch_balance_accept_deng.t_ch_balance.sql.clear; frm_ch_balance_accept_deng.t_ch_balance.sql.add('select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'); frm_ch_balance_accept_deng.t_ch_balance.open; if frm_ch_balance_accept_deng.t_ch_balance.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; 2: begin frm_ch_balance_accept_hexiao.t_ch_balance.Close; frm_ch_balance_accept_hexiao.t_ch_balance.sql.clear; frm_ch_balance_accept_hexiao.t_ch_balance.sql.add('select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'); frm_ch_balance_accept_hexiao.t_ch_balance.open; if frm_ch_balance_accept_hexiao.t_ch_balance.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; {$ENDIF} 3: begin frm_ch_balance_accept.t_ch_balance.Close; frm_ch_balance_accept.t_ch_balance.sql.clear; frm_ch_balance_accept.t_ch_balance.sql.add('select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'); frm_ch_balance_accept.t_ch_balance.open; if frm_ch_balance_accept.t_ch_balance.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; 4: begin frm_ch_balance_pay.t_ch_balance.Close; frm_ch_balance_pay.t_ch_balance.sql.clear; frm_ch_balance_pay.t_ch_balance.sql.add('select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'); frm_ch_balance_pay.t_ch_balance.open; if frm_ch_balance_pay.t_ch_balance.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; {$IFDEF SFLIUCHENG} 5: begin frm_ch_balance_accept_check.t_ch_balance.Close; frm_ch_balance_accept_check.t_ch_balance.sql.clear; frm_ch_balance_accept_check.t_ch_balance.sql.add('select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'); frm_ch_balance_accept_check.t_ch_balance.open; if frm_ch_balance_accept_check.t_ch_balance.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; {$ENDIF} 6: begin frm_rp_ch_balance_accept.p_detail.Close; frm_rp_ch_balance_accept.p_detail.Parameters.ParamByName('SQLStr').value:= 'select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'; frm_rp_ch_balance_accept.p_detail.open; frm_rp_ch_balance_accept.p_detail_fee.Close; frm_rp_ch_balance_accept.p_detail_fee.Parameters.ParamByName('SQLStr').value:= 'select * from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') order by 编号 desc'; frm_rp_ch_balance_accept.p_detail_fee.open; frm_rp_ch_balance_accept.p_detail_bill.Close; frm_rp_ch_balance_accept.p_detail_bill.Parameters.ParamByName('SQLStr').value:= 'select 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期,'+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号 as 帐单编号,结算日期,核销日期,结算人,结算方式,相关号码,银行,财务凭证,合计未收,毛利润,利润率,合计未收,'+ ' SUM(case 原始币别 when ''USD'' then 原始金额 else 0 end) as 美元金额,SUM(case 原始币别 when ''USD'' then 0 else 原始金额 end) as 人民币金额 '+ 'from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') '+ 'Group by 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期, '+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号,结算日期,核销日期,结算人,结算方式,相关号码,银行,财务凭证,合计未收,毛利润,利润率,合计未收 '+ 'order by 编号 desc'; frm_rp_ch_balance_accept.p_detail_bill.open; frm_rp_ch_balance_accept.p_sales.Close; frm_rp_ch_balance_accept.p_sales.Parameters.ParamByName('SQLStr').value:= 'select 揽货人,币别,sum(金额) as 金额 from v_fee_do_sales where 帐单编号 in (' +'select 帐单编号 from t_ch_balance '+shen_string+') group by 揽货人,币别 order by 揽货人,币别'; frm_rp_ch_balance_accept.p_sales.open; if StrToBool(get_parameters_value(83,'false')) then begin frm_rp_ch_balance_accept.p_currency.Close; frm_rp_ch_balance_accept.p_currency.Parameters.ParamByName('SQLStr').value:= 'select sum(美元金额) as 美元金额,sum(人民币金额) as 人民币金额' +',count(帐单编号) as 笔数 from t_ch_balance '+shen_string; frm_rp_ch_balance_accept.p_currency.open; end else begin frm_rp_ch_balance_accept.p_currency.Close; frm_rp_ch_balance_accept.p_currency.Parameters.ParamByName('SQLStr').value:= 'select 币别,sum(结算金额) as 结算金额,sum(实结金额) as 实结金额,sum(虚结金额) as 虚结金额' +',count(帐单编号) as 笔数 from t_ch_balance '+shen_string+' group by 币别 order by 币别'; frm_rp_ch_balance_accept.p_currency.open; end; frm_rp_ch_balance_accept_str:=shen_string; frm_rp_ch_balance_accept.RadioGroup1Click(Sender); if frm_rp_ch_balance_accept.p_detail.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; 7: begin frm_rp_ch_balance_pay.p_detail.Close; frm_rp_ch_balance_pay.p_detail.Parameters.ParamByName('SQLStr').value:= 'select * from t_ch_balance '+shen_string+' order by 帐单编号 desc'; frm_rp_ch_balance_pay.p_detail.open; frm_rp_ch_balance_pay.p_detail_fee.Close; frm_rp_ch_balance_pay.p_detail_fee.Parameters.ParamByName('SQLStr').value:= 'select * from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') order by 编号 desc'; frm_rp_ch_balance_pay.p_detail_fee.open; frm_rp_ch_balance_pay.p_detail_bill.Close; frm_rp_ch_balance_pay.p_detail_bill.Parameters.ParamByName('SQLStr').value:= 'select 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期,'+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号 as 帐单编号,结算日期,结算人,结算方式,相关号码,银行,财务凭证,'+ ' SUM(case 原始币别 when ''USD'' then 原始金额 else 0 end) as 美元金额,SUM(case 原始币别 when ''USD'' then 0 else 原始金额 end) as 人民币金额 '+ 'from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') '+ 'Group by 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期, '+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号,结算日期,结算人,结算方式,相关号码,银行,财务凭证 '+ 'order by 编号 desc'; frm_rp_ch_balance_pay.p_detail_bill.open; frm_rp_ch_balance_pay.p_sales.Close; frm_rp_ch_balance_pay.p_sales.Parameters.ParamByName('SQLStr').value:= 'select 揽货人,币别,sum(金额) as 金额 from v_fee_do_sales where 帐单编号 in (' +'select 帐单编号 from t_ch_balance '+shen_string+') group by 揽货人,币别 order by 揽货人,币别'; frm_rp_ch_balance_pay.p_sales.open; if StrToBool(get_parameters_value(83,'false')) then begin frm_rp_ch_balance_pay.p_currency.Close; frm_rp_ch_balance_pay.p_currency.Parameters.ParamByName('SQLStr').value:= 'select sum(美元金额) as 美元金额,sum(人民币金额) as 人民币金额' +',count(帐单编号) as 笔数 from t_ch_balance '+shen_string; frm_rp_ch_balance_pay.p_currency.open; end else begin frm_rp_ch_balance_pay.p_currency.Close; frm_rp_ch_balance_pay.p_currency.Parameters.ParamByName('SQLStr').value:= 'select 币别,sum(结算金额) as 结算金额,sum(实结金额) as 实结金额,sum(虚结金额) as 虚结金额' +',count(帐单编号) as 笔数 from t_ch_balance '+shen_string+' group by 币别 order by 币别'; frm_rp_ch_balance_pay.p_currency.open; end; frm_rp_ch_balance_pay_str:=shen_string; frm_rp_ch_balance_pay.RadioGroup1Click(Sender); if frm_rp_ch_balance_pay.p_detail.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; 8: begin if op_string<>'' then bb_str:=' and 编号 in '+op_string else bb_str:=' and 1=1 '; frm_rp_ch_balance_detail.p_detail_fee.Close; frm_rp_ch_balance_detail.p_detail_fee.Parameters.ParamByName('SQLStr').value:= 'select * from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') '+bb_str+' order by 编号 desc'; frm_rp_ch_balance_detail.p_detail_fee.open; frm_rp_ch_balance_detail.p_detail_bill.Close; frm_rp_ch_balance_detail.p_detail_bill.Parameters.ParamByName('SQLStr').value:= 'select 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期,'+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号 as 帐单编号,结算日期,结算人,结算方式,结算类别,相关号码,银行,财务凭证,'+ ' SUM(case 原始币别 when ''USD'' then 原始金额 else 0 end) as 美元金额,SUM(case 原始币别 when ''USD'' then 0 else 原始金额 end) as 人民币金额 '+ 'from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') '+bb_str+ 'Group by 编号,业务状态,费用状态,客户名称,业务编号,会计期间,主提单号,分提单号,委托编号,装运方式,委托单位,'+ '船名,航次,开船日期,装货港,卸货港,件数,重量,尺码,集装箱,录入人, 录入日期, '+ '操作员,揽货人,客服员,航线,船公司,货代公司,报关行,工作编号,结算日期,结算人,结算方式,结算类别,相关号码,银行,财务凭证 '+ 'order by 编号 desc'; frm_rp_ch_balance_detail.p_detail_bill.open; frm_rp_ch_balance_detail.p_detail.Close; frm_rp_ch_balance_detail.p_detail.Parameters.ParamByName('SQLStr').value:= 'select 客户名称,'+ ' SUM(case 类型 when ''收'' then (case 原始币别 when ''USD'' then 原始金额 else 0 end) else 0 end) as 已收美元金额,'+ ' SUM(case 类型 when ''收'' then (case 原始币别 when ''USD'' then 0 else 原始金额 end) else 0 end) as 已收人民币金额, '+ ' SUM(case 类型 when ''付'' then (case 原始币别 when ''USD'' then 原始金额 else 0 end) else 0 end) as 已付美元金额,'+ ' SUM(case 类型 when ''付'' then (case 原始币别 when ''USD'' then 0 else 原始金额 end) else 0 end) as 已付人民币金额 '+ 'from v_fee_do_bscard_detail where 工作编号 in (select 帐单编号 from t_ch_balance '+shen_string+') '+bb_str+ 'Group by 客户名称 '+ 'order by 客户名称 '; frm_rp_ch_balance_detail.p_detail.open; if frm_rp_ch_balance_detail.p_detail_fee.IsEmpty then begin showmessage('没有检索出所需帐单！！'); exit; end; end; end; close; end; procedure Tfrm_ch_balance_query.wwDBComboBox15KeyPress(Sender: TObject; var Key: Char); begin if key=#13 then begin key:=#0; frm_ch_balance_query.bsSkinButton1Click(Sender); end; end; procedure Tfrm_ch_balance_query.loadFindIni; var findini:tinifile ; mysec,tmpname:string; canload:boolean ; //是否记忆 i:integer ; begin mysec:=inttostr(balance_query_type) ; findini:=Tinifile.Create(ExtractFilePath(application.ExeName)+'chbalancequery.ini'); try canload:=findini.ReadBool(mysec,mysec,false); bsSkinCheckRadioBox1.Checked:=canload ; if canload then begin with bsSkinGroupBox1 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then (Controls[i] as TwwDBComboBox).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TEdit then (Controls[i] as TEdit).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TwwDBDateTimePicker then (Controls[i] as TwwDBDateTimePicker).Date:=strtodate(findini.ReadString(mysec,TmpName,'')) else if Controls[i] is TRxDBLookupCombo then (Controls[i] as TRxDBLookupCombo).Value:=findini.ReadString(mysec,TmpName,'') ; end ; with bsSkinGroupBox2 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then (Controls[i] as TwwDBComboBox).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TEdit then (Controls[i] as TEdit).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TwwDBDateTimePicker then (Controls[i] as TwwDBDateTimePicker).Date:=strtodate(findini.ReadString(mysec,TmpName,'')) else if Controls[i] is TRxDBLookupCombo then (Controls[i] as TRxDBLookupCombo).Value:=findini.ReadString(mysec,TmpName,'') ; end ; with bsSkinPageControl1 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then (Controls[i] as TwwDBComboBox).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TEdit then (Controls[i] as TEdit).Text:=findini.ReadString(mysec,TmpName,'') else if Controls[i] is TwwDBDateTimePicker then (Controls[i] as TwwDBDateTimePicker).Date:=strtodate(findini.ReadString(mysec,TmpName,'')) else if Controls[i] is TRxDBLookupCombo then (Controls[i] as TRxDBLookupCombo).Value:=findini.ReadString(mysec,TmpName,'') ; end ; end else begin end ; finally findini.free; end ; end; procedure Tfrm_ch_balance_query.writeFindIni; var findini:tinifile ; mysec,tmpname:string; canload:boolean ; //是否记忆 i:integer ; begin canload:=bsSkinCheckRadioBox1.Checked ; mysec:=inttostr(balance_query_type) ; findini:=Tinifile.Create(ExtractFilePath(application.ExeName)+'chbalancequery.ini'); try findini.WriteBool(mysec,mysec,canload); if canload then begin with bsSkinGroupBox1 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then findini.WriteString(mysec,TmpName,(Controls[i] as TwwDBComboBox).Text) else if Controls[i] is TEdit then findini.WriteString(mysec,TmpName,(Controls[i] as TEdit).Text) else if Controls[i] is TwwDBDateTimePicker then findini.WriteString(mysec,TmpName,datetostr((Controls[i] as TwwDBDateTimePicker).Date)) else if Controls[i] is TRxDBLookupCombo then findini.writeString(mysec,TmpName,(Controls[i] as TRxDBLookupCombo).Value) ; end ; with bsSkinGroupBox2 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then findini.WriteString(mysec,TmpName,(Controls[i] as TwwDBComboBox).Text) else if Controls[i] is TEdit then findini.WriteString(mysec,TmpName,(Controls[i] as TEdit).Text) else if Controls[i] is TwwDBDateTimePicker then findini.WriteString(mysec,TmpName,datetostr((Controls[i] as TwwDBDateTimePicker).Date)) else if Controls[i] is TRxDBLookupCombo then findini.writeString(mysec,TmpName,(Controls[i] as TRxDBLookupCombo).Value) ; end ; with bsSkinPageControl1 do for i:=0 to ControlCount-1 do begin tmpname:=Controls[i].Name ; if Controls[i] is TwwDBComboBox then findini.WriteString(mysec,TmpName,(Controls[i] as TwwDBComboBox).Text) else if Controls[i] is TEdit then findini.WriteString(mysec,TmpName,(Controls[i] as TEdit).Text) else if Controls[i] is TwwDBDateTimePicker then findini.WriteString(mysec,TmpName,datetostr((Controls[i] as TwwDBDateTimePicker).Date)) else if Controls[i] is TRxDBLookupCombo then findini.writeString(mysec,TmpName,(Controls[i] as TRxDBLookupCombo).Value) ; end ; end ; finally findini.free; end ; end; end.