📄 dlgmss7etesttype.frm

📁 电力机车牵引变压器试验站总控程序
💻 FRM
📖 第 1 页 / 共 4 页
字号:
上一页 1 2 34
        Frame8.Visible = False
        ProgressBar4.Visible = False
     Else
        Dim x1 As Integer
        x1 = MsgBox("数据已存在!是否覆盖?", 4 + 0 + 64, "注意")
        If x1 = 6 Then
            rs.Filter = "试验日期 = '" & hgqData(4) & "'"
            rs.Delete
            rs.UpdateBatch
            rs.Close
            
            Set cn = CreateObject("adodb.connection")
            Set rs = CreateObject("adodb.recordset")
            cn.ConnectionString = "uid=admin;pwd=111;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & App.Path & "\试验结果1.mdb;Persist Security Info=False"
            cn.Open
            rs.CursorLocation = 3

            rs.Open "select * from 互感器试验结果", cn, adOpenKeyset, adLockBatchOptimistic
            
            x = rs.Fields.count
            If rs.Recordcount <> 0 Then
                rs.MoveLast
            End If
            rs.AddNew
            
            For i = 0 To x - 1
               rs.Fields(i) = hgqData(i)
            Next i
            rs.UpdateBatch
            rs.Close
            
            MsgBox "数据存档完毕"
            ProgressBar4.Value = ProgressBar4.Max
            Frame8.Visible = False
            ProgressBar4.Visible = False
        ElseIf x1 = 7 Then
            MsgBox "数据未保存"
            ProgressBar4.Value = ProgressBar4.Max
            Frame8.Visible = False
            ProgressBar4.Visible = False
        End If
    End If
    cn.Close
End Sub

Private Sub Command13_Click()
    Call controlCommand("00100001", 0)
    frmProcessing.Show vbModal
    If ttype = "7" Then
        Command15.Enabled = True
        Command15.Visible = True
    End If
End Sub

Private Sub Command14_Click()
    Dim strCommand As String
    Select Case ttype
        Case "7"
            strCommand = TEST_START
        Case Else
            MsgBox "请先选择试验项目", 0 + 0 + 48, "警告"
    End Select
    Call controlCommand(strCommand, 0)
    Frame1.Enabled = False
    Command2.Enabled = False
    Command1.Enabled = False
    frmProcessing.Show vbModal
    Command12.Enabled = True
    Command11.Enabled = True
    Command13.Enabled = True
End Sub

Private Sub Command15_Click()
    dlgManualTest.Show vbModal
    Command16.Enabled = True
    Command17.Enabled = True
End Sub

Private Sub Command16_Click()
    Command11.Enabled = False
    Command12.Enabled = False
    Command13.Enabled = False
    Command14.Enabled = False
    Command15.Enabled = False
    Command15.Visible = False
    Command1.Enabled = True
    Command4.Enabled = True
    Command6.Enabled = True
End Sub

Private Sub Command17_Click()
    dlgObjectSelection.Show vbModal
    Command14.Enabled = True
    Command17.Enabled = False
End Sub

Private Sub Command18_Click()
    dlgCalendar.Show vbModal
    Text3(3).Text = choosenDate
    choosenDate = ""
End Sub

Private Sub Command19_Click()
    dlgCalendar.Show vbModal
    Text5(3).Text = choosenDate
    choosenDate = ""
End Sub

Private Sub Command2_Click()
    If continuedTest = False Then
        If Text1(0).Text = "" Or Text1(1).Text = "" Or Text1(2).Text = "" Or Text1(3).Text = "" Then
            Dim i As Integer
            i = MsgBox("请先完成基本信息录入!", 0 + 0 + 48, "警告")
        Else
            For i = 0 To 2
                byqData(i + 1) = Text1(i).Text
                dkqData(i + 1) = Text1(i).Text
            Next i
            Call GetCurrentTime
            byqData(4) = Text1(3).Text & " " & currentTime
            dkqData(4) = Text1(3).Text & " " & currentTime
            dataFile = App.Path & "\试验结果\" & byqData(4) & ".doc"
            Frame1.Enabled = True
            Frame3.Enabled = False
            SSTab1.TabEnabled(1) = False
            SSTab1.TabEnabled(2) = False
            SSTab1.TabEnabled(3) = False
        End If
    ElseIf continuedTest = True Then
        Frame1.Enabled = True
        dataFile = App.Path & "\试验结果\" & byqData(4) & ".doc"
    End If
