u_buy.~pas

1. 在IBConsole中添加两个用户LOGIN和MATER

unit u_buy;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Mask, DBCtrls, ExtCtrls, Grids, DBGrids, ComCtrls, TeEngine,
  Series, TeeProcs, Chart, DBChart, Buttons, Spin;

type
  TF_buy = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    GroupBox2: TGroupBox;
    DBNavigator1: TDBNavigator;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit1: TDBEdit;
    DBLookupComboBox1: TDBLookupComboBox;
    DBGrid2: TDBGrid;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    Label8: TLabel;
    GroupBox3: TGroupBox;
    DBNavigator2: TDBNavigator;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    DBEdit6: TDBEdit;
    DBLookupComboBox2: TDBLookupComboBox;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBRadioGroup1: TDBRadioGroup;
    BitBtn1: TBitBtn;
    B_print: TButton;
    Chart1: TChart;
    B_stat: TButton;
    Series1: TBarSeries;
    Label13: TLabel;
    i_year: TSpinEdit;
    Label14: TLabel;
    i_start_month: TSpinEdit;
    Label15: TLabel;
    i_end_month: TSpinEdit;
    Label18: TLabel;
    procedure FormShow(Sender: TObject);
    procedure B_statClick(Sender: TObject);
    procedure B_printClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_buy: TF_buy;

implementation

uses u_datamodule;
{$R *.DFM}

procedure TF_buy.FormShow(Sender: TObject);
begin
  DM_main.OpenBuy;
end;

procedure TF_buy.B_statClick(Sender: TObject);
var
  i:integer;
  start_time,end_time:TDateTime;
  sum_price:integer;
begin
  Series1.Clear;
  end_time:=StrToDateTime(i_year.Text+'-'+IntToStr(i_start_month.Value)+'-01 00:00:00');
  for i:=i_start_month.Value to i_end_month.Value do
  begin
    start_time:=end_time;
    if i=12 then
      end_time:=StrToDateTime(i_year.Text+'-12-31 23:59:59')
    else
      end_time:=StrToDateTime(i_year.Text+'-'+IntToStr(i+1)+'-01 00:00:00');
    sum_price:=DM_main.SumPrices(start_time, end_time);
    Series1.AddXY(i, sum_price, IntToStr(i)+'月份');
  end;
end;

procedure TF_buy.B_printClick(Sender: TObject);
begin
  Chart1.Print;
end;

end.