ygzbxxwh.pas

一个用vb mysql实现的人事管理信息系统希望对大家有用。

unit ygzbxxwh;

interface

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

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;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    DataSource4: TDataSource;
    Edit1: TEdit;
    Button5: TButton;
    Button6: TButton;
    Bevel14: TBevel;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    ADOQuery3: TADOQuery;
    ADOQuery4: TADOQuery;
    Bevel15: TBevel;
    Bevel16: TBevel;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    DBImage1: TDBImage;
    OpenPictureDialog1: TOpenPictureDialog;
    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);
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frm_ygzbxxwh: Tfrm_ygzbxxwh;

implementation

uses dl,dm;

{$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
    ADOQuery1.sql.clear;
    ADOQuery1.sql.add('select * from ygzlb where ygh=:ygh and yxbz=1');
    ADOQuery1.Parameters.ParamByName('ygh').Value:=edit1.text;
    IF ADOQuery1.ACTIVE THEN ADOQuery1.CLOSE;
     ADOQuery1.OPEN;
    IF ADOQuery1.IsEmpty  THEN
        begin
        SHOWMESSAGE('对不起！没有员工档案数据！请正确输入员工号！');
        edit1.selectall;
        exit;
        end;
  DateTimePicker1.Datetime:=strtodate(ADOQuery1.fieldbyname('qsrq').asstring);
  DateTimePicker2.Datetime:=strtodate(ADOQuery1.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)+'''';
  ADOQuery1.Close;
  ADOQuery1.Sql.Clear;
  ADOQuery1.Sql.Add(Sql);
  ADOQuery1.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 ((ADOQuery1.state=dsEdit )or( ADOQuery1.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;
  ADOQuery1.fieldbyname('qsrq').asstring:=qsrq;
  ADOQuery1.fieldbyname('rzsj').asstring:=rzsj;
  ADOQuery1.fieldbyname('czrq').asstring:=czdate;
  ADOQuery1.fieldbyname('czy').asstring:=dluser;
  ADOQuery1.post;
  ADOQuery1.close;
  ADOQuery1.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;

procedure Tfrm_ygzbxxwh.N1Click(Sender: TObject);
begin
if OpenPictureDialog1.Execute then
   DBImage1.Picture.LoadFromFile(OpenPictureDialog1.FileName);
end;

procedure Tfrm_ygzbxxwh.N2Click(Sender: TObject);
var
  ext:string;
begin
  if Dbimage1.Picture.Graphic <>nil then
  begin
    try
      dmain.ADOConnection1.BeginTrans  ;
      Adoquery1.Edit ;
      Adoquery1.FieldByName('photo').Assign(Dbimage1.Picture.Graphic);
       //以下记录保存到数据库的图像格式
       ext:=extractfileext(openpicturedialog1.FileName);
       if uppercase(ext) = '.BMP' THEN
          Adoquery1.FieldByName('bmp').Value :=1
          ELSE IF (UPPERCASE(EXT) = '.JPEG') OR (UPPERCASE(EXT) = '.JPG') THEN
            Adoquery1.FieldByName('bmp').Value :=2;
       Adoquery1.Post ;
       dmain.ADOConnection1.CommitTrans;
    except
       dmain.ADOConnection1.RollbackTrans ;
       showmessage('图片保存失败！');
    end;//try
  end;
end;

procedure Tfrm_ygzbxxwh.ADOQuery1AfterScroll(DataSet: TDataSet);
var
  jpegimage:tjpegimage;
begin
  dbimage1.Picture.Graphic:=nil;
  //BMP、JPEG两种图像数据必需分别处理
  if AdoQuery1.FieldByName('bmp').AsString ='1' then begin
    DbImage1.Picture.Bitmap.Assign(AdoQuery1.FieldByName('photo'));
  end
  else if AdoQuery1.FieldByName('bmp').AsString ='2' then
          begin
             jpegimage := tjpegimage.Create ;  //通过jpegimage将图像显示在image1,否则会出错
             try
               jpegimage.Assign(AdoQuery1.FieldByName('photo'));
               DbImage1.Picture.Graphic:=jpegimage;
             finally
               jpegimage.Free ;
             end;//try
          end;
end;

end.