ygzbxxwh.pas

用delphi开发的 人事管理系统

unit ygzbxxwh;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, DBCtrls, ComCtrls, Mask, ExtCtrls, Db, DBTables;

type
  Tfrm_ygzbxxwh = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Panel2: TPanel;
    Shape1: TShape;
    Shape2: TShape;
    GroupBox1: TGroupBox;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    GroupBox2: TGroupBox;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Bevel1: TBevel;
    Bevel2: TBevel;
    Bevel3: TBevel;
    Bevel4: TBevel;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    DateTimePicker1: TDateTimePicker;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBComboBox3: TDBComboBox;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    DBLookupComboBox3: TDBLookupComboBox;
    DateTimePicker2: TDateTimePicker;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Bevel5: TBevel;
    Bevel6: TBevel;
    Bevel7: TBevel;
    Bevel8: TBevel;
    Bevel9: TBevel;
    Bevel10: TBevel;
    DBEdit7: TDBEdit;
    Bevel11: TBevel;
    Bevel12: TBevel;
    Bevel13: TBevel;
    Panel3: TPanel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    DataSource1: TDataSource;
    Query1: TQuery;
    Query2: TQuery;
    DataSource2: TDataSource;
    Query3: TQuery;
    DataSource3: TDataSource;
    Query4: TQuery;
    DataSource4: TDataSource;
    Edit1: TEdit;
    Button5: TButton;
    Button6: TButton;
    Bevel14: TBevel;
    procedure Button4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure DBEdit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure FormShow(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frm_ygzbxxwh: Tfrm_ygzbxxwh;

implementation

uses dl;

{$R *.DFM}

procedure Tfrm_ygzbxxwh.Button4Click(Sender: TObject);
begin
close;
end;

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

procedure Tfrm_ygzbxxwh.Button1Click(Sender: TObject);
begin
 if trim(edit1.text)<>'' then
  begin
    Query1.sql.clear;
    Query1.sql.add('select * from ygzlb where ygh=:ygh and yxbz=1');
    Query1.ParamByName ('ygh').ASSTRING :=edit1.text;
    IF Query1.ACTIVE THEN Query1.CLOSE;
     Query1.OPEN;
    IF Query1.IsEmpty  THEN
        begin
        SHOWMESSAGE('对不起！没有员工档案数据！请正确输入员工号！');
        edit1.selectall;
        exit;
        end;
  DateTimePicker1.Datetime:=strtodate(query1.fieldbyname('qsrq').asstring);
  DateTimePicker2.Datetime:=strtodate(query1.fieldbyname('rzsj').asstring);
  end;
end;

procedure Tfrm_ygzbxxwh.DBEdit1KeyPress(Sender: TObject; var Key: Char);
begin
if (trim(edit1.text)<>'') and (key=#13) then
button1Click(Sender);
end;

procedure Tfrm_ygzbxxwh.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if (edit1.text<>'') and (key=#13) then
button1click(sender);
end;

procedure Tfrm_ygzbxxwh.FormShow(Sender: TObject);
begin
edit1.setfocus;
end;

procedure Tfrm_ygzbxxwh.Button2Click(Sender: TObject);
var sql:string;
begin
  if Application.MessageBox('您确认要删除吗？','系统提示',mb_IconInformation+mb_OK+mb_OKCancel)=IDCancel then Exit;
  Sql := 'update ygzlb set yxbz=9 where ygh='''+trim(edit1.text)+'''';
  Query1.Close;
  Query1.Sql.Clear;
  Query1.Sql.Add(Sql);
  Query1.ExecSQL;
  Application.MessageBox('该记录删除成功!','系统提示',mb_IconInformation+mb_OK);
  end;

procedure Tfrm_ygzbxxwh.Button5Click(Sender: TObject);
begin
  Edit1.ReadOnly := true;
  DBEdit2.ReadOnly := False;
  DBEdit3.ReadOnly := False;
  DBEdit4.ReadOnly := False;
  DBEdit5.ReadOnly := False;
  DBEdit6.ReadOnly := False;
  DBEdit7.ReadOnly := False;
  DBEdit7.enabled:=true;
  DBComboBox1.enabled:=true;
  DBComboBox2.enabled:=true;
  DBComboBox3.enabled:=true;
  DBLookupComboBox1.enabled:=true;
  DBLookupComboBox2.enabled:=true;
  DBLookupComboBox3.enabled:=true;
  DateTimePicker1.enabled:=true;
  DateTimePicker2.enabled:=true;
  button3.enabled:=true;


end;

procedure Tfrm_ygzbxxwh.Button3Click(Sender: TObject);
var czdate,qsrq,rzsj:string;
 begin
if ((Query1.state=dsEdit )or( Query1.state=dsInsert)) then else exit;
  qsrq:=FormatDatetime('YYYY-MM-DD',datetimepicker1.Datetime);
  rzsj:=FormatDatetime('YYYY-MM-DD',datetimepicker2.Datetime);
  czdate := FormatDatetime('YYYY-MM-DD HH:MM:SS',Now);
  if messagedlg('是否保存员工数据？',mtinformation,[mbyes,mbno],1)=mryes then else exit;
  Query1.fieldbyname('qsrq').asstring:=qsrq;
  Query1.fieldbyname('rzsj').asstring:=rzsj;
  Query1.fieldbyname('czrq').asstring:=czdate;
  Query1.fieldbyname('czy').asstring:=dluser;
  Query1.post;
  query1.close;
  query1.open;
  messagedlg('数据提交成功!',mtinformation,[mbok],1);
  edit1.setfocus;
  edit1.ReadOnly:=false;

end;

procedure Tfrm_ygzbxxwh.Button6Click(Sender: TObject);
begin
 application.MessageBox ('1.输入有效员工号,并回车或点查询,系统显示此员工的信息;'+#10#13+
                          '2.若要修改,点击修改按钮,修改完后按提交保存修改;'+#10+#13+
                          '3.若要删除此员工,点击删除按钮,系统将把此员工号的有效标志改为无效'+#10#13,
                          '员工信息维护帮助',1);

end;

end.