End Sub

Private Sub Command3_Click()
    If continuedTest = False Then
        If Text2(0).Text = "" Or Text2(1).Text = "" Or Text2(2).Text = "" Or Text2(3).Text = "" Then
            Dim i As Integer
            i = MsgBox("请先完成基本信息录入!", 0 + 0 + 48, "警告")
        Else
            For i = 0 To 2
                byqData(i + 1) = Text2(i).Text
                dkqData(i + 1) = Text2(i).Text
            Next i
            Call GetCurrentTime
            byqData(4) = Text2(3).Text & " " & currentTime
            dkqData(4) = Text2(3).Text & " " & currentTime
            dataFile = App.Path & "\试验结果\" & dkqData(4) & ".doc"
            Frame5.Enabled = True
            Frame4.Enabled = False
            SSTab1.TabEnabled(0) = False
            SSTab1.TabEnabled(2) = False
            SSTab1.TabEnabled(3) = False
        End If
    ElseIf continuedTest = True Then
        Frame5.Enabled = True
        dataFile = App.Path & "\试验结果\" & dkqData(4) & ".doc"
    End If
End Sub

Private Sub Command4_Click()
    Call Command1_Click
End Sub

Private Sub Command5_Click()
    If continuedTest = False Then
        If Text3(0).Text = "" Or Text3(1).Text = "" Or Text3(2).Text = "" Or Text3(3).Text = "" Then
            Dim i As Integer
            i = MsgBox("请先完成基本信息录入!", 0 + 0 + 48, "警告")
        Else
            For i = 0 To 2
                byqData(i + 1) = Text3(i).Text
                dkqData(i + 1) = Text3(i).Text
            Next i
            Call GetCurrentTime
            byqData(4) = Text3(3).Text & " " & currentTime
            dkqData(4) = Text3(3).Text & " " & currentTime
            dataFile = App.Path & "\试验结果\" & dkqData(4) & ".doc"
            Frame7.Enabled = True
            Frame6.Enabled = False
            SSTab1.TabEnabled(0) = False
            SSTab1.TabEnabled(1) = False
            SSTab1.TabEnabled(3) = False
        End If
    ElseIf continuedTest = True Then
        Frame7.Enabled = True
        dataFile = App.Path & "\试验结果\" & dkqData(4) & ".doc"
    End If
End Sub

Private Sub Command6_Click()
    Call Command1_Click
End Sub

Private Sub Command7_Click()
    dlgCalendar.Show vbModal
    Text1(3).Text = choosenDate
    choosenDate = ""
End Sub

Private Sub Command8_Click()
    dlgCalendar.Show vbModal
    Text2(3).Text = choosenDate
    choosenDate = ""
End Sub

Private Sub Command9_Click()
    If continuedTest = False Then
        If Text5(0).Text = "" Or Text5(1).Text = "" Or Text5(2).Text = "" Or Text5(3).Text = "" Then
            Dim i As Integer
            i = MsgBox("请先完成基本信息录入!", 0 + 0 + 48, "警告")
        Else
            For i = 0 To 2
                hgqData(i + 1) = Text5(i).Text
            Next i
            Call GetCurrentTime
            hgqData(4) = Text5(3).Text & " " & currentTime
            dataFile = App.Path & "\试验结果\" & hgqData(4) & ".doc"
            Frame12.Enabled = True
            Frame11.Enabled = False
            SSTab1.TabEnabled(0) = False
            SSTab1.TabEnabled(1) = False
            SSTab1.TabEnabled(2) = False
        End If
    ElseIf continuedTest = True Then
        Frame12.Enabled = True
        dataFile = App.Path & "\试验结果\" & hgqData(4) & ".doc"
    End If
End Sub

