bestslrep.pas

来自「日昌餐饮管理系统是用Delphi7+SQL写的管理系统」· PAS 代码 · 共 141 行

unit bestslrep;

interface

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

type
  TbestslForm = class(TForm)
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Shape1: TShape;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Label1: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label2: TLabel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    Panel1: TPanel;
    QuickRep1: TQuickRep;
    PageHeaderBand1: TQRBand;
    ColumnHeaderBand1: TQRBand;
    DetailBand1: TQRBand;
    SummaryBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText9: TQRDBText;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRLabel35: TQRLabel;
    QRExpr7: TQRExpr;
    QRExpr8: TQRExpr;
    QRShape3: TQRShape;
    QRSysData1: TQRSysData;
    Label3: TLabel;
    ComboBox1: TComboBox;
    ADOQuery2: TADOQuery;
    ADOQuery1DSDesigner: TStringField;
    ADOQuery1DSDesigner2: TStringField;
    ADOQuery1DSDesigner4: TBCDField;
    ADOQuery1Field: TStringField;
    ADOQuery3: TADOQuery;
    ADOQuery1Field2: TStringField;
    QRSysData2: TQRSysData;
    ADOQuery1DSDesigner3: TBCDField;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  bestslForm: TbestslForm;

implementation
uses rjsmain;
{$R *.dfm}

procedure TbestslForm.BitBtn1Click(Sender: TObject);
begin
     if adoquery1.Active then adoquery1.Close;
     adoquery1.SQL.Clear;
     if (combobox1.Text='') or (combobox1.Text='全部') then adoquery1.SQL.Add('select lb as 类别编号,bh as 菜品编号,sum(sl) as 销售数量, sum(je) as  金额 from dcd where rq>=:cs1 and rq<=:cs2 and zfbz=0 and fkbz=1 group by lb,bh order by 销售数量 desc ')
     else begin
       adoquery1.SQL.Add('select lb as 类别编号,bh as 菜品编号,sum(sl) as 销售数量, sum(je) as  金额 from dcd where rq>=:cs1 and rq<=:cs2 and zfbz=0 and fkbz=1 and lb=:cs3 group by lb,bh order by 销售数量 desc ');
       if adoquery2.Locate('lbmc',combobox1.Text,[]) then adoquery1.Parameters.ParamByName('cs3').Value:=adoquery2.FieldValues['lbbm'];
      end;
     datetimepicker1.Time:=datetimepicker2.Time;
     datetimepicker3.Time:=datetimepicker4.Time;
     adoquery1.Parameters.ParamByName('cs1').Value:=datetimepicker1.DateTime;
     adoquery1.Parameters.ParamByName('cs2').Value:=datetimepicker3.DateTime;
     adoquery1.Open;
end;

procedure TbestslForm.BitBtn2Click(Sender: TObject);
begin
     if adoquery1.Active=false then exit;
     messagedlg('请插入B5纸！',mtinformation,[mbok],0);
//     quickrep1.PrinterSetup;
     qrlabel26.Caption:=rjsmain.szdd;
     qrlabel28.Caption:=datetimetostr(datetimepicker1.DateTime)+' 到 '+datetimetostr(datetimepicker3.DateTime);
     quickrep1.Preview;
end;

procedure TbestslForm.BitBtn3Click(Sender: TObject);
begin
     close;
end;

procedure TbestslForm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     if adoquery1.Active then adoquery1.Close;
     if adoquery2.Active then adoquery2.Close;
     if adoquery3.Active then adoquery3.Close;
end;

procedure TbestslForm.FormActivate(Sender: TObject);
begin
     if adoquery1.Active then exit;
     datetimepicker1.Date:=date;
     datetimepicker3.Date:=date;
     combobox1.Items.Clear;
     if adoquery2.Active then adoquery2.First else adoquery2.Open;
     combobox1.Items.Add('全部');
     combobox1.Text:='全部';
     while not adoquery2.Eof do
     begin
       combobox1.Items.Add(adoquery2.FieldByName('lbmc').AsString);
       adoquery2.Next;
     end;
    if not adoquery3.Active then adoquery3.Open;
end;

end.