see_rk.pas

结于初学者来说这对数据库是一个很好的例子

unit see_rk;

interface

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

type
  TForm18 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label4: TLabel;
    Button1: TButton;
    spmc: TComboBox;
    Button2: TButton;
    GroupBox3: TGroupBox;
    Q_spmc: TQuery;
    Q_splb: TQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    splb: TComboBox;
    Q_lb: TQuery;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form18: TForm18;

implementation

uses H_inPrint;

{$R *.dfm}

procedure TForm18.FormCreate(Sender: TObject);
begin
  Q_lb.Open;
  Q_lb.Active:=True;
  while not Q_lb.Eof do
        begin
          splb.Items.Add(Q_lb.FieldByName('TypeName').AsString);
          Q_lb.Next;
        end;

  Q_spmc.Active:=False;
  Q_spmc.Close;
  Q_spmc.Open;
  Q_spmc.Active:=True;
while not Q_spmc.Eof do
        begin
          spmc.Items.Add(Q_spmc.FieldByName('MenuName').AsString);
          Q_spmc.Next;
        end;
end;

procedure TForm18.SpeedButton1Click(Sender: TObject);
begin
 close;
end;

procedure TForm18.Button2Click(Sender: TObject);
  var MenuName:string;
begin
  MenuName:=spmc.Text;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from H_in where MenuName='''+MenuName+'''');
  Q_splb.SQL.Add('order by MenuName,Intime');
  Q_splb.Open;
  Q_splb.Active:=True;
end;

procedure TForm18.SpeedButton2Click(Sender: TObject);
begin
    Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from H_in order by MenuName,Intime');
  Q_splb.Open;
end;

procedure TForm18.SpeedButton4Click(Sender: TObject);
begin
 close;
end;

procedure TForm18.Button1Click(Sender: TObject);
 var splba:string;
begin
  splba:=splb.text;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from H_in where TypeName='''+splba+'''');
  Q_splb.SQL.Add('order by MenuName,Intime');
  Q_splb.Open;
  Q_splb.Active:=True;
end;

procedure TForm18.SpeedButton3Click(Sender: TObject);
begin
  Form27.QuickRep1.Preview;
end;

end.