unit U_EmployeeBZ; 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, cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxGrid, DBClient, cxSplitter, cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, U_BaseList, dxSkinsCore, dxSkinsDefaultPainters, dxScrollbarAnnotations, dxDateRanges; type TfrmEmployeeBZ = class(TfrmBaseList) ToolBar1: TToolBar; TBRafresh: TToolButton; TBClose: TToolButton; PanelZD: TPanel; ToolBar2: TToolBar; TBAddZD: TToolButton; TBDelZD: TToolButton; cxGridZD: TcxGrid; TVZD: TcxGridDBTableView; TVZDZdyName: TcxGridDBColumn; cxGridZDLevel1: TcxGridLevel; cxSplitter1: TcxSplitter; PanelMain: TPanel; PanelTop: TPanel; LabelTop: TLabel; cxGridTop: TcxGrid; TvTop: TcxGridDBTableView; TvTopEECode: TcxGridDBColumn; TvTopEEName: TcxGridDBColumn; TvTopDept: TcxGridDBColumn; cxGridTopLevel1: TcxGridLevel; Panel1: TPanel; Label1: TLabel; Label4: TLabel; EEName: TEdit; Dept: TEdit; cxSplitter2: TcxSplitter; PanelTip: TPanel; LabelTip: TLabel; PanelBottom: TPanel; LabelBottom: TLabel; cxGridBottom: TcxGrid; TvBottom: TcxGridDBTableView; TvBottomEECode: TcxGridDBColumn; TvBottomEEName: TcxGridDBColumn; TvBottomDept: TcxGridDBColumn; cxGridBottomLevel1: TcxGridLevel; ADOQueryZD: TADOQuery; ADOQueryTop: TADOQuery; ADOQueryBottom: TADOQuery; DataSource1: TDataSource; DataSource2: TDataSource; DataSource3: TDataSource; CDS_Top: TClientDataSet; CDS_Bottom: TClientDataSet; CDS_ZD: TClientDataSet; cxStyleRepository1: TcxStyleRepository; cxStyle1: TcxStyle; procedure FormDestroy(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure FormShow(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure TBRafreshClick(Sender: TObject); procedure TBAddZDClick(Sender: TObject); procedure TBDelZDClick(Sender: TObject); procedure TvTopCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); procedure TvBottomCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); procedure CDS_ZDAfterScroll(DataSet: TDataSet); procedure EENameKeyPress(Sender: TObject; var Key: Char); private FIniting: Boolean; function GetZDName(): string; procedure InitZD(); procedure InitTop(); procedure InitBottom(); { Private declarations } public { Public declarations } end; var frmEmployeeBZ: TfrmEmployeeBZ; implementation uses U_DataLink, U_RTFun, U_ZDYHelp; const SUserDept = 'Udept in (''包装车间'',''裁剪车间'',''缝纫车间'',''检验车间'')'; {$R *.dfm} procedure TfrmEmployeeBZ.FormDestroy(Sender: TObject); begin inherited; frmEmployeeBZ := nil; end; procedure TfrmEmployeeBZ.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := caFree; end; function TfrmEmployeeBZ.GetZDName(): string; begin Result := ''; if CDS_ZD.Active and (not CDS_ZD.IsEmpty) then Result := Trim(CDS_ZD.FieldByName('ZdyName').AsString); end; procedure TfrmEmployeeBZ.InitZD(); begin FIniting := True; try ADOQueryZD.DisableControls; with ADOQueryZD do begin Close; SQL.Clear; SQL.Add('select ZdyNo,ZdyName from KH_ZDY where Type=''BZNAME'' order by ZdyNo'); Open; end; SCreateCDS(ADOQueryZD, CDS_ZD); SInitCDSData(ADOQueryZD, CDS_ZD); finally ADOQueryZD.EnableControls; FIniting := False; end; end; procedure TfrmEmployeeBZ.InitTop(); begin try ADOQueryTop.DisableControls; with ADOQueryTop do begin Close; SQL.Clear; SQL.Add('select * from SY_User where ' + SUserDept); SQL.Add(' and (bzname is null or bzname='''')'); if Trim(EEName.Text) <> '' then SQL.Add(' and UserName like ''%' + Trim(EEName.Text) + '%'''); if Trim(Dept.Text) <> '' then SQL.Add(' and Udept like ''%' + Trim(Dept.Text) + '%'''); SQL.Add(' order by UserID'); Open; end; SCreateCDS(ADOQueryTop, CDS_Top); SInitCDSData(ADOQueryTop, CDS_Top); finally ADOQueryTop.EnableControls; end; end; procedure TfrmEmployeeBZ.InitBottom(); var fbz: string; begin fbz := GetZDName(); if fbz <> '' then LabelBottom.Caption := '已分配班组员工(' + fbz + ')' else LabelBottom.Caption := '已分配班组员工'; try ADOQueryBottom.DisableControls; with ADOQueryBottom do begin Close; SQL.Clear; SQL.Add('select * from SY_User where ' + SUserDept); SQL.Add(' and bzname is not null and bzname<>'''''); if fbz <> '' then SQL.Add(' and bzname=''' + fbz + ''''); SQL.Add(' order by bzname,UserID'); Open; end; SCreateCDS(ADOQueryBottom, CDS_Bottom); SInitCDSData(ADOQueryBottom, CDS_Bottom); finally ADOQueryBottom.EnableControls; end; end; procedure TfrmEmployeeBZ.CDS_ZDAfterScroll(DataSet: TDataSet); begin if FIniting then Exit; InitBottom(); end; procedure TfrmEmployeeBZ.EENameKeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then InitTop(); end; procedure TfrmEmployeeBZ.FormShow(Sender: TObject); begin inherited; InitZD(); InitTop(); InitBottom(); end; procedure TfrmEmployeeBZ.TBRafreshClick(Sender: TObject); begin EEName.Clear; Dept.Clear; InitZD(); InitTop(); InitBottom(); end; procedure TfrmEmployeeBZ.TBAddZDClick(Sender: TObject); begin try frmZDYHelp := TfrmZDYHelp.Create(Application); with frmZDYHelp do begin flag := 'BZNAME'; flagname := '班组名称'; if ShowModal = 1 then begin InitZD(); InitBottom(); end; end; finally frmZDYHelp.Free; end; end; procedure TfrmEmployeeBZ.TBDelZDClick(Sender: TObject); var fbz, fno, fsj: string; icount: Integer; begin if not (CDS_ZD.Active and (not CDS_ZD.IsEmpty)) then Exit; fbz := Trim(CDS_ZD.FieldByName('ZdyName').AsString); fno := Trim(CDS_ZD.FieldByName('ZdyNo').AsString); if (fbz = '') or (fno = '') then Exit; icount := 0; with ADOQueryBaseTemp do begin Close; SQL.Clear; SQL.Add('select count(*) as icount from SY_User where bzname=''' + fbz + ''''); Open; icount := FieldByName('icount').AsInteger; Close; end; if icount > 0 then begin fsj := '该班组下还有' + IntToStr(icount) + '名员工,删除班组将把这些员工移出班组,是否继续?'; if Application.MessageBox(PChar(fsj), '提示', 32 + 4) <> IDYES then Exit; end else begin if Application.MessageBox('确定要删除该班组吗?', '提示', 32 + 4) <> IDYES then Exit; end; try ADOQueryBaseCmd.Connection.BeginTrans; with ADOQueryBaseCmd do begin Close; SQL.Clear; SQL.Add('update SY_User set bzname=null where bzname=''' + fbz + ''''); ExecSQL; end; with ADOQueryBaseCmd do begin Close; SQL.Clear; SQL.Add('delete KH_ZDY where ZdyNo=''' + fno + ''' and Type=''BZNAME'''); ExecSQL; end; ADOQueryBaseCmd.Connection.CommitTrans; except ADOQueryBaseCmd.Connection.RollbackTrans; Application.MessageBox('删除班组失败!', '提示信息', 0); Exit; end; InitZD(); InitTop(); InitBottom(); end; procedure TfrmEmployeeBZ.TvTopCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); var fbz, fsj: string; begin if CDS_Top.IsEmpty then Exit; fbz := GetZDName(); if fbz = '' then begin Application.MessageBox('请先在左侧选择班组!', '提示', 0); Exit; end; fsj := '确定要将该员工分配到班组[' + fbz + ']吗?'; if Application.MessageBox(PChar(fsj), '提示', 32 + 4) <> IDYES then Exit; try with ADOQueryBaseCmd do begin Close; SQL.Clear; SQL.Add('update SY_User set bzname=''' + fbz + ''''); SQL.Add(' where UserID=''' + Trim(CDS_Top.FieldByName('UserID').AsString) + ''''); ExecSQL; end; except Application.MessageBox('分配班组失败!', '提示信息', 0); Exit; end; InitTop(); InitBottom(); end; procedure TfrmEmployeeBZ.TvBottomCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean); begin if CDS_Bottom.IsEmpty then Exit; if Application.MessageBox('确定要移出该员工的班组吗?', '提示', 32 + 4) <> IDYES then Exit; try with ADOQueryBaseCmd do begin Close; SQL.Clear; SQL.Add('update SY_User set bzname=null'); SQL.Add(' where UserID=''' + Trim(CDS_Bottom.FieldByName('UserID').AsString) + ''''); ExecSQL; end; except Application.MessageBox('移出班组失败!', '提示信息', 0); Exit; end; InitTop(); InitBottom(); end; procedure TfrmEmployeeBZ.TBCloseClick(Sender: TObject); begin Close; end; end.