?? mc_fwczdj.~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('此房已經(jīng)在房源表中');
end
else
if Length(Table2.FieldByName('房主姓名').AsString)<>0 then
begin
if MessageDlg('此房屋已有戶主登記,是否為他辦理帶租手續(xù)?'
,mtCustom,[mbYes,mbNo],0)=mrYes then
begin
Query2.Append;
Query2.FieldByName('房間編號').AsString:=Table2.FieldByName('房間編號').AsString;
Query2.FieldByName('區(qū)名').AsString:=Table2.FieldByName('區(qū)名').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('權(quán)屬類型').AsString:=Table2.FieldByName('權(quán)屬類型').AsString;
Query2.FieldByName('朝向').AsString:=Table2.FieldByName('朝向').AsString;
Query2.FieldByName('房間類別').AsString:=Table2.FieldByName('房間類別').AsString;
Query2.FieldByName('配備設(shè)施').AsString:=Table2.FieldByName('配備設(shè)施').AsString;
Query2.FieldByName('房間結(jié)構(gòu)').AsString:=Table2.FieldByName('房間結(jié)構(gòu)').AsString;
Query2.FieldByName('用途').AsString:=Table2.FieldByName('用途').AsString;
Query2.FieldByName('建筑面積').AsFloat:=Table2.FieldByName('建筑面積').AsFloat;
Query2.FieldByName('使用面積').AsFloat:=Table2.FieldByName('使用面積').AsFloat;
Query2.FieldByName('公產(chǎn)面積').AsFloat:=Table2.FieldByName('公產(chǎn)面積').AsFloat;
Query2.FieldByName('私產(chǎn)面積').AsFloat:=Table2.FieldByName('私產(chǎn)面積').AsFloat;
Query2.Post;
Query2.Close;
Query2.Open;
Table2.Edit;
Table2.FieldByName('是否空閑').AsString:='帶租';
Table2.FieldByName('房屋狀態(tài)').AsString:='帶租中';
Table2.Post;
end;
end
else
if MessageDLg('是否將['+Query1.FieldByName('小區(qū)名').AsString+']['
+Table1.FieldByName('大樓名稱').AsString+']樓里的['
+Table2.FieldByName('房間號碼').AsString+']號房間添加到出租房源表中?'
,mtCustom,[mbYes,mbNo],0)=mrYes then
begin
Query2.Append;
Query2.FieldByName('房間編號').AsString:=Table2.FieldByName('房間編號').AsString;
Query2.FieldByName('區(qū)名').AsString:=Table2.FieldByName('區(qū)名').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('權(quán)屬類型').AsString:=Table2.FieldByName('權(quán)屬類型').AsString;
Query2.FieldByName('朝向').AsString:=Table2.FieldByName('朝向').AsString;
Query2.FieldByName('房間類別').AsString:=Table2.FieldByName('房間類別').AsString;
Query2.FieldByName('配備設(shè)施').AsString:=Table2.FieldByName('配備設(shè)施').AsString;
Query2.FieldByName('房間結(jié)構(gòu)').AsString:=Table2.FieldByName('房間結(jié)構(gòu)').AsString;
Query2.FieldByName('用途').AsString:=Table2.FieldByName('用途').AsString;
Query2.FieldByName('建筑面積').AsFloat:=Table2.FieldByName('建筑面積').AsFloat;
Query2.FieldByName('使用面積').AsFloat:=Table2.FieldByName('使用面積').AsFloat;
Query2.FieldByName('公產(chǎn)面積').AsFloat:=Table2.FieldByName('公產(chǎn)面積').AsFloat;
Query2.FieldByName('私產(chǎn)面積').AsFloat:=Table2.FieldByName('私產(chǎn)面積').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('是否結(jié)束['+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 房租費(fèi)用表 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('此房已經(jīng)出租,無法刪除.')
else
begin
if MessageDlg('是否刪除當(dāng)前房源信息?',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('此房已經(jīng)出租.');
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('使用選項(xiàng)','房屋出租登記',[loCaseInsensitive]) then
begin
if MainForm.Query1.FieldbyName('讀寫').AsString='讀' then
begin
BitBtn1.Enabled:=False;
BitBtn4.Enabled:=False;
end;
end;
end;
end.
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -