/// <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);
}
}