DAL/BorrowBookDAL.cs

（开头部分） 7KB

这里只显示每个文件的开头 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 BorrowBookDAL
    {
       #region //借书
       public bool BorrBook(BorrowBook borrBook)
       {
           //借书添加数据SQL
           string strSql = "insert into BorrowBook(borrowerId,bookId,borTime,shouldReturnTime,borrInfo,status) values('" + borrBook.BorrowerId + "','" + borrBook.BookId + "','"+ borrBook.BorTime+"','"+ borrBook.ShouldReturnTime +"','"+ borrBook.BorrInfo+"','借书')";
           try{
               if (DBHelper.changeData(strSql) > 0)
               {
                   //修改bookDetail表
                   string strBookSql = "update BookDetail set status = '借出' where bookId ='"+ borrBook.BookId+"'";
                   if (DBHelper.changeData(strBookSql) > 0)
                   {
                       //修改Borrower表
                       string strBorrSql = "update Borrower set bookAccount = bookAccount+1 where borrowerId='"+ borrBook.BorrowerId +"' ";
                       if (DBHelper.changeData(strBorrSql) > 0)
                       {
                           return true;
                       }
                       else {
                           return false;
                       }
                   }
                   else {
                       return false;
                   }
               }
               else
               {
                   return false;
               }
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       #endregion
       #region //还书
       public bool ReturnBook(BorrowBook borrBook)
       {

           //还书：根据图书编号、借阅者编号，将图书状态改为：还书
           string strSql = "update borrowBook set status ='还书',returnTime ='"+ borrBook.ReturnTime +"',borrInfo ='"+ borrBook.BorrInfo+"' where borrowerId ='"+ borrBook.BorrowerId +"' and bookId ='"+ borrBook.BookId +"'";
           try
           {
               if (DBHelper.changeData(strSql) > 0)
               {
后面还有 149 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。