mc_jzsjfx.pas

一个通用的餐饮管理软件

unit MC_JZSJFX;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ExtCtrls, ComCtrls, StdCtrls, ImgList, Grids, DBGrids, Db, DBTables,
  Buttons, Qrctrls, QuickRpt;

type
  TJZSJFX = class(TForm)
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Panel2: TPanel;
    TreeView1: TTreeView;
    ImageList1: TImageList;
    DBGrid1: TDBGrid;
    Query1: TQuery;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DataSource1: TDataSource;
    Query2: TQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure TreeView1Click(Sender: TObject);
    procedure QuickRep1Preview(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  JZSJFX: TJZSJFX;

implementation

uses MC_TLCYGLXT, MC_DYYLBrose;

{$R *.DFM}
procedure TJZSJFX.FormCreate(Sender: TObject);
var TList:array[0..6] of TTreeNode;
a:integer;
begin
 TreeView1.Items.Clear;
 TreeView1.Items.Add(nil,'日结帐分析');  //设置树状组件标题
 Query1.CLose;
 Query1.SQL.Clear;
 Query1.SQL.Add('Select * From 餐饮部门信息表');  //选择所有部门
 Query1.Open;
 While not Query1.Eof do
 begin
   TList[0]:=TreeView1.Items.AddChild(TreeView1.Items[0],Query1.FieldByName('部门名称').AsString); //增加部门
   Tlist[0].ImageIndex:=2;
   TList[0].SelectedIndex:=2;
   Query1.Next;
 end;
 Query1.Close;
 Query1.SQL.Clear;
 Query1.SQL.Add('select * From 房间台号信息表');  //选择所有房台
 Query1.Open;
 While not Query1.Eof do
 begin
  for a:=0 to TreeView1.Items[0].Count-1 do
   begin
    if Query1.FieldByName('餐饮部门').AsString=TreeView1.Items[0].Item[a].Text then
     begin
      TList[1]:=TreeView1.Items.AddChild(Treeview1.Items[0].Item[a],Query1.FieldByName('房台名称').AsString); //增加房台
      TList[1].ImageIndex:=1;
      TList[1].SelectedIndex:=1;
     end;
   end;
  Query1.Next;
 end;
 Query1.Close;
 Query1.SQL.Clear;
end;

procedure TJZSJFX.FormShow(Sender: TObject);
begin
 TreeView1.Items[0].Expanded:=True;
end;

procedure TJZSJFX.TreeView1Click(Sender: TObject);  //选择分析内容
var list:array[0..3]of TTreeNode;
a:integer;
begin
List[0]:=TreeView1.Selected;
if list[0].ImageIndex=2 then
begin
  Query1.Close;
  Query1.SQL.Clear;
  Query1.SQL.Add('Select * From 日点菜信息表,房间台号信息表');
  Query1.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A');
  Query1.SQL.Add('ORDER BY 结帐编号 ASC');
  Query1.Params[0].AsString:=List[0].Text;
  Query1.Open;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
  Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 日点菜信息表.状态=''点单''');
  Query2.Params[0].AsString:=List[0].Text;
  Query2.Open;
  Label4.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
  Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 日点菜信息表.状态=''赠单''');
  Query2.Params[0].AsString:=List[0].Text;
  Query2.Open;
  Label5.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
  Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A');
  Query2.Params[0].AsString:=List[0].Text;
  Query2.Open;
  Label6.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
end;
if list[0].ImageIndex=1 then
begin
  for a:=0 to TreeView1.Items[0].Count-1 do
  begin
    if TreeView1.Items[0].Item[a].IndexOf(List[0])>-1 then
      begin
        List[1]:=TreeView1.Items[0].Item[a];
        Query1.Close;
        Query1.SQL.Clear;
        Query1.SQL.Add('select * From 日点菜信息表,房间台号信息表');
        Query1.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 房间台号信息表.房台名称=:B');
        Query1.Params[0].AsString:=List[1].Text;
        Query1.Params[1].AsString:=List[0].Text;
        Query1.Open;
        Break;
      end;
  end;
    Query2.Close;
    Query2.SQL.Clear;
    Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
    Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 房间台号信息表.房台名称=:B and 日点菜信息表.状态=''点单''');
    Query2.Params[0].AsString:=List[1].Text;
    Query2.Params[1].AsString:=List[0].Text;
    Query2.Open;
    Label4.Caption:=Query2.Fields[0].AsString;
    Query2.Close;
    Query2.SQL.Clear;
    Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
    Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 房间台号信息表.房台名称=:B and 日点菜信息表.状态=''赠单''');
    Query2.Params[0].AsString:=List[1].Text;
    Query2.Params[1].AsString:=List[0].Text;
    Query2.Open;
    Label5.Caption:=Query2.Fields[0].AsString;
    Query2.Close;
    Query2.SQL.Clear;
    Query2.SQL.Add('select Sum(合计) From 日点菜信息表,房间台号信息表');
    Query2.SQL.Add('Where 日点菜信息表.房间台号=房间台号信息表.编号 and 房间台号信息表.餐饮部门=:A and 房间台号信息表.房台名称=:B');
    Query2.Params[0].AsString:=List[1].Text;
    Query2.Params[1].AsString:=List[0].Text;
    Query2.Open;
    Label6.Caption:=Query2.Fields[0].AsString;
    Query2.Close;
end;
if list[0].ImageIndex=0 then
begin
  Query1.Close;
  Query1.SQL.Clear;
  Query1.SQL.Add('Select * From 日点菜信息表');
  Query1.SQL.Add('ORDER BY 结帐编号 ASC');
  Query1.Open;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表 Where 状态=''点单''');
  Query2.Open;
  Label4.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表 Where 状态=''赠单''');
  Query2.Open;
  Label5.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
  Query2.SQL.Clear;
  Query2.SQL.Add('select Sum(合计) From 日点菜信息表');
  Query2.Open;
  Label6.Caption:=Query2.Fields[0].AsString;
  Query2.Close;
end;
end;

procedure TJZSJFX.QuickRep1Preview(Sender: TObject);
begin
/// DYYLBrose.QrPreview1.QRPrinter:=QuickRep1.QRPrinter;
end;


procedure TJZSJFX.BitBtn1Click(Sender: TObject);  //打印点菜信息
begin
 DYYLBrose.Show;
/// QuickRep1.Preview;
end;
procedure TJZSJFX.FormClose(Sender: TObject; var Action: TCloseAction);
begin
 JZSJFX.Release;
 JZSJFX:=Nil;
end;

procedure TJZSJFX.BitBtn2Click(Sender: TObject);  //关闭结账数据分析
begin
 Close;
end;
end.