cfcxnit.pas

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

unit cfcxnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, ExtCtrls, StdCtrls, ToolWin, ComCtrls,datadomule;

type
  Tcfcx = class(TForm)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    ToolBar1: TToolBar;
    ComboBox1: TComboBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure Edit1Enter(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cfcx: Tcfcx;

implementation

{$R *.dfm}

procedure Tcfcx.Button1Click(Sender: TObject);
begin
if combobox1.text='按学号查询' then
begin
with datamodule1.qry_cfcx do
begin
close;
sql.Clear;
sql.Add('select * from viewcfcx where xsxh_id=:id');
parambyname('id').asstring:=edit1.text;
open;
if recordcount=0 then
begin
application.MessageBox('没有该学生的惩处记录','提示',mb_ok+mb_iconinformation);

end;
end;
end;

if combobox1.text='按时间查询' then
begin
with datamodule1.qry_cfcx do
begin
close;
sql.Clear;
sql.Add('select * from viewcfcx where sj00 like :id');
parambyname('id').asstring:=edit1.text+'%';
open;
if recordcount=0 then
begin
application.MessageBox('没有检索到惩处记录','提示',mb_ok+mb_iconinformation);

end;
end;
end;

end;

procedure Tcfcx.ComboBox1Change(Sender: TObject);
begin
if combobox1.text='按时间查询' then
begin
edit1.text:='请输入年份';

end;
if combobox1.text='按学号查询' then
begin
edit1.text:='请输入学号';

end;
end;

procedure Tcfcx.Edit1Enter(Sender: TObject);
begin
edit1.Clear ;
end;

end.