unit U_PurchaseContractList; 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, dxSkinOffice2013White, dxSkinWXI, dxScrollbarAnnotations; type TfrmPurchaseContractList = class(TfrmBaseList) ToolBar1: TToolBar; TBRafresh: TToolButton; TBFind: TToolButton; TBAdd: TToolButton; TBEdit: 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; v1ConNo: TcxGridDBColumn; CDS_2: TClientDataSet; v1CustomerNoName: TcxGridDBColumn; ToolButton1: TToolButton; v1Column1: TcxGridDBColumn; ToolButton2: TToolButton; 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; tchk: TToolButton; Tnochk: TToolButton; cxSplitter1: TcxSplitter; DS_2: TDataSource; Label2: TLabel; Tqx: TToolButton; Tnoqx: TToolButton; ToolButton5: TToolButton; v1Column10: TcxGridDBColumn; v1Column12: TcxGridDBColumn; v1Column9: TcxGridDBColumn; GPM_2: TcxGridPopupMenu; CDS_1: TClientDataSet; btnTijiao: TToolButton; btnCXTijiao: TToolButton; v1Column13: TcxGridDBColumn; Label3: TLabel; BuyConNoHZ: TEdit; Tv1Column2: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Tv1Column14: TcxGridDBColumn; Label6: TLabel; HZSCSEName: TEdit; pm1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; btnWC: TToolButton; btnWCCX: TToolButton; Label7: TLabel; MiddleName: TEdit; ADOQueryImage: TADOQuery; Tv1Column19: TcxGridDBColumn; IsJYTime: TCheckBox; ToolButton7: TToolButton; N3: TMenuItem; N4: TMenuItem; Tv1Column25: TcxGridDBColumn; cxGrid2: TcxGrid; TV2: TcxGridDBTableView; 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; cxGridLevel1: TcxGridLevel; N5: TMenuItem; N6: TMenuItem; Tv1Column1: TcxGridDBColumn; ToolButton3: TToolButton; TV2Column1: TcxGridDBColumn; TV2Column2: TcxGridDBColumn; TV2Column3: TcxGridDBColumn; TV2Column4: TcxGridDBColumn; TV2Column5: TcxGridDBColumn; TV2Column6: TcxGridDBColumn; TV2Column7: TcxGridDBColumn; TV2Column8: TcxGridDBColumn; TV2Column9: TcxGridDBColumn; TV2Column10: TcxGridDBColumn; TV2Column11: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; Tv1Column15: TcxGridDBColumn; Tv1Column16: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; TV2Column12: TcxGridDBColumn; TV2Column13: TcxGridDBColumn; TV2Column14: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; contractNO: TEdit; Label1: TLabel; TV2Column15: TcxGridDBColumn; Tv1Column18: TcxGridDBColumn; TV2Column16: TcxGridDBColumn; TV2Column17: TcxGridDBColumn; ToolButton4: TToolButton; ToolButton6: TToolButton; TV2Column19: TcxGridDBColumn; TV2Column18: TcxGridDBColumn; Label10: TLabel; SellName: TEdit; Tv1Column20: TcxGridDBColumn; Tv1Column21: TcxGridDBColumn; TV2Column20: TcxGridDBColumn; TV2Column21: TcxGridDBColumn; Panel2: TPanel; Label11: TLabel; Edit1: TEdit; Button1: TButton; Button2: TButton; ToolButton8: TToolButton; ToolButton9: TToolButton; Tv1Column22: TcxGridDBColumn; Tv1Column23: TcxGridDBColumn; Tv1Column24: TcxGridDBColumn; 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 Tv1CellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); 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 ToolButton4Click(Sender: TObject); procedure ToolButton6Click(Sender: TObject); procedure ConNoChange(Sender: TObject); procedure BuyConNoHZChange(Sender: TObject); procedure contractNOChange(Sender: TObject); procedure TextEdit(Sender: TObject); procedure TV2Column21PropertiesEditValueChanged(Sender: TObject); procedure ToolButton9Click(Sender: TObject); procedure ToolButton8Click(Sender: TObject); procedure Button2Click(Sender: TObject); procedure Button1Click(Sender: TObject); private fFlileFlag: string; procedure InitGrid(); procedure SetStatus(); procedure InitSub(); procedure InitImage(); { Private declarations } public FFInt, FCloth: Integer; FAuthority, FGSTT, FSubIdS: string; { Public declarations } end; implementation uses U_DataLink, U_PurchaseConInPut, U_RTFun, U_AttachmentUpload, U_LabelPrint; {$R *.dfm} procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.InitSub(); begin if CDS_1.IsEmpty then exit; with ADOQueryTemp do begin close; sql.Clear; sql.Add('select * from BS_Contract_sub A '); sql.Add('where ConMID =' + quotedstr((CDS_1.fieldbyname('ConMID').AsString))); open; end; SCreateCDS(ADOQueryTemp, CDS_2); SInitCDSData(ADOQueryTemp, CDS_2); TV2.DataController.Filter.Clear; end; procedure TfrmPurchaseContractList.N1Click(Sender: TObject); begin SelOKNoFiler(Tv1, True); //全选 end; procedure TfrmPurchaseContractList.N2Click(Sender: TObject); begin SelOKNoFiler(Tv1, False); //全弃 end; procedure TfrmPurchaseContractList.N3Click(Sender: TObject); begin Clipboard.SetTextBuf(PChar(Trim(CDS_1.fieldbyname(TV1.Controller.FocusedColumn.DataBinding.FilterFieldName).AsString))); end; procedure TfrmPurchaseContractList.N4Click(Sender: TObject); begin Clipboard.SetTextBuf(PChar(Trim(CDS_1.fieldbyname(TV1.Controller.FocusedColumn.DataBinding.FilterFieldName).AsString))); end; procedure TfrmPurchaseContractList.N5Click(Sender: TObject); begin SelOKNo(CDS_1, True); end; procedure TfrmPurchaseContractList.N6Click(Sender: TObject); begin SelOKNo(CDS_1, False); end; procedure TfrmPurchaseContractList.SetStatus(); begin TBAdd.Enabled := false; tbedit.Enabled := false; // tbedit.Enabled := true; ToolButton2.Enabled := false; tchk.Enabled := false; tnochk.Enabled := false; Tqx.Enabled := false; TNoqx.Enabled := false; TBPrint.Enabled := False; btnTijiao.Enabled := False; btnCXTijiao.Enabled := False; btnWC.Enabled := False; btnWCCX.Enabled := False; ToolButton3.Enabled := False; if Trim(FAuthority) = '录入' then begin ToolButton2.Enabled := true; TBAdd.Enabled := true; TBPrint.Enabled := True; case cxTabControl1.TabIndex of 0: begin tbedit.Enabled := true; Tqx.Enabled := True; btnTijiao.Enabled := True; ToolButton3.Enabled := True; end; 1: begin // tbedit.Enabled := True; btnCXTijiao.Enabled := True; ToolButton3.Enabled := True; end; 2: begin if (Trim(DName) = 'ADMIN') or (Trim(DName) = 'ML02') or (Trim(DName) = 'ML03') or (Trim(DName) = 'ML04') or (Trim(DName) = 'ML05') or (Trim(DName) = 'ML06') or (Trim(DName) = 'ML07') or (Trim(DName) = 'ML08') or (Trim(DName) = 'ML09') or (Trim(DName) = '赵洁舲') or (Trim(DName) = '张琳') then begin tbedit.Enabled := True; end; // btnWC.Enabled := True; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; 3: begin btnWCCX.Enabled := True; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; 4: begin TNoqx.Enabled := True; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; end; end; if Trim(FAuthority) = '管理' then begin ToolButton2.Enabled := true; TBAdd.Enabled := true; TBPrint.Enabled := True; case cxTabControl1.TabIndex of 0: begin tbedit.Enabled := true; Tqx.Enabled := true; btnTijiao.Enabled := True; ToolButton3.Enabled := True; end; 1: begin // tbedit.Enabled := True; btnCXTijiao.Enabled := True; tchk.Enabled := True; ToolButton3.Enabled := True; end; 2: begin if (Trim(DName) = 'ADMIN') or (Trim(DName) = 'ML02') or (Trim(DName) = 'ML03') or (Trim(DName) = 'ML04') or (Trim(DName) = 'ML05') or (Trim(DName) = 'ML06') or (Trim(DName) = 'ML07') or (Trim(DName) = 'ML08') or (Trim(DName) = 'ML09') or (Trim(DName) = '赵洁舲') or (Trim(DName) = '张琳') then begin tbedit.Enabled := True; end; // tbedit.Enabled := True; tnochk.Enabled := True; btnWC.Enabled := True; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; 3: begin btnWCCX.Enabled := True; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; 4: begin TNoqx.Enabled := true; if Trim(DName) = 'ADMIN' then begin ToolButton3.Enabled := True; end else begin ToolButton3.Enabled := False; end; end; end; end; if Trim(FAuthority) = '查询' then begin TBPrint.Enabled := True; end; end; procedure TfrmPurchaseContractList.FormDestroy(Sender: TObject); begin inherited; // frmPurchaseContractList:=nil; end; procedure TfrmPurchaseContractList.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := caFree; end; procedure TfrmPurchaseContractList.FormCreate(Sender: TObject); begin inherited; EndDate.DateTime := SGetServerDate(ADOQueryTemp); BegDate.DateTime := EndDate.DateTime - 90; end; procedure TfrmPurchaseContractList.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmPurchaseContractList.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); with ADOQueryTemp do begin Close; SQL.Clear; SQL.Add('select * from SY_User where UserName=' + quotedstr(Trim(DName))); Open; end; try ADOQueryMain.DisableControls; with ADOQueryMain do begin Filtered := False; Close; sql.Clear; sql.Add('select AA.* ,DJStatus=case when (select getDate())>DlyDate and status in (''0'',''1'',''9'') then 1 else 0 end '); sql.Add(',DJStatus1=case when THstatus =''1'' then 1 else 0 end'); sql.Add('from (select A.*'); 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=(select sum(C.ConTotalAmount) from BS_Contract_Sub C where C.conmid=A.conmid)'); 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; 5: begin sql.Add(' and isnull(AA.dsstatus,''0'')=''1'' and AA.ConType=''印染'''); end; 6: begin sql.Add(' and isnull(AA.dsstatus,''0'')=''0'' and AA.ConType=''印染'''); end; end; if (Trim(DName) <> 'ADMIN') and (Trim(DName) <> '赵洁舲') and (ADOQueryTemp.fieldbyname('Udept').AsString <> '仓库管理') then begin sql.Add('and Filler=''' + Trim(DName) + ''' '); end; // showmessage(sql.text); Open; end; SCreateCDS(ADOQueryMain, CDS_1); SInitCDSData(ADOQueryMain, CDS_1); finally ADOQueryMain.EnableControls; TV1.DataController.Filter.Clear; end; end; procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.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; WSql := ''; CDS_1.DisableControls; with CDS_1 do begin First; while not Eof do begin if CDS_1.fieldbyname('SSel').AsBoolean then begin if WSql <> '' then begin WSql := WSql + ',' + quotedstr(Trim(CDS_1.fieldbyname('ConMID').AsString)); end else begin WSql := quotedstr(Trim(CDS_1.fieldbyname('ConMID').AsString)); end; end; Next; end; end; CDS_1.Locate('SSel', True, []); Tv1.OnFocusedRecordChanged := Tv1FocusedRecordChanged; CDS_1.EnableControls; // showmessage(WSql) ; try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'SalesConPrint'; // FFiltration1 := QuotedStr(Trim(Self.CDS_1.fieldbyname('ConMID').AsString)); FFiltration1 := WSql; if ShowModal = 1 then begin // Self.InitGrid(); end; end; finally frmLabelPrint.Free; end; end; procedure TfrmPurchaseContractList.TBEditClick(Sender: TObject); begin if CDS_1.IsEmpty then Exit; // ShowMessage(Trim(CDS_1.fieldbyname('Filler').AsString)); // ShowMessage(Trim(DName)); if (Trim(DName) <> 'ADMIN') and (Trim(DName) <> '张琳') then begin if Trim(CDS_1.fieldbyname('Filler').AsString) <> Trim(DName) then begin Application.MessageBox('不能操作他人的数据!', '提示', 0); Exit; end; end; try frmPurchaseConInPut := TfrmPurchaseConInPut.Create(Application); with frmPurchaseConInPut 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 frmPurchaseConInPut.Free; end; end; procedure TfrmPurchaseContractList.TBRafreshClick(Sender: TObject); begin InitGrid(); end; procedure TfrmPurchaseContractList.TBAddClick(Sender: TObject); var maxno: string; begin try frmPurchaseConInPut := TfrmPurchaseConInPut.Create(Application); with frmPurchaseConInPut do begin PState := '新增'; FConMId := ''; FAuthority := self.FAuthority; FGSTT := self.FGSTT; fFlileFlag := self.fFlileFlag; if ShowModal = 1 then begin end; end; finally frmPurchaseConInPut.Free; end; end; procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.Tv1CellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); begin if ToolButton1.Visible = False then Exit; ToolButton1.Click; end; procedure TfrmPurchaseContractList.CheckBox1Click(Sender: TObject); begin InitGrid(); end; procedure TfrmPurchaseContractList.CheckBox2Click(Sender: TObject); begin TBRafresh.Click; end; procedure TfrmPurchaseContractList.ConNoChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmPurchaseContractList.ConNoKeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then begin InitGrid(); end; end; procedure TfrmPurchaseContractList.ToolButton1Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; try frmPurchaseConInPut := TfrmPurchaseConInPut.Create(Application); with frmPurchaseConInPut 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 frmPurchaseConInPut.Free; end; end; procedure TfrmPurchaseContractList.ToolButton2Click(Sender: TObject); begin if CDS_1.IsEmpty then Exit; try frmPurchaseConInPut := TfrmPurchaseConInPut.Create(Application); with frmPurchaseConInPut 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 frmPurchaseConInPut.Free; end; end; procedure TfrmPurchaseContractList.ToolButton3Click(Sender: TObject); begin // inherited; if CDS_1.IsEmpty then exit; if not CDS_1.Locate('SSel', True, []) then begin application.MessageBox('请选择数据', '提示'); Exit; end; if Application.MessageBox('确定要删除数据吗?删除后数据不能恢复。', '提示', 32 + 4) <> IDYES then Exit; with CDS_1 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 Bs_Contract_Sub SET CGstatus=''0'' WHERE consid in'); sql.Add('(select A.subid from Bs_Contract_Sub A where ConMId=''' + Trim(CDS_1.fieldbyname('ConMId').AsString) + ''')'); sql.add('insert into Bs_Contract_Main_DEL select * from BS_Contract_Main where ConMid=''' + trim(CDS_1.fieldbyname('ConMid').AsString) + ''' '); sql.add('insert into Bs_Contract_sub_DEL select * from BS_Contract_sub where ConMid=''' + trim(CDS_1.fieldbyname('ConMid').AsString) + ''' '); sql.Add('DELETE from BS_Contract_Main where ConMid=''' + trim(CDS_1.fieldbyname('ConMid').AsString) + ''' '); sql.Add('DELETE from BS_Contract_sub where ConMid=''' + trim(CDS_1.fieldbyname('ConMid').AsString) + ''' '); ExecSQL; end; end; next; end; EnableControls; end; TBRafresh.Click; end; procedure TfrmPurchaseContractList.ToolButton4Click(Sender: TObject); var MConMIDS: string; begin // inherited; 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 TfrmPurchaseContractList.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) = '刘丽平') or (Trim(DName) = '吴津') or (Trim(DName) = '周帅帅') or (Trim(DName) = 'YW01') or (Trim(DName) = 'YW02') or (Trim(DName) = 'YW03') or (Trim(DName) = 'YW04') or (Trim(DName) = 'YW05') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW08') or (Trim(DName) = 'YW09') or (Trim(DName) = 'YW10') or (Trim(DName) = 'YW11') or (Trim(DName) = 'YW12') or (Trim(DName) = 'YW13') or (Trim(DName) = 'YW14') or (Trim(DName) = 'YW15') or (Trim(DName) = 'YW16') or (Trim(DName) = 'YW17') or (Trim(DName) = 'YW010') then begin Application.MessageBox('此账号不能操作数据!', '提示', 0); Exit; end; if (Trim(DName) <> 'ADMIN') and (Trim(DName) <> '张琳') then begin if Trim(CDS_1.fieldbyname('Filler').AsString) <> Trim(DName) then begin Application.MessageBox('不能操作他人的数据!', '提示', 0); Exit; end; 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 TfrmPurchaseContractList.Button1Click(Sender: TObject); begin // inherited; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('Update BS_Contract_main '); sql.Add('Set THYY=''' + Trim(Edit1.text) + ''''); sql.Add(',THStatus=''1'',Status=''0'''); sql.Add('where ConMId=''' + Trim(CDS_1.fieldbyname('ConMId').AsString) + ''''); ExecSQL; end; application.MessageBox('退回成功', '提示'); InitGrid(); Panel2.Visible := False; end; procedure TfrmPurchaseContractList.Button2Click(Sender: TObject); begin // inherited; Panel2.Visible := False; end; procedure TfrmPurchaseContractList.BuyConNoHZChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.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 TfrmPurchaseContractList.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 TfrmPurchaseContractList.contractNOChange(Sender: TObject); begin // inherited; TBFind.Click; end; procedure TfrmPurchaseContractList.cxTabControl1Change(Sender: TObject); begin SetStatus(); TBRafresh.Click; end; procedure TfrmPurchaseContractList.Tv1FocusedRecordChanged(Sender: TcxCustomGridTableView; APrevFocusedRecord, AFocusedRecord: TcxCustomGridRecord; ANewItemRecordFocusingChanged: Boolean); begin InitSub(); end; procedure TfrmPurchaseContractList.TV2Column21PropertiesEditValueChanged(Sender: TObject); var mvalue, FFieldName: string; begin // inherited; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('select A.*,B.* '); sql.Add('from BS_Contract_main A'); sql.Add('inner join BS_Contract_sub B on A.ConMId=B.ConMId'); sql.Add('where B.ConSId=''' + Trim(CDS_2.fieldbyname('ConSId').AsString) + ''''); sql.Add('and A.status=''9'' '); open; end; if ADOQueryTemp.IsEmpty = False then begin if (Trim(DName) = '刘丽平') or (Trim(DName) = '吴津') or (Trim(DName) = '周帅帅') or (Trim(DName) = 'YW01') or (Trim(DName) = 'YW02') or (Trim(DName) = 'YW03') or (Trim(DName) = 'YW04') or (Trim(DName) = 'YW05') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW08') or (Trim(DName) = 'YW09') or (Trim(DName) = 'YW10') or (Trim(DName) = 'YW11') or (Trim(DName) = 'YW12') or (Trim(DName) = 'YW13') or (Trim(DName) = 'YW14') or (Trim(DName) = 'YW15') or (Trim(DName) = 'YW16') or (Trim(DName) = 'YW17') or (Trim(DName) = 'YW010') then begin Application.MessageBox('此账号不能操作数据!', '提示', 0); Exit; end; mvalue := TcxTextEdit(Sender).EditingText; FFieldName := Trim(Tv2.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_2 do begin Edit; FieldByName(FFieldName).Value := Trim(mvalue); Post; end; with ADOQueryCmd do begin Close; sql.Clear; sql.Add('Update BS_Contract_sub '); sql.Add(' Set ' + FFieldName + '=''' + Trim(mvalue) + ''''); sql.Add('where ConSId=''' + Trim(CDS_2.fieldbyname('ConSId').AsString) + ''''); ExecSQL; end; end; end; procedure TfrmPurchaseContractList.TextEdit(Sender: TObject); var mvalue, FFieldName: string; begin // inherited; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('select A.*,B.* '); sql.Add('from BS_Contract_main A'); sql.Add('inner join BS_Contract_sub B on A.ConMId=B.ConMId'); sql.Add('where B.ConSId=''' + Trim(CDS_2.fieldbyname('ConSId').AsString) + ''''); sql.Add('and A.status=''9'' '); open; end; // if ADOQueryTemp.IsEmpty = False then // begin if (Trim(DName) = '刘丽平') and (Trim(DName) = '吴津') and (Trim(DName) = '周帅帅') and (Trim(DName) = 'YW01') and (Trim(DName) = 'YW02') and (Trim(DName) = 'YW03') and (Trim(DName) = 'YW04') and (Trim(DName) = 'YW05') and (Trim(DName) = 'YW06') and (Trim(DName) = 'YW06') and (Trim(DName) = 'YW08') and (Trim(DName) = 'YW09') and (Trim(DName) = 'YW10') and (Trim(DName) = 'YW11') and (Trim(DName) = 'YW12') and (Trim(DName) = 'YW13') and (Trim(DName) = 'YW14') and (Trim(DName) = 'YW15') and (Trim(DName) = 'YW16') and (Trim(DName) = 'YW17') and (Trim(DName) = 'YW010') then begin Application.MessageBox('此账号不能操作数据!', '提示', 0); Exit; end; mvalue := TcxTextEdit(Sender).EditingText; FFieldName := Trim(Tv2.Controller.FocusedColumn.DataBinding.FilterFieldName); with CDS_2 do begin Edit; FieldByName(FFieldName).Value := Trim(mvalue); Post; end; with ADOQueryCmd do begin Close; sql.Clear; sql.Add('Update BS_Contract_sub '); sql.Add(' Set ' + FFieldName + '=''' + Trim(mvalue) + ''''); sql.Add('where ConSId=''' + Trim(CDS_2.fieldbyname('ConSId').AsString) + ''''); ExecSQL; end; // end; end; procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.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 TfrmPurchaseContractList.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 TfrmPurchaseContractList.ToolButton6Click(Sender: TObject); var MConMIDS: string; begin // inherited; 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 TfrmPurchaseContractList.ToolButton7Click(Sender: TObject); begin writeCxGrid(trim(Self.Caption) + 'tv1', Tv1, '销售合同管理'); writeCxGrid(trim(Self.Caption) + 'tv2', Tv2, '销售合同管理'); end; procedure TfrmPurchaseContractList.ToolButton8Click(Sender: TObject); begin // inherited; 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 TfrmPurchaseContractList.ToolButton9Click(Sender: TObject); begin // inherited; if (trim(DName) <> 'ADMIN') and (trim(DName) <> '张玫') and (trim(DName) <> '张琳') then begin application.MessageBox('此账号无退回权限!', '提示信息', 0); Exit; end; Panel2.Left := (self.Width - Panel2.Width) div 2; Panel2.Visible := true; end; procedure TfrmPurchaseContractList.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) = '刘丽平') or (Trim(DName) = '吴津') or (Trim(DName) = '周帅帅') or (Trim(DName) = 'YW01') or (Trim(DName) = 'YW02') or (Trim(DName) = 'YW03') or (Trim(DName) = 'YW04') or (Trim(DName) = 'YW05') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW06') or (Trim(DName) = 'YW08') or (Trim(DName) = 'YW09') or (Trim(DName) = 'YW10') or (Trim(DName) = 'YW11') or (Trim(DName) = 'YW12') or (Trim(DName) = 'YW13') or (Trim(DName) = 'YW14') or (Trim(DName) = 'YW15') or (Trim(DName) = 'YW16') or (Trim(DName) = 'YW17') or (Trim(DName) = 'YW010') then begin Application.MessageBox('此账号不能操作数据!', '提示', 0); Exit; end; if (Trim(DName) <> 'ADMIN') and (Trim(DName) <> '张琳') then begin if Trim(CDS_1.fieldbyname('Filler').AsString) <> Trim(DName) then begin Application.MessageBox('不能操作他人的数据!', '提示', 0); Exit; end; end; // if Trim(CDS_1.fieldbyname('Filler').AsString) <> Trim(DName) then // begin // Application.MessageBox('不能操作他人的数据!', '提示', 0); // 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 TfrmPurchaseContractList.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 := clRed; if AViewInfo.GridRecord.Values[tv1.GetColumnByFieldName('DJstatus1').Index] = '1' then ACanvas.Brush.Color := clAQUA; end; procedure TfrmPurchaseContractList.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 TfrmPurchaseContractList.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.