unit U_CYSZ; 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.ExtCtrls, dxBarBuiltInMenu, Data.DB, Datasnap.DBClient, cxClasses, cxGridCustomPopupMenu, cxGridPopupMenu, cxGraphics, cxControls, cxLookAndFeels, cxLookAndFeelPainters, cxStyles, dxSkinsCore, dxSkinsDefaultPainters, cxCustomData, cxFilter, cxData, cxDataStorage, cxEdit, cxNavigator, dxDateRanges, cxDBData, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxGridCustomView, cxGrid, Vcl.StdCtrls, Data.Win.ADODB, cxCheckBox, BtnEdit, cxCalendar, cxTextEdit, math, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations; type TfrmCYSZ = class(TForm) ToolBar1: TToolBar; ToolButton4: TToolButton; ToolButton1: TToolButton; TBClose: TToolButton; Panel1: TPanel; ToolBar2: TToolBar; ToolButton2: TToolButton; ToolButton3: TToolButton; GPM_3: TcxGridPopupMenu; CDS_3: TClientDataSet; DS_3: TDataSource; cxGrid3: TcxGrid; TV3: TcxGridDBTableView; TV3Column1: TcxGridDBColumn; TV3Column2: TcxGridDBColumn; TV3Column3: TcxGridDBColumn; TV3Column4: TcxGridDBColumn; TV3Column5: TcxGridDBColumn; TV3Column6: TcxGridDBColumn; TV3Column7: TcxGridDBColumn; TV3Column8: TcxGridDBColumn; TV3Column9: TcxGridDBColumn; TV3Column10: TcxGridDBColumn; TV3Column11: TcxGridDBColumn; cxGridLevel3: TcxGridLevel; Label16: TLabel; fwsContact: TEdit; Label1: TLabel; fwsPhone: TEdit; Label2: TLabel; fwsaddress: TEdit; Label3: TLabel; Label4: TLabel; Label5: TLabel; CKfirmContact: TEdit; Label6: TLabel; CKfirmPhone: TEdit; Label7: TLabel; CKfirmmailbox: TEdit; Label8: TLabel; CKfirmaddress: TEdit; Label9: TLabel; SHfirmContact: TEdit; Label10: TLabel; Label11: TLabel; SHfirmPhone: TEdit; Label12: TLabel; SHfirmmailbox: TEdit; Label13: TLabel; SHfirmaddress: TEdit; Label15: TLabel; SJInformation: TEdit; Label14: TLabel; TYdate: TDateTimePicker; Label17: TLabel; ZGfinishdate: TDateTimePicker; Label18: TLabel; SJshipmentdate: TDateTimePicker; Label19: TLabel; boat: TEdit; Label20: TLabel; Voyage: TEdit; containerNO: TEdit; Label21: TLabel; Label22: TLabel; AccessoriesNO: TEdit; Label23: TLabel; CustomsNO: TEdit; Label24: TLabel; TDNO: TEdit; ADOQueryCmd: TADOQuery; ADOQueryMain: TADOQuery; ADOQueryTemp: TADOQuery; ADOCmd: TADOQuery; ADOTemp: TADOQuery; ADOQuery1: TADOQuery; TV3Column12: TcxGridDBColumn; Service: TBtnEditC; CKfirmName: TBtnEditC; SHfirmName: TBtnEditC; Label25: TLabel; ZYSK: TEdit; Label27: TLabel; YHF: TEdit; Label28: TLabel; Label29: TLabel; FD: TEdit; Label30: TLabel; note: TEdit; YSKTime: TDateTimePicker; TV3Column13: TcxGridDBColumn; TV3Column14: TcxGridDBColumn; procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure FormDestroy(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure FormShow(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ServiceBtnDnClick(Sender: TObject); procedure CKfirmNameBtnDnClick(Sender: TObject); procedure SHfirmNameChange(Sender: TObject); procedure SHfirmNameBtnDnClick(Sender: TObject); procedure ServiceBtnUpClick(Sender: TObject); procedure CKfirmNameBtnUpClick(Sender: TObject); procedure SHfirmNameBtnUpClick(Sender: TObject); procedure TV3Column8PropertiesEditValueChanged(Sender: TObject); procedure ZGfinishdateChange(Sender: TObject); procedure AccessoriesNOChange(Sender: TObject); private procedure SetXH(); function SaveData(): Boolean; { Private declarations } public PState: string; Fmainid: string; FFBIOSID: string; FAuthority, FGSTT: string; { Public declarations } end; var frmCYSZ: TfrmCYSZ; implementation uses U_DataLink, U_RTFun, U_FLJHD, U_CompanySel; {$R *.dfm} procedure TfrmCYSZ.ServiceBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmCYSZ.ServiceBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; FLX := '采购合同'; FCY := '出运'; if ShowModal = 1 then begin self.Service.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.Service.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); self.fwsPhone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Telephone').AsString); self.fwsaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); self.fwsContact.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Contacts').AsString); end; end; finally frmCompanySel.Free; end; // try // frmCompanySel := TfrmCompanySel.Create(Application); // with frmCompanySel do // begin // FCoType := '客户'; // FCY := '出运'; // if Self.FAuthority = '录入' then // FAuthority := '理单业务'; // if ShowModal = 1 then // begin // self.Service.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); // self.Service.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoName').AsString); // self.fwsPhone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Phone').AsString); // self.fwsaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); // end; // end; // // finally // frmCompanySel.Free; // end; end; procedure TfrmCYSZ.SetXH(); var i: Integer; begin with CDS_3 do begin First; i := 1; while not Eof do begin with CDS_3 do begin Edit; FieldByName('XHNoTemp').Value := i; Post; end; i := i + 1; Next; end; end; with CDS_3 do begin CDS_3.IndexFieldNames := ''; First; i := 1; while not Eof do begin with CDS_3 do begin Edit; FieldByName('XH').Value := FieldByName('XHNoTemp').AsInteger; Post; end; i := i + 1; Next; end; CDS_3.IndexFieldNames := 'XH'; end; end; procedure TfrmCYSZ.SHfirmNameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmCYSZ.SHfirmNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '客户'; FCY := '出运'; if Self.FAuthority = '录入' then FAuthority := '理单业务'; if ShowModal = 1 then begin self.SHfirmName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.SHfirmName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); self.SHfirmContact.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Contacts').AsString); self.SHfirmPhone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Phone').AsString); self.SHfirmaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmCYSZ.SHfirmNameChange(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; function TfrmCYSZ.SaveData(): Boolean; var maxno: string; fconNO, fmxType, fDate: string; begin try ADOCmd.Connection.BeginTrans; //////////////// 保存主表 ////////////////////// if Trim(Fmainid) = '' then begin if GetLSNo(ADOTemp, maxno, 'CY', 'BS_CYGL_Main', 3, 1) = False then raise Exception.Create('取最大号失败!'); end else begin maxno := Trim(Fmainid); end; with ADOCmd do begin Close; sql.Clear; SQL.Add('select * from BS_CYGL_Main where mainid=''' + Trim(Fmainid) + ''''); Open; end; with ADOCmd do begin if Trim(Fmainid) = '' then begin Append; FieldByName('Filler').Value := Trim(DName); // FieldByName('status').Value := '0'; end else begin Edit; FieldByName('Updater').Value := Trim(DName); FieldByName('GXdate').Value := SGetServerDateTime(ADOTemp); end; FieldByName('mainid').Value := Trim(maxno); FieldByName('BIOSID').Value := Trim(FFBIOSID); RTSetsavedata(ADOCmd, 'BS_JYGL_Main', Panel1, 2); FieldByName('Servicecode').Value := Trim(Service.TxtCode); FieldByName('CKfirmNamecode').Value := Trim(CKfirmName.TxtCode); FieldByName('SHfirmNamecode').Value := Trim(SHfirmName.TxtCode); Post; end; // with ADOCmd do // begin // Close; // sql.Clear; // sql.Add('select * from BS_Contract_Main where ConNo=''' + Trim(ConNo.Text) + ''''); // Open; // end; // if ADOCmd.RecordCount > 1 then // raise Exception.Create('合同号重复!'); Fmainid := Trim(maxno); //////////////// 保存主表 ////////////////////// /// //////////////// 保存子表 ////////////////////// with CDS_3 do begin First; while not Eof do begin if Trim(CDS_3.fieldbyname('SubId').AsString) = '' then begin if GetLSNo(ADOCmd, maxno, 'JS', 'BS_CYGL_sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; end else begin maxno := Trim(CDS_3.fieldbyname('SubId').AsString); end; // maxno := Trim(CDS_3.fieldbyname('subid').AsString); with ADOCmd do begin Close; SQL.Clear; sql.Add('select * from BS_CYGL_sub where subid=''' + Trim(maxno) + ''''); Open; end; with ADOCmd do begin if ADOCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOCmd, Tv3, CDS_3, 'BS_JYGL_sub', 0); FieldByName('mainid').Value := Trim(Fmainid); FieldByName('subid').Value := Trim(maxno); FieldByName('BIOSID').Value := Trim(FFBIOSID); Post; end; with CDS_3 do begin Edit; FieldByName('subid').Value := Trim(maxno); Post; end; Next; end; end; ADOCmd.Connection.CommitTrans; Result := True; except ADOCmd.Connection.RollbackTrans; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); Result := False; end; end; procedure TfrmCYSZ.AccessoriesNOChange(Sender: TObject); begin YSKTime.DateTime := ZGfinishdate.DateTime + StrToIntdef(AccessoriesNO.text, 0); end; procedure TfrmCYSZ.CKfirmNameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmCYSZ.CKfirmNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '我司'; if ShowModal = 1 then begin self.CKfirmName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.CKfirmName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); self.CKfirmPhone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Phone').AsString); self.CKfirmaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); end; end; finally frmCompanySel.Free; end; // try // frmCompanySel := TfrmCompanySel.Create(Application); // with frmCompanySel do // begin // FCoType := '客户'; // FCY := '出运'; // if Self.FAuthority = '录入' then // FAuthority := '理单业务'; // if ShowModal = 1 then // begin // self.CKfirmName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); // self.CKfirmName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoName').AsString); // self.CKfirmPhone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Phone').AsString); // self.CKfirmaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); // end; // end; // // finally // frmCompanySel.Free; // end; end; procedure TfrmCYSZ.FormClose(Sender: TObject; var Action: TCloseAction); begin Action := caFree; end; procedure TfrmCYSZ.FormDestroy(Sender: TObject); begin frmCYSZ := nil; end; procedure TfrmCYSZ.FormShow(Sender: TObject); begin ReadCxGrid(trim(self.caption) + 'Tv3', Tv3, '出运信息'); with ADOTemp do begin Close; SQL.Clear; sql.Add(' select * from BS_CYGL_Sub '); sql.Add('where mainid=''' + Trim(Fmainid) + ''''); // sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOTemp, CDS_3); SInitCDSData(ADOTemp, CDS_3); with ADOTemp do begin Close; sql.Clear; sql.Add('select * from BS_CYGL_Main where mainid=''' + Trim(Fmainid) + ''''); Open; end; SCSHData(ADOTemp, Panel1, 2); if PState = '新增' then begin TYdate.DateTime := SGetServerDateTime(ADOTemp); ZGfinishdate.DateTime := SGetServerDateTime(ADOTemp); SJshipmentdate.DateTime := SGetServerDateTime(ADOTemp); YSKTime.DateTime := SGetServerDateTime(ADOTemp) + 50; // DlyDate.DateTime := ConDate.DateTime; // ZDDate.DateTime := ConDate.DateTime; // ConNo.Text := '自动生成'; end; end; procedure TfrmCYSZ.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmCYSZ.ToolButton1Click(Sender: TObject); begin WriteCxGrid(trim(self.caption) + 'Tv3', Tv3, '出运信息'); end; procedure TfrmCYSZ.ToolButton2Click(Sender: TObject); var FConMainId, FMPRTCode: string; maxno: string; S: Integer; begin try frmFLJHD := TfrmFLJHD.Create(Application); with frmFLJHD do begin if ShowModal = 1 then begin S := self.CDS_3.RecordCount; while Order_Main.locate('SSel', true, []) do begin if GetLSNo(ADOCmd, maxno, 'CS', 'BS_CYGL_Sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; S := S + 1; with self.CDS_3 do begin Append; FieldByName('SSel').Value := false; Fieldbyname('XH').value := S; Fieldbyname('ProductNO').value := trim(frmFLJHD.Order_Main.Fieldbyname('C_Code').AsString); Fieldbyname('Productname').value := trim(frmFLJHD.Order_Main.Fieldbyname('C_Name').AsString); Fieldbyname('KHNO').value := trim(frmFLJHD.Order_Main.Fieldbyname('C_StyleNo').AsString); Fieldbyname('Barcodes').value := trim(frmFLJHD.Order_Main.Fieldbyname('C_Barcodes').AsString); Fieldbyname('CS_Color').value := trim(frmFLJHD.Order_Main.Fieldbyname('C_COLOR').AsString); Fieldbyname('DDQTY').value := frmFLJHD.Order_Main.Fieldbyname('OrdQty').AsFloat; // Fieldbyname('Boxs').value := frmFLJHD.Order_Main.Fieldbyname('C_box').AsFloat; Fieldbyname('volume').value := frmFLJHD.Order_Main.Fieldbyname('C_volume').AsFloat; Fieldbyname('BuiltinQTY').value := frmFLJHD.Order_Main.Fieldbyname('C_Crate').AsFloat; Post; end; Order_Main.Edit; Order_Main.fieldbyname('SSel').value := false; end; end; end; finally frmFLJHD.Free; end; end; procedure TfrmCYSZ.ToolButton3Click(Sender: TObject); begin if CDS_3.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; while CDS_3.Locate('SSel', True, []) do begin if Trim(CDS_3.fieldbyname('subid').AsString) <> '' then begin with ADOCmd do begin Close; sql.Clear; sql.Add('delete BS_CYGL_sub where subid=''' + Trim(CDS_3.fieldbyname('subid').AsString) + ''''); ExecSQL; end; end; CDS_3.Delete; end; SetXH(); end; procedure TfrmCYSZ.ToolButton4Click(Sender: TObject); begin if trim(AccessoriesNO.text) = '' then begin Application.MessageBox('付款间隔不能为空!', '提示', 0); Exit; end; if SaveData() then begin Application.MessageBox('保存成功!', '提示', 0); end; end; procedure TfrmCYSZ.TV3Column8PropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName: string; FBCdecimalQTY, FBoxs, FZvolume, FBuiltinQTY, Fvolume: Double; begin mvalue := TcxTextEdit(Sender).EditingText; if Trim(mvalue) = '' then begin mvalue := '0'; end; FFieldName := Trim(Tv3.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_3 do begin Edit; FieldByName(FFieldName).value := Trim(mvalue); Post; end; with CDS_3 do begin FBCdecimalQTY := Fieldbyname('BCdecimalQTY').AsFloat; //本次出运数量 FBuiltinQTY := Fieldbyname('BuiltinQTY').AsFloat; //内装箱数 Fvolume := Fieldbyname('volume').AsFloat; //体积 end; FBoxs := RoundFloat(FBCdecimalQTY / FBuiltinQTY, 2); //箱数 FZvolume := Fvolume * FBoxs; //总体积 with CDS_3 do begin Edit; FieldByName('Boxs').value := FBoxs; FieldByName('Zvolume').value := FZvolume; Post; end; tv3.Controller.EditingController.ShowEdit(); end; procedure TfrmCYSZ.ZGfinishdateChange(Sender: TObject); begin // YSKTime.DateTime := ZGfinishdate.DateTime + 50; YSKTime.DateTime := ZGfinishdate.DateTime + StrToIntdef(AccessoriesNO.text, 0); end; end.