/// <summary> /// 查询支付订单 /// </summary> /// <param name="payId"></param> /// <returns></returns> public OrderBillPay GetBillPayById(Guid payId) { OrderBillPay billPay = null; try { string sql = @"select top 1 * from OrderBillPay where PayId = @PayId"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "PayId", DbType.Guid, payId); using (var reader = db.ExecuteReader(cmd)) { while (reader.Read()) { billPay = new OrderBillPay() { PayId = payId, Cash = reader.TryGetValue <Decimal>("Cash"), Change = reader.TryGetValue <Decimal>("Change"), Coupons = reader.TryGetValue <Decimal>("Coupons"), CouponsNo = reader.TryGetValue <String>("CouponsNo"), CreateDate = reader.TryGetValue <DateTime>("CreateDate"), CreditCard = reader.TryGetValue <Decimal>("CreditCard"), MemberCard = reader.TryGetValue <Decimal>("MemberCard"), MemberCardNo = reader.TryGetValue <String>("MemberCardNo"), PaidIn = reader.TryGetValue <Decimal>("PaidIn"), PayState = reader.TryGetValue <String>("PayState"), Receivable = reader.TryGetValue <Decimal>("Receivable"), Remark = reader.TryGetValue <String>("Remark"), Remove = reader.TryGetValue <Decimal>("Remove"), UserId = reader.TryGetValue <Guid>("UserId"), UserName = reader.TryGetValue <String>("UserName"), RstId = reader.TryGetValue <Guid>("RstId"), Discount = reader.TryGetValue <Decimal>("Discount") }; } } } catch (Exception ex) { Logger.Log(LoggingLevel.WxPay, ex); } return(billPay); }
/// <summary> /// 增加支付订单记录 /// </summary> /// <param name="billPay"></param> /// <returns></returns> public bool AddBillPay(OrderBillPay billPay) { bool result = false; try { DbCommand cmd = null; string sql = @" INSERT INTO [dbo].[OrderBillPay] ([PayId] ,[Receivable] ,[PaidIn] ,[Change] ,[Remove] ,[MemberCardNo] ,[Cash] ,[CreditCard] ,[MemberCard] ,[Coupons] ,[CouponsNo] ,[Remark] ,[PayState] ,[UserId] ,[UserName] ,[CreateDate] ,[Discount] ,[RstId]) VALUES ( @PayId ,@Receivable ,@PaidIn ,@Change ,@Remove ,@MemberCardNo ,@Cash ,@CreditCard ,@MemberCard ,@Coupons ,@CouponsNo ,@Remark ,@PayState ,@UserId ,@UserName ,@CreateDate ,@Discount ,@RstId );"; cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "PayId", DbType.Guid, billPay.PayId); db.AddInParameter(cmd, "Receivable", DbType.Decimal, billPay.Receivable); db.AddInParameter(cmd, "PaidIn", DbType.Decimal, billPay.PaidIn); db.AddInParameter(cmd, "Change", DbType.Decimal, billPay.Change); db.AddInParameter(cmd, "Remove", DbType.Decimal, billPay.Remove); db.AddInParameter(cmd, "MemberCardNo", DbType.String, billPay.MemberCardNo); db.AddInParameter(cmd, "Cash", DbType.Decimal, billPay.Cash); db.AddInParameter(cmd, "CreditCard", DbType.Decimal, billPay.CreditCard); db.AddInParameter(cmd, "MemberCard", DbType.Decimal, billPay.MemberCard); db.AddInParameter(cmd, "Coupons", DbType.Decimal, billPay.Coupons); db.AddInParameter(cmd, "CouponsNo", DbType.String, billPay.CouponsNo); db.AddInParameter(cmd, "Remark", DbType.String, billPay.Remark); db.AddInParameter(cmd, "PayState", DbType.String, billPay.PayState); db.AddInParameter(cmd, "UserId", DbType.Guid, billPay.UserId); db.AddInParameter(cmd, "UserName", DbType.String, billPay.UserName); db.AddInParameter(cmd, "CreateDate", DbType.DateTime, billPay.CreateDate); db.AddInParameter(cmd, "Discount", DbType.Decimal, billPay.Discount); db.AddInParameter(cmd, "RstId", DbType.Guid, billPay.RstId); result = ExecSql(cmd) > 0; } catch (Exception ex) { Logger.Log(LoggingLevel.WxPay, ex); } return(result); }