?? lendbook.aspx.vb
字號:
Imports System.Data.SqlClient
Public Class LendBook
Inherits System.Web.UI.Page
#Region " Web 窗體設計器生成的代碼 "
'該調用是 Web 窗體設計器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents txtUserID As System.Web.UI.WebControls.TextBox
Protected WithEvents txtBookID As System.Web.UI.WebControls.TextBox
Protected WithEvents ListDGrid As System.Web.UI.WebControls.DataGrid
Protected WithEvents LendBtn As System.Web.UI.WebControls.LinkButton
Protected WithEvents UserHolder As System.Web.UI.WebControls.PlaceHolder
'注意: 以下占位符聲明是 Web 窗體設計器所必需的。
'不要刪除或移動它。
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法調用是 Web 窗體設計器所必需的
'不要使用代碼編輯器修改它。
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此處放置初始化頁的用戶代碼
If txtUserID.Text.ToString.Trim <> "" Then
Dim obj As LoadUser = Me.LoadControl("LoadUser.ascx")
If obj.LoadUserInfo(txtUserID.Text.ToString.Trim) = False Then
Response.Write("<script>javascript:alert('該用戶不存在或為非激活狀態!!!');</script>")
Else
UserHolder.Controls.Clear()
UserHolder.Controls.Add(obj)
End If
End If
End Sub
Private Sub BindDBGrid()
Dim sqlstr As String = "select * from BookInfo,LendInfo where BookInfo.BookID=LendInfo.BookID and IsBack=0 and UserID='" + txtUserID.Text.ToString + "'"
Dim obj As DBController = New DBController
obj.BindDBGrd(sqlstr, ListDGrid)
End Sub
Private Function GetBookID() As String
Dim sqlstr As String = "select BookID from BookInfo where BarCode='" + txtBookID.Text.ToString.Trim + "'"
Dim BookID As String = ""
Dim obj As DBController = New DBController
Dim myreader As SqlDataReader = obj.ExecReaderSql(sqlstr)
If myreader.Read Then
BookID = myreader("BookID")
End If
obj.Close()
Return BookID
End Function
Private Sub LendBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LendBtn.Click
Dim str As String = ""
Dim BookID As String = GetBookID()
Dim obj As BookController = New BookController
If obj.GetCurNum(txtUserID.Text) >= obj.GetMax(txtUserID.Text.ToString) Then
Response.Write("<script>javascript:alert('借書數已滿!!!');</script>")
Return
End If
Dim state As Integer = obj.GetBookState(BookID)
If state = 1 Then
obj.LendBook(txtUserID.Text.ToString.Trim, BookID)
ElseIf state = 0 And obj.IsUserBooking(txtUserID.Text.ToString.Trim, BookID) Then
obj.LendBook(txtUserID.Text.ToString.Trim, BookID)
obj.CancelBooking(txtUserID.Text.ToString.Trim, BookID)
Else
Select Case state
Case -2 : Response.Write("<script>javascript:alert('此書不在流通狀態或此書不存在!!!');</script>")
Case -1 : Response.Write("<script>javascript:alert('此書不在書架上!!!');</script>")
Case 0 : Response.Write("<script>javascript:alert('此書已經有人預約!!!');</script>")
End Select
End If
BindDBGrid()
End Sub
Private Sub txtUserID_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtUserID.TextChanged
End Sub
End Class
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -