unit9.pas

来自「学校学籍管理系统」· PAS 代码 · 共 138 行

unit Unit9;

interface

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

type
  Twu = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Edit1: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Button1: TButton;
    GroupBox2: TGroupBox;
    StatusBar1: TStatusBar;
    Button2: TButton;
    ComboBox3: TComboBox;
    MaskEdit1: TMaskEdit;
    DBGrid1: TDBGrid;
    Label9: TLabel;
    ComboBox4: TComboBox;
    procedure Button2Click(Sender: TObject);
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
    procedure Edit6KeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  wu: Twu;

implementation

uses Unit8, Unit4, Unit3;

{$R *.dfm}

procedure Twu.Button2Click(Sender: TObject);
begin
close;
end;

procedure Twu.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
 if not (key in ['0'..'9']) then key :=#0;
end;

procedure Twu.Edit6KeyPress(Sender: TObject; var Key: Char);
begin
 if not (key in ['0'..'9']) then key :=#0;
end;

procedure Twu.Button1Click(Sender: TObject);
var
  sqlstr:string;
begin
   sqlstr:='select * from studen where (1=1)';
if MaskEdit1.text<>'' then
   sqlstr:=sqlstr+'and (id='''+MaskEdit1.text+''')';
if edit1.Text <>'' then
   sqlstr:=sqlstr+'and (user='''+edit1.text+''')';
if combobox1.Text<>'' then
   sqlstr:=sqlstr+'and (sex='''+combobox1.text+''')' ;
if combobox2.Text <>'' then
   sqlstr:=sqlstr+'and (bang='''+combobox2.text+''')' ;
if  combobox3.text<>'' then
sqlstr:=sqlstr+'and (jian='''+combobox3.text+''')';
if edit4.text<>'' then
sqlstr:=sqlstr+'and (jiname='''+edit4.text+''')';
if edit5.text<>'' then
sqlstr:=sqlstr+'and (fon='''+edit5.text+''')';
if edit6.text<>'' then
sqlstr:=sqlstr+'and (tel='''+edit6.text+''')';
if edit6.text<>'' then
sqlstr:=sqlstr+'and (zi='''+combobox4.text+''')';
dm.xueQuery1.Close ;
dm.xueQuery1.SQL.Clear ;
dm.xueQuery1.SQL.Add(sqlstr);
dm.xueQuery1.Open;
Edit1.Text:='';
MaskEdit1.Text:='';
Edit4.Text:='';
Edit5.Text:='';
Edit6.Text:='';
combobox1.Text:='';
combobox2.Text:='';
combobox3.Text:='';
combobox4.Text:='';
statusbar1.Panels[0].Text:='总共找到 '+inttostr(dm.xueQuery1.RecordCount)+' 条记录';
 wu.DBGrid1.columns[0].width:=54;
 wu.DBGrid1.columns[1].width:=64;
 wu.DBGrid1.columns[2].width:=34;
 wu.DBGrid1.columns[3].width:=74;
 wu.DBGrid1.columns[4].width:=94;
 wu.DBGrid1.columns[5].width:=74;
 wu.DBGrid1.columns[6].width:=74;
 wu.DBGrid1.columns[7].width:=104;
 wu.DBGrid1.columns[8].width:=60;
 wu.DBGrid1.columns[9].width:=74;
 wu.DBGrid1.columns[10].width:=54;
 wu.DBGrid1.columns[11].width:=74;
 wu.DBGrid1.columns[12].width:=54;
wu.DBGrid1.columns[13].width:=64;
wu.DBGrid1.columns[14].width:=104;
wu.DBGrid1.columns[0].title.caption:='学号';
 wu.DBGrid1.columns[1].title.caption:='姓名';
 wu.DBGrid1.columns[2].title.caption:='性别';
 wu.DBGrid1.columns[3].title.caption:='出生日期';
 wu.DBGrid1.columns[4].title.caption:='就读专业';
 wu.DBGrid1.columns[5].title.caption:='班级';
 wu.DBGrid1.columns[6].title.caption:='入学日期';
 wu.DBGrid1.columns[7].title.caption:='家庭住址';
 wu.DBGrid1.columns[8].title.caption:='家长姓名';
 wu.DBGrid1.columns[9].title.caption:='联系电话';
 wu.DBGrid1.columns[10].title.caption:='是否住宿';
 wu.DBGrid1.columns[11].title.caption:='房号';
 wu.DBGrid1.columns[12].title.caption:='学习年段';
  wu.DBGrid1.columns[13].title.caption:='当前状况';
 wu.DBGrid1.columns[14].title.caption:='备注';
end;
end.