unit_bb2.pas

某小区物业管理系统源码某小区物业管理系统源码

unit Unit_bb2;

interface

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

type
  TForm_bb2 = class(TForm)
    ImageList1: TImageList;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    Panel1: TPanel;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Edit5: TEdit;
    Label5: TLabel;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form_bb2: TForm_bb2;

implementation

{$R *.dfm}

procedure TForm_bb2.ToolButton2Click(Sender: TObject);
begin
adoquery1.First;
end;

procedure TForm_bb2.ToolButton3Click(Sender: TObject);
begin
adoquery1.Prior;
end;

procedure TForm_bb2.ToolButton4Click(Sender: TObject);
begin
adoquery1.Next;
end;

procedure TForm_bb2.ToolButton5Click(Sender: TObject);
begin
adoquery1.Last;
end;

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

procedure TForm_bb2.ToolButton1Click(Sender: TObject);
var i,k,j,s,s1:integer;

begin
 with adoquery1 do
begin
sql.Clear;
close;
sql.add('select *  from 住户报修表 where 报修日期<=:ID ');
parameters[0].Value:=edit1.Text;
open;
end;
i:=0;
s:=0;
k:=0;
j:=0;
s1:=0;
while not adoquery1.Eof do
    begin
    inc(i);
    k:=strtoint(adoquery1.FieldByName('服务费用').AsString);
    s:=s+k;
   j:=strtoint(adoquery1.FieldByName('物料费用').asstring);
   s1:=s1+j;
    adoquery1.Next;
    end;

    edit2.Text:=inttostr(s1);
    edit3.Text:=inttostr(s);
    edit4.Text:=inttostr(i);
    edit5.Text:=inttostr(s+s1);
end;

end.