三层架构包含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("输入的数据错误");
}
}
}
到现在为止是全部弄好了,其中还有很多属性还要更改,在这就不点明了。