DAL/FineDAL.cs

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

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

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

namespace DAL
{
   public class FineDAL
    {
       #region //添加惩罚
       public bool AddFine(FineDetail fineDetail)
       {
           //添加惩罚记录
           string strSql = "insert into fineDetail(BookId,BorrowerId,Status,OverDays,FineMoney,CheckDate,info) values('" + fineDetail.BookId + "','" + fineDetail.BorrowerId + "','" + fineDetail.Status + "','" + fineDetail.OverDays + "','" + fineDetail.FineMoney + "','" + fineDetail.CheckDate + "','"+ fineDetail.Info+"')";
           try
           {
               if (DBHelper.changeData(strSql) > 0)
               {
                   //修改图书的状态为丢失
                   string strsql = "update bookDetail set status ='丢失' where bookId = '"+ fineDetail.BookId +"'";
                   if (DBHelper.changeData(strsql) > 0)
                   {
                       return true;
                   }
                   else {
                       return false;
                   }
               }
               else
               {
                   return false;
               }
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       #endregion
       #region//获取所有罚单
       public DataTable getFine()
       {
           string strSql = "select * from FineDetail";
           try
           {
               if (DBHelper.GetTable(strSql) != null)
               {
                   return DBHelper.GetTable(strSql);
               }
               else
                   return null;
           }
           catch (Exception e)
           {
               throw e;
           }
       }
       #endregion