private void GetSubMenuByParentID(MD_TabLinks TabLinkChildren, int TL_Parent, bool Interna) { MD_TabLinks TabLinks = new MD_TabLinks(); TabLinks.CT_Tab_LinkList = new List <Model.CT_Tab_Links>(); for (int j = 0; j < TabLinkChildren.CT_Tab_LinkList.Count; j++) { if (TabLinkChildren.CT_Tab_LinkList[j].TL_Parent == TL_Parent && TabLinkChildren.CT_Tab_LinkList[j] != null) { TabLinks.CT_Tab_LinkList.Add(TabLinkChildren.CT_Tab_LinkList[j]); } } for (int i = 0; i < TabLinks.CT_Tab_LinkList.Count; i++) { if (i == 0) { strNav.Append("<ul style='display:none'>"); } strNav.Append(" <li><a href=\"" + TabLinks.CT_Tab_LinkList[i].TL_Link + "\" class=\""); if (0 != TabLinks.CT_Tab_LinkList[i].TL_Parent && TabLinks.CT_Tab_LinkList[i].TL_Children > 0) { strNav.Append("rightarrow"); } strNav.Append("\" id=\"nav_" + TabLinks.CT_Tab_LinkList[i].TL_Text_EN.Trim() + "\">" + " " + (Interna ? TabLinks.CT_Tab_LinkList[i].TL_Text_EN.Trim() : TabLinks.CT_Tab_LinkList[i].TL_Text_CN.Trim()) + " " + "</a>"); GetSubMenuByParentID(TabLink, TabLinks.CT_Tab_LinkList[i].TL_Code, Interna); strNav.Append("</li>"); if (i == TabLinks.CT_Tab_LinkList.Count - 1) { strNav.Append("</ul>"); } } }
public string GetLevelLink(int UG_Code, string LinkUrl, bool Intern, out string ClassName) { MD_TabLinks _o = GetTabLevelList(UG_Code, LinkUrl); if (_o == null || _o.CT_Tab_LinkList == null) { ClassName = string.Empty; return(""); } else { string _LinkUrl = string.Empty; for (int i = 0; i < _o.CT_Tab_LinkList.Count; i++) { CT_Tab_Links _c = _o.CT_Tab_LinkList[i]; if (i != _o.CT_Tab_LinkList.Count - 1) { _LinkUrl += "<a class='brown' href='" + _c.TL_Link + "'>" + (Intern ? _c.TL_Text_EN : _c.TL_Text_CN) + "</a> > "; } else { _LinkUrl += "<span style='width:300px'>" + (Intern ? _c.TL_Text_EN : _c.TL_Text_CN) + "</span>"; } } ClassName = _o.CT_Tab_LinkList[0].TL_Text_EN; return(_LinkUrl); } }
private void GetSubMenuByID(MD_TabLinks TabLinkChildren, int TL_Parent, bool Interna, string hrefTittle) { MD_TabLinks TabLinks = new MD_TabLinks(); TabLinks.CT_Tab_LinkList = new List <Model.CT_Tab_Links>(); string subName = string.Empty; string tlCode = string.Empty; for (int j = 0; j < TabLinkChildren.CT_Tab_LinkList.Count; j++) { if (TabLinkChildren.CT_Tab_LinkList[j].TL_Parent == TL_Parent && TabLinkChildren.CT_Tab_LinkList[j] != null) { TabLinks.CT_Tab_LinkList.Add(TabLinkChildren.CT_Tab_LinkList[j]); } } if (TabLinks.CT_Tab_LinkList.Count == 0) { strNav.Append("<li><a href=\"#\" id=nav_" + TL_Parent + " onclick=\"addPanel('" + hrefTittle + "')\">" + hrefTittle + "</a></li>"); } else { for (int i = 0; i < TabLinks.CT_Tab_LinkList.Count; i++) { subName = Interna ? TabLinks.CT_Tab_LinkList[i].TL_Text_EN.Trim() : TabLinks.CT_Tab_LinkList[i].TL_Text_CN.Trim(); tlCode = TabLinks.CT_Tab_LinkList[i].TL_Code.ToString(); strNav.Append("<li><a href=\"#\" id=nav_" + tlCode + " onclick=\"addPanel('" + subName + "')\">" + subName + "</a></li>"); } } }
/// <summary> /// 根据某一Url 获取他的树形层级 /// </summary> /// <param name="UG_Code"></param> /// <param name="LinkUrl"></param> /// <returns></returns> public MD_TabLinks GetTabLevelList(int UG_Code, string LinkUrl) { SqlParameter[] parameters = { new SqlParameter("@UG_Code", SqlDbType.Int), new SqlParameter("@Link", SqlDbType.NVarChar) }; parameters[0].Value = UG_Code; parameters[1].Value = LinkUrl; DataSet ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "09_LK_GetCurrentPage", parameters); MD_TabLinks _o = new MD_TabLinks(); _o.CT_Tab_LinkList = DataHelper.ConvertToList <CT_Tab_Links>(ds); return(_o); }
public StringBuilder getTabLinkList(long UserCode, bool Interna) { TabLink = TbLinks.getTabLinkList(UserCode); strNav = new StringBuilder(); for (int i = 0; i < TabLink.CT_Tab_LinkList.Count; i++) { if (TabLink.CT_Tab_LinkList[i].TL_Parent == 0) { if (i != 0) { strNav.Append("<li class=\"nav_line\"></li>"); } strNav.Append(" <li><a href=\"" + TabLink.CT_Tab_LinkList[i].TL_Link + "\" class=\"\" id=\"nav_" + TabLink.CT_Tab_LinkList[i].TL_Text_EN.Trim() + "\">" + (Interna ? TabLink.CT_Tab_LinkList[i].TL_Text_EN.Trim() : TabLink.CT_Tab_LinkList[i].TL_Text_CN.Trim()) + "</a>"); GetSubMenuByParentID(TabLink, TabLink.CT_Tab_LinkList[i].TL_Code, Interna); strNav.Append("</li>"); } } return(strNav); }
public MD_TabLinks getTabLinkList(long UserCode) { StringBuilder strSql = new StringBuilder(); DataSet ds = new DataSet(); if (UserCode == 0) { strSql.Append("select TL_Code,TL_UG_Code,TL_Parent,TL_Level,TL_Order,TL_TagCD,TL_Text_EN,TL_Text_CN,TL_Link,TL_Children from CT_Tab_Links TL where TL_UG_Code=0 order by TL_Parent,TL_Order"); ds = SqlHelper.ExecuteDataset(strSql.ToString()); } else { strSql.Append("select TL_Code,TL_UG_Code,TL_Parent,TL_Level,TL_Order,TL_TagCD,TL_Text_EN,TL_Text_CN,TL_Link,TL_Children from CT_Tab_Links TL inner join CT_All_Users AU on TL.TL_UG_Code=AU.AU_UG_Code where AU.AU_Code=@AU_Code order by TL_Parent,TL_Order"); SqlParameter[] parameters = { new SqlParameter("@AU_Code", SqlDbType.Int) }; parameters[0].Value = UserCode; ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); } if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count <= 0) { return(null); } MD_TabLinks myTabLinkList = new MD_TabLinks(); myTabLinkList.CT_Tab_LinkList = new List <Model.CT_Tab_Links>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { myTabLinkList.CT_Tab_LinkList.Add(new Model.CT_Tab_Links { TL_Code = int.Parse(ds.Tables[0].Rows[i]["TL_Code"].ToString()), TL_UG_Code = int.Parse(ds.Tables[0].Rows[i]["TL_UG_Code"].ToString()), TL_Parent = int.Parse(ds.Tables[0].Rows[i]["TL_Parent"].ToString()), TL_Level = int.Parse(ds.Tables[0].Rows[i]["TL_Level"].ToString()), TL_Order = int.Parse(ds.Tables[0].Rows[i]["TL_Order"].ToString()), TL_TagCD = ds.Tables[0].Rows[i]["TL_TagCD"].ToString(), TL_Text_EN = ds.Tables[0].Rows[i]["TL_Text_EN"].ToString(), TL_Text_CN = ds.Tables[0].Rows[i]["TL_Text_CN"].ToString(), TL_Link = ds.Tables[0].Rows[i]["TL_Link"].ToString(), TL_Children = int.Parse(ds.Tables[0].Rows[i]["TL_Children"].ToString()) }); } return(myTabLinkList); }
public StringBuilder getTabLinkListForHelpSystem(long UserCode, bool Interna, string pagePath, out string pageOnLoad) { string pageTittle = string.Empty; string pageTittleContent = string.Empty; pageTittle = TbLinks.getTabName(pagePath, UserCode); pageTittleContent = pageTittle; TabLink = TbLinks.getTabLinkList(UserCode); strNav = new StringBuilder(); string hrefTittle = string.Empty; for (int i = 0; i < TabLink.CT_Tab_LinkList.Count; i++) { if (TabLink.CT_Tab_LinkList[i].TL_Parent == 0) { hrefTittle = Interna ? TabLink.CT_Tab_LinkList[i].TL_Text_EN.Trim() : TabLink.CT_Tab_LinkList[i].TL_Text_CN.Trim(); if (hrefTittle == pageTittle) { strNav.Append("<li><span>" + hrefTittle + "</span><ul>"); GetSubMenuByID(TabLink, TabLink.CT_Tab_LinkList[i].TL_Code, Interna, hrefTittle); strNav.Append("</ul></li>"); } else { strNav.Append("<li data-options=\"state:'closed'\"><span>" + hrefTittle + "</span><ul>"); GetSubMenuByID(TabLink, TabLink.CT_Tab_LinkList[i].TL_Code, Interna, hrefTittle); strNav.Append("</ul></li>"); } } } if (!String.IsNullOrEmpty(pageTittle)) { pageOnLoad = "window.onload = function () {$('#tt').tabs('add', {title: \'" + pageTittle + "\',content: '<div style=\"padding:10\"><div style=\"padding:10\"><img src=\"/images/HelpDocument/PieChart.png\"/></div>',closable: true}); tittleList ='" + pageTittle + "'}"; } else { pageOnLoad = "function test(){}"; } return(strNav); }