studentadd.pas

该源码采用DELPHI语言,主要实现了对员工信息管理的功能.

unit StudentAdd;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DBCtrls, Buttons, ComCtrls, DB, ADODB, ExtDlgs,
  ExtCtrls;

type
  TForm6 = class(TForm)
    PageControl2: TPageControl;
    TabSheet4: TTabSheet;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label12: TLabel;
    SpeedButton1: TSpeedButton;
    Edit1: TEdit;
    Edit2: TEdit;
    ComboBox1: TComboBox;
    Edit3: TEdit;
    ComboBox2: TComboBox;
    Edit4: TEdit;
    Memo1: TMemo;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Button1: TButton;
    ADOConnection2: TADOConnection;
    ADOQuery2: TADOQuery;
    DataSource1: TDataSource;
    Timer1: TTimer;
    DateTimePicker3: TDateTimePicker;
    Edit5: TEdit;
    Label1: TLabel;
    Label9: TLabel;
    Edit6: TEdit;
    Label10: TLabel;
    Edit7: TEdit;
    DateTimePicker1: TDateTimePicker;
    procedure BitBtn5Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    //procedure BitBtn3Click(Sender: TObject);
    //procedure SpeedButton7Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    //procedure DBImage1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;

implementation

{$R *.dfm}

procedure TForm6.BitBtn5Click(Sender: TObject);
begin
//if Openpicturedialog1.Execute then
begin
  //DBImage1.Picture.LoadFromFile(openpicturedialog1.FileName);
end;
end;

procedure TForm6.SpeedButton1Click(Sender: TObject);
var
date1 : string;
date2 : string;
//picture : tpicture;
begin
date1 := Datetostr(Datetimepicker1.Date);    //将时间类型转化为字符型
date2 := Datetostr(Datetimepicker3.Date);
with ADOquery1 do
begin
   if Edit1.Text = '' then showmessage('员工号不能为空!')
   else
   begin
   SQL.Clear;
   SQL.Add('select * from 员工 where 员工号 = '''+Edit1.Text+'''');
   Open;
   if not isempty then
   begin
      showmessage(' 该员工已存在,请核对后重新输入!');
      Edit1.Text := '';
   end
   else
   begin
      //picture:=tpicture.Create;
      //picture.LoadFromFile(extractfilename(openpicturedialog1.FileName));
      SQL.Clear;
      SQL.Add('select * from 员工');
      Open;
      Insert;
      FieldByName('员工号').AsString:=Edit1.Text;
      FieldByName('姓名').AsString:=Edit2.Text;
      FieldByName('性别').AsString:=ComboBox1.Text;
      FieldByName('民族').AsString:=Edit3.Text;
      FieldByName('政治面貌').AsString:=ComboBox2.Text;
      FieldByName('出生日期').AsString:=date1;
      FieldByName('籍贯').AsString:=Edit4.Text;
      FieldByName('部门').AsString:=Edit5.Text;
      FieldByName('电话').AsString:=Edit6.Text;
      FieldByName('备注').AsString:=Memo1.Text;
      FieldByName('密码').AsString:=Edit7.Text;
      //FieldByName('照片').Assign(picture);
      Post;
      showmessage('成功添加员工信息！');
      end;
   end;

end;

end;


procedure TForm6.Button1Click(Sender: TObject);
begin
Close;
end;

procedure TForm6.FormCreate(Sender: TObject);
begin
Memo1.Text := '';
end;



end.