bookdetails.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;
using MyLibrary.BusinessLogicLayer;

public partial class BookManage_BookDetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            for (int i = 2000; i < 2050; i++)
            {
                ddlYear.Items.Add(i.ToString());
            }
            for (int i = 1; i < 13; i++)
            {
                ddlMonth.Items.Add(i.ToString());
            }
            for (int i = 1; i < 32; i++)
            {
                ddlDay.Items.Add(i.ToString());
            }
            BindData();
        }
    }

    private void BindData()
    {
        int bookID = int.Parse(Request["bookID"].ToString());
        Book book = new Book();
        if (book.LoadData(bookID))
        {
            txtName.Text=book.BookName;
            txtISBN.Text=book.BookISBN;
            txtAuthor.Text=book.BookAuthor;
            txtPublish.Text = book.BookPublish;
            ddlYear.SelectedItem.Text=Convert.ToDateTime(book.BookPublishDate).Year.ToString();
            ddlMonth.SelectedItem.Text = Convert.ToDateTime(book.BookPublishDate).Month.ToString();
            ddlDay.SelectedItem.Text = Convert.ToDateTime(book.BookPublishDate).Day.ToString();
            rblClassify.SelectedItem.Text = book.BookClassify.ToString();
            txtSubject.Text = book.BookSubject;
            txtIndex.Text = book.BookIndex;
            txtPrice.Text = book.BookPrice.ToString();
            txtPageNum.Text = book.BookPageNum.ToString();
            txtSeries.Text = book.BookSeries;
            txtDescription.Text = book.BookDescription;
        }
        else
        {
            lblMessage.Text = "加载数据出错！";
        }
    }
//修改按钮单击事件
    protected void imgBtnUpdate_Click(object sender, ImageClickEventArgs e)
    {
        if (Page.IsValid)
        {
            int bookID = int.Parse(Request["bookID"].ToString());//取出传递过来的主键值
            Book book = new Book();//创建Book类对象book
            book.BookName = txtName.Text.Trim();//为book对象属性赋值
            book.BookISBN = txtISBN.Text.Trim();
            book.BookAuthor = txtAuthor.Text.Trim();
            book.BookPublish = txtPublish.Text.Trim();
            book.BookPublishDate = Convert.ToDateTime(ddlYear.SelectedItem.Text + "-" + ddlMonth.SelectedItem.Text + "-" + ddlDay.SelectedItem.Text);
            book.BookClassify = rblClassify.SelectedItem.Text;
            book.BookSubject = txtSubject.Text;
            book.BookIndex = txtIndex.Text;
            book.BookPrice = Convert.ToDouble(txtPrice.Text);
            book.BookPageNum = int.Parse(txtPageNum.Text);
            book.BookSeries = txtSeries.Text;
            book.BookDescription = txtDescription.Text;
            if (book.UpdateByProc(bookID))//使用UpdateByProc方法修改图书信息
            {
                lblMessage.Text = "成功修改书刊！";
            }
            else
            {
                lblMessage.Text = "添加修改失败！";
            }
        }
    }
}