lplane.cls

本系统本系统采用VB6.0+SQL2000,紧扣旅游的关键要素,进述如何对这些旅游资源进行管理,具有很强的实用性,既可以作为独立的系统使用,也可以作为旅游企业综合业务管理系统的一个重要组成部分,本系统

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "lplane"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'1 lid Int 线路编号
'2 direct  Int 往返方向（1 往，2 返）
'3 pid Int 飞机信息编号

Public lid As Long
Public direct As Integer
Public Pid As Long

Public Sub Init()
  lid = 0
  direct = 0
  Pid = 0
End Sub

'删除指定线路的所有飞机信息
Public Sub DeleteLine(ByVal Tmplid As Long)
  DB_Connect
  
  SqlStmt = "DELETE FROM lplane WHERE lid=" + Trim(Tmplid)
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

'删除指定线路飞机信息
Public Sub Delete(ByVal Tmplid As Long, _
                  ByVal TmpDirect As Integer)
  DB_Connect
  
  SqlStmt = "DELETE FROM lplane WHERE lid=" + Trim(Tmplid) _
          + " And direct=" + Trim(TmpDirect)
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal Tmplid As Long, _
                        ByVal TmpDirect As Integer) As Boolean
  lid = Tmplid
  direct = TmpDirect
  
  DB_Connect
  
  SqlStmt = "SELECT * FROM lplane WHERE lid=" + Trim(Tmplid) _
          + " And direct=" + Trim(TmpDirect)
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetInfo = False
    Init
  Else
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 3, 1, ColVal, Len(ColVal), pcblen)
    Pid = Val(ColVal)
    
    GetInfo = True
  End If
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Function

Public Sub Insert()
  DB_Connect
  
  SqlStmt = "INSERT INTO lplane VALUES(" + Trim(lid) + "," _
          + Trim(direct) + "," + Trim(Pid) + ")"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

'判断指定的飞机信息是否在线路中
Public Function PlaneInLine(ByVal TmpPid As Long) As Long
  DB_Connect
  
  SqlStmt = "SELECT lid FROM lplane WHERE pid=" _
          + Trim(TmpPid)
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) <> SQL_NO_DATA_FOUND Then
    ColVal = String(400, 0)
    Rc = SQLGetData(Hstmt, 1, 1, ColVal, Len(ColVal), pcblen)
    PlaneInLine = Val(ColVal)
  Else
    PlaneInLine = 0
  End If
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Function