public static ReturnorderConfirmResponse InitRequest() { string url = "http://qimenapi.tbsandbox.com/router/qimen/service"; string appkey = "1023883919"; string secret = "sandboxff0b11ecc626508c171a5b2a2"; //string customerId = "c1498112555030"; string customerId = "c1498448349079"; IQimenClient client = new DefaultQimenClient(url, appkey, secret); ReturnorderConfirmRequest req = new ReturnorderConfirmRequest(); req.CustomerId = customerId; req.Version = "2.0"; ReturnorderConfirmRequest.ReturnOrderDomain returnOrder = new ReturnorderConfirmRequest.ReturnOrderDomain(); ReturnorderConfirmRequest.OrderLineDomain orderLine = new ReturnorderConfirmRequest.OrderLineDomain(); List <ReturnorderConfirmRequest.OrderLineDomain> orderLines = new List <ReturnorderConfirmRequest.OrderLineDomain>(); returnOrder.ReturnOrderCode = "RK1707040006"; returnOrder.WarehouseCode = "LK01"; returnOrder.LogisticsCode = ""; orderLine.OwnerCode = "ZK"; orderLine.ItemCode = "1006-1003"; orderLine.ActualQty = "1"; orderLine.PlanQty = 1; orderLines.Add(orderLine); req.ReturnOrder = returnOrder; req.OrderLines = orderLines; return(client.Execute(req)); }
public void Execute(IJobExecutionContext context) { string url = ConfigurationManager.AppSettings["URL"].ToString(); string appkey = ConfigurationManager.AppSettings["APPKEY"].ToString(); //"1023883919"; 23883919 string secret = ConfigurationManager.AppSettings["SECRET"].ToString(); //"sandboxff0b11ecc626508c171a5b2a2"; string customeId = ConfigurationManager.AppSettings["CUSTOMEID"].ToString(); string v = ConfigurationManager.AppSettings["v"].ToString(); string[] customerArr = customeId.Split(','); try { _logger.Info("ReturnorderConfirm 开始执行... " + DateTime.Now + ""); foreach (var cId in customerArr) { using (SCVDBContainer dbContext0 = new SCVDBContainer()) using (DBContainer dbContext1 = new DBContainer()) { DbSet <RECEIPT_HEADER> header = dbContext0.Set <RECEIPT_HEADER>(); DbSet <RECEIPT_DETAIL> detail = dbContext0.Set <RECEIPT_DETAIL>(); //DbSet<QiMen_PushTimeStatus> dbSet0 = dbContext1.Set<QiMen_PushTimeStatus>(); DbSet <QiMen_PushLog> dbSet1 = dbContext1.Set <QiMen_PushLog>(); IQimenClient client = new DefaultQimenClient(url, appkey, secret); ReturnorderConfirmRequest req = new ReturnorderConfirmRequest(); //DateTime lastTime; //QiMen_PushTimeStatus qmt = dbSet0.Where(q => q.CustomerId == cId && q.OrderType == RECEIPT && q.Interface == INTERFACE).FirstOrDefault(); //if (qmt == null) //{ // qmt = new QiMen_PushTimeStatus() { CustomerId = cId, ActualArriveTime = DateTime.Now, OrderType = RECEIPT, Interface = INTERFACE }; // dbSet0.Add(qmt); // lastTime = DateTime.Now.AddMinutes(-1); //} //else //{ // lastTime = ((DateTime)qmt.ActualArriveTime).AddMinutes(-1); //} //var confirmlList = header.Where(h => h.COMPANY == cId && h.TRAILING_STS == 900 && (h.RECEIPT_TYPE).Equals("THRK",StringComparison.OrdinalIgnoreCase) && h.CLOSE_DATE >= lastTime).Include(r => r.RECEIPT_DETAIL).OrderByDescending(h => h.CLOSE_DATE).ToList(); var confirmlList = header.Where(h => h.COMPANY == cId && h.CREATE_USER == "ReturnorderCreate" && (h.USER_DEF8 == null || h.USER_DEF8 == QimenPushStatus.Failure.ToString() || h.USER_DEF8 == "1" || h.USER_DEF8 == "2" || h.USER_DEF8 == "3" || h.USER_DEF8 == "4" || h.USER_DEF8 == "5") && (h.TRAILING_STS == 800 || h.TRAILING_STS == 850 || h.TRAILING_STS == 900) && h.RECEIPT_TYPE.Equals("THRK", StringComparison.OrdinalIgnoreCase) ).Include(s => s.RECEIPT_DETAIL).ToList(); if (cId == "XGQQG") { confirmlList.Clear(); } //if (cId == "CQHGE") //{ // confirmlList = confirmlList.Where(l => l.CREATE_USER == "ReturnorderCreate").ToList(); //} if (cId == "CH") { req.CustomerId = "CH1"; } else { req.CustomerId = cId; } req.Version = v; req.Timestamp = DateTime.Now; //bool pushFlag = true; foreach (var itemHeader in confirmlList) { ReturnorderConfirmRequest.ReturnOrderDomain returnOrder = new ReturnorderConfirmRequest.ReturnOrderDomain(); returnOrder.ReturnOrderCode = itemHeader.RECEIPT_ID; //"R1234";//item.ERP_ORDER_ID; returnOrder.WarehouseCode = itemHeader.WAREHOUSE; returnOrder.LogisticsCode = ""; //"SF";//item.CARRER; returnOrder.OutBizCode = itemHeader.INTERNAL_RECEIPT_NUM.ToString(); returnOrder.OrderType = itemHeader.RECEIPT_TYPE; ReturnorderConfirmRequest.SenderInfoDomain senderInfo = new ReturnorderConfirmRequest.SenderInfoDomain(); senderInfo.Name = itemHeader.SHIP_FROM_NAME; //"老王";// senderInfo.Mobile = itemHeader.SHIP_FROM_PHONE_NUM; //"13214567869";// senderInfo.Province = itemHeader.SHIP_FROM_COUNTRY; //"浙江省";// senderInfo.City = itemHeader.SHIP_FROM_CITY; //"杭州"; // senderInfo.DetailAddress = itemHeader.SHIP_FROM_ADDRESS1 != null ? itemHeader.SHIP_FROM_ADDRESS1 : itemHeader.SHIP_FROM_ADDRESS2; //"杭州市余杭区989号";// returnOrder.SenderInfo = senderInfo; req.ReturnOrder = returnOrder; List <ReturnorderConfirmRequest.OrderLineDomain> orderLineList = new List <ReturnorderConfirmRequest.OrderLineDomain>(); foreach (var itemDetail in itemHeader.RECEIPT_DETAIL) { ReturnorderConfirmRequest.OrderLineDomain orderLine = new ReturnorderConfirmRequest.OrderLineDomain(); orderLine.ItemId = itemDetail.INTERNAL_RECEIPT_LINE_NUM.ToString(); orderLine.ItemName = itemDetail.ITEM_DESC; orderLine.OwnerCode = itemDetail.COMPANY; orderLine.ItemCode = itemDetail.ITEM; orderLine.PlanQty = (long)itemDetail.TOTAL_QTY; orderLine.ActualQty = (itemDetail.TOTAL_QTY - itemDetail.OPEN_QTY).ToString(); orderLine.OutBizCode = itemDetail.INTERNAL_RECEIPT_LINE_NUM.ToString(); orderLineList.Add(orderLine); } req.OrderLines = orderLineList; var rsp = client.Execute(req); QiMen_PushLog log = new QiMen_PushLog(); log.InternalOrderID = itemHeader.INTERNAL_RECEIPT_NUM; log.OrderType = INTERFACE; log.CustomerId = cId; log.Flag = rsp.Flag; log.Message = rsp.Message; log.CreateTime = DateTime.Now; dbSet1.Add(log); if (rsp.Flag == "success") { itemHeader.USER_DEF8 = QimenPushStatus.Success.ToString(); _logger.Info("入库单:" + itemHeader.RECEIPT_ID + "确认成功----" + DateTime.Now); } else { if (string.IsNullOrEmpty(itemHeader.USER_DEF8)) { itemHeader.USER_DEF8 = "1"; } else { int parseResult; if (int.TryParse(itemHeader.USER_DEF8, out parseResult)) { itemHeader.USER_DEF8 = (parseResult + 1).ToString(); } } //if (rsp.Message.Length > 50) //{ // pushFlag = false; //} _logger.Info("入库单:" + itemHeader.RECEIPT_ID + "确认失败:-" + rsp.Message + DateTime.Now); } } //if (confirmlList.Count > 0 && pushFlag) //{ // qmt.ActualArriveTime = (DateTime)confirmlList.First().CLOSE_DATE; //} dbContext0.SaveChanges(); dbContext1.SaveChanges(); } } _logger.Info("ReturnorderConfirm 执行完成... " + DateTime.Now + ""); } catch (Exception ex) { _logger.Error("ReturnorderConfirm 异常..." + DateTime.Now + " " + ex.Message); } }
/// <summary> /// 退货入库单确认 /// </summary> public bool ReturnorderConfirm() { log.Info("----------------启用定时任务:退货入库单确认" + DateTime.Now.Hour + "--------------"); try { dbContext = new SCVDBContainer(); DbSet <RECEIPT_HEADER> dbset0 = dbContext.Set <RECEIPT_HEADER>(); DbSet <RECEIPT_DETAIL> dbset1 = dbContext.Set <RECEIPT_DETAIL>(); DbSet <RECEIPT_HEADER_TEMP> dbset_Temp = dbContext.Set <RECEIPT_HEADER_TEMP>(); IQimenClient client = new DefaultQimenClient(url, appkey, secret); ReturnorderConfirmRequest req = new ReturnorderConfirmRequest(); ReturnorderConfirmResponse rsp = new ReturnorderConfirmResponse(); //退货单信息 ReturnorderConfirmRequest.ReturnOrderDomain obj1 = new ReturnorderConfirmRequest.ReturnOrderDomain(); //发件人信息 ReturnorderConfirmRequest.SenderInfoDomain send = new ReturnorderConfirmRequest.SenderInfoDomain(); //订单信息 ReturnorderConfirmRequest.OrderLineDomain orderLine = new ReturnorderConfirmRequest.OrderLineDomain(); List <ReturnorderConfirmRequest.OrderLineDomain> orderLineList = new List <ReturnorderConfirmRequest.OrderLineDomain>(); for (int i = 0; i < customerArr.Length; i++) { var confirmlList = dbset0 .Where(t => t.TRAILING_STS.ToString() == "900" && ( t.RECEIPT_TYPE.Contains("THRK") || t.RECEIPT_TYPE.Contains("HHRK") ) && t.COMPANY == customeId) .OrderByDescending(t => t.INTERNAL_RECEIPT_NUM) .Take(100).AsNoTracking().ToList(); var confirmTempList = dbset_Temp .Where(t => t.TRAILING_STS.ToString() == "900" && ( t.RECEIPT_TYPE.Contains("THRK") || t.RECEIPT_TYPE.Contains("HHRK") ) && t.COMPANY == customeId) .OrderByDescending(t => t.INTERNAL_RECEIPT_NUM) .Take(100).AsNoTracking().ToList(); List <RECEIPT_HEADER_TEMP> tempList = new List <RECEIPT_HEADER_TEMP>(); List <RECEIPT_DETAIL> detailList = new List <RECEIPT_DETAIL>(); //排除已确认的数据,并且一次性只处理100个订单 confirmlList = confirmlList .Where(a => !confirmTempList.Exists(t => a.INTERNAL_RECEIPT_NUM == t.INTERNAL_RECEIPT_NUM)) .OrderByDescending(t => t.INTERNAL_RECEIPT_NUM).ToList(); req.CustomerId = customerArr[i].Trim(); req.Version = v; req.Timestamp = DateTime.Now; if (confirmlList.Count == 0) { log.Info("客户:" + req.CustomerId + " " + "需确认的退货入库单为空,不需要确认!!!"); continue; } foreach (var item in confirmlList) { detailList = dbset1.Where(t => t.INTERNAL_RECEIPT_NUM == item.INTERNAL_RECEIPT_NUM).ToList(); obj1.ReturnOrderCode = item.RECEIPT_ID; //"R1234";//item.ERP_ORDER_ID; obj1.WarehouseCode = item.WAREHOUSE; obj1.LogisticsCode = "SF"; //"SF";//item.CARRER; obj1.OutBizCode = Guid.NewGuid().ToString(); send.Name = item.SHIP_FROM_NAME; //"老王";// send.Mobile = item.SHIP_FROM_PHONE_NUM; //"13214567869";// send.Province = item.SHIP_FROM_COUNTRY; //"浙江省";// send.City = item.SHIP_FROM_CITY; //"杭州"; // send.DetailAddress = item.SHIP_FROM_ADDRESS1 != null ? item.SHIP_FROM_ADDRESS1 : item.SHIP_FROM_ADDRESS2; //"杭州市余杭区989号";// obj1.SenderInfo = send; foreach (var itemChildren in detailList) { orderLine.OwnerCode = itemChildren.COMPANY; orderLine.ItemCode = itemChildren.ITEM; orderLine.PlanQty = (long)itemChildren.OPEN_QTY;//12L;// orderLine.ActualQty = itemChildren.TOTAL_QTY.ToString(); orderLineList.Add(orderLine); } req.ReturnOrder = obj1; req.OrderLines = orderLineList; try { rsp = client.Execute(req); log.Info(" " + "退货入库确认--订单号:" + item.INTERNAL_RECEIPT_NUM + " " + "确认结果:" + rsp.Flag + " " + "消息:" + rsp.Message); } catch (Exception ex) { log.Error("Error", ex); continue; } if (rsp.Flag == "success") { DbSet <RECEIPT_HEADER_TEMP> header = dbContext.Set <RECEIPT_HEADER_TEMP>(); RECEIPT_HEADER_TEMP headerTemp = new RECEIPT_HEADER_TEMP() { INTERNAL_RECEIPT_NUM = item.INTERNAL_RECEIPT_NUM, DATE_TIME_STAMP = DateTime.Now, RECEIPT_ID = item.RECEIPT_ID, WAREHOUSE = item.WAREHOUSE, RECEIPT_TYPE = item.RECEIPT_TYPE, TRAILING_STS = item.TRAILING_STS, LEADING_STS = item.LEADING_STS, FLAG = rsp.Flag, CODE = rsp.Code, MESSAGE = rsp.Message }; header.Add(headerTemp); } } dbContext.SaveChanges(); } return(true); } catch (Exception ex) { log.Error("Error", ex); return(false); } }