diandanquery.pas

小管理程序主要管理的小咖啡厅我是从网上下的经测试可用

unit diandanquery;

interface

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

type
  TFrmdiandanquery = class(TForm)
    GroupBox3: TGroupBox;
    DBGrid2: TDBGrid;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    RadioGroup1: TRadioGroup;
    SpeedButton1: TSpeedButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure ADOQuery1AfterOpen(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmdiandanquery: TFrmdiandanquery;

implementation
   uses dbmodule;
{$R *.dfm}

procedure TFrmdiandanquery.SpeedButton1Click(Sender: TObject);
begin
  if adoquery1.Active then
    adoquery1.Close;
  adoquery1.SQL.Clear;
  if RadioGroup1.ItemIndex=0 then
    begin
      adoquery1.SQL.Add('select chuanbiaohao,caipinname,caipincount,caipinunit,caipinprice,dianliexing,caipinprice*caipincount as heji from Q_customertemp');
      adoquery1.SQL.Add(' where  chuanbiaohao  like'+''''+'%'+edit1.Text+'%'+'''');
    end
  else if RadioGroup1.ItemIndex=1 then
     begin
       adoquery1.SQL.Add('select chuanbiaohao,caipinname,caipincount,caipinunit,caipinprice,caipinlei as dianliexing,caipinprice*caipincount as heji from Q_tuidan');
       adoquery1.SQL.Add(' where  chuanbiaohao  like'+''''+'%'+edit1.Text+'%'+'''');
     end;
  adoquery1.Open;
end;

procedure TFrmdiandanquery.FormShow(Sender: TObject);
begin
  edit1.Text:='';
end;

procedure TFrmdiandanquery.ADOQuery1AfterOpen(DataSet: TDataSet);
begin
  dm.UpdateFieldFormats(dataset);
end;

end.