unit U_SalesContractList2; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExtCtrls, ComCtrls, ToolWin, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, ADODB, cxGridCustomPopupMenu, cxGridPopupMenu, cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxGrid, DBClient, cxCheckBox, cxCalendar, cxSplitter, RM_Dataset, RM_System, RM_Common, RM_Class, RM_GridReport, RM_e_Xls, Menus, cxPC, cxButtonEdit, cxTextEdit, cxDropDownEdit, cxLookAndFeels, cxLookAndFeelPainters, dxSkinsCore, dxSkinsDefaultPainters, cxNavigator, dxDateRanges, dxBarBuiltInMenu, U_BaseList, RM_e_Graphic, RM_e_Jpeg, RM_E_llPDF, Vcl.Clipbrd, cxMemo, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations, cxContainer, cxCurrencyEdit, cxMaskEdit; type TfrmSalesContractList2 = class(TfrmBaseList) ToolBar1: TToolBar; TBRafresh: TToolButton; TBFind: TToolButton; TBPrint: TToolButton; TBClose: TToolButton; Tv1: TcxGridDBTableView; cxGrid1Level1: TcxGridLevel; cxGrid1: TcxGrid; GPM_1: TcxGridPopupMenu; ADOQueryCmd: TADOQuery; ADOQueryMain: TADOQuery; ADOQueryTemp: TADOQuery; DS_1: TDataSource; v1OrdDate: TcxGridDBColumn; v1DeliveryDate: TcxGridDBColumn; v1OrdPerson1: TcxGridDBColumn; v1ConNo: TcxGridDBColumn; CDS_2: TClientDataSet; v1CustomerNoName: TcxGridDBColumn; v1Column1: TcxGridDBColumn; v1Column4: TcxGridDBColumn; pm2: TPopupMenu; Panel1: TPanel; Label4: TLabel; Label5: TLabel; Label8: TLabel; Label9: TLabel; Label12: TLabel; Label13: TLabel; BegDate: TDateTimePicker; EndDate: TDateTimePicker; BuyName: TEdit; HZSCSName: TEdit; MPRTCodeName: TEdit; ConNo: TEdit; MPRTKZ: TEdit; MPRTMF: TEdit; cxTabControl1: TcxTabControl; DS_2: TDataSource; v1Column8: TcxGridDBColumn; Label2: TLabel; v1Column10: TcxGridDBColumn; v1Column12: TcxGridDBColumn; v1Column9: TcxGridDBColumn; GPM_2: TcxGridPopupMenu; CDS_1: TClientDataSet; v1Column13: TcxGridDBColumn; Label3: TLabel; BuyConNo: TEdit; Tv1Column1: TcxGridDBColumn; Tv1Column2: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Tv1Column14: TcxGridDBColumn; pm1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; ADOQueryImage: TADOQuery; Tv1Column19: TcxGridDBColumn; IsJYTime: TCheckBox; ToolButton7: TToolButton; N3: TMenuItem; N4: TMenuItem; Tv1Column25: TcxGridDBColumn; Tv1Column27: TcxGridDBColumn; N5: TMenuItem; N6: TMenuItem; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; Tv1Column15: TcxGridDBColumn; Label10: TLabel; Filler: TEdit; Tv1Column16: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; Tv1Column18: TcxGridDBColumn; Tv1Column20: TcxGridDBColumn; Tv1Column21: TcxGridDBColumn; Tv1Column22: TcxGridDBColumn; Panel2: TPanel; Panel3: TPanel; ToolBar2: TToolBar; ToolButton1: TToolButton; ToolButton2: TToolButton; ToolButton3: TToolButton; ToolButton4: TToolButton; ToolButton5: TToolButton; pnlkpkk: TPanel; Label1: TLabel; Label7: TLabel; Label15: TLabel; Label16: TLabel; Label17: TLabel; PCTime: TDateTimePicker; carnum: TcxCurrencyEdit; PCPiece: TcxCurrencyEdit; PCType: TComboBox; PCQty: TEdit; Button2: TButton; cxGrid3: TcxGrid; tv3: TcxGridDBTableView; V1SSel: TcxGridDBColumn; cxGridDBColumn1: TcxGridDBColumn; TV1Column23: TcxGridDBColumn; cxGridDBColumn10: TcxGridDBColumn; cxGridDBColumn11: TcxGridDBColumn; cxGridDBColumn12: TcxGridDBColumn; cxGridDBColumn13: TcxGridDBColumn; cxGridDBColumn14: TcxGridDBColumn; cxGridDBColumn15: TcxGridDBColumn; cxGridDBColumn16: TcxGridDBColumn; V1Column3: TcxGridDBColumn; cxGridDBColumn17: TcxGridDBColumn; cxGridDBColumn18: TcxGridDBColumn; cxGridDBColumn19: TcxGridDBColumn; cxGridDBColumn20: TcxGridDBColumn; cxGridDBColumn21: TcxGridDBColumn; cxGridDBColumn22: TcxGridDBColumn; cxGridDBColumn23: TcxGridDBColumn; cxGridDBColumn24: TcxGridDBColumn; cxGridDBColumn25: TcxGridDBColumn; cxGridDBColumn27: TcxGridDBColumn; cxGridLevel2: TcxGridLevel; ADO_Car: TADOQuery; GPM_3: TcxGridPopupMenu; CDS_3: TClientDataSet; DS_3: TDataSource; ToolButton6: TToolButton; CDS_4: TClientDataSet; DS_4: TDataSource; ToolButton8: TToolButton; cxSplitter1: TcxSplitter; Panel4: TPanel; cxGrid2: TcxGrid; TV2: TcxGridDBTableView; TV2Column1: TcxGridDBColumn; v1XHNo: TcxGridDBColumn; VC_SCSCode: TcxGridDBColumn; cxGridDBColumn2: TcxGridDBColumn; cxGridDBColumn3: TcxGridDBColumn; v1Column5: TcxGridDBColumn; cxGridDBColumn4: TcxGridDBColumn; cxGridDBColumn5: TcxGridDBColumn; cxGridDBColumn6: TcxGridDBColumn; cxGridDBColumn7: TcxGridDBColumn; cxGridDBColumn8: TcxGridDBColumn; v1Column6: TcxGridDBColumn; v1Column7: TcxGridDBColumn; v1PRTOrderQty: TcxGridDBColumn; v1OrderUnit: TcxGridDBColumn; v1PRTPrice: TcxGridDBColumn; cxGridDBColumn9: TcxGridDBColumn; v1Column2: TcxGridDBColumn; TV2Column10: TcxGridDBColumn; TV2Column4: TcxGridDBColumn; TV2Column8: TcxGridDBColumn; TV2Column2: TcxGridDBColumn; TV2Column3: TcxGridDBColumn; TV2Column5: TcxGridDBColumn; TV2Column6: TcxGridDBColumn; cxGridLevel1: TcxGridLevel; Panel5: TPanel; Label18: TLabel; Label22: TLabel; C_Code: TEdit; C_Name: TEdit; Label6: TLabel; Label11: TLabel; C_Color: TEdit; C_CJsize: TEdit; cds_5: TClientDataSet; ds_5: TDataSource; ToolButton9: TToolButton; ADOQuery1: TADOQuery; PM3: TPopupMenu; MenuItem1: TMenuItem; MenuItem2: TMenuItem; MenuItem3: TMenuItem; RMDB_1: TRMDBDataSet; Label14: TLabel; DYGS: TcxButtonEdit; RM1: TRMGridReport; ToolButton10: TToolButton; TV2Column7: TcxGridDBColumn; TV2Column9: TcxGridDBColumn; TV2Column11: TcxGridDBColumn; TV2Column12: TcxGridDBColumn; TV2Column13: TcxGridDBColumn; TV2Column14: TcxGridDBColumn; TV2Column15: TcxGridDBColumn; Label19: TLabel; zpcid: TEdit; ToolButton11: TToolButton; procedure FormDestroy(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure TBCloseClick(Sender: TObject); procedure TBFindClick(Sender: TObject); procedure TBEditClick(Sender: TObject); procedure TBRafreshClick(Sender: TObject); procedure TBAddClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure CheckBox1Click(Sender: TObject); procedure CheckBox2Click(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); procedure BuyNameChange(Sender: TObject); procedure tchkClick(Sender: TObject); procedure TnochkClick(Sender: TObject); procedure cxTabControl1Change(Sender: TObject); procedure Tv1FocusedRecordChanged(Sender: TcxCustomGridTableView; APrevFocusedRecord, AFocusedRecord: TcxCustomGridRecord; ANewItemRecordFocusingChanged: Boolean); procedure TqxClick(Sender: TObject); procedure TnoqxClick(Sender: TObject); procedure ToolButton5Click(Sender: TObject); procedure Tv1CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); procedure btnTijiaoClick(Sender: TObject); procedure btnCXTijiaoClick(Sender: TObject); procedure N1Click(Sender: TObject); procedure N2Click(Sender: TObject); procedure btnWCClick(Sender: TObject); procedure btnWCCXClick(Sender: TObject); procedure ConNoKeyPress(Sender: TObject; var Key: Char); procedure ToolButton7Click(Sender: TObject); procedure N3Click(Sender: TObject); procedure N4Click(Sender: TObject); procedure TBPrintClick(Sender: TObject); procedure FormCreate(Sender: TObject); procedure N5Click(Sender: TObject); procedure N6Click(Sender: TObject); procedure ToolButton3Click(Sender: TObject); procedure ConNoChange(Sender: TObject); procedure BuyConNoChange(Sender: TObject); procedure CurrencyChange(Sender: TObject); procedure ToolButton4Click(Sender: TObject); procedure ToolButton6Click(Sender: TObject); procedure Button2Click(Sender: TObject); procedure TV2FocusedRecordChanged(Sender: TcxCustomGridTableView; APrevFocusedRecord, AFocusedRecord: TcxCustomGridRecord; ANewItemRecordFocusingChanged: Boolean); procedure TV2CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); procedure ToolButton8Click(Sender: TObject); procedure FormResize(Sender: TObject); procedure C_CodeChange(Sender: TObject); procedure ToolButton9Click(Sender: TObject); procedure MenuItem1Click(Sender: TObject); procedure MenuItem2Click(Sender: TObject); procedure MenuItem3Click(Sender: TObject); procedure DYGSPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); procedure ToolButton10Click(Sender: TObject); procedure ToolButton11Click(Sender: TObject); private fFlileFlag: string; procedure InitGrid(); procedure SetStatus(); procedure InitSub(); procedure InitImage(); procedure Initcard(); procedure PrintCar(MPCID: string); procedure RefreshCardCount(); { Private declarations } public FFInt, FCloth: Integer; FAuthority, FGSTT, FSubIdS, FPCIDS: string; { Public declarations } end; implementation uses U_DataLink, U_SalesConInPut, U_RTFun, U_AttachmentUpload, U_LabelPrint, U_RZCK1, U_DyeCardGlideEdit, U_DyeCardGlideEdit2, U_ZDYHelp, U_cdzdy; {$R *.dfm} procedure TfrmSalesContractList2.PrintCar(MPCID: string); var fPrintFile: string; begin with ADOQueryTemp do begin Close; Filtered := False; sql.Clear; sql.Add('exec P_Trade_Card_Prt1 '); sql.Add(' @Filtration=' + quotedstr(trim(MPCID))); Open; end; SCreateCDS(ADOQueryTemp, CDS_4); SInitCDSData(ADOQueryTemp, CDS_4); with ADOQueryTemp do begin Close; Filtered := False; sql.Clear; sql.Add('exec P_Trade_Card_Prt2 '); sql.Add(' @Filtration=' + quotedstr(trim(MPCID))); Open; end; SCreateCDS(ADOQueryTemp, CDS_5); SInitCDSData(ADOQueryTemp, CDS_5); ExportFtErpFile(trim(dygs.text) + '.rmf', ADOQueryTemp); fPrintFile := ExtractFilePath(Application.ExeName) + 'Report\' + trim(dygs.text) + '.rmf'; if FileExists(fPrintFile) then begin RM1.LoadFromFile(fPrintFile); RMVariables['FILLTIME'] := CDS_4.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; procedure TfrmSalesContractList2.InitImage(); begin ADOQueryImage.Close; if CDS_1.IsEmpty then exit; with ADOQueryImage do begin close; sql.Clear; sql.Add('select * from TP_File A'); sql.Add('where WBID=' + quotedstr(trim(CDS_1.fieldbyname('SubId').AsString))); sql.Add('and TFType=' + quotedstr(trim('HX'))); open; end; end; procedure TfrmSalesContractList2.InitSub(); begin if CDS_1.IsEmpty then exit; with ADOQUERY1 do begin close; sql.Clear; sql.Add('select * '); sql.Add(',GlideList=[dbo].[F_Trade_Card_GlideList](A.consid) '); sql.Add(',IsCard=cast(case when exists(select 1 from Trade_Plan_Card B where B.SubId=A.consid) then 1 else 0 end as bit) '); sql.Add(',CardCount=(select count(1) from Trade_Plan_Card B where B.SubId=A.consid) '); sql.Add('from BS_Contract_sub A where ConMID =' + quotedstr((CDS_1.fieldbyname('ConMID').AsString))); open; end; SCreateCDS(ADOQUERY1, CDS_2); SInitCDSData(ADOQUERY1, CDS_2); // TV2.DataController.Filter.Clear; end; procedure TfrmSalesContractList2.MenuItem1Click(Sender: TObject); begin SelOKNoFiler(Tv3, True); end; procedure TfrmSalesContractList2.MenuItem2Click(Sender: TObject); begin SelOKNoFiler(Tv3, FALSE); end; procedure TfrmSalesContractList2.MenuItem3Click(Sender: TObject); begin Clipboard.SetTextBuf(PChar(Trim(CDS_3.fieldbyname(TV3.Controller.FocusedColumn.DataBinding.FilterFieldName).AsString))); end; procedure TfrmSalesContractList2.Initcard(); begin if CDS_2.IsEmpty then exit; with ADOQueryTemp do begin close; sql.Clear; // sql.Add('select * from BS_Contract_sub A '); // sql.Add('where ConMID =' + quotedstr((CDS_2.fieldbyname('ConMID').AsString))); 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 subid= ' + quotedstr((CDS_2.fieldbyname('ConsID').AsString))); open; end; SCreateCDS(ADOQueryTemp, CDS_3); SInitCDSData(ADOQueryTemp, CDS_3); // TV3.DataController.Filter.Clear; end; procedure TfrmSalesContractList2.RefreshCardCount(); var mIds: string; Bmk: TBookmark; begin if CDS_2.IsEmpty then exit; CDS_2.DisableControls; Bmk := CDS_2.GetBookmark; mIds := ''; CDS_2.First; while not CDS_2.Eof do begin mIds := mIds + trim(CDS_2.FieldByName('ConsID').AsString) + ';'; CDS_2.Next; end; with ADOQueryTemp do begin close; sql.Clear; sql.Add('select A.ConsID, CardCount=(select count(1) from Trade_Plan_Card B where B.SubId=A.ConsID) '); sql.Add('from BS_Contract_sub A '); sql.Add('where exists(select X.RTValue from [dbo].[F_Tool_SplitString](' + quotedstr(mIds) + ','';'') X where X.RTValue=A.ConsID) '); open; end; CDS_2.First; while not CDS_2.Eof do begin if ADOQueryTemp.Locate('ConsID', trim(CDS_2.FieldByName('ConsID').AsString), []) then begin CDS_2.Edit; CDS_2.FieldByName('IsCard').AsBoolean := ADOQueryTemp.FieldByName('CardCount').AsInteger > 0; CDS_2.FieldByName('CardCount').AsInteger := ADOQueryTemp.FieldByName('CardCount').AsInteger; CDS_2.Post; end; CDS_2.Next; end; ADOQueryTemp.Close; CDS_2.GotoBookmark(Bmk); CDS_2.FreeBookmark(Bmk); CDS_2.EnableControls; end; procedure TfrmSalesContractList2.N1Click(Sender: TObject); begin SelOKNoFiler(Tv2, True); //全选 end; procedure TfrmSalesContractList2.N2Click(Sender: TObject); begin SelOKNoFiler(Tv2, False); //全弃 end; procedure TfrmSalesContractList2.N3Click(Sender: TObject); begin Clipboard.SetTextBuf(PChar(Trim(CDS_2.fieldbyname(TV2.Controller.FocusedColumn.DataBinding.FilterFieldName).AsString))); end; procedure TfrmSalesContractList2.N4Click(Sender: TObject); begin Clipboard.SetTextBuf(PChar(Trim(CDS_2.fieldbyname(TV2.Controller.FocusedColumn.DataBinding.FilterFieldName).AsString))); end; procedure TfrmSalesContractList2.N5Click(Sender: TObject); begin SelOKNo(CDS_1, True); end; procedure TfrmSalesContractList2.N6Click(Sender: TObject); begin SelOKNo(CDS_1, False); end; procedure TfrmSalesContractList2.SetStatus(); begin end; procedure TfrmSalesContractList2.FormDestroy(Sender: TObject); begin inherited; // frmContractListNX:=nil; end; procedure TfrmSalesContractList2.FormResize(Sender: TObject); var w: Integer; begin if Panel2.Width > 0 then begin w := Round(Panel2.Width / 5 * 2); if w < 80 then w := 80; //最小宽度80,按需修改 Panel3.Width := w; end else Panel3.Width := 80; end; procedure TfrmSalesContractList2.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := caFree; end; procedure TfrmSalesContractList2.FormCreate(Sender: TObject); begin inherited; EndDate.DateTime := SGetServerDate(ADOQueryTemp); BegDate.DateTime := EndDate.DateTime - 90; PCTIME.DateTime := SGetServerDate(ADOQueryTemp); end; procedure TfrmSalesContractList2.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmSalesContractList2.InitGrid(); var WSql: string; begin WSql := SGetFilters(Panel1, 1, 2); if trim(WSql) <> '' then begin WSql := ' and ' + trim(WSql); end; if IsJYTime.Checked then begin WSql := WSql + ' and ConDate>' + quotedstr(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)); WSql := WSql + ' and ConDate<=' + quotedstr(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)); end else begin if trim(WSql) <> '' then WSql := ' and 1=1' + trim(WSql) else WSql := WSql + ' and 1=2 '; end; if trim(WSql) = 'and 1=2' then Application.MessageBox('勾选制单日期或填入搜索条件', '提示', 0); try ADOQueryMain.DisableControls; with ADOQueryMain do begin Filtered := False; Close; sql.Clear; sql.Add('select AA.* ,row_number() over(order by ConDate) as XH '); sql.Add(',DJStatus=case when THstatus =''1'' then 1 else 0 end'); sql.Add('from (select A.*'); sql.Add(',ZJSJC=(select top 1 CoAbbrName from BS_Company B where B.CoCode=A.MiddleNo and B.Valid=''Y'' )'); sql.Add(',ISSC=cast((case when (select COUNT(T.WBID) from FJ_File T where T.WBID=A.ConMID and T.TFType=''合同'')=0 then 0 else 1 end) as bit )'); sql.Add(',XGYJ=cast((case when (select COUNT(T.WBID) from FJ_File T where T.WBID=A.ConMID and T.TFType=''修改意见'')=0 then 0 else 1 end) as bit )'); sql.Add(',amount=isnull((select sum(C.ConTotalAmount) from BS_Contract_Sub C where C.conmid=A.conmid),0)-isnull(A.Inspection,0)'); sql.Add(',Qty=(select sum(C.ConQty) from BS_Contract_Sub C where C.conmid=A.conmid)'); sql.Add(',HZSCSName= STUFF(( SELECT '','' +convert(VARCHAR, C_Name) FROM BS_Contract_Sub c where C.conmid=A.conmid FOR XML PATH('''')), 1, 1, '''') '); sql.Add(',ZPCID= STUFF(( SELECT '','' +convert(VARCHAR, pcid) FROM TRADE_PLAN_CARD d where d.mainid=A.conmid FOR XML PATH('''')), 1, 1, '''') '); sql.Add(' from BS_Contract_Main A ) AA '); sql.Add('where 1=1 ' + (WSql)); sql.Add(' and AA.ConType in (''内销'',''外销'') '); // if Trim(FAuthority) = '录入' then // begin // sql.Add(' and ( SalesId=' + quotedstr(trim(DCode)) + ' or exists (select * from [dbo].[F_Tool_SplitString](TallyId,'','') X where X.RTValue =' + quotedstr(trim(DCode)) + '))'); // end; case cxTabControl1.TabIndex of 0: begin sql.Add(' and isnull(AA.status,''0'')=''0'''); end; 1: begin sql.Add(' and isnull(AA.status,''0'')=''1'''); end; 2: begin sql.Add(' and isnull(AA.status,''0'')=''9'''); end; 3: begin sql.Add(' and isnull(AA.status,''0'')=''10'''); end; 4: begin sql.Add(' and isnull(AA.status,''0'')=''-1'''); end; end; // if Trim(DName) <> 'ADMIN' then // begin // sql.Add('and Filler=''' + Trim(DName) + ''' '); // end; sql.Add(' order by ZDDate desc '); // showmessage(sql.text); Open; end; SCreateCDS(ADOQueryMain, CDS_1); SInitCDSData(ADOQueryMain, CDS_1); finally ADOQueryMain.EnableControls; TV1.DataController.Filter.Clear; end; end; procedure TfrmSalesContractList2.TBFindClick(Sender: TObject); begin if ADOQueryMain.Active = False then Exit; SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_1); SInitCDSData(ADOQueryMain, CDS_1); end; procedure TfrmSalesContractList2.TBPrintClick(Sender: TObject); var WSql: string; begin if CDS_1.IsEmpty then Exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'SalesConPrint'; if Self.CDS_1.fieldbyname('SSel').AsBoolean then begin FFiltration1 := QuotedStr(Trim(Self.CDS_1.fieldbyname('ConMID').AsString)); FFiltration2 := QuotedStr(Trim(Self.CDS_1.fieldbyname('ConMID').AsString)); FFiltration3 := QuotedStr(Trim(Self.CDS_1.fieldbyname('ConMID').AsString)); end; if ShowModal = 1 then begin // Self.InitGrid(); end; end; finally frmLabelPrint.Free; end; end; procedure TfrmSalesContractList2.TBEditClick(Sender: TObject); begin if CDS_1.IsEmpty then Exit; // ShowMessage(Trim(CDS_1.fieldbyname('Filler').AsString)); // ShowMessage(Trim(DName)); if Trim(CDS_1.fieldbyname('Filler').AsString) <> Trim(DName) then begin Application.MessageBox('不能操作他人的数据!', '提示', 0); Exit; end; try frmSalesConInPut := TfrmSalesConInPut.Create(Application); with frmSalesConInPut do begin PState := '修改'; FConMId := Trim(Self.CDS_1.fieldbyname('ConMID').AsString); FAuthority := self.FAuthority; FGSTT := self.FGSTT; fFlileFlag := self.fFlileFlag; if ShowModal = 1 then begin end; end; finally frmSalesConInPut.Free; end; end; procedure TfrmSalesContractList2.TBRafreshClick(Sender: TObject); begin InitGrid(); end; procedure TfrmSalesContractList2.TBAddClick(Sender: TObject); var maxno: string; begin try frmSalesConInPut := TfrmSalesConInPut.Create(Application); with frmSalesConInPut do begin PState := '新增'; FConMId := ''; FAuthority := self.FAuthority; FGSTT := self.FGSTT; fFlileFlag := self.fFlileFlag; if ShowModal = 1 then begin end; end; finally frmSalesConInPut.Free; end; end; procedure TfrmSalesContractList2.FormShow(Sender: TObject); begin inherited; fFlileFlag := UserDataFlag + 'HX'; FAuthority := self.fParameters1; readCxGrid(trim(Self.Caption) + 'tv1', Tv1, '销售合同管理'); readCxGrid(trim(Self.Caption) + 'tv2', Tv2, '销售合同管理'); SetStatus(); InitGrid(); end; procedure TfrmSalesContractList2.CheckBox1Click(Sender: TObject); begin InitGrid(); end; procedure TfrmSalesContractList2.CheckBox2Click(Sender: TObject); begin TBRafresh.Click; end; procedure TfrmSalesContractList2.ConNoChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmSalesContractList2.ConNoKeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then begin InitGrid(); end; end; procedure TfrmSalesContractList2.ToolButton10Click(Sender: TObject); var WSql: string; CurRow: Integer; begin WSql := ''; if CDS_3.IsEmpty then Exit; if CDS_3.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; with CDS_3 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin printcar(CDS_3.fieldbyname('PCID').AsString); end; Next; end; EnableControls; end; end; procedure TfrmSalesContractList2.ToolButton11Click(Sender: TObject); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'CDNAME'; flagname := '疵点名称'; fnote := true; fnote1 := true; v1note.Caption := '编号'; v1note1.Caption := '英文名称'; if ShowModal = 1 then begin // TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; // try // frmCDZDY := tfrmCDZDY.Create(Application); // with frmCDZDY do // begin // // if ShowModal = 1 then // begin //// TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); // end; // end; // finally // frmCDZDY.Free; // end; end; procedure TfrmSalesContractList2.ToolButton1Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; try frmSalesConInPut := TfrmSalesConInPut.Create(Application); with frmSalesConInPut do begin PState := '查看'; FConMId := Trim(Self.CDS_1.fieldbyname('ConMID').AsString); FGSTT := self.FGSTT; ToolBar2.Visible := False; TBSave.Visible := False; // ScrollBox1.Enabled := False; if ShowModal = 1 then begin end; end; finally frmSalesConInPut.Free; end; end; procedure TfrmSalesContractList2.ToolButton2Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; try frmSalesConInPut := TfrmSalesConInPut.Create(Application); with frmSalesConInPut do begin PState := '复制'; FConMId := Trim(Self.CDS_1.fieldbyname('ConMID').AsString); FAuthority := self.FAuthority; fFlileFlag := self.fFlileFlag; if ShowModal = 1 then begin end; end; finally frmSalesConInPut.Free; end; end; procedure TfrmSalesContractList2.ToolButton3Click(Sender: TObject); var WSql: string; CurRow: Integer; begin WSql := ''; if CDS_3.IsEmpty then Exit; if CDS_3.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; // with CDS_3 do // begin // DisableControls; // First; // while not Eof do // begin // if Fieldbyname('Ssel').AsBoolean then // begin // CurRow := Tv1.Controller.FocusedRowIndex; // if WSql <> '' then // begin // WSql := WSql + ',' + (Trim(CDS_3.fieldbyname('PCID').AsString)); // end // else // begin // WSql := (Trim(CDS_3.fieldbyname('PCID').AsString)); // end; // // end; // Next; // end; // EnableControls; // end; WSql := (Trim(CDS_3.fieldbyname('PCID').AsString)); // showmessage(WSql); Tv3.Controller.FocusedRowIndex := CurRow; try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'DyeCardPrint'; FFiltration1 := WSql; if ShowModal = 1 then begin end; end; finally frmLabelPrint.Free; end; end; procedure TfrmSalesContractList2.ToolButton4Click(Sender: TObject); begin // inherited; frmRZCK1 := TfrmRZCK1.create(self); // ForderNO:=trim(CDS_1.FieldByName('orderNO').AsString); with frmRZCK1 do begin FOrderNo1 := Trim(Self.CDS_1.fieldbyname('ConMID').AsString); // fModel := self.caption; // frmSysLogOrderzsd.FMainId := Trim(Self.FMainId); if ShowModal = 1 then begin showmodal; free; end; end; end; procedure TfrmSalesContractList2.btnWCClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; if Trim(DName) <> 'ADMIN' then begin application.MessageBox('非高权限不能完成', '提示'); exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''完成'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('完成成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.Button2Click(Sender: TObject); var i, k, fhxInt, x: integer; maxId, sqlstr, MaxmaxId, fconmid, fconsid: string; FPCQTY: string; begin if (StrToFloatDef(PCPiece.Text, 0) + StrToFloatDef(PCQty.Text, 0)) = 0 then begin application.MessageBox('开卡匹数、数量不能都为零!', '提示信息', MB_ICONERROR); exit; end; if CDS_2.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; CDS_2.Locate('SSel', True, []); if strtointdef(trim(carNum.text), 0) <= 1 then k := 1 else k := strtointdef(trim(carNum.text), 0); CDS_3.Last; sqlstr := ''; FPCQTY := (PCQty.TexT); fconmid := Trim(CDS_2.FieldByName('conmid').AsString); fconsid := Trim(CDS_2.FieldByName('consid').AsString); cds_2.disableControls; cds_1.disableControls; toolbar2.enabled := false; cxGrid1.enabled := false; panel4.enabled := false; 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 + ','; sqlstr := ''; FPCIDS := maxId; // MaxmaxId := inttostr(strtoint(Trim(maxId)) + x); sqlstr := sqlstr + 'insert into Trade_Plan_Card(KUNNO,SubId,Mainid,Filler,PCType,PCID,PCTime,CustNo,CustName,Saleser,C_Name,C_Code,C_Pattern,C_GramWeight,C_Width,C_Color,PCUnit,C_ColorNo,BuyConNo,C_StyleNo,PCPiece,PCQty,carnum,crop) '; sqlstr := sqlstr + ' values( '; sqlstr := sqlstr + ' cast( ''' + trim(INTTOSTR(i)) + '''as INT), '; // sqlstr := sqlstr + ' ''' + Trim(OrderNo.Text) + ''', '; sqlstr := sqlstr + ' ''' + Trim(fconsid) + ''', '; sqlstr := sqlstr + ' ''' + Trim(fconmid) + ''', '; sqlstr := sqlstr + ' ''' + trim(DName) + ''', '; // sqlstr := sqlstr + ' ''' + trim('') + ''', '; 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(CDS_1.FieldByName('BuyNO').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_1.FieldByName('BuyNAME').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_1.FieldByName('Salesman').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_NAME').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_CODE').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_Pattern').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_GramWeight').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_Width').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_COLOR').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('ConUnit').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_ColorNo').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_1.FieldByName('BUYCONNO').AsString) + ''', '; sqlstr := sqlstr + ' ''' + trim(CDS_2.FieldByName('C_StyleNo').AsString) + ''', '; sqlstr := sqlstr + ' cast( ''' + trim(PCpiece.Text) + '''as float), '; sqlstr := sqlstr + ' cast(''' + FPCQTY + '''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(CDS_2.FieldByName('C_CJSIZE').AsString) + ''' '; sqlstr := sqlstr + ' ) '; with ADOQueryCmd do begin close; sql.Clear; sql.Add(sqlstr); // showmessage(sql.Text); execsql; end; printcar(FPCIDS); // x := x + 1; end; initcard(); RefreshCardCount(); // 开卡后刷新TV2是否开卡、开卡捆数 cds_2.enableControls; cds_1.enableControls; toolbar2.enabled := true; panel4.enabled := true; carnum.Text := ''; PCQTY.Text := ''; // CDS_2.Locate('SSel', True, []); cxGrid1.enabled := true; CDS_2.Locate('consid', fconsid, []); // 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_3); // SInitCDSData(Ado_car, CDS_3); end; procedure TfrmSalesContractList2.BuyConNoChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmSalesContractList2.BuyNameChange(Sender: TObject); begin if ADOQueryMain.Active = False then Exit; SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_1); SInitCDSData(ADOQueryMain, CDS_1); end; procedure TfrmSalesContractList2.tchkClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; if Trim(DName) <> 'ADMIN' then begin application.MessageBox('非高权限不能审核', '提示'); exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''审核'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('审核成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.TnochkClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; if Trim(DName) <> 'ADMIN' then begin application.MessageBox('非高权限不能撤销审核', '提示'); exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''撤销审核'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('审核成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.cxTabControl1Change(Sender: TObject); begin SetStatus(); TBRafresh.Click; end; procedure TfrmSalesContractList2.C_CodeChange(Sender: TObject); begin SDofilter(ADOQUERY1, SGetFilters(Panel5, 1, 2)); SCreateCDS(ADOQUERY1, CDS_2); SInitCDSData(ADOQUERY1, CDS_2); end; procedure TfrmSalesContractList2.DYGSPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'dygs'; flagname := '打印格式'; if ShowModal = 1 then begin TEdit(Sender).Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmSalesContractList2.Tv1FocusedRecordChanged(Sender: TcxCustomGridTableView; APrevFocusedRecord, AFocusedRecord: TcxCustomGridRecord; ANewItemRecordFocusingChanged: Boolean); begin InitSub(); end; procedure TfrmSalesContractList2.TV2FocusedRecordChanged(Sender: TcxCustomGridTableView; APrevFocusedRecord, AFocusedRecord: TcxCustomGridRecord; ANewItemRecordFocusingChanged: Boolean); begin initcard(); end; procedure TfrmSalesContractList2.TV2CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); begin if TV2.GetColumnByFieldName('IsCard') = nil then exit; if AViewInfo.GridRecord.Values[TV2.GetColumnByFieldName('IsCard').Index] = True then ACanvas.Brush.Color := $0080FF80; end; procedure TfrmSalesContractList2.TqxClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''取消'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('取消成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.TnoqxClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''撤销取消'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); // ShowMessage(sql.Text); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('撤销取消成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.ToolButton5Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; try frmAttachmentUpload := TfrmAttachmentUpload.Create(Application); with frmAttachmentUpload do begin fkeyNO := Trim(Self.CDS_1.fieldbyname('ConMID').AsString); fType := '合同'; if ShowModal = 1 then begin end; end; finally frmAttachmentUpload.Free; end; end; procedure TfrmSalesContractList2.ToolButton6Click(Sender: TObject); begin if CDS_3.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; try with CDS_3 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin try ADOQueryCmd.Connection.BeginTrans; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('select * from Trade_Plan_Glide_OutPut where PCID=''' + Trim(CDS_3.fieldbyname('PCID').AsString) + ''''); Open; end; if ADOQueryTemp.IsEmpty = False then begin CDS_3.EnableControls; Application.MessageBox('已产生明细数据不能删除!', '提示', 0); ADOQueryCmd.Connection.RollbackTrans; Exit; end; // else with ADOQueryCmd do begin Close; Sql.Clear; Sql.Add('exec P_Trade_Card_Del '); Sql.Add('@PCIDS=' + quotedstr(Trim(CDS_3.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))); ADOQueryCmd.Connection.CommitTrans; except ADOQueryCmd.Connection.RollbackTrans; raise Exception.Create(PChar(Exception(ExceptObject).Message)); end; end; Next; end; EnableControls; end; initcard(); RefreshCardCount(); // 删卡后刷新TV2是否开卡、开卡捆数 except CDS_3.EnableControls; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); end; end; procedure TfrmSalesContractList2.ToolButton7Click(Sender: TObject); begin writeCxGrid(trim(Self.Caption) + 'tv1', Tv1, '销售合同管理'); writeCxGrid(trim(Self.Caption) + 'tv2', Tv2, '销售合同管理'); end; procedure TfrmSalesContractList2.ToolButton8Click(Sender: TObject); var MPCIDS, WSql: string; Bmk: TBookmark; // 保存原始选中行书签 begin if CDS_2.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; // ========== 保存当前行书签(关键:记住最初选中那条) ========== Bmk := CDS_2.GetBookmark; with CDS_2 do begin DisableControls; First; while not Eof do begin if FieldByName('Ssel').AsBoolean then begin MPCIDS := MPCIDS + trim(CDS_2.FieldByName('consid').AsString) + ';'; end; Next; end; EnableControls; end; with ADOQueryTemp 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 ADOQueryTemp.RecordCount > 1 then begin Application.MessageBox('请选择相同工序的卡编辑!', '提示', 0); CDS_2.GotoBookmark(Bmk); // 校验失败也要回去 CDS_2.FreeBookmark(Bmk); Exit; end; try frmDyeCardGlideEdit2 := TfrmDyeCardGlideEdit2.Create(Application); with frmDyeCardGlideEdit2 do begin FPCIDS := MPCIDS; FWSql := MPCIDS; if ShowModal = 1 then begin InitCard(); // 刷新CDS_2数据 end; end; finally frmDyeCardGlideEdit2.Free; end; // ========== 刷新完数据后,定位回原始选中行 ========== CDS_2.GotoBookmark(Bmk); CDS_2.FreeBookmark(Bmk); // 释放书签 end; // if CDS_3.Locate('SSel', True, []) = False then // begin // Application.MessageBox('没有选择数据!', '提示', 0); // Exit; // end; // with CDS_3 do // begin // DisableControls; // First; // while not Eof do // begin // if Fieldbyname('Ssel').AsBoolean then // begin // MPCIDS := MPCIDS + trim(CDS_3.FieldByName('PCID').AsString) + ';'; // end; // Next; // end; // EnableControls; // end; // // with CDS_3 do // begin // DisableControls; // First; // while not Eof do // begin // if Fieldbyname('Ssel').AsBoolean then // begin // if WSql <> '' then // begin // WSql := WSql + ',' + quotedstr(Trim(CDS_3.fieldbyname('PCID').AsString)); // end // else // begin // WSql := quotedstr(Trim(CDS_3.fieldbyname('PCID').AsString)); // end; // // end; // Next; // end; // EnableControls; // end; // // with ADOQueryTemp 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 ADOQueryTemp.RecordCount > 1 then // begin // Application.MessageBox('请选择相同工序的卡编辑!', '提示', 0); // Exit; // end; // // try // frmDyeCardGlideEdit := TfrmDyeCardGlideEdit.Create(Application); // with frmDyeCardGlideEdit do // begin // FPCIDS := MPCIDS; // FWSql := WSql; // // if ShowModal = 1 then // begin // InitCard(); // end; // end; // finally // frmDyeCardGlideEdit.Free; // end; procedure TfrmSalesContractList2.ToolButton9Click(Sender: TObject); var WSql: string; CurRow: Integer; begin WSql := ''; if CDS_2.IsEmpty then Exit; if CDS_2.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; with CDS_2 do begin DisableControls; First; while not Eof do begin if Fieldbyname('Ssel').AsBoolean then begin CurRow := Tv1.Controller.FocusedRowIndex; if WSql <> '' then begin WSql := WSql + ',' + (Trim(CDS_2.fieldbyname('consid').AsString)); end else begin WSql := (Trim(CDS_2.fieldbyname('consid').AsString)); end; end; Next; end; EnableControls; end; // WSql := (Trim(CDS_2.fieldbyname('PCID').AsString)); // showmessage(WSql); Tv2.Controller.FocusedRowIndex := CurRow; try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'contractsubPrint'; FFiltration1 := WSql; if ShowModal = 1 then begin end; end; finally frmLabelPrint.Free; end; end; procedure TfrmSalesContractList2.btnWCCXClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; if Trim(DName) <> 'ADMIN' then begin application.MessageBox('非高权限不能撤销完成', '提示'); exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''撤销完成'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('撤销完成成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.Tv1CustomDrawCell(Sender: TcxCustomGridTableView; ACanvas: TcxCanvas; AViewInfo: TcxGridTableDataCellViewInfo; var ADone: Boolean); begin if AViewInfo.GridRecord.Values[tv1.GetColumnByFieldName('status').Index] = '2' then ACanvas.Brush.Color := clLime; if AViewInfo.GridRecord.Values[tv1.GetColumnByFieldName('DJstatus').Index] = '1' then ACanvas.Brush.Color := clAQUA; end; procedure TfrmSalesContractList2.btnTijiaoClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''提交'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('提交成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmSalesContractList2.CurrencyChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmSalesContractList2.btnCXTijiaoClick(Sender: TObject); var MConMIDS: string; begin if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; with CDS_1 do begin DisableControls; First; MConMIDS := ''; while not eof do begin if fieldbyname('SSel').AsBoolean then begin MConMIDS := MConMIDS + trim(fieldbyname('ConMID').AsString) + ','; end; next; end; MConMIDS := copy(MConMIDS, 1, Length(MConMIDS) - 1); EnableControls; end; try with ADOQueryCmd do begin Close; sql.Clear; sql.Add(' exec P_BS_Contract_SetStatus '); sql.Add(' @ConMIDS=' + QuotedStr(MConMIDS)); sql.Add(',@Operation=''撤销提交'' '); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); 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('合同ID:' + trim(MConMIDS)))); sql.Add(',' + quotedstr(trim('成功'))); sql.Add(')'); open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); application.MessageBox('撤销提交成功', '提示'); InitGrid(); except application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; end.