bookinfo.cs

一个基于.NETFramework架构的图书管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DataAccess
{
    public class BookInfo
    {
        private SqlCommand cmd;
        public BookInfo()
        {
            cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
        }
        public DataSet GetBookInfo(string bookname, string booktypeno)
        {
            if (bookname == null)
                throw new ArgumentNullException("bookname");
            if (booktypeno == null)
                throw new ArgumentNullException("booktypeno");
            cmd.Parameters.Clear();
            cmd.CommandText = "GetBookInfoByBookTypeNoAndBookName";
            cmd.Parameters .Add ("@BookName",SqlDbType.NVarChar ,50).Value =bookname ;
            cmd.Parameters .Add("@BookTypeNo",SqlDbType .Char ,10).Value =booktypeno ;
            DataSet ds = DBAccess.QueryData(cmd);
            return ds;
        }
        public DataSet GetBookInfo(string bookno)
        {
            if (bookno == null)
                throw new ArgumentNullException("bookno");
            cmd.Parameters.Clear();
            cmd.CommandText = "GetBookInfoByBookNo";
            cmd.Parameters .Add ("@BookNo",SqlDbType.Char ,15).Value =bookno ;
            DataSet ds = DBAccess.QueryData(cmd);
            return ds;

        }
        public DataSet GetBookInfo(string isbn, string bookname, string author, string booktypeno)
        {
            if (isbn == null)
                throw new ArgumentNullException("isbn");
            if (bookname == null)
                throw new ArgumentNullException("bookname");
            if (author == null)
                throw new ArgumentNullException("author");
            if (booktypeno == null)
                throw new ArgumentNullException("booktypeno");
            cmd.Parameters.Clear();
            cmd.CommandText = "GetBookInfoByCondition";
            cmd.Parameters .Add (" @ISBN",SqlDbType.Char ,20).Value =isbn ;
            cmd.Parameters .Add ("@BookName",SqlDbType .NVarChar ,50).Value =bookname ;
            cmd.Parameters .Add ("@Author",SqlDbType .NVarChar ,40).Value =author ;
            cmd.Parameters .Add ("@BookTypeNo",SqlDbType .Char ,10).Value =booktypeno;
            DataSet ds = DBAccess.QueryData(cmd);
            return ds;
        }
        public DataSet GetAllBookBooktype()
        {
            cmd.CommandText = "GetAllBookType";
            DataSet ds = DBAccess.QueryData(cmd);
            return ds;
        }
        public DataSet GetBookStatisticInfo()
        {
            cmd.CommandText = "GetBookStatisticInfo";
            DataSet ds = DBAccess.QueryData(cmd);
            return ds;
        }
        public bool DeleteBook(string bookno)
        {
            if (bookno == null)
                throw new ArgumentNullException("bookno");
            cmd.Parameters.Clear();
            cmd.CommandText = "DeleteBook";
            cmd.Parameters .Add ("@BookNo",SqlDbType.Char ,15).Value =bookno ;
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }
        }
        public bool InsertNewBook(string bookno, string isbn, string bookname, string author,
            DateTime publishdate, string bookversion, int wordcount, int pagecount, string publisher,
            string booktypeno)
        {
            if (bookno == null)
                throw new ArgumentNullException("bookno");
            if (bookname == null)
                throw new ArgumentNullException("bookname");
            if (booktypeno == null)
                throw new ArgumentNullException("booktypeno");
            cmd.Parameters.Clear();
            cmd.CommandText = "InsertNewBook";
            cmd.Parameters.Add("@BookNo", SqlDbType.Char, 15).Value = bookno;
            cmd.Parameters .Add ("@ISBN",SqlDbType .Char ,20).Value =isbn ;
            cmd.Parameters .Add ("@BookName",SqlDbType .NVarChar ,50).Value =bookname ;
            cmd.Parameters .Add("@Author",SqlDbType .NVarChar ,40).Value =author ;
            cmd.Parameters .Add ("@PublishDate",SqlDbType .DateTime ).Value =publishdate ;
            cmd.Parameters .Add ("@BookVersion",SqlDbType.NVarChar ,40 ).Value =bookversion ;
            cmd.Parameters .Add ("@WordCount",SqlDbType .Int ).Value =wordcount ;
            cmd.Parameters .Add ("@PageCount",SqlDbType .SmallInt ).Value =pagecount ;
            cmd.Parameters .Add ("@Publisher",SqlDbType .NVarChar ,40).Value =publisher ;
            cmd.Parameters .Add ("@BookTypeNo",SqlDbType .Char ,10).Value =booktypeno ;
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }
        }
        public bool UpdateBookInfo(string bookno, string isbn, string bookname,
            string author, DateTime publishdate, string bookversion, int wordcount, 
            int pagecount, string publisher, string booktypeno)
        {
            if (bookno == null)
                throw new ArgumentNullException("bookno");
            if (bookname == null)
                throw new ArgumentNullException("bookname");
            if (booktypeno == null)
                throw new ArgumentNullException("booktypeno");
            cmd.Parameters.Clear();
            cmd.CommandText = "UpdateBookInfo";
            cmd.Parameters.Add("@BookNo", SqlDbType.Char, 15).Value = bookno;
            cmd.Parameters.Add("@ISBN", SqlDbType.Char, 20).Value = isbn;
            cmd.Parameters.Add("@BookName", SqlDbType.NVarChar, 50).Value = bookname;
            cmd.Parameters.Add("@Author", SqlDbType.NVarChar, 40).Value = author;
            cmd.Parameters.Add("@PublishDate", SqlDbType.DateTime).Value = publishdate;
            cmd.Parameters.Add("@BookVersion", SqlDbType.NVarChar, 40).Value = bookversion;
            cmd.Parameters.Add("@WordCount", SqlDbType.Int).Value = wordcount;
            cmd.Parameters.Add("@PageCount", SqlDbType.SmallInt).Value = pagecount;
            cmd.Parameters.Add("@Publisher", SqlDbType.NVarChar, 40).Value = publisher;
            cmd.Parameters.Add("@BookTypeNo", SqlDbType.Char, 10).Value = booktypeno;
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }
        }

    }
}