/// <summary> /// 根据条件获得用户组信息 /// </summary> /// <param name="name">名称</param> /// <param name="code">代码</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户组信息</returns> public List <V_UserGroup> GetUserGroupInfoByWhere(string name, string code, bool?ifEnable, MPagingModel pageM) { Expression <Func <V_UserGroup, bool> > expression = m => true; if (!string.IsNullOrEmpty(name)) { expression = LinqManager.And(expression, m => m.Name.Contains(name)); } if (!string.IsNullOrEmpty(code)) { expression = LinqManager.And(expression, m => m.Code == code); } if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } pageM.DataCount = _DB.V_UserGroup.Count(expression.Compile()); List <V_UserGroup> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_UserGroup.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }
/// <summary> /// 根据类型和启用标识获得顶层权限信息 /// </summary> /// <param name="type">权限类型</param> /// <param name="ifEnable">启用标识</param> /// <returns>所有权限信息</returns> public List <T_Permissions> GetPermissionsInfoByTypeAndEnable(PermissionsTypesEnum type, bool?ifEnable) { Expression <Func <T_Permissions, bool> > expression = m => m.Type == (byte)type && !m.IfDelete && m.FK_ParentID == null; if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } List <T_Permissions> listM = _DB.T_Permissions.Where(expression.Compile()).OrderByDescending(m => m.Ranks).ToList(); return(listM); }
/// <summary> /// 根据权限代码和启用状态获得权限信息 /// </summary> /// <param name="code">权限代码</param> /// <param name="ifEnable">启用标识</param> /// <returns>权限信息</returns> public V_Permissions GetPermissionsInfoByCodeAndEnable(string code, bool?ifEnable) { Expression <Func <V_Permissions, bool> > expression = m => m.Code == code; if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } V_Permissions resM = _DB.V_Permissions.Where(expression.Compile()).FirstOrDefault(); return(resM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="mobile">手机</param> /// <param name="weChatWorkUserID">微信企业号账户</param> /// <param name="email">邮箱</param> /// <param name="trueName">真实姓名</param> /// <param name="nickName">昵称</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserInfoByWhere(string userName, string mobile, string weChatWorkUserID, string email, string trueName, string nickName, bool?ifEnable, MPagingModel pageM) { Expression <Func <V_User, bool> > expression = m => true; if (!string.IsNullOrEmpty(userName)) { expression = LinqManager.And(expression, m => m.UserName == userName); } if (!string.IsNullOrEmpty(mobile)) { expression = LinqManager.And(expression, m => m.Mobile == mobile); } if (!string.IsNullOrEmpty(weChatWorkUserID)) { expression = LinqManager.And(expression, m => m.WeChatWorkUserID == weChatWorkUserID); } if (!string.IsNullOrEmpty(email)) { expression = LinqManager.And(expression, m => m.Email == email); } if (!string.IsNullOrEmpty(trueName)) { expression = LinqManager.And(expression, m => m.TrueName.Contains(trueName)); } if (!string.IsNullOrEmpty(nickName)) { expression = LinqManager.And(expression, m => m.NickName.Contains(nickName)); } if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } pageM.DataCount = _DB.V_User.Count(expression.Compile()); List <V_User> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_User.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }
/// <summary> /// 根据条件获得试题信息 /// </summary> /// <param name="title">试题标题</param> /// <param name="IsEnable">启用状态</param> /// <param name="pageM">分页对象</param> /// <returns>试题信息</returns> public List <V_Paper> GetPaperViewInfoByWhere(string title, bool?IsEnable, MPagingModel pageM) { Expression <Func <V_Paper, bool> > searchPredicate = LinqManager.True <V_Paper>(); if (!string.IsNullOrEmpty(title)) { searchPredicate = LinqManager.And(searchPredicate, m => m.Title.Contains(title)); } if (IsEnable != null) { searchPredicate = LinqManager.And(searchPredicate, m => m.IsEnable == IsEnable.Value); } pageM.DataCount = _DB.V_Paper.Where(searchPredicate.Compile()).Count(); List <V_Paper> resM = new List <V_Paper>(); if (pageM.DataCount > 0) { resM = _DB.V_Paper.Where(searchPredicate.Compile()).OrderByDescending(m => m.CreateTime).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).ToList(); } return(resM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="trueName">真实姓名</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserViewInfoByWhere(string userName, string trueName, MPagingModel pageM) { Expression <Func <V_User, bool> > expression = m => true; if (!string.IsNullOrEmpty(userName)) { expression = LinqManager.And(expression, m => m.UserName == userName); } if (!string.IsNullOrEmpty(trueName)) { expression = LinqManager.And(expression, m => m.TrueName.Contains(trueName)); } pageM.DataCount = _DB.V_User.Count(expression.Compile()); List <V_User> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_User.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }