unit U_DyePlanCardInput; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExtCtrls, BtnEdit, ComCtrls, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, ToolWin, cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGrid, ADODB, DBClient, cxCalendar, cxContainer, cxTextEdit, cxCurrencyEdit, cxDropDownEdit, cxCheckBox, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, dxSkinsCore, dxSkinsDefaultPainters, dxDateRanges, U_BaseInput, System.ImageList, Vcl.ImgList, dxBarBuiltInMenu, cxGridCustomPopupMenu, cxGridPopupMenu, cxButtonEdit, Vcl.Menus, cxPC, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations, RM_Common, RM_Class, RM_GridReport, RM_Dataset; type TfrmDyePlanCardInput = class(TfrmBaseInput) CDS_1: TClientDataSet; DS_1: TDataSource; ADO_Car: TADOQuery; ADOQueryCmd: TADOQuery; ADOQueryTmp: TADOQuery; GPM_1: TcxGridPopupMenu; Panel3: TPanel; Panel4: TPanel; cxGrid1: TcxGrid; TV1: TcxGridDBTableView; V1SSel: TcxGridDBColumn; V1Column1: TcxGridDBColumn; V1Column5: TcxGridDBColumn; TV1Column1: TcxGridDBColumn; TV1Column5: TcxGridDBColumn; TV1Column6: TcxGridDBColumn; TV1Column7: TcxGridDBColumn; V1Column2: TcxGridDBColumn; V1Column3: TcxGridDBColumn; TV1Column4: TcxGridDBColumn; TV1Column3: TcxGridDBColumn; V1Column6: TcxGridDBColumn; V1Column4: TcxGridDBColumn; TV1Column2: TcxGridDBColumn; cxGrid1Level1: TcxGridLevel; ToolBar1: TToolBar; ToolButton4: TToolButton; ADOQueryMain: TADOQuery; PM_1: TPopupMenu; MenuItem1: TMenuItem; MenuItem2: TMenuItem; TV1Column10: TcxGridDBColumn; ToolButton5: TToolButton; ToolButton1: TToolButton; ToolButton2: TToolButton; ToolButton3: TToolButton; TV1Column12: TcxGridDBColumn; TV1Column13: TcxGridDBColumn; TV1Column14: TcxGridDBColumn; TV1Column15: TcxGridDBColumn; TV1Column16: TcxGridDBColumn; TV1Column17: TcxGridDBColumn; TV1Column18: TcxGridDBColumn; TV1Column19: TcxGridDBColumn; ADO_Order: TADOQuery; CDS_Color: TClientDataSet; pnlOrder: TPanel; Label23: TLabel; Label4: TLabel; Label9: TLabel; Label11: TLabel; Label10: TLabel; Label24: TLabel; OrderNo: TBtnEditA; C_Width: TEdit; C_GramWeight: TEdit; C_COLORNO: TEdit; C_Color: TComboBox; OrdQty: TEdit; OrdUnit: TEdit; pnlkpkk: TPanel; Label1: TLabel; Label7: TLabel; Label15: TLabel; Label16: TLabel; Label17: TLabel; PCTime: TDateTimePicker; carnum: TcxCurrencyEdit; PCPiece: TcxCurrencyEdit; PCType: TComboBox; PCQty: TEdit; Button2: TButton; C_ColorM: TEdit; Label2: TLabel; BuyConNo: TEdit; C_StyleNo: TEdit; Label3: TLabel; TV1Column8: TcxGridDBColumn; TV1Column9: TcxGridDBColumn; Label5: TLabel; crop: TEdit; Label6: TLabel; ToolButton6: TToolButton; ToolButton7: TToolButton; ADOTmp: TADOQuery; sewing: TMemo; Label8: TLabel; C_BZmanner: TEdit; TV1Column11: TcxGridDBColumn; Label12: TLabel; C_CLName1: TEdit; C_CLwrap1: TEdit; Label13: TLabel; TV1Column20: TcxGridDBColumn; TV1Column21: TcxGridDBColumn; Label14: TLabel; Label18: TLabel; C_CLName: TEdit; C_CLwrap: TEdit; Label19: TLabel; Processprice: TEdit; Label20: TLabel; C_CPCode: TEdit; Label21: TLabel; C_CJSIZE: TEdit; TV1Column22: TcxGridDBColumn; TV1Column23: TcxGridDBColumn; RMDBmain: TRMDBDataSet; RM1: TRMGridReport; cds_3: TClientDataSet; ds_3: TDataSource; procedure FormDestroy(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure FormCreate(Sender: TObject); procedure FormShow(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure MenuItem1Click(Sender: TObject); procedure MenuItem2Click(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure Button2Click(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure PCIDKeyPress(Sender: TObject; var Key: Char); procedure Button1Click(Sender: TObject); procedure TV3DblClick(Sender: TObject); procedure OrderNoBtnClick(Sender: TObject); procedure C_ColorChange(Sender: TObject); procedure TV3Column1PropertiesEditValueChanged(Sender: TObject); procedure PCQtyChange(Sender: TObject); procedure ToolButton6Click(Sender: TObject); procedure ToolButton7Click(Sender: TObject); private FMainID, Fsubid: string; FRollNum: integer; FGC_BatchNo, FGC_Piece, FGC_STKID, FGC_Position: string; FFromCoNo, FFromCoName, FSaleser, FC_Name, FC_Code, FC_Pattern: string; procedure InitCard(); procedure InitOrder(); procedure InitGreyClothStk(); function GetCard(): Boolean; procedure InitRepairCard(PPCID: string); procedure PrintCar(MPCID: string); { Private declarations } public FWorkshop, FPCIDS: string; { Public declarations } end; var frmDyePlanCardInput: TfrmDyePlanCardInput; implementation uses U_DataLink, U_ZDYHelp, U_RTFun, U_DyePlanForCardSel, U_DyeCardGlideEdit; {$R *.dfm} procedure TfrmDyePlanCardInput.PrintCar(MPCID: string); var fPrintFile: string; begin with ADOTmp do begin Close; Filtered := False; sql.Clear; sql.Add('exec P_Trade_Card_Prt1 '); sql.Add(' @Filtration=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString))); Open; end; SCreateCDS(ADOTmp, CDS_3); SInitCDSData(ADOTmp, CDS_3); ExportFtErpFile('捆标签.rmf', ADOTmp); fPrintFile := ExtractFilePath(Application.ExeName) + 'Report\捆标签.rmf'; if FileExists(fPrintFile) then begin RM1.LoadFromFile(fPrintFile); RMVariables['FILLTIME'] := CDS_3.FieldByName('FILLTIME').AsString; RM1.PrintReport; sleep(200); // if canshu1 <> '查询' then // begin // with ADOQueryCmd do // begin // close; // sql.Clear; // sql.Add('update Dye_Plan_Card SET status=''9'' '); // sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString))); // execsql; // end; // end; end else Application.MessageBox(PChar('没有找到' + trim(fPrintFile)), '提示信息', 0); end; function TfrmDyePlanCardInput.GetCard(): Boolean; var MCustNo, MC_Name: string; begin // try // CDS_3.DisableControls; // if CDS_3.IsEmpty then // raise Exception.Create('请选择流程卡!'); // CDS_3.First; // while not CDS_3.eof do // begin // if Trim(MCustNo) = '' then // begin // MCustNo := trim(CDS_3.FieldByName('CustNo').AsString); // MC_Name := trim(CDS_3.FieldByName('C_Name').AsString); // end // else // begin // if MCustNo <> trim(CDS_3.FieldByName('CustNo').AsString) then // raise Exception.Create('不能选择多个客户!'); // if MC_Name <> trim(CDS_3.FieldByName('C_Name').AsString) then // raise Exception.Create('不能选择多个产品!'); // end; // if CDS_3.FieldByName('MvPiece').AsFloat > CDS_3.FieldByName('PSC_StkPiece').AsFloat then // raise Exception.Create('调用匹数超限!'); // if CDS_3.FieldByName('MvQty').AsFloat > CDS_3.FieldByName('PSC_StkQty').AsFloat then // raise Exception.Create('调用数量超限!'); // CDS_3.Next; // end; // CDS_3.EnableControls; // Result := True; // except // Result := false; // CDS_3.EnableControls; // application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); // end; end; procedure TfrmDyePlanCardInput.InitOrder(); var fsj: string; begin with Ado_Order do begin close; sql.Clear; sql.Add('select A.*,B.*'); sql.Add('from Trade_Plan_sub A '); sql.Add('inner join Trade_Plan_Main B on B.MainID=A.mainID '); sql.Add('where A.MainID=''' + trim(FMainID) + ''' '); open; end; SCreateCDS(Ado_Order, CDS_Color); SInitCDSData(Ado_Order, CDS_Color); if not Ado_Order.IsEmpty then begin fsj := 'select distinct(C_Color) name from Trade_Plan_sub where mainid= ' + QuotedStr(Trim(FMainID)); SInitComBoxBySql(ADOQueryTmp, C_COLOR, False, fsj); SCSHData(Ado_Order, pnlOrder, 2); // C_ColorM.text := Trim(Ado_Order.FieldByName('C_Color').AsString); FC_Name := Trim(Ado_Order.FieldByName('C_Name').AsString); FC_Code := Trim(Ado_Order.FieldByName('C_Code').AsString); FFromCoNo := Trim(Ado_Order.FieldByName('CustNo').AsString); FFromCoName := Trim(Ado_Order.FieldByName('CustName').AsString); // FGC_BatchNo := Trim(Ado_Order.FieldByName('GC_BatchNo').AsString); // FGC_Piece := Trim(Ado_Order.FieldByName('GC_Piece').AsString); // FGC_STKID := Trim(Ado_Order.FieldByName('GC_STKID').AsString); // FGC_Position := Trim(Ado_Order.FieldByName('GC_Position').AsString); // FRollNum :=Trim(Ado_Order.FieldByName('').AsString); end; end; procedure TfrmDyePlanCardInput.InitRepairCard(PPCID: string); begin // with ADOQueryTmp do // begin // close; // sql.Clear; // sql.Add('select A.*'); // sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) '); // sql.Add(',MvPiece=PSC_StkPiece,MvQty=PSC_StkQty '); // sql.Add('from Trade_Plan_Card A '); // if TRIM(PPCID) = '' then // sql.Add('where 1=2 ') // else // sql.Add('where PCID= ' + Quotedstr(trim(PPCID))); // // open; // end; // if TRIM(PPCID) = '' then // begin // SCreateCDS(ADOQueryTmp, CDS_3); // end // else // begin // SInitCDSData(ADOQueryTmp, CDS_3); // end; end; procedure TfrmDyePlanCardInput.InitGreyClothStk(); begin // try // ADOQueryMain.DisableControls; // with ADOQueryMain do // begin // Filtered := False; // Close; // sql.Clear; // sql.Add(' select A.* '); // sql.Add(' from BS_Cloth_IO A where isnull(STKName,'''')=''染色坯布'' '); // SQL.Add(' and A.IOFlag=''入库'' '); // SQL.Add(' and EXISTS(select * from [dbo].[F_Tool_SplitString](' + quotedstr(FGC_STKID) + ','';'' ) X where X.RTValue=A.StkId) '); //// ShowMessage(sql.Text); // Open; // end; // SCreateCDS(ADOQueryMain, CDS_2); // SInitCDSData(ADOQueryMain, CDS_2); // finally // ADOQueryMain.EnableControls; // end; end; procedure TfrmDyePlanCardInput.MenuItem1Click(Sender: TObject); begin SelOKNo(CDS_1, True); end; procedure TfrmDyePlanCardInput.MenuItem2Click(Sender: TObject); begin SelOKNo(CDS_1, False); end; procedure TfrmDyePlanCardInput.OrderNoBtnClick(Sender: TObject); begin frmProductOrderListSel := TfrmProductOrderListSel.create(self); with frmProductOrderListSel do begin FWorkshop := self.FWorkshop; if ShowModal = 1 then begin fmainID := Order_Main.fieldbyname('mainID').asstring; // InitOrder(); // InitGreyClothStk(); // InitCard(); // initGlide(); self.OrderNo.text := Order_Main.fieldbyname('OrderNo').asstring; self.C_Width.text := Order_Main.fieldbyname('C_Width').asstring; self.Processprice.text := Order_Main.fieldbyname('Processprice').asstring; self.C_GramWeight.text := Order_Main.fieldbyname('C_GramWeight').asstring; self.C_ColorM.text := Order_Main.fieldbyname('C_Color').asstring; self.C_COLORNO.text := Order_Main.fieldbyname('C_COLORNO').asstring; self.C_CJSIZE.text := Order_Main.fieldbyname('C_CJSIZE').asstring; self.OrdQty.text := Order_Main.fieldbyname('OrdQty').asstring; self.OrdUnit.text := Order_Main.fieldbyname('OrdUnit').asstring; self.BuyConNo.text := Order_Main.fieldbyname('BuyConNo').asstring; FC_Name := Trim(Order_Main.FieldByName('C_Name').AsString); FC_Code := Trim(Order_Main.FieldByName('C_Code').AsString); FC_Pattern := Trim(Order_Main.FieldByName('C_Pattern').AsString); FFromCoNo := Trim(Order_Main.FieldByName('CustNo').AsString); FFromCoName := Trim(Order_Main.FieldByName('CustName').AsString); Fsubid := Trim(Order_Main.FieldByName('subid').AsString); self.C_StyleNo.text := Trim(Order_Main.FieldByName('C_StyleNo').AsString); // self.crop.text := Trim(Order_Main.FieldByName('C_CJsize').AsString); // self.sewing.text := Trim(Order_Main.FieldByName('C_description').AsString); // self.C_BZmanner.text := Trim(Order_Main.FieldByName('C_wrap').AsString); self.C_CLName.text := Trim(Order_Main.FieldByName('C_Name').AsString); self.C_CLwrap.text := Trim(Order_Main.FieldByName('C_Spec').AsString); self.C_CPCode.text := Trim(Order_Main.FieldByName('C_Code').AsString); // self.PCQty.text := Trim(Order_Main.FieldByName('C_MKSL').AsString); // self.PCQty.text := Trim(Order_Main.FieldByName('OrdQty').AsString); // self.carnum.text := '1'; // self.carnum.text := floattostr(strtofloat(Order_Main.fieldbyname('OrdQty').asstring) / strtofloat(Trim(Order_Main.FieldByName('C_MKSL').asstring))); end; free; end; end; procedure TfrmDyePlanCardInput.PCIDKeyPress(Sender: TObject; var Key: Char); begin // if Key = #13 then // begin // if Trim(PCID.Text) = '' then // exit; // InitRepairCard(PCID.Text); // PCID.Text := ''; // end; end; procedure TfrmDyePlanCardInput.PCQtyChange(Sender: TObject); begin // inherited; end; procedure TfrmDyePlanCardInput.InitCard(); begin with Ado_car do begin close; sql.Clear; sql.Add('select A.*'); sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) '); sql.Add('from Trade_Plan_Card A '); // sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID'); sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) '); open; end; SCreateCDS(Ado_car, CDS_1); SInitCDSData(Ado_car, CDS_1); with ADOQueryTmp do begin close; sql.Clear; sql.Add('select A.*,B.*,C.*'); sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) '); sql.Add('from Trade_Plan_Card A '); sql.Add('left join Trade_Plan_sub B on B.subID=A.subID'); sql.Add('left join Trade_Plan_Main C on C.mainID=A.mainID'); // sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID'); sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) '); open; end; C_ColorM.text := ADOQueryTmp.FieldByName('C_Color').AsString; SCSHData(ADOQueryTmp, pnlOrder, 2); end; procedure TfrmDyePlanCardInput.FormDestroy(Sender: TObject); begin inherited; frmDyePlanCardInput := nil; end; procedure TfrmDyePlanCardInput.Button1Click(Sender: TObject); var maxId: string; begin // PCID.SetFocus; // if not GetCard() then // Exit; // // if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then // begin // Application.MessageBox('取最大号失败!', '提示', 0); // Exit; // end; // FPCIDS := FPCIDS + maxId + ';'; // try // ADOQueryCmd.Connection.BeginTrans; // CDS_3.DisableConstraints; // // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('select * from Trade_Plan_Card A where 1=2'); // Open; // Append; // FieldByName('Filler').Value := trim(DName); // FieldByName('Workshop').Value := trim(FWorkshop); // FieldByName('PCType').Value := trim(RePCType.Text); // FieldByName('PCID').Value := trim(maxId); // FieldByName('PCTime').Value := formatdateTime('yyyy-MM-dd', now()); // FieldByName('GC_BatchNo').Value := ''; // FieldByName('GC_Piece').Value := ''; // FieldByName('GC_STKID').Value := ''; // FieldByName('GC_Position').Value := ''; // FieldByName('C_Name').Value := trim(CDS_3.FieldByName('C_Name').AsString); // FieldByName('CustNo').Value := trim(CDS_3.FieldByName('CustNo').AsString); // FieldByName('CustName').Value := trim(CDS_3.FieldByName('CustName').AsString); // FieldByName('MainId').Value := trim(CDS_3.FieldByName('MainId').AsString); // FieldByName('SubId').Value := trim(CDS_3.FieldByName('SubId').AsString); // FieldByName('C_GramWeight').Value := trim(Re_GramWeight.Text); // FieldByName('C_Width').Value := trim(Re_Width.Text); // FieldByName('C_Color').Value := trim(Re_Color.Text); // FieldByName('PCUnit').Value := trim(ReUnit.Text); // FieldByName('C_ColorNo').Value := trim(Re_ColorNo.Text); // FieldByName('PCPiece').Value := 0; // FieldByName('PCQty').Value := 0; // post; // end; // // with CDS_3 do // begin // first; // while not Eof do // begin // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('select * from Trade_Plan_Card_Move A where 1=2'); // Open; // Append; // FieldByName('Filler').Value := trim(DName); // FieldByName('FromID').Value := trim(CDS_3.FieldByName('PCID').AsString); // FieldByName('ToID').Value := maxId; // FieldByName('MvPiece').Value := CDS_3.FieldByName('MvPiece').AsFloat; // FieldByName('MvQty').Value := CDS_3.FieldByName('MvQty').AsFloat; // post; // end; // Next; // end; // end; // // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('exec P_Trade_Card_Move '); // Sql.Add('@PCID=' + quotedstr(trim(maxId))); // Open; // end; // if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then // begin // raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); // end; // ADOQueryCmd.Connection.CommitTrans; // CDS_3.EnableConstraints; // except // ADOQueryCmd.Connection.RollbackTrans; // CDS_3.EnableConstraints; // application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); // end; // // InitCard(); // InitRepairCard(''); end; procedure TfrmDyePlanCardInput.Button2Click(Sender: TObject); var i, k, fhxInt, x: integer; maxId, sqlstr, MaxmaxId: string; begin // if trim(C_Color.Text) = '' then // begin // application.MessageBox('颜色不能为空!', '提示信息', MB_ICONERROR); // exit; // end; if trim(C_ColorM.Text) = '' then begin application.MessageBox('颜色不能为空!', '提示信息', MB_ICONERROR); exit; end; if trim(C_Width.Text) = '' then begin application.MessageBox('门幅不能为空!', '提示信息', MB_ICONERROR); exit; end; // if trim(C_GramWeight.Text) = '' then // begin // application.MessageBox('克重不能为空!', '提示信息', MB_ICONERROR); // exit; // end; if (StrToFloatDef(PCPiece.Text, 0) + StrToFloatDef(PCQty.Text, 0)) = 0 then begin application.MessageBox('开卡匹数、数量不能都为零!', '提示信息', MB_ICONERROR); exit; end; if strtointdef(trim(carNum.text), 0) <= 1 then k := 1 else k := strtointdef(trim(carNum.text), 0); // CDS_Color.Locate('C_Color', C_Color.Text, []); // if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then // begin // Application.MessageBox('取最大号失败!', '提示', 0); // Exit; // end; CDS_1.Last; sqlstr := ''; // x := 1; for i := 1 to k do begin if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 5, 1) = False then begin Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; FPCIDS := FPCIDS + maxId + ';'; // MaxmaxId := inttostr(strtoint(Trim(maxId)) + x); sqlstr := sqlstr + 'insert into Trade_Plan_Card(KUNNO,OrderNo,SubId,Mainid,Filler,Workshop,PCType,PCID,PCTime,GC_BatchNo,GC_Piece,' + 'GC_STKID,GC_Position,CustNo,CustName,Saleser,C_Name,C_Code,C_Pattern,C_GramWeight,C_Width,C_Color,PCUnit,C_ColorNo,BuyConNo,C_StyleNo,PCPiece,PCQty,carnum,C_CLName,C_CLwrap,C_CPCode,Processprice,crop) '; sqlstr := sqlstr + ' values( '; sqlstr := sqlstr + ' cast( ''' + trim(INTTOSTR(i)) + '''as INT), '; sqlstr := sqlstr + ' ''' + Trim(OrderNo.Text) + ''', '; sqlstr := sqlstr + ' ''' + Trim(Fsubid) + ''', '; sqlstr := sqlstr + ' ''' + Trim(FMainid) + ''', '; sqlstr := sqlstr + ' ''' + trim(DName) + ''', '; sqlstr := sqlstr + ' ''' + trim(FWorkshop) + ''', '; sqlstr := sqlstr + ' ''' + trim(PCType.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(maxId) + ''', '; sqlstr := sqlstr + ' ''' + formatdateTime('yyyy-MM-dd', PCTime.DateTime) + ''', '; sqlstr := sqlstr + ' ''' + trim(FGC_BatchNo) + ''', '; sqlstr := sqlstr + ' ''' + trim(FGC_Piece) + ''', '; sqlstr := sqlstr + ' ''' + trim(FGC_STKID) + ''', '; sqlstr := sqlstr + ' ''' + trim(FGC_Position) + ''', '; sqlstr := sqlstr + ' ''' + trim(FFromCoNo) + ''', '; sqlstr := sqlstr + ' ''' + trim(FFromCoName) + ''', '; sqlstr := sqlstr + ' ''' + trim(FSaleser) + ''', '; sqlstr := sqlstr + ' ''' + trim(FC_Name) + ''', '; sqlstr := sqlstr + ' ''' + trim(FC_Code) + ''', '; sqlstr := sqlstr + ' ''' + trim(FC_Pattern) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_GramWeight.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_Width.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_ColorM.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(OrdUnit.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_ColorNo.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(BuyConNo.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_StyleNo.Text) + ''', '; sqlstr := sqlstr + ' cast( ''' + trim(PCpiece.Text) + '''as float), '; sqlstr := sqlstr + ' cast(''' + trim(PCQty.Text) + '''as float), '; // sqlstr := sqlstr + ' ''' + trim(crop.Text) + ''', '; // sqlstr := sqlstr + ' ''' + trim(sewing.Text) + ''', '; // sqlstr := sqlstr + ' ''' + trim(C_BZmanner.Text) + ''' ,'; sqlstr := sqlstr + ' ''' + trim(carnum.Text) + ''','; sqlstr := sqlstr + ' ''' + trim(C_CLName.Text) + ''', '; sqlstr := sqlstr + ' ''' + trim(C_CLwrap.Text) + ''' ,'; sqlstr := sqlstr + ' ''' + trim(C_CPCode.Text) + ''' ,'; sqlstr := sqlstr + ' ''' + trim(Processprice.Text) + ''' ,'; sqlstr := sqlstr + ' ''' + trim(C_CJSIZE.Text) + ''' '; sqlstr := sqlstr + ' ) '; // x := x + 1; end; with ADOQueryCmd do begin close; sql.Clear; sql.Add(sqlstr); // showmessage(sql.Text); execsql; end; with Ado_car do begin close; sql.Clear; sql.Add('select A.*'); sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.PCID) '); sql.Add('from Trade_Plan_Card A '); // sql.Add('inner join Dye_Plan_Glide B on B.PCID=A.PCID'); sql.Add('where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + Quotedstr(trim(FPCIDS)) + ', '';'' ) X where X.RTValue=A.PCID ) '); open; end; SCreateCDS(Ado_car, CDS_1); SInitCDSData(Ado_car, CDS_1); printcar(FPCIDS); // InitCard(); InitGreyClothStk(); // for i := 1 to k do // begin // if GetLSNo(ADOQueryCmd, maxId, 'CZ', 'Trade_Plan_Card', 3, 1) = False then // begin // Application.MessageBox('取最大号失败!', '提示', 0); // Exit; // end; // FPCIDS := FPCIDS + maxId + ';'; // try // ADOQueryCmd.Connection.BeginTrans; // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('select * from Trade_Plan_Card A where 1=2'); // Open; // Append; // FieldByName('OrderNo').Value := OrderNo.Text; //// FieldByName('SubId').Value := CDS_Color.FieldByName('SubId').Value; // FieldByName('SubId').Value := Fsubid; // FieldByName('Mainid').Value := FMainid; // FieldByName('Filler').Value := trim(DName); // FieldByName('Workshop').Value := trim(FWorkshop); // FieldByName('PCType').Value := trim(PCType.Text); // FieldByName('PCID').Value := trim(maxId); // FieldByName('PCTime').Value := formatdateTime('yyyy-MM-dd', PCTime.DateTime); // FieldByName('GC_BatchNo').Value := trim(FGC_BatchNo); // FieldByName('GC_Piece').Value := trim(FGC_Piece); // FieldByName('GC_STKID').Value := trim(FGC_STKID); // FieldByName('GC_Position').Value := trim(FGC_Position); // FieldByName('CustNo').Value := trim(FFromCoNo); // FieldByName('CustName').Value := trim(FFromCoName); // FieldByName('Saleser').Value := trim(FSaleser); // FieldByName('C_Name').Value := trim(FC_Name); // FieldByName('C_GramWeight').Value := trim(C_GramWeight.Text); // FieldByName('C_Width').Value := trim(C_Width.Text); //// FieldByName('C_Color').Value := trim(C_Color.Text); // FieldByName('C_Color').Value := trim(C_ColorM.Text); // FieldByName('PCUnit').Value := trim(OrdUnit.Text); // FieldByName('C_ColorNo').Value := trim(C_ColorNo.Text); // FieldByName('PCPiece').Value := StrtoIntDef(PCPiece.Text, 0); // FieldByName('PCQty').Value := StrtoFloatDef(PCQty.Text, 0); // post; // end; // // ADOQueryCmd.Connection.CommitTrans; // except // ADOQueryCmd.Connection.RollbackTrans; // application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); // end; // end; // InitCard(); // InitGreyClothStk(); end; procedure TfrmDyePlanCardInput.C_ColorChange(Sender: TObject); begin CDS_Color.Locate('C_Color', C_Color.Text, []); C_COLOR.Text := CDS_Color.FieldByName('C_COLOR').AsString; OrdQty.Text := CDS_Color.FieldByName('OrdQty').AsString; OrdUnit.Text := CDS_Color.FieldByName('OrdUnit').AsString; C_COLORNO.Text := CDS_Color.FieldByName('C_COLORNO').AsString; end; procedure TfrmDyePlanCardInput.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := cahide; end; procedure TfrmDyePlanCardInput.FormCreate(Sender: TObject); begin inherited; PCTime.Date := DServerDate; end; procedure TfrmDyePlanCardInput.FormShow(Sender: TObject); begin inherited; ReadCxGrid(self.Caption + 'TV1', Tv1, '生产指示单管理'); // ReadCxGrid(self.Caption + 'TV2', Tv2, '生产指示单管理'); InitCard(); InitGreyClothStk(); InitRepairCard(''); end; procedure TfrmDyePlanCardInput.ToolButton1Click(Sender: TObject); var MPCIDS, WSql: string; // WSql: string; begin if CDS_1.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; with CDS_1 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin MPCIDS := MPCIDS + trim(CDS_1.FieldByName('PCID').AsString) + ';'; end; Next; end; EnableControls; end; with CDS_1 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin if WSql <> '' then begin WSql := WSql + ',' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString)); end else begin WSql := quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString)); end; end; Next; end; EnableControls; end; with ADOQueryTmp do begin close; sql.Clear; sql.Add('select distinct GX=[dbo].[F_Trade_Card_GlideList](A.RTValue) from [dbo].[F_Tool_SplitString](' + quotedstr(MPCIDS) + ','';'') A '); open; end; if ADOQueryTmp.RecordCount > 1 then begin Application.MessageBox('请选择相同工序的卡编辑!', '提示', 0); Exit; end; try frmDyeCardGlideEdit := TfrmDyeCardGlideEdit.Create(Application); with frmDyeCardGlideEdit do begin FPCIDS := MPCIDS; FWSql := WSql; FWorkshop := self.FWorkshop; if ShowModal = 1 then begin InitCard(); end; end; finally frmDyeCardGlideEdit.Free; end; end; procedure TfrmDyePlanCardInput.ToolButton2Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV1', Tv1, '生产指示单管理'); // WriteCxGrid(self.Caption + 'TV2', Tv2, '生产指示单管理'); end; procedure TfrmDyePlanCardInput.ToolButton3Click(Sender: TObject); begin close; end; procedure TfrmDyePlanCardInput.ToolButton4Click(Sender: TObject); begin if CDS_1.IsEmpty then exit; if CDS_1.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; try with CDS_1 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin try ADOQueryCmd.Connection.BeginTrans; with ADOQueryCmd do begin Close; Sql.Clear; Sql.Add('exec P_Trade_Card_Del '); Sql.Add('@PCIDS=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString))); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); Open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); // if (Trim(CDS_1.fieldbyname('PCType').AsString) = '正常卡') or (Trim(CDS_1.fieldbyname('PCType').AsString) = '前道卡') then // begin // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('exec P_Trade_GreyCloth_Out_Del '); // Sql.Add('@PCID=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString))); // Open; // end; // if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then // raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); // end // else // begin // with ADOQueryCmd do // begin // Close; // Sql.Clear; // Sql.Add('exec P_Trade_Card_Move_Del '); // Sql.Add('@PCID=' + quotedstr(Trim(CDS_1.fieldbyname('PCID').AsString))); // Open; // end; // if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then // raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); // end; ADOQueryCmd.Connection.CommitTrans; except ADOQueryCmd.Connection.RollbackTrans; raise Exception.Create(PChar(Exception(ExceptObject).Message)); end; end; Next; EnableControls; end; InitCard(); InitGreyClothStk(); end; except CDS_1.EnableControls; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; end; procedure TfrmDyePlanCardInput.ToolButton5Click(Sender: TObject); begin try CDS_1.DisableControls; CDS_1.First; while not CDS_1.Eof do begin if CDS_1.Fieldbyname('Ssel').AsBoolean then begin ADOQueryCmd.Connection.BeginTrans; try with ADOQueryCmd do begin close; sql.Clear; sql.Add('select * from Trade_Plan_Card A'); sql.Add('where PCID=''' + trim(CDS_1.fieldbyname('PCID').AsString) + ''''); open; edit; FieldByName('Editer').Value := Trim(DName); FieldByName('EditTime').Value := SGetServerDateTime(ADOQueryTmp); RTSetSaveDataCDS(ADOQueryCmd, Tv1, CDS_1, 'Trade_Plan_Card', 0); post; end; ADOQueryCmd.Connection.CommitTrans; except ADOQueryCmd.Connection.RollbackTrans; raise Exception.Create(PChar(Exception(ExceptObject).Message)); end; end; CDS_1.Next; end; CDS_1.EnableControls; InitCard(); InitGreyClothStk(); except CDS_1.EnableControls; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; end; procedure TfrmDyePlanCardInput.ToolButton6Click(Sender: TObject); begin // inherited; if CDS_1.IsEmpty then exit; if CDS_1.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; try ADOTmp.Connection.BeginTrans; with CDS_1 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin with ADOTmp do begin close; sql.Clear; sql.Add('update Trade_Plan_Card SET crop=''' + trim(crop.text) + ''' '); sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString))); execsql; end; end; Next; end; EnableControls; end; ADOTmp.Connection.CommitTrans; application.MessageBox('修改成功!', '提示信息'); except ADOTmp.Connection.RollbackTrans; application.MessageBox('修改失败!', '提示信息', 0); end; InitCard(); end; procedure TfrmDyePlanCardInput.ToolButton7Click(Sender: TObject); begin // inherited; if CDS_1.IsEmpty then exit; if CDS_1.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; try ADOTmp.Connection.BeginTrans; with CDS_1 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin with ADOTmp do begin close; sql.Clear; sql.Add('update Trade_Plan_Card SET sewing=''' + trim(sewing.text) + ''' '); sql.Add('where PCID=' + quotedstr(trim(CDS_1.fieldbyname('PCID').AsString))); execsql; end; end; Next; end; EnableControls; end; ADOTmp.Connection.CommitTrans; application.MessageBox('修改成功!', '提示信息'); except ADOTmp.Connection.RollbackTrans; application.MessageBox('修改失败!', '提示信息', 0); end; InitCard(); end; procedure TfrmDyePlanCardInput.TV3Column1PropertiesEditValueChanged(Sender: TObject); var mvalue: string; begin // mvalue := TcxTextEdit(Sender).EditingText; // with CDS_3 do // begin // Edit; // FieldByName('MvPiece').Value := STRTOFLOATDEF(mvalue, 0); // if FieldByName('PSC_StkPiece').AsFloat > 0 then // FieldByName('MvQty').Value := STRTOFLOATDEF(mvalue, 0) * (FieldByName('PSC_StkQty').AsFloat / FieldByName('PSC_StkPiece').AsFloat) // else // FieldByName('MvQty').Value := 0; // Post; // // end; // Tv3.Controller.EditingController.ShowEdit(); end; procedure TfrmDyePlanCardInput.TV3DblClick(Sender: TObject); begin // CDS_3.Delete; end; end.