protected void Page_Load(object sender, EventArgs e) { if ("" == Request.QueryString["rid"] || null == Request.QueryString["rid"]) { if (this.hidPrimary.Value == "-1") { this.LbTabName.Text = "添加角色"; //设置选项卡名称 this.LbHeadName.Text = "添加角色"; //设置标题头名称 } else { this.LbTabName.Text = "编辑角色"; //设置选项卡名称 this.LbHeadName.Text = "编辑角色"; //设置标题头名称 int RoleID = Convert.ToInt32(this.hidPrimary.Value); Entity.BASE_ROLE model = bll.GetEntity(RoleID); SetEntity(model); } } else { this.LbTabName.Text = "编辑角色"; //设置选项卡名称 this.LbHeadName.Text = "编辑角色"; //设置标题头名称 int RoleID = Convert.ToInt32(Request.QueryString["rid"]); Entity.BASE_ROLE model = bll.GetEntity(RoleID); SetEntity(model); } dataBindToRepeater(); }
/// <summary> /// 更新角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public bool UpdateRole(Entity.BASE_ROLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Base_Role set "); strSql.Append("RoleGroupID=@RoleGroupID,"); strSql.Append("RoleName=@RoleName,"); strSql.Append("RoleDescription=@RoleDescription,"); strSql.Append("RoleOrder=@RoleOrder"); strSql.Append(" where RoleID=@RoleID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@RoleGroupID", SqlDbType.Int, 4), new SqlParameter("@RoleName", SqlDbType.NVarChar, 30), new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50), new SqlParameter("@RoleOrder", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleID; parameters[1].Value = model.RoleGroupID; parameters[2].Value = model.RoleName; parameters[3].Value = model.RoleDescription; parameters[4].Value = model.RoleOrder; if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.BASE_ROLE entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Base_Role("); strSql.Append("RoleGroupID,RoleName,RoleDescription,RoleOrder"); strSql.Append(") values ("); strSql.Append("@RoleGroupID,@RoleName,@RoleDescription,@RoleOrder"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RoleGroupID", SqlDbType.Int, 4), new SqlParameter("@RoleName", SqlDbType.NVarChar, 30), new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50), new SqlParameter("@RoleOrder", SqlDbType.Int, 4) }; parameters[0].Value = entity.RoleGroupID; parameters[1].Value = entity.RoleName; parameters[2].Value = entity.RoleDescription; parameters[3].Value = entity.RoleOrder; object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public int CreateRole(Entity.BASE_ROLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Base_Role("); strSql.Append("RoleGroupID,RoleName,RoleDescription,RoleOrder)"); strSql.Append(" values ("); strSql.Append("@RoleGroupID,@RoleName,@RoleDescription,@RoleOrder)"); SqlParameter[] parameters = { new SqlParameter("@RoleGroupID", SqlDbType.Int, 4), new SqlParameter("@RoleName", SqlDbType.NVarChar, 30), new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50), new SqlParameter("@RoleOrder", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleGroupID; parameters[1].Value = model.RoleName; parameters[2].Value = model.RoleDescription; parameters[3].Value = model.RoleOrder; if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { return(1); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_ROLE entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_ROLE set "); strSql.Append(" ROLEID = :ROLEID , "); strSql.Append(" ROLENAME = :ROLENAME , "); strSql.Append(" ROLEINFO = :ROLEINFO "); strSql.Append(" where ROLEID=:ROLEID "); OracleParameter[] parameters = { new OracleParameter(":ROLEID", OracleType.Number, 4), new OracleParameter(":ROLENAME", OracleType.VarChar, 50), new OracleParameter(":ROLEINFO", OracleType.VarChar, 20) }; parameters[0].Value = entity.ROLEID; parameters[1].Value = entity.ROLENAME; parameters[2].Value = entity.ROLEINFO; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_ROLE GetEntity(decimal ROLEID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ROLEID, ROLENAME, ROLEINFO "); strSql.Append(" from BASE_ROLE "); strSql.Append(" where ROLEID=:ROLEID "); OracleParameter[] parameters = { new OracleParameter(":ROLEID", OracleType.Number, 4) }; parameters[0].Value = ROLEID; Entity.BASE_ROLE entity = new Entity.BASE_ROLE(); DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["ROLEID"].ToString() != "") { entity.ROLEID = decimal.Parse(dt.Rows[0]["ROLEID"].ToString()); } entity.ROLENAME = dt.Rows[0]["ROLENAME"].ToString(); entity.ROLEINFO = dt.Rows[0]["ROLEINFO"].ToString(); return(entity); } else { return(null); } }
/// <summary> /// 获得角色实体数据 /// </summary> /// <returns></returns> private Entity.BASE_ROLE GetEntity() { Entity.BASE_ROLE model = new Entity.BASE_ROLE(); model.ROLEID = Convert.ToDecimal(this.hidPrimary.Value); //id ,主键 model.ROLENAME = this.TxtRoleName.Text; //角色名称 model.ROLEINFO = this.txtdesc.Text; //角色描述 return(model); }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void BtnAdd_Click(object sender, EventArgs e) { //获取实体 Entity.BASE_ROLE model = GetEntity(); //添加数据 bll.Add(model); //重新加载当前页 Response.Redirect(Request.Url.AbsoluteUri + "#tabs-2", true); }
/// <summary> /// 增加角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public int CreateRole(Entity.BASE_ROLE model) { if (!RoleExists(model.RoleName, model.RoleGroupID)) { return(dal.CreateRole(model)); } else { return(2); } }
//修改 public override void BtnUpdate_Click(object sender, EventArgs e) { //获取实体 Entity.BASE_ROLE model = GetEntity(); //修改数据 if (bll.update(model)) { //重新加载当前页 Response.Redirect("Role.aspx#tabs-2"); } else { Response.Write("<script type='text/javascript'>alert('请检查数据是否填写完整!');</script>"); } }
/// <summary> /// 更新数据 /// </summary> protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e) { Entity.BASE_ROLE model = new Entity.BASE_ROLE(); model.RoleID = int.Parse(RolesLists.DataKeys[e.RowIndex].Values[0].ToString()); model.RoleName = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_name")).Text.Trim(); model.RoleDescription = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_Description")).Text.Trim(); model.RoleGroupID = int.Parse(((DropDownList)RolesLists.Rows[e.RowIndex].FindControl("GroupID")).SelectedValue); model.RoleOrder = int.Parse(((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_order")).Text); if (!bll.UpdateRole(model)) { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("记录更新失败!"); strinfo.Visible = true; } //返回浏览狀態 RolesLists.EditIndex = -1; BindOrder(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_ROLE GetEntity(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select RoleID, RoleGroupID, RoleName, RoleDescription, RoleOrder "); strSql.Append(" from Base_Role "); strSql.Append(" where RoleID=@RoleID"); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; Entity.BASE_ROLE entity = new Entity.BASE_ROLE(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "") { entity.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["RoleGroupID"].ToString() != "") { entity.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString()); } entity.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString(); entity.RoleDescription = ds.Tables[0].Rows[0]["RoleDescription"].ToString(); if (ds.Tables[0].Rows[0]["RoleOrder"].ToString() != "") { entity.RoleOrder = int.Parse(ds.Tables[0].Rows[0]["RoleOrder"].ToString()); } return(entity); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.BASE_ROLE entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_ROLE("); strSql.Append("ROLEID,ROLENAME,ROLEINFO"); strSql.Append(") values ("); strSql.Append(":ROLEID,:ROLENAME,:ROLEINFO"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":ROLEID", OracleType.Number, 4), new OracleParameter(":ROLENAME", OracleType.VarChar, 50), new OracleParameter(":ROLEINFO", OracleType.VarChar, 20) }; parameters[0].Value = entity.ROLEID; parameters[1].Value = entity.ROLENAME; parameters[2].Value = entity.ROLEINFO; OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 添加数据 /// </summary> protected void btn_add_Click(object sender, EventArgs e) { if (txt_Name.Text.Trim() != "") { if (GroupList.SelectedValue != "all") { Entity.BASE_ROLE model = new Entity.BASE_ROLE(); model.RoleName = txt_Name.Text.Trim(); model.RoleDescription = txt_Description.Text.Trim(); model.RoleGroupID = int.Parse(GroupList.SelectedValue.ToString()); model.RoleOrder = int.Parse(txt_order.Text.Trim()); switch (bll.CreateRole(model)) { case 1: txt_Name.Text = ""; txt_Description.Text = ""; BindOrder(); break; case 2: strinfo.InnerHtml = Smart.Utility.JScript.errinfo("分组已经存在,请更换后重试!"); strinfo.Visible = true; break; default: strinfo.InnerHtml = Smart.Utility.JScript.errinfo("新增操作失败!"); strinfo.Visible = true; break; } } else { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("请选择角色分组!"); strinfo.Visible = true; } } }
/// <summary> /// 更新角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public bool UpdateRole(Entity.BASE_ROLE model) { return(dal.UpdateRole(model)); }
/// <summary> /// 添加角色 /// </summary> /// <param name="model"></param> public void Add(Entity.BASE_ROLE model) { roleDal.Add(model); }
/// <summary> /// /// </summary> /// <param name="model"></param> private void SetEntity(Entity.BASE_ROLE model) { this.TxtRoleName.Text = model.ROLENAME; this.txtdesc.Text = model.ROLEINFO; }
/// <summary> /// 修改角色信息 /// </summary> /// <param name="model">角色实体数据</param> /// <returns></returns> public bool update(Entity.BASE_ROLE model) { return(roleDal.Update(model)); }