llygzzxx.pas

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

unit llygzzxx;

interface

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

type
  TFrm_llygzbxx = class(TForm)
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Shape1: TShape;
    Shape2: TShape;
    GroupBox1: TGroupBox;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Bevel2: TBevel;
    Bevel3: TBevel;
    Bevel4: TBevel;
    Bevel5: TBevel;
    Bevel6: TBevel;
    Bevel7: TBevel;
    Bevel9: TBevel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit1: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DataSource1: TDataSource;
    GroupBox2: TGroupBox;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Bevel10: TBevel;
    Bevel11: TBevel;
    Bevel12: TBevel;
    Bevel13: TBevel;
    Bevel14: TBevel;
    Bevel15: TBevel;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    Label20: TLabel;
    Bevel16: TBevel;
    Shape3: TShape;
    Shape4: TShape;
    DBGrid1: TDBGrid;
    DataSource2: TDataSource;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    Panel3: TPanel;
    Button11: TButton;
    Button12: TButton;
    Button13: TButton;
    Button14: TButton;
    Button15: TButton;
    Panel2: TPanel;
    Panel4: TPanel;
    Bevel1: TBevel;
    Label2: TLabel;
    Bevel17: TBevel;
    Bevel8: TBevel;
    DBImage1: TDBImage;
    Bevel18: TBevel;
    Label3: TLabel;
    Label19: TLabel;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    OpenPictureDialog1: TOpenPictureDialog;
    procedure TabSheet1Show(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_llygzbxx: TFrm_llygzbxx;

implementation
uses dm;
{$R *.DFM}

procedure TFrm_llygzbxx.TabSheet1Show(Sender: TObject);
begin
if  ADOQuery1.active  then
ADOQuery1.close;
ADOQuery1.open;
ADOQuery1.first;
end;

procedure TFrm_llygzbxx.TabSheet2Show(Sender: TObject);
begin
if ADOQuery2.Active then ADOQuery2.close;
ADOQuery2.open;
ADOQuery2.first;
end;

procedure TFrm_llygzbxx.Button1Click(Sender: TObject);
begin
ADOQuery1.first;
end;

procedure TFrm_llygzbxx.Button4Click(Sender: TObject);
begin
ADOQuery1.Last;
end;

procedure TFrm_llygzbxx.Button5Click(Sender: TObject);
begin
close;
end;

procedure TFrm_llygzbxx.Button10Click(Sender: TObject);
begin
close;
end;

procedure TFrm_llygzbxx.Button7Click(Sender: TObject);
begin
ADOQuery2.Prior;
if ADOQuery2.Bof then showmessage('已到达最后一条记录');
end;

procedure TFrm_llygzbxx.Button6Click(Sender: TObject);
begin
ADOQuery2.first;
end;

procedure TFrm_llygzbxx.Button9Click(Sender: TObject);
begin
ADOQuery2.last;
end;

procedure TFrm_llygzbxx.Button8Click(Sender: TObject);
begin
ADOQuery2.Next;
if ADOQuery2.Eof then showmessage('已到达最后一条记录');
end;

procedure TFrm_llygzbxx.Button2Click(Sender: TObject);
begin
ADOQuery1.Prior;
if ADOQuery1.bof then showmessage('已到达第一条记录');
end;

procedure TFrm_llygzbxx.Button3Click(Sender: TObject);
begin
ADOQuery1.next;
if ADOQuery1.Eof then showmessage('已到达最后一条记录');
end;

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

procedure TFrm_llygzbxx.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;

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

procedure TFrm_llygzbxx.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_llygzbxx.FormCreate(Sender: TObject);
begin
   ADOQuery1.Open;
   ADOQuery2.Open;
end;

end.