jbxxunit.pas

高校学生学籍管理系统源码

unit jbxxunit;

interface

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

type
  Tjbxx = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Button1: TButton;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    ComboBox1: TComboBox;
    MaskEdit1: TMaskEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit15: TEdit;
    Edit16: TEdit;
    Edit17: TEdit;
    Edit18: TEdit;
    MaskEdit2: TMaskEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    ComboBox2: TComboBox;
    Edit21: TEdit;
    ComboBox3: TComboBox;
    MaskEdit3: TMaskEdit;
    MaskEdit4: TMaskEdit;
    ComboBox4: TComboBox;
    MaskEdit5: TMaskEdit;
    procedure ComboBox3Change(Sender: TObject);
    procedure ComboBox4Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Edit1Exit(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);

  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jbxx: Tjbxx;

implementation

uses datadomule;



{$R *.dfm}



procedure Tjbxx.ComboBox3Change(Sender: TObject);
begin

if combobox3.text='否' then
begin
maskedit3.color:=cl3DLight;
maskedit3.text:='0000-00';
maskedit3.ReadOnly:=true;
maskedit4.color:=cl3DLight;
maskedit4.text:='0000-00';
maskedit4.ReadOnly:=true;


end;
if combobox3.text='是' then
begin
maskedit3.ReadOnly:=false;
maskedit3.Color:= clWindow;
maskedit4.ReadOnly:=false;
maskedit4.color:=clWindow;
end;
end;


procedure Tjbxx.ComboBox4Change(Sender: TObject);
begin
if combobox4.text='否' then
begin
maskedit5.color:=cl3DLight ;
maskedit5.text:='0000-00';
maskedit5.ReadOnly:=true;
end;
if combobox4.text='是' then
begin
maskedit5.ReadOnly:=false;
maskedit5.Color:= clWindow;
end;
end;

procedure Tjbxx.Button1Click(Sender: TObject);
begin
if (edit1.text='') or (edit2.text='') or (edit3.text='') or (edit4.text='') or (edit5.text='') then
begin
 application.MessageBox('对不起！您输入的数据不全 请核对后再输！','错误',mb_ok+mb_iconinformation);
 exit;
end;



with datamodule1.jbxx.dataset do
begin
open;
edit;
append;
fields[0].asstring:=edit1.text;
fields[1].asstring:=edit2.text;
fields[3].asstring:=edit3.text;
fields[2].asstring:=edit4.text;
fields[4].asstring:=edit5.text;
fields[5].asstring:=edit6.text;
fields[8].asstring:=edit7.text;
fields[9].asstring:=edit8.text;
fields[19].asstring:=edit9.text;
fields[20].asstring:=edit10.text;
fields[16].asstring:=edit11.text;
fields[10].asstring:=edit12.text;
fields[24].asstring:=edit13.text; //政治情况
fields[17].asstring:=edit14.text;
fields[23].asstring:=edit15.text;
fields[21].asstring:=edit16.text;
fields[22].asstring:=edit17.text;
fields[18].asstring:=edit18.text;
fields[25].asstring:=edit19.text;
fields[26].asstring:=edit20.text;
fields[27].asstring:=edit21.text;
fields[7].asstring:=maskedit1.text;
fields[29].asstring:=maskedit2.text;
fields[12].asstring:=maskedit3.text;
fields[13].asstring:=maskedit4.text;
fields[15].asstring:=maskedit5.text;
fields[6].asstring:=combobox1.text;
fields[28].asstring:=combobox2.text;
fields[11].asstring:=combobox3.text;
fields[14].asstring:=combobox4.text;
 post;
 application.MessageBox('该学生档案输入完成','提示',mb_ok+mb_iconinformation);
end;
end;

procedure Tjbxx.Edit1Exit(Sender: TObject);
begin
with datamodule1.qry_jbxx do
begin
close;
sql.clear;
sql.add('select * from xsmc where xsxh_id=:id') ;
parambyname('id').asstring:=edit1.text;
open;
if findfirst then
 begin
 application.messagebox('该学生档案已存在，您可以在（学生档案情况）中修改’？','提示',mb_ok+mb_iconinformation);

  edit1.clear;

 end;
end;
end;

procedure Tjbxx.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
selectnext (activecontrol,true,true);
end;

end.