protected StringBuilder BindTreeView() { string a = PlatformID; StringBuilder str = new StringBuilder(); str.Append(ParentID + "_Child|||"); List <ModuleEO> modellist = new List <ModuleEO>(); //得到模块权限和角色的列表 List <RolemoduleEO> rmplist = new List <RolemoduleEO>(); rmplist = (List <RolemoduleEO>)System.Web.HttpContext.Current.Session["RmpList"]; //modellist = (List<ModuleEO>)mdManage.Get("Md_parentid='" + ParentID + "' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder"); IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Md_parentid=@Md_parentid AND Md_deleteFlag<>1 ORDER BY Md_filedOrder"); parm.Add(new MySqlParameter("@Md_parentid", ParentID)); modellist = (List <ModuleEO>)mdManage.Get(strWhere.ToString(), parm); foreach (ModuleEO model in modellist) { //是否有下级内容 bool IsChild = true; IList <MySqlParameter> parmC = new List <MySqlParameter>(); StringBuilder strWhereC = new StringBuilder(); strWhereC.Append(" Md_parentid=@Md_parentid and Md_existsTreeView='1' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder"); parmC.Add(new MySqlParameter("@Md_parentid", model.MdId)); if (mdManage.Get(strWhereC.ToString(), parmC) != null) //if (mdManage.Get("Md_parentid='" + model.MdId + "'and Md_existsTreeView='1' AND Md_deleteFlag<>1 ORDER BY Md_filedOrder") != null) { IsChild = true; } else { IsChild = false; } //最外层div格式 if (IsChild) { str.Append("<div id=" + model.MdId + " class=\"moduleChildYes\">"); } else { str.Append("<div id=" + model.MdId + " class=\"moduleChildNo\">"); } //最外层div中,顶级模块表格式 str.Append("<table class=\"ModuleTeble\">"); str.Append("<tr>"); str.Append("<td><div class=\"MapShow\" id=\"" + model.MdId + "_Map\"></div></td>"); if (IsChild) { if (model.MdImgUrl == "") { str.Append("<td></td>"); } else { str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\"/ ></td>"); } if (PubFuncs.IsLanguageEng()) { str.Append("<td><div class=\"ChildTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\" >" + model.MdText1.Trim() + "</a></td>"); } else { str.Append("<td><div class=\"ChildTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "')\" >" + model.MdName.Trim() + "</a></td>"); } } else { if (model.MdImgUrl == "") { str.Append("<td></td>"); } else { str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','" + model.MdId.Trim() + "_Child','1','" + RoleID + "')\"/ ></td>"); } str.Append("<td><div class=\"ChildTitleNo\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','1','" + RoleID + "')\" >" + model.MdName.Trim() + "</a></div></td>"); } str.Append("</div>"); //加载权限列表 List <PermissionstatalEO> plist = new List <PermissionstatalEO>(); StringBuilder strWhereX = new StringBuilder(); strWhereX.Append(" 1=1"); IList <MySqlParameter> parmX = new List <MySqlParameter>(); strWhereX.Append(" and APerTat.Pt_del<>1 and APerTat.Pf_id=@Pf_id and AMoudlePer.Md_id = @Md_id"); parmX.Add(new MySqlParameter("@Pf_id", PlatformID)); parmX.Add(new MySqlParameter("@Md_id", model.MdId)); plist = (List <PermissionstatalEO>)ptManage.Gets(strWhereX.ToString(), parmX); //plist = (List<PermissionstatalEO>)ptManage.Gets(" APerTat.Pt_del<>1 and APerTat.Pf_id='" + PlatformID + "' and AMoudlePer.Md_id = '" + model.MdId + "'"); //List<RolemoduleEO> mplist = new List<RolemoduleEO>(); string permissionsIdList = ""; int int_ls = 0; StringBuilder strls = new StringBuilder(); foreach (PermissionstatalEO mpmodel in plist) { int_ls++; StringBuilder strWhereL = new StringBuilder(); strWhereL.Append(" 1=1"); IList <MySqlParameter> parmL = new List <MySqlParameter>(); strWhereL.Append(" and Rl_id=@Rl_id and Md_id=@Md_id and Pt_id=@Pt_id"); parmL.Add(new MySqlParameter("@Rl_id", RoleID)); parmL.Add(new MySqlParameter("@Md_id", model.MdId)); parmL.Add(new MySqlParameter("@Pt_id", mpmodel.PtId)); if (rlmdManage.GetTable(strWhereL.ToString(), parmL).Rows.Count > 0) //if (rlmdManage.GetTable("Rl_id='" + RoleID + "' and Md_id='" + model.MdId + "' and Pt_id='" + mpmodel.PtId + "'").Rows.Count > 0) { strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" checked=\"checked\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />"); strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>"); } else { strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />"); strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>"); } if (int_ls == 1) { permissionsIdList += mpmodel.PtId; } else { permissionsIdList += "|" + mpmodel.PtId; } } if (int_ls != 0) { str.Append("<td><div class=\"chackall\"><input type=\"checkbox\" id=\"" + model.MdId + "_all\" value=\"\" style=display:none onclick=\"Permsave('1','" + model.MdId + "','" + RoleID + "','','" + PlatformID + "')\"/><span> </span></div></td>"); str.Append("<td><div class=\"check\">"); str.Append(strls.ToString()); str.Append("</div><input type=\"hidden\" id=\"" + model.MdId + "_hidden\" value=\"" + permissionsIdList + "\">"); str.Append("</td>"); } int_ls = 0; str.Append("</tr>"); str.Append("</table>"); //下级最外层Div格式 if (IsChild) { str.Append("<div id=\"" + model.MdId.Trim() + "_Child\" class=\"moduleChild\" style=\"display:none;\"></div>"); } str.Append("</div>"); } return(str); }
protected void BindTreeView() { StringBuilder str = new StringBuilder(); List <ModuleEO> modellist = new List <ModuleEO>(); //得到模块权限和角色的列表 List <RolemoduleEO> rmplist = new List <RolemoduleEO>(); rmplist = (List <RolemoduleEO>)Session["RmpList"]; IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Pf_id = @Pf_id AND Md_parentid='0' AND Md_deleteFlag <>1 ORDER BY Md_filedOrder"); parm.Add(new MySqlParameter("@Pf_id", PlatformID)); //modellist = (List<ModuleEO>)mdManage.Get(" Pf_id = '" + PlatformID + "' AND Md_parentid='0' AND Md_deleteFlag <>1 ORDER BY Md_filedOrder"); modellist = (List <ModuleEO>)mdManage.Get(strWhere.ToString(), parm); foreach (ModuleEO model in modellist) { //是否有下级内容 bool IsChild = true; //if (mdManage.Get("Md_parentid='" + model.MdId + "' AND Md_deleteFlag <>1 ORDER BY Md_filedOrder") != null) IList <MySqlParameter> parmC = new List <MySqlParameter>(); StringBuilder strWhereC = new StringBuilder(); strWhereC.Append(" Md_parentid=@Md_parentid AND Md_deleteFlag <>1 ORDER BY Md_filedOrder"); parmC.Add(new MySqlParameter("@Md_parentid", model.MdId)); if (mdManage.Get(strWhereC.ToString(), parmC) != null) { IsChild = true; } else { IsChild = false; } //最外层div格式 if (IsChild) { str.Append("<div id=" + model.MdId + " class=\"TopParentDivYes\">"); } else { str.Append("<div id=" + model.MdId + " class=\"TopParentDivNo\">"); } //最外层div中,顶级模块表格式 str.Append("<table class=\"TopModuleTeble\">"); str.Append("<tr>"); str.Append("<td><div class=\"MapShow\" id=\"" + model.MdId + "_Map\"></div></td>"); //是否有下级目录 if (IsChild) { if (model.MdImgUrl == "") { str.Append("<td></td>"); } else { str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "','" + PlatformID + "')\" /></td>"); } if (IsLanguageEng()) { str.Append("<td><div class=\"TopParentTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "','" + PlatformID + "')\" >" + model.MdText1.Trim() + "</a></div></td>"); } else { str.Append("<td><div class=\"TopParentTitleYes\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','0','" + RoleID + "','" + PlatformID + "')\" >" + model.MdName.Trim() + "</a></div></td>"); } } else { if (model.MdImgUrl == "") { str.Append("<td></td>"); } else { str.Append("<td><img src=\"" + model.MdImgUrl + "\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','1','" + RoleID + "','" + PlatformID + "')\" ></td>"); } if (IsLanguageEng()) { str.Append("<td ><div class=\"TopParentTitleNo\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','1','" + RoleID + "','" + PlatformID + "')\" >" + model.MdText1.Trim() + "</a></div></td>"); } else { str.Append("<td ><div class=\"TopParentTitleNo\"><a href=\"#\" onclick=\"javascrpt:TreeViewSpread('" + model.MdId + "','1','" + RoleID + "','" + PlatformID + "')\" >" + model.MdName.Trim() + "</a></div></td>"); } } //加载权限列表 List <PermissionstatalEO> plist = new List <PermissionstatalEO>(); StringBuilder strWhereQ = new StringBuilder(); strWhereQ.Append(" 1=1"); IList <MySqlParameter> parmQ = new List <MySqlParameter>(); strWhereQ.Append(" and APerTat.Pt_del<>1 and APerTat.Pf_id=@Pf_id and AMoudlePer.Md_id = @Md_id"); parmQ.Add(new MySqlParameter("@Pf_id", PlatformID)); parmQ.Add(new MySqlParameter("@Md_id", model.MdId)); plist = (List <PermissionstatalEO>)ptManage.Gets(strWhereQ.ToString(), parmQ); //plist = (List<PermissionstatalEO>)ptManage.Gets(" APerTat.Pt_del<>1 and APerTat.Pf_id='" + PlatformID + "' and AMoudlePer.Md_id = '" + model.MdId + "'"); string permissionsIdList = ""; int int_ls = 0; StringBuilder strls = new StringBuilder(); foreach (PermissionstatalEO mpmodel in plist) { int_ls++; //是否已选择了权限 if (ISPerm(model.MdId, mpmodel.PtId)) { strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" checked=\"checked\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />"); strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>"); } else { strls.Append("<input type=\"checkbox\" id=\"" + model.MdId + "_" + mpmodel.PtId + "\" value=\"" + ISPermName(mpmodel.PtId, plist) + "\" onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\" />"); strls.Append("<span onclick=\"Permsave('0','" + model.MdId + "','" + RoleID + "','" + mpmodel.PtId + "','" + PlatformID + "')\">" + ISPermName(mpmodel.PtId, plist) + "</span>"); } if (int_ls == 1) { permissionsIdList += mpmodel.PtId; } else { permissionsIdList += "|" + mpmodel.PtId; } } if (int_ls != 0) { str.Append("<td><div class=\"checkall\"><input type=\"checkbox\" id=\"" + model.MdId + "_all\" value=\"\" style=display:none onclick=\"Permsave('1','" + model.MdId + "','" + RoleID + "','','" + PlatformID + "')\"/><span onclick=\"Permsave('1','" + model.MdId + "','" + RoleID + "','','" + PlatformID + "')\"> </span></div></td>"); str.Append("<td><div class=\"chack\">"); str.Append(strls.ToString()); str.Append("</div><input type=\"hidden\" id=\"" + model.MdId + "_hidden\" value=\"" + permissionsIdList + "\">"); str.Append("</td>"); } int_ls = 0; str.Append("</tr>"); str.Append("</table>"); //下级最外层Div格式 if (IsChild) { str.Append("<div id=\"" + model.MdId.Trim() + "_Child\" class=\"TopModuleChild\" style=\"display:none;\"></div>"); } str.Append("</div>"); } if (!string.IsNullOrEmpty(str.ToString())) { PermissionsTree.InnerHtml = str.ToString(); } else { PermissionsTree.InnerHtml = "暂无数据"; } }