/// <summary> /// 更新角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public bool UpdateRole(RedGlovePermission.Model.RGP_Roles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RGP_Roles set "); strSql.Append("RoleGroupID=@RoleGroupID,"); strSql.Append("RoleName=@RoleName,"); strSql.Append("RoleDescription=@RoleDescription"); 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) }; parameters[0].Value = model.RoleID; parameters[1].Value = model.RoleGroupID; parameters[2].Value = model.RoleName; parameters[3].Value = model.RoleDescription; if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { return(true); } else { return(false); } }
/// <summary> /// 添加数据 /// </summary> protected void btn_add_Click(object sender, EventArgs e) { if (txt_Name.Text.Trim() != "") { RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles(); model.RoleName = txt_Name.Text.Trim(); model.RoleDescription = txt_Description.Text.Trim(); model.RoleGroupID = int.Parse(GroupList.SelectedValue); switch (bll.CreateRole(model)) { case 1: txt_Name.Text = ""; txt_Description.Text = ""; BindOrder(); ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true); break; case 2: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Isgroup") + "')", true); break; default: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true); break; } } }
/// <summary> /// 增加角色 /// </summary> /// <param name="model">角色实体类</param> /// <returns></returns> public int CreateRole(RedGlovePermission.Model.RGP_Roles model) { int ret = 0; if (!RoleExists(model.RoleName, model.RoleGroupID)) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RGP_Roles("); strSql.Append("RoleGroupID,RoleName,RoleDescription)"); strSql.Append(" values ("); strSql.Append("@RoleGroupID,@RoleName,@RoleDescription)"); SqlParameter[] parameters = { new SqlParameter("@RoleGroupID", SqlDbType.Int, 4), new SqlParameter("@RoleName", SqlDbType.NVarChar, 30), new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.RoleGroupID; parameters[1].Value = model.RoleName; parameters[2].Value = model.RoleDescription; if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { ret = 1; } } else { ret = 2; } return(ret); }
/// <summary> /// 获取角色实体 /// </summary> /// <param name="RoleID">角色ID</param> /// <returns></returns> public RedGlovePermission.Model.RGP_Roles GetRoleModel(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from RGP_Roles "); strSql.Append(" where RoleID=@RoleID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "") { model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["RoleRoleID"].ToString() != "") { model.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString()); } model.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString(); model.RoleDescription = ds.Tables[0].Rows[0]["RoleDescription"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新数据 /// </summary> protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e) { RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles(); 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); if (!bll.UpdateRole(model)) { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true); } //返回浏览狀態 RolesLists.EditIndex = -1; BindOrder(); }
/// <summary> /// 获取角色实体 /// </summary> /// <param name="RoleID">角色ID</param> /// <returns></returns> public RedGlovePermission.Model.RGP_Roles GetRoleModel(int RoleID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 * from RGP_Roles "); strSql.Append(" where RoleID=@RoleID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int,4)}; parameters[0].Value = RoleID; RedGlovePermission.Model.RGP_Roles model=new RedGlovePermission.Model.RGP_Roles(); DataSet ds=SqlServerHelper.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["RoleID"].ToString()!="") { model.RoleID=int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString()); } if(ds.Tables[0].Rows[0]["RoleRoleID"].ToString()!="") { model.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString()); } model.RoleName=ds.Tables[0].Rows[0]["RoleName"].ToString(); model.RoleDescription=ds.Tables[0].Rows[0]["RoleDescription"].ToString(); return model; } else { return null; } }
/// <summary> /// 添加数据 /// </summary> protected void btn_add_Click(object sender, EventArgs e) { if (txt_Name.Text.Trim() != "") { RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles(); model.RoleName = txt_Name.Text.Trim(); model.RoleDescription = txt_Description.Text.Trim(); model.RoleGroupID = int.Parse(GroupList.SelectedValue); switch (bll.CreateRole(model)) { case 1: txt_Name.Text = ""; txt_Description.Text = ""; BindOrder(); ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true); break; case 2: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Isgroup") + "')", true); break; default: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true); break; } } }
/// <summary> /// 更新数据 /// </summary> protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e) { RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles(); 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); if (!bll.UpdateRole(model)) { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true); } //返回浏览狀態 RolesLists.EditIndex = -1; BindOrder(); }