unit Unit14;

interface

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

type
  Tjsxxxg = class(TForm)
    StatusBar1: TStatusBar;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    Label3: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    GroupBox3: TGroupBox;
    Edit3: TEdit;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit15: TEdit;
    Edit16: TEdit;
    DBGrid1: TDBGrid;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    Image1: TImage;
    ComboBox1: TComboBox;
    Label17: TLabel;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit13KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jsxxxg: Tjsxxxg;

implementation
uses unit1; 
{$R *.dfm}

procedure Tjsxxxg.SpeedButton4Click(Sender: TObject);
begin
self.Close;
end;

procedure Tjsxxxg.SpeedButton3Click(Sender: TObject);
begin
 DBgrid1.Refresh;
end;

procedure Tjsxxxg.SpeedButton2Click(Sender: TObject);
var
i:integer;
begin
i:=application.MessageBox('你確定要刪除嗎？','刪除提示',mb_YesNO);
 if i=7 then
 exit;
 ADOquery1.Delete;
end;

procedure Tjsxxxg.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if not (key in['0'..'9',#8])then
   begin
   key:=#0;
   Application.MessageBox('教師號只能填寫數字','警告',0+64)
   end;
end;

procedure Tjsxxxg.Edit13KeyPress(Sender: TObject; var Key: Char);
begin
 if not (key in['0'..'9',#8])then
   begin
   key:=#0;
   Application.MessageBox('郵政編碼只能填寫數字','警告',0+64)
   end;
end;

procedure Tjsxxxg.SpeedButton1Click(Sender: TObject);
begin
if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit4.Text='')or(edit5.Text='')
or(edit6.Text='')or(edit7.Text='')or(edit8.Text='')or(edit9.Text='')or(edit10.Text='')
or(edit11.Text='')or(edit12.Text='')or(edit13.Text='')or(edit14.Text='')or(edit15.Text='')or(edit16.Text='')
then
 begin
   application.MessageBox('請輸入要修改的內容','提示',0+64);
   exit;
 end
else
   ADOquery1.Edit;
   ADOquery1.FieldValues['教師號']:=edit1.Text;
   ADOquery1.FieldValues['姓名']:=edit2.Text;
   ADOquery1.FieldValues['性別']:=combobox1.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['職稱']:=edit9.Text;
   ADOquery1.FieldValues['聯系電話']:=edit10.Text;
   ADOquery1.FieldValues['授課教程']:=edit11.Text;
   ADOquery1.FieldValues['離校原因']:=edit12.Text;
   ADOquery1.FieldValues['郵政編碼']:=edit13.Text;
   ADOquery1.FieldValues['考勤']:=edit14.Text;
   ADOquery1.FieldValues['入校時間']:=edit15.Text;
   ADOquery1.FieldValues['離校時間']:=edit16.Text;
   ADoquery1.Post;
    application.MessageBox('信息已經修改完成！','修改提示',mb_ok);
 end;

procedure Tjsxxxg.FormActivate(Sender: TObject);
 var
 sqlstr:string;
begin
sqlstr:='select *from t_jiaoshi';
  Adoquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
end;

procedure Tjsxxxg.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
edit1.Text:=ADOquery1.FieldValues['教師號'];
edit2.Text:=ADOquery1.FieldValues['姓名'];
combobox1.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['家庭住址'];
edit9.Text:=ADOquery1.FieldValues['職稱'];
edit10.Text:=ADOquery1.FieldValues['聯系電話'];
edit11.Text:=ADOquery1.FieldValues['授課教程'];
edit12.Text:=ADOquery1.FieldValues['離校原因'];
edit13.Text:=ADOquery1.FieldValues['郵政編碼'];
edit14.Text:=ADOquery1.FieldValues['考勤'];
edit15.Text:=ADOquery1.FieldValues['入校時間'];
edit16.Text:=ADOquery1.FieldValues['離校時間'];
end;

end.