一、DAL数据访问层代码
1、获取实体对象
/// /// 得到一个对象实体 /// public Model.Banqi GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from banqi"); strSql.Append(" where id=@id"); SqlParameter[] parameters = {new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.Banqi model = new Model.Banqi(); DataTable dt = new SqlHelper().ExecuteQuery(strSql.ToString(), parameters, CommandType.Text); if (dt.Rows.Count > 0) { if (dt.Rows[0]["id"].ToString() != "") //这个判断可以省略,只判断允许为空的字段 { model.id = int.Parse(dt.Rows[0]["id"].ToString()); } model.bqid = dt.Rows[0]["bqid"].ToString(); model.xxdw = dt.Rows[0]["xxdw"].ToString(); model.bqmc = dt.Rows[0]["bqmc"].ToString(); model.zygz = dt.Rows[0]["zygz"].ToString(); model.pxdd = dt.Rows[0]["pxdd"].ToString(); model.skjs = dt.Rows[0]["skjs"].ToString(); model.pxks = DateTime.Parse(dt.Rows[0]["pxks"].ToString()); model.pxjs = DateTime.Parse(dt.Rows[0]["pxjs"].ToString()); model.bqrs = int.Parse(dt.Rows[0]["bqrs"].ToString()); return model; } else { return null; } }
2、更新数据
//更新一条记录 public bool Update(Model.Banqi model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update banqi set "); strSql.Append("bqid=@bqid,"); strSql.Append("xxdw=@xxdw,"); strSql.Append("bqmc=@bqmc,"); strSql.Append("zygz=@zygz,"); strSql.Append("pxdd=@pxdd,"); strSql.Append("skjs=@skjs,"); strSql.Append("pxks=@pxks,"); strSql.Append("pxjs=@pxjs,"); strSql.Append("update_time=@update_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@bqid", SqlDbType.NVarChar,50), new SqlParameter("@xxdw", SqlDbType.NVarChar,50), new SqlParameter("@bqmc", SqlDbType.NVarChar,50), new SqlParameter("@zygz", SqlDbType.NVarChar,50), new SqlParameter("@pxdd", SqlDbType.NVarChar,50), new SqlParameter("@skjs", SqlDbType.NVarChar,50), new SqlParameter("@pxks", SqlDbType.DateTime), new SqlParameter("@pxjs", SqlDbType.DateTime), new SqlParameter("@bqrs", SqlDbType.TinyInt), new SqlParameter("@update_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = model.bqid; parameters[1].Value = model.xxdw; parameters[2].Value = model.bqmc; parameters[3].Value = model.zygz; parameters[4].Value = model.pxdd; parameters[5].Value = model.skjs; parameters[6].Value = model.pxks; parameters[7].Value = model.pxjs; parameters[8].Value = model.bqrs; parameters[9].Value = model.update_time; parameters[10].Value = model.id; int res = new SqlHelper().ExecuteNonQuery(strSql.ToString(), parameters, CommandType.Text); if (res>=1) //更新一条就是=1 { return true; } else { return false; } }
二、前台页面代码,含数据验证
班期修改
*班期ID
*请输入班期ID
*学校单位
*请输入培训机构院校
*班期名称
*请输入班期名称
*职业工种
*请输入职业工种
*培训地点
*请输入培训地点
*授课教师
*请输入授课教师
*培训开始
*请输入培训开始日期
*培训结束
*请输入培训结束日期
*班期人数
*请输入培训人数
三、后台代码
1、根据传来的参数id,获取实体对象,将值赋予前台控件文本属性。
2、通过前台JS验证,修改数据后保存。更新成功后,关闭弹出页,刷新父窗口。
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request.QueryString["id"]); ShowInfo(id); } } #region 赋值操作================================= private void ShowInfo(int id) { Model.Banqi model = new DAL.banqi().GetModel(id); txtBqid.Text = model.bqid; txtXxdw.Text = model.xxdw; txtBqmc.Text = model.bqmc; txtZygz.Text = model.zygz; txtSkjs.Text = model.skjs; txtPxdd.Text = model.pxdd; txtPxks.Text = model.pxks.ToString("yyyy-MM-dd"); txtPxjs.Text = model.pxjs.ToString("yyyy-MM-dd"); txtPxrs.Text = model.bqrs.ToString(); ViewState["id"] = model.id; } #endregion //更新保存操作 private bool DoUpdate() { bool result = false; Model.Banqi model = new Model.Banqi(); model.id = int.Parse(ViewState["id"].ToString()); model.bqid = txtBqid.Text.Trim(); model.xxdw = txtXxdw.Text.Trim(); model.bqmc = txtBqmc.Text.Trim(); model.zygz = txtZygz.Text.Trim(); model.pxdd = txtPxdd.Text.Trim(); model.skjs = txtSkjs.Text.Trim(); model.pxks = Convert.ToDateTime(txtPxks.Text.Trim()); model.pxjs = Convert.ToDateTime(txtPxjs.Text.Trim()); model.bqrs = Convert.ToInt32(txtPxrs.Text.Trim()); model.update_time = DateTime.Now; if (new DAL.banqi().Update(model)) { result = true; } return result; } protected void Button1_Click(object sender, EventArgs e) { if (!DoUpdate()) { Response.Write(""); return; } else { Response.Write(""); } }
![ded8cfffefb420510dada032b8783484.png](https://img-blog.csdnimg.cn/img_convert/ded8cfffefb420510dada032b8783484.png)