public OrderSearchResponse Search(OrderSearchRequest request)
{
var response = new OrderSearchResponse();
response.List = _facade.Search(request.Filter, request.PaginationInfo);
return(response);
}
private async void SetData()
{
var pendingOrdersSearchObject = new OrderSearchRequest {
OrderStatus = OrderStatus.Pending, Client = new PersonDTO(), Location = new LocationDTO()
};
var pendingOrders = await _orderAPIService.Get <List <OrderDTO> >(pendingOrdersSearchObject);
dgvPendingOrders.DataSource = pendingOrders
.Select(x => new
{
x.Id,
Client = $"{x.Client.FirstName} {x.Client.LastName}",
Location = $"Address: {x.Location.AddressLine}, Phone number: {x.Location.PhoneNumber}",
x.Total,
x.TotalWithTax,
OrderType = x.OrderType.ToString(),
PaymentType = x.PaymentType.ToString(),
x.IsPayed,
DateCreated = x.DateTimeCreatedDisplay
}).ToList();
var activeOrdersSearchObject = new OrderSearchRequest {
OrderStatus = OrderStatus.Processing, Client = new PersonDTO(), Location = new LocationDTO()
};
var activeOrders = await _orderAPIService.Get <List <OrderDTO> >(activeOrdersSearchObject);
dgvActiveOrders.DataSource = activeOrders
.Select(x => new
{
x.Id,
Client = $"{x.Client.FirstName} {x.Client.LastName}",
Location = $"Address: {x.Location.AddressLine}, Phone number: {x.Location.PhoneNumber}",
x.Total,
x.TotalWithTax,
OrderType = x.OrderType.ToString(),
PaymentType = x.PaymentType.ToString(),
x.IsPayed,
DateCreated = x.DateTimeCreatedDisplay
}).ToList();
var historyOrdersSearchObject = new OrderSearchRequest {
OrderStatus = OrderStatus.Completed, Client = new PersonDTO(), Location = new LocationDTO()
};
var historyOrders = await _orderAPIService.Get <List <OrderDTO> >(historyOrdersSearchObject);
dgvOrderHistory.DataSource = historyOrders
.Select(x => new
{
x.Id,
Client = $"{x.Client.FirstName} {x.Client.LastName}",
Location = $"Address: {x.Location.AddressLine}, Phone number: {x.Location.PhoneNumber}",
x.Total,
x.TotalWithTax,
OrderType = x.OrderType.ToString(),
PaymentType = x.PaymentType.ToString(),
x.IsPayed,
DateCreated = x.DateTimeCreatedDisplay
}).ToList();
}
public async Task <IWrappedResponse> Search(OrderSearchRequest request)
{
var cmd = ServiceCommand <Order, Rules.Order.Search.MainRule>
.Create(_serviceProvider)
.When(new Rules.Order.Search.MainRule(request))
.Then(SearchAction);
return(await cmd.Execute());
}
public async Task Init()
{
var request = new OrderSearchRequest()
{
CustomerId = APIService.Client.Id
};
var result = await _service.Get <List <Order> >(request);
result = result.OrderByDescending(x => x.OrderDate).ToList();
Orders.Clear();
result.ForEach((Order order) => Orders.Add(order));
}
public ActionResult Index()
{
OrderSearchRequest viewModel = Session["PageMetaData"] as OrderSearchRequest;
Session["PageMetaData"] = null;
ViewBag.MessageVM = TempData["message"] as MessageViewModel;
var toReturnModel = new OrderListViewModel
{
orderSearchRequest = viewModel ?? new OrderSearchRequest()
};
return(View(toReturnModel));
}
private static bool IsValidConnection()
{
//return true;
try
{
OrderSearchRequest osr = new OrderSearchRequest();
osr.MaxRows = 1;
dsOrderList dsOrders = BusinessFlow.WebServices.Order.Search(osr);
return true;
}
catch (Exception)
{
return false;
}
}
public async Task <ResponseList <OrderResponse> > Search(OrderSearchRequest request)
{
int skip = request.PageNumber * request.PageSize;
(var orders, int total) = await _uow.Orders.Search(request.FullText, request.UserId, request.OrderState, request.PaymentState, skip, request.PageSize);
if (orders == null)
{
return(new ResponseList <OrderResponse>(ResponseStatus.NotFound, null, ResponseMessagesConstans.NotFound));
}
var result = orders.Select(x => _mapService.MapOrder(x)).ToList();
return(new ResponseList <OrderResponse>(ResponseStatus.Ok, result, total));
}
public List <Model.Models.Order> Get(OrderSearchRequest request)
{
if (request.Filter < 1 || request.Filter > 3)
{
throw new UserException("Filter za narudžbe nije validan");
}
var query = _context.Order.OrderByDescending(x => x.OrderDate).AsQueryable();
if (request.CustomerId != 0)
{
query = query.Where(x => x.CustomerId == request.CustomerId);
}
// Aktivni
if (request.Filter == 2)
{
query = query.Where(x => (bool)x.Active);
}
// Neaktivni
if (request.Filter == 3)
{
query = query.Where(x => (bool)!x.Active);
}
// Ako koristimo pagination
if (request.Page != -1)
{
query = query
.Skip((request.Page - 1) * request.ItemsPerPage)
.Take(request.ItemsPerPage);
}
var data = query.ToList();
var orders = _mapper.Map <List <Model.Models.Order> >(data);
foreach (var order in orders)
{
order.Products = new List <KeyValuePair <int, Model.Models.Product> >();
order.Products = GetOrderProducts(order.Id);
order.CustomerName = _context.Customer.Find(order.CustomerId).CompanyName;
}
return(orders);
}
public ActionResult GetBySearch([FromBody] OrderSearchRequest searchRequest)
{
if (searchRequest == null)
{
return(StatusCode(StatusCodes.Status400BadRequest, "Search request cannot be empty"));
}
try
{
var dataRequestValidator = new OrderSearchRequestValidator();
var validationResult = dataRequestValidator.Validate(searchRequest);
if (!validationResult.IsValid)
{
string errorMessage = "";
foreach (var error in validationResult.Errors)
{
errorMessage += error.ErrorMessage + " ";
}
return(Conflict(errorMessage));
}
}
catch (Exception e)
{
_logger.LogError($"Search orders. Input data failed validation. Full validator exception message: {e.Message}");
return(StatusCode(StatusCodes.Status500InternalServerError, "Internal server error"));
}
var blResult = _userOrderService.GetBySearch(searchRequest);
if (blResult.actionResult.ResultConnection == ServiceResult.ResultConnectionEnum.Correct &&
blResult.userOrders == null)
{
return(NotFound("Orders not exist"));
}
if (blResult.actionResult.ResultConnection != ServiceResult.ResultConnectionEnum.Correct)
{
return(StatusCode(StatusCodes.Status500InternalServerError, blResult.actionResult.Message));
}
return(Ok(blResult.userOrders));
}
public IActionResult Search([FromQuery] OrderSearchRequest filter)
{
ResultCode resultCode; QueryModel queryResult;
(resultCode, queryResult) = _service.Search(filter);
Result error; int statusCode;
(statusCode, error) = ResultHandler.GetStatusCodeAndResult(resultCode);
GeneralResponse response = new GeneralResponse
{
Result = queryResult,
Error = error,
};
return(StatusCode(statusCode, response));
}
public override async Task <OrderSearchResponse> Order_Search(OrderSearchRequest request, ServerCallContext context)
{
//TODO 从底层ES中查找订单数据，
//可以设计成DDD 方式来进行ES的操作，这里我就为了演示直接硬编码了
var response = new OrderSearchResponse();
try
{
response.Data.Add(new OrderRepsonse()
{
Amount = 100.00,
Count = 10,
Name = "订单名称测试",
OrderId = DateTime.Now.ToString("yyyyMMddHHmmss"),
Time = DateTime.Now.ToString()
});
response.Data.Add(new OrderRepsonse()
{
Amount = 200.00,
Count = 10,
Name = "订单名称测试2",
OrderId = DateTime.Now.ToString("yyyyMMddHHmmss"),
Time = DateTime.Now.ToString()
});
response.Data.Add(new OrderRepsonse()
{
Amount = 300.00,
Count = 10,
Name = "订单名称测试2",
OrderId = DateTime.Now.ToString("yyyyMMddHHmmss"),
Time = DateTime.Now.ToString()
});
response.Success = true;
}
catch (Exception ex)
{
response.ErrorMsg = ex.Message;
_logger.LogWarning("异常");
}
return(response);
}
public async System.Threading.Tasks.Task TestOrderSearchServiceAsync()
{
OrderSearchRequest orderSearchRequest = new OrderSearchRequest()
{
OrderSearchBody = new OrderSearchBody()
{
OrderSearch = new OrderSearch()
{
Orderid = "ywbj-110",
SearchType = "1"
}
}
};
ISFClient sFClient = new DefaultSFClient(_sFNetConfig);
var response = await sFClient.ExcuteAsync(orderSearchRequest);
Assert.True(response.Head == "OK");
}
public ActionResult Index(OrderSearchRequest orderSearchRequest)
{
if (!User.IsInRole("Admin"))
{
orderSearchRequest.UserId = User.Identity.GetUserId();
}
ViewBag.MessageVM = TempData["message"] as MessageViewModel;
OrderResponse oResponse = orderService.GetAllOrders(orderSearchRequest);
List <Models.Order> oList = oResponse.Orders.Select(x => x.CreateFromServerToClient()).ToList();
OrderListViewModel oLVModel = new OrderListViewModel
{
data = oList,
recordsTotal = oResponse.TotalCount,
recordsFiltered = oResponse.FilteredCount
};
Session["PageMetaData"] = orderSearchRequest;
var toReturn = Json(oLVModel, JsonRequestBehavior.AllowGet);
return(toReturn);
}
private async void frmOrders_Load(object sender, EventArgs e)
{
loader1.Visible = true;
var SearchRequest = new OrderSearchRequest()
{
Filter = Filter,
Page = Page,
ItemsPerPage = 6
};
var request = await _service.Get <List <EToolService.Model.Models.Order> >(SearchRequest);
if (Page > 1 && request.Count == 0)
{
Page--;
return;
}
if (Page < 1)
{
Page = 1;
return;
}
ClearPanel();
for (int i = request.Count - 1; i >= 0; i--)
{
var card = new OrderCard(request[i])
{
Parent = this
};
card.Dock = DockStyle.Top;
card.Show();
pnlOrders.Controls.Add(card);
}
loader1.Visible = false;
}
private List <OrderInfo> GetOrderList(DateTime startDate, DateTime endDate, string orderState, int page, int pageSize, out Int32 totalCount, bool recursive)
{
try
{
OrderSearchRequest request = new OrderSearchRequest();
request.StartDate = startDate;
request.EndDate = endDate;
request.OrderState = orderState;
request.Page = page;
request.PageSize = pageSize;
OrderSearchResponse response = Client.Execute(request, AppContext.AccessToken.Token);
if (!response.IsError)
{
List <OrderInfo> list = new List <OrderInfo>();
if (response.OrderSearch == null || response.OrderSearch.OrderInfoList == null || response.OrderSearch.OrderInfoList.Count == 0)
{
totalCount = 0;
return(list);
}
list.AddRange(response.OrderSearch.OrderInfoList);
if (recursive && page * pageSize < response.OrderSearch.OrderTotal)
{
list.AddRange(GetOrderList(startDate, endDate, orderState, ++page, pageSize, out totalCount, true));
}
totalCount = response.OrderSearch.OrderTotal;
return(list);
}
else
{
throw new Exception(response.ErrCode + "：" + response.ErrMsg);
}
}
catch (Exception ex)
{
throw ex;
}
}
public OrderSearchQueryRule(OrderSearchRequest request, IRule parentRule)
{
// Create Context
Context = new ContextModel(request, this);
ParentRule = parentRule;
}
public MainRule(OrderSearchRequest request)
{
// Create Context
Context = new ContextModel(request, this);
}
private List<OrderInfo> GetOrderList(DateTime startDate, DateTime endDate, string orderState, int page, int pageSize, out Int32 totalCount, bool recursive)
{
try
{
OrderSearchRequest request = new OrderSearchRequest();
request.StartDate = startDate;
request.EndDate = endDate;
request.OrderState = orderState;
request.Page = page;
request.PageSize = pageSize;
OrderSearchResponse response = Client.Execute(request, AppContext.AccessToken.Token);
if (!response.IsError)
{
List<OrderInfo> list = new List<OrderInfo>();
if (response.OrderSearch == null || response.OrderSearch.OrderInfoList == null || response.OrderSearch.OrderInfoList.Count == 0)
{
totalCount = 0;
return list;
}
list.AddRange(response.OrderSearch.OrderInfoList);
if (recursive && page * pageSize < response.OrderSearch.OrderTotal)
{
list.AddRange(GetOrderList(startDate, endDate, orderState, ++page, pageSize, out totalCount, true));
}
totalCount = response.OrderSearch.OrderTotal;
return list;
}
else
{
throw new Exception(response.ErrCode + "：" + response.ErrMsg);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseResult<SerachModel> Search(DateTime start_date = default(DateTime), DateTime end_date = default(DateTime), int page = 1, int page_size = 10, OrderState order_state = OrderState.ALL, string optional_fields = "", SortType sortType = SortType.Ase, DateType dateType = DateType.Modify_Time)
{
// OAuth oauth = new OAuth(Config._AppKey, Config._AppSecret);
IJdClient client = new DefaultJdClient("http://gw.api.360buy.com/routerjson", Config._AppKey, Config._AppSecret);
var request = new OrderSearchRequest();
request.OptionalFields = optional_fields;
if (order_state != OrderState.ALL)
{
request.OrderState = order_state.ToString();
}
#region 对传入参数进行判断 并且给予SearchRequest 请求赋值
if(start_date!= default(DateTime))
{
request.StartDate = start_date;
}
if(end_date != default(DateTime))
{
request.EndDate = end_date;//.ToString("yyyy-MM-dd HH:mm:ss");
}
if(start_date != default(DateTime)&& end_date != default(DateTime))
{
if (start_date > end_date)
{
throw new Exception("开始时间不能大于结束时间");
}
}
request.Page = page;
request.PageSize = page_size;
if (order_state != OrderState.ALL)
{
request.OrderState = order_state.ToString();
}
else
{
request.OrderState = "WAIT_SELLER_STOCK_OUT,SEND_TO_DISTRIBUTION_CENER,DISTRIBUTION_CENTER_RECEIVED,WAIT_GOODS_RECEIVE_CONFIRM,RECEIPTS_CONFIRM,WAIT_SELLER_DELIVERY,FINISHED_L,TRADE_CANCELED,LOCKED";
}
request.OptionalFields = optional_fields;
//request.SortType = sortType.ToString();
//request.DateType = dateType.ToString();
//TODO: 参数判断
#endregion
var response = client.Execute(request, Config._SessionCode, DateTime.Now.ToLocalTime());
if (response.ErrCode.ToInt() != 0)
{
return new ResponseResult<SerachModel>()
{
Code = response.ErrCode.ToInt(),
Result = null,
DescZH=response.ZhErrMsg,
DescEN=response.EnErrMsg
};
}
var model = new WrapSerachOrderModel().WrapModel(response.OrderSearch);
return new ResponseResult<SerachModel>()
{
Code =response.ErrCode.ToInt(),
Result = model
};
}
public (ServiceResult actionResult, IEnumerable <OrderData> userOrders) GetBySearch(OrderSearchRequest searchRequest)
{
var list = _dbContext.UserOrders.SelectAll();
List <OrderData> ordersResult = new List <OrderData>();
OrderStatus orderStatus = new OrderStatus(searchRequest.Status);
string searchString = searchRequest.SearchString.ToLower().Trim();
foreach (var order in list)
{
if (order.OrderStatus.Status != orderStatus.Status)
{
continue;
}
if (order.IdEntity.HasValue && order.IdEntity.Value.ToString().Contains(searchString) ||
order.Address.ToLower().Contains(searchString) ||
order.UserSystem.FirsName.ToLower().Contains(searchRequest.SearchString.ToLower()) ||
order.UserSystem.LastName.ToLower().Contains(searchRequest.SearchString.ToLower()) ||
order.UserSystem.Phone.ToLower().Contains(searchRequest.SearchString.ToLower()) ||
order.UserSystem.Email.ToLower().Contains(searchRequest.SearchString.ToLower()))
{
OrderData orderData = MapOrderData(order);
if (orderData != null)
{
ordersResult.Add(orderData);
}
}
}
ordersResult.Reverse();
ServiceResult serviceResult = new ServiceResult(ServiceResult.ResultConnectionEnum.Correct, "");
return(serviceResult, ordersResult);
}
public List <EToolService.Model.Models.Order> Get([FromQuery] OrderSearchRequest request)
{
return(_service.Get(request));
}
/// <summary>
/// 京东订单检索（360buy.order.search）
/// 定时同步时使用
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="orderState"></param>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <param name="recursive"></param>
/// <returns></returns>
public string GetOrderList(string startDate, string endDate, string orderState, string page, string pageSize, out Int32 totalCount, bool recursive)
{
try
{
int count = 0;
string AppKey = "0901C6C9E495BDB7FEEAE8EEA47D13F2"; //xMorderInfoApp.AppKey;
string AppSecret = "1916857c7087437095775f29763f527b"; //xMorderInfoApp.AppSecret;
string CallbackUrl = "http://www.hozest.com"; // xMorderInfoApp.CallbackUrl;
string AccessToken = "032ecc44-7ac6-46c3-a4b7-7e844f7ea1b4"; // xMorderInfoApp.AccessToken;
Jd.Api.IJdClient Client = new DefaultJdClient("http://gw.api.360buy.com/routerjson", AppKey, AppSecret, AccessToken);
OrderSearchRequest request = new OrderSearchRequest();
//
request.startDate = startDate.ToString(); //开始时间
request.endDate = endDate.ToString(); //结束时间
request.orderState = orderState;
request.page = page.ToString();
request.pageSize = pageSize.ToString();
request.optionalFields = "order_id,vender_id,pay_type,order_total_price,order_payment,order_seller_price,freight_price,seller_discount,order_state,delivery_type,invoice_info,order_remark,order_start_time,order_end_time,modified,payment_confirm_time,pin,consignee_info,coupon_detail_list,item_info_list,logistics_id,waybill,vender_remark";
OrderSearchResponse response = Client.Execute(request);
string s = "\"consignee_info\":\"\",";
string ns = "\"consignee_info\":null,";
string str = response.Body.Replace(s, ns);
OrderSearchResponse m = JsonConvert.DeserializeObject <OrderSearchResponse>(str);
if (m.orderSearch == null)
{
for (int i = 1; i < 10; i++)
{
Client = new DefaultJdClient("http://gw.api.360buy.com/routerjson", AppKey, AppSecret, AccessToken);
OrderSearchRequest requestfor = new OrderSearchRequest();
requestfor.startDate = startDate; //付款开始时间
requestfor.endDate = endDate; //付款结束时间
requestfor.orderState = orderState;
requestfor.page = page;
requestfor.pageSize = pageSize;
requestfor.optionalFields = "order_id,vender_id,pay_type,order_total_price,order_payment,order_seller_price,freight_price,seller_discount,order_state,delivery_type,invoice_info,order_remark,order_start_time,order_end_time,modified,payment_confirm_time,pin,consignee_info,coupon_detail_list,item_info_list,logistics_id,waybill,vender_remark";
OrderSearchResponse responsefor = Client.Execute(requestfor);
string sfor = "\"consignee_info\":\"\",";
string nsfor = "\"consignee_info\":null,";
string strfor = responsefor.Body.Replace(sfor, nsfor);
OrderSearchResponse mfor = JsonConvert.DeserializeObject <OrderSearchResponse>(strfor);
if (mfor.orderSearch != null)
{
if (!responsefor.IsError)
{
count = mfor.orderSearch.Count();
totalCount = count;
return("");
;
}
else
{
throw new Exception("错误代码：" + responsefor.ErrCode + "错误信息：" + responsefor.ErrMsg);
}
}
}
}
else
{
if (!response.IsError)
{
//count = m.Child.OrderSearch.OrderTotal;
totalCount = count;
//return m.Child.OrderSearch.OrderInfoList;
return("");
}
else
{
throw new Exception("错误代码：" + response.ErrCode + "错误信息：" + response.ErrMsg);
}
}
totalCount = count;
}
catch (Exception ex)
{
//throw new Exception(ex.Message);
//BusinessLogic.ErrorLog.RecordErrorLogs.WriteError(ex.Message.ToString(), CRMContext.Current.User.CustomerID.ToString());
totalCount = 0;
IoC.Resolve <IRecordErrorLogs>().WriteErrorLog("负责人:" + HozestERPContext.Current.User.CustomerID.ToString() + "; 方法名:GetOrderList; 异常提示：" + ex.Message.ToString() + "; InnerException:" + ex.InnerException);
}
return(null);
}
public async Task <IHttpActionResult> Search([FromUri] OrderSearchRequest request)
{
var response = await _orderService.Search(request);
return(new CreateResult(response));
}
public Task<ActionResult<IPaginationResult<Order>>> Search([FromQuery] OrderSearchRequest request)
{
return this._ordersService.Search(request).Convert<IPaginationResult<Order>>(this);
}
public Task <ActionResult <IEnumerable <OrderSummary> > > Get([FromQuery] OrderSearchRequest request)
{
return(this._ordersService.Summary(request).Convert <IEnumerable <OrderSummary> >(this));
}
