/// <summary> /// 拉取订单待发货订单 /// </summary> /// <returns></returns> public string List() { var result = new JsonResult(); string appid = HttpContext.Current.Request["appid"]; string sign = HttpContext.Current.Request["sign"]; string jsonData = HttpContext.Current.Request["jsonData"]; //验证秘钥 bool isPass = Security.SecurityCheck(appid, sign, jsonData); if (!isPass) { result.code = (int)OrderError.接口秘钥无效; result.message = OrderError.接口秘钥无效.ToString(); result.data = null; return(JsonHelper.GetJson(result)); } //序列化json PageForm pageFrom = JsonHelper.ConvertToObj <PageForm>(jsonData); string strWhere = string.Empty; strWhere += " CreateTime > '" + ConvertDataTimeHelper.ConvertLongDateTime(pageFrom.StartTime).ToString() + "'"; strWhere += " AND CreateTime < '" + ConvertDataTimeHelper.ConvertLongDateTime(pageFrom.EndTime).ToString() + "'"; int count = 0;//总条数 OperationResult <IList <OrdersInfo> > orderInfoList = OrderLogisticsSqlBLL.Instance.Orders_GetList(pageFrom.Page, pageFrom.Size, " CreateTime DESC ", strWhere, 0, out count); OperationResult <IList <OrderProductInfo> > orderProductInfoList = OrderLogisticsSqlBLL.Instance.OrderProduct_GetList(strWhere); //数据组合 IList <OrdersResponse> response = new List <OrdersResponse>(); foreach (var o in orderInfoList.AppendData) { OrdersResponse or = new OrdersResponse(); or.OrderID = o.OrderID; or.PaySum = o.PaySum; or.ProductFee = o.ProductFee; or.NewShipFee = o.NewShipFee; or.VoucherFee = o.VoucherFee; or.ShipMethodID = o.ShipMethodID; or.Province = o.Province; or.City = o.City; or.County = o.County; or.Address = o.Address; or.Receiver = o.Receiver; or.Telephone = o.Telephone; or.Mobile = o.Mobile; or.Invoice = o.Invoice; or.Remarks = o.Remarks; or.CreateTime = ConvertDataTimeHelper.ConvertDataTimeLong(o.CreateTime); or.OrderDetails = new List <OrderProductInfo>(); foreach (var op in orderProductInfoList.AppendData) { if (o.OrderID == op.OrderID) { OrderProductInfo opInfo = new OrderProductInfo(); opInfo.OrderID = op.OrderID; opInfo.ProductCode = op.ProductCode; opInfo.ProductID = op.ProductID; opInfo.ProductName = op.ProductName; opInfo.ProfeeDiscount = op.ProfeeDiscount; opInfo.Quantity = opInfo.Quantity; or.OrderDetails.Add(opInfo); } } response.Add(or); } //返回结果 if (orderInfoList.ResultType != OperationResultType.Success) { result.message = orderInfoList.Message; result.code = (int)OrderError.数据连接失败; result.data = null; } else { result.message = OrderError.数据返回成功.ToString(); result.code = (int)OrderError.数据返回成功; result.data = JsonHelper.GetJson(response); } return(JsonHelper.GetJson(result)); }
/// <summary> /// 金象隐形眼镜 自动设置订单已发货 /// </summary> /// <returns></returns> public string Shipping_Status() { var result = new JsonResult(); string appid = HttpContext.Current.Request["appid"]; string sign = HttpContext.Current.Request["sign"]; string jsonData = HttpContext.Current.Request["jsonData"]; //验证秘钥 bool isPass = Security.SecurityCheck(appid, sign, jsonData); if (!isPass) { result.code = (int)OrderError.接口秘钥无效; result.message = OrderError.接口秘钥无效.ToString(); result.data = null; return(JsonHelper.GetJson(result)); } //数据更新异常结果集 IList <string> errorOrderIDList = new List <string>(); //序列化json IList <ShippingInfo> spInfoList = JsonHelper.ConvertToObj <IList <ShippingInfo> >(jsonData); for (int i = 0; i < spInfoList.Count; i++) { //更新数据 DateTime createTime = ConvertDataTimeHelper.ConvertLongDateTime(spInfoList[i].Shipped_Time); OrderLogisticsInfo olInfo = new OrderLogisticsInfo() { OrderID = spInfoList[i].OrderID, ExpressID = Convert.ToInt32(spInfoList[i].Express_Id), LogisticsCompany = spInfoList[i].Express_Name, LogisticsNum = spInfoList[i].Express_Sn, UID = 0, Creator = spInfoList[i].Sender, CreateTime = createTime }; OperationResult <int> olResult = OrderLogisticsSqlBLL.Instance.OrderLogistics_Insert(olInfo); if (olResult.AppendData > 0) { int logisticsID = olResult.AppendData; OrdersInfo oInfo = new OrdersInfo() { OrderID = spInfoList[i].OrderID, }; olResult = OrderLogisticsSqlBLL.Instance.Order_Update(oInfo, "可得"); if (olResult.ResultType != OperationResultType.Success) { //没有更新成功 取消插入 OrderLogisticsSqlBLL.Instance.OrderLogistics_Delete(logisticsID); errorOrderIDList.Add(spInfoList[i].OrderID); continue; } } else { errorOrderIDList.Add(spInfoList[i].OrderID); continue; } } if (errorOrderIDList.Count() > 0) { result.data = JsonHelper.GetJson(errorOrderIDList); result.code = (int)OrderError.未知的订单号; result.message = OrderError.未知的订单号.ToString(); } else { result.code = (int)OrderError.数据返回成功; result.message = OrderError.数据返回成功.ToString(); result.data = null; } return(JsonHelper.GetJson(result)); }