zcxg.pas

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

unit zcxg;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Db, DBTables, Grids, DBGrids, ExtCtrls, ADODB;

type
  TFrm_zcxg = class(TForm)
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Label2: TLabel;
    Bevel1: TBevel;
    Label1: TLabel;
    panel2: TPanel;
    panel1: TPanel;
    Bevel2: TBevel;
    ADOQuery1: TADOQuery;
    ADOQuery1Id: TAutoIncField;
    ADOQuery1Lx: TSmallintField;
    ADOQuery1Mc: TWideStringField;
    ADOQuery1Czy: TWideStringField;
    ADOQuery1Czsj: TWideStringField;
    ADOQuery1Rela: TSmallintField;
    procedure Button4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit1Exit(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_zcxg: TFrm_zcxg;

implementation
uses dl,dm;

{$R *.DFM}

procedure TFrm_zcxg.Button4Click(Sender: TObject);
begin
   ADOQuery1.Close;
   close;
end;

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

procedure TFrm_zcxg.Button1Click(Sender: TObject);
begin
 Edit1.Enabled := True;
  Edit1.Text := '';
  Edit1.SetFocus;
  Button1.Enabled := False;
  Button3.Enabled := True;
end;

procedure TFrm_zcxg.Button2Click(Sender: TObject);
begin
if Application.MessageBox('删除参数将导致数据的不一致，确认要删除吗？','系统提示',mb_IconInformation+mb_OK+mb_OKCancel)=IDCancel then Exit;
  ADOQuery1.Delete;
end;

procedure TFrm_zcxg.Button3Click(Sender: TObject);
begin
  if Application.MessageBox('您确认要提交吗？','系统提示',mb_IconInformation+mb_OK+mb_OKCancel)=IDCancel then Exit;
 if Trim(Edit1.Text) = '' then
  begin
    Application.MessageBox('您不能插入一条空的记录','系统提示',mb_IconInformation+mb_OK);
    Exit;
  end; 
  ADOQuery1.Insert;
  ADOQuery1.FieldByName('czsj').AsString:=FormatDateTime('yyyy-mm-dd',Date)+' '+ FormatDateTime('hh:mm:ss',Time);
  ADOQuery1.FieldByName('mc').AsString:=Trim(Edit1.Text);
  ADOQuery1.FieldByName('lx').AsString:='4';
  ADOQuery1.FieldByName('czy').AsString:=dluser;
  ADOQuery1.Post;
if Application.MessageBox('您继续要新增吗？','系统提示',mb_IconInformation+mb_OK+mb_OKCancel)=IDCancel then
  begin
    Button1.Enabled := True;
    Button3.Enabled := False;
    Edit1.Enabled := False;
    Exit;
  end;
  Edit1.Text := '';
  Edit1.SetFocus;

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

procedure TFrm_zcxg.Edit1Exit(Sender: TObject);
begin
if Trim(Edit1.Text) = '' then
    Edit1.Text := '';
end;

procedure TFrm_zcxg.FormCreate(Sender: TObject);
begin
    ADOQuery1.Open;
end;

end.