rkchart_unit.~pas

餐营的数据核算,模拟入库,出库,库存.对餐营的流程详细叙述

unit RKCHART_Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls, Buttons, Mask, DBCtrlsEh, ExtCtrls,
  TeEngine, Series, TeeProcs, Chart, DbChart,teeprevi;

type
  TRKCHART_Form = class(TForm)
    DBChart1: TDBChart;
    Series1: TBarSeries;
    Panel1: TPanel;
    Label1: TLabel;
    DBDateTimeEditEh1: TDBDateTimeEditEh;
    Label2: TLabel;
    Label3: TLabel;
    DBDateTimeEditEh2: TDBDateTimeEditEh;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    ComboBox2: TComboBox;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormDestroy(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RKCHART_Form: TRKCHART_Form;

implementation

uses DMUnit;

{$R *.dfm}

procedure TRKCHART_Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
Action:=cafree;
end;

procedure TRKCHART_Form.FormDestroy(Sender: TObject);
begin
RKCHART_Form:=nil;
end;

procedure TRKCHART_Form.FormCreate(Sender: TObject);
var
 i:integer;//字段数
begin
  with DM.RKCHART_ADOQ do
  begin
    Close;
    Open;
  end;
  for i:=0 to DM.RKCHART_ADOQ.FieldCount-1 do
 if DM.RKCHART_ADOQ.Fields[i].DataType=ftbcd then
  begin
    Combobox2.Items.Add(DM.RKCHART_ADOQ.Fields[i].FieldName);
  end;
  DM.RKCHART_ADOQ.Close;
end;

procedure TRKCHART_Form.BitBtn1Click(Sender: TObject);
var
  S,p:string;
begin
  S:='SELECT 入库时间=RM.RKD_TIME, 总数量=SUM(RP.ITEM_NUM), 总金额=SUM(RP.ITEM_MON) '+
     'FROM RKD_M RM LEFT JOIN RKD_P RP ON RP.RKD_NO=RM.RKD_NO WHERE  2>1 ';
  P:=' GROUP BY RM.RKD_TIME ';
  if (Trim(copy(DBDateTimeEditEh1.Text,0,1))<>'') and (Trim(copy(DBDateTimeEditEh1.Text,0,1))<>'') then
  S:=S+ ' and RM.RKD_TIME>='''+DBDateTimeEditEh1.Text+''' and RM.RKD_TIME<='''+DBDateTimeEditEh2.Text+'''';
  with DM.RKCHART_ADOQ do
  begin
    Close;
    SQL.Clear;
    SQL.Add(S+' '+p);
  end;
  Series1.Active:=true;
  Series1.YValues.ValueSource:=ComboBox2.Text;
  DM.RKCHART_ADOQ.Open;
end;

procedure TRKCHART_Form.BitBtn2Click(Sender: TObject);
begin
chartpreview(self,dbchart1);
end;

end.