DAL/BorrowerDAL.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 BorrowerDAL
    {
         #region //查找该借阅者是否存在
         public Borrower BorrowerCheck(string borrId)
         {
             string strSql = "select * from borrower where borrowerId='" + borrId + "'";
             SqlConnection conn = DBHelper.CreatConn();
             DataTable dt = DBHelper.GetTable(strSql);
             Borrower model = new Borrower();
             if (dt.Rows.Count > 0)
             {
                 model.BookAccount = dt.Rows[0]["bookAccount"].ToString();
                 return model;
             }
             return null;
         }
         #endregion
         #region //借阅证办理
         public bool AddBorrower(Borrower borrower)
         {
             string strSql = "insert into Borrower(BorrowerId,BorrowerName,BookAccount,BorrSex,BorrWork,CheckDate,BorrAddress,BorrTel,BorrRemark) values('"+ borrower.BorrowerId +"','" + borrower.BorrowerName + "','" + borrower.BookAccount + "','" + borrower.BorrSex + "','" + borrower.BorrWork + "','" + borrower.CheckDate + "','" + borrower.BorrAddress + "','" + borrower.BorrTel + "','" + borrower.BorrRemark + "')";
             try
             {
                 if (DBHelper.changeData(strSql) > 0)
                 {
                     return true;
                 }
                 else
                 {
                     return false;
                 }
             }
             catch (Exception ex)
             {
                 throw ex;
             }
         }
         #endregion
         #region//获取所有借阅者信息
         public DataTable getBorrower()
         {
             string strSql = "select * from Borrower";
             try
             {
                 SqlConnection conn = DBHelper.CreatConn();
                 if (DBHelper.GetTable(strSql) != null)
                 {
                     return DBHelper.GetTable(strSql);
                 }
                 else