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