realtye12b.pas

物业管理系统系统特点 一、 实现集中式管理 系统将集团公司、各分公司、各物业管理处连接到一起

unit RealtyE12B;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dbcgrids, Grids, DBGrids, DB, ADODB, StdCtrls, Buttons, ExtCtrls,
  StrUtils, ExtDlgs, ComCtrls, math, Menus, ImgList, ToolWin;

type
    Tf_RealtyE12B = class(TForm)
    L2: TLabel;
    Label1: TLabel;
    edit2: TEdit;
    Label4: TLabel;
    edit1: TEdit;
    Button1: TButton;
    Label2: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    Button2: TButton;
    Button5: TButton;
    Button7: TButton;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Edit5Exit(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
       bOK:bool;
       T:string;
  end;

var
  f_RealtyE12B: Tf_RealtyE12B;
  sNum:string;

implementation

uses data, main,RealtyE12,realtyC21,RealtyE11;

{$R *.dfm}


procedure Tf_RealtyE12B.FormCreate(Sender: TObject);
var
    query:TADOQuery;
    s1:string;
begin

    if f_RealtyE12.bnew=false then
    begin
        Query:=TADOQuery.Create(nil);
        Query.Connection:=DataModuleADO.ADOConnection1;

        edit1.text:=f_RealtyE12.ListView1.Selected.Caption;
        edit2.text:=f_RealtyE12.ListView1.Selected.SubItems[0];
        edit3.text:=f_RealtyE12.ListView1.Selected.SubItems[1];

        edit5.text:=f_RealtyE12.ListView1.Selected.SubItems[3];
        edit6.text:=f_RealtyE12.ListView1.Selected.SubItems[4];  
    end;
end;

//Tab
procedure Tf_RealtyE12B.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
    if key=13 then
        Begin
            key:=0;
            perform(WM_NEXTDLGCTL,0,0);
        end
    else if key=VK_ESCAPE then close;
end;

procedure Tf_RealtyE12B.Button2Click(Sender: TObject);
begin
    f_realtyC21:=Tf_realtyC21.Create(self);
    f_realtyC21.ToolButton1.Visible:=true;
    f_realtyC21.ShowModal;

    if  f_realtyC21.bOk=true then
    begin
        edit3.text:=f_realtyC21.snum;
    end;
end;

procedure Tf_RealtyE12B.ToolButton10Click(Sender: TObject);
begin
    close;
end;


procedure Tf_RealtyE12B.Button1Click(Sender: TObject);
var
    query,query1:TADOQuery;
    s,s1,s2,s3:string;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;
    Query1:=TADOQuery.Create(nil);
    Query1.Connection:=DataModuleADO.ADOConnection1;

    f_RealtyE11:=Tf_RealtyE11.Create(self);
    f_RealtyE11.Button10.Visible:=true;
    f_RealtyE11.Button5.Enabled:=false;
    f_RealtyE11.Button2.Enabled:=false;
    f_RealtyE11.Button7.Enabled:=false;

    f_RealtyE11.listview1.items.clear;

    s:='select * from 房间 where 可租='''+'Y'+''' and 是否已租='''+'N'+'''';
    query.SQL.Add(s);
    query.Open;
    while not query.Eof do
    begin
        query1.SQL.Clear;
        query1.SQL.Add('select * from 管理区 where 编号='''+query.fieldbyname('管理区').Value+'''');
        query1.Open;
        if query1.RecordCount>0 then  s1:=query.fieldbyname('名称').Value;

        query1.SQL.Clear;
        query1.SQL.Add('select * from 楼宇 where 编号='''+query.fieldbyname('楼宇').Value+'''');
        query1.Open;
        if query1.RecordCount>0 then s2:=query.fieldbyname('名称').Value;
        with f_RealtyE11.listview1.Items.Add do
        begin
            Caption:=Query.FieldByName('编号').Value;
            SubItems.Add(s1);
            SubItems.Add(s2);
            SubItems.Add(Query.FieldByName('单元号').Value);
            SubItems.Add(Query.FieldByName('楼层号').Value);
            SubItems.Add(Query.FieldByName('名称').Value);
            SubItems.Add(Query.FieldByName('房型').Value);
            SubItems.Add(Query.FieldByName('朝向').Value);
            SubItems.Add(Query.FieldByName('建筑面积').Value);
            SubItems.Add(Query.FieldByName('使用面积').Value);
            SubItems.Add(Query.FieldByName('装修情况').Value);
            SubItems.Add(Query.FieldByName('配套设施').Value);
            SubItems.Add(Query.FieldByName('权属类型').Value);

            SubItems.Add(Query.FieldByName('租赁单价').Value);
            SubItems.Add(Query.FieldByName('租赁金额').Value);
            SubItems.Add(Query.FieldByName('是否已租').Value);
            SubItems.Add(Query.FieldByName('可租').Value);
        end;
        query.next;
    end;
    if f_RealtyE11.listview1.Items.Count > 0 then f_RealtyE11.ListView1.Items.Item[0].Selected := True;

    f_RealtyE11.ShowModal;

    if  f_RealtyE11.bOk=true then
    begin
        edit1.Text:=f_RealtyE11.sNum+'--'+f_RealtyE11.sName;
        edit2.Text:=mainform.StdDou2(f_RealtyE11.ListView1.Selected.SubItems[7])
    end;

    query.Close;
    query.Free;
    query1.Close;
    query1.Free;


end;

procedure Tf_RealtyE12B.Edit5Exit(Sender: TObject);
begin
    edit5.Text:=mainform.StdDou2(edit5.text);
    edit2.Text:=mainform.StdDou2(edit2.text);
    edit6.Text:=floattostr(strtofloat(edit5.text)*strtofloat(edit2.text));
end;

procedure Tf_RealtyE12B.Button7Click(Sender: TObject);
var
    s1,s2:string;
begin
    if edit1.Text='' then
    begin
        showmessage('房间号不能为空');
        exit;
    end;

    s1:='-';
    s2:='-';

    if edit2.Text='' then edit2.Text:='0.00';
    if edit3.Text='' then edit3.Text:='-';
    if edit5.Text='' then edit5.Text:='0.00';
    if edit6.Text='' then edit6.Text:='0.00';



    if  f_RealtyE12.bnew=true then
    begin
        with f_RealtyE12.ListView1.Items.Add do
        begin
            caption:=mainform.getNum(edit1.Text);
            subitems.Add(mainform.StdDou2(edit2.text));
            subitems.Add(edit3.text);
            subitems.Add(mainform.StdDou2(edit5.text));
            subitems.Add(mainform.StdDou2(edit6.text));

        end;
        if f_RealtyE12.listview1.Items.Count>0 then f_RealtyE12.listview1.Items.Item[0].Selected:=true;

        edit2.Text:='';
        edit1.Text:='';
        edit3.Text:='';
        edit5.Text:='';
        edit6.Text:='';

    end;

    if  f_RealtyE12.bnew=false then
    begin
        with f_RealtyE12.ListView1.Selected do
        begin
            caption:=mainform.getNum(edit1.Text);
            subitems[0]:=mainform.StdDou2(Edit2.text);
            subitems[1]:=Edit3.text;
            subitems[2]:=mainform.StdDou2(edit5.text);
            subitems[3]:=mainform.StdDou2(edit6.text);
        end;
        close;
    end;

end;

procedure Tf_RealtyE12B.Button5Click(Sender: TObject);
begin
    close;
end;

end.