/// <summary> /// 支付信息状态更新 /// </summary> /// <param name="id">支付信息Id</param> /// <param name="no">支付平台交易号 支付宝 财富通等 支付成功后更新该字段</param> /// <param name="status">支付状态</param> /// <returns></returns> public bool PaymentStatusUpdate(string id, string no, bool status) { return(Try(nameof(PaymentStatusUpdate), () => { var sql = @"update Payment set no=@no,status=@status where id=@id"; return WalletConn.Execute(sql, new { id, no, status }) > 0; })); }
///<summary> /// 支付信息创建 ///</summary> ///<param name="o">支付信息</param> ///<returns></returns> public bool PaymentCreate(Payment o) { return(Try(nameof(PaymentCreate), () => { var cmd = SqlBuilder.Insert("Payment") .Column("Id", o.Id) .Column("No", o.No) .Column("Type", o.Type) .Column("UserId", o.UserId) .Column("Method", o.Method) .Column("Amount", o.Amount) .Column("Subject", o.Subject) .Column("Message", o.Message) .Column("RawData", o.RawData) .Column("BankId", o.BankId) .Column("BankCode", o.BankCode) .Column("BankName", o.BankName) .Column("BankCard", o.BankCard) .Column("PlatformId", o.PlatformId) .Column("CardNo", o.CardNo) .Column("CardPwd", o.CardPwd) .Column("CardAmount", o.CardAmount) .Column("RelatedId", o.RelatedId) .Column("IpAddress", o.IpAddress) .Column("Extra", o.Extra) .Column("Status", o.Status) .Column("CreatedBy", o.CreatedBy) .Column("CreatedOn", o.CreatedOn) .Column("ModifiedBy", o.ModifiedBy) .Column("ModifiedOn", o.ModifiedOn) .ToCommand(); return WalletConn.Execute(cmd) > 0; /* * var status = WalletConn.Execute(cmd) > 0; * if (status) * { * OnCreated("payment-created", o); * } * return status; */ })); }