unit U_DyeCardGlideEdit2; interface uses Windows, Messages, SysUtils, strutils, 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, dxScrollbarAnnotations; type TfrmDyeCardGlideEdit2 = class(TfrmBaseInput) CDS_Glide: TClientDataSet; DS_Glide: TDataSource; CDS_1: TClientDataSet; DS_1: TDataSource; ADO_Car: TADOQuery; ADO_Glide: TADOQuery; ADOQueryCmd: TADOQuery; ADOQueryTmp: TADOQuery; GPM_1: TcxGridPopupMenu; Panel1: TPanel; Panel2: TPanel; cxGrid2: TcxGrid; TV2: TcxGridDBTableView; TV2Column1: TcxGridDBColumn; TV2Column2: TcxGridDBColumn; TV2Column3: TcxGridDBColumn; cxGridLevel1: TcxGridLevel; ToolBar1: TToolBar; TBGX: TToolButton; ToolButton2: TToolButton; ToolButton3: TToolButton; ToolButton4: TToolButton; ToolButton5: TToolButton; cxGrid1: TcxGrid; TV1: TcxGridDBTableView; v2PSName: TcxGridDBColumn; v2PSNote: TcxGridDBColumn; v2SYRName: TcxGridDBColumn; vLDPrice: TcxGridDBColumn; v2Column1: TcxGridDBColumn; cxGridLevel2: TcxGridLevel; CDS_Card: TClientDataSet; ToolButton1: TToolButton; ToolButton6: TToolButton; TV2Column4: TcxGridDBColumn; TV2Column5: TcxGridDBColumn; ToolButton7: TToolButton; ADOQueryTmp1: TADOQuery; CDS_Card1: TClientDataSet; ToolButton8: TToolButton; procedure FormDestroy(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure ToolButton2Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure FormShow(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure TBGXClick(Sender: TObject); procedure TV1DblClick(Sender: TObject); procedure ToolButton6Click(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton7Click(Sender: TObject); procedure ToolButton8Click(Sender: TObject); private fOrdType: string; procedure InitGrid1(); procedure InitCard(); procedure InitCard1(); procedure InitGlide(); { Private declarations } public FWorkshop, FPCIDS, FWSql, FSUBID, FCODE, FMAINID: string; { Public declarations } end; var frmDyeCardGlideEdit2: TfrmDyeCardGlideEdit2; implementation uses U_DataLink, U_RTFun, U_DyeTechnicsSel; {$R *.dfm} procedure TfrmDyeCardGlideEdit2.InitCard1(); begin try with ADOQueryTmp1 do begin close; sql.Clear; sql.Add('select distinct left(GlideID,12) as GlideID1 from Trade_Plan_Glide where PCid in (' + trim(FWSql) + ' ) '); showmessage(sql.text); open; end; SCreateCDS(ADOQueryTmp1, CDS_Card1); SInitCDSData(ADOQueryTmp1, CDS_Card1); finally end; end; procedure TfrmDyeCardGlideEdit2.InitGrid1(); begin with ADOQueryTmp do begin Close; SQL.Clear; // sql.Add(' select * from Dye_Process '); sql.Add(' select * from Trade_Process '); Open; end; SCreateCDS(ADOQueryTmp, CDS_1); SInitCDSData(ADOQueryTmp, CDS_1); end; procedure TfrmDyeCardGlideEdit2.InitGlide(); begin try with Ado_Glide do begin close; sql.Clear; sql.Add('select A.*'); sql.Add('from Trade_Plan_Glide A '); sql.Add('where A.SUBID=''' + trim(fsubid) + ''' '); // showmessage(sql.text); open; end; SCreateCDS(Ado_Glide, CDS_Glide); SInitCDSData(Ado_Glide, CDS_Glide); if CDS_Glide.IsEmpty then begin with ADOQueryTmp do begin close; sql.Clear; sql.Add('select A.*'); sql.Add('from Bs_Process A '); sql.Add('where A.BCIID=(SELECT TOP 1 BCIID FROM BS_CLOTH_INFO E WHERE E.C_CODE=''' + trim(fcode) + ''' '); SQL.Add(') ORDER BY SerialNo'); // showmessage(sql.text); open; end; if ADOQueryTmp.IsEmpty = FALSE then begin with ADOQueryTmp do begin First; while not Eof do begin with CDS_Glide do begin append; FIELDBYNAME('GlideNo').ASSTRING := ADOQueryTmp.FieldByName('SerialNo').AsString; FIELDBYNAME('GlideName').ASSTRING := ADOQueryTmp.FieldByName('psname').AsString; FIELDBYNAME('Dprice').ASSTRING := ADOQueryTmp.FieldByName('price').AsString; post; end; Next; end; end; end; end; finally end; end; procedure TfrmDyeCardGlideEdit2.InitCard(); begin // try // with ADOQueryTmp do // begin // close; // sql.Clear; // sql.Add('select * from [dbo].[F_Tool_SplitString](' + quotedstr(FPCIDS) + ','';'') A '); // open; // end; // SCreateCDS(ADOQueryTmp, CDS_Card); // SInitCDSData(ADOQueryTmp, CDS_Card); // finally // end; end; procedure TfrmDyeCardGlideEdit2.FormDestroy(Sender: TObject); begin inherited; frmDyeCardGlideEdit2 := nil; end; procedure TfrmDyeCardGlideEdit2.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := cahide; end; procedure TfrmDyeCardGlideEdit2.ToolButton1Click(Sender: TObject); begin WriteCxGrid(self.Caption + 'TV1', Tv1, '生产指示单管理'); WriteCxGrid(self.Caption + 'TV2', Tv2, '生产指示单管理'); end; procedure TfrmDyeCardGlideEdit2.ToolButton2Click(Sender: TObject); begin with CDS_Glide do begin if IsEmpty then Exit; if RecNo >= 1 then begin //Prior; Edit; fieldByName('GlideNo').Value := fieldByName('GlideNo').Value - 1; Post; Prior; Edit; fieldByName('GlideNo').Value := fieldByName('GlideNo').Value + 1; Post; end; Prior; end; end; procedure TfrmDyeCardGlideEdit2.ToolButton3Click(Sender: TObject); begin CDS_Glide.IndexFieldNames := 'GlideNo'; with CDS_Glide do begin if IsEmpty then Exit; Next; if not Eof then Prior else begin exit; end; if not Eof then begin Edit; fieldByName('GlideNo').Value := fieldByName('GlideNo').Value + 1; Post; Prior; Edit; fieldByName('GlideNo').Value := fieldByName('GlideNo').Value - 1; Post; end; Next; end; end; procedure TfrmDyeCardGlideEdit2.ToolButton4Click(Sender: TObject); var k: integer; begin if cds_Glide.IsEmpty then exit; try ADOQueryCmd.Connection.BeginTrans; with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Trade_Plan_Glide where GlideID=''' + Trim(cds_Glide.fieldbyname('GlideID').AsString) + ''''); sql.Add('insert into SY_SysLog(operor,opertime,Model,acction,opevent,result) values( '); sql.Add(' ' + quotedstr(trim(DName))); sql.Add(',getdate() '); sql.Add(',' + quotedstr(trim(self.Caption))); sql.Add(',' + quotedstr(trim('指示单删除'))); sql.Add(',' + quotedstr(trim('SUBID:' + fsubid + '工序名:' + trim(cds_Glide.FieldByName('GlideName').AsString)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); ExecSQL; end; ADOQueryCmd.Connection.CommitTrans; cds_Glide.Delete; except ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('数据删除异常!', '提示', 0); end; cds_Glide.IndexFieldNames := 'GlideNo'; cds_Glide.DisableControls; cds_Glide.First; k := 1; while not cds_Glide.Eof do begin cds_Glide.Edit; cds_Glide.FieldByName('GlideNo').Value := k; cds_Glide.Post; inc(k); cds_Glide.Next; end; cds_Glide.First; cds_Glide.EnableControls; end; procedure TfrmDyeCardGlideEdit2.FormShow(Sender: TObject); begin inherited; ReadCxGrid(self.Caption + 'TV1', Tv1, '生产指示单管理'); ReadCxGrid(self.Caption + 'TV2', Tv2, '生产指示单管理'); InitGrid1(); InitCard(); // InitCard1(); InitGlide(); end; procedure TfrmDyeCardGlideEdit2.ToolButton5Click(Sender: TObject); var maxID, sqlstr, sqlstr1, MaxmaxId: string; x: integer; begin if CDS_Glide.IsEmpty then exit; if CDS_Card.IsEmpty then exit; Self.TV2.GetColumnByFieldName('GlideName').Focused := True; sqlstr1 := ''; sqlstr := ''; x := 1; try CDS_Glide.DisableControls; with CDS_Card do begin CDS_Card.First; while not eof do begin // CDS_Glide.DisableControls; try ADOQueryCmd.Connection.BeginTrans; sqlstr1 := sqlstr1 + 'delete from Trade_Plan_Glide '; sqlstr1 := sqlstr1 + ' where PCID= '; sqlstr1 := sqlstr1 + ' ''' + trim(CDS_Card.fieldbyname('RTValue').asstring) + ''' '; // ADOQueryCmd.Connection.BeginTrans; // with ADOQueryCmd do // begin // close; // sql.Clear; // sql.Add('delete from Trade_Plan_Glide '); // sql.Add('where PCID=''' + trim(CDS_Card.fieldbyname('RTValue').asstring) + ''''); // execsql; // end; CDS_Glide.First; if trim(CDS_Glide.FieldByName('GlideID').asstring) = '' then begin if GetLSNo(ADOQueryCmd, maxID, 'CG', 'Trade_Plan_Glide', 4, 1) = False then raise Exception.Create(PChar('取最大号失败!')); end else begin // maxID := leftstr(trim(CDS_Glide.FieldByName('GlideID').asstring), 12); maxID := leftstr(trim(CDS_Glide.FieldByName('GlideID').asstring), 12); end; // CDS_Glide.First; while not CDS_Glide.Eof do begin // if trim(CDS_Glide.FieldByName('GlideID').asstring) = '' then // begin // if GetLSNo(ADOQueryCmd, maxID, 'CG', 'Trade_Plan_Glide', 4, 1) = False then // raise Exception.Create(PChar('取最大号失败!')); // end; // MaxmaxId := trim(maxID) + inttostr(x); //rightstr(maxID,9) MaxmaxId := trim(maxID) + inttostr(x); // // MaxmaxId := 'CG' + inttostr(strtoint(Copy(maxID, 3, 9)) + x); sqlstr := sqlstr + 'insert into Trade_Plan_Glide(Filler,GlideID,PCID,GlideNo,GlideName,Note,Dprice) '; sqlstr := sqlstr + ' values( '; sqlstr := sqlstr + ' ''' + trim(DName) + ''', '; sqlstr := sqlstr + ' ''' + trim(MaxmaxId) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_Card.fieldbyname('RTValue').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('GlideNo').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_Glide.fieldbyname('Note').AsString) + ''', '; // sqlstr := sqlstr + ' ''' + strtofloatdef((CDS_Glide.fieldbyname('Dprice').Asfloat),0) + ''' '; sqlstr := sqlstr + 'cast(isnull(''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''',0)as float) '; sqlstr := sqlstr + ' ) '; // with ADOQueryCmd do // begin // close; // sql.Clear; // sql.Add('select * from Trade_Plan_Glide A where 1=2'); // open; // // append; // fieldbyname('Filler').Value := trim(DName); // FieldByName('GlideID').Value := trim(maxID); // FieldByName('PCID').Value := trim(CDS_Card.fieldbyname('RTValue').AsString); // FieldByName('GlideNo').Value := trim(CDS_Glide.fieldbyname('GlideNo').AsString); // FieldByName('GlideName').Value := trim(CDS_Glide.fieldbyname('GlideName').AsString); // FieldByName('Note').Value := trim(CDS_Glide.fieldbyname('Note').AsString); // post; // end; x := x + 1; CDS_Glide.Next; end; // x := x + 1; ADOQueryCmd.Connection.CommitTrans; except ADOQueryCmd.Connection.RollbackTrans; raise Exception.Create(PChar(Exception(ExceptObject).Message)); end; CDS_Card.Next; end; with ADOQueryCmd do begin close; sql.Clear; sql.Add(sqlstr1); // showmessage(sql.Text); execsql; end; with ADOQueryCmd do begin close; sql.Clear; sql.Add(sqlstr); // showmessage(sql.Text); execsql; end; end; CDS_Glide.EnableControls; ModalResult := 1; except CDS_Glide.EnableControls; application.MessageBox('保存失败!', '提示信息', MB_ICONERROR); end; end; procedure TfrmDyeCardGlideEdit2.ToolButton6Click(Sender: TObject); begin close; end; procedure TfrmDyeCardGlideEdit2.ToolButton7Click(Sender: TObject); begin // inherited; if CDS_Glide.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; try CDS_Glide.DisableControls; ADOQueryCmd.Connection.BeginTrans; with CDS_Glide do begin First; while not Eof do begin if CDS_Glide.FieldByName('SSel').AsBoolean = True then begin with ADOQueryCmd do begin Close; sql.Clear; sql.Add('Update Trade_Plan_Glide Set Dprice=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' '); // sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); sql.Add('where PCID in (' + Trim(FWSql) + ' )and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); sql.Add('Update Trade_Plan_Glide_OutPut Set price=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' '); // sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); sql.Add('where PCID in (' + Trim(FWSql) + ') and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); showmessage(sql.text); ExecSQL; end; end; Next; end; end; ADOQueryCmd.Connection.CommitTrans; CDS_Glide.EnableControls; application.MessageBox('数据保存成功!', '提示信息'); except ADOQueryCmd.Connection.RollbackTrans; CDS_Glide.EnableControls; application.MessageBox('数据保存失败!', '提示信息', 0); end; // if CDS_Glide.FieldByName('SSel').AsBoolean = True then // begin // with CDS_Glide do // begin // DisableControls; // First; // while not Eof do // begin // if Fieldbyname('Ssel').AsBoolean then // begin // with ADOQueryCmd do // begin // Close; // sql.Clear; // sql.Add('Update Trade_Plan_Glide Set Dprice=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' '); // sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); // // sql.Add('Update Trade_Plan_Glide_OutPut Set price=''' + trim(CDS_Glide.fieldbyname('Dprice').AsString) + ''' '); // sql.Add('where PCID=''' + trim(CDS_Glide.fieldbyname('PCID').AsString) + ''' and GlideName=''' + trim(CDS_Glide.fieldbyname('GlideName').AsString) + ''' '); // ExecSQL; // end; // // end; // Next; // end; // EnableControls; // end; // // end; end; procedure TfrmDyeCardGlideEdit2.ToolButton8Click(Sender: TObject); var MaxBCPID: string; begin try CDS_Glide.DisableControls; with CDS_Glide do begin First; while not Eof do begin if Trim(CDS_Glide.fieldbyname('GlideID').AsString) = '' then begin if GetLSNo(ADOQueryCmd, MaxBCPID, 'P', 'Trade_Plan_Glide', 4, 1) = False then begin ADOQueryCmd.Connection.RollbackTrans; Application.MessageBox('取最大号失败!', '提示', 0); Exit; end; end else begin MaxBCPID := Trim(CDS_Glide.fieldbyname('GlideID').AsString); end; with ADOQueryCmd do begin Close; SQL.Clear; sql.Add('select * from Trade_Plan_Glide where GlideID=''' + Trim(MaxBCPID) + ''''); Open; end; with ADOQueryCmd do begin if ADOQueryCmd.IsEmpty then Append else Edit; RTSetSaveDataCDS(ADOQueryCmd, Tv2, CDS_Glide, 'Trade_Plan_Glide', 0); FieldByName('GlideID').Value := Trim(MaxBCPID); FieldByName('subid').Value := Trim(FSUBID); FieldByName('MAINID').Value := Trim(FMAINID); Post; end; with CDS_Glide do begin Edit; FieldByName('GlideID').Value := Trim(MaxBCPID); Post; end; Next; end; end; CDS_Glide.EnableControls; ModalResult := 1; except CDS_Glide.EnableControls; application.MessageBox('保存失败!', '提示信息', MB_ICONERROR); end; ////////////////// 保存工序表 ////////////////////// ////////////////// 保存工序表 ////////////////////// end; procedure TfrmDyeCardGlideEdit2.TV1DblClick(Sender: TObject); begin with CDS_1 do begin CDS_Glide.Append; CDS_Glide.FieldByName('GlideNo').Value := CDS_Glide.RecordCount + 1; CDS_Glide.FieldByName('GlideName').Value := CDS_1.fieldbyname('PSName').AsString; CDS_Glide.FieldByName('Note').Value := CDS_1.fieldbyname('Note').AsString; CDS_Glide.Post; end; end; procedure TfrmDyeCardGlideEdit2.TBGXClick(Sender: TObject); begin frmDyeTechnicsSel := TfrmDyeTechnicsSel.create(self); with frmDyeTechnicsSel do begin if showmodal = 1 then begin with frmDyeTechnicsSel.CDS_1 do begin First; CDS_Glide.EmptyDataSet; while not Eof do begin CDS_Glide.Append; CDS_Glide.FieldByName('GlideNo').Value := CDS_Glide.RecordCount + 1; CDS_Glide.FieldByName('GlideName').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('PSName').AsString; CDS_Glide.FieldByName('Note').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('Note').AsString; CDS_Glide.FieldByName('Dprice').Value := frmDyeTechnicsSel.CDS_1.fieldbyname('PSDprice').AsFloat; CDS_Glide.Post; Next; end; end; end; free; end; end; end.