unit4.~pas

一个简单的医疗查询系统

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    Panel1: TPanel;
    MainMenu2: TMainMenu;
    MenuItem1: TMenuItem;
    MenuItem2: TMenuItem;
    MenuItem3: TMenuItem;
    MenuItem4: TMenuItem;
    MenuItem5: TMenuItem;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Button1: TButton;
    DBGrid1: TDBGrid;
    Panel2: TPanel;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    procedure N5Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure DBLookupComboBox1Click(Sender: TObject);
    procedure DBLookupComboBox2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.N5Click(Sender: TObject);
begin
  close;
end;

procedure TForm4.FormCreate(Sender: TObject);
begin
  dblookupcombobox1.KeyValue:=adotable1.fieldbyname('编号').AsString;
  dblookupcombobox2.KeyValue:=adotable1.fieldbyname('编号').AsString;
end;

procedure TForm4.DBLookupComboBox1Click(Sender: TObject);
begin
  adotable1.Filtered:=false;
  adotable1.Filter:='科室='+quotedstr(dblookupcombobox1.Text);
  adotable1.Filtered:=true;
end;

procedure TForm4.DBLookupComboBox2Click(Sender: TObject);
begin
  adotable1.Filtered:=false;
  adotable1.Filter:='职称='+quotedstr(dblookupcombobox2.Text);
  adotable1.Filtered:=true;
end;

end.