毕业论文论文范文课程设计实践报告法律论文英语论文教学论文医学论文农学论文艺术论文行政论文管理论文计算机安全
您现在的位置: 毕业论文 >> 论文 >> 正文

.NET+SQL SERVER 2000图书管理系统流程图+功能图+ER+全套设计论文 第23页

更新时间:2007-9-25:  来源:毕业论文

 End Function

    Public Function GetRowsNum(ByVal sqlstr As String) As Integer

        If myConn.State = ConnectionState.Closed Then

            myConn.Open()

        End If

 

        Fill(sqlstr)

        myConn.Close()

        Return ds.Tables(0).Rows.Count

    End Function

 

    Public Function GetBookState(ByVal BookID As String) As Integer

 

        Dim sqlstr As String = "select * from BookInfo where BookState=1 and  BookID=" + BookID

        If GetRowsNum(sqlstr) = 0 Then

            Return -2

        End If

 

        sqlstr = "select * from LendInfo where IsBack=0 and BookID =" + BookID

        If GetRowsNum(sqlstr) <> 0 Then

            Return -1

        End If

 

        sqlstr = "select * from BookingInfo where  BookID=" + BookID

        If GetRowsNum(sqlstr) <> 0 Then

            Return 0

        End If

 

        Return 1

 

    End Function

    Public Function GetBookDate(ByVal UserID As String) As Integer

        Dim sqlstr As String = "select BookDate from UserInfo where UserID='" + UserID + "'"

 

        Dim myreader As SqlDataReader = ExecReaderSql(sqlstr)

        Dim num As Integer = 0

        If myreader.Read Then

            num = myreader("BookDate")

        End If

        myConn.Close()

        Return num

    End Function

    Public Function LendBook(ByVal UserID As String, ByVal BookID As String) As Boolean

        Dim datenum As Integer = GetBookDate(UserID)

 << 上一页  [21] [22] [23] [24] [25] 下一页

.NET+SQL SERVER 2000图书管理系统流程图+功能图+ER+全套设计论文 第23页下载如图片无法显示或论文不完整,请联系qq752018766
设为首页 | 联系站长 | 友情链接 | 网站地图 |

copyright©751com.cn 辣文论文网 严禁转载
如果本毕业论文网损害了您的利益或者侵犯了您的权利,请及时联系,我们一定会及时改正。