📄 frmdatainput1.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frmdatainput1
Caption = "表底录入"
ClientHeight = 2775
ClientLeft = 60
ClientTop = 345
ClientWidth = 6420
LinkTopic = "mdiform1"
MDIChild = -1 'True
ScaleHeight = 2775
ScaleWidth = 6420
Begin VB.Frame y
Caption = "表计数据输入"
Height = 1695
Left = 120
TabIndex = 4
Top = 120
Width = 6255
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Height = 375
Index = 5
Left = 4560
TabIndex = 10
Top = 1200
Width = 1575
End
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Height = 375
Index = 3
Left = 1440
TabIndex = 9
Top = 1200
Width = 1575
End
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Height = 375
Index = 4
Left = 3000
TabIndex = 8
Top = 1200
Width = 1575
End
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Enabled = 0 'False
ForeColor = &H80000011&
Height = 375
Index = 6
Left = 1440
TabIndex = 7
Top = 840
Width = 1575
End
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Enabled = 0 'False
Height = 375
Index = 7
Left = 3000
TabIndex = 6
Top = 840
Width = 1575
End
Begin VB.TextBox txtfields
BeginProperty DataFormat
Type = 1
Format = "0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 1
EndProperty
Enabled = 0 'False
Height = 375
Index = 8
Left = 4560
TabIndex = 5
Top = 840
Width = 1575
End
Begin MSComCtl2.DTPicker DTPicker1
Height = 375
Left = 120
TabIndex = 11
Top = 1200
Width = 1335
_ExtentX = 2355
_ExtentY = 661
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
CalendarTrailingForeColor= -2147483639
CustomFormat = "yyyy-MM"
Format = 24576003
CurrentDate = 37864
End
Begin MSComCtl2.DTPicker DTPicker2
Height = 375
Left = 120
TabIndex = 12
Top = 840
Width = 1335
_ExtentX = 2355
_ExtentY = 661
_Version = 393216
Enabled = 0 'False
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
CustomFormat = "yyyy-MM"
Format = 24576003
CurrentDate = 37864
End
Begin VB.Label Label5
Caption = "水表数据"
Height = 375
Left = 3360
TabIndex = 18
Top = 600
Width = 975
End
Begin VB.Label Label6
Caption = "厨 房"
Height = 255
Left = 5040
TabIndex = 17
Top = 360
Width = 735
End
Begin VB.Label Label1
Caption = "水表数据"
Height = 375
Index = 0
Left = 4920
TabIndex = 16
Top = 600
Width = 855
End
Begin VB.Label Label4
Caption = "卫生间"
Height = 255
Left = 3480
TabIndex = 15
Top = 360
Width = 855
End
Begin VB.Label Label1
Caption = "电表表底"
Height = 375
Index = 1
Left = 1800
TabIndex = 14
Top = 480
Width = 975
End
Begin VB.Label Label2
Caption = "日 期"
Height = 375
Left = 360
TabIndex = 13
Top = 480
Width = 975
End
Begin VB.Shape Shape1
Height = 1345
Left = 120
Top = 240
Width = 6030
End
Begin VB.Line Line1
X1 = 120
X2 = 6120
Y1 = 840
Y2 = 840
End
Begin VB.Line Line2
X1 = 120
X2 = 6120
Y1 = 1200
Y2 = 1200
End
Begin VB.Line Line3
X1 = 1440
X2 = 1440
Y1 = 240
Y2 = 1560
End
Begin VB.Line Line4
X1 = 3000
X2 = 3000
Y1 = 240
Y2 = 1560
End
Begin VB.Line Line5
X1 = 4560
X2 = 4560
Y1 = 240
Y2 = 1560
End
End
Begin VB.CommandButton Command1
Caption = "退 出"
Height = 375
Left = 4440
TabIndex = 1
Top = 2280
Width = 1575
End
Begin VB.CommandButton Comdata
Caption = "数据输入"
Height = 375
Left = 480
TabIndex = 0
Top = 2280
Width = 1575
End
Begin VB.ComboBox cmbPrice
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 840
TabIndex = 2
Top = 840
Width = 1620
End
Begin VB.ComboBox cmbPrice1
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 3720
TabIndex = 3
Top = 840
Width = 1500
End
End
Attribute VB_Name = "frmdatainput1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim stoalfee As Single
Private Sub Comdata_Click()
Dim MYSET As New ADODB.Recordset
Dim myset1 As New ADODB.Recordset
strsql = "select * from datawork where huhao='" & _
Trim(frmfeeinput.txtfields(2).Text) & _
"' and clloyear=" & DTPicker1.Year & " and cllomonth=" & _
DTPicker1.Month
MYSET.Open strsql, config.cnZdx, adOpenStatic, adLockReadOnly
If MYSET.EOF Then
strsql = "insert into datawork(louhaoid,USERID1,huhao,name,clloyear,cllomonth,elcmeterfee,elcmeter,watermeterfee,watermeter,watermeter1) values('"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -