unit MC_XQSSCX;

interface

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

type
  TXQSSCX = class(TForm)
    DBGrid1: TDBGrid;
    Query1: TQuery;
    DataSource1: TDataSource;
    Query1BDEDesigner: TStringField;
    Query1BDEDesigner2: TStringField;
    Query1BDEDesigner3: TStringField;
    Query1BDEDesigner4: TIntegerField;
    Query1BDEDesigner5: TStringField;
    Query1BDEDesigner6: TStringField;
    Query1BDEDesigner7: TDateTimeField;
    Query1BDEDesigner8: TStringField;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit1: TEdit;
    Label1: TLabel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  XQSSCX: TXQSSCX;

implementation

uses MC_SSDJ;

{$R *.DFM}

procedure TXQSSCX.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     XQSSCX.release;
     XQSSCX:=Nil;
end;

procedure TXQSSCX.FormShow(Sender: TObject);
begin
     ComboBox1.ItemIndex:=0;
     comboBox2.ItemIndex:=0;
     if MainFrom.Query1.Locate('使用選項','小區設施查詢',[loCaseInsensitive]) then
        begin
             if MainFrom.Query1.FieldByName('讀寫').AsString='讀' then
                begin
                     BitBtn1.Enabled:=False;
                     Bitbtn2.Enabled:=False;
                end;
        end;
end;

procedure TXQSSCX.BitBtn2Click(Sender: TObject);
begin
     if Query1.Active then
     if Query1.RecordCount<>0 then
     if MessageDlg('是否刪除當前信息？',mtCustom,[mbYes,mbNo],0)=mrYes then
        Query1.Delete;
end;

procedure TXQSSCX.BitBtn3Click(Sender: TObject);
begin
     Close;
end;

procedure TXQSSCX.BitBtn4Click(Sender: TObject);
begin
     if ComboBox2.text='Like' then
     if Edit1.Text='*' then
        begin
             With query1 do
             begin
                  Close;
                  SQL.Clear;
                  SQL.Add('Select * From 設備信息');
                  Open;
             end;
        end
     else
        begin
             with Query1 do
             begin
                  close;
                  SQL.Clear;
                  SQL.Add('Select * From 設備信息');
                  SQL.Add('Where '+ComboBox1.Items[ComboBox1.ItemIndex]
                          +' Like '''+Edit1.Text+'%''');
                  Open;
             end;
        end;
     if comboBox2.Text='=' then
        begin
             with Query1 do
             begin
                  close;
                  SQL.Clear;
                  SQL.Add('Select * From 設備信息');
                  SQL.Add('Where '+ComboBox1.Items[ComboBox1.ItemIndex]
                          +' = '''+Edit1.Text+'''');
                  Open;
             end;
        end;
     if comboBox2.Text='>' then
        begin
             with Query1 do
             begin
                  close;
                  SQL.Clear;
                  SQL.Add('Select * From 設備信息');
                  SQL.Add('Where '+ComboBox1.Items[ComboBox1.ItemIndex]
                          +' > '''+Edit1.Text+'''');
                  Open;
             end;
        end;
     if comboBox2.Text='<' then
        begin
             with Query1 do
             begin
                  close;
                  SQL.Clear;
                  SQL.Add('Select * From 設備信息');
                  SQL.Add('Where '+ComboBox1.Items[ComboBox1.ItemIndex]
                          +' < '''+Edit1.Text+'''');
                  Open;
             end;
        end;
end;

procedure TXQSSCX.BitBtn1Click(Sender: TObject);
begin
     if Query1.ACTive then
     if Query1.RecordCount<>0 then
     if not Assigned(SSDJ) then
        begin
             SSDJ:=TSSDJ.Create(Self);
             SSDJ.ShowModal;
        end;
end;

end.