see_snkc.pas

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

unit See_snkc;

interface

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

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

var
  Form7: TForm7;

implementation

uses Sn_kcprint;

{$R *.dfm}

procedure TForm7.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 TForm7.Button1Click(Sender: TObject);
 var splba:string;
begin
  splba:=splb.text;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from Sn_kucun where TypeName='''+splba+'''');
  Q_splb.SQL.Add('order by MenuName,Intime');
  Q_splb.Open;
  Q_splb.Active:=True;

end;

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


end;

procedure TForm7.Button3Click(Sender: TObject);
begin
    Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from Sn_kucun order by MenuNo');
  Q_splb.Open;

end;

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

procedure TForm7.Button4Click(Sender: TObject);
begin
 form8.QuickRep1.Preview; 
end;

end.