///// <summary>
///// 根据主键获取实体集合
///// </summary>
///// <param name="ids"></param>
///// <returns></returns>
//public List<Areas> GetList(List<int> ids)
//{
// return _unitOfWork.AreasManage.GetList(ids);
//}
/// <summary>
/// 分页方法
/// </summary>
/// <param name="page"></param>
/// <param name="size"></param>
/// <param name="sort"></param>
/// <param name="condition"></param>
/// <returns></returns>
public PageModel <Areas> GetByPage(int page, int size, string sort, AreasCondition condition)
{
var dbCondition = new List <DbCondition <Areas> >();
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = !string.IsNullOrEmpty(condition.Name), Expression = x => x.Name.Contains(condition.Name)
});
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = condition.ParentID != null, Expression = x => x.ParentID == condition.ParentID
});
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = condition.Type != null, Expression = x => x.Type == (int)condition.Type
});
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = !string.IsNullOrEmpty(condition.FullPinying), Expression = x => x.FullPinying.Contains(condition.FullPinying)
});
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = !string.IsNullOrEmpty(condition.ShortPinying), Expression = x => x.ShortPinying.Contains(condition.ShortPinying)
});
dbCondition.Add(new DbCondition <Areas>()
{
IsWhere = condition.IsUsual != null, Expression = x => x.IsUsual == (byte)(condition.IsUsual.GetValueOrDefault() ? 1 : 0)
});
return(_unitOfWork.AreasManage.GetAreasByPage(page, size, sort, dbCondition));
}
public List <Areas> GetByParameters(AreasCondition condition)
{
var list = Db.Queryable <Areas>().WhereIF(!string.IsNullOrEmpty(condition.Name), x => x.Name.Contains(condition.Name))
.WhereIF(condition.ParentID != null, x => x.ParentID == condition.ParentID)
.WhereIF(condition.Type != null, x => x.Type == (int)condition.Type)
.WhereIF(!string.IsNullOrEmpty(condition.FullPinying), x => x.FullPinying.Contains(condition.FullPinying))
.WhereIF(!string.IsNullOrEmpty(condition.ShortPinying), x => x.ShortPinying.Contains(condition.ShortPinying))
.WhereIF(condition.IsUsual != null, x => x.IsUsual == (byte)(condition.IsUsual.GetValueOrDefault()?1:0)).ToList();
return(list);
}
public IActionResult Get(string name, int?parentId, AreaType?type, string fullPinying, string shortPingying, bool?isUsual)
{
var condition = new AreasCondition()
{
Name = name,
ParentID = parentId,
Type = type,
FullPinying = fullPinying,
ShortPinying = shortPingying,
IsUsual = isUsual
};
var data = _areasService.GetByParameters(condition);
return(Ok(data));
}
public IActionResult Get(int page, int num, string name, string fullPinying, string shortPingying, bool?isUsual, int?parentId, AreaType?type, string sort = "Id", bool?asc = true)
{
var condition = new AreasCondition()
{
Name = name,
ParentID = parentId,
Type = type,
FullPinying = fullPinying,
ShortPinying = shortPingying,
IsUsual = isUsual
};
if (page <= 0 || num <= 0)
{
return(BadRequest(MessageFactory.CreatePageParamsInvalidMessage()));
}
var data = _areasService.GetByPage(page, num, sort, condition);
return(Ok(data));
}
public List <Areas> GetByParameters(AreasCondition condition)
{
return(_unitOfWork.AreasManage.GetByParameters(condition));
}
