28,391
社区成员
发帖
与我相关
我的任务
分享
sDt1 = "2010-9-1 7:30:00"
sDt2 = "2010-10-1 7:30:00"
days = DateDiff( "d", sDt1,sDt2)
MsgBox CStr(days),vbSystemModal
sDt2 = sDt1
Set conn = CreateObject("ADODB.Connection")
strConn = "Driver={SQL Server};Server=(local);Database=UserDatabase;Uid=;Pwd=;"
conn.Open strConn
For i = 1 To days
sDt1 = sDt2
sDt2 = DateAdd("d",1,sDt2)
Set rs = CreateObject("ADODB.Recordset")
strSQL = "select * from AirRecord where Kid in(56,57,58,59,60,61,62,63,64,67,68,71,73,74,75,76,78,81,86,89,90,92,93,94,95) "
strSQL = strSQL & " And (Rdt between '"+sDt1+"' and '"+sDt2+"') order by Rdt,Kid"
rs.Open strSQL,conn,2,2
If rs.EOF = False And rs.BOF = False Then
rs.MoveFirst
ts5 = rs("Hours")
For i1 = 1 To 24
rs.MoveNext
ts5 = ts5 + rs("Hours")
Next
rs.MoveLast
tz5 = rs("Hours")
For j1 = 1 To 24
rs.MovePrevious
tz5 = tz5 + rs("Hours")
Next
End If
rs.Close
MsgBox CStr(tz5 - ts5),vbSystemModal
Next
conn.Close
Set rs = Nothing
Set conn = Nothing