/// <summary> /// Adds a new user bank info. /// </summary> /// <param name="conn"></param> /// <param name="bankInfo"></param> /// <returns></returns> public bool AddUserBankInfo(SqlConnection conn, UserBankInfo bankInfo) { SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@UserId", bankInfo.UserId), new SqlParameter("@BankName", bankInfo.BankName ?? string.Empty), new SqlParameter("@BankAccount", bankInfo.BankAccount ?? string.Empty), new SqlParameter("@BankUserName", bankInfo.BankUserName ?? string.Empty), new SqlParameter("@BankAddress", bankInfo.BankAddress ?? string.Empty), new SqlParameter("@IsDefault", bankInfo.IsDefault), new SqlParameter("@CreatedTime", bankInfo.CreatedTime), new SqlParameter("@LastUpdatedTime", bankInfo.LastUpdatedTime) }; return DBHelper.RunScalarProcedure(conn, SP_AddUserBankInfo, sqlParameters) > 0; }
/// <summary> /// Adds a new user bank info. /// </summary> /// <param name="bankInfo"></param> /// <returns></returns> public bool AddUserBankInfo(UserBankInfo bankInfo) { var conn = DBHelper.GetSqlConnection(); bool result = false; try { conn.Open(); result = userDao.AddUserBankInfo(conn, bankInfo); } catch (Exception e) { LogService.Log("添加用户银行信息失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return result; }
private UserBankInfo ConvertToBankInfoObject(SqlDataReader reader) { UserBankInfo bankInfo = new UserBankInfo(); bankInfo.BankId = reader["BankId"].DBToInt32(); bankInfo.UserId = reader["UserId"].DBToInt32(); bankInfo.BankName = reader["BankName"].DBToString(); bankInfo.BankAccount = reader["BankAccount"].DBToString(); bankInfo.BankUserName = reader["BankUserName"].DBToString(); bankInfo.BankAddress = reader["BankAddress"].DBToString(); bankInfo.IsDefault = reader["IsDefault"].DBToBoolean(); bankInfo.CreatedTime = reader["CreatedTime"].DBToDateTime().Value; bankInfo.LastUpdatedTime = reader["LastUpdatedTime"].DBToDateTime().Value; return bankInfo; }
/// <summary> /// Gets user bank info by bank id. /// </summary> /// <param name="conn"></param> /// <param name="bankId"></param> /// <returns></returns> public UserBankInfo GetUserBankInfo(SqlConnection conn, int bankId) { UserBankInfo bankInfo = new UserBankInfo(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@BankId", bankId) }; SqlDataReader reader = DBHelper.RunProcedure(conn, SP_GetUserBankInfo, sqlParameters); while (reader.Read()) { bankInfo = ConvertToBankInfoObject(reader); } if (reader != null) { reader.Close(); } return bankInfo; }
/// <summary> /// Gets user bank info by bank id. /// </summary> /// <param name="bankId"></param> /// <returns></returns> public UserBankInfo GetUserBankInfo(int bankId) { var conn = DBHelper.GetSqlConnection(); UserBankInfo bankInfo = new UserBankInfo(); try { conn.Open(); bankInfo = userDao.GetUserBankInfo(conn, bankId); } catch (Exception e) { LogService.Log("获取用户银行信息失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return bankInfo; }
/// <summary> /// Validates bank info with get. We need to add a new bank record to database if user select new bank info. /// </summary> private UserBankInfo ValidateBankInfoWithGet(string bankid, string bankname, string bankaccount, string bankusername, string bankaddress, out bool isNewBankInfo) { UserBankInfo bankInfo = null; isNewBankInfo = false; if (bankid.Equals("-1") && UserInfo != null) { bankInfo = new UserBankInfo(); bankInfo.UserId = UserInfo.UserId; bankInfo.BankName = bankname ?? "信息缺失"; bankInfo.BankAccount = bankaccount ?? "信息缺失"; bankInfo.BankUserName = bankusername ?? "信息缺失"; bankInfo.BankAddress = bankaddress ?? "信息缺失"; bankInfo.CreatedTime = DateTime.Now; bankInfo.LastUpdatedTime = DateTime.Now; bankInfo.IsDefault = false; if (!userService.AddUserBankInfo(bankInfo)) { throw new ArgumentException("新增银行信息失败"); } else { isNewBankInfo = true; } } else { bankInfo = userService.GetUserBankInfo(int.Parse(bankid)); } bankInfo.CheckNullObject("银行信息"); return bankInfo; }