private string isParent()
{
int Menu_ID = CommonLib.CheckNullInt(Request["Menu_ID"]);
if (Menu_ID > 0)
{
HPCBusinessLogic.UltilFunc ultilDAL = new UltilFunc();
if (CommonLib.isParrentMenu(Menu_ID))
{
return(Menu_ID.ToString());
}
else
{
return(UltilFunc.GetColumnValues("T_Chucnang", "Ma_Chucnang_Cha", " Ma_Chucnang=" + Menu_ID.ToString()));
}
}
else
{
return("0");
}
}
public string BindNavigation(int User_ID)
{
StringBuilder _sbHeader = new StringBuilder();
StringBuilder _sb = new StringBuilder();
string _tmp = string.Empty;
if (Ma_QTBT != 0)
{
_tmp = GetMenu4User(User_ID, Ma_QTBT);
}
DataTable _dt;
DataTable _dtChild;
string _sql = string.Empty; string _sqlChild = string.Empty;
_sql = "BindNavigationByUserID";
HPCBusinessLogic.UltilFunc _untilDAL = new HPCBusinessLogic.UltilFunc();
_sb.Append(" <tr> <td align=\"left\"> <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\"> <tr>");
_sb.Append(" <td width=\"2px\"> </td>");
try
{
_dt = _untilDAL.GetStoreDataSet(_sql, new string[] { "@User_ID" }, new object[] { User_ID }).Tables[0];
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
if (CommonLib.CheckNullInt(_dt.Rows[i]["node"]) > 0)
{
_sb.Append("<td class=\"MenuBar\"><div id=\"idchildMenu\" onmouseover=\"ShowMenu('SubMenu" + CommonLib.CheckNullStr(_dt.Rows[i]["Ma_Chucnang"]) + "')\" onmouseout=\"HideMenu('SubMenu" + CommonLib.CheckNullStr(_dt.Rows[i]["Ma_Chucnang"]) + "',2)\" >");
_sb.Append(" <div id=\"Menu" + CommonLib.CheckNullStr(_dt.Rows[i]["Ma_Chucnang"]) + "\">");
_sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td width=\"6\">");
if (CommonLib.CheckNullInt(isParent()) == CommonLib.CheckNullInt(_dt.Rows[i]["Ma_Chucnang"]))
{
_sb.Append("<img src='" + Global.ApplicationPath + "/Dungchung/images/Active/Left.jpg'>");
_sb.Append("</td>");
_sb.Append("<td background=\"" + Global.ApplicationPath + "/Dungchung/images/Active/Center.jpg\" style=\"background-repeat: repeat-x;\">");
}
else
{
_sb.Append("<img src='" + Global.ApplicationPath + "/Dungchung/images/Left.jpg'>");
_sb.Append("</td>");
_sb.Append("<td background=\"" + Global.ApplicationPath + "/Dungchung/images/Center.jpg\" style=\"background-repeat: repeat-x;\">");
}
_sb.Append("<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" class=\"MenuBar\"><tr>");
if (CommonLib.CheckNullStr(_dt.Rows[i]["Icon"]).Length > 0)
{
_sb.Append("<td><img alt=\"\" src=\"" + UltilFunc.TinPath + CommonLib.CheckNullStr(_dt.Rows[i]["Icon"]) + "\" align=\"absmiddle\" onload=\"FixPNG(this)\" /></td>");
}
if (CommonLib.CheckNullInt(isParent()) == CommonLib.CheckNullInt(_dt.Rows[i]["Ma_Chucnang"]))
{
_sb.Append("<td class=\"TextAtive\">");
}
else
{
_sb.Append("<td class=\"Text\">");
}
if (CommonLib.CheckNullStr(_dt.Rows[i]["URL_Chucnang"]).Length > 0)
{
_sb.Append("<a href=\"" + Global.ApplicationPath + CommonLib.CheckNullStr(_dt.Rows[i]["URL_Chucnang"]) + "\">" + CommonLib.CheckNullStr(_dt.Rows[i]["Ten_chucnang"]) + "</a>");
}
else
{
_sb.Append(CommonLib.CheckNullStr(_dt.Rows[i]["Ten_chucnang"]));
}
if (CommonLib.CheckNullInt(isParent()) == CommonLib.CheckNullInt(_dt.Rows[i]["Ma_Chucnang"]))
{
_sb.Append("</td><td><img src=\"" + Global.ApplicationPath + "/Dungchung/images/Active/Arrow.gif\" alt=\"\" /></td></tr></table></td>");
}
else
{
_sb.Append("</td><td><img src=\"" + Global.ApplicationPath + "/Dungchung/images/Arrow.gif\" alt=\"\" /></td></tr></table></td>");
}
_sb.Append("<td width=\"6\">");
if (CommonLib.CheckNullInt(isParent()) == CommonLib.CheckNullInt(_dt.Rows[i]["Ma_Chucnang"]))
{
_sb.Append("<img src=\"" + Global.ApplicationPath + "/Dungchung/images/Active/Right.jpg\">");
}
else
{
_sb.Append("<img src=\"" + Global.ApplicationPath + "/Dungchung/images/Right.jpg\">");
}
_sb.Append("</td></tr></table></div>");
if (_tmp.Length == 1)
{
_sqlChild = "SELECT Ten_chucnang,URL_Chucnang,STT,Ma_Chucnang,Icon,Mota,Quytrinh,Ma_Doituong,(select count(*) FROM T_Chucnang WHERE T_Chucnang.HoatDong=1 and Ma_Chucnang_Cha = mn.Ma_Chucnang) childnodecount ";
_sqlChild += " FROM T_Chucnang mn WHERE mn.HoatDong=1 and Ma_Chucnang_Cha = " + _dt.Rows[i]["Ma_Chucnang"] + " AND Ma_Chucnang =" + _tmp + " ORDER BY mn.STT";
}
else
{
_sqlChild = " SELECT Ten_chucnang,[dbo].[fn_MenuQuytrinh]('" + Ma_QTBT + "',Quytrinh,Ma_Chucnang) as URL_Chucnang,STT,Ma_Chucnang,Icon,Mota,Quytrinh,Ma_Doituong,(select count(*) FROM T_Chucnang WHERE T_Chucnang.HoatDong=1 and Ma_Chucnang_Cha = mn.Ma_Chucnang) childnodecount";
_sqlChild += " FROM T_Chucnang mn WHERE mn.HoatDong=1 and Ma_Chucnang_Cha = " + _dt.Rows[i]["Ma_Chucnang"] + " AND Ma_Chucnang IN (" + _tmp + ") ORDER BY mn.STT";
}
try
{
_dtChild = _untilDAL.ExecSqlDataSet(_sqlChild).Tables[0];
if (_dtChild.Rows.Count > 0)
{
_sb.Append("<div id=\"SubMenu" + CommonLib.CheckNullStr(_dt.Rows[i]["Ma_Chucnang"]) + "\" class=\"Hide\">");
_sb.Append("<div style=\"padding-top: 0px; position: absolute;z-index:200px;\" align=\"left\">");
_sb.Append("<div style=\"width: 200px; padding-top: 5px;z-index:50000px;\" class=\"SubMenu\">");
_sb.Append("<table border=\"0\" class=\"cssMenuTables\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">");
for (int j = 0; j < _dtChild.Rows.Count; j++)
{
_sb.Append("<tr class=\"SubMenuItem\" onmouseover=\"this.className='SubMenuItemOver'\" onmouseout=\"this.className='SubMenuItem'\">");
_sb.Append("<td width=\"100%\" style=\"padding-top: 5px;\">");
_sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" height=\"100%\" align=\"center\">");
_sb.Append("<tr> <td width=\"24px\" align=\"left\" style=\"padding-left: 4px;\" valign=\"top\">");
_sb.Append("<td style=\"padding-right: 10px;\" align=\"left\">");
bool quytrinh = Convert.ToBoolean(_dtChild.Rows[j]["Quytrinh"].ToString());
if (quytrinh == true)
{
_sb.Append("<a class=\"SubMenuItem\" href='" + Global.ApplicationPath + "/" + _dtChild.Rows[j]["URL_Chucnang"].ToString() + "?Menu_ID=" + _dtChild.Rows[j]["Ma_Chucnang"].ToString() + "&MaDoiTuong=" + _dtChild.Rows[j]["Ma_Doituong"].ToString() + "'>" + CommonLib.CheckNullStr(_dtChild.Rows[j]["Ten_chucnang"]) + "</a>");
}
else
{
_sb.Append("<a class=\"SubMenuItem\" href='" + Global.ApplicationPath + "/" + _dtChild.Rows[j]["URL_Chucnang"].ToString() + "?Menu_ID=" + _dtChild.Rows[j]["Ma_Chucnang"].ToString() + "'>" + CommonLib.CheckNullStr(_dtChild.Rows[j]["Ten_chucnang"]) + "</a>");
}
_sb.Append("<div class=\"SubMenuItemDesc\" align=\"left\" style=\"padding-top: 3px; font-size: 10px\">");
_sb.Append(CommonLib.CheckNullStr(_dtChild.Rows[j]["Mota"]));
_sb.Append(" </div> </td> </tr> <tr><td height=\"10px\" > </td></tr></table></td></tr>");
}
_sb.Append("</table></div></div> </div> ");
}
}
catch (Exception ex)
{
throw ex;
}
_sb.Append(" </div></td><td width=\"2px\"></td>");
}
else
{
//_sb.Append("<td class=\"MenuBar\"><div>");
//_sb.Append(" <div id=\"Menu" + CommonLib.CheckNullStr(_dt.Rows[i]["Ma_Chucnang"]) + "\">");
//_sb.Append("<td background=\"" + Global.ApplicationPath + "/Dungchung/images/Center.jpg\" style=\"background-repeat: repeat-x;\">");
//_sb.Append("<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" class=\"MenuBar\"><tr>");
//if (CommonLib.CheckNullStr(_dt.Rows[i]["URL_Chucnang"]).Length > 0)
//{
// _sb.Append("<td class=\"Text\"><a href=\"" + Global.ApplicationPath + CommonLib.CheckNullStr(_dt.Rows[i]["URL_Chucnang"]) + "\">" + CommonLib.CheckNullStr(_dt.Rows[i]["Ten_chucnang"]) + "</a></td><td><img src=\"" + Global.ApplicationPath + "/images/Arrow.gif\" alt=\"\" /></td></tr></table></td>");
//}
//else
//{
// _sb.Append("<td class=\"Text\">" + CommonLib.CheckNullStr(_dt.Rows[i]["Ten_chucnang"]) + "</td>");
//}
//_sb.Append("</td></tr></table></td><td width=\"6\"><img src=\"" + Global.ApplicationPath + "/Dungchung/images/Right.jpg\"></td></tr></table></div>");
//_sb.Append(" </div></td><td width=\"5px\"></td>");
}
}
}
}
catch (Exception ex)
{
throw ex;
}
_sb.Append(" </tr> </table></td> </tr> <tr><td height=\"4\" bgcolor=\"#167cba\" align=\"right\"/></tr>");
return(_sb.ToString());
}