zcxg.pas

用delphi开发的 人事管理系统

unit zcxg;

interface

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

type
  TFrm_zcxg = class(TForm)
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Query1: TQuery;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Label2: TLabel;
    Bevel1: TBevel;
    Label1: TLabel;
    panel2: TPanel;
    panel1: TPanel;
    Bevel2: TBevel;
    Query2: TQuery;
    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);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_zcxg: TFrm_zcxg;

implementation
uses dl;

{$R *.DFM}

procedure TFrm_zcxg.Button4Click(Sender: TObject);
begin
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);
var sql:string;
begin
if Application.MessageBox('删除参数将导致数据的不一致，确认要删除吗？','系统提示',mb_IconInformation+mb_OK+mb_OKCancel)=IDCancel then Exit;
  Sql := 'Delete From jbcsb Where Id='+Query1.FieldByName('Id').AsString
        +' And lx=4';
  Query2.Close;
  Query2.Sql.Clear;
  Query2.Sql.Add(sql);
  Query2.ExecSQL;
  Query1.Close;
  Query1.Open;
end;

procedure TFrm_zcxg.Button3Click(Sender: TObject);
var localdate,sql,maxid:string;
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; 
  sql:='select max(id)+1 maxid from jbcsb where 1=1';
  Query2.Close;
  Query2.Sql.Clear;
  Query2.sql.Add(sql);
  Query2.open;
  maxid:=trim(query2.fieldbyname('maxid').asstring);
  if maxid='' then maxid:='0';
  LocalDate := FormatDateTime('yyyy-mm-dd',Date);
  LocalDate := LocalDate +' '+ FormatDateTime('hh:mm:ss',Time);
  sql:='insert into jbcsb(id,mc,lx,czy,czsj)'
  +'values('+maxid+','                           
  +''''+Trim(Edit1.Text)+''''+',4,'''+dluser+''','+''''+LocalDate+''''+')';
  Query2.close;
  Query2.sql.clear;
  Query2.SQL.add(sql);
  Query2.ExecSQL;
  Query1.Close;
  Query1.Open;
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;

end.