bmb1.pas

职工信息管理系统的源代码

unit bmb1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, jpeg, ExtCtrls, DBCtrls, DB, DBTables, Buttons,shellapi;

type
  Tbmb = class(TForm)
    Label2: TLabel;
    Label1: TLabel;
    Edit2: TEdit;
    Edit1: TEdit;
    DataSource1: TDataSource;
    bmb: TTable;
    bmbBDEDesigner: TStringField;
    bmbBDEDesigner2: TStringField;
    DBNavigator1: TDBNavigator;
    button1: TSpeedButton;
    Button4: TSpeedButton;
    Button3: TSpeedButton;
    button2: TSpeedButton;
    Button5: TSpeedButton;
    button6: TSpeedButton;
    bitbtn1: TSpeedButton;
    procedure Button6Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure FormPaint(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  bmb: Tbmb;
    f:integer;
implementation
  uses quan;
{$R *.dfm}

procedure Tbmb.Button6Click(Sender: TObject);
begin
if button5.Enabled=true then
if application.MessageBox('关闭前的操作未保存，要保存吗？保存则按确定，否则按取消','关闭',mb_okcancel+mb_iconquestion)=idok then
button5.Click;
button3.Enabled:=false;
button5.Enabled:=false;
button1.Enabled:=true;
button2.Enabled:=true;
button4.Enabled:=true;
close;
end;

procedure Tbmb.Button1Click(Sender: TObject);
begin
f:=0;
edit1.Text:='';
edit2.Text:='';
edit1.ReadOnly:=false;
edit2.ReadOnly:=false;
edit1.SetFocus;
button2.Enabled:=false;
button4.Enabled:=false;
button1.Enabled:=false;
button3.Enabled:=true;
button5.Enabled:=true;
DBNavigator1.Enabled:=false;
end;

procedure Tbmb.FormCreate(Sender: TObject);
begin
bmb.Active:=false;
bmb.DatabaseName:=s;
bmb.TableName:='bmb.db';
bmb.Active:=true;
edit1.ReadOnly:=true;
edit2.ReadOnly:=true;
bmb.First;
button3.Enabled:=false;
button5.Enabled:=false;
button1.Enabled:=true;
button2.Enabled:=true;
button4.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure Tbmb.Button2Click(Sender: TObject);
begin
DBNavigator1.Enabled:=true;
button1.Enabled:=false;
button2.Enabled:=false;
button3.Enabled:=true;
button5.Enabled:=true;
button4.Enabled:=false;
f:=1;
edit1.ReadOnly:=true;
edit2.ReadOnly:=false;
edit2.SetFocus;
end;

procedure Tbmb.Button3Click(Sender: TObject);
begin
DBNavigator1.Enabled:=true;
bmb.Prior;
edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
button1.Enabled:=true;
button2.Enabled:=true;
button5.Enabled:=false;
button3.Enabled:=false;
button4.Enabled:=true;
edit1.ReadOnly:=true;
edit2.ReadOnly:=true;
if bmb.RecordCount=0 then
begin
button4.Enabled:=false;
button2.Enabled:=false;
end
end;

procedure Tbmb.Button4Click(Sender: TObject);
begin
if application.MessageBox('嘿嘿！确实要删除吗？','删除',mb_okcancel+mb_iconquestion)=idok then
if bmb.RecordCount=0 then
begin
button4.Enabled:=false;
application.MessageBox('数据已清空！','信息',mb_ok+mb_iconinformation);
button2.Enabled:=false;
end
else
if bmb.Eof then
bmb.First
else
begin
bmb.Active:=true;
bmb.Delete;
 edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
end;
end;

procedure Tbmb.Button5Click(Sender: TObject);
begin
DBNavigator1.Enabled:=true;
bmb.First;
if f=0 then
begin
bmb.SetKey;
bmb.fieldbyname('部门号').asstring:=qu.cf(edit1.Text);
if (bmb.GotoKey) or (edit1.text='') then
begin
if application.MessageBox('此编号已存在或编号为空','信息',mb_ok+mb_iconinformation)=idok then
begin
bmb.Next;
edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
end;
end
else
begin
bmb.Active:=true;
bmb.Insert;
bmb.fieldbyname('部门号').asstring:=qu.cf(edit1.Text);
bmb.fieldbyname('部门名称').asstring:=qu.cf(edit2.Text);
bmb.Post;
bmb.Active:=true;
edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
end
end
else
begin
bmb.Active:=true;
bmb.SetKey;
bmb.fieldbyname('部门号').asstring:=qu.cf(edit1.Text);
if bmb.GotoKey then
begin
bmb.Edit;
bmb.fieldbyname('部门名称').asstring:=qu.cf(edit2.Text);
bmb.Post;
end;
end;
edit1.ReadOnly:=true;
edit2.ReadOnly:=true;
button1.Enabled:=true;
button2.Enabled:=true;
button4.Enabled:=true;
button3.Enabled:=false;
button5.Enabled:=false;
end;

procedure Tbmb.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tbmb.DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
begin
edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
end;

procedure Tbmb.BitBtn1Click(Sender: TObject);
begin
shellexecute(application.Handle,'open',pchar(s+'\help\bu_men.htm'),'','',SW_SHOW);
end;

procedure Tbmb.FormShow(Sender: TObject);
begin
bmb.Active:=false;
bmb.DatabaseName:=s;
bmb.TableName:='bmb.db';
bmb.Active:=true;
edit1.SetFocus;
if bmb.RecordCount=0 then
begin
button2.Enabled:=false;
button4.Enabled:=false;
end
else
begin
button2.Enabled:=true;
button4.Enabled:=true;
end;
edit1.ReadOnly:=true;
edit2.ReadOnly:=true;
bmb.First;
edit1.Text:=qu.cf(bmb.fieldbyname('部门号').asstring);
edit2.Text:=qu.cf(bmb.fieldbyname('部门名称').asstring);
button3.Enabled:=false;
button5.Enabled:=false;
button1.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure Tbmb.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
edit2.SetFocus;
end;



procedure Tbmb.FormPaint(Sender: TObject);
var a,b:real;
i:integer;
begin
a:=clientheight/256;
b:=0;
for i:=255 downto 0 do
begin
canvas.Brush.Color:=$000000000+i*$10000;
canvas.FillRect(rect(0,round(b),clientwidth,round(a+b)));
b:=b+a;
end;
end;

procedure Tbmb.FormActivate(Sender: TObject);
begin
bmb.Active:=false;
bmb.DatabaseName:=s;
bmb.TableName:='bmb.db';
bmb.Active:=true;
end;

end.