开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
Book.cs
资源名称：BooksManagement.rar　[点击查看]
上传用户：gooyliu
上传日期：2018-09-29
资源大小：5816k
文件大小：3k
源码类别：

.net编程

开发平台：

C#

Book.cs：源码内容
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  5. using System.Data;
  6. using System.Data.SqlClient;
  9. using Model;
  11. namespace DataAccessLayer
  12. {
  13.    public  class DALBook
  14.     {
  15.         public DALBook()
  16.         {
  17.         }
  18.         public bool AddBook(BookInfo bkInfo)
  19.         {
  20.             DataBase db = new DataBase();
  21.             SqlParameter[] param = new SqlParameter[]{
  22.             new SqlParameter("@bookID",bkInfo.BookID ),  
  23.             new SqlParameter("@bookName",bkInfo.BookName ),
  24.             new SqlParameter("@bookIndex",bkInfo.BookIndex ),
  25.             new SqlParameter("@bookTypeID",bkInfo .BookTypeID ),
  26.             new SqlParameter("@author",bkInfo .Author ),
  27.             new SqlParameter("@publish",bkInfo .Publish ),
  28.             new SqlParameter("@price",bkInfo.Price ),
  29.             new SqlParameter("@publishDate",bkInfo.PublishDate ),
  30.             new SqlParameter("@abstract",bkInfo .Abstrac ),
  31.             new SqlParameter("@keyword",bkInfo .Keyword ),
  32.             new SqlParameter("@status",bkInfo.BookStatus),
  33.             new SqlParameter("@registeDate",bkInfo.RegisteDate ) };
  36.             int linecount=db.RunProc("Proc_AddBook", param);
  37.             if (linecount == -1)
  38.                 return false;
  39.             else
  40.                 return true; 
  41.         }
  42.        public DataSet SearchBook(int typeID, string queryByCol, string content)
  43.        {
  44.            DataSet ds = new DataSet();
  45.            DataBase db = new DataBase();
  46.            SqlParameter[] Params = new SqlParameter[3];
  47.            Params[0] = db.MakeInParam("@bookTypeID",SqlDbType.Int , 20, typeID);
  48.            Params[1] = db.MakeInParam("@queryByCol",SqlDbType .NVarChar, 50,queryByCol);
  49.            Params[2] = db.MakeInParam("@Content", SqlDbType .NVarChar ,50 ,content);
  50.            ds=db.GetDataSet("Proc_SearchBook", Params);
  51.            return ds;
  53.        }
  55.        public DataSet GetBookInfoByID(string XBookID)
  56.        {
  57.            DataSet ds = new DataSet();
  58.            DataBase db = new DataBase();
  59.            SqlParameter[] param = new SqlParameter[1];
  60.            param[0] = db.MakeInParam("@bookID", SqlDbType.NVarChar, 50, XBookID);
  61.            ds=db.GetDataSet("Proc_GetBookInfoByID", param);
  62.            return ds;
  64.        }
  65.        //更新一本书的信息，status和registerdate是不可更该的
  66.        public bool updateBook(BookInfo bkInfo)
  67.        {
  68.            DataBase db = new DataBase();
  69.            SqlParameter[] param = new SqlParameter[]{
  70.             new SqlParameter("@bookID",bkInfo.BookID), 
  71.             new SqlParameter("@bookName",bkInfo.BookName ),
  72.             new SqlParameter("@bookIndex",bkInfo.BookIndex ),
  73.             new SqlParameter("@bookTypeID",bkInfo .BookTypeID ),
  74.             new SqlParameter("@author",bkInfo .Author ),
  75.             new SqlParameter("@publish",bkInfo .Publish ),
  76.             new SqlParameter("@price",bkInfo.Price ),
  77.             new SqlParameter("@publishDate",bkInfo.PublishDate ),
  78.             new SqlParameter("@abstract",bkInfo .Abstrac ),
  79.             new SqlParameter("@keyword",bkInfo .Keyword )};
  82.            int linecount = db.RunProc("Proc_UpdateBookByID", param);
  83.            if (linecount == -1)
  84.                return false;
  85.            else
  86.                return true;
  88.        }
  92.     }
  93. }