/// <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);
}
