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);
}