unit stinfo;

interface

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

type
  TForm7 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    Database1: TDatabase;
    T_student: TTable;
    DS_student: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Label1: TLabel;
    T_stud_info_1: TTable;
    DS_stud_info_1: TDataSource;
    DS_class_info_1: TDataSource;
    DS_depart_info_1: TDataSource;
    T_class_info_1: TTable;
    T_depart_info_1: TTable;
    T_counter_c: TTable;
    T_change: TTable;
    i_stud_id_1: TMaskEdit;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    DBText1: TDBText;
    DBText2: TDBText;
    DBText3: TDBText;
    i_change: TRadioGroup;
    i_descrip_1: TMemo;
    Label5: TLabel;
    Button1: TButton;
    Button2: TButton;
    SpeedButton2: TSpeedButton;
    Label6: TLabel;
    i_stud_id_4: TMaskEdit;
    Label7: TLabel;
    i_stud_id_2: TMaskEdit;
    GroupBox2: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    DBText4: TDBText;
    DBText5: TDBText;
    DBText6: TDBText;
    i_reward_level: TRadioGroup;
    Label11: TLabel;
    i_descrip_2: TMemo;
    Button3: TButton;
    Button4: TButton;
    Label12: TLabel;
    i_stud_id_3: TMaskEdit;
    GroupBox3: TGroupBox;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    DBText7: TDBText;
    DBText8: TDBText;
    DBText9: TDBText;
    i_punish_level: TRadioGroup;
    Label16: TLabel;
    i_descrip_3: TMemo;
    Button5: TButton;
    Button6: TButton;
    T_counter_r: TTable;
    T_counter_p: TTable;
    T_punish: TTable;
    T_reward: TTable;
    T_stud_info_2: TTable;
    DS_stud_info_2: TDataSource;
    T_class_info_2: TTable;
    DS_class_info_2: TDataSource;
    T_depart_info_2: TTable;
    DS_depart_info_2: TDataSource;
    T_stud_info_3: TTable;
    DS_stud_info_3: TDataSource;
    DS_class_info_3: TDataSource;
    DS_depart_info_3: TDataSource;
    T_class_info_3: TTable;
    T_depart_info_3: TTable;
    GroupBox4: TGroupBox;
    Label17: TLabel;
    Label18: TLabel;
    DBRadioGroup1: TDBRadioGroup;
    DBEdit1: TDBEdit;
    Label19: TLabel;
    Label20: TLabel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Label21: TLabel;
    Label22: TLabel;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    Button7: TButton;
    Button8: TButton;
    Label23: TLabel;
    DBGrid2: TDBGrid;
    Label24: TLabel;
    DBGrid3: TDBGrid;
    Label25: TLabel;
    DBGrid4: TDBGrid;
    GroupBox5: TGroupBox;
    GroupBox6: TGroupBox;
    GroupBox7: TGroupBox;
    Label26: TLabel;
    DBLookupComboBox3: TDBLookupComboBox;
    Label27: TLabel;
    DBMemo1: TDBMemo;
    Button9: TButton;
    Button10: TButton;
    Label28: TLabel;
    DBLookupComboBox4: TDBLookupComboBox;
    Label29: TLabel;
    DBMemo2: TDBMemo;
    Button11: TButton;
    Button12: TButton;
    Label30: TLabel;
    DBLookupComboBox5: TDBLookupComboBox;
    Label31: TLabel;
    DBRadioGroup2: TDBRadioGroup;
    DBMemo3: TDBMemo;
    Button13: TButton;
    Button14: TButton;
    T_stud_info_4: TTable;
    DS_stud_info_4: TDataSource;
    T_class_info_4: TTable;
    DS_class_info_4: TDataSource;
    T_depart_info_4: TTable;
    DS_depart_info_4: TDataSource;
    T_change_4: TTable;
    DS_change_4: TDataSource;
    T_change_code_4: TTable;
    DS_change_code_4: TDataSource;
    T_reward_4: TTable;
    DS_reward_4: TDataSource;
    T_reward_level_4: TTable;
    DS_reward_level_4: TDataSource;
    T_punish_4: TTable;
    DS_punish_4: TDataSource;
    T_punish_level_4: TTable;
    DS_punish_level_4: TDataSource;
    SpeedButton3: TSpeedButton;
    StatusBar1: TStatusBar;
    procedure FormCreate(Sender: TObject);
    procedure i_stud_id_1Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure i_stud_id_2Change(Sender: TObject);
    procedure i_stud_id_3Change(Sender: TObject);
    procedure i_stud_id_4Change(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button13Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;

implementation

uses student, ipthelp;

{$R *.dfm}

procedure TForm7.FormCreate(Sender: TObject);
begin
    T_student.Open ;
    DBGrid1.Columns [0].Width :=64;
    DBGrid1.Columns [1].Width :=64;
    DBGrid1.Columns [2].Width :=64;
    DBGrid1.Columns [3].Width :=64;
    DBGrid1.Columns [4].Width :=64;
    DBGrid1.Columns [5].Width :=64;
    DBGrid1.Columns [6].Width :=100;

end;

procedure TForm7.i_stud_id_1Change(Sender: TObject);
begin
   T_stud_info_1.Filter :='ID='''+i_stud_id_1.Text+'''';
   T_stud_info_1.Filtered :=true;
   T_stud_info_1.Open ;
   T_class_info_1.Open;
   T_depart_info_1.Open;
end;

procedure TForm7.Button1Click(Sender: TObject);
begin
   i_stud_id_1.Text:='';   //學號輸入框清空
   i_change.ItemIndex :=0; //學籍變更復位到”轉系“
   i_descrip_1.Clear ;  //描述框清空
end;

procedure TForm7.Button2Click(Sender: TObject);
var counter:smallint;
begin
  T_stud_info_1.Open;
  if T_stud_info_1.RecordCount >0 then     //判斷輸入的學號是否存在
     begin
        T_counter_c.Open;    //如果存在，開始追加記錄
        counter:=T_counter_c['COUNTER_VALUE'];
        Inc(counter);
        T_counter_c.Edit ;
        T_counter_c['COUNTER_VALUE']:=counter;
        T_counter_c.Post;
        T_change.Open;
        T_change.appendrecord([counter,i_stud_id_1.Text,i_change.itemindex,now,i_descrip_1.Text]);
        button1click(nil);
     end
     else
         Application.messagebox('請確認輸入的學號是否正確','錯誤',MB_OK);

end;

procedure TForm7.SpeedButton2Click(Sender: TObject);
begin
    form7.Hide;
    form2.show;
end;

procedure TForm7.SpeedButton1Click(Sender: TObject);
begin
   form1.show;
end;

procedure TForm7.Button5Click(Sender: TObject);
var
  counter:smallint;
begin
  T_stud_info_3.Open;
  if T_stud_info_3.RecordCount>0 then //確認學號是否存在
  begin
    T_counter_p.Open;
    counter:=T_counter_p['COUNTER_VALUE'];
    Inc(counter); //累加處罰記錄計數器
    T_counter_p.Edit;
    T_counter_p['COUNTER_VALUE']:=counter;
    T_counter_p.Post;   //修改計數器值
    T_punish.Open;   //打開處罰數據表
    T_punish.AppendRecord([counter, i_stud_id_3.text, i_punish_level.ItemIndex, Now, True, i_descrip_3.text]);//添加數據到處罰數據表
    Button6Click(nil);
  end
  else
    Application.MessageBox('請確認輸入的學號是否正確！', '錯誤', MB_OK);
end;

procedure TForm7.Button6Click(Sender: TObject);
begin
  i_stud_id_3.Text:='';
  i_punish_level.ItemIndex:=0;
  i_descrip_3.Clear;
 
end;

procedure TForm7.Button3Click(Sender: TObject);
var
counter:smallint;
begin
  T_stud_info_2.Open;
  if T_stud_info_2.RecordCount>0 then //確認學號是否存在
  begin
    T_counter_r.Open;
    counter:=T_counter_r['COUNTER_VALUE'];
    Inc(counter); //累加獎勵記錄計數器
    T_counter_r.Edit;
    T_counter_r['COUNTER_VALUE']:=counter;
    T_counter_r.Post;
    T_reward.Open;
    T_reward.AppendRecord([counter, i_stud_id_2.text, i_reward_level.ItemIndex, Now, i_descrip_2.text]);
    Button4Click(nil);
  end
  else
    Application.MessageBox('請確認輸入的學號是否正確！', '錯誤', MB_OK);
end;

procedure TForm7.Button4Click(Sender: TObject);
begin
  i_stud_id_2.Text:='';
  i_reward_level.ItemIndex:=0;
  i_descrip_2.Clear;
end;

procedure TForm7.i_stud_id_2Change(Sender: TObject);
begin
   T_stud_info_2.Filter :='ID='''+i_stud_id_2.Text+'''';
   T_stud_info_2.Filtered :=true;
   T_stud_info_2.Open ;
   T_class_info_2.Open;
   T_depart_info_2.Open;
end;

procedure TForm7.i_stud_id_3Change(Sender: TObject);
begin
   T_stud_info_3.Filter :='ID='''+i_stud_id_3.Text+'''';
   T_stud_info_3.Filtered :=true;
   T_stud_info_3.Open ;
   T_class_info_3.Open;
   T_depart_info_3.Open;
end;

procedure TForm7.i_stud_id_4Change(Sender: TObject);
begin
  T_stud_info_4.Filter:='ID='''+i_stud_id_4.Text+'''';
  T_stud_info_4.Filtered:=True;
  T_stud_info_4.Open;
  T_class_info_4.Open;
  T_depart_info_4.Open;
  T_change_4.Open;
  T_change_code_4.Open;
  T_reward_4.Open;
  T_reward_level_4.Open;
  T_punish_4.Open;
  T_punish_level_4.Open;
end;

procedure TForm7.Button7Click(Sender: TObject);
begin
   T_stud_info_4.Post;   //在學生信息查詢修改確認對學生信息的修改
end;

procedure TForm7.Button8Click(Sender: TObject);
begin
    T_stud_info_4.Cancel;
end;

procedure TForm7.Button9Click(Sender: TObject);
begin
    T_change_4.Post;   //在學生信息查詢修改子界面中確認對學生變更情況的修改
end;

procedure TForm7.Button10Click(Sender: TObject);
begin
    T_change_4.Cancel;
end;

procedure TForm7.Button11Click(Sender: TObject);
begin
   T_reward_4.Post;  //在學生信息查詢修改子界面中確認對學生獎勵情況的修改

end;

procedure TForm7.Button12Click(Sender: TObject);
begin
    T_reward_4.Cancel;
end;

procedure TForm7.Button13Click(Sender: TObject);
begin
    T_punish_4.Post;  //在學生信息查詢修改子界面中確認對學生懲罰情況的修改
end;

procedure TForm7.Button14Click(Sender: TObject);
begin
   T_punish.Cancel;
end;

end.