unit U_PurchaseConInPut; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxControls, cxGridCustomView, cxGrid, cxMemo, cxRichEdit, ComCtrls, cxContainer, cxTextEdit, cxMaskEdit, cxButtonEdit, StdCtrls, ToolWin, DBClient, ADODB, ExtCtrls, BtnEdit, cxCalendar, StrUtils, cxDropDownEdit, cxGridCustomPopupMenu, cxGridPopupMenu, cxLookAndFeels, cxLookAndFeelPainters, dxSkinsCore, dxSkinsDefaultPainters, cxNavigator, dxDateRanges, dxBarBuiltInMenu, dxDateTimeWheelPicker, dxGDIPlusClasses, Vcl.Menus, MovePanel, cxCheckBox, cxImage, cxDBEdit, Vcl.DBCtrls, U_BaseInput, System.ImageList, Vcl.ImgList, IdBaseComponent, IdComponent, IdTCPConnection, IdTCPClient, IdExplicitTLSClientServerBase, IdFTP, ShellAPI, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations; type TfrmPurchaseConInPut = class(TfrmBaseInput) ToolBar1: TToolBar; TBSave: TToolButton; TBClose: TToolButton; ScrollBox1: TScrollBox; Label3: TLabel; ConDate: TDateTimePicker; ToolBar2: TToolBar; ToolButton1: TToolButton; ToolButton2: TToolButton; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; cxGrid1Level1: TcxGridLevel; v1PRTPrice: TcxGridDBColumn; ADOTemp: TADOQuery; ADOCmd: TADOQuery; DS_1: TDataSource; Order_Sub: TClientDataSet; v1PRTOrderQty: TcxGridDBColumn; Label10: TLabel; ConNo: TEdit; Label14: TLabel; Label20: TLabel; BuyName: TBtnEditC; v1XHNo: TcxGridDBColumn; v1OrderUnit: TcxGridDBColumn; Label6: TLabel; v1Column2: TcxGridDBColumn; v1Column4: TcxGridDBColumn; v1Column5: TcxGridDBColumn; v1Column6: TcxGridDBColumn; v1Column7: TcxGridDBColumn; VC_SCSCode: TcxGridDBColumn; cxgrdpmn1: TcxGridPopupMenu; QtyNote: TBtnEditC; v1Column1: TcxGridDBColumn; v1Column8: TcxGridDBColumn; Sellname: TBtnEditC; Label27: TLabel; IsTax: TComboBox; Tv1Column3: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Label5: TLabel; Currency: TComboBox; Label11: TLabel; Label12: TLabel; YunShu: TBtnEditC; Payment: TBtnEditC; Label13: TLabel; JiaGeSY: TBtnEditC; pm_sub: TPopupMenu; Tv1Column1: TcxGridDBColumn; N1: TMenuItem; Tv1Column7: TcxGridDBColumn; Label8: TLabel; Packing: TBtnEditC; Label15: TLabel; Label16: TLabel; DlyDate: TDateTimePicker; N2: TMenuItem; ShippMent: TEdit; ToolButton3: TToolButton; Label23: TLabel; ConType: TComboBox; Tv1Column2: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; ToolButton4: TToolButton; Tv1Column14: TcxGridDBColumn; Leadtime: TMemo; Dyeing: TMemo; Label1: TLabel; Finishing: TMemo; Label2: TLabel; Label4: TLabel; Countercolor: TEdit; Label7: TLabel; Trimming: TEdit; Label9: TLabel; Torque: TEdit; Tv1Column15: TcxGridDBColumn; Tv1Column16: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; Label17: TLabel; PH: TEdit; Label18: TLabel; feel: TEdit; Label19: TLabel; Shrinkage: TEdit; Label21: TLabel; spray: TEdit; Label22: TLabel; Erodus: TEdit; Label24: TLabel; Eattrition: TEdit; Label25: TLabel; Tv1Column18: TcxGridDBColumn; Tv1Column19: TcxGridDBColumn; Tv1Column20: TcxGridDBColumn; Label26: TLabel; address: TMemo; Label28: TLabel; client: TEdit; Label29: TLabel; CoName: TEdit; Label30: TLabel; Phone: TEdit; cxStyleRepository1: TcxStyleRepository; cxStyle1: TcxStyle; Label31: TLabel; BuyConNoHZ: TEdit; Label32: TLabel; contractNO: TEdit; Tv1Column21: TcxGridDBColumn; Label33: TLabel; ZDDate: TDateTimePicker; Tv1Column22: TcxGridDBColumn; Tv1Column23: TcxGridDBColumn; Tv1Column24: TcxGridDBColumn; Tv1Column25: TcxGridDBColumn; Tv1Column26: TcxGridDBColumn; Label34: TLabel; firmname: TEdit; Label35: TLabel; firmaddress: TMemo; q1: TMenuItem; N3: TMenuItem; Tv1Column27: TcxGridDBColumn; procedure TBCloseClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure TBSaveClick(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure BuyNameBtnUpClick(Sender: TObject); procedure BuyNameBtnDnClick(Sender: TObject); procedure v1Column4PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure v1Column6PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure v1Column7PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure v1Column10PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure SalesmanBtnUpClick(Sender: TObject); procedure v1Column15PropertiesEditValueChanged(Sender: TObject); procedure SellNameBtnUpClick(Sender: TObject); procedure v1PRTOrderQtyPropertiesEditValueChanged(Sender: TObject); procedure QiYunBtnUpClick(Sender: TObject); procedure N1Click(Sender: TObject); procedure N2Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ExchangeRateKeyPress(Sender: TObject; var Key: Char); procedure ToolButton4Click(Sender: TObject); procedure ShippMentKeyPress(Sender: TObject; var Key: Char); procedure CountercolorKeyPress(Sender: TObject; var Key: Char); procedure TrimmingKeyPress(Sender: TObject; var Key: Char); procedure TorqueKeyPress(Sender: TObject; var Key: Char); procedure sprayKeyPress(Sender: TObject; var Key: Char); procedure PHKeyPress(Sender: TObject; var Key: Char); procedure feelKeyPress(Sender: TObject; var Key: Char); procedure ShrinkageKeyPress(Sender: TObject; var Key: Char); procedure ErodusKeyPress(Sender: TObject; var Key: Char); procedure EattritionKeyPress(Sender: TObject; var Key: Char); procedure clientKeyPress(Sender: TObject; var Key: Char); procedure LeadtimeKeyPress(Sender: TObject; var Key: Char); procedure DyeingKeyPress(Sender: TObject; var Key: Char); procedure FinishingKeyPress(Sender: TObject; var Key: Char); procedure Tv1Column19PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure q1Click(Sender: TObject); procedure N3Click(Sender: TObject); private FLeft, FTop: Integer; fuserName, Fstatus: string; procedure JSMoney(); procedure InitData(); function TestData(): Boolean; function SaveData(): Boolean; procedure SetXH(); { Private declarations } public CopyInt: Integer; PState: string; fFlileFlag: string; FConMId: string; FAuthority, FGSTT: string; { Public declarations } end; var frmPurchaseConInPut: TfrmPurchaseConInPut; newh: hwnd; implementation uses U_DataLink, U_RTFun, U_ZDYHelp, U_CompanySel, U_ClothInfoSel, U_PictureUpload, U_TradeSalesContractSel; {$R *.dfm} procedure TfrmPurchaseConInPut.SetXH(); var i: Integer; begin with Order_Sub do begin First; i := 1; while not Eof do begin with Order_Sub do begin Edit; FieldByName('XHNoTemp').Value := i; Post; end; i := i + 1; Next; end; end; with Order_Sub do begin Order_Sub.IndexFieldNames := ''; First; i := 1; while not Eof do begin with Order_Sub do begin Edit; FieldByName('SerialNo').Value := FieldByName('XHNoTemp').AsInteger; Post; end; i := i + 1; Next; end; Order_Sub.IndexFieldNames := 'SerialNo'; end; end; procedure TfrmPurchaseConInPut.ShippMentKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Countercolor.SetFocus; end; end; procedure TfrmPurchaseConInPut.ShrinkageKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin spray.SetFocus; end; end; procedure TfrmPurchaseConInPut.sprayKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Erodus.SetFocus; end; end; procedure TfrmPurchaseConInPut.JSMoney(); var FConQty, FConPrice, FC_Money: Double; begin with Order_Sub do begin FConQty := Fieldbyname('ConQty').AsFloat; FConPrice := Fieldbyname('ConPrice').AsFloat; end; //计算金额,保留2位小数 FC_Money := RoundFloat(FConQty * FConPrice, 2); with Order_Sub do begin Edit; FieldByName('ConTotalAmount').Value := FC_Money; Post; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.LeadtimeKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Dyeing.SetFocus; end; end; function TfrmPurchaseConInPut.TestData(): Boolean; begin try if Trim(ConNo.Text) = '' then raise Exception.Create('合同号不能为空!'); if Trim(SellName.Text) = '' then raise Exception.Create('经营单位不能为空!'); if Trim(BuyName.Text) = '' then raise Exception.Create('对方单位不能为空!'); if Trim(ConType.Text) = '' then raise Exception.Create('类型不能为空!'); if Trim(BuyConNoHZ.Text) = '' then raise Exception.Create('客户单号不能为空!'); if Order_Sub.IsEmpty then raise Exception.Create('明细不能为空!'); // if Order_Sub.Locate('C_Code', null, []) then // raise Exception.Create('产品编号不能为空!'); // if Order_Sub.Locate('C_Code', '', []) then // raise Exception.Create('产品编号不能为空!'); // if Order_Sub.Locate('C_Name', null, []) then // raise Exception.Create('品名不能为空!'); // if Order_Sub.Locate('C_Name', '', []) then // raise Exception.Create('品名不能为空!'); // if Order_Sub.Locate('C_Color', null, []) then // raise Exception.Create('颜色不能为空!'); // if Order_Sub.Locate('C_Color', '', []) then // raise Exception.Create('颜色不能为空!'); // if Order_Sub.Locate('C_MF', null, []) then // raise Exception.Create('门幅不能为空!'); // if Order_Sub.Locate('C_MF', '', []) then // raise Exception.Create('门幅不能为空!'); // if Order_Sub.Locate('C_KZ', null, []) then // raise Exception.Create('克重不能为空!'); // if Order_Sub.Locate('C_KZ', '', []) then // raise Exception.Create('克重不能为空!'); if Order_Sub.Locate('ConQty', null, []) then raise Exception.Create('数量不能为空!'); if Order_Sub.Locate('ConQty', 0, []) then raise Exception.Create('数量不能为0!'); if Order_Sub.Locate('ConUnit', null, []) then raise Exception.Create('数量单位不能为空!'); if Order_Sub.Locate('ConUnit', '', []) then raise Exception.Create('数量单位不能为空!'); Result := True; except Result := false; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; end; procedure TfrmPurchaseConInPut.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmPurchaseConInPut.InitData(); var maxno: string; begin //刷新产品信息 with ADOTemp do begin Close; SQL.Clear; sql.Add(' select * from BS_Contract_Sub '); sql.Add('where ConMId=''' + Trim(FConMId) + ''''); sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOTemp, Order_Sub); SInitCDSData(ADOTemp, Order_Sub); //刷新条款信息 with ADOTemp do begin Close; sql.Clear; sql.Add('select * from BS_Contract_Main where ConMId=''' + Trim(FConMId) + ''''); Open; end; SCSHData(ADOTemp, ScrollBox1, 2); BuyName.TxtCode := Trim(ADOTemp.FieldByName('BuyNo').AsString); Sellname.TxtCode := Trim(ADOTemp.FieldByName('SellNo').AsString); Fstatus := Trim(ADOTemp.FieldByName('status').AsString); if PState = '新增' then begin ConDate.DateTime := SGetServerDateTime(ADOTemp); DlyDate.DateTime := ConDate.DateTime; ZDDate.DateTime := ConDate.DateTime; ConNo.Text := '自动生成'; end; if PState = '复制' then begin PState := '新增'; FConMId := ''; ConNo.Text := '自动生成'; ZDDate.DateTime := SGetServerDateTime(ADOTemp); with Order_Sub do begin First; while not Eof do begin if GetLSNo(ADOCmd, maxno, 'SCS', 'BS_Contract_Sub', 4, 1) = False then begin Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; Edit; FieldByName('ConMId').Value := ''; FieldByName('ConSId').Value := maxno; FieldByName('rktime').Value := null; Post; Next; end; end; end; end; procedure TfrmPurchaseConInPut.N1Click(Sender: TObject); var FValue, FFValue, FColumn, FFColumn, MHXSID: string; MXHNO: Integer; begin if Fstatus = '1' then begin application.MessageBox('合同已审核,无法操作!', '提示信息', 0); exit; end; MXHNO := Order_Sub.FieldByName('XHNo').ASInteger; FColumn := Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName; FValue := Trim(Order_Sub.fieldbyname(FColumn).AsString); MHXSID := Trim(Order_Sub.fieldbyname('HXSID').AsString); with Order_Sub do begin DisableControls; First; while not Eof do begin if FieldByName('SSel').AsBoolean then begin Edit; if FValue = '' then begin Order_Sub.FieldByName(FColumn).Value := null; end else begin Order_Sub.FieldByName(FColumn).Value := FValue; end; if FColumn = 'C_HX' then begin Order_Sub.FieldByName('HXSID').Value := MHXSID; end; Post; JSMoney(); end; Next; end; EnableControls; end; Order_Sub.Locate('XHNO', MXHNO, []); end; procedure TfrmPurchaseConInPut.N2Click(Sender: TObject); var FValue, MC_Code, MC_Craft, MC_Name, MC_Spec, MC_CF, MC_Color, MC_MF, MC_KZ, MC_Note, MC_Unit, MGcHuaNo, MSuoLv, MC_EName: string; MXHNO: Integer; begin if Fstatus = '1' then begin application.MessageBox('合同已审核,无法操作!', '提示信息', 0); exit; end; MXHNO := Order_Sub.FieldByName('XHNo').ASInteger; MC_Code := Order_Sub.fieldbyname('C_Code').AsString; MC_Craft := Order_Sub.fieldbyname('C_Craft').AsString; MC_Name := Order_Sub.fieldbyname('C_Name').AsString; MC_Spec := Order_Sub.fieldbyname('C_Spec').AsString; MC_CF := Order_Sub.fieldbyname('C_CF').AsString; MC_Color := Order_Sub.fieldbyname('C_Color').AsString; MC_MF := Order_Sub.fieldbyname('C_MF').AsString; MC_KZ := Order_Sub.fieldbyname('C_KZ').AsString; MC_Note := Order_Sub.fieldbyname('C_Note').AsString; MC_Unit := Order_Sub.fieldbyname('C_Unit').AsString; MSuoLv := Order_Sub.fieldbyname('SuoLv').AsString; MGcHuaNo := Order_Sub.fieldbyname('GcHuaNo').AsString; MC_EName := Order_Sub.fieldbyname('C_EName').AsString; with Order_Sub do begin DisableControls; First; while not Eof do begin if FieldByName('SSel').AsBoolean then begin Edit; Order_Sub.fieldbyname('C_Code').Value := MC_Code; Order_Sub.fieldbyname('C_Craft').Value := MC_Craft; Order_Sub.fieldbyname('C_Name').Value := MC_Name; Order_Sub.fieldbyname('C_Spec').Value := MC_Spec; Order_Sub.fieldbyname('C_CF').Value := MC_CF; Order_Sub.fieldbyname('C_Color').Value := MC_Color; Order_Sub.fieldbyname('C_MF').Value := MC_MF; Order_Sub.fieldbyname('C_KZ').Value := MC_KZ; Order_Sub.fieldbyname('C_Note').Value := MC_Note; Order_Sub.fieldbyname('C_Unit').Value := MC_Unit; Order_Sub.fieldbyname('SuoLv').Value := MSuoLv; Order_Sub.fieldbyname('GcHuaNo').Value := MGcHuaNo; Order_Sub.fieldbyname('C_EName').Value := MC_EName; Post; end; Next; end; EnableControls; end; Order_Sub.Locate('XHNO', MXHNO, []); end; procedure TfrmPurchaseConInPut.N3Click(Sender: TObject); begin // inherited; SelOKNoFiler(Tv1, False); //全弃 end; procedure TfrmPurchaseConInPut.PHKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin feel.SetFocus; end; end; procedure TfrmPurchaseConInPut.q1Click(Sender: TObject); begin // inherited; SelOKNoFiler(Tv1, True); //全选 end; procedure TfrmPurchaseConInPut.QiYunBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmPurchaseConInPut.FinishingKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Countercolor.SetFocus; end; end; procedure TfrmPurchaseConInPut.FormShow(Sender: TObject); begin inherited; readCxGrid(trim(self.Caption), Tv1, '销售合同管理'); fFlileFlag := UserDataFlag + 'HX'; InitData(); ShippMent.SetFocus; end; function TfrmPurchaseConInPut.SaveData(): Boolean; var maxno: string; fconNO, fmxType, fDate: string; begin try ADOCmd.Connection.BeginTrans; //////////////// 保存主表 ////////////////////// if Trim(FConMId) = '' then begin if GetLSNo(ADOTemp, maxno, 'CM', 'BS_Contract_Main', 3, 1) = False then raise Exception.Create('取最大号失败!'); fDate := FormatDateTime('yy', SGetServerDate(ADOTemp)); if trim(ConNo.Text) = '自动生成' then begin if GetLSNo(ADOTemp, fconNO, fDate, 'BS_Contract_Main', 4, 0) = False then raise Exception.Create('取最合同编号失败!'); if ConType.Text = '内销' then fconNO := 'N' + fconNO else fconNO := 'W' + fconNO; ConNo.Text := fconNO; end; end else begin maxno := Trim(FConMId); end; with ADOCmd do begin Close; sql.Clear; SQL.Add('select * from BS_Contract_Main where ConMId=''' + Trim(FConMId) + ''''); Open; end; with ADOCmd do begin if Trim(FConMId) = '' then begin Append; FieldByName('Filler').Value := Trim(DName); FieldByName('status').Value := '0'; end else begin Edit; FieldByName('Editer').Value := Trim(DName); FieldByName('EditTime').Value := SGetServerDateTime(ADOTemp); end; FieldByName('ConMId').Value := Trim(maxno); RTSetsavedata(ADOCmd, 'BS_Contract_Main', ScrollBox1, 2); FieldByName('BuyNo').Value := Trim(BuyName.TxtCode); FieldByName('SellNo').Value := Sellname.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('合同号重复!'); FConMId := Trim(maxno); //////////////// 保存主表 ////////////////////// /// //////////////// 保存子表 ////////////////////// with Order_Sub do begin First; while not Eof do begin maxno := Trim(Order_Sub.fieldbyname('ConSId').AsString); with ADOCmd do begin Close; SQL.Clear; sql.Add('select * from BS_Contract_Sub where ConSId=''' + Trim(maxno) + ''''); Open; end; with ADOCmd do begin if ADOCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOCmd, Tv1, Order_Sub, 'BS_Contract_Sub', 0); FieldByName('ConMId').Value := Trim(FConMId); FieldByName('ConSId').Value := Trim(maxno); Post; end; with Order_Sub do begin Edit; FieldByName('ConSId').Value := Trim(maxno); Post; end; Next; end; end; //////////////// 保存子表 ////////////////////// /// //////////////// 更新合同 ////////////////////// // with ADOCmd do // begin // close; // sql.Clear; // sql.Add('EXEC P_Con_Up_PiQty '); // sql.Add('@DataID=' + quotedstr(Trim(FConMId))); // execsql; // end; //////////////// 更新合同 ////////////////////// ADOCmd.Connection.CommitTrans; Result := True; except ADOCmd.Connection.RollbackTrans; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); Result := False; end; end; procedure TfrmPurchaseConInPut.TBSaveClick(Sender: TObject); begin ConDate.SetFocus; if TestData() = false then exit; with Order_Sub do begin First; while not Eof do begin with ADOTemp do begin close; sql.Clear; sql.Add('update Bs_Contract_Sub SET CGstatus=''1'' '); sql.Add(' where ConSId=' + quotedstr(trim(Order_Sub.fieldbyname('subid').AsString))); execsql; end; Next; end; end; if SaveData() then begin Application.MessageBox('保存成功!', '提示', 0); end; end; procedure TfrmPurchaseConInPut.v1PRTOrderQtyPropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName: string; FConQty, FConPrice, FC_Money: Double; //个数,单价,金额 begin mvalue := TcxTextEdit(Sender).EditingText; if Trim(mvalue) = '' then begin mvalue := '0'; end; FFieldName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); with Order_Sub do begin Edit; FieldByName(FFieldName).Value := Trim(mvalue); Post; FConQty := Fieldbyname('ConQty').AsFloat; FConPrice := Fieldbyname('ConPrice').AsFloat; end; FC_Money := RoundFloat(FConQty * FConPrice, 2); with Order_Sub do begin Edit; FieldByName('ConQty').Value := FConQty; FieldByName('ConPrice').Value := FConPrice; FieldByName('ConTotalAmount').Value := FC_Money; Post; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.ToolButton1Click(Sender: TObject); var i: Integer; maxno: string; begin if GetLSNo(ADOCmd, maxno, 'CS', 'BS_Contract_Sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; if Trim(ConNo.Text) = '' then begin Application.MessageBox('合同号不能为空!', '提示', 0); Exit; end; i := Order_Sub.RecordCount; //当前的dataset有多少行记录 i := i + 1; CopyAddRow(Tv1, Order_Sub); with Order_Sub do begin Edit; FieldByName('SSEL').Value := FALSE; FieldByName('SerialNo').Value := i; FieldByName('ConSId').Value := maxno; // FieldByName('C_Color').Value := ''; FieldByName('ConQty').Value := null; Post; end; SetXH(); end; procedure TfrmPurchaseConInPut.ToolButton2Click(Sender: TObject); begin if Order_Sub.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; while Order_Sub.Locate('SSel', True, []) do begin with ADOTemp do begin Close; sql.Clear; sql.Add('select * from Trade_Plan_Sub where ConSId=''' + Trim(Order_Sub.fieldbyname('ConSId').AsString) + ''''); open; end; if ADOTemp.IsEmpty = false then begin application.MessageBox('该明细已经在生产!', '提示信息'); exit; end; if Trim(Order_Sub.fieldbyname('ConSId').AsString) <> '' then begin with ADOCmd do begin Close; sql.Clear; sql.Add('delete BS_Contract_Sub where ConSId=''' + Trim(Order_Sub.fieldbyname('ConSId').AsString) + ''''); ExecSQL; end; end; Order_Sub.Delete; end; SetXH(); end; procedure TfrmPurchaseConInPut.ToolButton3Click(Sender: TObject); begin WriteCxGrid(trim(self.Caption), Tv1, '销售合同管理'); end; procedure TfrmPurchaseConInPut.ToolButton4Click(Sender: TObject); var FConMainId, FMPRTCode: string; maxno: string; S: Integer; begin // inherited; try frmTradeSalesContractSel := TfrmTradeSalesContractSel.Create(Application); with frmTradeSalesContractSel do begin FLX := '采购合同'; // fconNO := self.ConNo.Text; // fC_Code := self.C_Code.Text; if ShowModal = 1 then begin S := self.Order_Sub.RecordCount; while CDS_1.locate('SSel', true, []) do begin // if self.Order_Sub.locate('ConSId', trim(CDS_1.Fieldbyname('ConSId').AsString), []) then // begin // CDS_1.Edit; // CDS_1.fieldbyname('SSel').value := false; // continue; // end; if GetLSNo(ADOCmd, maxno, 'CS', 'BS_Contract_Sub', 4, 1) = False then begin ADOCmd.Connection.RollbackTrans; Application.MessageBox('取子流水号失败!', '提示', 0); Exit; end; // self.ConNo.text:=trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString); self.BuyConNoHZ.Text := Trim(frmTradeSalesContractSel.CDS_1.fieldbyname('BuyConNo').AsString); with self.ADOTemp do begin Filtered := False; Close; sql.Clear; sql.add('select SL=(select count(contractNO) from Bs_Contract_Main A where A.contractNO like ''' + trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString) + '%'' and A.ConType in (''采购'',''加工'',''采购坯布'',''采购成品布'',''采购辅料'',''绣花'',''印染'',''印花''))+1'); // showmessage(sql.text); Open; end; self.contractNO.Text := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString) + '-' + trim(ADOTemp.Fieldbyname('SL').AsString); S := S + 1; with self.Order_Sub do begin Append; FieldByName('SSel').Value := false; Fieldbyname('SerialNo').value := S; // Fieldbyname('ConNo').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString); // Fieldbyname('ConMId').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConMId').AsString); // Fieldbyname('ConSId').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConSId').AsString); // Fieldbyname('C_Pattern').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Pattern').AsString); Fieldbyname('subid').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConSId').AsString); Fieldbyname('ConSId').value := Trim(maxno); Fieldbyname('C_BuyConNo').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('BuyConNo').AsString); // Fieldbyname('ConQty').value := frmTradeSalesContractSel.CDS_1.Fieldbyname('ConQty').AsFloat; Fieldbyname('C_Code').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Code').AsString); Fieldbyname('C_Name').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Name').AsString); Fieldbyname('C_ColorNo').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_ColorNo').AsString); Fieldbyname('C_Color').value := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Color').AsString); Fieldbyname('ConUnit').AsString := trim(frmTradeSalesContractSel.CDS_1.fieldbyname('ConUnit').AsString); Fieldbyname('C_Spec').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Spec').AsString); Fieldbyname('C_Composition').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Composition').AsString); Fieldbyname('C_Width').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Width').AsString); Fieldbyname('C_GramWeight').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_GramWeight').AsString); Fieldbyname('ConSNote').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConSNote').AsString); Fieldbyname('C_EName').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_EName').AsString); Fieldbyname('C_StyleNo').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_StyleNo').AsString); Fieldbyname('C_Pattern').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Pattern').AsString); Fieldbyname('C_ConNo').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConNo').AsString); Fieldbyname('C_Fabric').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('C_Fabric').AsString); Fieldbyname('C_curtainQTY').AsString := trim(frmTradeSalesContractSel.CDS_1.Fieldbyname('ConQty').AsString); Post; end; CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; end; end; end; finally frmTradeSalesContractSel.Free; end; end; procedure TfrmPurchaseConInPut.TorqueKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin PH.SetFocus; end; end; procedure TfrmPurchaseConInPut.TrimmingKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Torque.SetFocus; end; end; procedure TfrmPurchaseConInPut.Tv1Column19PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin // inherited; frmClothInfoSel := TfrmClothInfoSel.Create(self); with frmClothInfoSel do begin FCG := '采购'; if showmodal = 1 then begin with ADOQueryTree do begin Close; SQL.Clear; SQL.Add('select * from BS_Cloth_Type where CTID=' + quotedstr(frmClothInfoSel.CDS_1.fieldbyname('CTID').asstring)); // SQL.Add('order by CTName'); Open; end; Order_Sub.Edit; // if (Trim(ADOQueryTree.fieldbyname('CTParent').AsString) = 'CT2401040008') then // begin // Order_Sub.fieldbyname('C_goods').Value := '辅料'; // end; // if (Trim(ADOQueryTree.fieldbyname('CTParent').AsString) = 'CT2401040009') then // begin // Order_Sub.fieldbyname('C_goods').Value := '面料'; // end; Order_Sub.fieldbyname('C_goods').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Name').asstring + frmClothInfoSel.CDS_1.fieldbyname('C_Accessories').asstring + frmClothInfoSel.CDS_1.fieldbyname('C_mlName').asstring; Order_Sub.fieldbyname('ConPrice').Value := frmClothInfoSel.CDS_1.fieldbyname('Price').asstring; Order_Sub.Post; end; free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.BuyNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '我司'; if ShowModal = 1 then begin self.BuyName.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.BuyName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); self.firmname.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoName').AsString); self.firmaddress.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmPurchaseConInPut.clientKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Leadtime.SetFocus; end; end; procedure TfrmPurchaseConInPut.CountercolorKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Trimming.SetFocus; end; end; procedure TfrmPurchaseConInPut.DyeingKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Finishing.SetFocus; end; end; procedure TfrmPurchaseConInPut.EattritionKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin client.SetFocus; end; end; procedure TfrmPurchaseConInPut.ErodusKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Eattrition.SetFocus; end; end; procedure TfrmPurchaseConInPut.ExchangeRateKeyPress(Sender: TObject; var Key: Char); begin if not (((Key >= '0') and (Key <= '9')) or (Key = '.') or (Key = #8)) then begin Key := #0; end else if (pos('.', TEdit(Sender).text) <> 0) then begin if Key = '.' then begin Key := #0; end; end; end; procedure TfrmPurchaseConInPut.feelKeyPress(Sender: TObject; var Key: Char); begin // inherited; if Key = #13 then begin Shrinkage.SetFocus; end; end; procedure TfrmPurchaseConInPut.BuyNameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmPurchaseConInPut.v1Column4PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'MPRTCodeName'; flagname := '产品名称'; if ShowModal = 1 then begin Order_Sub.Edit; Order_Sub.fieldbyname('PRTCodeName').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); Order_Sub.fieldbyname('PRTCode').Value := Trim(ClientDataSet1.fieldbyname('ZDYNo').AsString); Order_Sub.Post; end; end; finally frmZDYHelp.Free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.v1Column6PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'C_MF'; flagname := '门幅信息'; if ShowModal = 1 then begin Order_Sub.Edit; Order_Sub.fieldbyname('C_MF').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); // Order_Sub.fieldbyname('PRTCode').Value:=Trim(ClientDataSet1.fieldbyname('ZDYNo').AsString); Order_Sub.Post; end; end; finally frmZDYHelp.Free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.v1Column7PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'C_KZ'; flagname := '克重信息'; if ShowModal = 1 then begin Order_Sub.Edit; Order_Sub.fieldbyname('C_KZ').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); // Order_Sub.fieldbyname('PRTCode').Value:=Trim(ClientDataSet1.fieldbyname('ZDYNo').AsString); Order_Sub.Post; end; end; finally frmZDYHelp.Free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.v1Column10PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); var MCYNo: string; begin frmClothInfoSel := TfrmClothInfoSel.Create(self); with frmClothInfoSel do begin if showmodal = 1 then begin Order_Sub.Edit; Order_Sub.fieldbyname('C_Code').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Code').asstring; Order_Sub.fieldbyname('C_Name').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Name').asstring; Order_Sub.fieldbyname('C_EName').Value := frmClothInfoSel.CDS_1.fieldbyname('C_EName').asstring; Order_Sub.fieldbyname('C_Spec').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Spec').asstring; Order_Sub.fieldbyname('C_Composition').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Composition').asstring; Order_Sub.fieldbyname('C_Color').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Color').asstring; Order_Sub.fieldbyname('C_Width').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Width').asstring; Order_Sub.fieldbyname('C_GramWeight').Value := frmClothInfoSel.CDS_1.fieldbyname('C_GramWeight').asstring; Order_Sub.Post; end; free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmPurchaseConInPut.SalesmanBtnUpClick(Sender: TObject); var fsj: string; FWZ: Integer; begin fsj := Trim(TEdit(Sender).Hint); FWZ := Pos('/', fsj); try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := Copy(fsj, 1, FWZ - 1); flagname := Copy(fsj, FWZ + 1, Length(fsj) - FWZ); if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmPurchaseConInPut.v1Column15PropertiesEditValueChanged(Sender: TObject); var mvalue: string; begin mvalue := TcxTextEdit(Sender).EditingText; if Trim(mvalue) = '' then begin mvalue := '0'; end; with Order_Sub do begin Edit; FieldByName('YongJinPrice').Value := mvalue; FieldByName('YongJin').Value := FieldByName('YongJinPrice').AsFloat * FieldByName('PRTOrderQty').AsFloat; Post; end; end; procedure TfrmPurchaseConInPut.SellNameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; FLX := '采购合同'; if ShowModal = 1 then begin self.Sellname.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.Sellname.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); self.address.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAddress').AsString); self.CoName.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoName').AsString); self.Phone.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Phone').AsString); end; end; finally frmCompanySel.Free; end; end; end.