⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 mc_fwczdj.pas

📁 1、系统环境要求：所有程序均在Windows98/XP操作系统下测试运行。 2、建议用户在系统上安装DELPHI7.0企业版。 3、如果数据库为SQL Server数据库
💻 PAS
字号:
🔍 
unit MC_FWCZDJ;

interface

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

type
  TFWCZDJ = class(TForm)
    GroupBox1: TGroupBox;
    DBLookupComboBox1: TDBLookupComboBox;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    GroupBox3: TGroupBox;
    DBGrid2: TDBGrid;
    DataSource1: TDataSource;
    Query1: TQuery;
    Query1BDEDesigner: TStringField;
    Query1BDEDesigner2: TStringField;
    DataSource2: TDataSource;
    Table1: TTable;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner7: TStringField;
    Table2: TTable;
    Table2BDEDesigner: TStringField;
    Table2BDEDesigner2: TStringField;
    Table2BDEDesigner3: TStringField;
    Table2BDEDesigner4: TStringField;
    Table2BDEDesigner6: TStringField;
    Table2BDEDesigner18: TStringField;
    DataSource3: TDataSource;
    GroupBox4: TGroupBox;
    DBGrid3: TDBGrid;
    Query2: TQuery;
    DataSource4: TDataSource;
    Query2BDEDesigner: TStringField;
    Query2BDEDesigner2: TStringField;
    Query2BDEDesigner3: TStringField;
    Query2BDEDesigner4: TStringField;
    Query2BDEDesigner5: TStringField;
    Query2BDEDesigner6: TStringField;
    Query2BDEDesigner7: TStringField;
    Query2BDEDesigner8: TStringField;
    Query2BDEDesigner9: TStringField;
    Query2BDEDesigner10: TStringField;
    Query2BDEDesigner11: TStringField;
    Query2BDEDesigner12: TStringField;
    Query2BDEDesigner13: TStringField;
    Query2BDEDesigner14: TStringField;
    Query2BDEDesigner15: TFloatField;
    Query2BDEDesigner16: TFloatField;
    Query2BDEDesigner17: TFloatField;
    Query2BDEDesigner18: TFloatField;
    Query2BDEDesigner19: TStringField;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    Query3: TQuery;
    Table2BDEDesigner5: TStringField;
    Table2BDEDesigner7: TStringField;
    Table2BDEDesigner8: TStringField;
    Table2BDEDesigner9: TStringField;
    Table2BDEDesigner10: TStringField;
    Table2BDEDesigner11: TStringField;
    Table2BDEDesigner12: TStringField;
    Table2BDEDesigner13: TStringField;
    Table2BDEDesigner14: TFloatField;
    Table2BDEDesigner15: TFloatField;
    Table2BDEDesigner16: TFloatField;
    Table2BDEDesigner17: TFloatField;
    SpeedButton1: TSpeedButton;
    Edit1: TEdit;
    BitBtn5: TBitBtn;
    Table2BDEDesigner19: TStringField;
    Table2BDEDesigner20: TStringField;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FWCZDJ: TFWCZDJ;

implementation

uses MC_ZFDJ, MC_MainForm;

{$R *.DFM}

procedure TFWCZDJ.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     FWCZDJ.Release;
     FWCZDJ:=Nil;
end;

