delaccountformunit.pas

人事管理系统帮助人们管理复杂的关系

unit delAccountFormUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, ExtCtrls, Grids, DBGrids;

type
  TdelAccountForm = class(TForm)
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    procedure FormShow(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  delAccountForm: TdelAccountForm;

implementation

uses DataMUnit, LoginFormUnit;

{$R *.dfm}

procedure TdelAccountForm.FormShow(Sender: TObject);
begin
  if DataM.ADOLogin.Active = true then
    DataM.ADOLogin.Close;

  DataM.ADOLogin.SQL.Clear;

  if LoginForm.CBPurview.Text = '总经理' then
    DataM.ADOLogin.SQL.Text:=' select * from Login ';

  if LoginForm.CBPurview.Text = '人事经理' then
    DataM.ADOLogin.SQL.Text:='select * from Login Where Purview <> '''+ '人事经理'
                            +''''+ ' and Purview <> ''' + '总经理'+'''';
  DataM.ADOLogin.Prepared;
  DataM.ADOLogin.Open;
end;

procedure TdelAccountForm.SpeedButton1Click(Sender: TObject);
var sel:integer;
begin
  sel:=MessageBox(0,'是否删除该帐户','人事管理系统',MB_YESNO+MB_ICONQUESTION);
  if sel=IDYES then
    DataM.ADOLogin.Delete;
end;

procedure TdelAccountForm.SpeedButton2Click(Sender: TObject);
begin
  delAccountForm.Close;
end;

end.