亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

? 歡迎來到蟲蟲下載站! | ?? 資源下載 ?? 資源專輯 ?? 關(guān)于我們
? 蟲蟲下載站

?? gdhweight.frm

?? 齊魯石化某分公司的數(shù)據(jù)采集管理系統(tǒng)
?? FRM
?? 第 1 頁 / 共 5 頁
字號:
    If Int(Val(ss)) >= 0 Then
        gdh_Print_Lline = Int(Val(ss))
    Else
        gdh_Print_Lline = 1
    
    End If
    
    ss = GetKeyValue(str_FilePath, "print", "spacecount", "0")
    If Int(Val(ss)) >= 0 Then
        gdh_Print_Spacecount = Int(Val(ss))
    Else
        gdh_Print_Spacecount = 0
    
    End If
    
    ss = GetKeyValue(str_FilePath, "print", "printmode", "L")
    If ss = "P" Then
        gdh_Print_Mode = "P"
    Else
        gdh_Print_Mode = "L"
    
    End If
    
    ss = GetKeyValue(str_FilePath, "mode", "printmode", "1")
    If Int(Val(ss)) = 0 Then
        gdh_Mode_Printmode = 0
    Else
        gdh_Mode_Printmode = 1
    
    End If
    
    ss = GetKeyValue(str_FilePath, "gprs", "path", "D:\RW\SEND")    '2007-1-11 //付建明
    If Right$(ss, 1) <> "\" Then
        ss = ss + "\"
    End If
    gdh_GPRS_Path = ss
    
    ss = GetKeyValue(str_FilePath, "gprs", "dates", "1")   '2007-1-11  //
    If Int(Val(ss)) >= 1 Then
        gdh_Gprs_Sdate = Int(Val(ss))
    Else
        gdh_Gprs_Sdate = 5
    End If
    
    ss = GetKeyValue(str_FilePath, "weight", "dbpath", "")    '2007-1-13 //付建明
    If ss = "" Then
        gdh_Weight_Dbpath = App.Path & "\"
    Else
        If Right$(ss, 1) <> "\" Then
            ss = ss + "\"
        End If
        gdh_Weight_Dbpath = ss
    End If
    
    str_FilePath = App.Path & "\editconfig.ini"
    For j = 0 To 9
        ss = GetKeyValue(str_FilePath, "page", "page" & j, "9")
        PageSize(j) = Int(Val(ss))
    Next j
    
    
ok:
End Function

Private Function myTrim(strtn As String) As String
    Dim i As Integer
    Dim j As Integer
    Dim strtemp As String
    j = 0
    If strtn <> "" Then
        For i = 1 To Len(strtn)
            strtemp = Mid(strtn, i, 1)
            If strtemp >= "0" And strtemp <= "9" Or strtemp >= "A" And strtemp <= "Z" Or strtemp >= "a" And strtemp <= "z" Or strtemp = "+" Then
                j = j + 1
            Else
                Exit For
            End If
        Next
    End If
    If j = 0 Then
        strtn = ""
    ElseIf j > 5 Then
        strtn = Mid(strtn, 1, 5)
    Else
        strtn = Mid(strtn, 1, j)
    End If
    myTrim = strtn
End Function

Function Read_Data_from_gdhysdb(strDate_Time As String, GD As MSHFlexGrid, DBPath As String)
    Dim db As New ADODB.Connection, rs As New ADODB.Recordset
    Dim i As Integer
    Dim Query As String, table_Name As String, dbName As String
    Dim FulldbPath As String
    On Error GoTo ok
    
    GD.Rows = 2
    For i = 0 To GD.Cols - 1
        GD.TextMatrix(1, i) = ""
    Next i
    i = 0
    Select Case Mid(strDate_Time, 6, 2)
        Case "01"
            table_Name = "gdh" & "01"
        Case "02"
            table_Name = "gdh" & "02"
        Case "03"
            table_Name = "gdh" & "03"
        Case "04"
            table_Name = "gdh" & "04"
        Case "05"
            table_Name = "gdh" & "05"
        Case "06"
            table_Name = "gdh" & "06"
        Case "07"
            table_Name = "gdh" & "07"
        Case "08"
            table_Name = "gdh" & "08"
        Case "09"
            table_Name = "gdh" & "09"
        Case "10"
            table_Name = "gdh" & "10"
        Case "11"
            table_Name = "gdh" & "11"
        Case "12"
            table_Name = "gdh" & "12"
        Case Else
            Exit Function
    End Select
    
    dbName = "gdhys" & Mid(strDate_Time, 1, 4) & ".mdb"
    FulldbPath = DBPath & "\" & dbName
    
    db.CursorLocation = adUseClient
    db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & FulldbPath & ";Jet OLEDB:Database Password=dfrw2306;"
    
'    Set db = OpenDatabase(dbPath & "\" & dbName, False, False, ";pwd=1")
    Query = "select * from " & table_Name & " where 日期時(shí)間='" & strDate_Time & "' order by 序號 ASC"
'    Set rs = db.OpenRecordset(Query)
    rs.Open Query, db, adOpenDynamic, adLockOptimistic
    If Not rs.BOF And Not rs.EOF Then
        rs.MoveFirst
        Do While Not rs.EOF
            i = i + 1
            GD.Rows = GD.Rows + 1
            GD.TextMatrix(i, Col(0)) = Trim(str(rs.Fields("序號").Value))
            GD.TextMatrix(i, Col(1)) = Trim(rs.Fields("車型").Value)
            GD.TextMatrix(i, Col(2)) = Trim(rs.Fields("車號").Value)
            GD.TextMatrix(i, Col(3)) = Trim(str(rs.Fields("毛重").Value))
            GD.TextMatrix(i, Col(8)) = Trim(str(rs.Fields("速度").Value))
            rs.MoveNext
        Loop
    End If
    
    rs.Close
    db.Close
ok:
End Function

Function Save_Data_to_gdhys(strDate_Time As String, v_Direction As String, GD As MSHFlexGrid, dbsavePath As String) As Boolean
    Dim db As New ADODB.Connection, rs As New ADODB.Recordset
    Dim i As Integer, j As Integer
    Dim Query As String, table_Name As String, dbName As String
    Dim FulldbPath As String
    On Error GoTo ok
    
    If GD.Rows = 2 Or GD.TextMatrix(1, 0) = "" Then
        Exit Function
    End If
    
    Select Case Mid(strDate_Time, 6, 2)
        Case "01"
            table_Name = "gdh" & "01"
        Case "02"
            table_Name = "gdh" & "02"
        Case "03"
            table_Name = "gdh" & "03"
        Case "04"
            table_Name = "gdh" & "04"
        Case "05"
            table_Name = "gdh" & "05"
        Case "06"
            table_Name = "gdh" & "06"
        Case "07"
            table_Name = "gdh" & "07"
        Case "08"
            table_Name = "gdh" & "08"
        Case "09"
            table_Name = "gdh" & "09"
        Case "10"
            table_Name = "gdh" & "10"
        Case "11"
            table_Name = "gdh" & "11"
        Case "12"
            table_Name = "gdh" & "12"
        Case Else
            Exit Function
    End Select
    
    dbName = "gdhys" & Mid(strDate_Time, 1, 4) & ".mdb"
    FulldbPath = dbsavePath & dbName
    
    db.CursorLocation = adUseClient
    db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & FulldbPath & ";Jet OLEDB:Database Password=dfrw2306;"
    
'    Set db = OpenDatabase(dbsavePath & dbName, False, False, "; pwd=1")
    Query = "select * from " & table_Name & " where 日期時(shí)間='" & strDate_Time & "'"
'    Set rs = db.OpenRecordset(Query)
    rs.Open Query, db, adOpenDynamic, adLockOptimistic
    
    If Not rs.BOF And Not rs.EOF Then
        rs.MoveFirst
        Do While Not rs.EOF
            rs.Delete
            rs.MoveNext
        Loop
    End If
    
    For i = 1 To GD.Rows - 2
        rs.AddNew
        rs.Fields("序號") = Int(Val(GD.TextMatrix(i, Col(0))))
        rs.Fields("車型") = Trim(GD.TextMatrix(i, Col(1)))
        rs.Fields("車號") = Trim(GD.TextMatrix(i, Col(2)))
        rs.Fields("毛重") = Trim(GD.TextMatrix(i, Col(3)))
        rs.Fields("速度") = Trim(GD.TextMatrix(i, Col(8)))
        rs.Fields("方向") = v_Direction
        rs.Fields("日期時(shí)間") = strDate_Time
        rs.Update
    Next i
    rs.Close
    
    '添加索引記錄
    Query = "select * from gdhindex where 日期時(shí)間='" & strDate_Time & "'"
'    Set rs = db.OpenRecordset(Query)
    rs.Open Query, db, adOpenDynamic, adLockOptimistic
    
    If Not rs.BOF And Not rs.EOF Then
    Else
        rs.AddNew
        rs.Fields("車數(shù)") = Trim(str(GD.Rows - 2))
        rs.Fields("日期時(shí)間") = strDate_Time
        rs.Fields("方向") = v_Direction
        rs.Update
    End If
    rs.Close
    
    db.Close
    Save_Data_to_gdhys = True
    Exit Function
