delbjdatasrc.pas

报警地图电子显示源代码

unit DelBJDataSrc;

interface

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

type
  TFormDelBJData = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    ComboBoxDelBJData: TComboBox;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    procedure ButtonCloseClick(Sender: TObject);
    procedure ButtonDeleteClick(Sender: TObject);
    procedure ComboBoxDelBJDataChange(Sender: TObject);
    procedure ButtonOKClick(Sender: TObject);
    procedure ButtonDeleteAllClick(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormDelBJData: TFormDelBJData;

implementation

{$R *.dfm}
uses
BJDataSrc,QDialogs;

procedure TFormDelBJData.ButtonCloseClick(Sender: TObject);
begin
      Close;
end;

procedure TFormDelBJData.ComboBoxDelBJDataChange(Sender: TObject);
begin
     Edit1.Text := '';
end;

procedure TFormDelBJData.ButtonOKClick(Sender: TObject);  //查询....
var
     strSQL:string;
begin
     strSQL := 'select * from BJQWHB where ' + ComboBoxDelBJData.text + ' like ' + '"%'+ Edit1.Text + '%"';
     FormBJData.ADOQuery1.Close;
     FormBJData.ADOQuery1.SQL.Clear;
     FormBJData.ADOQuery1.SQL.Text := strSQL;
     FormBJData.ADOQuery1.Open;
end;

procedure TFormDelBJData.ButtonDeleteClick(Sender: TObject);
begin
     if FormBJData.ADOQuery1.IsEmpty then
     begin
           ShowMessage('已经没有记录可删除!');
           Exit;
     end;
     DBGrid1.ReadOnly:=false;
     FormBJData.ADOQuery1.Delete;
     DBGrid1.ReadOnly:=true;
     Edit1.Text := '';
end;

procedure TFormDelBJData.ButtonDeleteAllClick(Sender: TObject);
var
     strSQL:string;
begin
     strSQL := 'select * from BJQWHB';
     FormBJData.ADOQuery1.Close;
     FormBJData.ADOQuery1.SQL.Clear;
     FormBJData.ADOQuery1.SQL.Text := strSQL;
     FormBJData.ADOQuery1.ExecSQL;

     DBGrid1.ReadOnly:=false;
     FormBJData.ADOQuery1.Open;
     while not FormBJData.ADOQuery1.Eof do
     begin
          FormBJData.ADOQuery1.Delete;
          //FormBJData.ADOQuery1.Next;
     end;
     DBGrid1.ReadOnly:=true;
end;

procedure TFormDelBJData.Button5Click(Sender: TObject);   //查询全部.
var
     strSQL:string;
begin
     strSQL := 'select * from BJQWHB';
     FormBJData.ADOQuery1.Close;
     FormBJData.ADOQuery1.SQL.Clear;
     FormBJData.ADOQuery1.SQL.Text := strSQL;
     FormBJData.ADOQuery1.Open;
end;

procedure TFormDelBJData.FormActivate(Sender: TObject);
var i,num:Integer;
    str:string;
    strSQL:string;
begin
        ComboBoxDelBJData.Clear;
        FormBJData.ADOQuery1.Open;
        num:=FormBJData.ADOQuery1.FieldCount;
        for i:=0 to num-1 do
        begin
          str:=FormBJData.ADOQuery1.FieldList.Strings[i];
          ComboBoxDelBJData.Items.Add(str);
        end;
        ComboBoxDelBJData.ItemIndex := 0;
        Edit1.Text := '';
        strSQL := 'select * from BJQWHB';
        FormBJData.ADOQuery1.Close;
        FormBJData.ADOQuery1.SQL.Clear;
        FormBJData.ADOQuery1.SQL.Text := strSQL;
        FormBJData.ADOQuery1.Open;
end;

end.