C#超详解做三层架构的图书管理系统——窗体界面

最新推荐文章于 2024-01-25 21:19:58 发布

择柒

最新推荐文章于 2024-01-25 21:19:58 发布

阅读量6k

点赞数 12

分类专栏：项目

本文链接：https://blog.csdn.net/weixin_44162158/article/details/103567351

版权

项目专栏收录该内容

1 篇文章 0 订阅

订阅专栏

三层架构包含BLL，DAL，model，需要连接数据库。

这个系统包含四张表，分别为图书管理员，图书信息表，借阅信息表，借阅人信息表；

建立TestDB数据库，包含如下四张表，

建好四张表后，

做七个界面，分别是：

做好七个界面后，开始底层的三层架构，分别连接数据库的四张表，如下图所示：

其中，图书信息表的BLL为：

using BooksSystem.DAL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.BLL
{
     public class tblBookInfoBLL
    {
        private readonly tblBookInfoDAL dal = new tblBookInfoDAL();
        public tblBookInfoBLL()
        { }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="BookID">用户名</param>
        /// <returns></returns>
        public bool Exists(string BookID)
        {
            return dal.Exists(BookID);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblBookInfoModel model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblBookInfoModel model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string BookID)
        {

            dal.Delete(BookID);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblBookInfoModel GetModel(string BookID)
        {

            return dal.GetModel(BookID);
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<tblBookInfoModel>  GetList(string BookID,string BookName,string BookType,string StatusIndex,bool shangjia =false)
        {
            DataSet ds = dal.GetList(BookID, BookName, BookType, StatusIndex,shangjia);
            List<tblBookInfoModel> modelList = new List<tblBookInfoModel>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {

                for (int n = 0; n < rowsCount; n++)
                {
                    tblBookInfoModel model = new tblBookInfoModel();
                    model.BookID = ds.Tables[0].Rows[n]["BookID"].ToString();
                    model.BookName = ds.Tables[0].Rows[n]["BookName"].ToString();
                    model.BookType = ds.Tables[0].Rows[n]["BookType"].ToString();
                    model.BookCount = Convert.ToInt16(ds.Tables[0].Rows[n]["BookID"]);
                    model.BookJieCount = Convert.ToInt16(ds.Tables[0].Rows[n]["BookJieCount"]);
                    model.BookStatus = ds.Tables[0].Rows[n]["BookStatus"].ToString();
                    modelList.Add(model);
                }
            }
            return modelList;
        }
        #endregion
    }
}

图书管理员BLL为：

using BooksSystem.DAL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace BooksSystem.BLL
{
  public  class tblUserInfoBLL
    {
        private readonly tblUserInfoDAL dal = new tblUserInfoDAL();


        public tblUserInfoBLL()
        { }
        #region  成员方法
       

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="id">用户名</param>
        /// <param name="password">密码</param>
        /// <returns></returns>
        public bool Exists(string id, string password)
        {
            return dal.Exists(id, password);
        }
    

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblUserInfoModel model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblUserInfoModel model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string id)
        {

            dal.Delete(id);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblUserInfoModel GetModel(string id)
        {

            return dal.GetModel(id);
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            return dal.GetList(strWhere);
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<tblUserInfoModel> GetModelList(string strWhere)
        {
            DataSet ds = dal.GetList(strWhere);
            List<tblUserInfoModel> modelList = new List<tblUserInfoModel>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {
                tblUserInfoModel model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new tblUserInfoModel();
                    model.id = ds.Tables[0].Rows[n]["id"].ToString();
                    model.password = ds.Tables[0].Rows[n]["password"].ToString();
                  
                    modelList.Add(model);
                }
            }
            return modelList;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetAllList()
        {
            return GetList("");
        }

        #endregion
    }
}

借阅信息表BLL为：

using BooksSystem.DAL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.BLL
{
    public class tblJieYueInfoBLL
    {
        private readonly tblJieYueInfoDAL dal = new tblJieYueInfoDAL();
        public tblJieYueInfoBLL()
        { }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="BookID">用户名</param>
        /// <returns></returns>
        public bool Exists(string BookID, string JieYueRenID = "", int IsJieshu = 0)
        {
            return dal.Exists(BookID, JieYueRenID, IsJieshu);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblJieYueInfoModel model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblJieYueInfoModel model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string BookID)
        {

            dal.Delete(BookID);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblJieYueInfoModel GetModel(string BookID, string JieYueRenID)
        {

            return dal.GetModel(BookID, JieYueRenID);
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            return dal.GetList(strWhere);
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<tblJieYueInfoModel> GetModelList(string strWhere)
        {
            DataSet ds = dal.GetList(strWhere);
            List<tblJieYueInfoModel> modelList = new List<tblJieYueInfoModel>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {
                tblJieYueInfoModel model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new tblJieYueInfoModel();
                    model.BookID = ds.Tables[0].Rows[n]["BookID"].ToString();
                    model.JieYueREnID = ds.Tables[0].Rows[n]["JieYueREnID"].ToString();
                    model.Status =Convert.ToInt16(ds.Tables[0].Rows[n]["Status"]);
                   
                    modelList.Add(model);
                }
            }
            return modelList;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetAllList()
        {
            return GetList("");
        }

        #endregion
    }
}

借阅人信息表BLL为：

using BooksSystem.DAL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.BLL
{
   public class tblJieYueREnInfoBLL
    {
        private readonly tblJieYueREnInfoDAL dal = new tblJieYueREnInfoDAL();
        public tblJieYueREnInfoBLL()
        { }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="JieYueRenID">用户名</param>
        /// <returns></returns>
        public bool Exists(string JieYueRenID)
        {
            return dal.Exists(JieYueRenID);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblJieYueREnInfoModel model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblJieYueREnInfoModel model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string JieYueRenID)
        {

            dal.Delete(JieYueRenID);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblJieYueREnInfoModel GetModel(string JieYueRenID)
        {

            return dal.GetModel(JieYueRenID);
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<tblJieYueREnInfoModel> GetList(string txtRenID,string txtRenName,string cmbStatus)
        {
            DataSet ds = dal.GetList(txtRenID, txtRenName, cmbStatus);
            List<tblJieYueREnInfoModel> modelList = new List<tblJieYueREnInfoModel>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {
                for (int n = 0; n < rowsCount; n++)
                {
                    tblJieYueREnInfoModel model = new tblJieYueREnInfoModel();
                    model.JieYueRenID = Convert.ToInt32(ds.Tables[0].Rows[n]["JieYueRenID"]);
                    model.JieYueRenName = ds.Tables[0].Rows[n]["JieYueRenName"].ToString();
                    model.Addr = ds.Tables[0].Rows[n]["Addr"].ToString();
                    model.Tel = Convert.ToInt32(ds.Tables[0].Rows[n]["Tel"]);
                    model.Status =Convert.ToInt16( ds.Tables[0].Rows[n]["Status"]);
                    modelList.Add(model);
                }
            }
            return modelList;
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List<tblJieYueREnInfoModel> GetModelList(string txtRenID, string txtRenName, string cmbStatus)
        {
            DataSet ds = dal.GetList( txtRenID,txtRenName,cmbStatus);
            List<tblJieYueREnInfoModel> modelList = new List<tblJieYueREnInfoModel>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {
                tblJieYueREnInfoModel model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new tblJieYueREnInfoModel();
                    model.JieYueRenID = Convert.ToInt32(  ds.Tables[0].Rows[n]["JieYueRenID"]);
                    model.JieYueRenName = ds.Tables[0].Rows[n]["JieYueRenName"].ToString();                  
                    model.Addr = ds.Tables[0].Rows[n]["Addr"].ToString();
                    model.Tel = Convert.ToInt32(ds.Tables[0].Rows[n]["Tel"]);
                    model.Status = Convert.ToInt16(ds.Tables[0].Rows[n]["Status"]);
                    modelList.Add(model);
                }
            }
            return modelList;
        }

        / <summary>
        / 获得数据列表
        / </summary>
        //public DataSet GetAllList()
        //{
        //    return GetList("");
        //}

        #endregion
    }
}

连接好BLL的四张表后

做DAL的四张表：

其中图书管理员的DAL为：

using BooksSystem.Common;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.DAL
{
   public class tblUserInfoDAL
    {
        /// <summary>
        /// 初期处理
        /// </summary>
        public tblUserInfoDAL()
        { }
        #region  成员方法
      
      
        /// <returns>存在返回true</returns>
        public bool Exists(string id, string password)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [tblUserInfo]");
            strSql.Append(" where id='" + id + "' and password='" + password + "'");
            return DbHelperSQL.Exists(strSql.ToString());
        }

  

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblUserInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.id != null)
            {
                strSql1.Append("id,");
                strSql2.Append("'" + model.id + "',");
            }
            if (model.password != null)
            {
                strSql1.Append("password,");
                strSql2.Append("'" + model.password + "',");
            }
           
            strSql.Append("insert into tblUserInfo(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblUserInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tblUserInfo set ");
            if (model.password != null)
            {
                strSql.Append("password='" + model.password + "',");
            }          
            int n = strSql.ToString().LastIndexOf(",");
            strSql.Remove(n, 1);
            strSql.Append(" where id='" + model.id + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string userID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete tblUserInfo ");
            strSql.Append(" where id='" + userID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblUserInfoModel GetModel(string userID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1  ");
            strSql.Append(" id,password ");
            strSql.Append(" from tblUserInfo ");
            strSql.Append(" where id='" + userID + "' ");
            tblUserInfoModel model = new tblUserInfoModel();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.id = ds.Tables[0].Rows[0]["id"].ToString();
                model.password = ds.Tables[0].Rows[0]["password"].ToString();
               
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select id,password ");
            strSql.Append(" FROM tblUserInfo ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        */

        #endregion  成员方法
    }
}

图书信息表的DAL为：

using BooksSystem.Common;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.DAL
{
    public class tblBookInfoDAL
    {
        /// <summary>
        /// 初期处理
        /// </summary>
        public tblBookInfoDAL()
        { }
        #region  成员方法


        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="studentID">用户名</param>
        /// <returns>存在返回true</returns>
        public bool Exists(string BookID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [tblBookInfo]");
            strSql.Append(" where BookID= '" + BookID + "' ");
            return DbHelperSQL.Exists(strSql.ToString());
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblBookInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.BookID != null)
            {
                strSql1.Append("BookID,");
                strSql2.Append("'" + model.BookID + "',");
            }
            if (model.BookName != null)
            {
                strSql1.Append("BookName,");
                strSql2.Append("'" + model.BookName + "',");
            }
            if (model.BookType != null)
            {
                strSql1.Append("BookType,");
                strSql2.Append("'" + model.BookType + "',");
            }
            if (model.BookCount != null)
            {
                strSql1.Append("BookCount,");
                strSql2.Append("'" + model.BookCount + "',");
            }
            if (model.BookJieCount != null)
            {
                strSql1.Append("BookJieCount,");
                strSql2.Append("'" + model.BookJieCount + "',");
            }
            if (model.BookStatus != null)
            {
                strSql1.Append("BookStatus,");
                strSql2.Append("'" + model.BookStatus + "',");
            }
            strSql.Append("insert into tblBookInfo(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblBookInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tblBookInfo set ");
            if (model.BookID != null)
            {
                strSql.Append("BookID='" + model.BookID + "',");
            }
            if (model.BookName != null)
            {
                strSql.Append("BookName='" + model.BookName + "',");
            }
            if (model.BookType != null)
            {
                strSql.Append("BookType='" + model.BookType + "',");
            }
            if (model.BookCount != null)
            {
                strSql.Append("BookCount='" + model.BookCount + "',");
            }
            if (model.BookJieCount != null)
            {
                strSql.Append("BookJieCount='" + model.BookJieCount + "',");
            }
            if (model.BookStatus != null)
            {
                strSql.Append("BookStatus='" + model.BookStatus + "',");
            }
            int n = strSql.ToString().LastIndexOf(",");
            strSql.Remove(n, 1);
            strSql.Append(" where BookID='" + model.BookID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string BookID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete tblBookInfo ");
            strSql.Append(" where BookID='" + BookID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblBookInfoModel GetModel(string BookID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1  ");
            strSql.Append(" BookID,BookName,BookType,BookCount,BookJieCount,BookStatus ");
            strSql.Append(" from tblBookInfo ");
            strSql.Append(" where BookID='" + BookID + "' ");
            tblBookInfoModel model = new tblBookInfoModel();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.BookID = ds.Tables[0].Rows[0]["BookID"].ToString();
                model.BookName = ds.Tables[0].Rows[0]["BookName"].ToString();
                model.BookType = ds.Tables[0].Rows[0]["BookType"].ToString();
                model.BookCount = Convert.ToInt32(ds.Tables[0].Rows[0]["BookCount"]);
                model.BookJieCount = Convert.ToInt32(ds.Tables[0].Rows[0]["BookJieCount"]);
                model.BookStatus = ds.Tables[0].Rows[0]["BookStatus"].ToString();
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string BookID, string BookName, string BookType, string StatusIndex,bool shangjia= false)
        {
            StringBuilder strWhere = new StringBuilder();
            if (!string.IsNullOrEmpty(BookID))
            {
                strWhere.Append(" BookID = '" + BookID + "'");
            }
            if (!string.IsNullOrEmpty(BookName))
            {
                if (strWhere.Length != 0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" BookName LIKE '%" + BookName + "%'");
            }

            if (!string.IsNullOrEmpty(BookType))
            {
                if (strWhere.Length != 0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" BookType LIKE '%" + BookType + "%'");
            }
            StringBuilder strSql = new StringBuilder();
            if(!string.IsNullOrEmpty(StatusIndex) && !StatusIndex.Equals("-1"))
            {
                if (strWhere.Length != 0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" BookStatus= '" +StatusIndex + " '");
            }
            if(shangjia)
            {
                if(strWhere.Length!=0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" BookStatus='0'");
            }
            strSql.Append("select BookID,BookName,BookType,BookCount,BookJieCount,BookStatus ");
            strSql.Append(" FROM tblBookInfo ");
            if (strWhere.ToString().Trim() != "")
            {
                strSql.Append(" where " + strWhere.ToString());
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        */

        #endregion  成员方法
    }
}

借阅信息表DAL为：

using BooksSystem.Common;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.DAL
{
    public class tblJieYueInfoDAL
    {
        /// <summary>
        /// 初期处理
        /// </summary>
        public tblJieYueInfoDAL()
        { }
        #region  成员方法


        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="studentID">用户名</param>
        /// <returns>存在返回true</returns>
        public bool Exists(string BookID, string JieYueRenID = "", int IsJieshu = 0)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [tblJieYueInfo]");
            strSql.Append(" where 1= 1 ");
            if (!string.IsNullOrEmpty(BookID))
            {
                strSql.Append(" AND BookID='" + BookID + "'");

            }
            if (!string.IsNullOrEmpty(JieYueRenID))
            {
                strSql.Append(" AND JieYueRenID='" + JieYueRenID + "'");
            }

            strSql.Append(" AND Status = " + IsJieshu);

            return DbHelperSQL.Exists(strSql.ToString());
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblJieYueInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.BookID != null)
            {
                strSql1.Append("BookID,");
                strSql2.Append("'" + model.BookID + "',");
            }
            if (model.JieYueREnID != null)
            {
                strSql1.Append("JieYueREnID,");
                strSql2.Append("'" + model.JieYueREnID + "',");
            }
            if (model.Status != null)
            {
                strSql1.Append("Status,");
                strSql2.Append("'" + model.Status + "',");
            }
          

            strSql.Append("insert into tblJieYueInfo(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblJieYueInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tblJieYueInfo set ");
            if (model.BookID != null)
            {
                strSql.Append("BookID='" + model.BookID + "',");
            }
            if (model.JieYueREnID != null)
            {
                strSql.Append("JieYueREnID='" + model.JieYueREnID + "',");
            }
            if (model.Status != null)
            {
                strSql.Append("Status='" + model.Status + "',");
            }
            

            int n = strSql.ToString().LastIndexOf(",");
            strSql.Remove(n, 1);
            strSql.Append(" where BookID='" + model.BookID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string BookID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete BookID ");
            strSql.Append(" where BookID='" + BookID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblJieYueInfoModel GetModel(string BookID, string JieYueRenID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1  ");
            strSql.Append(" BookID,JieYueRenID,Status ");
            strSql.Append(" from tblJieYueInfo ");
            strSql.Append(" where 1= 1 ");
            if (!string.IsNullOrEmpty(BookID))
            {
                strSql.Append(" AND BookID='" + BookID + "'");

            }
            if (!string.IsNullOrEmpty(JieYueRenID))
            {
                strSql.Append(" AND JieYueRenID='" + JieYueRenID + "'");
            }
            tblJieYueInfoModel model = new tblJieYueInfoModel();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.BookID = ds.Tables[0].Rows[0]["BookID"].ToString();
                model.JieYueREnID = ds.Tables[0].Rows[0]["JieYueRenID"].ToString();
                model.Status = Convert.ToInt16(ds.Tables[0].Rows[0]["Status"]);
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select BookID,JieYueRenName,Status,Tel,Status");
            strSql.Append(" FROM tblJieYueREnInfo ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        */

        #endregion  成员方法
    }
}

借阅人信息表DAL为：

using BooksSystem.Common;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BooksSystem.DAL
{
    public class tblJieYueREnInfoDAL
    {
        /// <summary>
        /// 初期处理
        /// </summary>
        public tblJieYueREnInfoDAL()
        { }
        #region  成员方法


        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="studentID">用户名</param>
        /// <returns>存在返回true</returns>
        public bool Exists(string JieYueRenID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [tblJieYueREnInfo]");
            strSql.Append(" where JieYueRenID= '" + JieYueRenID + "' ");
            return DbHelperSQL.Exists(strSql.ToString());
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tblJieYueREnInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.JieYueRenID != null)
            {
                strSql1.Append("JieYueRenID,");
                strSql2.Append("'" + model.JieYueRenID + "',");
            }
            if (model.JieYueRenName != null)
            {
                strSql1.Append("JieYueRenName,");
                strSql2.Append("'" + model.JieYueRenName + "',");
            }
            if (model.Addr != null)
            {
                strSql1.Append("Addr,");
                strSql2.Append("'" + model.Addr + "',");
            }
            if (model.Tel != null)
            {
                strSql1.Append("Tel,");
                strSql2.Append("'" + model.Tel + "',");
            }
            if (model.Status != null)
            {
                strSql1.Append("Status,");
                strSql2.Append("'" + model.Status + "',");
            }
            
            strSql.Append("insert into tblJieYueREnInfo(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tblJieYueREnInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tblJieYueREnInfo set ");
            if (model.JieYueRenID != null)
            {
                strSql.Append("JieYueRenID='" + model.JieYueRenID + "',");
            }
            if (model.JieYueRenName != null)
            {
                strSql.Append("JieYueRenName='" + model.JieYueRenName + "',");
            }
            if (model.Addr != null)
            {
                strSql.Append("Addr='" + model.Addr + "',");
            }
            if (model.Tel != null)
            {
                strSql.Append("Tel='" + model.Tel + "',");
            }
            if (model.Status != null)
            {
                strSql.Append("Status='" + model.Status + "',");
            }
           
            int n = strSql.ToString().LastIndexOf(",");
            strSql.Remove(n, 1);
            strSql.Append(" where JieYueRenID='" + model.JieYueRenID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(string JieYueRenID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete tblJieYueREnInfo ");
            strSql.Append(" where JieYueRenID='" + JieYueRenID + "' ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tblJieYueREnInfoModel GetModel(string JieYueRenID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1  ");
            strSql.Append(" JieYueRenID,JieYueRenName,Addr,Tel,Status ");
            strSql.Append(" from tblJieYueREnInfo ");
            strSql.Append(" where JieYueRenID='" + JieYueRenID + "' ");
            tblJieYueREnInfoModel model = new tblJieYueREnInfoModel();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.JieYueRenID = Convert.ToInt32(ds.Tables[0].Rows[0]["JieYueRenID"]);
                model.JieYueRenName = ds.Tables[0].Rows[0]["JieYueRenName"].ToString();
                model.Addr = ds.Tables[0].Rows[0]["Addr"].ToString();
                model.Tel = Convert.ToInt32(ds.Tables[0].Rows[0]["Tel"]);
                model.Status = Convert.ToInt16(ds.Tables[0].Rows[0]["Status"]);            
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string txtRenID, string txtRenName, string cmbStatus)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strWhere = new StringBuilder();
            if (!string.IsNullOrEmpty(txtRenID))
            {
                strWhere.Append(" JieYueRenID = '" + txtRenID + "'");
            }
            if (!string.IsNullOrEmpty(txtRenName))
            {
                if (strWhere.Length != 0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" JieYueRenName LIKE '%" + txtRenName + "%'");
            }
            if (!string.IsNullOrEmpty(cmbStatus) && !cmbStatus.Equals("-1"))
            {
                if (strWhere.Length != 0)
                {
                    strWhere.Append(" AND");
                }
                strWhere.Append(" Status= '" + cmbStatus + " '");
            }
            strSql.Append("select JieYueRenID,JieYueRenName,Addr,Tel,Status");
            strSql.Append(" FROM tblJieYueREnInfo ");
            if (strWhere.ToString().Trim() != "")
            {
                strSql.Append(" where " + strWhere.ToString());
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        */

        #endregion  成员方法
    }
}

DAL建好后，连接model的四张表

其中图书管理员model为：

using System;
namespace BooksSystem.Model
{  
    public  class tblUserInfoModel
    {     
        public string id { get; set; }     
        public string password { get; set; }
    }
}

图书信息表model为：

 using System;

namespace BooksSystem.Model
{


    public class tblBookInfoModel
    {

        public string BookID { get; set; }


        public string BookName { get; set; }


        public string BookType { get; set; }

        public int BookCount { get; set; }

        public int BookJieCount { get; set; }

        public int BookNotJieCount
        {
            get
            {
                if(BookCount >= BookJieCount)
                {
                    return BookCount - BookJieCount;
                }
                else
                {
                    return 0;
                }
            }
        }
        public string BookStatus { get; set; }
        public string BookStatusNm
        {
            get

            {
                return BookStatus.Equals("1") ? "下架" : "上架";
            }
        }
    }
}

借阅信息表model为：

using System;
namespace BooksSystem.Model
{
    
  

   
    public class tblJieYueInfoModel
    {
       
        public string BookID { get; set; }

       
        public string JieYueREnID { get; set; }

        public short Status { get; set; }
    }
}

借阅人信息表model为：

 using System;
namespace BooksSystem.Model
{
   
    

   
    public  class tblJieYueREnInfoModel
    {
       
        public int JieYueRenID { get; set; }

       
        public string JieYueRenName { get; set; }

       
        public string Addr { get; set; }

        public int Tel { get; set; }

        public short Status { get; set; }
        public string StatusNm
        {
            get

            {
                return Status.Equals("1") ? "注销" : "注册中";
            }
        }
    }
}

到此为止三层架构是建好了，已经完成了一大半了，现在开始做界面的代码，

登录界面的代码为，其中登录人密码为*，要用MD5码转换一下：

using System;
using System.Security.Cryptography;
using System.Text;
using System.Windows.Forms;
using BooksSystem.BLL;
using BooksSystem.Model;

namespace BooksSystem
{
    public partial class frmLogin : Form
    {
        public frmLogin()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 用MD5加密字符串，可选择生成16位或者32位的加密字符串
        /// </summary>
        /// <param name="password">待加密的字符串</param>

        /// <returns>返回的加密后的字符串</returns>
        public string MD5Encrypt(string password)
        {
            MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
            byte[] hashedDataBytes;
            hashedDataBytes = md5Hasher.ComputeHash(Encoding.GetEncoding("gb2312").GetBytes(password));
            StringBuilder tmp = new StringBuilder();
            foreach (byte i in hashedDataBytes)
            {
                tmp.Append(i.ToString("x2"));
            }

            if(!string.IsNullOrEmpty(tmp.ToString()))
            {
                return tmp.ToString();               
            }
            else         
                return string.Empty;
        }				

        private void btnLogin_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtID.Text) && !string.IsNullOrEmpty(txtPWD.Text))
            {
                string strPwd = MD5Encrypt(txtPWD.Text);
                tblUserInfoBLL bll = new tblUserInfoBLL();
                if (bll.Exists(txtID.Text, strPwd))
                {
                    MessageBox.Show("用户登录成功！");
                    frmMain frm = new frmMain();
                    frm.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("不存在此用户或用户名密码错！");
                    txtID.Focus();
                    txtID.SelectAll();
                }
            }
        }

        private void frmLogin_Load(object sender, EventArgs e)
        {
            txtID.Focus();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            DialogResult dr = MessageBox.Show("确认是否关闭吗？", "关闭", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (dr == DialogResult.OK)
            {
                Application.Exit();
            }
        }
    }
}

第二个主界面为：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace BooksSystem
{
    public partial class frmMain : Form
    {
        public frmMain()
        {
            InitializeComponent();
        }
        private void 图书信息查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmBookSearch Form1 = new frmBookSearch();
            Form1.MdiParent = this;
            Form1.Show();
        }
        private void 图书信息录入ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmBookInsert Form1 = new frmBookInsert();
            Form1.MdiParent = this;
            Form1.IsCreate = true;
            Form1.Show();
        }
        private void 借阅人信息查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmJieYueRenSearch Form1 = new frmJieYueRenSearch();
            Form1.MdiParent = this;
            Form1.Show();
        }
        private void 借阅人信息更新ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmJieYueRenInsert Form1 = new frmJieYueRenInsert();
            Form1.IsCreate = true;
            Form1.MdiParent = this;
            Form1.Show();
        }
        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DialogResult dr = MessageBox.Show("确认是否关闭吗？", "关闭", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (dr == DialogResult.OK)
            {
                Application.Exit();
            }
        }
        private void 借阅图书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmBookJieYue Form1 = new frmBookJieYue();
            Form1.IsJieYue = true;
            Form1.MdiParent = this;
            Form1.Show();
        }
        private void 归还图书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmBookJieYue Form1 = new frmBookJieYue();
            Form1.IsJieYue = false;
            Form1.MdiParent = this;
            Form1.Show();
        }
    }
}

第三个图书信息代码为：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using BooksSystem.BLL;
using BooksSystem.Model;
namespace BooksSystem
{
    public partial class frmBookInsert : Form
    {
        public bool IsCreate = false;
        public string BookId = string.Empty;

        public frmBookInsert()
        {
            InitializeComponent();
        }

        private void frmBookInsert_Load(object sender, EventArgs e)
        {
            if(!IsCreate)
            {
                tblBookInfoModel model = new tblBookInfoModel();
                tblBookInfoBLL bll = new tblBookInfoBLL();
               if(!string.IsNullOrEmpty(BookId))
                {
                    model = bll.GetModel(BookId);
                    txtBookID.Enabled = true;
                    txtBookID.Text = model.BookID;
                    txtBookName.Text = model.BookName;
                    cmbType.SelectedText  = model.BookType;
                    txtJieNum.Text = Convert.ToString(model.BookJieCount);
                    txtNum.Text = Convert.ToString(model.BookCount);
                    cmbStatus.SelectedIndex = Convert.ToInt32(model.BookStatus);
                    btndel.Enabled = true;

                }
                else
                {
                    btndel.Enabled = false;                             
                }
            }
           
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            tblBookInfoBLL bll = new tblBookInfoBLL();
            tblBookInfoModel model = new tblBookInfoModel();
            txtBookID.Enabled = true;
            model.BookID = txtBookID.Text;
            model.BookName =txtBookName.Text ;
            model.BookType= cmbType.SelectedItem.ToString();
            model.BookJieCount= Convert.ToInt32( txtJieNum.Text);
            model.BookCount =Convert.ToInt32( txtNum.Text);
            model.BookStatus=Convert.ToString( cmbStatus.SelectedIndex) ;
            if(IsCreate)
            {
                bll.Add(model);
            }
            else
            {
                bll.Update(model);
            }
            MessageBox.Show("保存成功！点击确认后该画面关闭！！");
            this.Close();
            if(Application.OpenForms["frmBookSearch"]!=null)
            {
                Application.OpenForms["frmBookSearch"].Show();
                ((frmBookSearch)Application.OpenForms["frmBookSearch"]).BindDataGrid();

            }
        }

        private void btndel_Click(object sender, EventArgs e)
        {
            if(!string.IsNullOrEmpty(txtBookID.Text))
            {
                tblBookInfoBLL bll = new tblBookInfoBLL();
                bll.Delete(txtBookID.Text);
                MessageBox.Show("删除成功！点击确认后该画面关闭！！");
                this.Close();
                if (Application.OpenForms["frmBookSearch"] != null)
                {
                    Application.OpenForms["frmBookSearch"].Show();
                    ((frmBookSearch)Application.OpenForms["frmBookSearch"]).BindDataGrid();

                }
            }


        }

        private void btnCancle_Click(object sender, EventArgs e)
        {
            DialogResult dr = MessageBox.Show("确认是否关闭吗？", "关闭", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (dr == DialogResult.OK)
            {
                this.Close();
            }
        }

        private void txtBookID_TextChanged(object sender, EventArgs e)
        {
            if (txtBookID.Text.Length > 10)
            {
                MessageBox.Show("输入错误！");
            }
        }

        private void txtNum_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
            {
                e.Handled = true;
            }
        }

        private void txtJieNum_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
            {
                e.Handled = true;
            }
        }
    }
}

第四个图书信息查询代码为：

using BooksSystem.BLL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace BooksSystem
{
    public partial class frmBookSearch : Form
    {
        public frmBookSearch()
        {
            InitializeComponent();
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            BindDataGrid();
        }
        public void BindDataGrid()
        {
            this.dgvBookInfoList.Columns.Clear();
            // 表格上下左右自适应
            dgvBookInfoList.Anchor = (AnchorStyles.Top | AnchorStyles.Right | AnchorStyles.Bottom | AnchorStyles.Left);
            dgvBookInfoList.AllowUserToAddRows = false;
            dgvBookInfoList.AllowUserToDeleteRows = false;
            dgvBookInfoList.ReadOnly = true;
            // 列手工排序
            dgvBookInfoList.AllowUserToOrderColumns = true;
            // 列头系统样式，设置为false，自定义才生效
            dgvBookInfoList.EnableHeadersVisualStyles = false;
            // 列头高度大小模式
            dgvBookInfoList.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
            // 列头高度大小
            dgvBookInfoList.ColumnHeadersHeight = 30;
            // 列头居中
            dgvBookInfoList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvBookInfoList.ColumnHeadersDefaultCellStyle.Font = new Font("微软雅黑", 10, FontStyle.Bold);
            // 列头边框样式
            dgvBookInfoList.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
            // 列头背景色
            dgvBookInfoList.ColumnHeadersDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#0099FF");
            // 列头前景色
            dgvBookInfoList.ColumnHeadersDefaultCellStyle.ForeColor = ColorTranslator.FromHtml("#fff");
            // 列宽自适应
            dgvBookInfoList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
            // 网格线颜色
            dgvBookInfoList.GridColor = ColorTranslator.FromHtml("#006CB3");
            // 背景色
            //dgvBookInfoList.BackgroundColor = ColorTranslator.FromHtml("#E7F5FF");
            // 行头边框样式
            dgvBookInfoList.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
            // 行头背景色
            dgvBookInfoList.RowHeadersDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#0099FF");
            // 行高（要在窗体初始化的地方InitializeComponent调用才生效）
            dgvBookInfoList.RowTemplate.Height = 30;
            // 单元格内容居中
            dgvBookInfoList.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            // 单元格背景色
            dgvBookInfoList.DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#97D5FF");
            // 隔行背景色
            dgvBookInfoList.AlternatingRowsDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#E1F3FF");
            tblBookInfoBLL bll = new tblBookInfoBLL();
            List<tblBookInfoModel> list = bll.GetList(txtBookID.Text, txtBookName.Text, txtBookType.Text, cmbStatus.SelectedIndex.ToString());

            if (list != null && list.Count > 0)
            {
                this.dgvBookInfoList.DataSource = list;
                this.dgvBookInfoList.Columns["BookID"].HeaderText = "图书编号";
                this.dgvBookInfoList.Columns["BookName"].HeaderText = "图书名称";
                this.dgvBookInfoList.Columns["BookType"].HeaderText = "图书类型";
                this.dgvBookInfoList.Columns["BookCount"].HeaderText = "图书总数";
                this.dgvBookInfoList.Columns["BookJieCount"].HeaderText = "图书借阅中数量";
                this.dgvBookInfoList.Columns["BookStatus"].Visible = false;
                this.dgvBookInfoList.Columns["BookNotJieCount"].Visible = false;
                this.dgvBookInfoList.Columns["BookStatusNm"].HeaderText = "图书状态";

            }
            else
            {
                MessageBox.Show("没有数据，请确认!!!");
            }

        }
        private void dgvBookInfoList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgvBookInfoList.SelectedRows != null && dgvBookInfoList.SelectedRows.Count > 0)
            {
                frmBookInsert frm = new frmBookInsert();
                frm.IsCreate = false;
                frm.MdiParent = Application.OpenForms["frmMain"];
                frm.BookId = Convert.ToString(dgvBookInfoList.SelectedRows[0].Cells["BookID"].Value);
                frm.Show();
            }
        }

        private void frmBookSearch_Load(object sender, EventArgs e)
        {

        }
    }
}

第五个借阅信息代码为：

using BooksSystem.BLL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace BooksSystem
{
    public partial class frmJieYueRenInsert : Form
    {
        public bool IsCreate = false;
        public string JieYueRenID = string.Empty;

        public frmJieYueRenInsert()
        {
            InitializeComponent();
        }

        private void frmJieYueRenInsert_Load(object sender, EventArgs e)
        {
            if (!IsCreate)
            {
                tblJieYueREnInfoModel model = new tblJieYueREnInfoModel();
                tblJieYueREnInfoBLL bll = new tblJieYueREnInfoBLL();
                if (!string.IsNullOrEmpty(JieYueRenID))
                {
                    model = bll.GetModel(JieYueRenID);
                    txtRenID.Enabled = true;
                    txtRenID.Text = Convert.ToString(model.JieYueRenID);
                    txtRenName.Text = model.JieYueRenName;
                    txtRenPhe.Text = Convert.ToString(model.Tel);
                    cmbStatus.SelectedText = model.StatusNm;
                    txtRenAddr.Text = Convert.ToString(model.Addr);
                  
                    btndel.Enabled = true;

                }
                else
                {
                    btndel.Enabled = false;
                }
            }

        }

        private void btnSave_Click_1(object sender, EventArgs e)
        {
            tblJieYueREnInfoBLL bll = new tblJieYueREnInfoBLL();
            tblJieYueREnInfoModel model = new tblJieYueREnInfoModel();
            txtRenID.Enabled = true;
            model.JieYueRenID = Convert.ToInt32(txtRenID.Text);
            model.JieYueRenName = txtRenName.Text;
            model.Tel = Convert.ToInt32(txtRenPhe.Text);//.SelectedItem.ToString();
            model.Status = Convert.ToInt16(cmbStatus.SelectedIndex);
            model.Addr = txtRenAddr.Text;
            
            if (IsCreate)
            {
                bll.Add(model);
            }
            else
            {
                bll.Update(model);
            }
            MessageBox.Show("保存成功！点击确认后该画面关闭！！");
            this.Close();
            if (Application.OpenForms["frmJieYueRenSearch"] != null)
            {
                Application.OpenForms["frmJieYueRenSearch"].Show();
                ((frmJieYueRenSearch)Application.OpenForms["frmJieYueRenSearch"]).BindDataGrid();

            }
        }

        private void btndel_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtRenID.Text))
            {
                tblJieYueREnInfoBLL bll = new tblJieYueREnInfoBLL();
                bll.Delete(txtRenID.Text);
                MessageBox.Show("删除成功！点击确认后该画面关闭！！");
                this.Close();
                if (Application.OpenForms["frmJieYueRenSearch"] != null)
                {
                    Application.OpenForms["frmJieYueRenSearch"].Show();
                    ((frmJieYueRenSearch)Application.OpenForms["frmJieYueRenSearch"]).BindDataGrid();

                }
            }


        }

        private void btnCanCel_Click(object sender, EventArgs e)
        {
            DialogResult dr = MessageBox.Show("确认是否关闭吗？", "关闭", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (dr == DialogResult.OK)
            {
                this.Close();
            }
        }

        private void txtRenID_TextChanged(object sender, EventArgs e)
        {
            if (txtRenID.Text.Length>10)
            {
                MessageBox.Show("输入错误！");
            }
        }

        private void txtRenPhe_TextChanged(object sender, EventArgs e)
        {
            if (txtRenPhe.Text.Length > 13)
            {
                MessageBox.Show("输入错误！");
            }
        }

        private void txtRenID_KeyPress(object sender, KeyPressEventArgs e)
        {
            if(!char.IsNumber(e.KeyChar)&&e.KeyChar!=(char)8)
            {
                e.Handled = true;
            }
        }

        private void txtRenPhe_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
            {
                e.Handled = true;
            }
        }

       
    }
}

第六个借阅信息查询代码为：

using BooksSystem.BLL;
using BooksSystem.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace BooksSystem
{
    public partial class frmJieYueRenSearch : Form
    {
        public frmJieYueRenSearch()
        {
            InitializeComponent();
        }
        private void btnsel_Click(object sender, EventArgs e)
        {
            BindDataGrid();
        }
        //private void btnSearch_Click(object sender, EventArgs e)
        //{
        //    BindDataGrid();
        //}
        public void BindDataGrid()
        {
            this.dgvJieYueRenInfoList.Columns.Clear();
            // 表格上下左右自适应
            dgvJieYueRenInfoList.Anchor = (AnchorStyles.Top | AnchorStyles.Right | AnchorStyles.Bottom | AnchorStyles.Left);
            dgvJieYueRenInfoList.AllowUserToAddRows = false;
            dgvJieYueRenInfoList.AllowUserToDeleteRows = false;
            dgvJieYueRenInfoList.ReadOnly = true;
            // 列手工排序
            dgvJieYueRenInfoList.AllowUserToOrderColumns = true;
            // 列头系统样式，设置为false，自定义才生效
            dgvJieYueRenInfoList.EnableHeadersVisualStyles = false;
            // 列头高度大小模式
            dgvJieYueRenInfoList.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
            // 列头高度大小
            dgvJieYueRenInfoList.ColumnHeadersHeight = 30;
            // 列头居中
            dgvJieYueRenInfoList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvJieYueRenInfoList.ColumnHeadersDefaultCellStyle.Font = new Font("微软雅黑", 10, FontStyle.Bold);
            // 列头边框样式
            dgvJieYueRenInfoList.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
            // 列头背景色
            dgvJieYueRenInfoList.ColumnHeadersDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#0099FF");
            // 列头前景色
            dgvJieYueRenInfoList.ColumnHeadersDefaultCellStyle.ForeColor = ColorTranslator.FromHtml("#fff");
            // 列宽自适应
            dgvJieYueRenInfoList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
            // 网格线颜色
            dgvJieYueRenInfoList.GridColor = ColorTranslator.FromHtml("#006CB3");
            // 背景色
            //dgvJieYueRenInfoList.BackgroundColor = ColorTranslator.FromHtml("#E7F5FF");
            // 行头边框样式
            dgvJieYueRenInfoList.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
            // 行头背景色
            dgvJieYueRenInfoList.RowHeadersDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#0099FF");
            // 行高（要在窗体初始化的地方InitializeComponent调用才生效）
            dgvJieYueRenInfoList.RowTemplate.Height = 30;
            // 单元格内容居中
            dgvJieYueRenInfoList.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            // 单元格背景色
            dgvJieYueRenInfoList.DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#97D5FF");
            // 隔行背景色
            dgvJieYueRenInfoList.AlternatingRowsDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#E1F3FF");
            tblJieYueREnInfoBLL bll = new tblJieYueREnInfoBLL();
            List<tblJieYueREnInfoModel> list = bll.GetList(txtRenID.Text, txtRenName.Text, cmbStatus.SelectedIndex.ToString());
           
            if (list != null && list.Count > 0)
            {
                this.dgvJieYueRenInfoList.DataSource = list;
                this.dgvJieYueRenInfoList.Columns["JieYueRenID"].HeaderText = "借阅人编号";
                this.dgvJieYueRenInfoList.Columns["JieYueRenName"].HeaderText = "借阅人名称";
                this.dgvJieYueRenInfoList.Columns["Addr"].HeaderText = "借阅人住址";
                this.dgvJieYueRenInfoList.Columns["Tel"].HeaderText = "借阅人电话";
                this.dgvJieYueRenInfoList.Columns["StatusNm"].HeaderText = "借阅人状态";
                this.dgvJieYueRenInfoList.Columns["Status"].Visible = false;

            }
            else
            {
                MessageBox.Show("没有数据，请确认!!!");
            }

        }
        private void dgvBookInfoList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgvJieYueRenInfoList.SelectedRows != null && dgvJieYueRenInfoList.SelectedRows.Count > 0)
            {
                frmJieYueRenInsert frm = new frmJieYueRenInsert();
                frm.IsCreate = false;
                frm.MdiParent = Application.OpenForms["frmMain"];
                frm.JieYueRenID = Convert.ToString(dgvJieYueRenInfoList.SelectedRows[0].Cells["JieYueRenID"].Value);
                frm.Show();
            }
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            if (txtRenID.Text.Length > 10)
                MessageBox.Show("输入的数据错误");
        }

       
    }
}

到现在为止是全部弄好了，其中还有很多属性还要更改，在这就不点明了。

择柒

关注

12
点赞
踩
132

收藏

觉得还不错? 一键收藏
5
评论
C#超详解做三层架构的图书管理系统——窗体界面

三层架构包含BLL，DAL，model，需要连接数据库。这个系统包含四张表，分别为图书管理员，图书信息表，借阅信息表，借阅人信息表；建立TestDB数据库，包含如下四张表，建好四张表后，做七个界面，分别是：做好七个界面后，开始底层的三层架构，分别连接数据库的四张表，...
复制链接

扫一扫