realtye15ab.pas

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

unit RealtyE15AB;

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_RealtyE15AB = class(TForm)
    L2: TLabel;
    Label1: TLabel;
    edit2: TEdit;
    Label4: TLabel;
    edit1: TEdit;
    Button1: TButton;
    Label2: TLabel;
    Edit3: TEdit;
    Label3: TLabel;
    Label5: TLabel;
    Edit5: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Edit9: TEdit;
    Label10: TLabel;
    Edit10: TEdit;
    Label11: TLabel;
    Label12: TLabel;
    edit12: TDateTimePicker;
    edit8: TComboBox;
    edit11: TComboBox;
    Button2: TButton;
    Button5: TButton;
    Button7: TButton;
    edit7: TDateTimePicker;
    edit4: TComboBox;
    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);
    procedure Edit10Exit(Sender: TObject);
    procedure Edit9Exit(Sender: TObject);

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

var
  f_RealtyE15AB: Tf_RealtyE15AB;
  sNum:string;

implementation

uses data, main,RealtyE15A,realtyC21,RealtyE11;

{$R *.dfm}


procedure Tf_RealtyE15AB.FormCreate(Sender: TObject);
var
    query:TADOQuery;
    s1:string;
begin
    edit8.Items.Add('年');
    edit8.Items.Add('月');
    edit8.Items.Add('日');

    edit11.Items.Add('年');
    edit11.Items.Add('月');
    edit11.Items.Add('日');

    if f_RealtyE15A.bnew=true then
    begin
        edit12.Date:=date;
        edit7.date:=Date;
    end;

    if f_RealtyE15A.bnew=false then
    begin
        edit4.Enabled:=true;
        Query:=TADOQuery.Create(nil);
        Query.Connection:=DataModuleADO.ADOConnection1;

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

        query.SQL.Clear;
        query.SQL.Add('select * from 房间 where 编号='''+mainform.getNum(edit1.text)+'''');
        query.Open;
        if query.RecordCount>0 then
        begin
            s1:=query.fieldbyname('管理区').value;
        end;

        query.SQL.Clear;
        query.SQL.Add('select * from 收费标准 where 管理区='''+s1+'''');
        query.open;
        while not query.Eof do
        begin
            edit4.Items.Add(query.fieldbyname('名称').value);
            query.Next;
        end;
        query.Close;
        query.Free;

        edit4.ItemIndex:=edit4.Items.IndexOf(f_RealtyE15A.ListView1.Selected.SubItems[2]);
        edit5.text:=f_RealtyE15A.ListView1.Selected.SubItems[3];
        edit6.text:=f_RealtyE15A.ListView1.Selected.SubItems[4];
        edit7.date:=strtodate(f_RealtyE15A.ListView1.Selected.SubItems[5]);
        edit8.ItemIndex:=edit8.Items.IndexOf(f_RealtyE15A.ListView1.Selected.SubItems[6]);
        edit9.text:=f_RealtyE15A.ListView1.Selected.SubItems[7];
        edit10.text:=f_RealtyE15A.ListView1.Selected.SubItems[8];
        edit11.ItemIndex:=edit8.Items.IndexOf(f_RealtyE15A.ListView1.Selected.SubItems[9]);
        edit12.date:=strtodate(f_RealtyE15A.ListView1.Selected.SubItems[10]);
    end;
end;

//Tab
procedure Tf_RealtyE15AB.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_RealtyE15AB.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_RealtyE15AB.ToolButton10Click(Sender: TObject);
begin
    close;
end;


procedure Tf_RealtyE15AB.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.Button8.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;

    edit4.Enabled:=true;
    query.SQL.Clear;
    query.SQL.Add('select * from 房间 where 编号='''+mainform.getNum(edit1.text)+'''');
    query.Open;
    if query.RecordCount>0 then
    begin
        s3:=query.fieldbyname('管理区').value;

    end;
    query.SQL.Clear;
    query.SQL.Add('select * from 收费标准 where 管理区='''+s3+'''');
    query.open;
    while not query.Eof do
    begin
        edit4.Items.Add(query.fieldbyname('名称').value);
        query.Next;
    end;
    query.Close;
    query.Free;
    query1.Close;
    query1.Free;


end;

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

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

    s1:='-';
    s2:='-';
    if edit8.Text<>'' then s1:=edit8.Text;
    if edit11.Text<>'' then s2:=edit11.Text;
    if edit2.Text='' then edit2.Text:='0.00';
    if edit3.Text='' then edit3.Text:='-';
    if edit4.Text='' then edit4.Text:='-';
    if edit5.Text='' then edit5.Text:='0.00';
    if edit6.Text='' then edit6.Text:='0.00';
    if edit9.Text='' then edit9.Text:='0.00';
    if edit10.Text='' then edit10.Text:='0';


    if  f_RealtyE15A.bnew=true then
    begin
        with f_RealtyE15A.ListView1.Items.Add do
        begin
            caption:=mainform.getNum(edit1.Text);
            subitems.Add(mainform.StdDou2(edit2.text));
            subitems.Add(edit3.text);
            subitems.Add(edit4.text);
            subitems.Add(mainform.StdDou2(edit5.text));
            subitems.Add(mainform.StdDou2(edit6.text));
            subitems.Add(datetostr(edit7.date));
            subitems.Add(s1);
            subitems.Add(edit9.text);
            subitems.Add(edit10.text);
            subitems.Add(s2);
            subitems.Add(datetostr(edit12.DATE));
        end;
        if f_RealtyE15A.listview1.Items.Count>0 then f_RealtyE15A.listview1.Items.Item[0].Selected:=true;

        edit2.Text:='';
        edit1.Text:='';
        edit3.Text:='';
        edit4.Text:='';
        edit5.Text:='';
        edit6.Text:='';
        edit7.date:=date;
        edit8.ItemIndex:=edit8.Items.IndexOf('');
        edit9.Text:='';
        edit10.Text:='';
        edit11.ItemIndex:=edit11.Items.IndexOf('');
        edit12.Date:=date;
    end;

    if  f_RealtyE15A.bnew=false then
    begin
        with f_RealtyE15A.ListView1.Selected do
        begin
            caption:=mainform.getNum(edit1.Text);
            subitems[0]:=mainform.StdDou2(Edit2.text);
            subitems[1]:=Edit3.text;
            subitems[2]:=edit4.text;
            subitems[3]:=mainform.StdDou2(edit5.text);
            subitems[4]:=mainform.StdDou2(edit6.text);
            subitems[5]:=datetostr(edit7.date);
            subitems[6]:=s1;
            subitems[7]:=Edit9.text;
            subitems[8]:=Edit10.text;
            subitems[9]:=s2;
            subitems[10]:=datetostr(Edit12.date);
        end;
        close;
    end;

end;

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

procedure Tf_RealtyE15AB.Edit10Exit(Sender: TObject);
begin
    edit10.Text:=mainform.StdInt(edit10.Text);
end;

procedure Tf_RealtyE15AB.Edit9Exit(Sender: TObject);
begin
    edit9.Text:=mainform.StdDou2(edit9.Text);
end;

end.