📄 frmuserwatermeterdatarecord_select.frm
字号:
VERSION 5.00
Object = "{F0D2F211-CCB0-11D0-A316-00AA00688B10}#1.0#0"; "MSDATLST.OCX"
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Begin VB.Form frmUserWaterMeterDataRecord_Select
BorderStyle = 1 'Fixed Single
Caption = "抄表数据查询条件选择"
ClientHeight = 2775
ClientLeft = 45
ClientTop = 330
ClientWidth = 7200
Icon = "frmUserWaterMeterDataRecord_Select.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 2775
ScaleWidth = 7200
StartUpPosition = 1 '所有者中心
Begin VB.Frame Frame1
Caption = "用户"
Height = 1170
Left = 150
TabIndex = 12
Top = 900
Width = 6825
Begin VB.TextBox txtUName
Enabled = 0 'False
Height = 345
Left = 3840
TabIndex = 13
Top = 645
Width = 2865
End
Begin VB.TextBox txtUID
Enabled = 0 'False
Height = 345
Left = 1215
TabIndex = 8
Top = 645
Width = 1365
End
Begin VB.CheckBox chkPQ
Height = 210
Index = 0
Left = 255
TabIndex = 3
Top = 285
Width = 225
End
Begin VB.CheckBox chkPQ
Enabled = 0 'False
Height = 210
Index = 1
Left = 2850
TabIndex = 5
Top = 285
Width = 225
End
Begin VB.CheckBox chkUser
Height = 225
Left = 255
TabIndex = 7
Top = 705
Width = 240
End
Begin MSDataListLib.DataCombo cboP
Height = 330
Left = 1200
TabIndex = 4
Top = 225
Width = 1380
_ExtentX = 2434
_ExtentY = 582
_Version = 393216
Enabled = 0 'False
Style = 2
Text = ""
End
Begin MSDataListLib.DataCombo cboQ
Height = 330
Left = 3840
TabIndex = 6
Top = 225
Width = 1380
_ExtentX = 2434
_ExtentY = 582
_Version = 393216
Enabled = 0 'False
Style = 2
Text = ""
End
Begin VB.Label lblUserName
Caption = "用户名："
Height = 195
Left = 3090
TabIndex = 17
Top = 720
Width = 735
End
Begin VB.Label lblPID
Caption = "片区："
Height = 195
Left = 495
TabIndex = 16
Top = 300
Width = 555
End
Begin VB.Label lblQID
Caption = "小区："
Height = 195
Left = 3255
TabIndex = 15
Top = 285
Width = 555
End
Begin VB.Label lblUserID
Caption = "用户号："
Height = 195
Left = 495
TabIndex = 14
Top = 735
Width = 1470
End
End
Begin VB.CommandButton cmdOK
Caption = "确定"
Height = 375
Left = 180
TabIndex = 0
Top = 2295
Width = 960
End
Begin VB.Frame Frame2
Caption = "时段"
Height = 750
Left = 150
TabIndex = 9
Top = 90
Width = 6825
Begin VB.ComboBox cboMonth
Height = 300
ItemData = "frmUserWaterMeterDataRecord_Select.frx":0442
Left = 1530
List = "frmUserWaterMeterDataRecord_Select.frx":0444
Style = 2 'Dropdown List
TabIndex = 2
Top = 240
Width = 990
End
Begin MSMask.MaskEdBox txtYear
Height = 300
Left = 345
TabIndex = 1
Top = 240
Width = 885
_ExtentX = 1561
_ExtentY = 529
_Version = 393216
MaxLength = 4
Mask = "9999"
PromptChar = " "
End
Begin VB.Label Label2
Caption = "年"
Height = 210
Left = 1320
TabIndex = 11
Top = 315
Width = 225
End
Begin VB.Label Label1
Caption = "月份"
Height = 210
Left = 2535
TabIndex = 10
Top = 330
Width = 480
End
End
Begin VB.Line Line1
BorderColor = &H80000003&
Index = 1
X1 = 75
X2 = 7050
Y1 = 2160
Y2 = 2160
End
Begin VB.Line Line1
BorderColor = &H80000005&
Index = 0
X1 = 75
X2 = 7080
Y1 = 2175
Y2 = 2175
End
End
Attribute VB_Name = "frmUserWaterMeterDataRecord_Select"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public strReturnYear As String '返回值-用水时段年
Public strReturnMonth As String '返回值-用水时段月
Public strReturnPID As String '返回值-片号
Public strReturnQID As String '返回值-区号
Public strReturnPName As String '返回值-片名
Public strReturnQName As String '返回值-区名
Public strReturnUID As String '返回值-用户号
Dim adoPRS As ADODB.Recordset
Dim adoQRS As ADODB.Recordset
Private Sub cmdCancle_Click()
Unload Me
End Sub
Private Sub cmdOK_Click()
'时段
strReturnYear = Trim(Str(Me.txtYear.Text))
strReturnMonth = Me.cboMonth.Text
'用户
If Me.chkPQ(0).value = 1 And Trim(Me.cboP.Text) <> "" Then
strReturnPID = Me.cboP.BoundText
strReturnPName = Trim(Me.cboP.Text)
End If
If Me.chkPQ(1).value = 1 And Trim(Me.cboQ.Text) <> "" Then
strReturnQID = Me.cboQ.BoundText
strReturnQName = Trim(Me.cboQ.Text)
End If
If Me.chkUser.value = 1 And Trim(Me.txtUID.Text) <> "" Then
strReturnUID = Trim(Me.txtUID.Text)
End If
Unload Me
End Sub
Private Sub Form_Load()
txtYear.Text = Year(Date)
cboMonth.AddItem ("01")
cboMonth.AddItem ("02")
cboMonth.AddItem ("03")
cboMonth.AddItem ("04")
cboMonth.AddItem ("05")
cboMonth.AddItem ("06")
cboMonth.AddItem ("07")
cboMonth.AddItem ("08")
cboMonth.AddItem ("09")
cboMonth.AddItem ("10")
cboMonth.AddItem ("11")
cboMonth.AddItem ("12")
cboMonth.ListIndex = Month(Date) - 1
strReturnYear = Trim(Str(Year(Date)))
strReturnMonth = Me.cboMonth.Text
'初始化其它返回值
strReturnPID = ""
strReturnQID = ""
strReturnPName = ""
strReturnQName = ""
strReturnUID = ""
'设置关键控件属性
Me.txtUID.MaxLength = gUIDLen
'初始化记录集
On Error GoTo errHandleOpen
Set adoPRS = New ADODB.Recordset
Set adoPRS.ActiveConnection = gConnect
adoPRS.CursorLocation = adUseClient
adoPRS.CursorType = adOpenForwardOnly
adoPRS.LockType = adLockOptimistic
adoPRS.Open "select PID,PName from Pian"
Set adoQRS = New ADODB.Recordset
Set adoQRS.ActiveConnection = gConnect
adoQRS.CursorLocation = adUseClient
adoQRS.CursorType = adOpenForwardOnly
adoQRS.LockType = adLockOptimistic
On Error GoTo 0
Me.cboP.ListField = "PName"
Me.cboP.BoundColumn = "PID"
Exit Sub
'-------错误处理---------
errHandleOpen:
Warning "记录集创建失败！" & Chr(13) & Err.Description
On Error GoTo 0
Exit Sub
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
adoPRS.Close
adoQRS.Close
Set adoPRS = Nothing
Set adoQRS = Nothing
On Error GoTo 0
End Sub
Private Sub txtYear_GotFocus()
Call AutoSelectText(txtYear)
End Sub
Private Sub txtYear_KeyPress(KeyAscii As Integer)
Call IfEnterKeyMoveNext(KeyAscii)
End Sub
Private Sub txtYear_LostFocus()
If Me.txtYear.Text < 1000 Or Me.txtYear.Text > 9999 Then
Warning "日期格式输入错误!!!"
Me.txtYear.SetFocus
Exit Sub
End If
End Sub
Private Sub cmbMonth_KeyPress(KeyAscii As Integer)
Call IfEnterKeyMoveNext(KeyAscii)
End Sub
Private Sub FillP()
Set Me.cboP.RowSource = adoPRS
Me.cboP.Text = ""
End Sub
Private Sub ClearP()
Set Me.cboP.RowSource = Nothing
Me.cboP.Text = ""
End Sub
Private Sub FillQ(ByVal strPID As String)
On Error Resume Next
adoQRS.Close
On Error GoTo 0
On Error GoTo errHandleOpen
adoQRS.Open "select QID,QName from Qu where PID='" & Trim(strPID) & "'"
On Error GoTo 0
Set Me.cboQ.RowSource = adoQRS
Me.cboQ.ListField = "QName"
Me.cboQ.BoundColumn = "QID"
Me.cboQ.Text = ""
Exit Sub
'-------错误处理---------
errHandleOpen:
Warning "记录集打开失败！" & Chr(13) & Err.Description
On Error GoTo 0
Exit Sub
End Sub
Private Sub ClearQ()
Set Me.cboQ.RowSource = Nothing
Me.cboQ.Text = ""
End Sub
Private Sub chkPQ_Click(Index As Integer)
Select Case Index
Case 0 '片
If Me.chkPQ(0).value = 0 Then
Call ClearP
Me.cboP.Enabled = False
Me.chkPQ(1).value = 0
Me.chkPQ(1).Enabled = False
Else
Call FillP
Me.cboP.Enabled = True
Me.chkPQ(1).Enabled = True
Me.chkUser.value = 0
Me.cboP.SetFocus
End If
Case 1 '区
If Me.chkPQ(1).value = 0 Then
Call ClearQ
Me.cboQ.Enabled = False
Else
Call FillQ(Me.cboP.BoundText)
Me.cboQ.Enabled = True
End If
End Select
End Sub
Private Sub chkUser_Click()
If Me.chkUser.value = 0 Then
Me.txtUID.Text = ""
Me.txtUName.Text = ""
Me.txtUID.Enabled = False
Else
chkPQ(0).value = 0
Me.txtUID.Enabled = True
Me.txtUID.SetFocus
End If
End Sub
Private Sub cboP_LostFocus()
If Trim(Me.cboP.Text) = "" Then
Exit Sub
End If
If Me.chkPQ(1).value = 1 Then
Call FillQ(Me.cboP.BoundText)
End If
End Sub
Private Sub cboQ_KeyPress(KeyAscii As Integer)
Call IfEnterKeyMoveNext(KeyAscii)
End Sub
Private Sub cboSQ_KeyPress(KeyAscii As Integer)
Call IfEnterKeyMoveNext(KeyAscii)
End Sub
Private Sub txtUID_GotFocus()
Call AutoSelectText(txtUID)
End Sub
Private Sub txtUID_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
KeyAscii = 0
SendKeys "{tab}"
End If
End Sub
Private Sub cboP_KeyPress(KeyAscii As Integer)
Call IfEnterKeyMoveNext(KeyAscii)
End Sub
Private Sub cboP_Change()
Me.cboQ.Text = ""
End Sub
Private Sub txtUID_LostFocus()
Dim strSQL As String
Dim adoTmpRS As ADODB.Recordset
If Trim(Me.txtUID.Text) = "" Then
Me.txtUName.Text = ""
Exit Sub
End If
Me.txtUID.Text = String(gUIDLen - Len(Trim(Me.txtUID.Text)), "0") & Trim(Me.txtUID.Text)
strSQL = "select UID,UName from UserRecord where UID='" & Trim(Me.txtUID.Text) & "' and Status='1'" '从正常用户中查找
On Error GoTo ErrHandleExe
Set adoTmpRS = gConnect.Execute(strSQL)
On Error GoTo 0
If adoTmpRS.EOF And adoTmpRS.BOF Then
Me.txtUName.Text = ""
Warning "用户号无效！！！"
Me.txtUID.SetFocus
Else
Me.txtUName.Text = Trim(adoTmpRS.Fields("UName"))
End If
On Error Resume Next
adoTmpRS.Close
Set adoTmpRS = Nothing
On Error GoTo 0
Exit Sub
'-------错误处理---------
ErrHandleExe:
On Error GoTo 0
Me.txtUID.Text = ""
Me.txtUName.Text = ""
Warning "用户查找失败！" & Chr(13) & Err.Description
On Error Resume Next
adoTmpRS.Close
Set adoTmpRS = Nothing
On Error GoTo 0
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -