public async Task <List <UploadfileEntity> > GetLookList(SoulPage <UploadfileEntity> pagination, string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
Dictionary <string, string> fileTypeTemp = new Dictionary <string, string>();
fileTypeTemp.Add("图片", "1");
fileTypeTemp.Add("文件", "0");
dic.Add("F_FileType", fileTypeTemp);
pagination = ChangeSoulData(dic, pagination);
var query = GetQuery();
if (!string.IsNullOrEmpty(keyword))
{
//此处需修改
query = query.Where(u => u.F_FileName.Contains(keyword) || u.F_Description.Contains(keyword));
}
//权限过滤
query = GetDataPrivilege("u", "", query);
var data = await repository.OrderList(query, pagination);
var orgs = uniwork.IQueryable <OrganizeEntity>().ToList();
foreach (var item in data)
{
string[] departments = item.F_OrganizeId.Split(',');
item.F_OrganizeName = string.Join(',', orgs.Where(a => departments.Contains(a.F_Id)).Select(a => a.F_FullName).ToList());
}
return(data);
}
public async Task <List <RoleExtend> > GetLookList(SoulPage <RoleExtend> pagination, string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
var setList = await setApp.GetList();
Dictionary <string, string> orgizeTemp = new Dictionary <string, string>();
foreach (var item in setList)
{
orgizeTemp.Add(item.F_CompanyName, item.F_Id);
}
dic.Add("F_OrganizeId", orgizeTemp);
pagination = ChangeSoulData(dic, pagination);
var query = GetQuery();
//获取数据权限
var list = GetDataPrivilege("u", "", query);
if (!string.IsNullOrEmpty(keyword))
{
list = list.Where(u => u.F_FullName.Contains(keyword) || u.F_EnCode.Contains(keyword));
}
list = list.Where(u => u.F_DeleteMark == false && u.F_Category == 2);
return(GetFieldsFilterData(await repository.OrderList(list, pagination)));
}
public async Task <List <MessageEntity> > GetLookList(SoulPage <MessageEntity> pagination, string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
var setList = await itemsApp.GetItemList("MessageType");
Dictionary <string, string> messageTypeTemp = new Dictionary <string, string>();
foreach (var item in setList)
{
messageTypeTemp.Add(item.F_ItemName, item.F_ItemCode);
}
dic.Add("F_MessageType", messageTypeTemp);
pagination = ChangeSoulData(dic, pagination);
//获取数据权限
var query = repository.IQueryable().Where(a => a.F_EnabledMark == true);
if (!string.IsNullOrEmpty(keyword))
{
//此处需修改
query = query.Where(t => t.F_MessageInfo.Contains(keyword) || t.F_CreatorUserName.Contains(keyword));
}
query = GetDataPrivilege("u", "", query);
return(await repository.OrderList(query, pagination));
}
public async Task <List <RoleExtend> > GetLookList(SoulPage <RoleExtend> pagination, string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
var setList = await itemsApp.GetItemList("RoleType");
Dictionary <string, string> messageTypeTemp = new Dictionary <string, string>();
foreach (var item in setList)
{
messageTypeTemp.Add(item.F_ItemName, item.F_ItemCode);
}
dic.Add("F_Type", messageTypeTemp);
pagination = ChangeSoulData(dic, pagination);
//获取数据权限
var query = GetQuery();
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(u => u.F_FullName.Contains(keyword) || u.F_EnCode.Contains(keyword));
}
query = GetDataPrivilege("u", "", query);
return(await repository.OrderList(query, pagination));
}
public async Task <ActionResult> GetGridJson(SoulPage <RoleExtend> pagination, string keyword)
{
if (string.IsNullOrEmpty(pagination.field))
{
pagination.field = "F_CreatorTime";
pagination.order = "desc";
}
var data = await _service.GetLookList(pagination, keyword);
return(Content(pagination.setData(data).ToJson()));
}
public async Task <List <DataPrivilegeRuleEntity> > GetLookList(SoulPage <DataPrivilegeRuleEntity> pagination, string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
pagination = ChangeSoulData(dic, pagination);
var query = repository.IQueryable().Where(u => u.F_DeleteMark == false);
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(u => u.F_ModuleCode.Contains(keyword) || u.F_Description.Contains(keyword));
}
query = GetDataPrivilege("u", "", query);
return(await repository.OrderList(query, pagination));
}
public async Task <List <T> > OrderList <T>(IQuery <T> query, SoulPage <T> pagination)
{
var tempData = query;
List <FilterSo> filterSos = pagination.getFilterSos();
if (filterSos != null && filterSos.Count > 0)
{
tempData = tempData.GenerateFilter("u", filterSos);
}
pagination.count = tempData.Count();
if (pagination.order == "desc")
{
tempData = tempData.OrderBy(pagination.field + " " + pagination.order);
}
else
{
tempData = tempData.OrderBy(pagination.field);
}
tempData = tempData.TakePage(pagination.page, pagination.rows);
return(tempData.ToList());
}
public async Task <List <FlowinstanceEntity> > GetLookList(SoulPage <FlowinstanceEntity> pagination, string type = "", string keyword = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("正在运行", "0");
enabledTemp.Add("审批通过", "1");
//enabledTemp.Add("审批通过", "2");
enabledTemp.Add("不同意", "3");
enabledTemp.Add("被驳回", "4");
dic.Add("F_IsFinish", enabledTemp);
pagination = ChangeSoulData(dic, pagination);
var query = repository.IQueryable();
if (!string.IsNullOrEmpty(keyword))
{
//此处需修改
query = query.Where(u => u.F_Code.Contains(keyword) || u.F_CustomName.Contains(keyword));
}
var user = currentuser;
if (type == "todo") //待办事项
{
query = query.Where(u => ((u.F_MakerList == "1" || u.F_MakerList.Contains(user.UserId))) && (u.F_IsFinish == 0 || u.F_IsFinish == 4) && u.F_ActivityType < 3);
}
else if (type == "done") //已办事项（即我参与过的流程）
{
var instances = uniwork.IQueryable <FlowInstanceOperationHistory>(u => u.F_CreatorUserId == user.UserId)
.Select(u => u.F_InstanceId).Distinct().ToList();
query = query.Where(u => instances.Contains(u.F_Id));
}
else //我的流程
{
query = query.Where(u => u.F_CreatorUserId == user.UserId);
}
//权限过滤
query = GetDataPrivilege("u", "", query);
return(await repository.OrderList(query.Where(a => a.F_EnabledMark == true), pagination));
}
public async Task <List <UserExtend> > GetLookList(SoulPage <UserExtend> pagination, string keyword)
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
Dictionary <string, string> sexTemp = new Dictionary <string, string>();
sexTemp.Add("男", "1");
sexTemp.Add("女", "0");
dic.Add("F_Gender", sexTemp);
pagination = ChangeSoulData(dic, pagination);
//获取数据权限
var query = GetQuery().Where(u => u.F_IsAdmin == false);
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(u => u.F_Account.Contains(keyword) || u.F_RealName.Contains(keyword) || u.F_MobilePhone.Contains(keyword));
}
query = GetDataPrivilege("u", "", query);
var data = await repository.OrderList(query, pagination);
var roles = uniwork.IQueryable <RoleEntity>().ToList();
var orgs = uniwork.IQueryable <OrganizeEntity>().ToList();
foreach (var item in data)
{
string[] roleIds = item.F_RoleId.Split(',');
string[] departmentIds = item.F_DepartmentId.Split(',');
item.F_DepartmentName = string.Join(',', orgs.Where(a => departmentIds.Contains(a.F_Id)).Select(a => a.F_FullName).ToList());
item.F_RoleName = string.Join(',', roles.Where(a => roleIds.Contains(a.F_Id)).Select(a => a.F_FullName).ToList());
}
return(data);
}
/// <summary>
/// soul数据反向模板化
/// </summary>
/// <param name=""moduleName>菜单名称</param>
/// <returns></returns>
protected SoulPage <TEntity> ChangeSoulData <TEntity>(Dictionary <string, Dictionary <string, string> > dic, SoulPage <TEntity> pagination)
{
List <FilterSo> filterSos = pagination.getFilterSos();
filterSos = FormatData(dic, filterSos);
pagination.filterSos = filterSos.ToJson();
return(pagination);
}
public async Task <List <ArticleNewsEntity> > GetLookList(SoulPage <ArticleNewsEntity> pagination, string keyword = "", string CategoryId = "")
{
//反格式化显示只能用"等于"，其他不支持
Dictionary <string, Dictionary <string, string> > dic = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> enabledTemp = new Dictionary <string, string>();
enabledTemp.Add("有效", "1");
enabledTemp.Add("无效", "0");
dic.Add("F_EnabledMark", enabledTemp);
Dictionary <string, string> isTrue = new Dictionary <string, string>();
enabledTemp.Add("是", "1");
enabledTemp.Add("否", "0");
dic.Add("F_IsTop", isTrue);
dic.Add("F_IsHot", isTrue);
pagination = ChangeSoulData(dic, pagination);
//获取新闻列表
var query = repository.IQueryable(a => a.F_EnabledMark == true)
.LeftJoin <ArticleCategoryEntity>((a, b) => a.F_CategoryId == b.F_Id && b.F_EnabledMark == true)
.Select((a, b) => new ArticleNewsEntity
{
F_Id = a.F_Id,
F_CategoryId = a.F_CategoryId,
F_CategoryName = b.F_FullName,
F_Title = a.F_Title,
F_LinkUrl = a.F_LinkUrl,
F_ImgUrl = a.F_ImgUrl,
F_SeoTitle = a.F_SeoTitle,
F_SeoKeywords = a.F_SeoKeywords,
F_SeoDescription = a.F_SeoDescription,
F_Tags = a.F_Tags,
F_Zhaiyao = a.F_Zhaiyao,
F_Description = a.F_Description,
F_SortCode = a.F_SortCode,
F_IsTop = a.F_IsTop,
F_IsHot = a.F_IsHot,
F_IsRed = a.F_IsRed,
F_Click = a.F_Click,
F_Source = a.F_Source,
F_Author = a.F_Author,
F_EnabledMark = a.F_EnabledMark,
F_CreatorTime = a.F_CreatorTime,
F_CreatorUserId = a.F_CreatorUserId,
F_DeleteMark = a.F_DeleteMark,
F_DeleteTime = a.F_DeleteTime,
F_DeleteUserId = a.F_DeleteUserId,
F_LastModifyTime = a.F_LastModifyTime,
F_LastModifyUserId = a.F_LastModifyUserId,
});
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(a => a.F_Title.Contains(keyword));
}
if (!string.IsNullOrEmpty(CategoryId))
{
query = query.Where(a => a.F_CategoryId.Contains(CategoryId));
}
query = query.Where(u => u.F_DeleteMark == false);
//权限过滤
query = GetDataPrivilege <ArticleNewsEntity>("u", "", query);
return(await repository.OrderList(query, pagination));
}
