teacherunit.~pas

教学信息管理系统是校园信息管理系统的一个有机组成部分。经过详细的需求分析

unit teacherunit;

interface

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

type
  Tteacherform = class(TForm)
    Panel1: TPanel;
    Label9: TLabel;
    Edit1: TEdit;
    BitBtn1: TBitBtn;
    Panel2: TPanel;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    DBImage1: TDBImage;
    DBNavigator1: TDBNavigator;
    Panel3: TPanel;
    Bevel1: TBevel;
    DBGrid1: TDBGrid;
  
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure FormCreate(Sender: TObject);
 private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  teacherform: Tteacherform;

implementation

uses datamoduleUnit;

{$R *.dfm} 
procedure Tteacherform.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
datamodule1.queryall.Close;
datamodule1.DSteacher.DataSet:=datamodule1.tableteacher;
end;



procedure Tteacherform.BitBtn1Click(Sender: TObject);
var tname,tempstr :string;
begin
if (trim(edit1.Text)='')  then
  begin
    messagebox (Handle,'姓名不能为空，请输入！','警告',mb_ok) ;
    exit;
  end;
 tname:=trim(edit1.Text);
 tempstr:=format('姓名中包含 "%s" 的教师的信息没有找到！',[tname]);
 with datamodule1.queryall do
    begin
    close;
    sql.Clear;
    sql.Add('select * from teacher where tname like :tname');
    Parameters.ParamByName('tname').Value:='%'+tname+'%';
    prepared:=true;
    open;
     if IsEmpty then
         begin
            messagebox (Handle,pointer(tempstr),'反馈信息',mb_ok) ;
         end;


    end;
 edit1.Text:='';      
end;

procedure Tteacherform.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
  bitbtn1.Click;
end;



procedure Tteacherform.FormCreate(Sender: TObject);
begin
datamodule1.DSteacher.DataSet:=datamodule1.queryall;
end;

end.