bookadd.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;

public partial class BookManage_BookAdd : 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());
            }
        }
        else
        { }
    }
    //添加按钮单击事件
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        if (Page.IsValid)
        {
            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.InsertByProc())//使用InsertByProc方法向数据库添加图书信息
            {
                lblMessage.Text = "成功添加书刊！";
            }
            else
            {
                lblMessage.Text = "添加书刊失败！";
            }                
        }
    }
}