/// <summary> /// 获取分销退货数据 /// </summary> /// <param name="request">分销退货请求</param> /// <returns>System.Object.</returns> /// <remarks>聚石塔WebService</remarks> public object Any(GetFXRefund request) { //记录请求 logger.Debug(JsonConvert.SerializeObject(request)); //验证请求数据 FXRefundValidator validator = new FXRefundValidator(); ValidationResult results = validator.Validate(request); if (!results.IsValid) { logger.Error(JsonConvert.SerializeObject(results)); return(results); } //业务数据查询 using (RDSContext db = new RDSContext()) { IQueryable <jdp_fx_refund> q = db.jdp_fx_refund; //0:淘宝推送时间;1:订单修改时间;默认0 if (request.DateType == 0) { q = q.Where(u => u.jdp_modified >= request.StartDateTime && u.jdp_modified <= request.EndDateTime).OrderBy(m => m.jdp_modified); } else { q = q.Where(u => u.modified >= request.StartDateTime && u.modified <= request.EndDateTime).OrderBy(m => m.modified); } //订单状态 if (request.RefundStatus != 0) { q = q.Where(u => u.refund_status == request.RefundStatus); } if (!string.IsNullOrEmpty(request.SupplierNick)) { q = q.Where(u => u.supplier_nick == request.SupplierNick); } if (!string.IsNullOrEmpty(request.DistributorNick)) { q = q.Where(u => u.distributor_nick == request.DistributorNick); } //组装返回对象 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 => u.jdp_response).ToList(); //记录返回对象 logger.Debug(JsonConvert.SerializeObject(results)); return(response); } }
/// <summary> /// 获取分销退货数据 /// </summary> /// <param name="request">分销退货请求</param> /// <returns>System.Object.</returns> /// <remarks>聚石塔WebService</remarks> public object Any(GetFXRefund request) { //记录请求 logger.Debug(JsonConvert.SerializeObject(request)); //验证请求数据 FXRefundValidator validator = new FXRefundValidator(); ValidationResult results = validator.Validate(request); if (!results.IsValid) { logger.Error(JsonConvert.SerializeObject(results)); return results; } //业务数据查询 using (RDSContext db = new RDSContext()) { IQueryable<jdp_fx_refund> q = db.jdp_fx_refund; //0:淘宝推送时间;1:订单修改时间;默认0 if (request.DateType == 0) { q = q.Where(u => u.jdp_modified >= request.StartDateTime && u.jdp_modified <= request.EndDateTime).OrderBy(m => m.jdp_modified); } else { q = q.Where(u => u.modified >= request.StartDateTime && u.modified <= request.EndDateTime).OrderBy(m => m.modified); } //订单状态 if (request.RefundStatus != 0) { q = q.Where(u => u.refund_status == request.RefundStatus ); } if (!string.IsNullOrEmpty(request.SupplierNick)) { q = q.Where(u => u.supplier_nick == request.SupplierNick); } if (!string.IsNullOrEmpty(request.DistributorNick )) { q = q.Where(u => u.distributor_nick == request.DistributorNick); } //组装返回对象 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 => u.jdp_response ).ToList(); //记录返回对象 logger.Debug(JsonConvert.SerializeObject(results)); return response; } }