D10clhege/A01基础公司管理/U_EmployeeBZ.pas
DESKTOP-E401PHE\Administrator a9ceaeacaf 初
2026-11-14 17:01:56 +08:00

368 lines
9.2 KiB
ObjectPascal
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

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 (''<27><>װ<EFBFBD><D7B0><EFBFBD><EFBFBD>'',''<27>ü<EFBFBD><C3BC><EFBFBD><EFBFBD><EFBFBD>'',''<27><><EFBFBD>ҳ<EFBFBD><D2B3><EFBFBD>'',''<27><><EFBFBD>鳵<EFBFBD><E9B3B5>'')';
{$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 := '<27>ѷ<EFBFBD><D1B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա<EFBFBD><D4B1>(' + fbz + ')'
else
LabelBottom.Caption := '<27>ѷ<EFBFBD><D1B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա<EFBFBD><D4B1>';
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 := '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
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 := '<27>ð<EFBFBD><C3B0><EFBFBD><EFBFBD>»<EFBFBD><C2BB><EFBFBD>' + IntToStr(icount) + '<27><>Ա<EFBFBD><D4B1><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE><EFBFBD><EFBFBD><EFBFBD>齫<EFBFBD><E9BDAB><EFBFBD><EFBFBD>ЩԱ<D0A9><D4B1><EFBFBD>Ƴ<EFBFBD><C6B3><EFBFBD><EFBFBD>飬<EFBFBD>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
if Application.MessageBox(PChar(fsj), '<27><>ʾ', 32 + 4) <> IDYES then
Exit;
end
else
begin
if Application.MessageBox('ȷ<><C8B7>Ҫɾ<D2AA><C9BE><EFBFBD>ð<EFBFBD><C3B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', '<27><>ʾ', 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('ɾ<><C9BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 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('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD><EFBFBD>飡', '<27><>ʾ', 0);
Exit;
end;
fsj := 'ȷ<><C8B7>Ҫ<EFBFBD><D2AA><EFBFBD><EFBFBD>Ա<EFBFBD><D4B1><EFBFBD><EFBFBD><EFBFBD>䵽<EFBFBD><E4B5BD><EFBFBD><EFBFBD>[' + fbz + ']<5D><><EFBFBD><EFBFBD>';
if Application.MessageBox(PChar(fsj), '<27><>ʾ', 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('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 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('ȷ<><C8B7>Ҫ<EFBFBD>Ƴ<EFBFBD><C6B3><EFBFBD>Ա<EFBFBD><D4B1><EFBFBD>İ<EFBFBD><C4B0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', '<27><>ʾ', 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('<27>Ƴ<EFBFBD><C6B3><EFBFBD><EFBFBD><EFBFBD>ʧ<EFBFBD>ܣ<EFBFBD>', '<27><>ʾ<EFBFBD><CABE>Ϣ', 0);
Exit;
end;
InitTop();
InitBottom();
end;
procedure TfrmEmployeeBZ.TBCloseClick(Sender: TObject);
begin
Close;
end;
end.