public string GetMenu4User(int User_ID, int MaAnpham)
{
HPCBusinessLogic.UltilFunc _untilDAL = new HPCBusinessLogic.UltilFunc();
string _sql = "GetChucNang4User";
DataTable _dt;
string _tmp = string.Empty;
try
{
_dt = _untilDAL.GetStoreDataSet(_sql, new string[] { "@User_ID", "@MaAnPham" }, new object[] { User_ID, MaAnpham }).Tables[0];
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
if (_tmp.Trim() == "")
{
_tmp = _dt.Rows[i]["Ma_Chucnang"].ToString();
}
else
{
_tmp = _tmp + "," + _dt.Rows[i]["Ma_Chucnang"].ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(_tmp);
}
public static int GetLatestID(string TableName, string IDFieldName, string Condition)
{
HPCBusinessLogic.UltilFunc _untilFuncDAL = new HPCBusinessLogic.UltilFunc();
try
{
DataSet ds = _untilFuncDAL.GetStoreDataSet("SP_GetLatestID", new string[] { "@TableName", "@IDFieldName", "@Condition" }, new object[] { TableName, IDFieldName, Condition });
return(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray.GetValue(0)));
}
catch
{
return(0);
}
}
public static bool isParrentMenu(int Menu_ID)
{
bool _return = true;
HPCBusinessLogic.UltilFunc _lib = new HPCBusinessLogic.UltilFunc();
DataSet ds = _lib.GetStoreDataSet("SP_isParrentMenu", new string[] { "@Menu_ID" }, new object[] { Menu_ID });
if (Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray.GetValue(0)) > 0)
{
_return = false;
}
return(_return);
}
public static bool IsAccept(int MenuID)
{
try
{
HPCBusinessLogic.UltilFunc _untilDAL = new HPCBusinessLogic.UltilFunc();
SSOLib.SSOLibDAL _ssolibdal = new SSOLib.SSOLibDAL();
SSOLib.ServiceAgent.T_Users user = _ssolibdal.GetT_UsersByUserName(HPCSecurity.CurrentUser.Identity.Name);
DataSet _ds = _untilDAL.GetStoreDataSet("SP_GetRole4UserMenu", new string[] { "@UserID", "@Menu_ID" }, new object[] { user.UserID, MenuID.ToString() });
if (_ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
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());
}