unit U_CYDXZ; interface uses Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.ComCtrls, Vcl.ToolWin, Vcl.StdCtrls, Vcl.ExtCtrls, dxSkinsCore, dxSkinsDefaultPainters, dxBarBuiltInMenu, cxGraphics, cxControls, cxLookAndFeels, cxLookAndFeelPainters, cxPC, cxStyles, cxCustomData, cxFilter, cxData, cxDataStorage, cxEdit, cxNavigator, dxDateRanges, Data.DB, cxDBData, cxCheckBox, cxCalendar, cxDropDownEdit, cxButtonEdit, cxTextEdit, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxGridCustomView, cxGrid, Datasnap.DBClient, Data.Win.ADODB, cxGridCustomPopupMenu, cxGridPopupMenu, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations, Vcl.Menus; type TfrmCYDXZ = class(TForm) ToolBar2: TToolBar; ToolButton3: TToolButton; ToolButton1: TToolButton; ToolButton2: TToolButton; ToolButton7: TToolButton; ToolButton8: TToolButton; Panel1: TPanel; Label1: TLabel; Label2: TLabel; Label3: TLabel; Label4: TLabel; Label5: TLabel; Label8: TLabel; Label6: TLabel; Label7: TLabel; BegDate: TDateTimePicker; EndDate: TDateTimePicker; TDNO: TEdit; KHName: TEdit; SHfirmName: TEdit; AccessoriesNO: TEdit; CustomsNO: TEdit; KHNumber: TEdit; cxTabControl1: TcxTabControl; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; cxGrid1Level1: TcxGridLevel; cxGridPopupMenu1: TcxGridPopupMenu; ADOQueryMain: TADOQuery; ADOQueryTemp: TADOQuery; ADOQueryCmd: TADOQuery; DataSource1: TDataSource; CDS_Main: TClientDataSet; ADOQueryTemp1: TADOQuery; Tv1Column1: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; Tv1Column3: 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; Tv1Column16: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; Tv1Column18: TcxGridDBColumn; Tv1Column19: TcxGridDBColumn; Tv1Column20: TcxGridDBColumn; Tv1Column21: TcxGridDBColumn; Tv1Column22: TcxGridDBColumn; Tv1Column23: TcxGridDBColumn; Tv1Column24: TcxGridDBColumn; Tv1Column25: TcxGridDBColumn; Tv1Column26: TcxGridDBColumn; PopupMenu1: TPopupMenu; N1: TMenuItem; N3: TMenuItem; procedure FormShow(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton7Click(Sender: TObject); procedure ToolButton8Click(Sender: TObject); procedure FormCreate(Sender: TObject); procedure cxTabControl1Change(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure N1Click(Sender: TObject); procedure N3Click(Sender: TObject); private procedure InitGrid(); function YSData(): Boolean; { Private declarations } public FFFID: string; { Public declarations } end; var frmCYDXZ: TfrmCYDXZ; implementation uses U_DataLink, U_RTFun; {$R *.dfm} function TfrmCYDXZ.YSData(): Boolean; var MaxId, MaxSubId, FCoCode, FCCID: string; begin try ADOQueryCmd.Connection.BeginTrans; if Trim(FFFID) = '' then begin if not GetLSNo(ADOQueryCmd, MaxId, 'YS', 'Finance_Flow', 4, 1) then raise Exception.Create('取最大号失败!'); end else begin MaxId := Trim(FFFID); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Finance_Flow where FFID=''' + Trim(FFFID) + ''''); Open; end; // with ADOQueryTemp1 do // begin // Close; // SQL.Clear; // sql.Add('select A.*,B.* from BS_Contract_sub A '); // sql.Add('INNER JOIN BS_Contract_main B On A.conmid=B.conmid'); // sql.Add('where B.ConType in (''内销'',''外销'') '); // sql.Add('and A.ConSId =''' + Trim(CDS_Main.fieldbyname('FromConSId').AsString) + ''' '); // Open; // end; with ADOQueryCmd do begin if Trim(FFFID) = '' then begin Append; FieldByName('FillId').Value := Trim(DCode); FieldByName('Filler').Value := Trim(DName); FieldByName('AOTUFlag').Value := '自动生成'; FieldByName('FFFlag').Value := '应收收'; FieldByName('FFType').Value := '应收款登记'; FieldByName('status').Value := '0'; FieldByName('FFQtyFlag').Value := 1; end else begin Edit; FieldByName('EditId').Value := Trim(DCode); FieldByName('Editer').Value := Trim(DName); FieldByName('Edittime').Value := SGetServerDateTime(ADOQueryTemp); end; FieldByName('FFID').Value := Trim(MaxId); FieldByName('FFTime').Value := SGetServerDateTime(ADOQueryTemp); //发生日期 FieldByName('ReconciliationDate').Value := SGetServerDateTime(ADOQueryTemp); //对账日期 FieldByName('FBCIOID').Value := Trim(CDS_Main.fieldbyname('BIOSID').AsString); //关联出运 FieldByName('OurCoName').Value := Trim(CDS_Main.fieldbyname('CKfirmName').AsString); //我方单位 FieldByName('OurCoNo').Value := Trim(CDS_Main.fieldbyname('CKfirmNamecode').AsString); //我方单位 FieldByName('OppCoName').Value := Trim(CDS_Main.fieldbyname('KHName').AsString); //对方单位 FieldByName('OppCoNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //对方单位 FieldByName('OppParentCoName').Value := Trim(CDS_Main.fieldbyname('KHName').AsString); //上级单位 FieldByName('OppParentCoNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //上级单位 FieldByName('Currency').Value := Trim(CDS_Main.fieldbyname('BZ').AsString); //币种 FieldByName('YJSKTime').Value := CDS_Main.fieldbyname('YSKTime').AsDateTime; //应收款时间 FieldByName('BuyConNo').Value := Trim(CDS_Main.fieldbyname('KHNumber').AsString); //客户单号 FieldByName('ZJS').Value := Trim(CDS_Main.fieldbyname('ZJS').AsString); //中间商 FieldByName('ZDR').Value := Trim(CDS_Main.fieldbyname('ZDR').AsString); //制单人 FieldByName('PayMent').Value := Trim(CDS_Main.fieldbyname('FKFS').AsString); //付款方式 FieldByName('ZGfinishdate').Value := CDS_Main.fieldbyname('ZGfinishdate').AsDateTime; //装柜日期 FieldByName('Amount').Value := CDS_Main.fieldbyname('ZYSK').AsFloat; //* ADOQueryTemp1.fieldbyname('ConPrice').AsFloat; // RTSetsavedata(ADOQueryCmd, 'Finance_Flow', ScrollBox1, 0); Post; end; ADOQueryCmd.Connection.CommitTrans; // FCCID := Trim(MaxSubId); Result := True; except Result := false; ADOQueryCmd.Connection.RollbackTrans; // application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; end; procedure TfrmCYDXZ.InitGrid(); begin try ADOQueryMain.DisableControls; with ADOQueryMain do begin Filtered := False; Close; sql.Clear; sql.Add(' select A.*,B.* '); sql.Add(' ,convert(varchar(10),B.YSKTime,120) as YSKTime1 '); sql.Add(' from BS_CYGL_CY A'); sql.Add(' INNER JOIN BS_CYGL_Main B on A.BIOSID=B.BIOSID '); sql.add(' where A.CJdate>=''' + Trim(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)) + ''''); sql.Add(' and A.CJdate<''' + Trim(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)) + ''''); SQL.Add(' and status=''1'' '); case cxTabControl1.TabIndex of 0: begin sql.Add(' and isnull(A.YSZT,''0'')=''0'' '); end; 1: begin sql.Add(' and isnull(A.YSZT,''0'')=''1'' '); end; end; // showmessage(sql.text); Open; end; SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); finally ADOQueryMain.EnableControls; end; end; procedure TfrmCYDXZ.N1Click(Sender: TObject); begin SelOKNo(CDS_Main, true) end; procedure TfrmCYDXZ.N3Click(Sender: TObject); begin SelOKNo(CDS_Main, false) end; procedure TfrmCYDXZ.ToolButton1Click(Sender: TObject); begin if ADOQueryMain.Active then begin SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); end; end; procedure TfrmCYDXZ.ToolButton2Click(Sender: TObject); begin if CDS_Main.IsEmpty then Exit; if CDS_Main.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; // ADOQueryCmd.Connection.BeginTrans; try with CDS_Main do begin DisableControls; first; while not eof do begin if fieldbyname('ssel').AsBoolean then begin if not YSData() then begin // ADOQueryCmd.Connection.RollbackTrans; application.MessageBox('生成应收款失败!', '提示信息', 0); end; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('Update BS_CYGL_CY Set YSZT=''1'' '); sql.Add('where BIOSID=''' + Trim(CDS_Main.fieldbyname('BIOSID').AsString) + ''''); ExecSQL; end; end; next; end; first; EnableControls; end; // ADOQueryCmd.Connection.CommitTrans; application.MessageBox('生成应收款成功!', '提示信息'); initGrid(); except // ADOQueryCmd.Connection.RollbackTrans; application.MessageBox('生成应收款失败!', '提示信息', 0); end; end; procedure TfrmCYDXZ.ToolButton3Click(Sender: TObject); begin InitGrid(); end; procedure TfrmCYDXZ.ToolButton7Click(Sender: TObject); begin WriteCxGrid(trim(Self.Caption), Tv1, '出运单选择'); end; procedure TfrmCYDXZ.ToolButton8Click(Sender: TObject); begin Close; end; procedure TfrmCYDXZ.cxTabControl1Change(Sender: TObject); begin InitGrid(); end; procedure TfrmCYDXZ.FormCreate(Sender: TObject); begin EndDate.DateTime := SGetServerDate(ADOQueryTemp); BegDate.DateTime := EndDate.DateTime - 90; end; procedure TfrmCYDXZ.FormShow(Sender: TObject); begin ReadCxGrid(trim(Self.Caption), Tv1, '出运单选择'); InitGrid(); end; end.