📄 frmaddhouse.frm
字号:
VERSION 5.00
Begin VB.Form frmAddHouse
BorderStyle = 1 'Fixed Single
Caption = "添加房屋信息"
ClientHeight = 4260
ClientLeft = 45
ClientTop = 330
ClientWidth = 8025
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 4260
ScaleWidth = 8025
Begin VB.CommandButton cancelCommand
Caption = "关闭退出"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 4320
TabIndex = 13
Top = 3480
Width = 1215
End
Begin VB.CommandButton updateCommand
Caption = "保存记录"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 2040
TabIndex = 12
Top = 3480
Width = 1095
End
Begin VB.TextBox txtCurrentUser
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 1560
TabIndex = 10
Top = 1800
Width = 6195
End
Begin VB.TextBox txtHouseNO
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 1575
TabIndex = 4
Top = 510
Width = 2280
End
Begin VB.TextBox txtHouseType
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 5760
TabIndex = 3
Top = 480
Width = 1935
End
Begin VB.TextBox txtConstArea
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 1545
TabIndex = 2
Top = 1155
Width = 2295
End
Begin VB.TextBox txtComment
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 1560
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 1
Top = 2400
Width = 6225
End
Begin VB.TextBox TxtUseArea
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 5760
TabIndex = 0
Top = 1200
Width = 1935
End
Begin VB.Label Label3
Alignment = 2 'Center
Caption = "目前住户："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 0
TabIndex = 11
Top = 1785
Width = 1410
End
Begin VB.Label Label1
Alignment = 2 'Center
Caption = "房屋编号："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 9
Top = 510
Width = 1305
End
Begin VB.Label Label2
Alignment = 2 'Center
Caption = "房型："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4320
TabIndex = 8
Top = 510
Width = 1095
End
Begin VB.Label Label4
Alignment = 2 'Center
Caption = "居住面积："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4380
TabIndex = 7
Top = 1230
Width = 1410
End
Begin VB.Label Label5
Alignment = 2 'Center
Caption = "建筑面积："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 180
TabIndex = 6
Top = 1170
Width = 1215
End
Begin VB.Label Label9
Alignment = 2 'Center
Caption = "备注："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 0
TabIndex = 5
Top = 2400
Width = 1095
End
End
Attribute VB_Name = "frmAddHouse"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cancelCommand_Click()
Unload Me
End Sub
Private Sub updateCommand_Click()
Dim txtSQL As String
Dim MsgText As String
Dim mrcc As ADODB.Recordset
If Not Testtxt(txtHouseNO.Text) Then
MsgBox "请输入房屋编号！", vbOKOnly + vbExclamation, "警告"
txtHouseNO.SetFocus
Exit Sub
End If
If Not Testtxt(txtHouseType.Text) Then
MsgBox "请输入房型！", vbOKOnly + vbExclamation, "警告"
txtHouseType.SetFocus
Exit Sub
End If
If Not IsNumeric(txtConstArea.Text) Then
MsgBox "请输入建筑面积！", vbOKOnly + vbExclamation, "警告"
txtConstArea.SetFocus
Exit Sub
End If
If Not IsNumeric(TxtUseArea.Text) Then
MsgBox "请输入使用面积！", vbOKOnly + vbExclamation, "警告"
TxtUseArea.SetFocus
Exit Sub
End If
If Not Testtxt(txtCurrentUser.Text) Then
MsgBox "请输入当前住户！", vbOKOnly + vbExclamation, "警告"
txtCurrentUser.SetFocus
Exit Sub
End If
Dim tempHouse As clsHouse
Set tempHouse = New clsHouse
tempHouse.AddNew txtHouseNO.Text, txtHouseType.Text, Val(txtConstArea.Text), Val(TxtUseArea.Text), txtCurrentUser.Text, txtComment.Text
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -