DAL/BookDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace DAL
{
   public class BookDAL
    {
       #region //查找该图书是否存在
       public BookDetail bookCheck(string bookId)
       {
           string strSql = "select * from bookDetail where bookId='" + bookId + "'";
           SqlConnection conn = DBHelper.CreatConn();
           DataTable dt = DBHelper.GetTable(strSql);
           BookDetail model = new BookDetail();
           if (dt.Rows.Count > 0)
           {
               model.Status = dt.Rows[0]["status"].ToString();
               return model;
           }
           return null;
       }
       #endregion
       #region //查找该图书是否已借出
       public BookDetail LendCheck(BookDetail book)
       {
           string strSql = "select * from bookDetail where bookId='" + book.BookId + "'";
           SqlConnection conn = DBHelper.CreatConn();
           DataTable dt = DBHelper.GetTable(strSql);
           BookDetail model = new BookDetail();
           if (dt.Rows.Count > 0)
           {
               return model;
           }
           return null;
       }
       #endregion
       #region //新书上架
       public bool AddBook(BookDetail book)
       {
           string strSql = "insert into BookDetail values('" + book.BookId + "','" + book.BookTypeID + "','" + book.BookName + "','"+ book.Publisher +"','"+ book.Author +"','"+ book.Status +"','"+book.BookPrice+"','"+ book.BookPage +"','"+ book.CheckDate +"','"+ book.BookInfo +"')";
           try
           {
               if (DBHelper.changeData(strSql) > 0)
               {
                   return true;
               }
               else
               {
                   return false;
               }
           }
           catch (Exception ex)
           {
               throw ex;
           }