Private Sub Form_Load()
    Dim i As Integer
    If continuedTest = True Then
        SSTab1.TabEnabled(0) = False
        SSTab1.TabEnabled(1) = False
        SSTab1.TabEnabled(2) = False
        SSTab1.TabEnabled(3) = False
        If byqData(4) <> "" And dkqData(4) <> "" Then
            If dkqData(138) = "未完成" Then
                SSTab1.Tab = 2
                SSTab1.TabEnabled(2) = True
                Frame6.Enabled = False
                Frame7.Enabled = False
                For i = 0 To 4
                    If dkqData(i + 132) = "完成" Then
                        Option1(i + 18).Enabled = False
                    End If
                Next i
                For i = 0 To 3
                    Text3(i).Text = dkqData(i + 1)
                Next i
            End If
            
            If dkqData(71) = "未完成" Then
                SSTab1.Tab = 1
                SSTab1.TabEnabled(1) = True
                Frame4.Enabled = False
                Frame5.Enabled = False
                For i = 0 To 4
                    If dkqData(i + 65) = "完成" Then
                        Option1(i + 13).Enabled = False
                    End If
                Next i
                For i = 0 To 3
                    Text2(i).Text = dkqData(i + 1)
                Next i
            End If
            
            If byqData(238) = "未完成" Then
                SSTab1.Tab = 0
                SSTab1.TabEnabled(0) = True
                Frame3.Enabled = False
                Frame1.Enabled = False
                For i = 0 To 12
                    If byqData(i + 225) = "完成" Then
                        Option1(i).Enabled = False
                    End If
                Next i
                For i = 0 To 3
                    Text1(i).Text = byqData(i + 1)
                Next i
            End If
            SSTab1.TabEnabled(3) = False
        ElseIf hgqData(4) <> "" And hgqData(21) = "未完成" Then
            SSTab1.Tab = 3
            SSTab1.TabEnabled(3) = True
            SSTab1.TabEnabled(0) = False
            SSTab1.TabEnabled(1) = False
            SSTab1.TabEnabled(2) = False
            Frame11.Enabled = False
            Frame12.Enabled = False
            For i = 0 To 4
                If hgqData(i + 16) = "完成" Then
                    Option1(i + 28).Enabled = False
                End If
            Next i
            For i = 0 To 3
                Text5(i).Text = hgqData(i + 1)
            Next i
        End If
    ElseIf continuedTest = False Then
        byqData(0) = "模块SS7E"
        hgqData(0) = "模块SS7E"
        dkqData(0) = "模块SS7E"
        Text1(3).Text = Date
        Text2(3).Text = Date
        Text3(3).Text = Date
        Text5(3).Text = Date
        SSTab1.TabEnabled(0) = True
        SSTab1.TabEnabled(1) = True
        SSTab1.TabEnabled(2) = True
        SSTab1.TabEnabled(3) = True
        Frame3.Enabled = True
        Frame1.Enabled = False
        Frame4.Enabled = True
        Frame5.Enabled = False
        Frame6.Enabled = True
        Frame7.Enabled = False
        Frame11.Enabled = True
        Frame12.Enabled = False
        SSTab1.Tab = 0
    End If
End Sub

Private Sub OKButton_Click()
    Unload Me
End Sub

Private Sub Option1_Click(Index As Integer)
    If Index = 0 Then
        ttype = "1"
        dlgManualTest.Show [vbModal]
    ElseIf Index = 1 Then
        ttype = "2"
        dlgManualTest.Show [vbModal]
    ElseIf Index = 2 Then
    
    ElseIf Index = 3 Then
    
    ElseIf Index = 4 Then
    
    ElseIf Index = 5 Then
    
    ElseIf Index = 6 Then
    
    ElseIf Index = 7 Then
        ttype = "7"
        Command17.Enabled = True
        Command17.Visible = True
    ElseIf Index = 8 Then
    
    ElseIf Index = 9 Then
    
    ElseIf Index = 10 Then
    
    ElseIf Index = 11 Then
    
    ElseIf Index = 12 Then
    
    ElseIf Index = 13 Then
    
    ElseIf Index = 14 Then
    
    ElseIf Index = 15 Then
    
    ElseIf Index = 16 Then
    
    ElseIf Index = 17 Then
    
    ElseIf Index = 18 Then
    
    ElseIf Index = 19 Then
    
    ElseIf Index = 20 Then
    
    ElseIf Index = 21 Then
    
    ElseIf Index = 22 Then
    
    ElseIf Index = 23 Then
    
    ElseIf Index = 24 Then
    
    ElseIf Index = 25 Then
    
    ElseIf Index = 26 Then
    
    ElseIf Index = 27 Then
    
    ElseIf Index = 28 Then
    
    ElseIf Index = 29 Then
    
    ElseIf Index = 30 Then
    
    ElseIf Index = 31 Then
    
    ElseIf Index = 32 Then
    
    End If
End Sub
上一页 1 2 34
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -