4,008
社区成员
发帖
与我相关
我的任务
分享
bValue=RunSys.OpenDatabase(3000)
If bValue=1 Then
sDtStart=RunSys.GetVTtext("DTSTART",-1)+" "+RunSys.GetVTtext("TMSTART",-1)
sDtEnd=RunSys.GetVTtext("DTEND",-1)+" "+RunSys.GetVTtext("TMEND",-1)
RunSys.CloseDatabase
End If
UserDB.OpenConnect "FameView UserData Source","","" '打开ODBC数据源
Public Function AirRecord(Sid,sDtStart,sDtEnd) '---定义计算空调机组运行时间的公用函数
Dim ts,tz,tzs
strSQL="select * from AirRecord where Kid=Sid And Rdt between sDtStart And sDtEnd order by Rdt,Kid"
UserDB.OpenRecordset strSQL,1,2,2
If UserDB.IsBOF=False And UserDB.IsEOF=False Then
UserDB.MoveFirst
ts=UserDB.GetFieldValue("Hours",4)
UserDB.MoveLast
tz=UserDB.GetFieldValue("Hours",4)
End If
UserDB.CloseRecordset
tzs=tz-ts
AirRecord=tzs
End Function
ReDim a(91)
For i0=1 To 10
a(i0-1)=AirRecord(i0,sDtStart,sDtEnd) '---a(0)----a(9)
Next
Const SqlDatabaseName = "test" ' 数据库名字'
Const SqlPassword = "123" '数据库密码'
Const SqlUsername = "sa" '数据库帐户'
Const SqlLocalName = "127.0.0.1" '数据库地址'
'数据库连接函数'
Sub ConnectionDatabase
Dim ConnStr
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请检查连接字串!"
Response.End
End If
End Sub
'默认打开数据库连接
call ConnectionDatabase()