1,216
社区成员
发帖
与我相关
我的任务
分享
'票价库
Set DPMDBF_DataBase = OpenDatabase(SP_Path & "JC", 0, 0, "foxpro 2.5")
Set RsDBF = DPMDBF_DataBase.OpenRecordset("select * from PJK")
SelSQL = "SELECT VoyagePrices.*, Ports.PortName AS EndPortName" _
& " FROM VoyagePrices INNER JOIN Ports ON VoyagePrices.EndPortId = Ports.PortId" _
& " Where Year(VoyageDate)=" & Year(Now) & " And Month(VoyageDate) = " & Month(Now) & " And Day(VoyageDate) = " & Day(Now)
Set RsC = New ADODB.Recordset
RsC.CursorLocation = adUseClient
RsC.Open SelSQL, CNN, adOpenDynamic, adLockReadOnly
For i = 1 To RsC.RecordCount
'替换港口ID(新售票系统与旧售票系统)
PortID = RsC("EndPortID")
RsPort_Mdb.Filter = "New_PortID='" & PortID & "'"
If Not RsPort_Mdb.EOF Then '这里是一个循环吗?如不是EOF就执行下面的语句,但是没有没看到他如何循环,比如movenext If RsPort_Mdb("Old_PortID") <> "" Then
PortID = RsPort_Mdb("Old_PortID")
End If
End If
'更新船舶等级即舱位
CBDJ = RsC("CabinID")
RsCBDJ.Filter = "New_CabinID=" & RsC("CabinID")
If Not RsCBDJ.EOF Then
If RsCBDJ("Old_CabinID") <> "" Then
CBDJ = RsCBDJ("Old_CabinID")
End If
End If
RsDBF.AddNew
RsDBF("CBDJ") = CBDJ
RsDBF("ZDM") = PortID
RsDBF("pj1") = RsC("Price")
RsDBF.Update
RsC.MoveNext
Next