Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
 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);
     }
 }
Exemplo n.º 3
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);
        }
Exemplo n.º 4
0
 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);
     }
 }
Exemplo n.º 5
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());
        }