/// <summary> /// 查询支付情况 /// </summary> /// <param name="quickPayment_Object"></param> /// <returns></returns> public TVMResult <TVMPayInfo> QueryPay(QuickPayment_Object quickPayment_Object) { var result = new TVMResult <TVMPayInfo> { ResultCode = 1, SysDate = DateTime.Now, Message = "查询失败" }; TVMPayInfo payInfo = quickPayment_Object.PayData; if (quickPayment_Object.PayData == null) { result.Message = "查询失败,信息丢失"; return(result); } var tbl_Order = _orderService.Get(payInfo.m_PayPassOrderID); if (tbl_Order == null) { result.Message = "订单不存在"; return(result); } result.ResultCode = 0; result.Message = "成功"; result.Data = payInfo; return(result); }
/// <summary> /// 查询支付情况 /// </summary> /// <param name="quickPayment_Object"></param> /// <returns></returns> public TVMResult <TVMPayInfo> QueryPay(QuickPayment_Object quickPayment_Object) { var result = new TVMResult <TVMPayInfo> { ResultCode = 1, SysDate = DateTime.Now, Message = "查询失败" }; TVMPayInfo payInfo = quickPayment_Object.PayData; if (quickPayment_Object.PayData == null) { result.Message = "查询失败,信息丢失"; return(result); } //确认支付是否成功,每隔一段时间查询一次订单,共查询5次--订单有效时间10秒 int queryTimes = 5;//查询次数计数器 while (queryTimes-- > 0) { var tbl_Order = _orderService.GetByAuthCode(payInfo.ScannerPayCode); if (tbl_Order == null) { Thread.Sleep(2000); continue; } result.ResultCode = 0; result.Message = "成功"; result.Data = new TVMPayInfo() { payResult = true, payType = tbl_Order.PayType.ToString(), PayMsg = "支付成功", return_trade_no = tbl_Order.PayTradeNo, m_PayPassOrderID = tbl_Order.OrderNo, merchantCode = quickPayment_Object.PayData.merchantCode, //商户id terminalNo = quickPayment_Object.PayData.terminalNo, //终端编号 TerminalType = quickPayment_Object.PayData.TerminalType, //终端类型 strPaymoney = tbl_Order.TotalAmount.ToString(), //支付金额 ScannerPayCode = quickPayment_Object.PayData.ScannerPayCode, //支付码 postOrder = quickPayment_Object.PayData.postOrder }; return(result); } result.Message = "订单不存在"; return(result); }
/// <summary> /// 销售门票请求票务详情 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TVMResult <List <SaleTicket_Result> > SaleTicket(QuickPayment_Object quickPayment_Object) { var result = new TVMResult <List <SaleTicket_Result> > { ResultCode = 1, SysDate = DateTime.Now, Message = "失败", Data = new List <SaleTicket_Result>() }; TVMPayInfo payInfo = quickPayment_Object.PayData; if (quickPayment_Object.PayData == null) { result.Message = "查询失败,信息丢失"; return(result); } var tbl_Order = _orderService.Get(payInfo.m_PayPassOrderID); if (tbl_Order == null) { result.Message = "订单不存在"; return(result); } var orderDetails = _orderDetailService.GetList(payInfo.m_PayPassOrderID); try { _orderService.BeginTran(); foreach (var row in orderDetails) { var tbl_OrderDetail = _orderDetailService.UpdatePrintTicketStatus(row.OrderDetailId); _noticeOrderConsumedService.Update(tbl_OrderDetail); } //提交事物 _orderService.CommitTran(); } catch { _orderService.RollbackTran(); } foreach (var row in orderDetails) { string code = SecurityExtension.DesEncrypt(row.QRcode, AppSettingsConfig.QrCodeKey); result.Data.Add(new SaleTicket_Result { OrderID = row.OrderNo, //订单详情id StrInvoiceCode = code, //交易号 TicketName = row.TicketName, TicketId = row.TicketId.ToString(), TypeName = "", StartDate = row.ValidityDateStart, EndDate = row.ValidityDateEnd, Price = Convert.ToDouble(row.Price), GeneralPrice = Convert.ToDouble(row.Price * row.Quantity), PeopleCount = row.Quantity, ENSBARCODE = code, //加密的条码 Sbarcode = row.CertificateNO, //凭证号 Remarks = "限当日有效" }); } result.ResultCode = 0; result.Message = "成功"; return(result); }
/// <summary> /// 创建订单并支付 /// </summary> /// <param name="quickPayment_Object"></param> /// <returns></returns> public TVMResult <TVMPayInfo> QuickPayment(QuickPayment_Object quickPayment_Object) { var result = new TVMResult <TVMPayInfo> { ResultCode = 1, SysDate = DateTime.Now, Message = "订单创建异常,订单创建失败" }; TVMPayInfo payInfo = quickPayment_Object.PayData; if (payInfo.postOrder.Count == 0) { result.Message = "未找到门票信息"; return(result); } if (string.IsNullOrEmpty(payInfo.ScannerPayCode)) { result.Message = "支付码未被扫描到,请联系管理员"; return(result); } int payType = 0;//道控支付类型 0:支付宝 1:微信 if (!int.TryParse(payInfo.payType, out payType) || payType < 0 || payType >= 2) { result.Message = "支付方式不明确,请联系管理员"; return(result); } payType = payType == 1 ? (int)PayStatus.Wechat : (int)PayStatus.Alipay; var orderInfo = new OrderInfoModel { Code = payInfo.ScannerPayCode, //支付码 PayType = payType, //支付类型 1:支付宝 2:微信 ValidityDate = DateTime.Now.Date, Mobile = "", Linkman = "", TicketCategory = (int)TicketCategoryStatus.QrCodePrintTicket, TicketSource = (int)TicketSourceStatus.ScenicSpot, TicketItem = new List <TicketItemModel>() }; foreach (var row in payInfo.postOrder) { orderInfo.TicketItem.Add(new TicketItemModel { TicketId = row.ProductID, BookCount = row.ProductCount }); } var tbl_Tickets = _ticketService.GetTickets(payInfo.postOrder.Select(a => a.ProductID).ToList()); var tbl_Order = _orderService.AddOrderForNoPay(orderInfo); var tbl_OrderDetails = _orderDetailService.AddOrderDetailForQrCodeNoPay(orderInfo, tbl_Order); _orderService.UpdateOrder(tbl_Order, tbl_OrderDetails); var tbl_Ticket_Testing = _ticketTestingService.addTicketTestings(tbl_Order, tbl_OrderDetails); _ticketService.UpdateTicketBySellCount(tbl_Tickets, tbl_OrderDetails); var tbl_SaleLog = _saleLogService.addSaleLog(tbl_Order); if (orderInfo.PayType == (int)PayStatus.Wechat) { var payResult = _wxPayGateway.OrderPay(tbl_Order.TicketName, tbl_Order.TotalAmount, payInfo.ScannerPayCode); if (!payResult.Success) { result.Message = payResult.Message; return(result); } tbl_Order.PayTradeNo = payResult.OutTradeNo; } else if (orderInfo.PayType == (int)PayStatus.Alipay) { var payResult = _alipayPayGateway.OrderPay(tbl_Order.TicketName, tbl_Order.TotalAmount.ToString(), payInfo.ScannerPayCode); if (!payResult.Success) { result.Message = payResult.Message; return(result); } tbl_Order.PayTradeNo = payResult.OutTradeNo; } try { using (SqlConnection connection = new SqlConnection(DbConfig.TicketConnectionString)) { connection.Open(); var trans = connection.BeginTransaction(); SqlBulkInsert.Inert(tbl_Order, connection, trans); SqlBulkInsert.Inert(tbl_OrderDetails, connection, trans); SqlBulkInsert.Inert(tbl_Ticket_Testing, connection, trans); _ticketService.UpdateTicket(tbl_Tickets, connection, trans); SqlBulkInsert.Inert(tbl_SaleLog, connection, trans); trans.Commit(); } result.ResultCode = 0; result.Message = "成功"; result.Data = new TVMPayInfo() { payResult = true, payType = tbl_Order.PayType.ToString(), PayMsg = "支付成功", return_trade_no = tbl_Order.PayTradeNo, m_PayPassOrderID = tbl_Order.OrderNo, merchantCode = quickPayment_Object.PayData.merchantCode, //商户id terminalNo = quickPayment_Object.PayData.terminalNo, //终端编号 TerminalType = quickPayment_Object.PayData.TerminalType, //终端类型 strPaymoney = tbl_Order.TotalAmount.ToString(), //支付金额 ScannerPayCode = quickPayment_Object.PayData.ScannerPayCode, //支付码 postOrder = quickPayment_Object.PayData.postOrder }; return(result); } catch (Exception ex) { if (orderInfo.PayType == (int)PayStatus.Wechat && !string.IsNullOrEmpty(tbl_Order.PayTradeNo)) { var isCancel = _wxPayGateway.Cancel(tbl_Order.PayTradeNo); if (!isCancel) { result.Message = "系统异常,订单创建失败,请联系景区人员进行退款!"; } } else if (orderInfo.PayType == (int)PayStatus.Alipay && !string.IsNullOrEmpty(tbl_Order.PayTradeNo)) { var isCancel = _alipayPayGateway.Cancel(tbl_Order.PayTradeNo, tbl_Order.TotalAmount.ToString()); if (!isCancel) { result.Message = "系统异常,订单创建失败,请联系景区人员进行退款!"; } } } return(result); }