see_kc.~pas

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

unit see_kc;

interface

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

type
  TForm19 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label4: TLabel;
    splb: TComboBox;
    spmc: TComboBox;
    Button1: TButton;
    Button2: TButton;
    GroupBox3: TGroupBox;
    Q_splb: TQuery;
    DataSource1: TDataSource;
    Q_lb: TQuery;
    Q_spmc: TQuery;
    DBGrid1: TDBGrid;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    procedure FormCreate(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form19: TForm19;

implementation

uses H_kcPrint;

{$R *.dfm}

procedure TForm19.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 TForm19.Button3Click(Sender: TObject);
begin
    Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from kucun order by MenuNo');
  Q_splb.Open;
end;

procedure TForm19.Button5Click(Sender: TObject);
begin
  close;
end;

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

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

procedure TForm19.Button4Click(Sender: TObject);
begin
  form28.QuickRep1.Preview;
end;

end.