/// <summary> /// 增加一条记录 /// <param name="businessWithdrawForm">参数实体</param> /// </summary> public long Insert(BusinessWithdrawForm businessWithdrawForm) { const string insertSql = @" insert into BusinessWithdrawForm(WithwardNo,BusinessId,BalancePrice,AllowWithdrawPrice,Status,Amount,Balance, TrueName,AccountNo,AccountType,BelongType,OpenBank,OpenSubBank) values(@WithwardNo,@BusinessId,@BalancePrice,@AllowWithdrawPrice,@Status,@Amount,@Balance, @TrueName,@AccountNo,@AccountType,@BelongType,@OpenBank,@OpenSubBank) select @@IDENTITY"; IDbParameters dbParameters = DbHelper.CreateDbParameters(); dbParameters.AddWithValue("WithwardNo", businessWithdrawForm.WithwardNo); //提现单号 dbParameters.AddWithValue("BusinessId", businessWithdrawForm.BusinessId); //商户ID(clienter表) dbParameters.AddWithValue("BalancePrice", businessWithdrawForm.BalancePrice); //提现前商户余额 dbParameters.AddWithValue("AllowWithdrawPrice", businessWithdrawForm.AllowWithdrawPrice); //提现前商户可提现金额 dbParameters.AddWithValue("Status", businessWithdrawForm.Status); //提现状态(1待审核 2 审核通过 3打款完成 -1审核拒绝 -2 打款失败) dbParameters.AddWithValue("Amount", businessWithdrawForm.Amount); //提现金额 dbParameters.AddWithValue("Balance", businessWithdrawForm.Balance); //提现后余额 dbParameters.AddWithValue("TrueName", businessWithdrawForm.TrueName); //商户收款户名 dbParameters.AddWithValue("AccountNo", businessWithdrawForm.AccountNo); //卡号(DES加密) dbParameters.AddWithValue("AccountType", businessWithdrawForm.AccountType); //账号类型:(1网银 2支付宝 3微信 4财付通 5百度钱包) dbParameters.AddWithValue("BelongType", businessWithdrawForm.BelongType); //账号类别 0 个人账户 1 公司账户 dbParameters.AddWithValue("OpenBank", businessWithdrawForm.OpenBank); //开户行 dbParameters.AddWithValue("OpenSubBank", businessWithdrawForm.OpenSubBank); //开户支行 object result = DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters); //提现单号 return(ParseHelper.ToLong(result)); }
/// <summary> /// 根据ID获取对象 /// <param name="id">id</param> /// </summary> public BusinessWithdrawForm GetById(long id) { BusinessWithdrawForm model = new BusinessWithdrawForm(); const string querysql = @" select Id,WithwardNo,BusinessId,BalancePrice,AllowWithdrawPrice,Status,Amount,Balance,WithdrawTime,Auditor,AuditTime,AuditFailedReason,Payer,PayTime,PayFailedReason from BusinessWithdrawForm (nolock) where Id=@Id "; IDbParameters dbParameters = DbHelper.CreateDbParameters(); dbParameters.AddWithValue("Id", id); DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql, dbParameters)); if (DataTableHelper.CheckDt(dt)) { model = DataTableHelper.ConvertDataTableList <BusinessWithdrawForm>(dt)[0]; } return(model); }
/// <summary> /// 更新一条记录 /// <param name="businessWithdrawForm">参数实体</param> /// </summary> public void Update(BusinessWithdrawForm businessWithdrawForm) { const string updateSql = @" update BusinessWithdrawForm set Status=@Status,Auditor=@Auditor,AuditTime=@AuditTime,AuditFailedReason=@AuditFailedReason,Payer=@Payer,PayTime=@PayTime,PayFailedReason=@PayFailedReason where Id=@Id "; IDbParameters dbParameters = DbHelper.CreateDbParameters(); dbParameters.AddWithValue("Id", businessWithdrawForm.Id); dbParameters.AddWithValue("Status", businessWithdrawForm.Status); dbParameters.AddWithValue("Auditor", businessWithdrawForm.Auditor); dbParameters.AddWithValue("AuditTime", businessWithdrawForm.AuditTime); dbParameters.AddWithValue("AuditFailedReason", businessWithdrawForm.AuditFailedReason); dbParameters.AddWithValue("Payer", businessWithdrawForm.Payer); dbParameters.AddWithValue("PayTime", businessWithdrawForm.PayTime); dbParameters.AddWithValue("PayFailedReason", businessWithdrawForm.PayFailedReason); DbHelper.ExecuteNonQuery(SuperMan_Write, updateSql, dbParameters); }