procedure TFWCZDJ.BitBtn1Click(Sender: TObject);
begin
     if Table2.RecordCount<>0 then
     if Query2.Locate('房间编号',Table2.FieldByName('房间编号').AsString,[loPartialKey]) then
        begin
             ShowMessage('此房已经在房源表中');
        end
     else
     if Length(Table2.FieldByName('房主姓名').AsString)<>0 then
        begin
         if MessageDlg('此房屋已有户主登记,是否为他办理带租手续?'
            ,mtCustom,[mbYes,mbNo],0)=mrYes then
            begin
                 Query2.Append;
                 Query2.FieldByName('房间编号').AsString:=Table2.FieldByName('房间编号').AsString;
                 Query2.FieldByName('区名').AsString:=Table2.FieldByName('区名').AsString;
                 Query2.FieldByName('大楼名').AsString:=Table2.FieldByName('大楼名').AsString;
                 Query2.FieldByName('房间号码').AsString:=Table2.FieldByName('房间号码').AsString;
                 Query2.FieldByName('房主代号').AsString:=Table2.FieldByName('房主代号').AsString;
                 Query2.FieldByName('房主姓名').AsString:=Table2.FieldByName('房主姓名').AsString;
                 Query2.FieldByName('权属类型').AsString:=Table2.FieldByName('权属类型').AsString;
                 Query2.FieldByName('朝向').AsString:=Table2.FieldByName('朝向').AsString;
                 Query2.FieldByName('房间类别').AsString:=Table2.FieldByName('房间类别').AsString;
                 Query2.FieldByName('配备设施').AsString:=Table2.FieldByName('配备设施').AsString;
                 Query2.FieldByName('房间结构').AsString:=Table2.FieldByName('房间结构').AsString;
                 Query2.FieldByName('用途').AsString:=Table2.FieldByName('用途').AsString;
                 Query2.FieldByName('建筑面积').AsFloat:=Table2.FieldByName('建筑面积').AsFloat;
                 Query2.FieldByName('使用面积').AsFloat:=Table2.FieldByName('使用面积').AsFloat;
                 Query2.FieldByName('公产面积').AsFloat:=Table2.FieldByName('公产面积').AsFloat;
                 Query2.FieldByName('私产面积').AsFloat:=Table2.FieldByName('私产面积').AsFloat;
                 Query2.Post;
                 Query2.Close;
                 Query2.Open;
                 Table2.Edit;
                 Table2.FieldByName('是否空闲').AsString:='带租';
                 Table2.FieldByName('房屋状态').AsString:='带租中';                 
                 Table2.Post;
            end;
         end
     else
     if MessageDLg('是否将['+Query1.FieldByName('小区名').AsString+']['
        +Table1.FieldByName('大楼名称').AsString+']楼里的['
        +Table2.FieldByName('房间号码').AsString+']号房间添加到出租房源表中?'
        ,mtCustom,[mbYes,mbNo],0)=mrYes then
        begin
             Query2.Append;
             Query2.FieldByName('房间编号').AsString:=Table2.FieldByName('房间编号').AsString;
             Query2.FieldByName('区名').AsString:=Table2.FieldByName('区名').AsString;
             Query2.FieldByName('大楼名').AsString:=Table2.FieldByName('大楼名').AsString;
             Query2.FieldByName('房间号码').AsString:=Table2.FieldByName('房间号码').AsString;
             Query2.FieldByName('房主代号').AsString:=Table2.FieldByName('房主代号').AsString;
             Query2.FieldByName('房主姓名').AsString:=Table2.FieldByName('房主姓名').AsString;
             Query2.FieldByName('权属类型').AsString:=Table2.FieldByName('权属类型').AsString;
             Query2.FieldByName('朝向').AsString:=Table2.FieldByName('朝向').AsString;
             Query2.FieldByName('房间类别').AsString:=Table2.FieldByName('房间类别').AsString;
             Query2.FieldByName('配备设施').AsString:=Table2.FieldByName('配备设施').AsString;
             Query2.FieldByName('房间结构').AsString:=Table2.FieldByName('房间结构').AsString;
             Query2.FieldByName('用途').AsString:=Table2.FieldByName('用途').AsString;
             Query2.FieldByName('建筑面积').AsFloat:=Table2.FieldByName('建筑面积').AsFloat;
             Query2.FieldByName('使用面积').AsFloat:=Table2.FieldByName('使用面积').AsFloat;
             Query2.FieldByName('公产面积').AsFloat:=Table2.FieldByName('公产面积').AsFloat;
             Query2.FieldByName('私产面积').AsFloat:=Table2.FieldByName('私产面积').AsFloat;
             Query2.Post;
                 Query2.Close;
                 Query2.Open;
             Table2.Edit;
             Table2.FieldByName('是否空闲').AsString:='出租';
             Table2.FieldByName('是否空闲').AsString:='出租中';             
             Table2.Post;
        end;
