/// <summary>
/// 添加银行卡
/// </summary>
/// <returns></returns>
public bool AddBankCard(BankInfoResDto model)
{
var rows = Convert.ToInt32(SqlHelper.ExecuteScalar("select count(*) from bankinfo where UserId=@UserId",
new SqlParameter[] { new SqlParameter("@UserId", model.UserId) }));
string regsql = "";
if (rows > 0)
{
regsql = @"update bankinfo set BankAccount=@BankAccount,BankName=@BankName,SubTime=@SubTime,TrueName=@TrueName where UserId=@UserId";
}
else
{
regsql = @"insert into bankinfo (UserId,TrueName,BankAccount,BankName,SubTime)
values (@UserId,@TrueName,@BankAccount,@BankName,@SubTime)";
}
SqlParameter[] regsp = new SqlParameter[] {
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@TrueName", model.TrueName),
new SqlParameter("@BankAccount", model.BankAccount),
new SqlParameter("@BankName", model.BankName),
new SqlParameter("@SubTime", DateTime.Now)
};
var i = SqlHelper.ExecuteNonQuery(regsql, regsp);
return(i > 0);
}
public ApiResult <bool> AddBankCard(BankInfoResDto model)
{
var result = new ApiResult <bool>();
result.Data = _service.AddBankCard(model);
return(result);
}
