/// <summary>
/// 添加UserActivateTokenInfo
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static long AddUserActivateToken(UserActivateTokenInfo useractivatetoken)
{
string sql = @"INSERT INTO [UserActivateToken]
([UserId],[Email],[Token])
VALUES
(@UserId,@Email,@Token)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", useractivatetoken.UserId, DbType.Int32);
par.Add("@Email", useractivatetoken.Email, DbType.AnsiString);
par.Add("@Token", useractivatetoken.Token, DbType.AnsiString);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// DataModel 转 ViewModel
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static UserActivateTokenVModel UserActivateTokenInfoToVModel(UserActivateTokenInfo useractivatetoken)
{
if (useractivatetoken == null)
{
return(new UserActivateTokenVModel());
}
return(new UserActivateTokenVModel
{
Id = useractivatetoken.Id,
UserId = useractivatetoken.UserId,
Email = useractivatetoken.Email,
Token = useractivatetoken.Token,
Status = useractivatetoken.Status,
CreateTime = useractivatetoken.CreateTime
});
}
/// <summary>
/// 修改UserActivateTokenInfo
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static int UpdateUserActivateToken(UserActivateTokenInfo useractivatetoken)
{
string sql = @"UPDATE [UserActivateToken] SET
UserId=@UserId,
Email=@Email,
Token=@Token,
Status=@Status,
CreateTime=@CreateTime
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", useractivatetoken.Id, DbType.Int64);
par.Add("@UserId", useractivatetoken.UserId, DbType.Int32);
par.Add("@Email", useractivatetoken.Email, DbType.AnsiString);
par.Add("@Token", useractivatetoken.Token, DbType.AnsiString);
par.Add("@Status", useractivatetoken.Status, DbType.Boolean);
par.Add("@CreateTime", useractivatetoken.CreateTime, DbType.DateTime);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 修改UserActivateTokenInfo
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static int UpdateUserActivateToken(UserActivateTokenInfo useractivatetoken)
{
return(DataProvider.UserActivateTokens.UpdateUserActivateToken(useractivatetoken));
}
/// <summary>
/// 添加UserActivateTokenInfo
/// </summary>
/// <param name="useractivatetoken"></param>
/// <returns></returns>
public static long AddUserActivateToken(UserActivateTokenInfo useractivatetoken)
{
return(DataProvider.UserActivateTokens.AddUserActivateToken(useractivatetoken));
}
