三层范本——1

代码生成器直接生成的三层：经代码生成器直接生成，D层，B层方法均未作修改；方法比较笨，且不灵活。

 

using System;using System.Data;using System.Text;namespace DAL{/// <summary>/// 数据访问类CheckInfo。 /// 操作“考核信息表”中的数据。/// </summary>public class CheckInfo{public CheckInfo(){}#region 成员方法/// <summary>/// 是否存在该记录/// </summary>public bool Exists(string PkGuid){StringBuilder strSql=new StringBuilder();strSql.Append("select count(1) from CheckInfo");strSql.Append(" where PkGuid=@PkGuid ");SqlParameter[] parameters = {new SqlParameter("@PkGuid", SqlDbType.NVarChar,50)};parameters[0].Value = PkGuid;return DbHelperSQL.Exists(strSql.ToString(),parameters);}/// <summary>/// 增加一条数据/// </summary>public void Add(Model.RLZY.CheckInfo model){StringBuilder strSql=new StringBuilder();strSql.Append("insert into CheckInfo(");strSql.Append("PkGuid,CheckType,CheckUser,CheckResult,CheckTime,CheckUserId)");strSql.Append(" values (");strSql.Append("@PkGuid,@CheckType,@CheckUser,@CheckResult,@CheckTime,@CheckUserId)");SqlParameter[] parameters = {new SqlParameter("@PkGuid", SqlDbType.NVarChar,50),new SqlParameter("@CheckType", SqlDbType.NVarChar,50),new SqlParameter("@CheckUser", SqlDbType.NVarChar,50),new SqlParameter("@CheckResult", SqlDbType.NVarChar,50),new SqlParameter("@CheckTime", SqlDbType.SmallDateTime),new SqlParameter("@CheckUserId", SqlDbType.NVarChar,50)};parameters[0].Value = model.PkGuid;parameters[1].Value = model.CheckType;parameters[2].Value = model.CheckUser;parameters[3].Value = model.CheckResult;parameters[4].Value = model.CheckTime;parameters[5].Value = model.CheckUserId;DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);}/// <summary>/// 更新一条数据/// </summary>public void Update(Model.RLZY.CheckInfo model){StringBuilder strSql=new StringBuilder();strSql.Append("update CheckInfo set ");strSql.Append("CheckType=@CheckType,");strSql.Append("CheckUser=@CheckUser,");strSql.Append("CheckResult=@CheckResult,");strSql.Append("CheckTime=@CheckTime,");strSql.Append("CheckUserId=@CheckUserId");strSql.Append(" where PkGuid=@PkGuid ");SqlParameter[] parameters = {new SqlParameter("@PkGuid", SqlDbType.NVarChar,50),new SqlParameter("@CheckType", SqlDbType.NVarChar,50),new SqlParameter("@CheckUser", SqlDbType.NVarChar,50),new SqlParameter("@CheckResult", SqlDbType.NVarChar,50),new SqlParameter("@CheckTime", SqlDbType.SmallDateTime),new SqlParameter("@CheckUserId", SqlDbType.NVarChar,50)};parameters[0].Value = model.PkGuid;parameters[1].Value = model.CheckType;parameters[2].Value = model.CheckUser;parameters[3].Value = model.CheckResult;parameters[4].Value = model.CheckTime;parameters[5].Value = model.CheckUserId;DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);}/// <summary>/// 删除一条数据/// </summary>public void Delete(string PkGuid){StringBuilder strSql=new StringBuilder();strSql.Append("delete from CheckInfo ");strSql.Append(" where PkGuid=@PkGuid ");SqlParameter[] parameters = {new SqlParameter("@PkGuid", SqlDbType.NVarChar,50)};parameters[0].Value = PkGuid;DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);}/// <summary>/// 得到一个对象实体/// </summary>public Model.RLZY.CheckInfo GetModel(string PkGuid){StringBuilder strSql=new StringBuilder();strSql.Append("select top 1 PkGuid,CheckType,CheckUser,CheckResult,CheckTime,CheckUserId from CheckInfo ");strSql.Append(" where PkGuid=@PkGuid ");SqlParameter[] parameters = {new SqlParameter("@PkGuid", SqlDbType.NVarChar,50)};parameters[0].Value = PkGuid;Model.RLZY.CheckInfo model=new Model.RLZY.CheckInfo();DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);if(ds.Tables[0].Rows.Count>0){model.PkGuid=ds.Tables[0].Rows[0]["PkGuid"].ToString();model.CheckType=ds.Tables[0].Rows[0]["CheckType"].ToString();model.CheckUser=ds.Tables[0].Rows[0]["CheckUser"].ToString();model.CheckResult=ds.Tables[0].Rows[0]["CheckResult"].ToString();if(ds.Tables[0].Rows[0]["CheckTime"].ToString()!=""){model.CheckTime=DateTime.Parse(ds.Tables[0].Rows[0]["CheckTime"].ToString());}model.CheckUserId=ds.Tables[0].Rows[0]["CheckUserId"].ToString();return model;}else{return null;}}/// <summary>/// 获得数据列表/// </summary>public DataSet GetList(string strWhere){StringBuilder strSql=new StringBuilder();strSql.Append("select PkGuid,CheckType,CheckUser,CheckResult,CheckTime,CheckUserId ");strSql.Append(" FROM CheckInfo ");if(strWhere.Trim()!=""){strSql.Append(" where "+strWhere);}return DbHelperSQL.Query(strSql.ToString());}/// <summary>/// 获得前几行数据/// </summary>public DataSet GetList(int Top,string strWhere,string filedOrder){StringBuilder strSql=new StringBuilder();strSql.Append("select ");if(Top>0){strSql.Append(" top "+Top.ToString());}strSql.Append(" PkGuid,CheckType,CheckUser,CheckResult,CheckTime,CheckUserId ");strSql.Append(" FROM CheckInfo ");if(strWhere.Trim()!=""){strSql.Append(" where "+strWhere);}strSql.Append(" order by " + filedOrder);return DbHelperSQL.Query(strSql.ToString());} #endregion 成员方法}}using System;using System.Data;using System.Collections.Generic;namespace BLL{/// <summary>/// 业务逻辑类CheckInfo 的摘要说明。 /// 考核信息表/// </summary>public class CheckInfo{private readonly DAL.RLZY.CheckInfo dal=new DAL.RLZY.CheckInfo();public CheckInfo(){}#region 成员方法/// <summary>/// 是否存在该记录/// </summary>public bool Exists(string PkGuid){return dal.Exists(PkGuid);}/// <summary>/// 增加一条数据/// </summary>public void Add(Model.RLZY.CheckInfo model){dal.Add(model);}/// <summary>/// 更新一条数据/// </summary>public void Update(Model.RLZY.CheckInfo model){dal.Update(model);}/// <summary>/// 删除一条数据/// </summary>public void Delete(string PkGuid){dal.Delete(PkGuid);}/// <summary>/// 得到一个对象实体/// </summary>public Model.RLZY.CheckInfo GetModel(string PkGuid){return dal.GetModel(PkGuid);}/// <summary>/// 获得数据列表/// </summary>public DataSet GetList(string strWhere){return dal.GetList(strWhere);}/// <summary>/// 获得前几行数据/// </summary>public DataSet GetList(int Top,string strWhere,string filedOrder){return dal.GetList(Top,strWhere,filedOrder);}/// <summary>/// 获得数据列表/// </summary>public List<Model.RLZY.CheckInfo> GetModelList(string strWhere){DataSet ds = dal.GetList(strWhere);return DataTableToList(ds.Tables[0]);}/// <summary>/// 获得数据列表/// </summary>public List<Model.RLZY.CheckInfo> DataTableToList(DataTable dt){List<Model.RLZY.CheckInfo> modelList = new List<Model.RLZY.CheckInfo>();int rowsCount = dt.Rows.Count;if (rowsCount > 0){Model.RLZY.CheckInfo model;for (int n = 0; n < rowsCount; n++){model = new Model.RLZY.CheckInfo();model.PkGuid=dt.Rows[n]["PkGuid"].ToString();model.CheckType=dt.Rows[n]["CheckType"].ToString();model.CheckUser=dt.Rows[n]["CheckUser"].ToString();model.CheckResult=dt.Rows[n]["CheckResult"].ToString();if(dt.Rows[n]["CheckTime"].ToString()!=""){model.CheckTime=DateTime.Parse(dt.Rows[n]["CheckTime"].ToString());}model.CheckUserId=dt.Rows[n]["CheckUserId"].ToString();modelList.Add(model);}}return modelList;}/// <summary>/// 获得数据列表/// </summary>public DataSet GetAllList(){return GetList("");} #endregion 成员方法}}using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;public partial class Web_HumanResources_PersonalFile_FileManager : System.Web.UI.Page{ BLL.RLZY.EmployeeInfo BllEmployee = new BLL.RLZY.EmployeeInfo(); Model.RLZY.EmployeeInfo modelEmployee = new Model.RLZY.EmployeeInfo(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGridView(); } } //gridview中点击编辑时 protected void link_Edit_Click(object sender, EventArgs e) { Server.Transfer("AddPerFile.aspx?pkguid=" + ((LinkButton)sender).CommandArgument.ToString()); } //gridview中点击删除时 protected void link_delete_Click(object sender, EventArgs e) { string PkGuid = (sender as LinkButton).CommandArgument.ToString(); BllEmployee.Delete(PkGuid); this.GridView1.EditIndex = -1; BindGridView(); } //绑定员工基本信息表中的数据 private void BindGridView() { DataSet ds = BllEmployee.GetList(""); this.GridView1.DataSource = ds; this.GridView1.DataKeyNames = new string[] { "PkGuid" }; this.GridView1.DataBind(); } #region 显示员工的政治面貌 /// <summary> /// 在GridView中显示员工的政治面貌 /// </summary> /// <param name="pkguid"></param> /// <returns></returns> public string GetPlfeatureType(string pkguid) { string PlfeatureType = ""; modelEmployee = BllEmployee.GetModel(pkguid); if (modelEmployee.Plfeature == 0) { PlfeatureType = "群众"; } if (modelEmployee.Plfeature == 1) { PlfeatureType = "团员"; } if (modelEmployee.Plfeature == 2) { PlfeatureType = "预备党员"; } if (modelEmployee.Plfeature == 3) { PlfeatureType = "党员"; } return PlfeatureType; } #endregion protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { }}