修改页面按钮权限的验证

username@email.com

2024-12-25 0b15f032dcd39c269668f57006f6d399d4d0e999

修改页面按钮权限的验证

 CY_ECommercePlatform/CY.SQLDAL/Sys/Sys_Permissions_UserCaseDAL.cs

@@ -187,7 +187,7 @@
        {
            try
            {
                IList<Sys_Permissions_UserCase> result = _dataBase.SelectModel<Sys_Permissions_UserCase>(" a.* ", " dbo.Sys_Permissions_UserCase AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.MenuId = b.Keyid LEFT JOIN dbo.Sys_Permissions_RoleMenuRelation AS c ON b.Keyid = c.MenuIdThree ", string.Format(" b.MenuPath='{0}' AND c.RoleId ='{1}' AND CHARINDEX(CONVERT(VARCHAR(20),a.Keyid),c.FuncId)=0 ", MenuPath, RoleId)) as IList<Sys_Permissions_UserCase>;//执行查询
                IList<Sys_Permissions_UserCase> result = _dataBase.SelectModel<Sys_Permissions_UserCase>(" a.* ", " dbo.Sys_Permissions_UserCase AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.MenuId = b.Keyid LEFT JOIN dbo.Sys_Permissions_RoleMenuRelation AS c ON b.Keyid = c.MenuIdThree ", string.Format(" b.MenuPath like '%{0}' AND c.RoleId ='{1}' AND CHARINDEX(CONVERT(VARCHAR(20),a.Keyid),c.FuncId)>=0 ", MenuPath, RoleId)) as IList<Sys_Permissions_UserCase>;//执行查询

                return result;
            }

 CY_ECommercePlatform/CY.WebForm/Pages/common/CMSHead.ascx

@@ -128,9 +128,16 @@
<!--begin-->
<script type="text/javascript">
    $(function () {

        var url = window.location.href;
        var j = "";
        if (url.indexOf('?') >= 0) {
            j = url.substring(url.indexOf('?'));
        }
          
        var tempPathName = window.location.pathname;
        var tempContext = tempPathName.substring(1, tempPathName.length);
        var TruePath = tempContext.replace("Pages/", "../");
        var TruePath = tempContext.replace("Pages/", "../") + j;
        $.ajax({
            url: "/Pages/common/CommonAjax.aspx",
            type: "POST",
@@ -154,27 +161,28 @@
    });
</script>
<script type="text/javascript">
    $(function () {
        // menu_member_case_id="case_" menu_member_case_name=""
        var tempPathName = window.location.pathname;
        var tempContext = tempPathName.substring(1, tempPathName.length);
        var TruePath = tempContext.replace("Pages/", "../").replace("pages/", "../");
        var attrs = "";
        var texts = "";
        $("*[menu_member_case_id^='case_']").each(function (ii, vv) {
            attrs += ("," + $(vv).attr("menu_member_case_id"));
            texts += ("," + $(vv).attr("menu_member_case_name"));
        });
        $.ajax({
            url: "/Pages/common/CommonAjax.aspx",
            type: "POST",
            dataType: "html",
            data: { dateType: "creat_menu_case", menupath: TruePath, attrs: attrs, texts: texts },
            global: false,
            cache: false,
            success: function (data) {
    //$(function () {
    //    // menu_member_case_id="case_" menu_member_case_name=""
       
    //    var tempPathName = window.location.pathname;
    //    var tempContext = tempPathName.substring(1, tempPathName.length);
    //    var TruePath = tempContext.replace("Pages/", "../").replace("pages/", "../");
    //    var attrs = "";
    //    var texts = "";
    //    $("*[menu_member_case_id^='case_']").each(function (ii, vv) {
    //        attrs += ("," + $(vv).attr("menu_member_case_id"));
    //        texts += ("," + $(vv).attr("menu_member_case_name"));
    //    });
    //    $.ajax({
    //        url: "/Pages/common/CommonAjax.aspx",
    //        type: "POST",
    //        dataType: "html",
    //        data: { dateType: "creat_menu_case", menupath: TruePath, attrs: attrs, texts: texts },
    //        global: false,
    //        cache: false,
    //        success: function (data) {
                
            }
        });
    });
    //        }
    //    });
    //});
</script>

 CY_ECommercePlatform/CY.WebForm/Pages/common/CommonAjax.aspx.cs

@@ -1288,8 +1288,35 @@
                }
                else
                {
                    Sys_Permissions_UserRoleRelation m_Sys_Permissions_UserRoleRelation = bll_Sys_Permissions_RoleBLL.SelectSys_Permissions_UserRoleRelation(CurrentUser.MemberId);
                    return JsonHelper.GetJsonStringByObject(bll_Sys_Permissions_UserCaseBLL.GetNoExitCaseList(MenuPath, m_Sys_Permissions_UserRoleRelation.RoleId));
                    Sys_Permissions_UserRoleRelation m_Sys_Permissions_UserRoleRelation = bll_Sys_Permissions_RoleBLL.SelectSys_Permissions_UserRoleRelation(CurrentUser.MemberId);                
                    MenuPath = MenuPath.Replace("..", "");
                    var sss = bll_Sys_Permissions_UserCaseBLL.GetNoExitCaseList(MenuPath, m_Sys_Permissions_UserRoleRelation.RoleId);

                    sss = sss.Where(x => x.Keyid == 12121212121);
                   //if(sss!=null && sss.Count() > 0)
                   // {
                   //     var roleRel = bll_OA_FirmRoleBLL.SelectOA_StaffRoleRel(CurrentUser.StaffId);
                   //     if (roleRel != null)
                   //     {
                   //         List<OA_FirmRolePermissionsRel> m_OA_FirmRolePermissionsRelList = bll_OA_FirmRoleBLL.SelectListByRoleId(roleRel.RoleId) as List<OA_FirmRolePermissionsRel>;
                   //         if (m_OA_FirmRolePermissionsRelList != null && m_OA_FirmRolePermissionsRelList.Count > 0)
                   //         {
                   //             List<int?> Menus = new List<int?>();
                   //             foreach (var m_Sys_Permissions_Menu in m_OA_FirmRolePermissionsRelList)
                   //             {
                   //                 // Menus.Add(m_Sys_Permissions_Menu.MenuIdOne + "-" + m_Sys_Permissions_Menu.MenuIdTwo + "-" + m_Sys_Permissions_Menu.MenuIdThree + "+" + "0");
                   //                 string[] fucns = m_Sys_Permissions_Menu.FuncGroup.Split(',');
                   //                 foreach (var item in fucns)
                   //                 {
                   //                     Menus.Add(item.ToInt32());
                   //                 }
                   //             }
                   //             sss = sss.Where(x => !Menus.Contains(x.Keyid));
                   //         }
                   //     }
                   // }
                        
                    return JsonHelper.GetJsonStringByObject(sss);
                }
            }
            catch (Exception ex)