/// <summary> /// 拆分参数 /// </summary> private void ShowData() { lgk.Model.tb_Security securityInfo = securityBLL.GetModel(iSecurityID); if (securityInfo != null) { txtQuestion.Text = securityInfo.Question; } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_Security GetModel(int SecurityID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SecurityID, Question, AddUserID, AddDate, EditUserID, EditDate, Status"); strSql.Append(" from tb_Security "); strSql.Append(" where SecurityID=@SecurityID"); SqlParameter[] parameters = { new SqlParameter("@SecurityID", SqlDbType.Int, 4) }; parameters[0].Value = SecurityID; lgk.Model.tb_Security model = new lgk.Model.tb_Security(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SecurityID"].ToString() != "") { model.SecurityID = int.Parse(ds.Tables[0].Rows[0]["SecurityID"].ToString()); } model.Question = ds.Tables[0].Rows[0]["Question"].ToString(); if (ds.Tables[0].Rows[0]["AddUserID"].ToString() != "") { model.AddUserID = int.Parse(ds.Tables[0].Rows[0]["AddUserID"].ToString()); } if (ds.Tables[0].Rows[0]["AddDate"].ToString() != "") { model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString()); } if (ds.Tables[0].Rows[0]["EditUserID"].ToString() != "") { model.EditUserID = int.Parse(ds.Tables[0].Rows[0]["EditUserID"].ToString()); } if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString()); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } return(model); } else { return(null); } }
protected void lbtnSubmit_Click(object sender, EventArgs e) { lgk.Model.tb_Security securityInfo = new lgk.Model.tb_Security(); if (txtQuestion.Text.Trim() == "") { MessageBox.MyShow(this, "密保问题不能为空!");//密保问题不能为空 return; } if (iSecurityID > 0) { securityInfo = securityBLL.GetModel(iSecurityID); securityInfo.Question = txtQuestion.Text; securityInfo.EditUserID = getLoginID(); securityInfo.EditDate = DateTime.Now; if (securityBLL.Update(securityInfo)) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功!');window.location.href='Security.aspx';", true);//修改成功 } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败,请检查后再试!');window.location.href='Security.aspx';", true);//修改成功 } } else { securityInfo.Question = txtQuestion.Text; securityInfo.AddUserID = getLoginID(); securityInfo.AddDate = DateTime.Now; securityInfo.EditUserID = 0; securityInfo.Status = 0; if (securityBLL.Add(securityInfo) > 0) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加成功!');window.location.href='Security.aspx';", true);//修改成功 } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加失败,请检查后再试!');window.location.href='Security.aspx';", true);//修改成功 } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_Security model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Security set "); strSql.Append(" Question = @Question,"); strSql.Append(" AddUserID = @AddUserID,"); strSql.Append(" AddDate = @AddDate,"); strSql.Append(" EditUserID = @EditUserID,"); strSql.Append(" EditDate = @EditDate,"); strSql.Append(" Status = @Status "); strSql.Append(" where SecurityID=@SecurityID "); SqlParameter[] parameters = { new SqlParameter("@SecurityID", SqlDbType.Int, 4), new SqlParameter("@Question", SqlDbType.VarChar, 50), new SqlParameter("@AddUserID", SqlDbType.Int, 4), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@EditUserID", SqlDbType.Int, 4), new SqlParameter("@EditDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.SecurityID; parameters[1].Value = model.Question; parameters[2].Value = model.AddUserID; parameters[3].Value = model.AddDate; parameters[4].Value = model.EditUserID; parameters[5].Value = model.EditDate; parameters[6].Value = model.Status; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_Security model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Security("); strSql.Append("Question,AddUserID,AddDate,EditUserID,EditDate,Status"); strSql.Append(") values ("); strSql.Append("@Question,@AddUserID,@AddDate,@EditUserID,@EditDate,@Status"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Question", SqlDbType.VarChar, 50), new SqlParameter("@AddUserID", SqlDbType.Int, 4), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@EditUserID", SqlDbType.Int, 4), new SqlParameter("@EditDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.Question; parameters[1].Value = model.AddUserID; parameters[2].Value = model.AddDate; parameters[3].Value = model.EditUserID; parameters[4].Value = DBNull.Value; parameters[5].Value = model.Status; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }