bmcoustomer.pas

毕业设计时候开发的人事管理系统

unit bmcoustomer;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls,db, Buttons;

type
  Tfrmcustomerbm = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    btnok: TBitBtn;
    btnquit: TBitBtn;
    btnmodify: TBitBtn;
    btnsave: TBitBtn;
    procedure FormCreate(Sender: TObject);
    procedure btnquitClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure btnokClick(Sender: TObject);
    procedure btnmodifyClick(Sender: TObject);
    procedure btnsaveClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmcustomerbm: Tfrmcustomerbm;

implementation

uses datarsgl;

{$R *.dfm}

procedure Tfrmcustomerbm.FormCreate(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
edit3.Clear;
edit4.Clear;
edit5.Clear;
edit6.Clear;
edit7.Clear;
edit8.Clear;
edit9.Clear;
edit10.Clear;
end;

procedure Tfrmcustomerbm.btnquitClick(Sender: TObject);
begin
close;
end;
//判断是否为空值
function isempty1(sender:tobject):boolean;
begin
if (sender is tedit) then
    if trim((sender as tedit).Text)=''then
        begin
        result:=false;
       (sender as tedit).SetFocus ;
        exit;
        end;
       result:=true;
end;
procedure Tfrmcustomerbm.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tfrmcustomerbm.FormShow(Sender: TObject);
begin
edit1.SetFocus;
end;

procedure Tfrmcustomerbm.btnokClick(Sender: TObject);
begin
if not isempty1(edit1) then
begin
messagedlg('请输入完整的部门记录',mtwarning,[mbok],0);
end;
with dmrsgl.ygbmqry do
begin
close;
sql.Clear;
sql.Add('select * from ygbmtb');
open;
if recordcount<>0 then
begin
showmessage('公司部门表已经存在定义项目'+#13+'您只能修改资料');
btnok.Enabled:=false;
exit;
end
else
begin
append;
fieldbyname('ygbm1').AsString:=trim(edit1.Text);
fieldbyname('ygbm2').AsString:=trim(edit2.Text);
fieldbyname('ygbm3').AsString:=trim(edit3.Text);
fieldbyname('ygbm4').AsString:=trim(edit4.Text);
fieldbyname('ygbm5').AsString:=trim(edit5.Text);
fieldbyname('ygbm6').AsString:=trim(edit6.Text);
fieldbyname('ygbm7').AsString:=trim(edit7.Text);
fieldbyname('ygbm8').AsString:=trim(edit8.Text);
fieldbyname('ygbm9').AsString:=trim(edit9.Text);
fieldbyname('ygbm10').AsString:=trim(edit10.Text);
try
if messagedlg('请确认定义部门项目内容无误,然后写入数据库系统.',mtconfirmation,[mbyes,mbno],0)=mryes then
begin
post;
frmcustomerbm.Close;
end
else
begin
showmessage('操作已经取消');
cancel;
exit;
end;
except
on edatabaseerror do
end;
end;
end;
end;
procedure Tfrmcustomerbm.btnmodifyClick(Sender: TObject);
begin
with dmrsgl.ygbmqry do
begin
close;
sql.Clear;
sql.Add('select * from ygbmtb');
open;
if recordcount=0 then
begin
showmessage('部门定义数据库资料为空.');
btnok.Enabled:=true;
end
else
edit1.Text:=fieldbyname('ygbm1').AsString;
edit2.Text:=fieldbyname('ygbm2').AsString;
edit3.Text:=fieldbyname('ygbm3').AsString;
edit4.Text:=fieldbyname('ygbm4').AsString;
edit5.Text:=fieldbyname('ygbm5').AsString;
edit6.Text:=fieldbyname('ygbm6').AsString;
edit7.Text:=fieldbyname('ygbm7').AsString;
edit8.Text:=fieldbyname('ygbm8').AsString;
edit9.Text:=fieldbyname('ygbm9').AsString;
edit10.Text:=fieldbyname('ygbm10').AsString;
end;
end;
procedure Tfrmcustomerbm.btnsaveClick(Sender: TObject);
begin
if not isempty1(edit1) then
begin
messagedlg('请输入完整的部门记录',mtwarning,[mbok],0);
end;
with dmrsgl.ygbmqry do
begin
close;
sql.Clear;
sql.Add('select * from ygbmtb');
open;
begin
edit;
fieldbyname('ygbm1').AsString:=trim(edit1.Text);
fieldbyname('ygbm2').AsString:=trim(edit2.Text);
fieldbyname('ygbm3').AsString:=trim(edit3.Text);
fieldbyname('ygbm4').AsString:=trim(edit4.Text);
fieldbyname('ygbm5').AsString:=trim(edit5.Text);
fieldbyname('ygbm6').AsString:=trim(edit6.Text);
fieldbyname('ygbm7').AsString:=trim(edit7.Text);
fieldbyname('ygbm8').AsString:=trim(edit8.Text);
fieldbyname('ygbm9').AsString:=trim(edit9.Text);
fieldbyname('ygbm10').AsString:=trim(edit10.Text);
try
if messagedlg('请确认修改定义部门项目内容无误,然后写入数据库系统.',mtconfirmation,[mbyes,mbno],0)=mryes then
begin
post;
frmcustomerbm.Close;
end
else
begin
showmessage('操作已经取消');
cancel;
exit;
end;
except
on edatabaseerror do
end;
end;
end;
end;

end.