u_main.~pas

这是一个简单的学生管理系统

unit U_main;

interface

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

type
  TFrmmain = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Label5: TLabel;
    student_id1: TMaskEdit;
    i_change: TRadioGroup;
    GroupBox1: TGroupBox;
    DBText1: TDBText;
    DBText3: TDBText;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Button1: TButton;
    Button2: TButton;
    i_descript: TMemo;
    TabSheet3: TTabSheet;
    Label16: TLabel;
    Label20: TLabel;
    GroupBox6: TGroupBox;
    DBText4: TDBText;
    DBText5: TDBText;
    DBText6: TDBText;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    RG_RW: TRadioGroup;
    student_id2: TMaskEdit;
    ok: TBitBtn;
    b2: TBitBtn;
    descript_rw: TMemo;
    TabSheet4: TTabSheet;
    Label21: TLabel;
    Label22: TLabel;
    student_id3: TMaskEdit;
    RadioGroup1: TRadioGroup;
    Memo1: TMemo;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    GroupBox7: TGroupBox;
    DBText7: TDBText;
    DBText8: TDBText;
    DBText9: TDBText;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    TabSheet5: TTabSheet;
    Label6: TLabel;
    student_id4: TMaskEdit;
    GroupBox2: TGroupBox;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    DBEdit1: TDBEdit;
    DBRadioGroup1: TDBRadioGroup;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    Button3: TButton;
    Button4: TButton;
    GroupBox3: TGroupBox;
    Label14: TLabel;
    Label15: TLabel;
    DBLookupComboBox3: TDBLookupComboBox;
    DBMemo1: TDBMemo;
    Button5: TButton;
    Button6: TButton;
    GroupBox4: TGroupBox;
    GroupBox8: TGroupBox;
    Label26: TLabel;
    Label27: TLabel;
    DBLookupComboBox4: TDBLookupComboBox;
    DBMemo2: TDBMemo;
    Button8: TButton;
    Button7: TButton;
    DBGrid3: TDBGrid;
    GroupBox5: TGroupBox;
    Label28: TLabel;
    Label29: TLabel;
    GroupBox9: TGroupBox;
    Label30: TLabel;
    Label31: TLabel;
    Button9: TButton;
    Button10: TButton;
    DBLookupComboBox5: TDBLookupComboBox;
    DBMemo3: TDBMemo;
    DBGrid4: TDBGrid;
    DBGrid2: TDBGrid;
    DBText2: TDBText;
    GroupBox10: TGroupBox;
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure student_id1Change(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure student_id4Change(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure TabSheet5Exit(Sender: TObject);
    procedure student_id2Change(Sender: TObject);
    procedure okClick(Sender: TObject);
    procedure b2Click(Sender: TObject);
    procedure student_id3Change(Sender: TObject);
    procedure TabSheet3Show(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure TabSheet4Show(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);


  private
    { Private declarations }
  public
    procedure box();
    { Public declarations }
  end;

var
  Frmmain: TFrmmain;

implementation

uses Login;

{$R *.dfm}
procedure TFrmmain.box();
begin
   application.MessageBox('操作成功！','提示',mb_OK) ;
end;

procedure TFrmmain.FormShow(Sender: TObject);
begin

  if not datam.student.Active then
     datam.student.Open;

end;

procedure TFrmmain.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  datam.student.close;
end;

procedure TFrmmain.student_id1Change(Sender: TObject);
begin
datam.student_id1.Filter:='id='+''''+student_id1.Text+'''';
datam.student_id1.Filtered:=true;
datam.student_id1.Open;
datam.class1.Open;
datam.department1.Open;
end;

procedure TFrmmain.Button2Click(Sender: TObject);
begin
student_id1.Text:='';
i_change.ItemIndex:=0;
i_descript.Clear;
end;

procedure TFrmmain.TabSheet2Show(Sender: TObject);
begin
button2click(sender);
end;

procedure TFrmmain.Button1Click(Sender: TObject);
var
counter:integer;
begin
datam.student_id1.Open;
if datam.student_id1.RecordCount>0 then
begin
 datam.COUNTER_C.Filtered:=true;
 datam.COUNTER_C.Filter:='id='+''''+'C'+'''';
 datam.COUNTER_C.Open;
 if datam.COUNTER_C.FieldByName('counter_value').AsString='' then
    counter:=0
 else
    counter:= datam.COUNTER_C['counter_value'];
 inc(counter);
  datam.COUNTER_C.Edit;
  
 datam.COUNTER_C['counter_value']:=counter;
 datam.COUNTER_C.Post;
 datam.CHANGE.Open;
 //showmessage(inttostr(counter));
 datam.CHANGE.AppendRecord([counter,student_id1.Text,i_change.ItemIndex,now,i_descript.Text]);
 button2click(nil);
 box();
end
else
begin
application.MessageBox('学号是否正确！','错误',mb_ok)
end;


end;

procedure TFrmmain.student_id4Change(Sender: TObject);
begin
datam.student_id4.Filter:='ID='+''''+student_id4.Text+'''';
datam.student_id4.Filtered:=true;
datam.student_id4.Open;
datam.class4.Open;
datam.department4.Open;
datam.change4.Open;
datam.CHANGE_CODE4.Open;
datam.REWARD4.Open;
datam.REWARD_LEVELS4.Open;
datam.punish4.Open;
datam.PUNISH_LEVELS4.Open;
end;

procedure TFrmmain.Button3Click(Sender: TObject);
begin
datam.student_id4.edit;
datam.student_id4.post;
box();
end; 
procedure TFrmmain.Button4Click(Sender: TObject);
begin
datam.student_id4.Cancel;
box();
end;

procedure TFrmmain.Button5Click(Sender: TObject);
begin
datam.change4.Edit ;
datam.change4.Post;
box();
end;

procedure TFrmmain.Button6Click(Sender: TObject);
begin
datam.change4.Cancel;
box();
end;

procedure TFrmmain.TabSheet5Exit(Sender: TObject);
begin
datam.student_id4.close;
datam.class4.close;
datam.department4.close;
datam.change4.close;
datam.CHANGE_CODE4.close;
datam.REWARD4.close;
datam.REWARD_LEVELS4.close;
datam.punish4.Close;
datam.PUNISH_LEVELS4.Close;
end;

procedure TFrmmain.student_id2Change(Sender: TObject);
begin
datam.student_id2.Filter:='id='+''''+student_id2.Text+'''';
datam.student_id2.Filtered:=true;
datam.student_id2.Open;
datam.class2.Open;
datam.DEPARTMENT2.Open;
end;

procedure TFrmmain.okClick(Sender: TObject);
var
counter:integer;
begin
//datam.student_id.Open;
if datam.student_id2.RecordCount>0 then
begin
 datam.COUNTER_R.Filtered:=true;
 datam.COUNTER_R.Filter:='id='+''''+'R'+'''';
 datam.COUNTER_R.Open;
 if datam.COUNTER_R.FieldByName('counter_value').AsString='' then
    counter:=0
 else
    counter:= datam.COUNTER_R['counter_value'];
 inc(counter);
  datam.COUNTER_R.Edit;

 datam.COUNTER_R['counter_value']:=counter;
 datam.COUNTER_R.Post;
 datam.reward.Open;
 //showmessage(inttostr(counter));
 datam.reward.AppendRecord([counter,student_id2.Text,rg_rw.ItemIndex,now,descript_rw.Text]);
 b2click(nil);
 box();
end
else
begin
application.MessageBox('学号是否正确！','错误',mb_ok)
end;

end;
procedure TFrmmain.b2Click(Sender: TObject);
begin
student_id2.Text:='';
rg_rw.ItemIndex:=0;
descript_rw.Clear;
end;

procedure TFrmmain.student_id3Change(Sender: TObject);
begin
datam.student_id3.Filter:='id='+''''+student_id3.Text+'''';
datam.student_id3.Filtered:=true;
datam.student_id3.Open;
datam.class3.Open;
datam.DEPARTMENT3.Open;
end;

procedure TFrmmain.TabSheet3Show(Sender: TObject);
begin
b2click(sender);
end;

procedure TFrmmain.BitBtn2Click(Sender: TObject);
begin
student_id3.Text:='';
RadioGroup1.ItemIndex:=0;
Memo1.Clear;
end;

procedure TFrmmain.TabSheet4Show(Sender: TObject);
begin
bitbtn2click(sender);
end;



procedure TFrmmain.Button7Click(Sender: TObject);
begin
datam.REWARD4.Edit;
datam.REWARD4.Post;
box();
end;

procedure TFrmmain.Button8Click(Sender: TObject);
begin
datam.REWARD4.Cancel;
box();
end;

procedure TFrmmain.BitBtn1Click(Sender: TObject);

var
counter:integer;
begin
//datam.student_id.Open;
if datam.student_id3.RecordCount>0 then
begin
 datam.COUNTER_P.Filtered:=true;
 datam.COUNTER_P.Filter:='id='+''''+'P'+'''';
 datam.COUNTER_P.Open;
 if datam.COUNTER_P.FieldByName('counter_value').AsString='' then
    counter:=0
 else
    counter:= datam.COUNTER_P['counter_value'];
 inc(counter);
  datam.COUNTER_P.Edit;

 datam.COUNTER_P['counter_value']:=counter;
 datam.COUNTER_P.Post;
 datam.punish.Open;
 //showmessage(inttostr(counter));
 datam.punish.AppendRecord([counter,student_id3.Text,RadioGroup1.ItemIndex,now,Memo1.Text]);
 bitbtn2click(nil);
 box();
end
else
 begin
 application.MessageBox('学号是否正确！','错误',mb_ok)
 end;
end;


procedure TFrmmain.Button9Click(Sender: TObject);
begin
datam.punish4.Edit;
datam.punish4.Post;
box();
end;

procedure TFrmmain.Button10Click(Sender: TObject);
begin
datam.punish4.Cancel;
box();
end;

end.