ok:
End Function

Function Save_Data_to_File(str_FilePath As String, GD As MSHFlexGrid, strDate_Time As String, v_Direction As String)
    
    Dim strLine As String
    Dim j As Integer
    Dim i As Integer
    Dim FileNo As Integer
    On Error GoTo ok
'    str_FilePath = App.Path & "\tempfile.tpr"
    If Dir(str_FilePath) <> "" Then
        Kill str_FilePath
    End If
    
    If GD.Rows = 2 Or GD.TextMatrix(1, 0) = "" Then
        Exit Function
    End If
    
    FileNo = FreeFile
    Open str_FilePath For Output As #FileNo
    Print #FileNo, "GDHW"
    strLine = "序號" + "|" + "車號" + "|" + "車型" + "|" + "毛重" + "|" + "速度" + "|"
    Print #FileNo, strLine
    Print #FileNo, strDate_Time
    Print #FileNo, v_Direction
    Print #FileNo, Trim(str(GD.Rows - 2))
    
    For i = 1 To GD.Rows - 2
        strLine = ""
        strLine = strLine + Trim(GD.TextMatrix(i, Col(0))) + "|"
        strLine = strLine + Trim(GD.TextMatrix(i, Col(2))) + "|"
        strLine = strLine + Trim(GD.TextMatrix(i, Col(1))) + "|"
        strLine = strLine + Trim(GD.TextMatrix(i, Col(3))) + "|"
        strLine = strLine + Trim(GD.TextMatrix(i, Col(8))) + "|"
        Print #FileNo, strLine
    Next i
    Close #FileNo
ok:
End Function

Function Save_Zero_to_File(str_FilePath As String, strDate_Time As String)
    Dim strLine As String
    Dim FileNo As Integer
    Dim j As Integer
    On Error GoTo ok
    
    FileNo = FreeFile
    Open str_FilePath For Output As #FileNo
    
    Print #FileNo, "GDHZ"
    Print #FileNo, strDate_Time
    
    For j = 0 To 11
        strLine = strLine + Trim(Text1(j).text) + "|"
    Next j
    Print #FileNo, strLine
    
    Close #FileNo
    
ok:
End Function

Function Weight_Exit()
    On Error GoTo ok
    If Goods_Vehicle_Exist = True Then
        Call Save_Data_to_File(gdh_GPRS_Path & "gprssend.tpr", MSHFlexGrid1, Trim(Label3(0).Caption), Trim(Label3(1).Caption))
        
        Call CreatDB(Mid(Trim(Label3(0).Caption), 1, 4))
        If Check1.Value = 1 Then
            
            Call Save_Data_to_gdhys(Trim(Label3(0).Caption), Trim(Label3(1).Caption), MSHFlexGrid1, gdh_Weight_Dbpath)
            Call Save_Data_to_File(App.Path & "\tempfile.tpr", MSHFlexGrid1, Trim(Label3(0).Caption), Trim(Label3(1).Caption))
            If gdh_Weight_Savetofile = 1 Then
                Dim str_FilePath As String
                str_FilePath = Mid(Trim(Label3(0).Caption), 1, 4) + Mid(Trim(Label3(0).Caption), 6, 2) + Mid(Trim(Label3(0).Caption), 9, 2)
                str_FilePath = str_FilePath + Mid(Trim(Label3(0).Caption), 12, 2) + Mid(Trim(Label3(0).Caption), 15, 2)
                If Right$(gdh_Weight_Savepath, 1) <> "\" Then
                    str_FilePath = gdh_Weight_Savepath + "\" + str_FilePath + ".txt"
                Else
                    str_FilePath = gdh_Weight_Savepath + str_FilePath + ".txt"
                End If
                Call Save_Data_to_File(str_FilePath, MSHFlexGrid1, Trim(Label3(0).Caption), Trim(Label3(1).Caption))
            
            End If
        End If
        
        If Me.Check2.Value = 1 Then
            If gdh_Print_Mode = "P" Then
                Call totalPrint(MSHFlexGrid1.Rows - 2)
            Else
                Call Line_Print(MSHFlexGrid1)
            End If
        End If
        
    End If
    Goods_Vehicle_Exist = False
ok:
End Function

