fangtaixiaofei.pas

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

unit fangtaixiaofei;

interface

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

type
  TFrmfangtaixiaofei = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    startdate: TDateTimePicker;
    Label2: TLabel;
    enddate: TDateTimePicker;
    SpeedButton1: TSpeedButton;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure ADOQuery1AfterOpen(DataSet: TDataSet);
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmfangtaixiaofei: TFrmfangtaixiaofei;

implementation
  uses dbmodule;
{$R *.dfm}

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

procedure TFrmfangtaixiaofei.SpeedButton1Click(Sender: TObject);
begin
  if adoquery1.Active then
    adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select a.fangtaiid,a.fangtainame,sum(b.caipincount*b.caipinprice) as heji');
  adoquery1.SQL.Add(' from Q_fangtai a,Q_customertemp b');
  adoquery1.SQL.Add('where a.fangtaiid=b.fangtaiid and b.opratedate between #'+datetostr(startdate.Date)+' 00:00:00# and #'+datetostr(enddate.Date)+' 23:59:59#');
  adoquery1.SQL.Add('Group by a.fangtaiid,a.fangtainame');
  adoquery1.Open;
end;

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

end.