?? frm_qurryuserinfo.frm
字號:
Left = 4440
TabIndex = 42
Top = 5280
Width = 1095
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "用戶地址："
Height = 255
Left = 360
TabIndex = 41
Top = 5280
Width = 975
End
Begin VB.Label Label26
BackStyle = 0 'Transparent
Caption = "電能表起用日期："
Height = 375
Left = 4320
TabIndex = 40
Top = 4920
Width = 1455
End
Begin VB.Label Label25
BackStyle = 0 'Transparent
Caption = "電能表起始讀數無功："
Height = 375
Left = 4320
TabIndex = 39
Top = 4320
Width = 1935
End
Begin VB.Label Label24
BackStyle = 0 'Transparent
Caption = "電能表起始讀數有功："
Height = 375
Left = 4320
TabIndex = 38
Top = 3720
Width = 1815
End
Begin VB.Label Label23
BackStyle = 0 'Transparent
Caption = "互感器比例："
Height = 375
Left = 4320
TabIndex = 37
Top = 3240
Width = 1335
End
Begin VB.Label Label22
BackStyle = 0 'Transparent
Caption = "變壓器型號："
Height = 255
Left = 4320
TabIndex = 36
Top = 2640
Width = 1095
End
Begin VB.Label Label21
BackStyle = 0 'Transparent
Caption = "變壓器編號："
Height = 255
Left = 4320
TabIndex = 35
Top = 2040
Width = 1215
End
Begin VB.Label Label20
BackStyle = 0 'Transparent
Caption = "電能表常數："
Height = 375
Left = 4320
TabIndex = 34
Top = 1440
Width = 1335
End
Begin VB.Label Label19
BackStyle = 0 'Transparent
Caption = "電能表型號："
Height = 375
Left = 4320
TabIndex = 33
Top = 960
Width = 1215
End
Begin VB.Label Label18
BackStyle = 0 'Transparent
Caption = "電能表編號："
Height = 375
Left = 4320
TabIndex = 32
Top = 480
Width = 1335
End
Begin VB.Label Label17
BackStyle = 0 'Transparent
Caption = "用戶臺區："
Height = 255
Left = 360
TabIndex = 31
Top = 4920
Width = 975
End
Begin VB.Label Label16
BackStyle = 0 'Transparent
Caption = "用戶線路："
Height = 255
Left = 360
TabIndex = 30
Top = 4440
Width = 975
End
Begin VB.Label Label15
BackStyle = 0 'Transparent
Caption = "電價："
Height = 255
Left = 360
TabIndex = 29
Top = 3840
Width = 975
End
Begin VB.Label Label14
BackStyle = 0 'Transparent
Caption = "用戶SIM號："
Height = 375
Left = 360
TabIndex = 28
Top = 3360
Width = 1215
End
Begin VB.Label Label13
BackStyle = 0 'Transparent
Caption = "用戶密碼："
Height = 375
Left = 360
TabIndex = 27
Top = 2880
Width = 1095
End
Begin VB.Label Label12
BackStyle = 0 'Transparent
Caption = "聯系手機："
Height = 375
Left = 360
TabIndex = 26
Top = 2280
Width = 975
End
Begin VB.Label Label11
BackStyle = 0 'Transparent
Caption = "聯系電話："
Height = 375
Left = 360
TabIndex = 25
Top = 1680
Width = 1095
End
Begin VB.Label Label10
BackStyle = 0 'Transparent
Caption = "用戶名稱："
Height = 375
Left = 360
TabIndex = 24
Top = 1080
Width = 1095
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "用戶編號："
Height = 255
Left = 360
TabIndex = 23
Top = 480
Width = 975
End
End
Begin VB.TextBox txt_qurry
Appearance = 0 'Flat
Height = 375
Left = 5160
MaxLength = 12
TabIndex = 1
Top = 480
Width = 2055
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "請輸入要查詢的客戶信息："
Height = 255
Left = 240
TabIndex = 43
Top = 550
Width = 2175
End
End
End
Attribute VB_Name = "frm_qurryuserinfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub xpcmdbutton4_Click()
Dim strsql
If Option1.Value = False And Option2.Value = False Then
MsgBox ("您沒有選擇查詢條件！"), vbOKOnly + vbInformation, "提示"
Exit Sub
End If
If Trim(txt_qurry.Text) = "" Then
MsgBox ("查詢值不能為空！"), vbOKOnly + vbInformation, "提示"
Exit Sub
End If
If Option1.Value = True Then
strsql = "select * from userbasic where user_id='" & Trim(txt_qurry.Text) & "'"
openrs strsql
If rs.EOF Then
MsgBox ("不存在該用戶！"), vbOKOnly + vbInformation, "提示"
clors
Exit Sub
End If
End If
If Option2.Value = True Then
strsql = "select * from userbasic where user_sim='" & Trim(txt_qurry.Text) & "'"
openrs strsql
If rs.EOF Then
MsgBox ("不存在該用戶！"), vbOKOnly + vbInformation, "提示"
clors
Exit Sub
End If
End If
txt_id.Text = rs.Fields("user_id").Value
txt_name.Text = rs.Fields("user_name").Value
txt_addr.Text = rs.Fields("user_addr").Value
txt_tel.Text = rs.Fields("user_tel").Value
txt_mobile.Text = rs.Fields("user_mobile").Value
txt_pw.Text = rs.Fields("user_dtupw").Value
txt_biaohao.Text = rs.Fields("user_biaohao").Value
txt_biaoxinghao.Text = rs.Fields("user_biaoxinghao").Value
txt_biaoconst.Text = rs.Fields("user_biaoconst").Value
txt_biaosnumy.Text = rs.Fields("user_biaosnumy").Value
txt_biaosnumn.Text = rs.Fields("user_biaosnumn").Value
txt_byqid.Text = rs.Fields("user_byqid").Value
txt_byqxinghao.Text = rs.Fields("user_byqxinghao").Value
txt_hgqbili.Text = rs.Fields("user_hgqbili").Value
txt_sim.Text = rs.Fields("user_sim").Value
txt_price.Text = rs.Fields("user_powerprice").Value
' txt = rs.Fields("user_powernum").Value
txt_biaotime.Text = rs.Fields("user_biaostime")
txt_usertime.Text = rs.Fields("user_regtime").Value
txt_line.Text = rs.Fields("user_line").Value
txt_taiqu.Text = rs.Fields("user_taiqu").Value
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -