unit U_ClothInfoInput; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, ADODB, DBClient, cxGridLevel, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses, cxControls, cxGridCustomView, cxGrid, ComCtrls, ToolWin, cxGridCustomPopupMenu, cxGridPopupMenu, cxTextEdit, cxButtonEdit, StdCtrls, ExtCtrls, cxCurrencyEdit, BtnEdit, U_BaseList, cxLookAndFeels, cxLookAndFeelPainters, dxSkinsCore, dxSkinsDefaultPainters, cxNavigator, dxDateRanges, dxBarBuiltInMenu, cxCheckBox, cxDropDownEdit, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations; type TfrmClothInfoInput = class(TForm) ToolBar1: TToolBar; ToolButton1: TToolButton; TBClose: TToolButton; ADOQueryCmd: TADOQuery; ADOQueryTemp: TADOQuery; ScrollBox1: TScrollBox; ToolButton6: TToolButton; CDS_1: TClientDataSet; DS_1: TDataSource; GPM_1: TcxGridPopupMenu; Label17: TLabel; mlPrice: TEdit; Label18: TLabel; mlSellname: TBtnEditC; Label19: TLabel; C_mlCode: TEdit; Label20: TLabel; C_mlColor: TEdit; Label21: TLabel; C_Accessories1: TEdit; Label23: TLabel; C_flCode: TEdit; C_mlName: TEdit; Label24: TLabel; Label25: TLabel; Label26: TLabel; C_mlWidth: TBtnEditC; C_mlGramWeight: TBtnEditC; C_flSpec: TBtnEditC; Label27: TLabel; ADOTemp: TADOQuery; Label28: TLabel; Label29: TLabel; flPrice: TEdit; flSellname: TBtnEditC; Processprice1: TEdit; Label37: TLabel; C_FLStyleNo: TEdit; Label38: TLabel; C_FLBarcodes: TEdit; C_Accessories: TMemo; Panel2: TPanel; Label1: TLabel; Label5: TLabel; Label15: TLabel; Label22: TLabel; Label2: TLabel; Label4: TLabel; Label3: TLabel; Label7: TLabel; Label6: TLabel; Label10: TLabel; Label11: TLabel; Label13: TLabel; Label14: TLabel; Label30: TLabel; Label32: TLabel; Label33: TLabel; Label39: TLabel; Label40: TLabel; C_Code: TEdit; C_Name: TEdit; C_Color: TEdit; C_Width: TBtnEditC; C_GramWeight: TBtnEditC; C_Composition: TBtnEditC; BCIID: TEdit; C_Spec: TBtnEditC; C_FromName: TBtnEditC; C_description: TMemo; C_ColorN: TEdit; C_remark: TMemo; C_StyleNo: TEdit; C_Barcodes: TEdit; C_GBmanner: TBtnEditC; C_MKSL: TEdit; Panel1: TPanel; GroupBox1: TGroupBox; GroupBox2: TGroupBox; GroupBox3: TGroupBox; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; v1XHNo: TcxGridDBColumn; Tv1Column1: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; cxGrid1Level1: TcxGridLevel; ToolBar2: TToolBar; ToolButton4: TToolButton; ToolButton2: TToolButton; ToolButton3: TToolButton; ToolButton5: TToolButton; cxGrid3: TcxGrid; TV3: TcxGridDBTableView; cxGridDBColumn6: TcxGridDBColumn; cxGridDBColumn7: TcxGridDBColumn; cxGridDBColumn8: TcxGridDBColumn; cxGridDBColumn9: TcxGridDBColumn; cxGridLevel2: TcxGridLevel; cxGrid4: TcxGrid; TV4: TcxGridDBTableView; cxGridDBColumn10: TcxGridDBColumn; cxGridDBColumn11: TcxGridDBColumn; cxGridDBColumn12: TcxGridDBColumn; cxGridDBColumn13: TcxGridDBColumn; cxGridLevel3: TcxGridLevel; TV4Column1: TcxGridDBColumn; GroupBox4: TGroupBox; ToolBar3: TToolBar; ToolButton8: TToolButton; ToolButton9: TToolButton; ToolButton10: TToolButton; ToolBar4: TToolBar; ToolButton12: TToolButton; ToolButton13: TToolButton; ToolButton14: TToolButton; ToolBar5: TToolBar; ToolButton16: TToolButton; ToolButton17: TToolButton; ToolButton18: TToolButton; GPM_2: TcxGridPopupMenu; CDS_2: TClientDataSet; DS_2: TDataSource; TV3Column1: TcxGridDBColumn; GPM_3: TcxGridPopupMenu; CDS_3: TClientDataSet; DS_3: TDataSource; GPM_4: TcxGridPopupMenu; CDS_4: TClientDataSet; DS_4: TDataSource; C_CJsize: TEdit; ToolButton7: TToolButton; cxGrid2: TcxGrid; TV2: TcxGridDBTableView; cxGridDBColumn1: TcxGridDBColumn; cxGridDBColumn2: TcxGridDBColumn; cxGridDBColumn3: TcxGridDBColumn; cxGridDBColumn4: TcxGridDBColumn; cxGridDBColumn5: TcxGridDBColumn; cxGridDBColumn14: TcxGridDBColumn; cxGridDBColumn15: TcxGridDBColumn; cxGridDBColumn16: TcxGridDBColumn; cxGridLevel1: TcxGridLevel; ToolButton11: TToolButton; TV2Column1: TcxGridDBColumn; TV2Column2: TcxGridDBColumn; TV3Column2: TcxGridDBColumn; Label8: TLabel; C_Pattern: TEdit; Label9: TLabel; C_ECOLOR: TEdit; Label12: TLabel; C_LSNO: TEdit; Label16: TLabel; FNFKU: TEdit; procedure FormShow(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure CYColorKeyPress(Sender: TObject; var Key: Char); procedure CYJGGYBtnDnClick(Sender: TObject); procedure C_WidthBtnDnClick(Sender: TObject); procedure C_WidthBtnUpClick(Sender: TObject); procedure ToolButton6Click(Sender: TObject); procedure C_FromNameBtnUpClick(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure SetXH(ACDS: TClientDataSet); procedure ToolButton3Click(Sender: TObject); procedure Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure C_clientBtnDnClick(Sender: TObject); procedure mlSellnameBtnDnClick(Sender: TObject); procedure mlSellnameBtnUpClick(Sender: TObject); procedure C_mlWidthBtnDnClick(Sender: TObject); procedure flSellnameBtnDnClick(Sender: TObject); procedure flSellnameBtnUpClick(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure Tv1Column5PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure Tv1Column7PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure FormResize(Sender: TObject); procedure ToolButton16Click(Sender: TObject); procedure ToolButton17Click(Sender: TObject); procedure ToolButton12Click(Sender: TObject); procedure ToolButton13Click(Sender: TObject); procedure ToolButton7Click(Sender: TObject); procedure ToolButton10Click(Sender: TObject); procedure ToolButton14Click(Sender: TObject); procedure ToolButton18Click(Sender: TObject); procedure ToolButton9Click(Sender: TObject); procedure ToolButton8Click(Sender: TObject); procedure ToolButton11Click(Sender: TObject); private canshu1: string; Fint: Integer; procedure InitGrid(); function SaveData(): Boolean; { Private declarations } public FBCIID, FCTID: string; CopyInt: Integer; { Public declarations } end; var frmClothInfoInput: TfrmClothInfoInput; implementation uses U_DataLink, U_RTFun, U_iniParam, U_ZDYHelp, U_AttachmentUpload, U_ClothInfoSel, U_CompanySel, U_ProductInfoSel, U_DyeCardGlideEdit; {$R *.dfm} procedure TfrmClothInfoInput.mlSellnameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmClothInfoInput.mlSellnameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; // if Self.FAuthority = '录入' then // FAuthority := '理单业务'; if ShowModal = 1 then begin self.mlSellname.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.mlSellname.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); // self.SalesId.Text := Trim(frmCompanySel.CDS_1.fieldbyname('SalesId').AsString); // self.Saleser.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Saleser').AsString); // self.TallyId.Text := Trim(frmCompanySel.CDS_1.fieldbyname('TallyId').AsString); // self.Tallyer.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Tallyer').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmClothInfoInput.SetXH(ACDS: TClientDataSet); var i: Integer; begin if not Assigned(ACDS) then Exit; // 防空指针 // 第一段:填充临时序号 XHNoTemp with ACDS do begin First; i := 1; while not Eof do begin Edit; FieldByName('XHNoTemp').AsInteger := i; Post; Inc(i); Next; end; end; // 第二段:把临时序号赋值给正式SerialNo,重建索引排序 with ACDS do begin IndexFieldNames := ''; // 清空原有排序 First; i := 1; while not Eof do begin Edit; FieldByName('SerialNo').AsInteger := FieldByName('XHNoTemp').AsInteger; Post; Inc(i); Next; end; IndexFieldNames := 'SerialNo'; // 按序号排序 end; end; procedure TfrmClothInfoInput.InitGrid(); begin with ADOTemp do begin Close; SQL.Clear; SQL.Add('select * from SY_User where UserName=' + quotedstr(Trim(DName))); Open; end; with ADOQueryTemp do begin Close; SQL.Clear; SQL.Add('select * from BS_Cloth_Info where BCIID=''' + Trim(FBCIID) + ''''); Open; end; SCSHData(ADOQueryTemp, panel2, 2); SCSHData(ADOQueryTemp, panel2, 0); // C_FromName.TxtCode := Trim(ADOQueryTemp.fieldbyname('FromBCIID').AsString); // C_FromName.Text := Trim(ADOQueryTemp.fieldbyname('C_FromName').AsString); with ADOQueryTemp do begin Close; SQL.Clear; sql.Add(' select * from Bs_Cloth_Process '); sql.Add(' where BCIID=''' + Trim(FBCIID) + ''''); sql.Add('and BCTYPE=''辅料'''); sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOQueryTemp, CDS_1); SInitCDSData(ADOQueryTemp, CDS_1); with ADOQueryTemp do begin Close; SQL.Clear; sql.Add(' select * from Bs_Cloth_Process '); sql.Add(' where BCIID=''' + Trim(FBCIID) + ''''); sql.Add('and BCTYPE=''面料'''); sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOQueryTemp, CDS_2); SInitCDSData(ADOQueryTemp, CDS_2); with ADOQueryTemp do begin Close; SQL.Clear; sql.Add(' select * from Bs_Process '); sql.Add(' where BCIID=''' + Trim(FBCIID) + ''''); sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOQueryTemp, CDS_3); SInitCDSData(ADOQueryTemp, CDS_3); with ADOQueryTemp do begin Close; SQL.Clear; sql.Add(' select * from Bs_Cloth_Cost '); sql.Add(' where BCIID=''' + Trim(FBCIID) + ''''); sql.Add(' order by SerialNo '); Open; end; SCreateCDS(ADOQueryTemp, CDS_4); SInitCDSData(ADOQueryTemp, CDS_4); end; procedure TfrmClothInfoInput.FormResize(Sender: TObject); begin groupbox2.Height := ScrollBox1.Height div 3; groupbox3.Height := ScrollBox1.Height div 3; groupbox4.Height := ScrollBox1.Height - groupbox2.Height; end; procedure TfrmClothInfoInput.FormShow(Sender: TObject); begin ReadCxGrid(self.Caption + 'TV1', Tv1, '样品辅料管理'); InitGrid(); if CopyInt = 1 then begin FBCIID := ''; BCIID.text := ''; C_Code.text := ''; ClearCDSColumn(cds_3, ['psid']); ClearCDSColumn(cds_1, ['bcpid']); ClearCDSColumn(cds_4, ['bccid']); ClearCDSColumn(cds_2, ['bcpid']); end; end; procedure TfrmClothInfoInput.TBCloseClick(Sender: TObject); begin Close; end; function TfrmClothInfoInput.SaveData(): Boolean; var MaxBCIID, MaxBCPID, MAXBCSID, MaxBCGID, MaxBCCID: string; begin try ADOQueryCmd.Connection.BeginTrans; //////////////// 保存主表 ////////////////////// if Trim(FBCIID) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCIID, 'Y', 'BS_Cloth_Info', 4, 1) = False then begin Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; BCIID.Text := trim(MaxBCIID); end else begin MaxBCIID := Trim(FBCIID); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from BS_Cloth_Info where BCIID=''' + Trim(FBCIID) + ''''); Open; end; with ADOQueryCmd do begin if Trim(FBCIID) = '' then begin Append; FieldByName('CTID').Value := Trim(FCTID); FieldByName('FILLID').Value := Trim(DCode); FieldByName('FILLER').Value := Trim(DName); FieldByName('FILLTIME').Value := SGetServerDateTime(ADOQueryTemp); end else begin Edit; FieldByName('EDITER').Value := Trim(DName); FieldByName('EDITTIME').Value := SGetServerDateTime(ADOQueryTemp); end; FieldByName('BCIID').Value := Trim(MaxBCIID); if trim(C_Code.Text) = '' then C_Code.Text := Trim(MaxBCIID); RTSetsavedata(ADOQueryCmd, 'BS_Cloth_Info', panel2, 2); Post; end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('delete BS_Cloth_Info_Link where ToID=''' + Trim(MaxBCIID) + ''''); ExecSQL; end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from BS_Cloth_Info_Link where 1=2'); Open; end; with ADOQueryCmd do begin Append; FieldByName('ToID').Value := Trim(MaxBCIID); FieldByName('FromID').Value := Trim(C_FromName.TxtCode); Post; end; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('select count(*) as AA from BS_Cloth_Info where C_Code=''' + Trim(C_Code.Text) + ''''); Open; if FieldByName('AA').AsInteger > 1 then begin ADOQueryCmd.Connection.RollbackTrans; Result := False; Application.MessageBox('编号重复!', '提示', 0); Exit; end; end; //////////////// 保存主表 ////////////////////// // ////////////////// 保存原料表 ////////////////////// with CDS_2 do begin First; while not Eof do begin if Trim(CDS_2.fieldbyname('BCPID').AsString) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Bs_Cloth_Process', 4, 1) = False then begin Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; end else begin MaxBCPID := Trim(CDS_2.fieldbyname('BCPID').AsString); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Bs_Cloth_Process where BCPID=''' + Trim(MaxBCPID) + ''''); Open; end; with ADOQueryCmd do begin if ADOQueryCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOQueryCmd, Tv2, CDS_2, 'Bs_Cloth_Process', 0); FieldByName('BCPID').Value := Trim(MaxBCPID); FieldByName('BCIID').Value := Trim(MaxBCIID); FieldByName('BCtype').Value := Trim('面料'); Post; end; with CDS_2 do begin Edit; FieldByName('BCPID').Value := Trim(MaxBCPID); Post; end; Next; end; end; ////////////////// 保存原料表 ////////////////////// ////////////////// 保存工序表 ////////////////////// with CDS_3 do begin First; while not Eof do begin if Trim(CDS_3.fieldbyname('psid').AsString) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Bs_Process', 4, 1) = False then begin Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; end else begin MaxBCPID := Trim(CDS_3.fieldbyname('psid').AsString); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Bs_Process where psid=''' + Trim(MaxBCPID) + ''''); Open; end; with ADOQueryCmd do begin if ADOQueryCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOQueryCmd, Tv3, CDS_3, 'Bs_Process', 0); FieldByName('psid').Value := Trim(MaxBCPID); FieldByName('BCIID').Value := Trim(MaxBCIID); Post; end; with CDS_3 do begin Edit; FieldByName('psid').Value := Trim(MaxBCPID); Post; end; Next; end; end; ////////////////// 保存工序表 ////////////////////// //////////////// 保存费用表 ////////////////////// with CDS_4 do begin First; while not Eof do begin if Trim(CDS_4.fieldbyname('BCCID').AsString) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCCID, 'S', 'Bs_Cloth_Cost', 4, 1) = False then begin Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; end else begin MaxBCCID := Trim(CDS_4.fieldbyname('BCCID').AsString); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Bs_Cloth_Cost where BCCID=''' + Trim(MaxBCCID) + ''''); Open; end; with ADOQueryCmd do begin if ADOQueryCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOQueryCmd, Tv4, CDS_4, 'Bs_Cloth_Cost', 0); FieldByName('BCCID').Value := Trim(MaxBCCID); FieldByName('BCIID').Value := Trim(MaxBCIID); Post; end; with CDS_4 do begin Edit; FieldByName('BCCID').Value := Trim(MaxBCCID); Post; end; Next; end; end; //////////////// 保存费用表 ////////////////////// // // ////////////////// 保存辅料表 ////////////////////// with CDS_1 do begin First; while not Eof do begin if Trim(CDS_1.fieldbyname('BCPID').AsString) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Bs_Cloth_Process', 4, 1) = False then begin Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; end else begin MaxBCPID := Trim(CDS_1.fieldbyname('BCPID').AsString); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Bs_Cloth_Process where BCPID=''' + Trim(MaxBCPID) + ''''); Open; end; with ADOQueryCmd do begin if ADOQueryCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOQueryCmd, Tv1, CDS_1, 'Bs_Cloth_Process', 0); FieldByName('BCPID').Value := Trim(MaxBCPID); FieldByName('BCIID').Value := Trim(MaxBCIID); FieldByName('BCtype').Value := Trim('辅料'); Post; end; with CDS_1 do begin Edit; FieldByName('BCPID').Value := Trim(MaxBCPID); Post; end; Next; end; end; ////////////////// 保存辅料表 ////////////////////// /// /// /// ADOQueryCmd.Connection.CommitTrans; FBCIID := MaxBCIID; Result := True; except Result := False; ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('保存失败!', '提示', 0); end; end; procedure TfrmClothInfoInput.CYJGGYBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; end; procedure TfrmClothInfoInput.ToolButton10Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV2', Tv2, '样品辅料管理'); end; procedure TfrmClothInfoInput.ToolButton11Click(Sender: TObject); var S: Integer; begin try frmProductInfoSel := TfrmProductInfoSel.Create(Application); with frmProductInfoSel do begin FSTKName := '面料'; if ShowModal = 1 then begin S := self.CDS_2.RecordCount; while CDS_1.locate('SSel', true, []) do begin S := S + 1; with self.CDS_2 do begin Append; Fieldbyname('SerialNo').value := S; self.CDS_2.fieldbyname('C_flCode').Value := frmProductInfoSel.CDS_1.fieldbyname('p_Code').asstring; // self.CDS_1.fieldbyname('C_Accessories').Value := frmProductInfoSel.CDS_1.fieldbyname('C_Accessories').asstring; // self.CDS_1.fieldbyname('flSellname').Value := frmProductInfoSel.CDS_1.fieldbyname('Sellname').asstring; self.CDS_2.fieldbyname('Price').Value := frmProductInfoSel.CDS_1.fieldbyname('Price').AsFloat; self.CDS_2.fieldbyname('C_Accessories').Value := frmProductInfoSel.CDS_1.fieldbyname('p_name').asstring; // self.CDS_1.fieldbyname('flcategory').Value := frmProductInfoSel.CDS_1.fieldbyname('CTName').asstring; Post; end; CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; end; end; end; finally frmProductInfoSel.Free; end; end; procedure TfrmClothInfoInput.ToolButton12Click(Sender: TObject); var i: Integer; begin i := CDS_4.RecordCount; //当前的dataset有多少行记录 i := i + 1; with CDS_4 do begin APPEND; FieldByName('SerialNo').Value := i; Post; end; SetXH(CDS_4); end; procedure TfrmClothInfoInput.ToolButton13Click(Sender: TObject); begin if CDS_4.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; if Trim(CDS_4.fieldbyname('bccid').AsString) <> '' then begin with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Bs_Cloth_Cost where bccid=''' + Trim(CDS_4.fieldbyname('bccid').AsString) + ''''); ExecSQL; end; end; CDS_4.Delete; SetXH(CDS_4); end; procedure TfrmClothInfoInput.ToolButton14Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV4', Tv4, '样品辅料管理'); end; procedure TfrmClothInfoInput.ToolButton16Click(Sender: TObject); var i: Integer; begin i := CDS_3.RecordCount; //当前的dataset有多少行记录 i := i + 1; with CDS_3 do begin APPEND; FieldByName('SerialNo').Value := i; Post; end; SetXH(CDS_3); end; procedure TfrmClothInfoInput.ToolButton17Click(Sender: TObject); begin if CDS_3.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; if Trim(CDS_3.fieldbyname('PSID').AsString) <> '' then begin with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Bs_Process where PSID=''' + Trim(CDS_3.fieldbyname('PSID').AsString) + ''''); ExecSQL; end; end; CDS_3.Delete; SetXH(CDS_3); end; procedure TfrmClothInfoInput.ToolButton18Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV3', Tv3, '样品辅料管理'); end; procedure TfrmClothInfoInput.ToolButton1Click(Sender: TObject); var MC_Code: string; begin if C_Name.Text = '' then begin Application.MessageBox('产品名称不能为空!', '提示', 0); Exit; end; if C_code.Text = '' then begin Application.MessageBox('品番不能为空!', '提示', 0); Exit; end; if C_cjsize.Text = '' then begin Application.MessageBox('尺寸不能为空!', '提示', 0); Exit; end; if trim(C_Code.Text) = '' then begin if GetLSNo(ADOQueryCmd, MC_Code, 'C', 'BS_Cloth_Info', 4, 0) = False then begin Application.MessageBox('取最成品编号失败!', '提示', 0); Exit; end; C_Code.Text := MC_Code; end; // SetXH(); if SaveData() then begin Application.MessageBox('保存成功!', '提示', 0); ModalResult := 1; end; end; procedure TfrmClothInfoInput.ToolButton2Click(Sender: TObject); var i: Integer; begin i := CDS_1.RecordCount; //当前的dataset有多少行记录 i := i + 1; CopyAddRow(Tv1, CDS_1); with CDS_1 do begin Edit; FieldByName('SerialNo').Value := i; FieldByName('FtyWastage').Value := 0; FieldByName('C_Accessories').Value := null; FieldByName('flSellname').Value := null; FieldByName('Price').Value := 0; FieldByName('flcategory').Value := null; Post; end; SetXH(CDS_1); end; procedure TfrmClothInfoInput.ToolButton3Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; if Trim(CDS_1.fieldbyname('BCPID').AsString) <> '' then begin with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Bs_Cloth_Process where BCPID=''' + Trim(CDS_1.fieldbyname('BCPID').AsString) + ''''); ExecSQL; end; end; CDS_1.Delete; SetXH(CDS_1); end; procedure TfrmClothInfoInput.ToolButton4Click(Sender: TObject); var S: Integer; begin try frmProductInfoSel := TfrmProductInfoSel.Create(Application); with frmProductInfoSel do begin FSTKName := '原料'; if ShowModal = 1 then begin S := self.CDS_1.RecordCount; while CDS_1.locate('SSel', true, []) do begin S := S + 1; with self.CDS_1 do begin Append; Fieldbyname('SerialNo').value := S; self.CDS_1.fieldbyname('C_flCode').Value := frmProductInfoSel.CDS_1.fieldbyname('p_Code').asstring; // self.CDS_1.fieldbyname('C_Accessories').Value := frmProductInfoSel.CDS_1.fieldbyname('C_Accessories').asstring; // self.CDS_1.fieldbyname('flSellname').Value := frmProductInfoSel.CDS_1.fieldbyname('Sellname').asstring; self.CDS_1.fieldbyname('Price').Value := frmProductInfoSel.CDS_1.fieldbyname('Price').AsFloat; self.CDS_1.fieldbyname('C_Accessories').Value := frmProductInfoSel.CDS_1.fieldbyname('p_name').asstring; // self.CDS_1.fieldbyname('flcategory').Value := frmProductInfoSel.CDS_1.fieldbyname('CTName').asstring; Post; end; CDS_1.Edit; CDS_1.fieldbyname('SSel').value := false; end; end; end; finally frmProductInfoSel.Free; end; // try // frmClothInfoSel := TfrmClothInfoSel.Create(Application); // with frmClothInfoSel do // begin // FFL := '辅料'; // if ShowModal = 1 then // begin // S := self.CDS_1.RecordCount; // while CDS_1.locate('SSel', true, []) do // // begin // S := S + 1; // with self.CDS_1 do // begin // Append; // Fieldbyname('SerialNo').value := S; // self.CDS_1.fieldbyname('C_flCode').Value := frmClothInfoSel.CDS_1.fieldbyname('C_flCode').asstring; // self.CDS_1.fieldbyname('C_Accessories').Value := frmClothInfoSel.CDS_1.fieldbyname('C_Accessories').asstring; // self.CDS_1.fieldbyname('flSellname').Value := frmClothInfoSel.CDS_1.fieldbyname('Sellname').asstring; // self.CDS_1.fieldbyname('Price').Value := frmClothInfoSel.CDS_1.fieldbyname('Price').AsFloat; // self.CDS_1.fieldbyname('flcategory').Value := frmClothInfoSel.CDS_1.fieldbyname('CTName').asstring; // Post; // end; // CDS_1.Edit; // CDS_1.fieldbyname('SSel').value := false; // end; //// Next; // end; // end; // finally // frmClothInfoSel.Free; // end; end; procedure TfrmClothInfoInput.ToolButton5Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV1', Tv1, '样品辅料管理'); end; procedure TfrmClothInfoInput.C_FromNameBtnUpClick(Sender: TObject); begin try frmClothInfoSel := TfrmClothInfoSel.Create(Application); with frmClothInfoSel do begin FCTType := '坯布'; if ShowModal = 1 then begin C_FromName.TxtCode := Trim(CDS_1.fieldbyname('BCIID').AsString); C_FromName.Text := Trim(CDS_1.fieldbyname('C_Name').AsString); end; end; finally frmClothInfoSel.Free; end; end; procedure TfrmClothInfoInput.C_mlWidthBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := '' end; procedure TfrmClothInfoInput.C_clientBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmClothInfoInput.CYColorKeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then begin Key := #0; SelectNext(ActiveControl as TWinControl, True, True); end; end; procedure TfrmClothInfoInput.C_WidthBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmClothInfoInput.C_WidthBtnUpClick(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 TfrmClothInfoInput.flSellnameBtnDnClick(Sender: TObject); begin TBtnEditC(Sender).Text := ''; TBtnEditC(Sender).TxtCode := ''; end; procedure TfrmClothInfoInput.flSellnameBtnUpClick(Sender: TObject); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; // if Self.FAuthority = '录入' then // FAuthority := '理单业务'; if ShowModal = 1 then begin self.flSellname.TxtCode := Trim(frmCompanySel.CDS_1.fieldbyname('CoCode').AsString); self.flSellname.Text := Trim(frmCompanySel.CDS_1.fieldbyname('CoAbbrName').AsString); // self.SalesId.Text := Trim(frmCompanySel.CDS_1.fieldbyname('SalesId').AsString); // self.Saleser.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Saleser').AsString); // self.TallyId.Text := Trim(frmCompanySel.CDS_1.fieldbyname('TallyId').AsString); // self.Tallyer.Text := Trim(frmCompanySel.CDS_1.fieldbyname('Tallyer').AsString); end; end; finally frmCompanySel.Free; end; end; procedure TfrmClothInfoInput.ToolButton6Click(Sender: TObject); begin if trim(C_Code.Text) = '' then Exit; try frmAttachmentUpload := TfrmAttachmentUpload.Create(Application); with frmAttachmentUpload do begin FEditAuthority := True; fkeyNO := trim(C_Code.Text); fType := '产品品档案'; if ShowModal = 1 then begin end; end; finally frmAttachmentUpload.Free; end; end; procedure TfrmClothInfoInput.ToolButton7Click(Sender: TObject); begin try frmDyeCardGlideEdit := TfrmDyeCardGlideEdit.Create(Application); with frmDyeCardGlideEdit do begin fbciid := self.FBCIID; if ShowModal = 1 then begin with frmDyeCardGlideEdit.CDS_Glide do begin First; while not Eof do begin with SELF.CDS_3 do begin APPEND; FIELDBYNAME('SerialNo').ASSTRING := frmDyeCardGlideEdit.CDS_Glide.FieldByName('SerialNo').AsString; CDS_3.FIELDBYNAME('psname').ASSTRING := frmDyeCardGlideEdit.CDS_Glide.FieldByName('psname').AsString; CDS_3.FIELDBYNAME('pstype').ASSTRING := frmDyeCardGlideEdit.CDS_Glide.FieldByName('PSType').AsString; POST; end; Next; end; end; end; end; finally frmDyeCardGlideEdit.Free; end; end; procedure TfrmClothInfoInput.ToolButton8Click(Sender: TObject); var i: Integer; begin i := CDS_2.RecordCount; //当前的dataset有多少行记录 i := i + 1; CopyAddRow(Tv2, CDS_2); with CDS_2 do begin Edit; FieldByName('SerialNo').Value := i; FieldByName('FtyWastage').Value := 0; FieldByName('C_Accessories').Value := null; FieldByName('flSellname').Value := null; FieldByName('Price').Value := 0; FieldByName('flcategory').Value := null; Post; end; SetXH(CDS_2); end; procedure TfrmClothInfoInput.ToolButton9Click(Sender: TObject); begin if CDS_2.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; if Trim(CDS_2.fieldbyname('BCPID').AsString) <> '' then begin with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Bs_Cloth_Process where BCPID=''' + Trim(CDS_2.fieldbyname('BCPID').AsString) + ''''); ExecSQL; end; end; CDS_2.Delete; SetXH(CDS_2); end; procedure TfrmClothInfoInput.Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'FtyType'; flagname := '类型'; if ShowModal = 1 then begin CDS_1.Edit; CDS_1.fieldbyname('FtyType').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); CDS_1.Post; end; end; finally frmZDYHelp.Free; end; tv1.Controller.EditingController.ShowEdit(); end; procedure TfrmClothInfoInput.Tv1Column5PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmCompanySel := TfrmCompanySel.Create(Application); with frmCompanySel do begin FCoType := '供应商'; FLX := '采购合同'; if ShowModal = 1 then begin self.CDS_1.Edit; self.CDS_1.fieldbyname('flSellname').Value := frmCompanySel.CDS_1.fieldbyname('CoName').asstring; self.CDS_1.Post; end; // free; end; finally frmCompanySel.Free; end; end; procedure TfrmClothInfoInput.Tv1Column7PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'flcategory'; flagname := '辅料类别'; if ShowModal = 1 then begin Self.CDS_1.Edit; Self.CDS_1.FieldByName('flcategory').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; end.