end;

procedure TFWCZDJ.BitBtn3Click(Sender: TObject);
begin
    if Query2.RecordCount<>0 then
    if Query2.FieldByName('承租人姓名').AsString<>'' then
    if MessageDlg('是否结束['+Query2.FieldbyName('承租人姓名').AsString
       +']的租房约定?',mtCustom,[mbYes,mbNO],0)=mrYes then
       begin
            Query2.Edit;
            Query2.FieldByName('承租人姓名').AsString:='';
            Query2.FieldByName('是否空闲').AsString:='空闲';
            Query2.Post;
            Query3.Close;
            Query3.SQL.Clear;
            Query3.SQL.add('Delete 房租费用表 Where 房间代号=:A');
            Query3.ParamByName('A').AsString:=Query2.FieldByName('房间编号').AsSTring;
            Query3.ExecSQL;
       end;
end;

procedure TFWCZDJ.BitBtn4Click(Sender: TObject);
var a: String;
begin
    if Query2.RecordCount<>0 then
    if Length(Query2.FieldByName('承租人姓名').AsString)<>0 then
       showMessage('此房已经出租,无法删除.')
    else
       begin
            if MessageDlg('是否删除当前房源信息?',mtCustom,[mbYes,mbNo],0)=mrYes then
               begin
                            Query3.Close;
                            Query3.SQL.Clear;
                            Query3.SQL.Add('Select 房主姓名 From 房屋信息表 where 房间编号=:B');
                            Query3.ParamByName('b').AsString:=Query2.FieldByName('房间编号').AsString;
                            Query3.Open;
                            a:=Query3.FieldByName('房主姓名').AsString;
                            Query3.Close;
                            Query3.SQL.Clear;
                            if Length(a)<>0 then
                            begin
                                 Query3.SQL.Add('update 房屋信息表 Set 是否空闲=:A Where 房间编号=:B');
                                 Query3.ParamByName('A').AsString:='居住';
                                 Query3.ParamByName('b').AsString:=Query2.FieldByName('房间编号').AsString;
                                 Query3.ExecSQL;
                            end
                            else
                            begin
                                 Query3.SQL.Add('update 房屋信息表 Set 是否空闲=:A Where 房间编号=:B');
                                 Query3.ParamByName('A').AsString:='空闲';
                                 Query3.ParamByName('b').AsString:=Query2.FieldByName('房间编号').AsString;
                                 Query3.ExecSQL;
                            end;
                                 Query2.Delete;
                            Table2.Refresh;
               end;
       end;
end;

procedure TFWCZDJ.BitBtn2Click(Sender: TObject);
begin
     if Query2.RecordCount<>0 then
     if Query2.FieldByName('是否空闲').AsString='出租' then
        begin
             ShowMessage('此房已经出租.');
        end
     else
        begin
             if Not Assigned(ZFDJ) then
                begin
                     ZFDJ:=TZFDJ.Create(Self);
                     ZFDJ.Label2.Caption:=Query2.FieldByName('房间编号').AsString;
                     ZFDJ.ComboBox1.ItemIndex:=0;
                     ZFDJ.ShowModal;
                end;
        end;
end;

procedure TFWCZDJ.SpeedButton1Click(Sender: TObject);
begin
     if Length(Edit1.Text)<>0 then
     if Not Table2.Locate('房间编号',Edit1.Text,[loPartialKey]) then
        ShowMessage('对不起，没有找到？');
end;

procedure TFWCZDJ.BitBtn5Click(Sender: TObject);
begin
     Close;
end;

procedure TFWCZDJ.FormShow(Sender: TObject);
begin
     if MainForm.Query1.Locate('使用选项','房屋出租登记',[loCaseInsensitive]) then
        begin
             if MainForm.Query1.FieldbyName('读写').AsString='读' then
                begin
                     BitBtn1.Enabled:=False;
                     BitBtn4.Enabled:=False;
                end;
        end;
end;

end.

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -