unit BXrptUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Mask, DBCtrls, Grids, DBGrids, ExtCtrls, ComCtrls,
  ToolWin, ImgList, DB, ADODB;

type
  TBXrptForm = class(TForm)
    ImageList1: TImageList;
    ToolBar1: TToolBar;
    ToolButton4: TToolButton;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton5: TToolButton;
    ToolButton7: TToolButton;
    ToolButton6: TToolButton;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Label2: TLabel;
    Label3: TLabel;
    Label1: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit3: TDBEdit;
    Edit1: TEdit;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit4: TDBEdit;
    procedure FormShow(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure ToolButton7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  BXrptForm: TBXrptForm;

implementation
uses udm, BXprint;
{$R *.dfm}

procedure TBXrptForm.FormShow(Sender: TObject);
begin
  Edit1.Text := DateTimeToStr(Now);
  DBEdit1.Text := IntToStr(adodm.ZHBX.RecordCount);
  with adodm.search1 do
  begin
    Close;
    adodm.search1.DataSource := adodm.dsZHBX;
    CommandText := '';
    CommandText := 'SELECT sum(服務費用) FROM ZHBXTable';
    open;
  end;
  DBedit2.DataSource := adodm.dssearch1;
  DBedit2.DataField := 'COLUMN1';
  with adodm.search2 do
  begin
    Close;
    adodm.search2.DataSource := adodm.dsZHBX;
    CommandText := '';
    CommandText := 'SELECT sum(物料費用) FROM ZHBXTable';
    open;
  end;
  DBedit3.DataSource := adodm.dssearch2;
  DBedit3.DataField := 'COLUMN1';
  with adodm.search3 do
  begin
    Close;
    adodm.search3.DataSource := adodm.dsZHBX;
    CommandText := '';
    CommandText := 'SELECT sum(費用合計) FROM ZHBXTable';
    open;
  end;
  DBedit4.DataSource := adodm.dssearch3;
  DBedit4.DataField := 'COLUMN1';
end;

procedure TBXrptForm.ToolButton4Click(Sender: TObject);
begin
  adodm.ZHBX.Refresh;
end;

procedure TBXrptForm.ToolButton1Click(Sender: TObject);
begin
  adodm.ZHBX.First;
end;

procedure TBXrptForm.ToolButton2Click(Sender: TObject);
begin
  adodm.ZHBX.Prior;
end;

procedure TBXrptForm.ToolButton3Click(Sender: TObject);
begin
  adodm.ZHBX.Next;
end;

procedure TBXrptForm.ToolButton5Click(Sender: TObject);
begin
  adodm.ZHBX.Last;
end;

procedure TBXrptForm.ToolButton6Click(Sender: TObject);
begin
  close;
end;

procedure TBXrptForm.ToolButton7Click(Sender: TObject);
begin
  BXrptPrint.Preview;
end;

end.