代码生成器直接生成的三层:经代码生成器直接生成,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) { } }