bookda.cs

项目名称eShop

using System;
using System.Data;
using System.Configuration;
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 System.Data.OleDb;

/// <summary>
/// BookDA 的摘要说明
/// </summary>
public class BookDA:DBObject
{
	public BookDA()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //添加图书信息
    public int AddBook(BookVO bookVO)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //添加图书信息
        using (connEShop)
        {
            string strSQL = "insert into T_BOOK(F_BOOKNAME,F_AUTHOR,F_DESC,F_PUBDATE,F_PRICE,"
              +"F_DISCOUNT,F_CATEGORYID,F_PRESS,F_PICTURE) "
              +"values(@bookName,@author,@desc,@pubDate,@price,@discount,@categoryID,@press,@picture)";
            using (OleDbCommand cmdBookAdd = new OleDbCommand(strSQL, connEShop))
            {
                cmdBookAdd.Parameters.Add(new OleDbParameter("@bookName", bookVO.BookName));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@author", bookVO.BookAuthor));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@desc", bookVO.BookDesc));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@pubDate", bookVO.BookPubDate));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@price", bookVO.BookPrice));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@discount",bookVO.BookDiscount));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@categoryID", bookVO.BookCategoryID));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@press", bookVO.BookPress));
                cmdBookAdd.Parameters.Add(new OleDbParameter("@picture", bookVO.BookPicture));

                connEShop.Open();
                flag=cmdBookAdd.ExecuteNonQuery();
            }

        }        
        return flag;
    }

    //修改图书信息
    public int ModifyBook(BookVO bookVO)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //修改图书信息
        using (connEShop)
        {
            string strSQL = "update T_BOOK set F_BOOKNAME=@bookName,F_AUTHOR=@author,"
              + "F_DESC=@desc,F_PUBDATE=@pubDate,F_PRICE=@price,F_DISCOUNT=@discount,"
              + "F_CATEGORYID=@categoryID,F_PRESS=@press,F_PICTURE=@picture where F_BOOKID=@bookID";
            using (OleDbCommand cmdBookModify = new OleDbCommand(strSQL, connEShop))
            {
                cmdBookModify.Parameters.Add(new OleDbParameter("@bookName", bookVO.BookName));
                cmdBookModify.Parameters.Add(new OleDbParameter("@author", bookVO.BookAuthor));
                cmdBookModify.Parameters.Add(new OleDbParameter("@desc", bookVO.BookDesc));
                cmdBookModify.Parameters.Add(new OleDbParameter("@pubDate", bookVO.BookPubDate));
                cmdBookModify.Parameters.Add(new OleDbParameter("@price", bookVO.BookPrice));
                cmdBookModify.Parameters.Add(new OleDbParameter("@discount", bookVO.BookDiscount));
                cmdBookModify.Parameters.Add(new OleDbParameter("@categoryID", bookVO.BookCategoryID));
                cmdBookModify.Parameters.Add(new OleDbParameter("@press", bookVO.BookPress));
                cmdBookModify.Parameters.Add(new OleDbParameter("@picture", bookVO.BookPicture));
                cmdBookModify.Parameters.Add(new OleDbParameter("@bookID", bookVO.BookID));

                connEShop.Open();
                flag = cmdBookModify.ExecuteNonQuery();
            }
        }
        return flag;
    }

    //获得图书基本信息
    public BookVO GetBookInfo(int bookID)
    {
        BookVO bookVO = new BookVO();
        string strSQL = "SELECT a.F_BOOKNAME,a.F_CATEGORYID,a.F_BOOKID,a.F_AUTHOR,a.F_DESC,"
          +"a.F_PUBDATE,a.F_PRICE,a.F_DISCOUNT,a.F_PRESS,a.F_PICTURE,b.F_CATEGORY "
          +"FROM (T_BOOK a INNER JOIN T_CATEGORY b ON a.F_CATEGORYID = b.F_CATEGORYID) where a.F_BOOKID=@bookID";
        using (connEShop)
        {
            
            using (OleDbCommand cmdGetBookInfo = new OleDbCommand(strSQL, connEShop))
            {
                cmdGetBookInfo.Parameters.Add(new OleDbParameter("@bookID",bookID));
                cmdGetBookInfo.Connection.Open();
                OleDbDataReader dtrGetBookInfo = cmdGetBookInfo.ExecuteReader();
                
                if (dtrGetBookInfo.Read())
                {
                    bookVO.BookID = bookID;
                    bookVO.BookName = dtrGetBookInfo["F_BOOKNAME"].ToString().Trim();
                    bookVO.BookAuthor = dtrGetBookInfo["F_AUTHOR"].ToString().Trim();
                    bookVO.BookDesc = dtrGetBookInfo["F_DESC"].ToString().Trim();
                    bookVO.BookPubDate = dtrGetBookInfo["F_PUBDATE"].ToString().Trim();
                    bookVO.BookPrice = Convert.ToSingle(dtrGetBookInfo["F_PRICE"].ToString().Trim());
                    bookVO.BookDiscount = Convert.ToSingle(dtrGetBookInfo["F_DISCOUNT"].ToString().Trim());
                    bookVO.BookCategoryID = Convert.ToInt32(dtrGetBookInfo["F_CATEGORYID"].ToString().Trim());
                    bookVO.BookCategory = dtrGetBookInfo["F_CATEGORY"].ToString().Trim();
                    bookVO.BookPress = dtrGetBookInfo["F_PRESS"].ToString().Trim();
                    bookVO.BookPicture = dtrGetBookInfo["F_PICTURE"].ToString().Trim();
                }
            }            
        }
        return bookVO;
    }


}