/// <summary> /// 设置用户角色 /// </summary> /// <param name="UserID"></param> /// <param name="RoleID"></param> /// <param name="IsHas">ture设置 false移除</param> public void SetUserRole(string UserID, string RoleID) { using (var factory = new BaseAccess()) { //如果传入的roleid为空的话移除改用户对对应的所有角色 if (string.IsNullOrWhiteSpace(RoleID)) { var entity = factory.GetAll <UserRoleEntity>(Specification <UserRoleEntity> .Create(c => c.UserID == UserID)); factory.Delete <UserRoleEntity>(entity); } else { var entity = factory.GetAll <UserRoleEntity>(Specification <UserRoleEntity> .Create(c => c.UserID == UserID)); factory.Delete <UserRoleEntity>(entity); var Rids = RoleID.Split(','); foreach (var item in Rids) { var spec = Specification <UserRoleEntity> .Create(c => c.UserID == UserID && c.RoleID == item); bool bl = factory.IsExists <UserRoleEntity>(spec); if (!bl) { var userRole = new UserRoleEntity() { RoleID = item, UserID = UserID }; factory.Insert <UserRoleEntity>(userRole); } } } } }
/// <summary> /// 设置分组用户 /// </summary> /// <param name="OrganID"></param> /// <param name="UserID"></param> /// <param name="IsHas">ture设置 false移除</param> public void SetUserOrgan(string OrganID, string UserID, bool IsHas) { using (var factory = new BaseAccess()) { //获取用户的所有分组 var UserAllOrgan = factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => c.UserID == UserID)); if (IsHas) { //增加 if (UserAllOrgan == null || UserAllOrgan.Count == 0 || UserAllOrgan.Count(c => c.OrganizationID == OrganID) == 0) { var organUser = new UserOrganizationEntity() { OrganizationID = OrganID, UserID = UserID, IsDefault = UserAllOrgan.Count(c => c.IsDefault == (int)YesNo.Yes) == 0 ? (int)YesNo.Yes : (int)YesNo.No }; factory.Insert <UserOrganizationEntity>(organUser); } } else { //移除 if (UserAllOrgan != null && UserAllOrgan.Count(c => c.OrganizationID == OrganID) > 0) { factory.Delete <UserOrganizationEntity>(UserAllOrgan.Where(c => c.OrganizationID == OrganID).First()); } } } }
/// <summary> /// 获取所有角色,从数据库取 /// </summary> /// <returns></returns> public List <RoleInfo> GetAllRoles() { using (var factory = new BaseAccess()) { return(factory.GetAll <RoleEntity>(Specification <RoleEntity> .Create(c => c.RecordStatus != (int)RecordStatus.UnEnable)).Adapter <RoleEntity, RoleInfo>(new List <RoleInfo>())); } }
/// <summary> /// 获取专题及其前后 /// </summary> /// <param name="model"></param> /// <param name="pi"></param> /// <returns></returns> public Event_S GetEventWithSide(string EventID) { using (var factory = new BaseAccess()) { List <Orderby <EventEntity> > orders = new List <Orderby <EventEntity> >() { new Orderby <EventEntity>(c => c.DT_OP_TIME, SortOrder.Descending) }; var spec = Specification <EventEntity> .Create(c => true); var list = factory.GetAll <EventEntity>(spec, orders) .Adapter <EventEntity, Event_S>(new List <Event_S>()); var premodel = new Event_S(); var nowmodel = list.Find(c => c.ID == EventID); if (nowmodel == null) { return(new Event_S()); } var nextmodel = new Event_S(); var index = list.FindIndex(c => c.ID == EventID); if (index != 0) { nowmodel.prevEvent = list[index - 1]; } if (index != list.Count - 1) { nowmodel.nextEvent = list[index + 1]; } return(nowmodel); } }
/// <summary> /// 设置为主分组 /// </summary> /// <param name="OrganID"></param> /// <param name="UserID"></param> public void SetDefaultOrgan(string OrganID, string UserID) { using (var factory = new BaseAccess()) { try { //获取用户的所有分组 var UserAllOrgan = factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => c.UserID == UserID)); var defaultOrgan = UserAllOrgan.Where(c => c.IsDefault == (int)YesNo.Yes).ToList() ?? new List <UserOrganizationEntity>(); var setOrgan = UserAllOrgan.Where(w => w.OrganizationID == OrganID).FirstOrDefault(); if (setOrgan != null) { //取消所有原主分组(做荣誉操作,正常情况下不会有多个主分组) foreach (var m in defaultOrgan) { m.IsDefault = (int)YesNo.No; factory.Update <UserOrganizationEntity>(m, false); } //设置需要设置的分组为主分组 setOrgan.IsDefault = (int)YesNo.Yes; factory.Update <UserOrganizationEntity>(setOrgan, false); factory.Commit(); } } catch (Exception e) { factory.Rollback(); throw e; } } }
/// <summary> /// 获取所有分组,从数据库取 /// </summary> /// <returns></returns> public List <OrganizationInfo> GetAllOrgans() { using (var factory = new BaseAccess()) { return(factory.GetAll <OrganizationEntity>(Specification <OrganizationEntity> .Create(c => c.RecordStatus != (int)RecordStatus.UnEnable)).Adapter <OrganizationEntity, OrganizationInfo>(new List <OrganizationInfo>())); } }
/// <summary> /// 获取用户的所有分组 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public List <UserOrganizationEntity> GetOrgansByUser(string UserID) { using (var factory = new BaseAccess()) { return(factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => c.UserID == UserID))); } }
/// <summary> /// 获取栏目集合前N条数据 /// 图片信息获取强烈推荐 /// </summary> /// <param name="ColumnID"></param> /// <param name="TopNum"></param> /// <returns></returns> public List <Article_S> GetImageArticles(string ColumnIDs, int nCount) { using (var factory = new BaseAccess()) { var listAll = new List <Article_S>(); List <Orderby <ArticleEntity> > orders = new List <Orderby <ArticleEntity> >() { new Orderby <ArticleEntity>(c => c.C_RECOMMEND_LEVEL, SortOrder.Descending),//强烈推荐 new Orderby <ArticleEntity>(c => c.DT_ADD_TIME, SortOrder.Descending) }; var spec = Specification <ArticleEntity> .Create(c => c.B_IMG_NEWS == true);//是图片新闻 spec &= Specification <ArticleEntity> .Create(c => c.C_STATUS == ((int)RecordStatus.Enable).ToString()); if (!string.IsNullOrEmpty(ColumnIDs)) { spec = Specification <ArticleEntity> .Create(c => c.B_IMG_NEWS == true && ("," + ColumnIDs + ",").Contains(("," + c.N_COLUMN_ID + ",")));//防止104将10的情况搜索出来 } PageInfo pi = new PageInfo(); pi.PageSize = nCount; pi.PageIndex = 1; List <ArticleEntity> list = new List <ArticleEntity>(); if (pi.PageSize == 0) { list = factory.GetAll <ArticleEntity>(spec, orders); } else { list = factory.GetPage <ArticleEntity>(pi, spec, orders); } return(list.Adapter <ArticleEntity, Article_S>(new List <Article_S>())); } }
/// <summary> /// 设置角色菜单 /// </summary> /// <param name="RoleID"></param> /// <param name="MenuIDs"></param> public void SetRoleMenus(string RoleID, List <string> MenuIDs) { using (var factory = new BaseAccess()) { try { if (!string.IsNullOrEmpty(RoleID)) { var menus_old = factory.GetAll <MenuRoleEntity>(Specification <MenuRoleEntity> .Create(c => c.RoleID == RoleID)); factory.Delete <MenuRoleEntity>(menus_old, false); if (MenuIDs != null) { foreach (string id in MenuIDs) { var entity = new MenuRoleEntity() { ID = Guid.NewGuid().ToString(), RoleID = RoleID, MenuID = id }; factory.Insert <MenuRoleEntity>(entity, false); } } factory.Commit(); } } catch (Exception ex) { factory.Rollback(); throw ex; } } }
/// <summary> /// 获取超级管理员菜单 /// </summary> /// <returns></returns> public List <MenuInfo> GetAdminMenu() { using (var factory = new BaseAccess()) { var list = factory.GetAll <MenuEntity>(Specification <MenuEntity> .Create(c => c.MenuType == (int)MenuType.Admin && c.RecordStatus != (int)RecordStatus.UnEnable)) ?? new List <MenuEntity>(); return(list.Adapter <MenuEntity, MenuInfo>(new List <MenuInfo>())); } }
/// <summary> /// 获取数据字典(不包含标题项) /// </summary> /// <param name="DictType"></param> /// <returns></returns> public List <Dictionary_S> GetDict(string DictType) { using (var factory = new BaseAccess()) { var list = factory.GetAll <Sys_DictionaryEntity>(Specification <Sys_DictionaryEntity> .Create(c => c.DictType == DictType && c.ParDictID != null && c.ParDictID != "" && c.ParDictID != Define._TOPPARENTID)) ?? new List <Sys_DictionaryEntity>(); return(list.OrderBy(o => o.DictOrder).ThenBy(t => t.DictCode).ToList().Adapter <Sys_DictionaryEntity, Dictionary_S>(new List <Dictionary_S>())); } }
/// <summary> /// 根据栏目编号获取栏目名称 /// </summary> /// <returns></returns> public string GetColumnIDsByColumnId(string ColumnId) { using (var factory = new BaseAccess()) { var Columns = factory.GetAll <MenuEntity>(Specification <MenuEntity> .Create(c => c.MenuCode.Contains(ColumnId))); string ColumnIDs = string.Empty; Columns.ForEach(c => ColumnIDs += c.MenuCode + ","); return(ColumnIDs); } }
/// <summary> /// 获取分组用户列表 /// </summary> /// <param name="OrganizationID"></param> /// <param name="UserName"></param> /// <returns></returns> public List <UserOrganizationEntity> GetUserWithOrgan(string OrganizationID, string UserID) { using (var factory = new BaseAccess()) { var spec = Specification <UserOrganizationEntity> .Create(c => true); if (!string.IsNullOrEmpty(OrganizationID)) { spec &= Specification <UserOrganizationEntity> .Create(c => c.OrganizationID == OrganizationID); } else { var listorgan = factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => c.UserID == UserID)); string strOrgans = string.Empty; listorgan.ForEach(c => strOrgans += c.OrganizationID + ","); spec &= Specification <UserOrganizationEntity> .Create(c => strOrgans.Contains(c.OrganizationID)); } var list = factory.GetAll <UserOrganizationEntity>(spec); return(list); } }
/// <summary> /// 获取分组用户列表 /// </summary> /// <param name="OrganizationID"></param> /// <param name="UserName"></param> /// <returns></returns> public List <OrganUser_S> GetUserWithOrgan(string OrganizationID, string LoginName, string DisplayName) { using (var factory = new BaseAccess()) { var OrganUser = factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => c.OrganizationID == OrganizationID)); var AllUsers = Manage.Open.MembershipFactory.Instance.GetAllUsers(LoginName, DisplayName); var list = AllUsers.Adapter <UserInfo, OrganUser_S>(new List <OrganUser_S>()); list.ForEach(f => f.IsHas = OrganUser.Select(s => s.UserID).Contains(f.ID)); list.ForEach(f => f.IsMain = (f.IsHas && OrganUser.Count(w => w.UserID == f.ID && w.IsDefault == (int)YesNo.Yes) > 0)); list = list.OrderBy(o => !o.IsHas).ThenBy(t => t.UserDisplayName).ToList(); return(list); } }
/// <summary> /// 获取所有或页面内的所有需要验证的功能按钮 /// </summary> /// <param name="MenuID"></param> /// <returns></returns> public List <MenuInfo> GetFunMenuByMenuID(string MenuID = "") { using (var factory = new BaseAccess()) { var spec = Specification <MenuEntity> .Create(c => c.RecordStatus != (int)RecordStatus.UnEnable && c.MenuType == (int)MenuType.Function); if (!string.IsNullOrEmpty(MenuID)) { spec &= Specification <MenuEntity> .Create(c => c.PerMenuID == MenuID); } return(factory.GetAll <MenuEntity>(spec).Adapter <MenuEntity, MenuInfo>(new List <MenuInfo>())); } }
/// <summary> /// 获取所有菜单(除管理员菜单) /// </summary> /// <returns></returns> public List <Menu_S> GetAllMenus() { using (var factory = new BaseAccess()) { List <Orderby <MenuEntity> > orders = new List <Orderby <MenuEntity> >() { new Orderby <MenuEntity>(c => c.MenuType, SortOrder.Ascending), new Orderby <MenuEntity>(c => c.MenuOrder, SortOrder.Ascending) }; //return factory.GetAll<MenuEntity>(Specification<MenuEntity>.Create(c => c.MenuType != (int)MenuType.Admin), orders) return(factory.GetAll <MenuEntity>(Specification <MenuEntity> .Create(c => true), orders) .Adapter <MenuEntity, Menu_S>(new List <Menu_S>())); } }
public List <Menu_S> GetAllMenus(Boolean flag) { using (var factory = new BaseAccess()) { List <Orderby <MenuEntity> > orders = new List <Orderby <MenuEntity> >() { new Orderby <MenuEntity>(c => c.MenuType, SortOrder.Ascending), new Orderby <MenuEntity>(c => c.MenuOrder, SortOrder.Ascending) }; //return factory.GetAll<MenuEntity>(Specification<MenuEntity>.Create(c => c.MenuType != (int)MenuType.Admin), orders) if (flag) { return(factory.GetAll <MenuEntity>(Specification <MenuEntity> .Create(c => c.Extend4 == "1" && c.MenuType == 1 && c.RecordStatus == 1), orders) .Adapter <MenuEntity, Menu_S>(new List <Menu_S>())); } else { return(factory.GetAll <MenuEntity>(Specification <MenuEntity> .Create(c => c.Extend4 == "1"), orders) .Adapter <MenuEntity, Menu_S>(new List <Menu_S>())); } } }
/// <summary> /// 获取指定栏目前N条数据 /// </summary> /// <param name="ColumnID"></param> /// <param name="TopNum"></param> /// <returns></returns> public List <Article_S> GetTopArticleByColumnID(string ColumnID, int TopNum) { using (var factory = new BaseAccess()) { var list = new List <Article_S>(); PageInfo pi = new PageInfo(); var spec = Specification <ArticleEntity> .Create(c => true); spec &= Specification <ArticleEntity> .Create(c => c.C_STATUS == ((int)RecordStatus.Enable).ToString()); spec &= Specification <ArticleEntity> .Create(c => c.C_VERIFY_STATUS == ((int)EMARTICLESTATUS.二级审核).ToString()); if (ColumnID == "999") { spec &= Specification <ArticleEntity> .Create(c => c.DT_ADD_TIME >= DateTime.Now.AddDays(-7)); List <Orderby <ArticleEntity> > orders = new List <Orderby <ArticleEntity> >() { new Orderby <ArticleEntity>(c => c.N_HITS, SortOrder.Descending), new Orderby <ArticleEntity>(c => c.DT_ADD_TIME, SortOrder.Descending) }; pi.PageSize = TopNum; pi.PageIndex = 1; list = factory.GetPage(pi, spec, orders).Adapter <ArticleEntity, Article_S>(new List <Article_S>()); list.ForEach(c => c.B_HOTPOINTS = true); } else { List <Orderby <ArticleEntity> > orders = new List <Orderby <ArticleEntity> >() { new Orderby <ArticleEntity>(c => c.C_RECOMMEND_LEVEL, SortOrder.Descending),//强烈推荐 new Orderby <ArticleEntity>(c => c.DT_ADD_TIME, SortOrder.Descending) }; spec &= Specification <ArticleEntity> .Create(c => c.N_COLUMN_ID.Contains(ColumnID)); if (TopNum != 0) { pi.PageSize = TopNum; pi.PageIndex = 1; list = factory.GetPage <ArticleEntity>(pi, spec, orders).Adapter <ArticleEntity, Article_S>(new List <Article_S>()); } else { list = factory.GetAll <ArticleEntity>(spec, orders).Adapter <ArticleEntity, Article_S>(new List <Article_S>()); } list.ForEach(c => c.B_HOTPOINTS = false); } return(list); } }
private List <Sys_DictionaryEntity> GetChilds(BaseAccess factory, string ParDictID, List <Sys_DictionaryEntity> entitys) { if (entitys == null) { entitys = new List <Sys_DictionaryEntity>(); } var list = factory.GetAll <Sys_DictionaryEntity>(Specification <Sys_DictionaryEntity> .Create(c => c.ParDictID == ParDictID)); entitys.AddRange(list); foreach (var m in list) { entitys.AddRange(GetChilds(factory, m.ID, entitys)); } return(entitys); }
/// <summary> /// 获取带明细的专题信息 /// </summary> /// <param name="EventID"></param> /// <returns></returns> public Event_S GetEventWithDetail(string EventID) { using (var factory = new BaseAccess()) { var entity = factory.GetSingle <EventEntity>(EventID); var model = entity.Adapter <Event_S>(new Event_S()); var spec = Specification <EventDetailEntity> .Create(c => c.N_EVENT_ID == EventID); var entitydetaillist = factory.GetAll <EventDetailEntity>(spec); model.listEventDetail = entitydetaillist.Adapter <EventDetailEntity, EventDetail_S>(new List <EventDetail_S>()); return(model); } }
private List <OrganizationEntity> GetChilds(BaseAccess factory, string OrganParentID, List <OrganizationEntity> entitys) { if (entitys == null) { entitys = new List <OrganizationEntity>(); } var list = factory.GetAll <OrganizationEntity>(Specification <OrganizationEntity> .Create(c => c.OrganParentID == OrganParentID)); entitys.AddRange(list); foreach (var m in list) { entitys.AddRange(GetChilds(factory, m.ID, entitys)); } return(entitys); }
/// <summary> /// 删除用户 /// </summary> /// <param name="IDs">用户ID,逗号“,”隔开</param> /// <returns></returns> public bool DelUsers(string IDs) { using (var factory = new BaseAccess(base._DBConfigPath)) { try { string[] userIDs = IDs.Split(','); factory.Delete <UserEntity>(userIDs, false); //循环删除用户分组 var userOrgans = factory.GetAll <UserOrganizationEntity>(Specification <UserOrganizationEntity> .Create(c => userIDs.Contains(c.UserID))); foreach (var userOrgan in userOrgans) { factory.Delete <UserOrganizationEntity>(userOrgan, false); } //循环删除用户角色 var userRoles = factory.GetAll <UserRoleEntity>(Specification <UserRoleEntity> .Create(c => userIDs.Contains(c.UserID))); foreach (var userRole in userRoles) { factory.Delete <UserRoleEntity>(userRole, false); } factory.Commit(); //清理缓存 foreach (var id in userIDs) { Manage.Open.CacheshipFactory.Instance.ClearSSOUserCache(id); } return(true); } catch (Exception ex) { factory.Rollback(); return(false); } } }
/// <summary> /// 得到链接类型地址 /// 3国内档案网站 4省内档案网站 5热门网站 /// </summary> /// <param name="typeId"></param> /// <returns></returns> public List <Link_S> GetAllLinks(string typeId) { using (var factory = new BaseAccess()) { List <Orderby <LinkEntity> > orders = new List <Orderby <LinkEntity> >() { new Orderby <LinkEntity>(c => c.DT_OP_TIME, SortOrder.Descending) }; var spec = Specification <LinkEntity> .Create(c => c.C_LINK_TYPE == typeId); var list = factory.GetAll <LinkEntity>(spec, orders) .Adapter <LinkEntity, Link_S>(new List <Link_S>()); return(list); } }
/// <summary> /// 分页获取专题明细列表 /// </summary> /// <param name="model"></param> /// <param name="pi"></param> /// <returns></returns> public List <ArticleApply_S> GetArticleApplyListPaged(ArticleApply_S model, PageInfo pi) { using (var factory = new BaseAccess()) { List <Orderby <ArticleApplyEntity> > orders = new List <Orderby <ArticleApplyEntity> >() { new Orderby <ArticleApplyEntity>(c => c.DT_APPLY_TIME, SortOrder.Descending) }; var spec = Specification <ArticleApplyEntity> .Create(c => true); if (!string.IsNullOrWhiteSpace(model.VC_ARTICLE_NAME)) { var ArticleIDs = factory.GetAll <ArticleEntity>(Specification <ArticleEntity> .Create(c => c.VC_TITLE.Contains(model.VC_ARTICLE_NAME))).Select(c => c.ID).ToList().ToArray(); spec &= Specification <ArticleApplyEntity> .Create(c => ArticleIDs.Contains(c.ID)); } if (!string.IsNullOrWhiteSpace(model.C_CHECK_STATUS)) { spec &= Specification <ArticleApplyEntity> .Create(c => c.C_CHECK_STATUS == model.C_CHECK_STATUS); } if (!string.IsNullOrWhiteSpace(model.VC_APPLYER_NAME)) { spec &= Specification <ArticleApplyEntity> .Create(c => c.VC_APPLYER_NAME.Contains(model.VC_APPLYER_NAME)); } if (model.N_START_DATE != null) { spec &= (Specification <ArticleApplyEntity> .Create(c => c.DT_APPLY_TIME >= model.N_START_DATE)); } if (model.N_END_DATE != null) { spec &= (Specification <ArticleApplyEntity> .Create(c => c.DT_APPLY_TIME <= model.N_END_DATE)); } var list = factory.GetPage <ArticleApplyEntity>(pi, spec, orders) .Adapter <ArticleApplyEntity, ArticleApply_S>(new List <ArticleApply_S>()); foreach (var item in list) { // item.VC_ARTICLE_NAME = factory.GetSingle<ArticleEntity>(item.N_ARTICLE_ID).VC_TITLE; item.VC_ARTICLE_NAME = factory.GetSingle <ArticleEntity>(item.N_ARTICLE_ID) == null ? "未知" : factory.GetSingle <ArticleEntity>(item.N_ARTICLE_ID).VC_TITLE; if (!string.IsNullOrWhiteSpace(item.VC_CHECKER_ID)) { var checker = factory.GetSingle <SYS_UserEntity>(item.VC_CHECKER_ID); item.VC_CHECKER_NAME = checker == null ? "" : checker.UserDisplayName; } } return(list); } }
/// <summary> /// 获取所有菜单(除管理员菜单) /// </summary> /// <returns></returns> public List <Article_S> GetAllArticles(string ColumnId) { using (var factory = new BaseAccess()) { List <Orderby <ArticleEntity> > orders = new List <Orderby <ArticleEntity> >() { new Orderby <ArticleEntity>(c => c.DT_ADD_TIME, SortOrder.Descending) }; var Column = factory.GetSingle <MenuEntity>(Specification <MenuEntity> .Create(c => c.MenuCode == ColumnId)); var spec = Specification <ArticleEntity> .Create(c => c.N_COLUMN_ID == ColumnId); spec &= Specification <ArticleEntity> .Create(c => c.C_STATUS == "1"); var list = factory.GetAll <ArticleEntity>(spec, orders) .Adapter <ArticleEntity, Article_S>(new List <Article_S>()); return(list); } }
/// <summary> /// 获取所有分组,从数据库取 /// </summary> /// <returns></returns> public List <OrganizationInfo> GetAllOrgans(Organization_S model) { using (var factory = new BaseAccess()) { var spec = Specification <OrganizationEntity> .Create(c => c.RecordStatus != (int)RecordStatus.UnEnable); if (!string.IsNullOrWhiteSpace(model.OrganName)) { spec &= Specification <OrganizationEntity> .Create(c => c.OrganName.Contains(model.OrganName)); } if (!string.IsNullOrWhiteSpace(model.Extend4)) { spec &= Specification <OrganizationEntity> .Create(c => c.Extend4 == model.Extend4); } return(factory.GetAll <OrganizationEntity>(spec).Adapter <OrganizationEntity, OrganizationInfo>(new List <OrganizationInfo>())); } }
/// <summary> /// 获取所有用户数据 /// </summary> /// <param name="user"></param> /// <param name="pi"></param> /// <returns></returns> public List <User_S> GetAllUsers(User_S user) { using (var factory = new BaseAccess(base._DBConfigPath)) { var spec = Specification <UserEntity> .Create(c => c.UserType != (int)UserType.Administrators); if (!string.IsNullOrEmpty(user.UserDisplayName)) { spec &= Specification <UserEntity> .Create(c => c.UserDisplayName.Contains(user.UserDisplayName)); } if (!string.IsNullOrEmpty(user.UserLoginName)) { spec &= Specification <UserEntity> .Create(c => c.UserLoginName.Contains(user.UserLoginName)); } var list = factory.GetAll <UserEntity>(spec, c => c.UserDisplayName, SortOrder.Ascending); return((list ?? new List <UserEntity>()).Adapter <UserEntity, User_S>(new List <User_S>())); } }
/// <summary> /// 获取所有菜单(除管理员菜单) /// </summary> /// <returns></returns> public List <Navigation_S> GetAllNavigations(string ColumnId = "") { using (var factory = new BaseAccess()) { List <Orderby <NavigationEntity> > orders = new List <Orderby <NavigationEntity> >() { new Orderby <NavigationEntity>(c => c.N_ORDER_NO, SortOrder.Ascending) }; //var Column = factory.GetSingle<MenuEntity>(Specification<MenuEntity>.Create(c => c.MenuCode == ColumnId)); var spec = Specification <NavigationEntity> .Create(c => true); if (!string.IsNullOrEmpty(ColumnId)) { spec = Specification <NavigationEntity> .Create(c => c.N_COLUMN_ID.Equals(ColumnId)); } var list = factory.GetAll <NavigationEntity>(spec, orders) .Adapter <NavigationEntity, Navigation_S>(new List <Navigation_S>()); return(list); } }