/// <summary> /// 插入用户; /// </summary> /// <param name="user">用户</param> /// <returns>受影响行数</returns> public int Insert(User user) { int rowAffected = 0; try { rowAffected = DapperPgsqlHelper.GetScalarFromSp <int> ("usp_insert_user" , new { p_no = user.No, p_password = user.Password, p_is_activated = user.IsActivated, }); } catch (NotUniqueException) { throw new ApplicationException("您提交的用户号已存在"); } catch (Exception) { throw; } return(rowAffected); }
/// <summary> /// 更新用户; /// </summary> /// <param name="user">用户</param> /// <returns>受影响行数</returns> public int Update(User user) => DapperPgsqlHelper.GetScalarFromSp <int> ("usp_update_user" , new { p_no = user.No, p_password = user.Password, p_is_activated = user.IsActivated, p_login_fail_count = user.LoginFailCount });
/// <summary> /// 查询用户; /// </summary> /// <param name="user">用户号</param> /// <returns>用户</returns> public User Select(string userNo) { dynamic u = DapperPgsqlHelper.GetScalarFromSp <dynamic> ("usp_select_user" , new { p_no = userNo }); User user = null; if (u != null) { user = new User() { No = u.no, Password = u.password, IsActivated = u.is_activated, LoginFailCount = u.login_fail_count }; } return(user); }
/// <summary> /// 查询用户计数; /// </summary> /// <param name="userNo">用户号</param> /// <returns>计数</returns> public int SelectCount(string userNo) => DapperPgsqlHelper.GetScalarFromSp <int> ("usp_select_user_count" , new { p_no = userNo });