Private Function totalPrint(RecordCount As Integer)
    Dim i As Integer, j As Integer, px As Long, py As Long
    Dim tt As Integer, printCount As Integer
    Dim intTotal As Single
    Dim strTotal As String
    Dim PrintString As String
    Dim strNo As String
    On Error GoTo ok
    
    If MSHFlexGrid1.Rows = 2 Or MSHFlexGrid1.TextMatrix(1, 0) = "" Then
        MsgBox "缺少打印內(nèi)容,無法打印"
        Exit Function
    End If
    
    If RecordCount <= 10 Then
        Printer.PaperSize = PageSize(0)
    ElseIf RecordCount > 10 And RecordCount <= 20 Then Printer.PaperSize = PageSize(1)
    ElseIf RecordCount > 20 And RecordCount <= 30 Then Printer.PaperSize = PageSize(2)
    ElseIf RecordCount > 30 And RecordCount <= 40 Then Printer.PaperSize = PageSize(3)
    ElseIf RecordCount > 40 And RecordCount <= 50 Then Printer.PaperSize = PageSize(4)
    ElseIf RecordCount > 50 And RecordCount <= 60 Then Printer.PaperSize = PageSize(5)
    ElseIf RecordCount > 60 And RecordCount <= 70 Then Printer.PaperSize = PageSize(6)
    ElseIf RecordCount > 70 And RecordCount <= 80 Then Printer.PaperSize = PageSize(7)
    ElseIf RecordCount > 80 And RecordCount <= 90 Then Printer.PaperSize = PageSize(8)
    Else
        Printer.PaperSize = PageSize(9)
    End If
    
    px = 500
    py = 100
    Printer.FontName = "黑體"
    '打印主標(biāo)題
    PrintString = Space(6) & "軌 道 衡 稱 重 原 始 計(jì) 量 單"
    tt = prnt11(px, py, 12, PrintString, 110)
    
    '打印說明信息
    strNo = Mid(Label3(0).Caption, 1, 4) + Mid(Label3(0).Caption, 6, 2) + Mid(Label3(0).Caption, 9, 2) + Mid(Label3(0).Caption, 12, 2) + Mid(Label3(0).Caption, 15, 2)
    PrintString = "日期: " + Mid(Label3(0).Caption, 1, 10) + Space(4) & "時(shí)間: " + Mid(Label3(0).Caption, 12, 5) + Space(4) & "編號: " + strNo

