/// <summary> /// Anies the specified request. /// </summary> /// <param name="request">The request.</param> /// <returns>System.Object.</returns> /// <remarks>聚石塔WebService</remarks> public object Any(GetTBItem request) { logger.Debug(JsonConvert.SerializeObject(request)); TBItemValidator validator = new TBItemValidator(); ValidationResult results = validator.Validate(request); if (!results.IsValid) { logger.Error(JsonConvert.SerializeObject(results)); return(results); } using (RDSContext db = new RDSContext()) { IQueryable <jdp_tb_item> q = db.jdp_tb_item; //0:淘宝推送时间;1:订单修改时间;默认0 if (request.DateType == 0) { q = q.Where(u => u.jdp_modified >= request.StartDateTime && u.created <= request.EndDateTime).OrderBy(m => m.jdp_modified); } else { q = q.Where(u => u.modified >= request.StartDateTime && u.created <= request.EndDateTime).OrderBy(m => m.modified); } //店铺支持多选,格式shop1,shop2,shop3 if (!string.IsNullOrEmpty(request.Nicks)) { q = q.Where(u => request.Nicks.Contains(u.nick)); } //1:在售;2:下架;0:全部;默认0 if (request.Status != 0) { q = q.Where(u => u.approve_status == ((TBItemStatus)request.Status).ToString()); } DefaultResponse response = new DefaultResponse(); response.PageSize = request.PageSize; response.RecordCount = q.Count(); response.PageCount = (int)Math.Ceiling(response.RecordCount * 1.00 / response.PageSize); response.Result = q.Skip(request.PageNo * request.PageSize).Take(request.PageSize).Select(u => new { u.jdp_response, u.jdp_delete }).ToList(); logger.Debug(JsonConvert.SerializeObject(results)); return(response); } }
/// <summary> /// Anies the specified request. /// </summary> /// <param name="request">The request.</param> /// <returns>System.Object.</returns> /// <remarks>聚石塔WebService</remarks> public object Any(GetTBItem request) { logger.Debug(JsonConvert.SerializeObject(request)); TBItemValidator validator = new TBItemValidator(); ValidationResult results = validator.Validate(request); if (!results.IsValid) { logger.Error(JsonConvert.SerializeObject(results)); return results; } using (RDSContext db = new RDSContext()) { IQueryable<jdp_tb_item> q = db.jdp_tb_item; //0:淘宝推送时间;1:订单修改时间;默认0 if (request.DateType == 0) { q = q.Where(u => u.jdp_modified >= request.StartDateTime && u.created <= request.EndDateTime).OrderBy( m => m.jdp_modified); }else { q = q.Where(u => u.modified >= request.StartDateTime && u.created <= request.EndDateTime).OrderBy(m => m.modified); } //店铺支持多选,格式shop1,shop2,shop3 if (!string.IsNullOrEmpty(request.Nicks )) { q = q.Where(u => request.Nicks.Contains(u.nick)); } //1:在售;2:下架;0:全部;默认0 if (request.Status != 0) { q = q.Where(u => u.approve_status == ((TBItemStatus)request.Status).ToString()); } DefaultResponse response = new DefaultResponse(); response.PageSize = request.PageSize; response.RecordCount = q.Count(); response.PageCount = (int)Math.Ceiling(response.RecordCount * 1.00 / response.PageSize); response.Result = q.Skip(request.PageNo * request.PageSize).Take(request.PageSize).Select(u => new { u.jdp_response,u.jdp_delete }).ToList(); logger.Debug(JsonConvert.SerializeObject(results)); return response; } }