returnbook.aspx.cs

图书馆管理系统 包含有数据库等 和详细的页面设计 是一个不错的程序

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;

public partial class BookBRManage_ReturnBook : System.Web.UI.Page
{
    ReaderManage readermanage = new ReaderManage();
    RTypeManage rtypemanage = new RTypeManage();
    BookManage bookmanage = new BookManage();
    BTypeManage btypemanage = new BTypeManage();
    BorrowandBackManage borrowandbackmanage = new BorrowandBackManage();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "图书归还页面";
        if (!IsPostBack)
        {
            if (Session["role"] == "Reader")
            {
                txtReaderID.Text = Session["readid"].ToString();
            }
        }
    }
    protected void btnSure_Click(object sender, EventArgs e)
    {
        if (txtReaderID.Text == "")
        {
            Response.Write("<script>alert('读者编号不能为空！')</script>");
        }
        else
        {
            readermanage.ID = txtReaderID.Text;
            DataSet readerds = readermanage.FindReaderByCode(readermanage, "tb_reader");
            if (readerds.Tables[0].Rows.Count > 0)
            {
                txtReader.Text = readerds.Tables[0].Rows[0][1].ToString();
                txtSex.Text = readerds.Tables[0].Rows[0][2].ToString();
                txtPaperType.Text = readerds.Tables[0].Rows[0][5].ToString();
                txtPaperNum.Text = readerds.Tables[0].Rows[0][6].ToString();
                txtRType.Text = readerds.Tables[0].Rows[0][3].ToString();
            }
            else
            {
                Response.Write("<script>alert('该读者不存在！')</script>");
                return;
            }

            rtypemanage.Name = txtRType.Text;
            DataSet rtypeds = rtypemanage.FindRTypeByName(rtypemanage, "tb_readertype");
            txtBNum.Text = rtypeds.Tables[0].Rows[0][2].ToString();

            gvBRBookBind();
            Session["readerid"] = txtReaderID.Text;
        }
    }
    protected void gvBorrowBook_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvBorrowBook.PageIndex = e.NewPageIndex;
        gvBRBookBind();
    }
    protected void gvBorrowBook_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        if (Session["readerid"] == null)
        {
            Response.Write("<script>alert('请输入读者编号！')</script>");
        }
        else
        {      
            borrowandbackmanage.ID = gvBorrowBook.DataKeys[e.RowIndex].Value.ToString();
            borrowandbackmanage.SJBackTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            borrowandbackmanage.BackOper = Session["Name"].ToString();
            borrowandbackmanage.IsBack = true;
            borrowandbackmanage.UpdateBackBook(borrowandbackmanage);
            gvBRBookBind();

            readermanage.ID = Session["readerid"].ToString();
            DataSet readerds = readermanage.FindReaderByCode(readermanage, "tb_reader");
            readermanage.BorrowNum = Convert.ToInt32(readerds.Tables[0].Rows[0][12].ToString());
            readermanage.Num = Convert.ToInt32(readerds.Tables[0].Rows[0][13].ToString()) - 1;
            readermanage.UpdateBorrowNum(readermanage);
        }
    }
    protected void gvBRBookBind()
    {
        borrowandbackmanage.ReadID = txtReaderID.Text;
        DataSet brinfods = borrowandbackmanage.FindBoBaBookByRID(borrowandbackmanage, "view_BookBRInfo");
        gvBorrowBook.DataSource = brinfods;
        gvBorrowBook.DataKeyNames = new string[] { "id" };
        gvBorrowBook.DataBind();
    }
}