unit U_DyeOutputListCL; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, cxGridCustomTableView, cxGridTableView, cxGridBandedTableView, cxGridDBBandedTableView, cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGridDBTableView, cxGrid, StdCtrls, ComCtrls, ExtCtrls, ToolWin, cxGridCustomPopupMenu, cxGridPopupMenu, ADODB, DBClient, cxDropDownEdit, MovePanel, cxButtonEdit, cxCalendar, RM_System, RM_Common, RM_Class, RM_GridReport, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, dxSkinsCore, dxSkinsDefaultPainters, dxDateRanges, dxBarBuiltInMenu, U_BaseList, cxCheckBox, Vcl.Menus, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations, Vcl.CheckLst, cxTextEdit; type TfrmDyeOutputListCL = class(TfrmBaseList) ToolBar1: TToolBar; TBRafresh: TToolButton; TBFind: TToolButton; TBExport: TToolButton; TBClose: TToolButton; Panel1: TPanel; ADOQueryCmd: TADOQuery; ADOQueryMain: TADOQuery; ADOQueryTemp: TADOQuery; DataSource1: TDataSource; cxGridPopupMenu1: TcxGridPopupMenu; BegDate: TDateTimePicker; CDS_Main: TClientDataSet; Tv1: TcxGridDBTableView; cxGrid2Level1: TcxGridLevel; cxGrid2: TcxGrid; MovePanel2: TMovePanel; Label16: TLabel; customerNoName: TEdit; Label13: TLabel; ywy: TEdit; Label17: TLabel; Tv1Column6: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; lbHx: TEdit; Label7: TLabel; GlideName: TComboBox; ToolButton1: TToolButton; Tv1Column4: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Label14: TLabel; StaffName: TEdit; PM_1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; Label15: TLabel; Tv1Column16: TcxGridDBColumn; Tv1Column1: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; Tv1Column14: TcxGridDBColumn; Tv1Column15: TcxGridDBColumn; Tv1Column18: TcxGridDBColumn; Tv1Column19: TcxGridDBColumn; Tv1Column20: TcxGridDBColumn; Tv1Column21: TcxGridDBColumn; Tv1Column22: TcxGridDBColumn; Tv1Column23: TcxGridDBColumn; Tv1Column24: TcxGridDBColumn; Tv1Column25: TcxGridDBColumn; Tv1Column26: TcxGridDBColumn; Tv1Column27: TcxGridDBColumn; Tv1Column28: TcxGridDBColumn; Tv1Column29: TcxGridDBColumn; Tv1Column30: TcxGridDBColumn; Tv1Column31: TcxGridDBColumn; Tv1Column32: TcxGridDBColumn; Tv1Column33: TcxGridDBColumn; Tv1Column34: TcxGridDBColumn; Tv1Column35: TcxGridDBColumn; Tv1Column36: TcxGridDBColumn; ToolButton2: TToolButton; Tv1Column17: TcxGridDBColumn; Tv1Column37: TcxGridDBColumn; procedure FormDestroy(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure FormCreate(Sender: TObject); procedure TBRafreshClick(Sender: TObject); procedure ConNoMChange(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure TBExportClick(Sender: TObject); procedure TBFindClick(Sender: TObject); procedure PRTColorChange(Sender: TObject); procedure TBdelClick(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure orderNoChange(Sender: TObject); procedure Tv1CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); procedure TBPrintClick(Sender: TObject); procedure N1Click(Sender: TObject); procedure N2Click(Sender: TObject); procedure CheckBox1Click(Sender: TObject); procedure CheckBox2Click(Sender: TObject); procedure Tv1Column25PropertiesEditValueChanged(Sender: TObject); procedure ToolButton2Click(Sender: TObject); private FLeft, FTop: Integer; procedure InitGrid(); { Private declarations } public fsyrName, canshu1: string; FFromStaff: string; { Public declarations } end; var frmDyeOutputListCL: TfrmDyeOutputListCL; implementation uses U_DataLink, U_RTFun, U_ZDYHelp, U_LabelPrint, U_DyeOutputListCLMX; {$R *.dfm} procedure TfrmDyeOutputListCL.FormDestroy(Sender: TObject); begin inherited; frmDyeOutputListCL := nil; end; procedure TfrmDyeOutputListCL.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := caFree; end; procedure TfrmDyeOutputListCL.FormCreate(Sender: TObject); begin inherited; BegDate.DateTime := SGetServerDateTime(ADOQueryTemp); fsyrName := trim(DdataBase); canshu1 := trim(DParameters1); SInitComBoxBySql(ADOQueryTemp, GlideName, false, 'select PSName as Name from Trade_Process'); end; procedure TfrmDyeOutputListCL.InitGrid(); var Msql, mbegdate, menddate: string; mcol: TcxGridDBColumn; begin Msql := ''; if SGetFilters(Panel1, 1, 2) <> '' then Msql := Msql + ' and ' + SGetFilters(Panel1, 1, 2); mbegdate := FormatDateTime('yyyy-MM', begdate.Date); try ADOQueryMain.DisableControls; with ADOQueryMain do begin Close; sql.Clear; Filtered := False; sql.Add('exec GetProductWageTableHZ @ym=' + quotedstr(mbegdate)); sql.Add(',@UType=' + quotedstr(trim(self.fParameters1))); sql.Add(',@StaffName=' + quotedstr(trim(FFromStaff))); // showmessage(sql.Text); Open; end; SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); finally ADOQueryMain.EnableControls; end; TBFind.Click; // tier 1 (staff-only): hide the process column; tier 2 shows it mcol := Tv1.GetColumnByFieldName('GlideName'); if mcol <> nil then mcol.Visible := (trim(FFromStaff) <> ''); end; procedure TfrmDyeOutputListCL.N1Click(Sender: TObject); begin // inherited; SelOKNo(CDS_Main, true); end; procedure TfrmDyeOutputListCL.N2Click(Sender: TObject); begin // inherited; SelOKNo(CDS_Main, False); end; procedure TfrmDyeOutputListCL.orderNoChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmDyeOutputListCL.TBRafreshClick(Sender: TObject); begin MovePanel2.Visible := True; MovePanel2.Refresh; InitGrid(); MovePanel2.Visible := False; end; procedure TfrmDyeOutputListCL.ToolButton1Click(Sender: TObject); begin WriteCxGrid(self.Caption + tv1.Name + 'TV1', Tv1, '成品仓库1'); end; procedure TfrmDyeOutputListCL.ToolButton2Click(Sender: TObject); var mPairs: string; mStaff, mLocKey: string; mLocDay: Integer; mColName, mdayField: string; mbk: TBookmark; mcol: TcxGridDBColumn; frm: TfrmDyeOutputListCL; begin if trim(FFromStaff) = '' then begin // tier 1 -> tier 2: open the original staff+process summary carrying the employee if CDS_Main.IsEmpty then Exit; mStaff := Trim(CDS_Main.FieldByName('StaffName').AsString); if mStaff = '' then begin Application.MessageBox('请先选中员工行!', '提示', 0); Exit; end; frm := TfrmDyeOutputListCL.Create(Application, self.Caption + '-' + mStaff, trim(self.fParameters1), '', '', '', '', ''); try frm.FFromStaff := mStaff; frm.begdate.DateTime := self.begdate.DateTime; frm.ShowModal; finally frm.Free; end; Exit; end; // tier 2 -> tier 3: original logic (open CLMX detail) mPairs := ''; mLocKey := ''; mLocDay := 0; mColName := ''; mbk := nil; // capture current row/column so we can come back to the same place if not CDS_Main.IsEmpty then begin mbk := CDS_Main.GetBookmark; mLocKey := Trim(CDS_Main.FieldByName('StaffName').AsString) + '|' + Trim(CDS_Main.FieldByName('GlideName').AsString); if Tv1.Controller.FocusedColumn <> nil then begin mColName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); mdayField := mColName; if (Length(mdayField) > 1) and (UpCase(mdayField[1]) = 'T') then Delete(mdayField, 1, 1); mLocDay := StrToIntDef(mdayField, 0); if (mLocDay < 1) or (mLocDay > 31) then mLocDay := 0; end; end; with CDS_Main do begin DisableControls; try First; while not Eof do begin if FieldByName('Ssel').AsBoolean then begin if mPairs <> '' then mPairs := mPairs + ','; mPairs := mPairs + Trim(FieldByName('StaffName').AsString) + '|' + Trim(FieldByName('GlideName').AsString); end; Next; end; // stay on the current row instead of jumping to the first one if (mbk <> nil) and BookmarkValid(mbk) then GotoBookmark(mbk); finally if mbk <> nil then FreeBookmark(mbk); EnableControls; end; end; // showmessage(mPairs); try frmDyeOutputListCLMX := TfrmDyeOutputListCLMX.Create(Application); with frmDyeOutputListCLMX do begin if mPairs <> '' then begin FPairList := mPairs; FGLIDENAME := ''; FStaffName := ''; end else begin FPairList := ''; FGLIDENAME := self.CDS_Main.FieldByName('GlideName').AsString; FStaffName := self.CDS_Main.FieldByName('StaffName').AsString; end; FLocKey := mLocKey; FLocDay := mLocDay; begdate.DateTime := self.begdate.DateTime; if ShowModal = 1 then begin end; end; finally frmDyeOutputListCLMX.Free; end; // back to the same cell after the detail window closes if mColName <> '' then begin mcol := Tv1.GetColumnByFieldName(mColName); if mcol <> nil then Tv1.Controller.FocusedColumn := mcol; end; cxGrid2.SetFocus; end; procedure TfrmDyeOutputListCL.Tv1Column25PropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName: string; begin // inherited; mvalue := TcxTextEdit(Sender).EditingText; FFieldName := Trim(Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_Main do begin Edit; FieldByName(FFieldName).Value := Trim(mvalue); Post; end; with ADOQueryCmd do begin Close; sql.Clear; sql.Add('Update Trade_Plan_Glide_OutPut '); sql.Add('Set ' + FFieldName + '=''' + Trim(mvalue) + ''''); sql.Add('where GOID=''' + Trim(CDS_Main.fieldbyname('GOID').AsString) + ''''); ExecSQL; end; end; procedure TfrmDyeOutputListCL.Tv1CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); begin // inherited; if AViewInfo.GridRecord.Values[tv1.GetColumnByFieldName('DJstatus').Index] = '1' then ACanvas.Brush.Color := clRed; end; procedure TfrmDyeOutputListCL.CheckBox1Click(Sender: TObject); begin BegDate.DateTime := SGetServerDateTime(ADOQueryTemp); // CheckBox2.Checked := False; InitGrid(); end; procedure TfrmDyeOutputListCL.CheckBox2Click(Sender: TObject); begin inherited; // if CheckBox2.Checked then // begin // BegDate.DateTime := SGetServerDateTime(ADOQueryTemp) - 1; // EndDate.DateTime := SGetServerDateTime(ADOQueryTemp); // CheckBox1.Checked := False; // InitGrid(); // end // else // begin // CheckBox1.Checked := true; // InitGrid(); // end; end; procedure TfrmDyeOutputListCL.ConNoMChange(Sender: TObject); begin if ADOQueryMain.Active then begin SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); end; end; procedure TfrmDyeOutputListCL.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmDyeOutputListCL.FormShow(Sender: TObject); begin inherited; ReadCxGrid(self.Caption + tv1.Name + 'TV1', Tv1, '成品仓库1'); canshu1 := self.fParameters1; // tier-2 instance: keep the search date carried from the parent window if trim(FFromStaff) = '' then BegDate.DateTime := SGetServerDateTime(ADOQueryTemp); initgrid(); end; procedure TfrmDyeOutputListCL.TBExportClick(Sender: TObject); begin if ADOQueryMain.IsEmpty then exit; // SelExportData(tv1,ADOQueryMain,self.Caption); TcxGridToExcel(self.Caption, cxGrid2); end; procedure TfrmDyeOutputListCL.TBFindClick(Sender: TObject); begin if ADOQueryMain.Active then begin SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); end; end; procedure TfrmDyeOutputListCL.TBPrintClick(Sender: TObject); var WSql: string; begin // inherited; WSql := ''; if CDS_Main.IsEmpty then Exit; if CDS_Main.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; with CDS_Main do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin if WSql <> '' then begin WSql := WSql + ',' + quotedstr(Trim(CDS_Main.fieldbyname('GOID').AsString)); end else begin WSql := quotedstr(Trim(CDS_Main.fieldbyname('GOID').AsString)); end; end; Next; end; EnableControls; end; // showmessage(WSql); try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'ClCardPrint'; FFiltration1 := WSql; if ShowModal = 1 then begin // with ADOQueryCmd do // begin // close; // sql.Clear; // sql.Add('update Trade_Plan_Card SET status=''9'' ,chker=''' + trim(DName) + ''',Chktime=getdate() '); // sql.Add(' where EXISTS(select X.RTValue from [dbo].[F_Tool_SplitString](' + quotedstr(WSql) + ','','') X where X.RTValue=Trade_Plan_Card.PCID ) '); // execsql; // end; end; end; finally frmLabelPrint.Free; end; end; procedure TfrmDyeOutputListCL.PRTColorChange(Sender: TObject); begin TBFind.Click; end; procedure TfrmDyeOutputListCL.TBdelClick(Sender: TObject); begin if CDS_Main.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; try with CDS_Main do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin try with ADOQueryCmd do begin Close; sql.Clear; sql.Add('delete Trade_Plan_Glide_OutPut where GOID=''' + Trim(CDS_Main.fieldbyname('GOID').AsString) + ''''); ExecSQL; end; ////////////////// 更新进度 ////////////////// with ADOQueryCmd do begin Close; sql.Clear; sql.Add('insert into Trade_Need_Up(UType,UDataId) values(''机台刷卡'',' + quotedstr(Trim(CDS_Main.fieldbyname('GOID').AsString)) + ') '); execsql; end; ////////////////// 更新进度 ////////////////// // CDS_Main.Delete; except application.MessageBox('删除失败!', '提示信息', 0); end; end; Next; end; EnableControls; end; TBRafresh.Click; except CDS_Main.EnableControls; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; // try // with ADOQueryCmd do // begin // Close; // sql.Clear; // sql.Add('delete Trade_Plan_Glide_OutPut where GOID=''' + Trim(CDS_Main.fieldbyname('GOID').AsString) + ''''); // // ExecSQL; // end; //////////////////// 更新进度 ////////////////// // with ADOQueryCmd do // begin // Close; // sql.Clear; // sql.Add('insert into Trade_Need_Up(UType,UDataId) values(''机台刷卡'',' + quotedstr(Trim(CDS_Main.fieldbyname('GOID').AsString)) + ') '); // execsql; // end; //////////////////// 更新进度 ////////////////// // CDS_Main.Delete; // except // application.MessageBox('删除失败!', '提示信息', 0); // end; end; end.