readerbookdetails.aspx.cs

一个使用ASP。net和SQLServer2005开发的图书管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyLibrary.BusinessLogicLayer;
using MyLibrary.DataAccessLayer;

public partial class BookManage_ReaderBookDetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ShowBookDetails();
        }
    }
    //显示书刊详细信息
    private void ShowBookDetails()
    {
        int bookID = int.Parse(Request["bookID"].ToString());//取出传递过来的书号
        Book book = new Book();//创建Book对象
        if (book.LoadData(bookID))//根据书号查询书刊详细信息，如果查询到
        {
            txtName.Text = book.BookName;//将书刊信息赋给相应控件显示
            txtISBN.Text = book.BookISBN;
            txtAuthor.Text = book.BookAuthor;
            txtPublish.Text = book.BookPublish;
            txtPublishDate.Text = book.BookPublishDate.Year.ToString() + "年" + book.BookPublishDate.Month.ToString()+"月";
            txtClassify.Text = book.BookClassify;
            txtSubject.Text = book.BookSubject;
            txtIndex.Text = book.BookIndex;
            txtPrice.Text = book.BookPrice + "元";
            txtPageNum.Text = book.BookPageNum.ToString();
            txtSeries.Text = book.BookSeries;
            txtDescription.Text = book.BookDescription;
            DataBase db = new DataBase();//创建DataBase类对象
            if (db.GetRecord("select * from Borrow where BookID=" + bookID + " and BorrowState=0"))//查询该图书是否可借
            {
                txtGuanCang.Text = "不可借";
            }
            else
            {
                txtGuanCang.Text = "可借";
            }
        }
        else
        {
            Response.Write("显示图书信息失败！");
        }
    }
}