book.cs

网上那个书店开发系统论文,需要的朋友可以下载参考哦

using System;
using System.Data.SqlClient;
using System.Data;
using System.Collections.Generic;
using BookManage.Model;

namespace BookManage.DAL
{
    /// <summary>
        /// 图书的相关操作
        /// </summary>
    public class Book
    {
       
        public Book() { }

        /// <summary>
        /// 添加图书
        /// </summary>
        /// <param name="bookInfo">图书的详细资料</param>
        /// <returns>添加图书的id</returns>
        public int AddBook(BookInfo bookInfo)
        {
            const string cmdText = "insert into booklist (bookName,bookDesc,bookTypeId,bookStatus,bookCode) values (@bookName,@bookDesc,@bookTypeId,0,@bookCode);select @@identity";
            SqlParameter[] param = new SqlParameter[]{
            new SqlParameter("@bookName",bookInfo.BookName),
            new SqlParameter("@bookDesc",bookInfo.BookDesc),
            new SqlParameter("@bookTypeId",bookInfo.BookTypeInfo.BookTypeId),
            new SqlParameter("@bookCode",bookInfo.BookCode)
        };
            object result = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param);
            return Convert.ToInt32(result);
        }

        /// <summary>
        /// 修改图书资料
        /// </summary>
        /// <param name="bookInfo"></param>
        /// <returns></returns>
        public int ModifyBookInfo(BookInfo bookInfo)
        {
            const string cmdText = "UPDATE BookList SET BookName =@bookName, BookDesc =@bookDesc, BookTypeId =@bookTypeId, BookCode =@bookCode where bookId=@bookId";
            SqlParameter[] param = new SqlParameter[]{
            new SqlParameter("@bookName",bookInfo.BookName),
            new SqlParameter("@bookDesc",bookInfo.BookDesc),
            new SqlParameter("@bookTypeId",bookInfo.BookTypeInfo.BookTypeId),
            new SqlParameter("@bookCode",bookInfo.BookCode),
            new SqlParameter("@bookId",bookInfo.BookId)
        };
            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param);
            return result;
        }

        /// <summary>
        /// 删除图书
        /// </summary>
        /// <param name="bookId"></param>
        /// <returns></returns>
        public int DeleteBookInfo(int bookId)
        {
            const string cmdText = "delete from BookList where BookId=@bookId";
            SqlParameter param = new SqlParameter("@bookId", bookId);
            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param);
            return result;
        }

        /// <summary>
        /// 获取图书列表
        /// </summary>
        /// <returns></returns>
        public static IList<BookInfo> GetBookList()
        {
            const string cmdText = "select bookName,bookDesc,bookTypeName,bookStatus,bookCode,bookId from booklist l,bookType t where l.bookTypeId=t.bookTypeId";
            IList<BookInfo> bookList = new List<BookInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, null))
            {
                while (dr.Read())
                {
                    BookTypeInfo bookTypeInfo = new BookTypeInfo(0,0, string.Empty, dr.GetString(2));
                    BookInfo bookInfo = new BookInfo(dr.GetString(1), dr.GetString(0), dr.GetBoolean(3), dr.GetString(4), dr.GetInt32(5), bookTypeInfo);
                    bookList.Add(bookInfo);
                }
            }
            return bookList;
        }

        /// <summary>
        /// 根据种类获取图书列表
        /// </summary>
        /// <param name="typeId"></param>
        /// <returns></returns>
        public static IList<BookInfo> GetBookListByType(int typeId)
        {
            const string cmdText = "upBookListGetByType";
            SqlParameter param = new SqlParameter("@typeId", typeId);
            IList<BookInfo> bookList = new List<BookInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, param))
            {
                while (dr.Read())
                {
                    BookTypeInfo bookTypeInfo = new BookTypeInfo(0,0, string.Empty, dr.GetString(2));
                    BookInfo bookInfo = new BookInfo(dr.GetString(1), dr.GetString(0), dr.GetBoolean(3), dr.GetString(4), dr.GetInt32(5), bookTypeInfo);
                    bookList.Add(bookInfo);
                }
            }
            return bookList;
        }

        /// <summary>
        /// 根据书名获取图书列表
        /// </summary>
        /// <param name="bookName"></param>
        /// <returns></returns>
        public static IList<BookInfo> GetBookListByName(string bookName)
        {
            const string cmdText = "select bookName,bookDesc,bookTypeName,bookStatus,bookCode,bookId from booklist l,bookType t where l.bookTypeId=t.bookTypeId and l.bookName like '%'+@bookName+'%'";
            SqlParameter param = new SqlParameter("@bookName", bookName);
            IList<BookInfo> bookList = new List<BookInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param))
            {
                while (dr.Read())
                {
                    BookTypeInfo bookTypeInfo = new BookTypeInfo(0,0, string.Empty, dr.GetString(2));
                    BookInfo bookInfo = new BookInfo(dr.GetString(1), dr.GetString(0), dr.GetBoolean(3), dr.GetString(4), dr.GetInt32(5), bookTypeInfo);
                    bookList.Add(bookInfo);
                }
            }
            return bookList;
        }

        /// <summary>
        /// 根据图书ID获取图书
        /// </summary>
        /// <param name="bookId"></param>
        /// <returns></returns>
        public IList<BookInfo> GetBookListById(int bookId)
        {
            const string cmdText = "select bookName,bookDesc,bookTypeName,bookStatus,bookCode,bookId from booklist l,bookType t where l.bookTypeId=t.bookTypeId and l.bookId=@bookId";
            SqlParameter param = new SqlParameter("@bookId", bookId);
            IList<BookInfo> bookList = new List<BookInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param))
            {
                while (dr.Read())
                {
                    BookTypeInfo bookTypeInfo = new BookTypeInfo(0,0, string.Empty, dr.GetString(2));
                    BookInfo bookInfo = new BookInfo(dr.GetString(1), dr.GetString(0), dr.GetBoolean(3), dr.GetString(4), dr.GetInt32(5), bookTypeInfo);
                    bookList.Add(bookInfo);
                }
            }
            return bookList;
        }

        /// <summary>
        /// 根据图书ID获取图书资料
        /// </summary>
        /// <param name="bookId"></param>
        /// <returns></returns>
        public BookInfo GetBookById(int bookId)
        {
            const string cmdText = "select bookName,bookDesc,bookTypeId,bookCode from booklist where bookId=@bookId";
            SqlParameter param = new SqlParameter("@bookId", bookId);
            BookInfo bookInfo = new BookInfo();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param))
            {
                while (dr.Read())
                {
                    BookTypeInfo bookTypeInfo = new BookTypeInfo(dr.GetInt32(2),0, string.Empty, string.Empty);
                    bookInfo = new BookInfo(dr.GetString(1), dr.GetString(0), true, dr.GetString(3), 0, bookTypeInfo);
                }
            }
            return bookInfo;
        }
    }

        /// <summary>
        /// 图书种类的相关操作
        /// </summary>
    public class BookType
    {
       
        public BookType() { }

        /// <summary>
        /// 获取图书种类列表
        /// </summary>
        /// <returns></returns>
        public IList<BookTypeInfo> GetBookTypeList()
        {
            const string cmdText = "select bookTypeId,BookTypeName,levelId from BookType order by rootTypeId,orderId";
            IList<BookTypeInfo> bookTypeInfo = new List<BookTypeInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, null))
            {
                while (dr.Read())
                {
                    BookTypeInfo bti = new BookTypeInfo(dr.GetInt32(0),dr.GetInt32(2), string.Empty, dr.GetString(1));
                    bookTypeInfo.Add(bti);
                }
            }
            return bookTypeInfo;
        }

        /// <summary>
        /// 获取包括描述的图书种类列表
        /// </summary>
        /// <returns></returns>
        public IList<BookTypeInfo> GetBookTypeListWithDesc()
        {
            const string cmdText = "select bookTypeId,BookTypeName,levelId,BookTypeDesc from BookType order by rootTypeId,orderId";
            IList<BookTypeInfo> bookTypeInfo = new List<BookTypeInfo>();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, null))
            {
                while (dr.Read())
                {
                    BookTypeInfo bti = new BookTypeInfo(dr.GetInt32(0), dr.GetInt32(2), dr.GetString(3), dr.GetString(1));
                    bookTypeInfo.Add(bti);
                }
            }
            return bookTypeInfo;
        }

        /// <summary>
        /// 添加图书种类
        /// </summary>
        /// <param name="typeInfo"></param>
        /// <returns>添加命令影响的行数</returns>
        public int AddBookType(BookTypeInfo typeInfo)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@parentTypeId",typeInfo.ParentTypeId),
                new SqlParameter("@typeName",typeInfo.BookTypeName),
                new SqlParameter("@typeDesc",typeInfo.BookTypeDesc)
            };

            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "upBookTypeAdd", param);
            return result;
        }

        /// <summary>
        /// 删除图书种类
        /// </summary>
        /// <param name="bookTypeId"></param>
        /// <returns></returns>
        public int DeleteBookType(int bookTypeId)
        {
            const string cmdText = "upBookTypeDel";
            SqlParameter param = new SqlParameter("@id", bookTypeId);
            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure,cmdText, param);
            return result;
        }

        /// <summary>
        /// 修改图书种类
        /// </summary>
        /// <param name="typeInfo"></param>
        /// <returns></returns>
        public int ModifyBookType(BookTypeInfo typeInfo)
        {
            const string cmdText = "update bookType set bookTypeDesc=@typeDesc,bookTypeName=@typeName where bookTypeId=@id";
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@id",typeInfo.BookTypeId),
                new SqlParameter("@typeName",typeInfo.BookTypeName),
                new SqlParameter("@typeDesc",typeInfo.BookTypeDesc)
            };
            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param);
            return result;
        }

        /// <summary>
        /// 根据ID获取图书种类信息
        /// </summary>
        /// <param name="bookTypeId"></param>
        /// <returns></returns>
        public BookTypeInfo GetBookTypeById(int bookTypeId)
        {
            const string cmdText = "select booktypeName,booktypeDesc,parentTypeId from bookType where bookTypeId=@id";
            SqlParameter param = new SqlParameter("@id", bookTypeId);
            BookTypeInfo typeInfo = new BookTypeInfo();
            using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, cmdText, param))
            {
                while (dr.Read())
                {
                    typeInfo = new BookTypeInfo(bookTypeId, dr.GetString(1), dr.GetString(0), dr.GetInt32(2));
                }
            }
            return typeInfo;
        }
    }
}