/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhongLi.Model.PostType model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@PostTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@ColValue", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.PostTypeName; parameters[2].Value = model.ParentID; parameters[3].Value = model.Sort; parameters[4].Value = model.ColValue; DbHelperSQL.RunProcedure("PostType_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.PostType DataRowToModel(DataRow row) { ZhongLi.Model.PostType model = new ZhongLi.Model.PostType(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["PostTypeName"] != null) { model.PostTypeName = row["PostTypeName"].ToString(); } if (row["ParentID"] != null && row["ParentID"].ToString() != "") { model.ParentID = int.Parse(row["ParentID"].ToString()); } if (row["Sort"] != null && row["Sort"].ToString() != "") { model.Sort = int.Parse(row["Sort"].ToString()); } if (row["ColValue"] != null) { model.ColValue = row["ColValue"].ToString(); } } return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!Utils.CheckRole("17")) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限!','/Systestcomjun/index.aspx',2)</script>"); return; } if (!IsPostBack) { if (Request.QueryString["ID"] != null) { int ID = Convert.ToInt32(Request.QueryString["ID"]); ZhongLi.Model.PostType p = bll.GetModel(ID); txtPostTypeName.Text = p.PostTypeName; txtSort.Text = p.Sort + ""; } } }
protected void btnsave_Click(object sender, EventArgs e) { ZhongLi.Model.PostType p = null; if (Request.QueryString["ID"] == null) { p = new ZhongLi.Model.PostType(); if (Request.QueryString["PID"] != null) { p.ParentID = Convert.ToInt32(Request.QueryString["PID"]); } else { p.ParentID = 0; } } else { p = bll.GetModel(Convert.ToInt32(Request.QueryString["ID"])); } p.PostTypeName = txtPostTypeName.Text.Trim(); p.Sort = Convert.ToInt32(txtSort.Text); if (Request.QueryString["ID"] == null) { if (bll.Add(p) > 0) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('职位类型','保存成功!','',1)</script>"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('职位类型','保存失败','',2)</script>"); } } else { if (bll.Update(p)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('职位类型','保存成功!','',1)</script>"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('职位类型','保存失败','',2)</script>"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.PostType GetModel(int ID) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; ZhongLi.Model.PostType model = new ZhongLi.Model.PostType(); DataSet ds = DbHelperSQL.RunProcedure("PostType_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhongLi.Model.PostType model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@PostTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@ColValue", SqlDbType.NVarChar, 50) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.PostTypeName; parameters[2].Value = model.ParentID; parameters[3].Value = model.Sort; parameters[4].Value = model.ColValue; DbHelperSQL.RunProcedure("PostType_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }