unit U_CKLB; 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, dxBarBuiltInMenu, cxGraphics, cxControls, cxLookAndFeels, cxLookAndFeelPainters, cxStyles, dxSkinsCore, dxSkinsDefaultPainters, cxCustomData, cxFilter, cxData, cxDataStorage, cxEdit, cxNavigator, dxDateRanges, Data.DB, cxDBData, cxCheckBox, cxCalendar, cxDropDownEdit, cxButtonEdit, cxTextEdit, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxGridCustomView, cxGrid, cxGridCustomPopupMenu, cxGridPopupMenu, Datasnap.DBClient, Data.Win.ADODB, Vcl.Menus, cxPC; type TfrmCKLB = class(TForm) ToolBar2: TToolBar; ToolButton3: TToolButton; btnAdd: TToolButton; ToolButton4: TToolButton; btnEdit: TToolButton; ToolButton5: TToolButton; btnDel: TToolButton; btnChk: TToolButton; btnReChk: TToolButton; ToolButton6: TToolButton; ToolButton7: TToolButton; ToolButton8: TToolButton; Panel1: TPanel; Label1: TLabel; Label2: TLabel; Label3: TLabel; Label4: TLabel; Label5: TLabel; Label8: TLabel; Label12: TLabel; Label6: TLabel; Label7: TLabel; BegDate: TDateTimePicker; EndDate: TDateTimePicker; C_Name: TEdit; FTYName: TEdit; BCIOID: TEdit; C_spec: TEdit; IOType: TComboBox; ToOrdNo: TEdit; FromBuyConNoHZ: TEdit; PopupMenu1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; ADOQueryTemp1: TADOQuery; ADOQueryCmd: TADOQuery; DataSource1: TDataSource; CDS_Main: TClientDataSet; ADOQueryTemp: TADOQuery; ADOQueryMain: TADOQuery; cxGridPopupMenu1: TcxGridPopupMenu; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; Tv1Column5: TcxGridDBColumn; v1Column6: TcxGridDBColumn; v1Column2: TcxGridDBColumn; v1Column4: TcxGridDBColumn; v1Column15: TcxGridDBColumn; v1Column1: TcxGridDBColumn; v1Column14: TcxGridDBColumn; v1Column13: TcxGridDBColumn; v1Column16: TcxGridDBColumn; v1Column17: TcxGridDBColumn; v2Column1: TcxGridDBColumn; v1Column20: TcxGridDBColumn; v1Column8: TcxGridDBColumn; v1Column10: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; v1Column7: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; v1Column18: TcxGridDBColumn; Tv1Column1: TcxGridDBColumn; v1Column19: TcxGridDBColumn; v2Column6: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; v1Column3: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; v1Column12: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; cxGrid1Level1: TcxGridLevel; ToolButton1: TToolButton; ToolButton2: TToolButton; cxTabControl1: TcxTabControl; Tv1Column14: TcxGridDBColumn; procedure ToolButton1Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure FormShow(Sender: TObject); procedure ToolButton7Click(Sender: TObject); procedure FormCreate(Sender: TObject); procedure BCIOIDChange(Sender: TObject); procedure cxTabControl1Change(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure ToolButton8Click(Sender: TObject); private procedure InitGrid(); function YSData(): Boolean; { Private declarations } public FFFID: string; { Public declarations } end; var frmCKLB: TfrmCKLB; implementation uses U_DataLink, U_RTFun; {$R *.dfm} function TfrmCKLB.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('BCIOID').AsString); //关联出库 FieldByName('OurCoName').Value := Trim(ADOQueryTemp1.fieldbyname('SellName').AsString); //我方单位 BuyName FieldByName('OurCoNo').Value := Trim(ADOQueryTemp1.fieldbyname('SellNo').AsString); // BuyNo FieldByName('OppCoName').Value := Trim(ADOQueryTemp1.fieldbyname('BuyName').AsString); //对方单位 SellName FieldByName('OppCoNo').Value := Trim(ADOQueryTemp1.fieldbyname('BuyNo').AsString); // SellNo FieldByName('OppParentCoName').Value := Trim(ADOQueryTemp1.fieldbyname('BuyName').AsString); //上级单位 FieldByName('OppParentCoNo').Value := Trim(ADOQueryTemp1.fieldbyname('BuyNo').AsString); FieldByName('PayMent').Value := Trim(ADOQueryTemp1.fieldbyname('Payment').AsString); //付款方式 FieldByName('ConNo').Value := Trim(ADOQueryTemp1.fieldbyname('ConNo').AsString); //合同号 // FieldByName('BuyConNo').Value := Trim(ADOQueryTemp1.fieldbyname('BuyConNo').AsString); //客户单号 // FieldByName('FromBuyConNoHZ').Value := Trim(ADOQueryTemp1.fieldbyname('FromBuyConNoHZ').AsString); //客户单号 FieldByName('Price').Value := ADOQueryTemp1.fieldbyname('ConPrice').AsFloat; // 单价 FieldByName('Currency').Value := Trim(ADOQueryTemp1.fieldbyname('Currency').AsString); //币种 // FieldByName('contractNO').Value := Trim(CDS_Main.fieldbyname('contractNO').AsString); //合同编号 // FieldByName('C_ConNo').Value := Trim(CDS_Main.fieldbyname('C_ConNo').AsString); //明细合同号 // FieldByName('BuyConNoHZ').Value := Trim(CDS_Main.fieldbyname('BuyConNoHZ').AsString); //总客户单号 FieldByName('BuyConNo').Value := Trim(CDS_Main.fieldbyname('FromBuyConNoHZ').AsString); //客户单号 FieldByName('F_Code').Value := Trim(CDS_Main.fieldbyname('C_Code').AsString); //编号 FieldByName('F_Name').Value := Trim(CDS_Main.fieldbyname('C_Name').AsString); //品名 FieldByName('F_Pattern').Value := Trim(CDS_Main.fieldbyname('C_Pattern').AsString); //花型 FieldByName('F_Color').Value := Trim(CDS_Main.fieldbyname('C_Color').AsString); //颜色 FieldByName('F_Width').Value := Trim(CDS_Main.fieldbyname('C_Width').AsString); //门幅 FieldByName('F_GramWeight').Value := Trim(CDS_Main.fieldbyname('C_GramWeight').AsString); //克重 FieldByName('F_ColorNo').Value := Trim(CDS_Main.fieldbyname('C_ColorNo').AsString); //色号 FieldByName('Qty').Value := CDS_Main.fieldbyname('Qty').AsFloat; //数量 FieldByName('Piece').Value := CDS_Main.fieldbyname('Piece').AsFloat; //匹数 // FieldByName('SJConQty').Value := CDS_Main.fieldbyname('SJConQty').AsFloat; //实际数量 // FieldByName('SJPQTY').Value := CDS_Main.fieldbyname('SJPQTY').AsInteger; //实际匹数 FieldByName('QtyUnit').Value := Trim(CDS_Main.fieldbyname('QtyUnit').AsString); // 单位 // FieldByName('OtherFee').Value := CDS_Main.fieldbyname('C_OtherFees').AsFloat; //其他费用 // FieldByName('OtherFeesNote').Value := Trim(CDS_Main.fieldbyname('C_OtherFeesNote').AsString); //其他费用备注 // FieldByName('Note').Value := Trim(CDS_Main.fieldbyname('ConSNote').AsString); //其他费用备注 // FieldByName('IsInvoice').Value := Trim(CDS_Main.fieldbyname('IsTax').AsString); //是否含税 FieldByName('Amount').Value := CDS_Main.fieldbyname('Qty').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 TfrmCKLB.BCIOIDChange(Sender: TObject); begin ToolButton1.Click; end; procedure TfrmCKLB.cxTabControl1Change(Sender: TObject); begin InitGrid(); end; procedure TfrmCKLB.FormCreate(Sender: TObject); begin EndDate.DateTime := SGetServerDate(ADOQueryTemp); BegDate.DateTime := EndDate.DateTime - 90; end; procedure TfrmCKLB.FormShow(Sender: TObject); begin ReadCxGrid(trim(Self.Caption), Tv1, '贸易汇总仓库1'); InitGrid(); end; procedure TfrmCKLB.InitGrid(); begin try ADOQueryMain.DisableControls; with ADOQueryMain do begin Filtered := False; Close; sql.Clear; sql.Add(' select A.* '); // sql.Add(',Zb=(select sum(boxs) from BS_Cloth_IO B where B.FromSubId=A.FromSubId and B.IOFlag=''出库'')'); // sql.Add(',minbox=(select CEILING(D.OrdQty*(1-(isnull(C.overflow,0)/100))/D.C_Crate) from Trade_Plan_Main C inner join Trade_Plan_Sub D on C.MainId=D.MainId where D.subid=A.fromsubid) '); sql.Add(' from BS_Cloth_IO A'); sql.add(' where A.IOTime>=''' + Trim(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)) + ''''); sql.Add(' and A.IOTime<''' + Trim(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)) + ''''); // sql.Add(' and isnull(stkName,'''')=''' + Trim(FstkName) + ''''); 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; SQL.Add(' and ioFlag=''出库'' '); // showmessage(sql.text); Open; end; SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); finally ADOQueryMain.EnableControls; end; end; procedure TfrmCKLB.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 TfrmCKLB.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_Cloth_IO Set YSZT=''1'' '); sql.Add('where BCIOID=''' + Trim(CDS_Main.fieldbyname('BCIOID').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 TfrmCKLB.ToolButton3Click(Sender: TObject); begin InitGrid(); end; procedure TfrmCKLB.ToolButton7Click(Sender: TObject); begin WriteCxGrid(trim(Self.Caption), Tv1, '贸易汇总仓库1'); end; procedure TfrmCKLB.ToolButton8Click(Sender: TObject); begin Close; end; end.