unit13.pas

学校学籍管理系统

unit Unit13;

interface

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

type
  TForm13 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    Label1: TLabel;
    Label5: TLabel;
    i_stud_id_1: TMaskEdit;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    DBText1: TDBText;
    DBText2: TDBText;
    DBText3: TDBText;
    i_descrip_1: TMemo;
    Button1: TButton;
    Button2: TButton;
    TabSheet2: TTabSheet;
    Label37: TLabel;
    Label41: TLabel;
    GroupBox9: TGroupBox;
    Label38: TLabel;
    Label39: TLabel;
    Label40: TLabel;
    DBText10: TDBText;
    DBText11: TDBText;
    DBText12: TDBText;
    i_stud_id_5: TMaskEdit;
    i_descrip_5: TMemo;
    Button17: TButton;
    Button18: TButton;
    TabSheet3: TTabSheet;
    Label6: TLabel;
    Label10: TLabel;
    i_stud_id_2: TMaskEdit;
    GroupBox2: TGroupBox;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    DBText4: TDBText;
    DBText5: TDBText;
    DBText6: TDBText;
    i_descrip_2: TMemo;
    Button3: TButton;
    Button4: TButton;
    TabSheet4: TTabSheet;
    Label11: TLabel;
    Label15: TLabel;
    i_stud_id_3: TMaskEdit;
    GroupBox3: TGroupBox;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    DBText7: TDBText;
    DBText8: TDBText;
    DBText9: TDBText;
    i_descrip_3: TMemo;
    Button5: TButton;
    Button6: TButton;
    Button8: TButton;
    Button9: TButton;
    Button11: TButton;
    Button12: TButton;
    DateTimePicker1: TDateTimePicker;
    Label16: TLabel;
    Label17: TLabel;
    DateTimePicker2: TDateTimePicker;
    Label18: TLabel;
    Label19: TLabel;
    DateTimePicker3: TDateTimePicker;
    Label20: TLabel;
    Label21: TLabel;
    DateTimePicker5: TDateTimePicker;
    Label24: TLabel;
    Label25: TLabel;
    DataSource1: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    DBLookupComboBox2: TDBLookupComboBox;
    DBLookupComboBox3: TDBLookupComboBox;
    DBLookupComboBox4: TDBLookupComboBox;
    DataSource4: TDataSource;
    DataSource5: TDataSource;
    DataSource6: TDataSource;
    DataSource7: TDataSource;
    DataSource8: TDataSource;
    DataSource9: TDataSource;
    Button7: TButton;
    Button10: TButton;
    Button13: TButton;
    TabSheet5: TTabSheet;
    Label22: TLabel;
    GroupBox4: TGroupBox;
    Label23: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    DBText13: TDBText;
    DBText14: TDBText;
    DBText15: TDBText;
    Label28: TLabel;
    DateTimePicker4: TDateTimePicker;
    Label29: TLabel;
    DBLookupComboBox5: TDBLookupComboBox;
    Label30: TLabel;
    i_descrip_4: TMemo;
    Button19: TButton;
    Button20: TButton;
    Button21: TButton;
    DataSource10: TDataSource;
    DataSource11: TDataSource;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    i_stud_id_6: TMaskEdit;
    DBComboBox1: TDBComboBox;
    Label31: TLabel;
    procedure Button7Click(Sender: TObject);
    procedure i_stud_id_1Change(Sender: TObject);
    procedure i_stud_id_5Change(Sender: TObject);
    procedure i_stud_id_2Change(Sender: TObject);
    procedure i_stud_id_3Change(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button17Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button18Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button15Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button13Click(Sender: TObject);
    procedure Button16Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure i_stud_id_6Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form13: TForm13;

implementation

uses Unit4;

{$R *.dfm}

procedure TForm13.Button7Click(Sender: TObject);
begin
dm.studen.close;;
i_stud_id_3.Text:='';
i_descrip_3.lines.Clear;
i_stud_id_2.Text:='';
i_descrip_2.lines.Clear;
i_stud_id_1.Text:='';
i_descrip_1.lines.Clear;
i_stud_id_5.Text:='';;
i_descrip_5.lines.Clear;
i_descrip_4.Text:='';;
i_descrip_4.lines.Clear;
close;
end;

procedure TForm13.i_stud_id_1Change(Sender: TObject);
begin
dm.studen.Filter:='ID='''+i_stud_id_1.Text+'''';
dm.studen.Filtered:=True;
dm.studen.Open;
end;

procedure TForm13.i_stud_id_5Change(Sender: TObject);
begin
dm.studen.Filter:='ID='''+i_stud_id_5.Text+'''';
dm.studen.Filtered:=True;
dm.studen.Open;
end;

procedure TForm13.i_stud_id_2Change(Sender: TObject);
begin
dm.studen.Filter:='ID='''+i_stud_id_2.Text+'''';
dm.studen.Filtered:=True;
dm.studen.Open;
end;

procedure TForm13.i_stud_id_3Change(Sender: TObject);
begin
dm.studen.Filter:='ID='''+i_stud_id_3.Text+'''';
dm.studen.Filtered:=True;
dm.studen.Open;
end;

procedure TForm13.Button8Click(Sender: TObject);
var
  counter:integer;
begin
  dm.studen.Open;
  if dm.studen.RecordCount>0 then //确认学号是否存在
  begin
dm.soji.Open;
dm.soji.FieldByName('id').AsString:=i_stud_id_1.Text;
dm.soji.FieldByName('data').AsDateTime:=datetimepicker1.Date;
dm.soji.FieldByName('be').AsString:=i_descrip_1.lines.text;
dm.soji.Post;
next;
dm.soji.Refresh;
  end
  else
    Application.MessageBox('请确认输入的学号是否正确！', '错误', MB_OK);
end;

procedure TForm13.Button17Click(Sender: TObject);
var
  counter:integer;
begin
  dm.studen.Open;
  if dm.studen.RecordCount>0 then //确认学号是否存在
  begin
dm.soji1.Open;
dm.soji1.FieldByName('id').AsString:=i_stud_id_5.Text;
dm.soji1.FieldByName('data').AsDateTime:=datetimepicker2.Date;
dm.soji1.FieldByName('be').AsString:=i_descrip_5.lines.text;
dm.soji1.Post;
next;
dm.soji1.Refresh;
  end
  else
    Application.MessageBox('请确认输入的学号是否正确！', '错误', MB_OK);
end;

procedure TForm13.Button11Click(Sender: TObject);
var
  counter:integer;
begin
  dm.studen.Open;
  if dm.studen.RecordCount>0 then //确认学号是否存在
  begin
dm.soji2.Open;
dm.soji2.FieldByName('id').AsString:=i_stud_id_2.Text;
dm.soji2.FieldByName('data').AsDateTime:=datetimepicker3.Date;
dm.soji2.FieldByName('be').AsString:=i_descrip_2.lines.text;
dm.soji2.Post;
next;
dm.soji2.Refresh;
  end
  else
    Application.MessageBox('请确认输入的学号是否正确！', '错误', MB_OK);
end;

procedure TForm13.Button14Click(Sender: TObject);
var
  counter:integer;
begin
  dm.studen.Open;
  if dm.studen.RecordCount>0 then //确认学号是否存在
  begin
dm.bioe.Open;
dm.bioe.FieldByName('id').AsString:=i_stud_id_6.Text;
dm.bioe.FieldByName('data').AsDateTime:=DateTimePicker5.Date;
dm.bioe.FieldByName('be').AsString:=i_descrip_4.lines.text;
dm.bioe.Post;
next;
dm.bioe.Refresh;
dm.studen.Open;
dm.studen.post;
next;
  end
  else
    Application.MessageBox('请确认输入的学号是否正确！', '错误', MB_OK);
end;

procedure TForm13.Button9Click(Sender: TObject);
begin
i_descrip_1.lines.Clear;
end;

procedure TForm13.Button18Click(Sender: TObject);
begin
i_descrip_5.lines.Clear;
end;

procedure TForm13.Button12Click(Sender: TObject);
begin
i_descrip_2.lines.Clear;
end;

procedure TForm13.Button15Click(Sender: TObject);
begin
i_descrip_4.lines.Clear;
end;

procedure TForm13.BitBtn1Click(Sender: TObject);
var
  counter:integer;
begin
  dm.studen.Open;
  if dm.studen.RecordCount>0 then //确认学号是否存在
  begin
dm.soji3.Open;
dm.soji3.FieldByName('id').AsString:=i_stud_id_3.Text;
dm.soji3.FieldByName('data').AsDateTime:=datetimepicker4.Date;
dm.soji3.FieldByName('be').AsString:=i_descrip_3.lines.text;
dm.soji3.Post;
next;
dm.soji3.Refresh;
  end
  else
    Application.MessageBox('请确认输入的学号是否正确！', '错误', MB_OK);
end;


procedure TForm13.Button10Click(Sender: TObject);
begin
dm.studen.close;;
i_stud_id_3.Text:='';
i_descrip_3.lines.Clear;
i_stud_id_2.Text:='';
i_descrip_2.lines.Clear;
i_stud_id_1.Text:='';
i_descrip_1.lines.Clear;
i_stud_id_5.Text:='';;
i_descrip_5.lines.Clear;
i_descrip_4.Text:='';;
i_descrip_4.lines.Clear;
close;
end;

procedure TForm13.Button13Click(Sender: TObject);
begin
dm.studen.close;;
i_stud_id_3.Text:='';
i_descrip_3.lines.Clear;
i_stud_id_2.Text:='';
i_descrip_2.lines.Clear;
i_stud_id_1.Text:='';
i_descrip_1.lines.Clear;
i_stud_id_5.Text:='';;
i_descrip_5.lines.Clear;
i_descrip_4.Text:='';;
i_descrip_4.lines.Clear;
close;
end;

procedure TForm13.Button16Click(Sender: TObject);
begin
dm.studen.close;;
i_stud_id_3.Text:='';
i_descrip_3.lines.Clear;
i_stud_id_2.Text:='';
i_descrip_2.lines.Clear;
i_stud_id_1.Text:='';
i_descrip_1.lines.Clear;
i_stud_id_5.Text:='';;
i_descrip_5.lines.Clear;
i_descrip_4.Text:='';;
i_descrip_4.lines.Clear;
i_stud_id_6.Text:='';;
close;
end;
procedure TForm13.BitBtn3Click(Sender: TObject);
begin
dm.studen.close;;
i_stud_id_3.Text:='';
i_descrip_3.lines.Clear;
i_stud_id_2.Text:='';
i_descrip_2.lines.Clear;
i_stud_id_1.Text:='';
i_descrip_1.lines.Clear;
i_stud_id_5.Text:='';;
i_descrip_5.lines.Clear;
i_descrip_4.Text:='';;
i_descrip_4.lines.Clear;
close;
end;

procedure TForm13.BitBtn2Click(Sender: TObject);
begin
i_descrip_3.lines.Clear;
end;

procedure TForm13.i_stud_id_6Change(Sender: TObject);
begin
dm.studen.Filter:='ID='''+i_stud_id_6.Text+'''';
dm.studen.Filtered:=True;
dm.studen.Open;
end;

end.