?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频
欧美精品一区二区不卡| 欧美精品日日鲁夜夜添| 国产亚洲精品aa午夜观看| 美女www一区二区| 亚洲精品在线观看网站| 国产盗摄一区二区| 亚洲男人的天堂av| 欧美日本精品一区二区三区| 午夜影院久久久| 精品精品国产高清a毛片牛牛 | 亚洲一区二区三区四区在线免费观看 | 国产亚洲1区2区3区| 成人三级伦理片| 亚洲欧美日韩久久精品| 欧美日韩成人综合天天影院| 久久er精品视频| 国产精品久久久久久久久久久免费看| 91在线国内视频| 日本欧美一区二区| 国产无一区二区| 欧美日韩免费在线视频| 久久99精品国产.久久久久久| 国产精品国产三级国产专播品爱网 | 欧美一区欧美二区| 国产成人日日夜夜| 亚洲一级二级三级在线免费观看| 日韩欧美一区二区免费| 成人高清视频在线观看| 日本视频在线一区| 中文字幕一区二区三区色视频| 欧美午夜精品一区二区三区| 国内精品国产成人国产三级粉色| 亚洲欧美视频在线观看视频| 日韩一区二区三区在线观看| 99久久国产综合精品麻豆| 热久久久久久久| 亚洲精品美腿丝袜| 久久久久久久综合| 欧美巨大另类极品videosbest | 国产精品久久福利| 日韩一区二区在线看片| 在线观看网站黄不卡| 国产成a人亚洲精| 日本美女视频一区二区| 自拍av一区二区三区| 精品国精品国产| 欧美区一区二区三区| 色综合天天性综合| 蜜桃视频免费观看一区| 亚洲国产精品成人久久综合一区| 欧美裸体一区二区三区| www.66久久| 国产盗摄视频一区二区三区| 日韩1区2区3区| 亚洲一区二区三区小说| 亚洲视频一区二区免费在线观看| 欧美一级片在线看| 欧美亚洲国产怡红院影院| 99riav一区二区三区| 国产精品中文字幕欧美| 久久精品二区亚洲w码| 曰韩精品一区二区| 中文字幕在线不卡一区 | 懂色av一区二区夜夜嗨| 日本不卡免费在线视频| 午夜精品在线视频一区| 一级精品视频在线观看宜春院| 亚洲国产成人午夜在线一区 | 色综合久久久久综合99| 成人av电影在线观看| 国产成人高清在线| 国产精品一区二区果冻传媒| 国产在线精品不卡| 国产呦精品一区二区三区网站| 天堂资源在线中文精品| 天天色图综合网| 天堂在线亚洲视频| 奇米精品一区二区三区在线观看| 亚洲国产精品欧美一二99| 一区二区国产视频| 午夜久久久久久电影| 免费高清在线一区| 精品亚洲成a人在线观看| 国产乱人伦偷精品视频不卡| 国内精品久久久久影院色| 国产成人自拍网| 粉嫩av一区二区三区粉嫩| youjizz国产精品| 日本丰满少妇一区二区三区| 日本道色综合久久| 欧美另类久久久品| 欧美一级免费大片| 2023国产精华国产精品| 国产精品视频第一区| 亚洲精品免费在线观看| 亚洲国产sm捆绑调教视频 | 久久久欧美精品sm网站| 中文一区在线播放| 亚洲精品一卡二卡| 国产精品原创巨作av| 国产麻豆精品在线| 91无套直看片红桃| 欧美视频一区二区在线观看| 在线观看国产91| 精品国产网站在线观看| 亚洲欧洲国产日本综合| 亚洲午夜在线电影| 国产一区二区在线观看视频| 97se亚洲国产综合自在线| 欧美二区三区91| 国产人成亚洲第一网站在线播放| 亚洲欧美一区二区在线观看| 亚洲成人av一区二区三区| 国产毛片精品国产一区二区三区| 99久久国产综合精品色伊| 337p亚洲精品色噜噜| 国产日韩精品一区二区三区| 夜夜爽夜夜爽精品视频| 国产在线乱码一区二区三区| 91麻豆蜜桃一区二区三区| 日韩欧美一级片| 亚洲综合av网| 高清国产午夜精品久久久久久| 欧美色图免费看| 中文乱码免费一区二区| 蜜桃久久久久久| 91同城在线观看| 欧美草草影院在线视频| 亚洲欧美日韩在线不卡| 国产永久精品大片wwwapp | 国产在线播放一区三区四| 色综合一个色综合| 久久久精品tv| 天天综合色天天| 91免费看`日韩一区二区| 欧美精品一区二区在线播放| 亚洲影视在线观看| 99精品国产99久久久久久白柏| 欧美岛国在线观看| 日韩制服丝袜av| 欧美性生交片4| 亚洲人成精品久久久久| 国产成人av资源| 精品欧美久久久| 日本三级韩国三级欧美三级| 色婷婷久久一区二区三区麻豆| 国产日本一区二区| 久国产精品韩国三级视频| 欧美亚洲禁片免费| 亚洲另类在线制服丝袜| a4yy欧美一区二区三区| 中文字幕精品在线不卡| 国产综合色视频| 精品国产一区二区精华| 久久成人久久爱| 欧美成人女星排名| 久久国产视频网| 日韩精品一区二区三区中文不卡 | 久久国产人妖系列| 欧美一区二区日韩一区二区| 亚洲丰满少妇videoshd| 一本色道久久综合狠狠躁的推荐| 国产精品二三区| 成人美女视频在线观看| 国产精品剧情在线亚洲| 成人在线视频一区| 国产人成一区二区三区影院| 国产成人在线色| 国产亚洲欧美日韩俺去了| 国产精品99久久久久| 国产日韩欧美在线一区| 丰满岳乱妇一区二区三区| 国产精品美女久久久久aⅴ| 9人人澡人人爽人人精品| 亚洲欧美视频在线观看视频| 在线免费观看成人短视频| 亚洲国产wwwccc36天堂| 日韩欧美在线1卡| 国产一区二区主播在线| 国产精品麻豆久久久| 99re免费视频精品全部| 一区二区高清视频在线观看| 欧美日韩你懂得| 久久国产乱子精品免费女| 久久久久国产精品麻豆| 成人高清免费观看| 一区二区欧美国产| 717成人午夜免费福利电影| 久久99精品久久久久婷婷| 国产欧美日韩麻豆91| 色视频欧美一区二区三区| 午夜精品福利一区二区蜜股av| 欧美大片在线观看一区二区| 成人黄色在线网站| 亚洲一区二区av在线| 精品国产乱码久久久久久浪潮| 福利一区二区在线| 五月婷婷色综合| 国产三级欧美三级日产三级99| 色综合天天综合狠狠|