📄 tqinfo.frm
字号:
Begin VB.Label Label14
BackStyle = 0 'Transparent
Caption = "投运日期："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 22
Top = 3679
Width = 915
End
Begin VB.Label Label13
BackStyle = 0 'Transparent
Caption = "产权归属："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 21
Top = 3251
Width = 915
End
Begin VB.Label Label12
BackStyle = 0 'Transparent
Caption = "台变标识："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 20
Top = 2823
Width = 915
End
Begin VB.Label Label11
BackStyle = 0 'Transparent
Caption = "管理员："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 19
Top = 2395
Width = 915
End
Begin VB.Label Label10
BackStyle = 0 'Transparent
Caption = "生产班次："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 18
Top = 1967
Width = 915
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "线路编号："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 17
Top = 1539
Width = 915
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "台变代码："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 195
Left = 150
TabIndex = 15
Top = 255
Width = 915
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "台变名称："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 14
Top = 683
Width = 915
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "安装位置："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Left = 150
TabIndex = 13
Top = 1111
Width = 915
End
End
Begin VB.Line Line1
BorderColor = &H80000005&
Index = 1
X1 = 135
X2 = 9675
Y1 = 645
Y2 = 645
End
Begin VB.Line Line1
BorderColor = &H80000003&
Index = 0
X1 = 135
X2 = 9675
Y1 = 660
Y2 = 660
End
Begin VB.Label Label5
Caption = "请选择线路:"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 225
Left = 945
TabIndex = 26
Top = 315
Width = 1095
End
Begin VB.Image Image2
Height = 300
Left = 315
Picture = "TQinfo.frx":0442
Top = 240
Width = 525
End
Begin VB.Shape Shape2
BorderColor = &H00808080&
Height = 6105
Left = 105
Top = 105
Width = 9615
End
Begin VB.Shape Shape1
BorderColor = &H00FFFFFF&
Height = 6105
Left = 120
Top = 120
Width = 9615
End
End
Attribute VB_Name = "TQinfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
'////////////////////加载窗口//////////////////////
Private Sub Form_Load()
Dim intRecCount, intCounter As Integer
On Error Resume Next
Me.Move (Screen.Width - Me.Width) / 2, (Screen.Height - Me.Height) / 1 - 850
OpenMdb
Set MdbR = NdMd.OpenRecordset("SELECT * FROM 乡镇档案 ORDER BY 镇代码")
If Not MdbR.eof Then
MdbR.MoveLast
intRecCount = MdbR.RecordCount
MdbR.MoveFirst
For intCounter = 0 To MdbR.RecordCount - 1
Combo1(0).AddItem MdbR.Fields!镇代码 & " " & MdbR.Fields!全称
MdbR.MoveNext
Next intCounter
Combo1(0).ListIndex = 0
Else
MsgBox "请建立上一级档案！", vbCritical
Exit Sub
End If
Set MdbR = NdMd.OpenRecordset("SELECT * FROM 基本数据")
If Not MdbR.eof Then
MdbR.MoveLast
intRecCount = MdbR.RecordCount
MdbR.MoveFirst
For intCounter = 0 To MdbR.RecordCount - 1
Combo1(4).AddItem MdbR.Fields!厂家
MdbR.MoveNext
Next intCounter
Else
MsgBox "请建立上一级档案！", vbCritical
Exit Sub
End If
'生产班次
Combo1(2).AddItem "二班制"
Combo1(2).AddItem "三班制"
Combo1(2).AddItem "其他"
Combo1(2).ListIndex = 0
'台变标识
Combo1(3).AddItem "公用变"
Combo1(3).AddItem "专用变(大工业、私有变)"
Combo1(3).ListIndex = 0
Command1.Enabled = False
Command2.Enabled = False
End Sub
'结束窗口
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
MdbR.Close
NdMd.Close
End Sub
Private Sub Command1_Click()
Call SaveData
End Sub
Private Sub Command3_Click()
Unload Me
End Sub
'////////////////////保存过程////////////////////////////////
Sub SaveData()
On Error GoTo SaveErr
Dim i As Integer
Set MdbR = NdMd.OpenRecordset("select 村档案.简称, 村档案.安装位置, 村档案.线路编号,村档案.抄表员,村档案.产权,村档案.出厂编号,村档案.规格型号, 村档案.阻抗电压, 村档案.容量, 村档案.一次电压,村档案.一次电流,村档案.连接组, 村档案.二次电压, 村档案.油号, 村档案.二次电流, 村档案.空载电流, 村档案.油重, 村档案.空载损耗, 村档案.芯重, 村档案.短路损耗, 村档案.总重, 村档案.铜损系数, 村档案.铁损系数, 村档案.铜损K值, 村档案.CT变压比, 村档案.倍率 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 25
MdbR.Edit
MdbR.Fields(i) = Text1(i).Text
MdbR.Update
Next
Set MdbR = NdMd.OpenRecordset("select 村档案.村代码,村档案.简称,村档案.生产班次,村档案.类型,村档案.厂家,村档案.损耗类型 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 5
If i <> 0 And i <> 1 Then
MdbR.Edit
MdbR.Fields(i) = Combo1(i).Text
MdbR.Update
End If
Next
Set MdbR = NdMd.OpenRecordset("select 村档案.启用日期,村档案.出厂日期 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 1
MdbR.Edit
MdbR.Fields(i) = DTPicker1(i).Value
MdbR.Update
Next
MsgBox "数据已保存！", vbInformation
Command1.Enabled = False
Exit Sub
SaveErr:
MsgBox Err.Description, vbInformation
Resume Next
End Sub
'清输入框
Sub ClearText()
End Sub
Private Sub Text1_Change(Index As Integer)
If Text1(Index).Tag <> Text1(Index).Text Then
Command1.Enabled = True
End If
End Sub
Private Sub Combo1_Change(Index As Integer)
On Error Resume Next
If Combo1(Index).Tag <> Combo1(Index).Text Then
If Combo1(Index) <> 0 Or Combo1(Index) <> 1 Then
Command1.Enabled = True
End If
End If
End Sub
Private Sub DTPicker1_Change(Index As Integer)
If DTPicker1(Index).Tag <> DTPicker1(Index).Value Then
Command1.Enabled = True
End If
End Sub
Private Sub Text1_GotFocus(Index As Integer)
Text1(Index).BackColor = &HFFFF80
End Sub
Private Sub Text1_LostFocus(Index As Integer)
Text1(Index).BackColor = vbWhite
End Sub
Private Sub Text1_KeyPress(Index As Integer, KeyAscii As Integer)
If KeyAscii = 13 Then
SendKeys "{tab}"
End If
End Sub
Private Sub Combo1_GotFocus(Index As Integer)
Combo1(Index).BackColor = &HFFFF80
End Sub
Private Sub Combo1_LostFocus(Index As Integer)
Combo1(Index).BackColor = vbWhite
End Sub
Private Sub Combo1_Click(Index As Integer)
Dim i As Integer
Select Case Index
Case 0
Dim itm As ListItem
Dim intCounter As Integer
On Error Resume Next
Set MdbR = NdMd.OpenRecordset("select * from 村档案 where 镇代码='" & Trim(Left(Combo1(0).Text, 3)) & "' order by 村档案.村代码 ")
Combo1(1).Clear
If Not MdbR.eof Then
MdbR.MoveLast
MdbR.MoveFirst
For intCounter = 0 To MdbR.RecordCount - 1
Combo1(1).AddItem MdbR.Fields!村代码 & vbTab & MdbR.Fields!简称
MdbR.MoveNext
Next intCounter
Combo1(1).ListIndex = 0
Else
MsgBox "请建立上一级档案！", vbCritical
Exit Sub
End If
Case 1
Set MdbR = NdMd.OpenRecordset("select 村档案.简称, 村档案.安装位置, 村档案.线路编号,村档案.抄表员,村档案.产权,村档案.出厂编号,村档案.规格型号, 村档案.阻抗电压, 村档案.容量, 村档案.一次电压,村档案.一次电流,村档案.连接组, 村档案.二次电压, 村档案.油号, 村档案.二次电流, 村档案.空载电流, 村档案.油重, 村档案.空载损耗, 村档案.芯重, 村档案.短路损耗, 村档案.总重, 村档案.铜损系数, 村档案.铁损系数, 村档案.铜损K值, 村档案.CT变压比, 村档案.倍率 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 25
Text1(i).Tag = MdbR.Fields(i) & ""
Text1(i).Text = MdbR.Fields(i) & ""
Next
Set MdbR = NdMd.OpenRecordset("select 村档案.村代码,村档案.简称,村档案.生产班次,村档案.类型,村档案.厂家,村档案.损耗类型 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 5
If i <> 0 And i <> 1 Then
Combo1(i).Tag = MdbR.Fields(i) & ""
Combo1(i).Text = MdbR.Fields(i) & ""
End If
Next
Set MdbR = NdMd.OpenRecordset("select 村档案.启用日期,村档案.出厂日期 from 村档案 where 镇村代码='" & Trim(Left(Combo1(0).Text, 3)) & Trim(Left(Combo1(1).Text, 3)) & "' order by 村档案.村代码 ")
For i = 0 To 1
DTPicker1(i).Tag = IIf(IsNull(MdbR.Fields(i)), Date, Format(MdbR.Fields(i), "yyyy年mm月dd日"))
DTPicker1(i).Value = IIf(IsNull(MdbR.Fields(i)), Date, Format(MdbR.Fields(i), "yyyy年mm月dd日"))
Next
' Text1(4) = convert_string(Combo1(1).Text)
Case 2
End Select
End Sub
Private Sub Combo1_KeyPress(Index As Integer, KeyAscii As Integer)
If KeyAscii = 13 Then
SendKeys "{tab}"
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -