unit2.~pas

房产普查管理系统,对所管瞎的区域分类进行管理

unit Unit2;

interface

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

type
  TFgj = class(TForm)
    Edit2: TEdit;
    Edit3: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    StaticText1: TStaticText;
    StaticText2: TStaticText;
    StaticText3: TStaticText;
    StaticText4: TStaticText;
    ListBox1: TListBox;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    DBGrid1: TDBGrid;
    StaticText5: TStaticText;
    StaticText6: TStaticText;
    Bevel1: TBevel;
    Edit4: TEdit;
    StaticText7: TStaticText;
    StaticText8: TStaticText;
    ComboBox3: TComboBox;
    SpeedButton6: TSpeedButton;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure SpeedButton6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fgj: TFgj;
   i,j,n :integer;
 imagefile, s,str,mohu:string;

implementation

uses pucha, Unit1;

{$R *.dfm}

procedure TFgj.SpeedButton1Click(Sender: TObject);
begin
{if combobox2.Text='序号' then
listbox1.Items.Append('('+trim(combobox2.Text)+trim(edit2.Text)+trim(edit3.Text)+')'+trim(combobox1.Text))
else}

listbox1.Items.Append('('+trim(combobox2.Text)+trim(edit2.Text)+''''+trim(edit3.Text)+''')'+trim(combobox1.Text));
end;

procedure TFgj.SpeedButton2Click(Sender: TObject);
begin
if listbox1.ItemIndex<>-1 then
if listbox1.Selected[listbox1.ItemIndex] then
listbox1.DeleteSelected;
end;

procedure TFgj.SpeedButton3Click(Sender: TObject);
begin
listbox1.Clear;
end;

procedure TFgj.SpeedButton4Click(Sender: TObject);
begin

str:='';
i:=listbox1.Items.Count;
if i>0 then
begin
s:=listbox1.Items[i-1];
n:=length(s);
for j:=1 to n do
if copy(s,j,1)=')' then
begin
delete(s,j+1,n-j);
for j:=0 to i-2 do
str:=str+listbox1.Items[j];
str:=str+s;
dm.ADOQuery5.Close;
dm.ADOQuery5.SQL.Clear;
dm.ADOQuery5.SQL.Add('select * from 房屋表 where'+str);
dm.ADOQuery5.Open;
if dm.ADOQuery5.RecordCount<>0 then
begin
showmessage('查询完毕！');

end
else
begin
showmessage('没有符合条件的记录');

end;
end;
end;
end;

procedure TFgj.SpeedButton5Click(Sender: TObject);
begin
close;
end;

procedure TFgj.DBGrid1CellClick(Column: TColumn);
begin
close;
fmain.Panel1.Visible:=true;
fmain.Edit8.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('序号').AsString;
fmain.Edit1.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('房屋座落区').AsString;
fmain.Edit2.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('街').AsString;
fmain.Edit3.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('号').AsString;
fmain.Edit4.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('分类号').AsString;
fmain.Edit5.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('房号').AsString;
fmain.Edit6.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('所有权人').AsString;
fmain.Edit7.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('使用情况').AsString;
fmain.Edit9.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('使用面积').AsString;
fmain.Edit10.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('居住面积').AsString;
fmain.Edit11.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('人口').AsString;
fmain.Edit12.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('月租金').AsString;
fmain.Edit13.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('管理费').AsString;
fmain.Edit14.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('商网').AsString;
fmain.Edit15.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('普查员').AsString;
fmain.Edit16.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('复核人').AsString;
fmain.ComboBox1.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('产权类别').AsString;
fmain.Memo1.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('备注').AsString;
fmain.ComboBox2.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('厨房').AsString;
fmain.ComboBox3.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('厕所').AsString;
fmain.ComboBox4.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('洗澡设施').AsString;
fmain.ComboBox5.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('自来水').AsString;
fmain.ComboBox6.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('下水').AsString;
fmain.ComboBox7.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('煤气').AsString;
fmain.ComboBox8.Text:=dbgrid1.DataSource.DataSet.Fieldbyname('暖气').AsString;
fmain.DateTimePicker1.Date:=strtodatetime(dbgrid1.DataSource.DataSet.Fieldbyname('普查日期').AsString);
dm.ADOQuery2.Close;
dm.ADOQuery2.SQL.Clear;
dm.ADOQuery2.SQL.Add('select * from 家庭表 where 序号=:xuhao');
dm.ADOQuery2.Parameters.ParamValues['xuhao']:=trim(fmain.edit8.Text);
dm.ADOQuery2.Open;
dm.ADOQuery3.Close;
dm.ADOQuery3.SQL.Clear;
dm.ADOQuery3.SQL.Add('select * from 图片表 where 序号=:xuhao');
dm.ADOQuery3.Parameters.ParamValues['xuhao']:=trim(fmain.edit8.Text);
dm.ADOQuery3.Open;
 imagefile:=extractfilepath(application.ExeName)+'photo\'+dm.ADOQuery3.fieldbyname('序号').AsString+'.jpg';
 if fileexists(imagefile) then
 fmain.Image1.Picture.LoadFromFile(imagefile);
fmain.SpeedButton2.Enabled:=true;
fmain.SpeedButton3.Enabled:=true;
end;

procedure TFgj.SpeedButton6Click(Sender: TObject);
begin
mohu:=combobox3.Text;
dm.ADOQuery5.Close;
dm.ADOQuery5.SQL.Clear;
dm.ADOQuery5.SQL.Add('select * from 房屋表 where '+mohu+' like:hh');
dm.ADOQuery5.Parameters.ParamValues['hh']:='%'+edit4.Text+'%' ;
dm.ADOQuery5.Open;

end;

end.