weekxsbgrep.pas

日昌餐饮管理系统是用Delphi7+SQL写的管理系统

unit Weekxsbgrep;

interface

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

type
  TweekForm = class(TForm)
    DBGrid1: TDBGrid;
    Shape1: TShape;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Label1: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label2: TLabel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    Panel1: TPanel;
    ADODataSet1: TADODataSet;
    DataSource1: TDataSource;
    QuickRep1: TQuickRep;
    PageHeaderBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRSysData1: TQRSysData;
    ColumnHeaderBand1: TQRBand;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel22: TQRLabel;
    QRLabel34: TQRLabel;
    DetailBand1: TQRBand;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    SummaryBand1: TQRBand;
    QRLabel16: TQRLabel;
    QRShape1: TQRShape;
    QRExpr1: TQRExpr;
    QRExpr2: TQRExpr;
    QRExpr3: TQRExpr;
    QRExpr4: TQRExpr;
    QRExpr5: TQRExpr;
    QRExpr6: TQRExpr;
    QRExpr7: TQRExpr;
    QRExpr8: TQRExpr;
    QRExpr9: TQRExpr;
    QRExpr10: TQRExpr;
    QRSysData2: TQRSysData;
    ADODataSet1th: TStringField;
    ADODataSet1DSDesigner: TBCDField;
    ADODataSet1DSDesigner2: TBCDField;
    ADODataSet1DSDesigner3: TBCDField;
    ADODataSet1DSDesigner4: TBCDField;
    ADODataSet1DSDesigner5: TIntegerField;
    ADODataSet1DSDesigner6: TIntegerField;
    ADODataSet1DSDesigner7: TBCDField;
    ADODataSet1DSDesigner8: TBCDField;
    ADODataSet1DSDesigner9: TIntegerField;
    ADODataSet1DSDesigner10: TIntegerField;
    ADODataSet1DSDesigner11: TIntegerField;
    ADODataSet1DSDesigner12: TIntegerField;
    ADODataSet1DSDesigner13: TIntegerField;
    ADODataSet1DSDesigner14: TIntegerField;
    ADODataSet1DSDesigner15: TIntegerField;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure QRLabel28Print(sender: TObject; var Value: String);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  weekForm: TweekForm;

implementation
uses rjsmain;
{$R *.dfm}

procedure TweekForm.BitBtn1Click(Sender: TObject);
begin
  DateTimePicker1.Time := DateTimePicker2.Time;
  DateTimePicker3.Time := DateTimePicker4.Time;

  ADODataSet1.Active := false;
  ADODataSet1.Parameters.ParamByName('ksrqcs1').Value := DateTimePicker1.DateTime;
  ADODataSet1.Parameters.ParamByName('jzrqcs2').Value := DateTimePicker3.DateTime;
  ADODataSet1.Active := true;
end;

procedure TweekForm.BitBtn2Click(Sender: TObject);
begin
     messagedlg('请插入A4纸，设定打印机,纸张为“横向”输出！',mtinformation,[mbok],0);
//     quickrep1.PrinterSetup;
     quickrep1.Preview;
end;

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

procedure TweekForm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     if adodataset1.Active then adodataset1.Close;
end;

procedure TweekForm.FormShow(Sender: TObject);
begin
  DateTimePicker1.Date := date;
  DateTimePicker3.Date := date;

end;

procedure TweekForm.QRLabel28Print(sender: TObject; var Value: String);
begin
  Value := datetimetostr(DateTimePicker1.DateTime)+'至'+datetimetostr(DateTimePicker3.DateTime);
end;

procedure TweekForm.FormActivate(Sender: TObject);
begin
     datetimepicker1.Date:=date;
     datetimepicker3.Date:=date;
end;

end.