📄 frm_dl.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frm_dl
Caption = "大楼栋数设置"
ClientHeight = 3060
ClientLeft = 2790
ClientTop = 2700
ClientWidth = 6645
LinkTopic = "Form2"
MaxButton = 0 'False
ScaleHeight = 3060
ScaleWidth = 6645
Begin VB.Data Data2
Caption = "Data2"
Connect = "Access"
DatabaseName = "G:\zhkl\db_wyfy.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 4440
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "db_dl"
Top = 3840
Width = 1815
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "G:\zhkl\db_wyfy.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 960
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "db_xqmz"
Top = 3960
Width = 2775
End
Begin VB.Frame Frame3
Caption = "大楼编号"
Height = 975
Left = 480
TabIndex = 7
Top = 1800
Width = 6015
Begin MSComCtl2.UpDown UpDown2
Height = 375
Left = 4560
TabIndex = 14
Top = 360
Width = 255
_ExtentX = 450
_ExtentY = 661
_Version = 393216
Max = 100
Enabled = -1 'True
End
Begin MSComCtl2.UpDown UpDown1
Height = 375
Left = 2400
TabIndex = 13
Top = 360
Width = 255
_ExtentX = 450
_ExtentY = 661
_Version = 393216
Max = 100
Enabled = -1 'True
End
Begin VB.TextBox Text2
Height = 375
Left = 3240
TabIndex = 11
Top = 360
Width = 1575
End
Begin VB.TextBox Text1
Height = 375
Left = 1080
TabIndex = 9
Text = "1"
Top = 350
Width = 1575
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "至"
Height = 180
Left = 2880
TabIndex = 10
Top = 480
Width = 180
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "大楼编号："
Height = 180
Left = 120
TabIndex = 8
Top = 480
Width = 900
End
End
Begin VB.Frame Frame2
Height = 735
Left = 3480
TabIndex = 4
Top = 720
Width = 3000
Begin VB.CommandButton Command2
Caption = "返回主系统"
Height = 495
Left = 1560
TabIndex = 6
Top = 160
Width = 1335
End
Begin VB.CommandButton Command1
Caption = "开始生成系统"
Height = 495
Left = 120
TabIndex = 5
Top = 160
Width = 1335
End
End
Begin VB.Frame Frame1
Caption = "选择小区"
Height = 735
Left = 480
TabIndex = 1
Top = 720
Width = 2655
Begin VB.ComboBox Combo1
Height = 300
Left = 1200
TabIndex = 3
Top = 300
Width = 1335
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "小区名称："
Height = 180
Left = 240
TabIndex = 2
Top = 360
Width = 900
End
End
Begin VB.Label Label5
Caption = "Label5"
DataField = "小区名称"
DataSource = "Data1"
Height = 375
Left = 5400
TabIndex = 12
Top = 4560
Width = 1215
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "大楼栋数设置"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 2640
TabIndex = 0
Top = 240
Width = 1530
End
End
Attribute VB_Name = "frm_dl"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
If Text1.Text = "" Or Text2.Text = "" Or Combo1.Text = "" Then
MsgBox "你添的信息不完整，请将信息补充完整", 48, "提示"
Exit Sub
End If
Dim a, b As Integer
Dim l As String
b = Val(Text2.Text)
For a = Val(Text1.Text) To b
Data2.Refresh
If Data2.Recordset.RecordCount > 0 Then
Data2.Recordset.MoveFirst
Do While Data2.Recordset.EOF = False
If Data2.Recordset.Fields("大楼名称") = Trim(Combo1.Text + Trim(Str(a)) + "栋") Then
GoTo l:
Else
Data2.Recordset.MoveNext
End If
Loop
Set adors = cn.Execute("insert into db_dl(小区名称,大楼名称,大楼编号) values( '" & Trim(Combo1) & " ','" & Trim(Combo1 + Trim(Str(a)) + "栋") & "','" & Trim(Str(a)) & "')")
Else
Set adors = cn.Execute("insert into db_dl(小区名称,大楼名称,大楼编号) values( '" & Trim(Combo1) & " ','" & Trim(Combo1 + Trim(Str(a)) + "栋") & "','" & Trim(Str(a)) & "')")
End If
l:
Next a
MsgBox "数据保存成功", 32, "大楼栋数登记"
Data2.Refresh
End Sub
Private Sub Command2_Click()
Form1.Show
Unload Me
End Sub
Private Sub Form_Load()
Data1.Refresh
Data1.Recordset.MoveFirst
Do While Data1.Recordset.EOF = False
Combo1.AddItem Label5.Caption
Data1.Recordset.MoveNext
Loop
End Sub
Private Sub UpDown1_Change()
Text1.Text = UpDown1.Value
End Sub
Private Sub UpDown2_Change()
Text2.Text = UpDown2.Value
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -