u_inputemp.pas

小型劳资管理系统,用visual basic+access编写

unit U_inputemp;

interface

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

type
  TF_inputemp = class(TForm)
    Q_empdata: TQuery;
    Q_employees: TQuery;
    Q_employeesemp_id: TIntegerField;
    Q_employeescardnum: TStringField;
    Q_employeesIC_id: TStringField;
    Q_employeesbirthday: TStringField;
    Q_employeessex: TStringField;
    Q_employeesMarry: TStringField;
    Q_employeesIn_date: TStringField;
    Q_employeesNow_add: TStringField;
    Q_employeesTelePhone: TStringField;
    Q_employeeshome_ori: TStringField;
    Q_employeeshome_add: TStringField;
    Q_employeeshome_mem: TStringField;
    Q_employeeshome_relation: TStringField;
    Q_employeesgrd_sch: TStringField;
    Q_employeesgrd_zy: TStringField;
    Q_employeesgrd_date: TDateTimeField;
    Q_employeesdegree: TStringField;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    DataSource1: TDataSource;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    Label10: TLabel;
    DBEdit10: TDBEdit;
    Label11: TLabel;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    DBEdit12: TDBEdit;
    Label13: TLabel;
    DBEdit13: TDBEdit;
    Label14: TLabel;
    DBEdit14: TDBEdit;
    Label16: TLabel;
    DBEdit16: TDBEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Label15: TLabel;
    DBEdit15: TDBEdit;
    DateTimePicker1: TDateTimePicker;
    ComboBox3: TComboBox;
    DBEdit4: TDBEdit;
    ComboBox4: TComboBox;
    DBEdit5: TDBEdit;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker3: TDateTimePicker;
    bitbtn1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    ComboBox5: TComboBox;
    DBEdit9: TDBEdit;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure DBEdit2Exit(Sender: TObject);
    procedure ComboBox1Click(Sender: TObject);
    procedure ComboBox2Click(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure DBEdit7KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton2Click(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure DateTimePicker3Change(Sender: TObject);
    procedure DateTimePicker1Change(Sender: TObject);
    procedure ComboBox5Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_inputemp: TF_inputemp;

implementation   


{$R *.DFM}

procedure TF_inputemp.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=caFree;
  F_inputemp:=nil;
end;

procedure TF_inputemp.BitBtn1Click(Sender: TObject);
begin
  Q_employees.Post;
  close;
end;

procedure TF_inputemp.DBEdit2Exit(Sender: TObject);
var
  i:integer;
  s:string;
begin
  if (DBEdit2.Text='')or(Length(trim(DBEdit2.text))=15)or(Length(trim(DBEdit2.text))=18) then
    begin
      if DBEdit2.Text='' then exit;
      if Length(trim(DBEdit2.text))=15 then
        begin
          begin
            s:='19'+copy(DBEdit2.text,7,2)+'/'+copy(DBEdit2.text,9,2)+'/'+copy(DBEdit2.text,11,2);
            Q_employees.FieldByName('birthday').asstring:=s;
          end;
          s:=copy(DBEdit2.text,15,1);
          i:=strtoint(s);
          if(i mod 2)=0 then
           Q_employees.FieldByName('sex').asstring:='女'
          else
          Q_employees.FieldByName('sex').asstring:='男';
        end
      else
      if Length(trim(DBEdit2.text))=18 then
          begin
            s:=copy(DBEdit2.text,7,4)+'/'+copy(DBEdit2.text,11,2)+'/'+copy(DBEdit2.text,13,2);
            Q_employees.FieldByName('birthday').asstring:=s;
          end;
    end
  else
    begin
      Application.MessageBox('请输入一个15位或18位的身份证号!','系统提示',MB_OK+MB_ICONWARNING);
      exit;
    end;
end;

procedure TF_inputemp.ComboBox1Click(Sender: TObject);
begin
  DBEdit16.Text:=Combobox1.Text;
end;

procedure TF_inputemp.ComboBox2Click(Sender: TObject);
begin
  DBedit12.Text:=combobox2.Text;
end;

procedure TF_inputemp.FormKeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    selectnext(activecontrol,true,true);
end;

procedure TF_inputemp.DBEdit7KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
  if DBEdit7.Text<>'' then
     Q_employees.FieldByName('home_add').asstring:=DBEdit7.Text;

end;

procedure TF_inputemp.SpeedButton2Click(Sender: TObject);
begin
close;
end;

procedure TF_inputemp.DateTimePicker2Change(Sender: TObject);
begin
DBedit15.Text:=datetostr(datetimepicker2.Date);
end;

procedure TF_inputemp.DateTimePicker3Change(Sender: TObject);
begin
DBedit6.text:=datetostr(datetimepicker3.Date);
end;

procedure TF_inputemp.DateTimePicker1Change(Sender: TObject);
begin
DBedit3.Text:=datetostr(datetimepicker1.Date);
end;

procedure TF_inputemp.ComboBox5Change(Sender: TObject);
begin
DBedit9.Text:=combobox5.Text;
end;

end.