alert.pas

Monitor.dfm Meter.dpr pasMain.pas

unit Alert;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, StdCtrls, Grids, DBGrids, Db, DBTables, DBCtrls, ExtCtrls,
  Buttons;

type
  TfrmAlert = class(TForm)
    Panel1: TPanel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    BitBtn1: TBitBtn;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Label19: TLabel;
    Label20: TLabel;
    Query1: TQuery;
    DataSource1: TDataSource;
    meterreport: TPageControl;
    notsuccess: TTabSheet;
    Label1: TLabel;
    zero: TTabSheet;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    littzero: TTabSheet;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    procedure RadioButton1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Click(Sender: TObject);
    procedure meterreportChange(Sender: TObject);
  private
    { Private declarations }
  public
    procedure myquery;
    { Public declarations }
  end;

var
  frmAlert: TfrmAlert;


implementation

uses DM,global;

//uses pasMain, Info;

{$R *.DFM}
procedure TfrmAlert.myquery;
begin
 

end;

procedure TfrmAlert.RadioButton1Click(Sender: TObject);
begin
radiobutton1.Checked:=true;
radiobutton2.Checked:=false;
combobox1.text:='';
combobox2.text:='';
combobox1.Enabled:=false;
combobox2.Enabled:=false;
end;

procedure TfrmAlert.RadioButton2Click(Sender: TObject);
begin
radiobutton1.Checked:=false;
radiobutton2.Checked:=true;
combobox1.Enabled:=true;
combobox2.Enabled:=true;
end;

procedure TfrmAlert.BitBtn1Click(Sender: TObject);   //设置相应的查询语言
begin

  //设置查询所有抄表异常语句

  

  with query1 do
    begin
        Close;
        with SQL do
        begin
            Clear;
            Add('select rmt.dno,rmt.uno,rmt.rdt,Mtr.name,Mtr.address from rmt,Mtr ');
            Add('where rmt.uno=mtr.uno ');
            if combobox1.text<>'' then
                begin
                        Add(' and mtr.dno=:pardno ' );
                         if DM1.dstDB.Locate('NAME', combobox1.text, [loCaseInsensitive]) then
                         ParamByName('Pardno').AsString := DM1.dstDB.FieldByName('dno').AsString;
                end;
            if combobox2.text<>'' then
                begin
                        Add(' and rmt.rdt=:parrdt ' );
                        ParamByName('Parrdt').AsString := combobox2.text;
                end;

           end;
     end;


end;

procedure TfrmAlert.FormCreate(Sender: TObject);
begin
        query1.DatabaseName:=dbname;
        if dm1.dstdb.active=false then dm1.dstdb.Active:=true;
        dm1.dstdb.First;
        if dm1.dstdb.eof then exit;
        while  not(dm1.dstdb.Eof) do
        begin
            combobox1.Items.Add(dm1.dstdb.Fieldbyname('name').AsString);
            dm1.dstdb.Next;
        end;

        radiobutton1.Checked:=true;
        radiobutton2.Checked:=false;
        combobox1.Enabled:=false;
        combobox2.Enabled:=false;
end;

procedure TfrmAlert.ComboBox1Click(Sender: TObject);
begin
        combobox2.Items.Clear;
        combobox2.text:='';
        dm1.timedb.Active:=true;
        if combobox1.text ='' then exit;
        if DM1.dstDB.Locate('NAME', combobox1.text, [loCaseInsensitive]) then
        dm1.timedb.filter:='dno='+''''+DM1.dstDB.FieldByName('dno').AsString+'''';
        dm1.timedb.First;


        while  not(dm1.timedb.eof) do
        begin
                combobox2.Items.Add(dm1.timedb.fieldbyname('rdt').AsString);
                dm1.timedb.Next;
        end;
end;

procedure TfrmAlert.meterreportChange(Sender: TObject);
begin
    frmAlert.BitBtn1Click(frmalert);
    case meterreport.ActivePageIndex of
    0:  begin
            query1.sql.Add(' and rmt.sf="0" ' );
        end;
    1:  begin
            query1.sql.Add(' and rmt.dif=0 ' );
        end;
    2:  begin
            query1.sql.Add(' and rmt.dif<0 ' );
        end;
    end;
    query1.close;
    query1.prepare;
    query1.open;
    datasource1.dataset:=query1;
    label8.Caption:=combobox1.text+' 共 '+inttostr(datasource1.DataSet.RecordCount)+' 户';
    label8.Alignment:=taCenter;
    label1.caption:=label8.caption;
    label5.caption:=label8.caption;


end;

end.