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