unit U_SKGL; interface uses Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Data.DB, Datasnap.DBClient, Vcl.ComCtrls, Vcl.ToolWin, Vcl.StdCtrls, Vcl.ExtCtrls, cxGraphics, cxControls, cxLookAndFeels, cxLookAndFeelPainters, cxStyles, dxSkinsCore, dxSkinsDefaultPainters, cxCustomData, cxFilter, cxData, cxDataStorage, cxEdit, cxNavigator, dxDateRanges, cxDBData, cxCheckBox, cxCalendar, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxGridCustomView, cxGrid, dxBarBuiltInMenu, cxGridCustomPopupMenu, cxGridPopupMenu, Data.Win.ADODB, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations, cxPC; type TfrmSKGL = class(TForm) DS_1: TDataSource; CDS_1: TClientDataSet; ToolBar1: TToolBar; TBRafresh: TToolButton; ToolButton4: TToolButton; ToolButton5: TToolButton; TBClose: TToolButton; Panel1: TPanel; Label3: TLabel; Label4: TLabel; Label6: TLabel; Label10: TLabel; Label11: TLabel; Label2: TLabel; OppCoName: TEdit; begdate: TDateTimePicker; Enddate: TDateTimePicker; F_Name: TEdit; CheckBox1: TCheckBox; P_Code: TEdit; ConNo: TEdit; BuyConNo: TEdit; OppParentCoName: TEdit; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; Tv1Column22: TcxGridDBColumn; v2CRTime: TcxGridDBColumn; Tv1Column23: TcxGridDBColumn; v2Column2: TcxGridDBColumn; v2FactoryName: TcxGridDBColumn; v2OrderNo: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column19: TcxGridDBColumn; Tv1Column24: TcxGridDBColumn; Tv1Column20: TcxGridDBColumn; Tv1Column21: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; Tv1Column14: TcxGridDBColumn; Tv1Column15: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; Tv1Column16: TcxGridDBColumn; Tv1Column26: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; Tv1Column18: TcxGridDBColumn; Tv1Column25: TcxGridDBColumn; Tv1Column1: TcxGridDBColumn; cxGridLevel1: TcxGridLevel; ToolButton1: TToolButton; ADOQueryCmd: TADOQuery; ADOQueryTemp: TADOQuery; ADOQueryMain: TADOQuery; GPM_1: TcxGridPopupMenu; Tv1Column27: TcxGridDBColumn; cxTabControl1: TcxTabControl; procedure TBRafreshClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure OppCoNameKeyPress(Sender: TObject; var Key: Char); procedure ToolButton1Click(Sender: TObject); procedure cxTabControl1Change(Sender: TObject); private procedure InitGrid(); { Private declarations } public { Public declarations } end; var frmSKGL: TfrmSKGL; implementation uses U_DataLink, U_RTFun; {$R *.dfm} procedure TfrmSKGL.cxTabControl1Change(Sender: TObject); begin InitGrid(); end; procedure TfrmSKGL.FormShow(Sender: TObject); begin ReadCxGrid(trim(Self.Caption), Tv1, '应收款'); Enddate.DateTime := SGetServerDate(ADOQueryTemp); begdate.DateTime := Enddate.DateTime - 30; InitGrid(); end; procedure TfrmSKGL.InitGrid(); var WSql: string; begin WSql := SGetFilters(Panel1, 1, 2); if Trim(WSql) <> '' then WSql := ' and ' + WSql else CheckBox1.Checked := True; try ADOQueryMain.DisableControls; with ADOQueryMain do begin Close; SQL.Clear; Filtered := False; sql.Add(' select A.*,convert(varchar(10),A.YJSKTime,120) as YJSKTime1 from Finance_Flow A '); sql.Add(' where A.FFType=''应收款登记'' '); sql.Add(' and isnull(status,''0'')=''9'' '); if CheckBox1.Checked then begin sql.Add(' and A.FFTime>=''' + FormatDateTime('yyyy-MM-dd', begdate.DateTime) + ''' '); sql.Add(' and FFTime<''' + FormatDateTime('yyyy-MM-dd', Enddate.DateTime + 1) + ''' '); end; sql.Add(WSql); case cxTabControl1.TabIndex of 0: begin sql.Add(' and isnull(A.YSKZT,''0'')=''0'''); end; 1: begin sql.Add(' and isnull(A.YSKZT,''0'')=''1'''); end; end; // showmessage(SQL.text); Open; end; SCreateCDS(ADOQueryMain, CDS_1); SInitCDSData(ADOQueryMain, CDS_1); finally ADOQueryMain.EnableControls; TV1.DataController.Filter.Clear; end; end; procedure TfrmSKGL.OppCoNameKeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then begin InitGrid(); end; end; procedure TfrmSKGL.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmSKGL.TBRafreshClick(Sender: TObject); begin begdate.SetFocus; with ADOQueryCmd do begin Close; Sql.Clear; // Sql.Add('exec P_Fin_Generate '); Sql.Add('exec P_Fin_Trade_Generate '); Open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then begin application.MessageBox(pchar(ADOQueryCmd.FieldByName('ShowMsg').AsString), '提示信息'); Exit; end; InitGrid(); end; procedure TfrmSKGL.ToolButton1Click(Sender: TObject); begin // BankName.SetFocus; ModalResult := 1; end; procedure TfrmSKGL.ToolButton4Click(Sender: TObject); begin if ADOQueryMain.IsEmpty then Exit; TcxGridToExcel(self.Caption, cxgrid1); end; procedure TfrmSKGL.ToolButton5Click(Sender: TObject); begin WriteCxGrid(trim(Self.Caption), Tv1, '应收款'); end; end.