RolePermission.Bll/SMROLETBService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using RolePermission.Common;
using RolePermission.IBLL;
using RolePermission.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using RolePermission.Model.SearchParam;
using System.Linq.Expressions;
using System.Transactions;
using System.Text;
using RolePermission.IDAL;
using RolePermission.Model.Relationship;

namespace RolePermission.BLL
{
    public partial class SMROLETBService : BaseService<SMROLETB>, ISMROLETBService
    {
        /// <summary>
        /// 多条件搜索角色信息
        /// </summary>
        /// <param name="roleParam">角色查询参数实体</param>
        /// <returns></returns>
        public IQueryable<SMROLETB> LoadSearchEntities(RoleParam roleParam)
        {
            Expression<Func<SMROLETB, bool>> whereLambda = PredicateBuilder.True<SMROLETB>();
            if (!string.IsNullOrEmpty(roleParam.ROLE_NAME))
            {
                whereLambda = whereLambda.And(u => u.ROLE_NAME.Contains(roleParam.ROLE_NAME));
            }

            if (!string.IsNullOrEmpty(roleParam.STATUS))
            {
                whereLambda = whereLambda.And(u => u.STATUS == roleParam.STATUS);
            }

            int count = 0;
            IQueryable<SMROLETB> queryData = null;
            if (!string.IsNullOrEmpty(roleParam.order) && !string.IsNullOrEmpty(roleParam.sort))
            {
                bool isAsc = roleParam.order == "asc" ? true : false;
                queryData = LoadPageEntities<SMROLETB>(roleParam.page, roleParam.rows, out count, whereLambda,
                    roleParam.sort, isAsc);
            }
            else
            {
                queryData = LoadPageEntities<SMROLETB>(roleParam.page, roleParam.rows, out count, whereLambda,
                    roleParam.sort, null);
            }

            roleParam.TotalCount = count;

            foreach (var item in queryData)
            {
                if (item.SMUSERTB != null)
                {
                    item.SysPersonId = string.Empty;
                    foreach (var it in item.SMUSERTB2)
                    {
                        item.SysPersonId += it.User.USER_NAME + ' ';
                    }