/// <summary>
/// 查询列表
/// </summary>
/// <param name="requestModel"></param>
/// <returns></returns>
public BusinessPagedBaseViewModel <QuerySystemRoleResponseModel> Query(QuerySystemRoleRequestModel requestModel)
{
var res = new BusinessPagedBaseViewModel <QuerySystemRoleResponseModel>()
{
Status = ResponseStatus.Fail
};
var filter = PredicateBuilder.True <SystemRole>();
if (!requestModel.KeyWord.IsNullOrWhiteSpace())
{
filter = filter.And(x => x.RoleName.Contains(requestModel.KeyWord));
}
var order = new IOrderByBuilder <SystemRole>[]
{
new OrderByBuilder <SystemRole, int>(x => x.Sort, false),
};
var query = _systemRoleRepository.Find(out int total, requestModel.PageIndex, requestModel.PageSize, filter, order);
if (query.Any())
{
var list = query.MapToList <QuerySystemRoleResponseModel>();
res.BusinessData = list;
}
res.Total = total;
res.Status = ResponseStatus.Success;
return(res);
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="requestModel"></param>
/// <returns></returns>
public BusinessBaseViewModel <IList <QuerySystemSectionResponseModel> > Query(QuerySystemSectionRequestModel requestModel)
{
var res = new BusinessBaseViewModel <IList <QuerySystemSectionResponseModel> >()
{
Status = ResponseStatus.Fail
};
var filter = PredicateBuilder.True <SystemSection>();
if (!requestModel.KeyWord.IsNullOrWhiteSpace())
{
filter = filter.And(x => x.Name.Contains(requestModel.KeyWord));
}
var order = new IOrderByBuilder <SystemSection>[]
{
new OrderByBuilder <SystemSection, int>(x => x.Sort, false),
};
var query = _systemSectionRepository.Find(filter, order);
if (query.Any())
{
var list = query.MapToList <QuerySystemSectionResponseModel>();
res.BusinessData = list;
}
res.Status = ResponseStatus.Success;
return(res);
}
public BusinessPagedBaseViewModel <QuerySystemMenuResponseModel> Query(QuerySystemMenuRequestModel requestModel)
{
var res = new BusinessPagedBaseViewModel <QuerySystemMenuResponseModel>()
{
Status = ResponseStatus.Fail
};
var filter = PredicateBuilder.True <SystemMenu>();
if (!requestModel.KeyWord.IsNullOrWhiteSpace())
{
filter = filter.And(x => x.MenuName.Contains(requestModel.KeyWord));
}
var order = new IOrderByBuilder <SystemMenu>[]
{
new OrderByBuilder <SystemMenu, int>(x => x.MenuSort, false),
};
var query = _systemMenuRepository.Find(filter, order);
if (query.Any())
{
var list = query.MapToList <QuerySystemMenuResponseModel>();
var buttonList = _systemActionButtonRepository.Find(x => x.Enabled == true).ToList();
list.ForEach(m =>
{
if (!m.MenuButtonId.IsNullOrWhiteSpace())
{
var bids = m.MenuButtonId.ToSplitArray(',').ToList();
var bName = buttonList.Where(x => bids.Contains(x.Id.ToString())).Select(x => x.ButtonName).ToList();
if (!bName.IsNull())
{
m.MenuButtonName = string.Join(",", bName);
}
}
});
res.BusinessData = list;
}
res.Status = ResponseStatus.Success;
return(res);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BusinessPagedBaseViewModel <MQBusinessResponse> FindList(MQBusinessRequest request)
{
int totalCount = 0;
var res = new BusinessPagedBaseViewModel <MQBusinessResponse>()
{
Status = ResponseStatus.Fail
};
#region 条件处理
var filter = PredicateBuilder.True <MQBusinessConfig>();
filter = filter.And(x => x.Status == (int)YesOrNo.Yes);
if (request.CreateBeginTime.HasValue)
{
filter = filter.And(x => x.CreateTime >= request.CreateBeginTime.Value);
}
if (request.CreateEndTime.HasValue)
{
filter = filter.And(x => x.CreateTime <= request.CreateEndTime.Value);
}
if (!string.IsNullOrWhiteSpace(request.KeyWords))
{
filter = filter.And(x => x.BusinessName.Contains(request.KeyWords));
}
#endregion
#region 排序处理
var order = new IOrderByBuilder <MQBusinessConfig>[]
{
new OrderByBuilder <MQBusinessConfig, DateTime?>(x => x.CreateTime, true),
};
#endregion
var query = _mQBusinessConfigRepository.Find(out totalCount, request.PageIndex, request.PageSize, filter, order);
#region 返回数据处理
res.Status = ResponseStatus.Success;
var list = query.ToList();
res.BusinessData = list.MapToList <MQBusinessResponse>();
res.Total = totalCount;
#endregion
return(res);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="requestModel"></param>
/// <returns></returns>
public BusinessPagedBaseViewModel <QuerySystemStaffResponseModel> Query(QuerySystemStaffRequestModel requestModel)
{
var res = new BusinessPagedBaseViewModel <QuerySystemStaffResponseModel>()
{
Status = ResponseStatus.Fail
};
var filter = PredicateBuilder.True <SystemStaff>();
filter = filter.And(x => x.Status != (int)SystemStaffStatus.Del);
if (!requestModel.KeyWord.IsNullOrWhiteSpace())
{
filter = filter.And(x => x.LoginName.Contains(requestModel.KeyWord) || x.NickName.Contains(requestModel.KeyWord) ||
x.Mobile.Contains(requestModel.KeyWord));
}
var order = new IOrderByBuilder <SystemStaff>[]
{
new OrderByBuilder <SystemStaff, DateTime?>(x => x.CreateTime, true),
};
var query = _staffRepostory.Find(out int totalCount, requestModel.PageIndex, requestModel.PageSize, filter, order);
if (query.Any())
{
var viewModel = query.MapToList <QuerySystemStaffResponseModel>();
//获取部门名称
var sectionIds = viewModel.Select(x => x.SectionId).ToList();
var sectionList = _systemSectionRepository.Find(x => sectionIds.Contains(x.Id.ToString()));
if (sectionList.Any())
{
viewModel.ForEach(m =>
{
var section = sectionList.Where(x => m.SectionId == x.Id + "").Select(x => x.Name).ToList();
if (!section.IsNull())
{
m.SectionName = string.Join(",", section);
}
});
}
//获取角色名称
var StaffIds = viewModel.Select(x => x.Id);
var roleList = _systemRoleService.FindStaffRoleNameByStaffId(StaffIds);
if (roleList.Any())
{
viewModel.ForEach(m =>
{
var role = roleList.Where(x => m.Id == x.StaffId).Select(x => x.RoleName).ToList();
if (!role.IsNull())
{
m.RoleName = string.Join(",", role);
}
});
}
res.BusinessData = viewModel;
}
res.Total = totalCount;
res.Status = ResponseStatus.Success;
return(res);
}
