search.~pas

来自「DElphi教学排课管理系统全套 包括论文。希望对大家有帮助」· ~PAS 代码 · 共 102 行

unit search;

interface

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

type
  TForm21 = class(TForm)
    Label1: TLabel;
    i_id: TEdit;
    T_user2: TTable;
    DS_user2: TDataSource;
    T_department: TTable;
    DS_department: TDataSource;
    Label3: TLabel;
    i_job: TDBLookupComboBox;
    T_job: TTable;
    DS_job: TDataSource;
    Label4: TLabel;
    i_edu_level: TDBLookupComboBox;
    T_edu_level: TTable;
    DS_edu_level: TDataSource;
    Label5: TLabel;
    i_name: TDBEdit;
    Label6: TLabel;
    i_birthday: TDBEdit;
    i_sex: TDBRadioGroup;
    Label2: TLabel;
    i_specialty: TDBEdit;
    Label7: TLabel;
    i_address: TDBEdit;
    Label8: TLabel;
    i_tel: TDBEdit;
    Label9: TLabel;
    i_remark: TDBMemo;
    Label10: TLabel;
    i_email: TDBEdit;
    Button1: TButton;
    Label11: TLabel;
    T_change: TTable;
    T_change_list: TTable;
    DS_change_list: TDataSource;
    T_counter: TTable;
    DBCtrlGrid1: TDBCtrlGrid;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBMemo1: TDBMemo;
    procedure i_idChange(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form21: TForm21;

implementation

{$R *.dfm}

procedure TForm21.i_idChange(Sender: TObject);
begin
    T_user_2.Filter:='ID='''+i_id.Text+'''';
    T_user_2.Filtered:=True;
    T_user_2.Open;
    T_change_list.Filter:='PERSON='''+i_id.Text+'''';
    T_change_list.Filtered:=True;
    T_change_list.Open;
end;

procedure TForm21.FormCreate(Sender: TObject);
begin
      if not T_department.Active then T_department.Open ;
      if not T_job.Active then T_job.Open ;
      if not T_edu_level.Active then T_edu_level.Open ;
      T_user2.Close ;
end;

procedure TForm21.Button1Click(Sender: TObject);
begin
       T_user2.Post ;
       T_change_list.Post ;
end;

procedure TForm21.FormClose(Sender: TObject; var Action: TCloseAction);
begin
      inherited;
      T_user2.Close;
      T_change_list.Close ;
end;

end.