unit4.~pas

小区抄表系统

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    GroupBox1: TGroupBox;
    ComboBox1: TComboBox;
    RadioGroup2: TRadioGroup;
    Label1: TLabel;
    Label2: TLabel;
    StaticText1: TStaticText;
    StaticText2: TStaticText;
    Edit1: TEdit;
    Edit2: TEdit;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    Button1: TButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.Button1Click(Sender: TObject);
var
   num,sj1,sj2:string;
begin
  num:=unit1.Form1.Edit1.Text;
  sj1:=edit1.text;
  sj2:=edit2.Text;
  //if combobox1.Text='编号' then
  //begin   //1
    if combobox1.text='电表' then
        begin  //2
          if radiogroup2.ItemIndex=1 then
          begin //*
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select max(示数) as 当前读数 from 数据信息 where (编号= '''+num+''')and (表名=''电表'')';
          Adoquery1.Open;

          end   //*
          else if radiogroup2.ItemIndex=0 then
          begin //*
          Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select (max(示数)-min(示数)) as 历史示数 from 数据信息 where (编号= '''+num+''')and (表名=''电表'')and (记录日期 between :a and :b)';
          adoquery1.Parameters.ParamByName('a').Value:=strtodate(trim(edit1.Text));
          adoquery1.Parameters.ParamByName('b').Value:=strtodate(trim(edit2.Text));
          Adoquery1.Open;

          end  //*
         else if radiogroup2.ItemIndex=2 then
          begin //*
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select * from 数据信息 where (编号= '''+num+''')and (表名=''电表'')';
          Adoquery1.Open;

          end   //*
        end  // 2
     else if combobox1.Text='水表'then
        begin //5
          if radiogroup2.ItemIndex=1then
          begin //
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select max(示数) as 当前读数 from 数据信息 where (编号= '''+num+''')and (表名=''水表'')';
          Adoquery1.Open;

          end
          else if radiogroup2.ItemIndex=0then
          begin
          Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select (max(示数)-min(示数)) as 历史示数 from 数据信息 where (编号= '''+num+''')and (表名=''水表'')and (记录日期 between :a and :b)';
          adoquery1.Parameters.ParamByName('a').Value:=strtodate(trim(edit1.Text));
          adoquery1.Parameters.ParamByName('b').Value:=strtodate(trim(edit2.Text));
          Adoquery1.Open;

          end
         else if radiogroup2.ItemIndex=2 then
          begin //*
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select * from 数据信息 where (编号= '''+num+''')and (表名=''水表'')';
          Adoquery1.Open;

          end   //*
        end //5
       else if combobox1.Text='煤气表'then
         begin  //
          if radiogroup2.ItemIndex=1then
          begin
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select max(示数) as 当前读数 from 数据信息 where (编号= '''+num+''')and (表名=''煤气表'')';
          Adoquery1.Open;

          end
          else if radiogroup2.ItemIndex=0then
          begin
         Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select (max(示数)-min(示数)) as 历史示数 from 数据信息 where (编号= '''+num+''')and (表名=''煤气表'')and (记录日期 between :a and :b)';
          adoquery1.Parameters.ParamByName('a').Value:=strtodate(trim(edit1.Text));
          adoquery1.Parameters.ParamByName('b').Value:=strtodate(trim(edit2.Text));
          Adoquery1.Open;

          end
          else if radiogroup2.ItemIndex=2 then
          begin //*
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select * from 数据信息 where (编号= '''+num+''')and (表名=''煤气表'')';
          Adoquery1.Open;

          end   //*
        end //
        else  if combobox1.Text='所有' then
           begin
          if radiogroup2.ItemIndex=1then
          begin
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select 表名,max(示数) as 当前读数 from 数据信息 where (编号= '''+num+''') group by 表名';
          Adoquery1.Open;

          end
          else if radiogroup2.ItemIndex=0then
          begin
         Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select 表名,(max(示数)-min(示数)) as 历史示数 from 数据信息 where (编号= '''+num+''')and (记录日期 between :a and :b) group by 表名';
          adoquery1.Parameters.ParamByName('a').Value:=strtodate(trim(edit1.Text));
          adoquery1.Parameters.ParamByName('b').Value:=strtodate(trim(edit2.Text));
          Adoquery1.Open;

        end
        else if radiogroup2.ItemIndex=2 then
          begin //*
           Adoquery1.Close;
          Adoquery1.SQL.Clear;
          Adoquery1.SQL.text:='select * from 数据信息 where (编号= '''+num+''')';
          Adoquery1.Open;

          end   //*
        end
 end;
end.