forminfo.pas

《Delphi数据库应用项目开发实践》配书光盘

unit FormInfo;

interface

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

type
  TInfo = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Button1: TButton;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    procedure ComboBox1Change(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
  Info: TInfo;
  number: Integer;

implementation
uses FormManage;
{$R *.dfm}

procedure TInfo.ComboBox1Change(Sender: TObject);
begin
if ComboBox1.ItemIndex=5 then
begin
adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Add('select * from 药品信息');
 adoquery1.Open;
 end
end;

procedure TInfo.FormCreate(Sender: TObject);
begin
Edit1.Clear;
ComboBox1.ItemIndex:=0;
DBGrid1.Columns.Items[2].Font.Color:=clRed;
//DBGrid1.Columns.Items[3].Font.Color:=clRed;
for  number:=0 to 5 do
begin
DBGrid1.Fields[number].DisplayWidth:=10;
DBGrid1.Columns.Items[number].Alignment:=taLeftJustify;
end
end;

procedure TInfo.Button1Click(Sender: TObject);
begin
if ComboBox1.ItemIndex<> 5 then
begin
  adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Add('select * from 药品信息 where '+ComboBox1.Items[ComboBox1.ItemIndex]+' = '''+edit1.Text+'''');
 adoquery1.Open;
 end
 else
 begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Add('select * from 药品信息');
 adoquery1.Open;
 end

end;

procedure TInfo.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Manage.show;
end;

end.