/// <summary> /// 获取需要发送支付通知的订单 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="orderType"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public IEnumerable <OrderLists> SelectNeedSendOrder(DateTime startTime, DateTime endTime, string orderType) { List <OrderLists> result = new List <OrderLists>(); try { var data = dbScopeReadManager.Execute(conn => DALThirdReplaceOrder.SelectNeedSendOrder(conn, startTime, endTime, orderType)); var sendOrderList = dbTuhuLogScopeReadManager.Execute(conn => DALThirdReplaceOrder.SelectSendOrderPayNoticeOrderIds(conn)); if (data != null && data.Any()) { if (sendOrderList == null || !sendOrderList.Any()) { result = data; } else { data.ForEach(x => { if (sendOrderList.Where(y => y == x.PKID).Count() <= 0) { result.Add(x); } }); } } } catch (Exception ex) { logger.Error(ex); } return(result); }
/// <summary> /// 获取途虎订单的订单流水号 /// </summary> /// <param name="tuhuOrderId"></param> /// <returns></returns> public string SelectSerialNumByTuhuOrderId(long tuhuOrderId) { var result = string.Empty; try { result = dbScopeReadManager.Execute(conn => DALThirdReplaceOrder.SelectSerialNumByTuhuOrderId(conn, tuhuOrderId)); } catch (Exception ex) { logger.Error(ex); } return(result); }
/// <summary> /// 是否已经发送支付通知 /// </summary> /// <param name="tuhuOrderId"></param> /// <returns></returns> public bool IsSendOrderPayNotice(long tuhuOrderId) { var result = false; try { result = dbTuhuLogScopeReadManager.Execute(conn => DALThirdReplaceOrder.IsSendOrderPayNotice(conn, tuhuOrderId)) > 0; } catch (Exception ex) { logger.Error(ex); } return(result); }