📄 frmwaterraterequisition_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 frmWaterrateRequisition_Select
BorderStyle = 1 'Fixed Single
Caption = "水费通知单查询选择"
ClientHeight = 3120
ClientLeft = 45
ClientTop = 330
ClientWidth = 7095
Icon = "frmWaterrateRequisition_Select.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3120
ScaleWidth = 7095
StartUpPosition = 1 '所有者中心
Begin VB.CommandButton cmdOK
Caption = "确定"
Height = 450
Left = 150
TabIndex = 0
Top = 2505
Width = 1155
End
Begin VB.Frame Frame2
Caption = "时段"
ForeColor = &H00800000&
Height = 645
Left = 150
TabIndex = 12
Top = 75
Width = 6810
Begin VB.ComboBox cboMonth
Height = 300
ItemData = "frmWaterrateRequisition_Select.frx":0442
Left = 2820
List = "frmWaterrateRequisition_Select.frx":0444
Style = 2 'Dropdown List
TabIndex = 2
Top = 210
Width = 990
End
Begin MSMask.MaskEdBox txtYear
Height = 300
Left = 1635
TabIndex = 1
Top = 210
Width = 885
_ExtentX = 1561
_ExtentY = 529
_Version = 393216
MaxLength = 4
Mask = "9999"
PromptChar = " "
End
Begin VB.Label Label8
Caption = "月份"
Height = 210
Left = 3855
TabIndex = 16
Top = 285
Width = 405
End
Begin VB.Label Label7
Caption = "年"
Height = 210
Left = 2565
TabIndex = 15
Top = 270
Width = 225
End
Begin VB.Label Label5
Caption = "水费时段："
Height = 210
Left = 360
TabIndex = 14
Top = 255
Width = 975
End
End
Begin VB.Frame Frame1
Caption = "用户"
ForeColor = &H00800000&
Height = 1575
Left = 135
TabIndex = 11
Top = 765
Width = 6825
Begin VB.CheckBox chkChargeType
Height = 210
Left = 225
TabIndex = 7
Top = 270
Width = 225
End
Begin VB.CheckBox chkUser
Height = 225
Left = 210
TabIndex = 10
Top = 1110
Width = 240
End
Begin VB.CheckBox chkPQ
Enabled = 0 'False
Height = 210
Index = 1
Left = 2970
TabIndex = 9
Top = 735
Width = 225
End
Begin VB.CheckBox chkPQ
Height = 210
Index = 0
Left = 225
TabIndex = 8
Top = 735
Width = 225
End
Begin VB.TextBox txtUID
Enabled = 0 'False
Height = 345
Left = 1215
TabIndex = 6
Top = 1050
Width = 1365
End
Begin VB.TextBox txtUName
Enabled = 0 'False
Height = 345
Left = 3840
TabIndex = 17
Top = 1050
Width = 2865
End
Begin MSDataListLib.DataCombo cboP
Height = 330
Left = 1215
TabIndex = 4
Top = 675
Width = 1365
_ExtentX = 2408
_ExtentY = 582
_Version = 393216
Enabled = 0 'False
Style = 2
Text = ""
End
Begin MSDataListLib.DataCombo cboQ
Height = 330
Left = 3840
TabIndex = 5
Top = 675
Width = 1380
_ExtentX = 2434
_ExtentY = 582
_Version = 393216
Enabled = 0 'False
Style = 2
Text = ""
End
Begin MSDataListLib.DataCombo cboChargeType
Height = 330
Left = 1770
TabIndex = 3
Top = 195
Width = 3420
_ExtentX = 6033
_ExtentY = 582
_Version = 393216
Enabled = 0 'False
Style = 2
Text = ""
End
Begin VB.Label lblUserID
Caption = "用户号："
Height = 195
Left = 495
TabIndex = 21
Top = 1140
Width = 1470
End
Begin VB.Label lblQID
Caption = "小区："
Height = 195
Left = 3255
TabIndex = 20
Top = 735
Width = 555
End
Begin VB.Label lblPID
Caption = "片区："
Height = 195
Left = 495
TabIndex = 19
Top = 750
Width = 555
End
Begin VB.Label lblUserName
Caption = "用户名："
Height = 195
Left = 3090
TabIndex = 18
Top = 1125
Width = 735
End
Begin VB.Label Label4
Caption = "用户缴费类型："
Height = 210
Left = 495
TabIndex = 13
Top = 285
Width = 1350
End
Begin VB.Line Line2
BorderColor = &H80000003&
Index = 1
X1 = 90
X2 = 6705
Y1 = 585
Y2 = 585
End
Begin VB.Line Line2
BorderColor = &H80000005&
Index = 0
X1 = 90
X2 = 6705
Y1 = 600
Y2 = 600
End
End
Begin VB.Line Line1
BorderColor = &H80000003&
Index = 1
X1 = 75
X2 = 7020
Y1 = 2400
Y2 = 2400
End
Begin VB.Line Line1
BorderColor = &H80000005&
Index = 0
X1 = 75
X2 = 7020
Y1 = 2415
Y2 = 2415
End
End
Attribute VB_Name = "frmWaterrateRequisition_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 strReturnChargeTypeID As String '返回值-用户交费类型号
Public strReturnChargeTypeName 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
Dim adoChargeTypeRS As ADODB.Recordset
Private Sub cmdOK_Click()
'时段
strReturnYear = Trim(Str(Me.txtYear.Text))
strReturnMonth = Me.cboMonth.Text
'用户
If Me.chkChargeType.value = 1 And Trim(Me.cboChargeType.Text) <> "" Then
strReturnChargeTypeID = Me.cboChargeType.BoundText
strReturnChargeTypeName = Trim(Me.cboChargeType.Text)
End If
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 cboMonth_Change()
If Me.txtYear.Text = Year(Date) And Me.cboMonth.ListIndex > Month(Date) - 1 Then
Warning "月份不能大于当前月份！！！"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -