一、DAL数据访问层
//领取卡片 public bool Update(Model.gqcrc model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [gccrc] set "); strSql.Append("[lqr]=@lqr,"); strSql.Append("[lqrlxdh]=@lqrlxdh,"); strSql.Append("[fkrq]=@fkrq,"); strSql.Append("[jbr]=@jbr"); strSql.Append(" where [id]=@id"); SqlParameter[] parameters = { new SqlParameter("@lqr", SqlDbType.NVarChar,50), new SqlParameter("@lqrlxdh", SqlDbType.NVarChar,50), new SqlParameter("@fkrq", SqlDbType.Date), new SqlParameter("@jbr", SqlDbType.NVarChar,50), new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = model.lqr; parameters[1].Value = model.lqrlxdh; parameters[2].Value = model.fkrq; parameters[3].Value = model.jbr; parameters[4].Value = model.id; int res = new SqlHelper().ExecuteNonQuery(strSql.ToString(), parameters, CommandType.Text); if (res >= 1) //更新一条就是=1 { return true; } else { return false; } }
二、前台显示已存在的数据值
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request.QueryString["id"]); Model.gqcrc model = new DAL.gqcrc().GetModel(id); xmlbl.Text = model.xm; klblbl.Text = model.klb; if (model.fkrq>=Convert.ToDateTime("1900-01-01")) { Response.Write("<script>alert('已存在发卡日期,请检查!');var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index); parent.location.reload();</script></script>"); return; } } }
三、更新按钮执行代码
protected void Button1_Click(object sender, EventArgs e) { Model.gqcrc model = new Model.gqcrc(); model.id = int.Parse(Request.QueryString["id"]); model.lqr=lqrtxt.Text.Trim(); model.lqrlxdh = lqrlxdh.Text.Trim(); model.fkrq =Convert.ToDateTime(fkrqtxt.Text.Trim()); model.jbr = new Common.Admin_info().Getadmin_info().realname; if (new DAL.gqcrc().Update(model)) { Response.Write("<script>alert('发卡记录完成!');var index = parent.layer.getFrameIndex(window.name);parent.layer.close(index); parent.location.reload();</script>"); } else { Response.Write("<script>alert('发生错误!');</script>"); return; } }