unit13.pas

教学管理系统源码

unit Unit13;

interface

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

type
  TForm13 = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    BitBtn1: TBitBtn;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Label13: TLabel;
    Label14: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    ComboBox4: TComboBox;
    OpenPictureDialog1: TOpenPictureDialog;
    Panel1: TPanel;
    Image1: TImage;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure DBEdit1Change(Sender: TObject);
    procedure DBEdit2Change(Sender: TObject);
    //procedure DBComboBox1Change(Sender: TObject);
    procedure DBEdit3Change(Sender: TObject);
    //procedure DBComboBox2Change(Sender: TObject);
    procedure DBEdit4Change(Sender: TObject);
    procedure DBEdit6Change(Sender: TObject);
    procedure DBEdit7Change(Sender: TObject);
    procedure DBEdit8Change(Sender: TObject);
    procedure DBEdit10Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure DBImage1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure Image1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form13: TForm13;
  path:string;
implementation

uses Unit6, Unit5, Unit1, Unit22;

{$R *.dfm}

procedure TForm13.FormClose(Sender: TObject; var Action: TCloseAction);
begin
//Action:=caFree;
    //Form6:=nil;
end;

procedure TForm13.BitBtn1Click(Sender: TObject);
begin
if Edit1.Text=''
   then begin
     Application.MessageBox('请输入姓名！','警告！',MB_OK);
     exit;
   end;
if Edit2.Text=''
   then begin
     Application.MessageBox('请输入编号！','警告！',MB_OK);
     exit;
   end;
if Edit3.Text=''
   then begin
     Application.MessageBox('请输入出生年月！','警告！',MB_OK);
     exit;
   end;
if Edit4.Text=''
   then begin
     Application.MessageBox('请输入毕业学校！','警告！',MB_OK);
     exit;
   end;
if Edit5.Text=''
   then begin
     Application.MessageBox('请输入职称！','警告！',MB_OK);
     exit;
   end;
if Edit6.Text=''
   then begin
     Application.MessageBox('请输入部门！','警告！',MB_OK);
     exit;
   end;
if Edit7.Text=''
   then begin
     Application.MessageBox('请输入工资！','警告！',MB_OK);
     exit;
   end;
if Edit8.Text=''
   then begin
     Application.MessageBox('请输入毕业时间！','警告！',MB_OK);
     exit;
   end;
if ComboBox1.Text=''
   then begin
     Application.MessageBox('请输入性别！','警告！',MB_OK);
     exit;
   end;
if ComboBox2.Text=''
   then begin
     Application.MessageBox('请输入学历！','警告！',MB_OK);
     exit;
   end;
if ComboBox3.Text=''
   then begin
     Application.MessageBox('请输入专业！','警告！',MB_OK);
     exit;
   end;
if ComboBox4.Text=''
   then begin
     Application.MessageBox('请输入籍贯！','警告！',MB_OK);
     exit;
   end;
   //else begin

ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from 教师基本档案');
ADOQuery1.SQL.Add('WHERE 教师编号='''+Edit2.Text+'''');
ADOQuery1.Open;
if (ADOQuery1.RecordCount=1)
    then begin
    Application.MessageBox('对象已经存在！','警告！',MB_OK);
    Edit1.Text:='';
    Edit2.Text:='';
    Edit3.Text:='';
    Edit4.Text:='';
    Edit5.Text:='';
    Edit6.Text:='';
    Edit7.Text:='';
    Edit8.Text:='';
    ComboBox1.Text:='';
    ComboBox2.Text:='';
    ComboBox3.Text:='';
    ComboBox4.Text:='';
    exit;
    end
    else begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from 教师基本档案');
ADOQuery1.Open;
ADOQuery1.Insert;
ADOQuery1.FieldValues['教师姓名']:=Edit1.Text;
ADOQuery1.FieldValues['教师编号']:=Edit2.Text;
ADOQuery1.FieldValues['性别']:=ComboBox1.Text;
ADOQuery1.FieldValues['学历']:=ComboBox2.Text;
ADOQuery1.FieldValues['专业']:=ComboBox3.Text;
ADOQuery1.FieldValues['籍贯']:=ComboBox4.Text;
ADOQuery1.FieldValues['出生']:=Edit3.Text;
ADOQuery1.FieldValues['毕业学校']:=Edit4.Text;
ADOQuery1.FieldValues['职称']:=Edit5.Text;
ADOQuery1.FieldValues['部门']:=Edit6.Text;
ADOQuery1.FieldValues['工资']:=Edit7.Text;
ADOQuery1.FieldValues['毕业时间']:=Edit8.Text;
ADOQuery1.FieldValues['照片']:=path;
ADOQuery1.Post;

Application.MessageBox('提交成功！','恭喜！',MB_OK);
Form22.ComboBox2.Items.Add(Edit2.Text);
Form22.ComboBox1.Items.Add(Edit1.Text);
end;
Edit1.Text:='';
Edit2.Text:='';
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
Edit6.Text:='';
Edit7.Text:='';
Edit8.Text:='';
ComboBox1.Text:='';
ComboBox2.Text:='';
ComboBox3.Text:='';
ComboBox4.Text:='';
end;

procedure TForm13.DBEdit1Change(Sender: TObject);
begin
Edit1.Clear;
end;

procedure TForm13.DBEdit2Change(Sender: TObject);
begin
Edit2.Clear;
end;

procedure TForm13.DBEdit3Change(Sender: TObject);
begin
Edit3.Clear;
end;

procedure TForm13.DBEdit4Change(Sender: TObject);
begin
Edit4.Clear;
end;

procedure TForm13.DBEdit6Change(Sender: TObject);
begin
Edit5.Clear;
end;

procedure TForm13.DBEdit7Change(Sender: TObject);
begin
Edit6.Clear;
end;

procedure TForm13.DBEdit8Change(Sender: TObject);
begin
Edit7.Clear;
end;

procedure TForm13.DBEdit10Change(Sender: TObject);
begin
Edit8.Clear;
end;

procedure TForm13.FormCreate(Sender: TObject);
begin
    {Edit1.Text:='';
    Edit2.Text:='';
    Edit3.Text:='';
    Edit4.Text:='';
    Edit5.Text:='';
    Edit6.Text:='';
    Edit7.Text:='';
    Edit8.Text:='';
    ComboBox1.Text:='';
    ComboBox2.Text:='';
    ComboBox3.Text:='';
    ComboBox4.Text:=''; }
end;

procedure TForm13.DBImage1Click(Sender: TObject);
begin
if OpenPictureDialog1.Execute then
    begin
       //Bitbtn2.Glyph.LoadFromFile(OpenPictureDialog1.FileName);
    end;
end;

procedure TForm13.BitBtn2Click(Sender: TObject);
begin
if openpicturedialog1.Execute then
   //Bitbtn2.Glyph.LoadFromFile(OpenPictureDialog1.FileName);
end;

procedure TForm13.Image1Click(Sender: TObject);
begin
if openpicturedialog1.Execute then
   Image1.Picture.LoadFromFile(OpenPictureDialog1.FileName);
   path:=openpicturedialog1.FileName;
   end;

end.