protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try{ string RoleId = Request.QueryString["RoleId"]; ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); ljxpower.Model.tb_roles model = bll.GetModel(int.Parse(RoleId)); lblRole.Text = model.RolesName; HdId.Value = RoleId; BindDataList(); }catch { Response.Redirect("RolesList.html"); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string RoleId = "0"; if (context.Request.QueryString["type"] == "edit")//获取角色信息 { int Id = int.Parse(context.Request.QueryString["Id"]); ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); ljxpower.Model.tb_roles model = bll.GetModel(Id); StringBuilder sb = new StringBuilder(); sb.Append(model.RolesName + ","); sb.Append(model.Remark + ","); ljxpower.BLL.com_user ubll = new ljxpower.BLL.com_user(); List <ljxpower.Model.com_user> list = ubll.GetModelList(" Userid in(select UserId from tb_rolesadduser where RolesId=" + Id + ")"); foreach (ljxpower.Model.com_user item in list) { sb.Append("<div onclick='ss(" + item.userid + ")' height='23px'><input type='hidden' value='" + item.userid + "' />" + item.password + "|" + item.username + "</div>"); } context.Response.Write(sb.ToString()); } else if (context.Request.QueryString["type"] == "getUser")//获取未绑定到当前角色的用户 { StringBuilder sb = new StringBuilder(); ljxpower.BLL.com_user ubll = new ljxpower.BLL.com_user(); List <ljxpower.Model.com_user> list = new List <ljxpower.Model.com_user>(); //if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") //{ // int Id = int.Parse(context.Request.QueryString["Id"]); // list = ubll.GetModelList(" Userid not in(select UserId from tb_rolesadduser where RolesId=" + Id + ")"); //} //else //{ list = ubll.GetModelList(""); // } foreach (ljxpower.Model.com_user item in list) { sb.Append("<div><input name=\"chkItem\" value=\"<div onclick='ss(" + item.userid + ")' height='23px'><input type='hidden' value='" + item.userid + "' />" + item.password + "|" + item.username + "</div>\" type=\"checkbox\" /> "); sb.Append(item.password + "|" + item.username + "</div>"); } context.Response.Write(sb.ToString()); } else if (context.Request.QueryString["type"] == "save")//保存角色信息 { string name = context.Request.QueryString["name"]; string remark = context.Request.QueryString["remark"]; int Id = int.Parse(context.Request.QueryString["Id"]); ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); ljxpower.Model.tb_roles model = bll.GetModel(Id); model.Remark = remark; model.RolesName = name; context.Response.Write(bll.Update1(model)); } else if (context.Request.QueryString["type"] == "add")//添加 { string name = context.Request.QueryString["name"]; string remark = context.Request.QueryString["remark"]; ljxpower.Model.tb_roles model = new ljxpower.Model.tb_roles(); ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); model.Remark = remark; model.RolesName = name; if (bll.Add1(model) > 0) { context.Response.Write("true"); } else { context.Response.Write("false"); } } else if (context.Request.QueryString["type"] == "delRole")//删除角色 { int Id = int.Parse(context.Request.QueryString["Id"]); ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); ljxpower.BLL.tb_rolesadduser rbll = new ljxpower.BLL.tb_rolesadduser(); rbll.Delete(Id); context.Response.Write(bll.Delete(Id)); } else if (context.Request.QueryString["type"] == "Distri")//获取已分配的权限 { int Id = int.Parse(context.Request.QueryString["Id"]); ljxpower.BLL.tb_rolesandnavigation bll = new ljxpower.BLL.tb_rolesandnavigation(); List <ljxpower.Model.tb_rolesandnavigation> list = new List <ljxpower.Model.tb_rolesandnavigation>(); list = bll.GetModelList(" RolesId=" + Id); StringBuilder sb = new StringBuilder(); foreach (ljxpower.Model.tb_rolesandnavigation model in list) { sb.Append(model.NavigationId + ","); } if (sb.Length > 0) { sb.Remove(sb.Length - 1, 1); } context.Response.Write(sb.ToString()); } else if (context.Request.QueryString["type"] == "saveDistri") { int Id = int.Parse(context.Request.QueryString["Id"]); string nav = context.Request.QueryString["nav"]; string[] str = nav.Split(','); List <string> list = new List <string>(); string sql = "delete tb_rolesandnavigation where RolesId=" + Id; foreach (string ss in str) { ljxpower.BLL.tb_navigation bll = new ljxpower.BLL.tb_navigation(); ljxpower.Model.tb_navigation model = bll.GetModel(int.Parse(ss)); if (model.ParentId != 0) { string sql3 = "delete tb_rolesandnavigation where RolesId=" + Id + " and NavigationId=" + model.ParentId; string sql1 = "insert into tb_rolesandnavigation (RolesId,NavigationId) values(" + Id + "," + model.ParentId + ")"; list.Add(sql3); list.Add(sql1); } string sql2 = "insert into tb_rolesandnavigation (RolesId,NavigationId) values(" + Id + "," + ss + ")"; list.Add(sql2); } ljxpower.Common.DbHelperMySQL.ExecuteSqlTran(list); } else if (context.Request.QueryString["type"] == "savenav") { RoleId = context.Request["RoleId"].ToString(); string NavId = context.Request["NavId"].ToString(); List <string> list = new List <string>(); list.Add("delete from tb_rolesandnavigation where RolesId=" + RoleId); string[] str = NavId.Split('|'); for (int i = 0; i < str.Length - 1; i++) { string[] str2 = str[i].Split(','); if (str2.Length == 2) { list.Add(" insert into tb_rolesandnavigation(RolesId,NavigationId,ButtonId) values(" + RoleId + "," + str2[0] + ",0)"); } else { for (int j = 1; j < str2.Length - 1; j++) { list.Add(" insert into tb_rolesandnavigation(RolesId,NavigationId,ButtonId) values(" + RoleId + "," + str2[0] + "," + str2[j] + ")"); } } } ljxpower.Common.DbHelperMySQL.ExecuteSqlTran(list); context.Response.Write("Hello World"); } else if (context.Request.QueryString["type"] == "query") { ljxpower.BLL.tb_roles bll = new ljxpower.BLL.tb_roles(); List <ljxpower.Model.tb_roles> list = bll.GetModelList(""); StringBuilder sb = new StringBuilder(); sb.Append("["); foreach (ljxpower.Model.tb_roles item in list) { sb.Append("{\"Id\":" + item.Id + ","); sb.Append("\"Name\":\"" + item.RolesName + "\","); sb.Append("\"Remark\":\"" + item.Remark + "\"},"); } if (sb.Length > 1) { sb.Remove(sb.Length - 1, 1); } sb.Append("]"); context.Response.Write(sb.ToString()); } ///////////////////////////////////// else if (context.Request["type"].ToString() == "ljxquery") { RoleId = context.Request["RoleId"].ToString(); getdata(RoleId, context); } else if (context.Request["type"] == "pageload") { //设置内容权限,读取内容权限,保留在本页中。 string str1 = context.Request.UrlReferrer.LocalPath; if (str1.Length > 3) { str1 = str1.Substring(1); } string pageljxfun = getstrif(str1, context); context.Response.Write(pageljxfun); //context.Response.Write("OK"); //return; } else if (context.Request["type"] == "ljxsave") { //设置内容权限,读取内容权限,保留在本页中。 RoleId = context.Request["RoleId"].ToString(); string NavId = context.Request["NavId"].ToString(); List <string> list = new List <string>(); list.Add("delete from tb_rolesandnavigation where RolesId=" + RoleId); string[] str = NavId.Split('|'); for (int i = 0; i < str.Length - 1; i++) { string[] str2 = str[i].Split(','); if (str2.Length == 2) { list.Add(" insert into tb_rolesandnavigation(RolesId,NavigationId,ButtonId) values(" + RoleId + "," + str2[0] + ",0)"); } else { for (int j = 1; j < str2.Length - 1; j++) { list.Add(" insert into tb_rolesandnavigation(RolesId,NavigationId,ButtonId) values(" + RoleId + "," + str2[0] + "," + str2[j] + ")"); } } } ljxpower.Common.DbHelperMySQL.ExecuteSqlTran(list); context.Response.Write("OK"); //return; } }