/// <summary>
/// 新增用户
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public bool Add(UserInfo userinfo)
{
userinfo.UserId = Guid.NewGuid().ToString();
//加密
userinfo.UserPassword = SHAEncrypt.SHA128(userinfo.UserPassword);
userinfo.CreateTime = DateTime.Now;
return dal.Add(userinfo);
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public bool Add(UserInfo userinfo)
{
IList<SqlParameter> arrParameter = new List<SqlParameter>();
arrParameter.Add(new SqlParameter { ParameterName = "@userid", Value = userinfo.UserId, DbType = DbType.String });
arrParameter.Add(new SqlParameter { ParameterName = "@username", Value = userinfo.UserName, DbType = DbType.String });
arrParameter.Add(new SqlParameter { ParameterName = "@password", Value = userinfo.UserPassword, DbType = DbType.String });
arrParameter.Add(new SqlParameter { ParameterName = "@createtime", Value = userinfo.CreateTime, DbType = DbType.DateTime });
return SqlHelper.ExecteNonQueryText("INSERT INTO UserInfo (user_id,user_name,user_password,create_time) VALUES(@userid,@username,@password,@createtime)", arrParameter.ToArray()) > 0;
}
/// <summary>
/// 设置用户缓存
/// </summary>
/// <param name="info">用户信息类</param>
/// <param name="Timeout">缓存时间</param>
public static void SetUserInfo(UserInfo info, TimeSpan Timeout)
{
//加密用户ID
string key = DESEncrypt.Encode(info.UserId);
//将加密数据保存到cookie中
CookieHelper.SetCookie("UserId", key);
//缓存用户信息20分钟
CacheHelper.SetCache(info.UserId, info, Timeout);
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public UserInfo Login(string username, string password)
{
IList<SqlParameter> arrParameter = new List<SqlParameter>();
arrParameter.Add(new SqlParameter { ParameterName = "@username", Value = username, DbType = DbType.String });
arrParameter.Add(new SqlParameter { ParameterName = "@userpassword", Value = password, DbType = DbType.String });
arrParameter.Add(new SqlParameter { ParameterName = "@result", DbType = DbType.Byte,Direction=ParameterDirection.Output });
DataTable dtResult = SqlHelper.ExecuteDataSetProducts("myblogs_loginAndQry", arrParameter.ToArray()).Tables[0];
//获取登录结果（1：成功，0：失败）
int resultCount = Functions.ToConvert<int>(arrParameter.FirstOrDefault(p => p.ParameterName == "@result").SqlValue.ToString());
if (resultCount == 1)
{
UserInfo info = new UserInfo
{
UserId = Functions.ToConvert<string>(dtResult.Rows[0]["user_id"]),
UserName = Functions.ToConvert<string>(dtResult.Rows[0]["user_name"]),
UserPassword = Functions.ToConvert<string>(dtResult.Rows[0]["user_password"]),
CreateTime = Functions.ToConvert<DateTime>(dtResult.Rows[0]["create_time"]),
LoginTime = Functions.ToConvert<DateTime>(dtResult.Rows[0]["login_time"])
};
return info;
}
return null;
}
public bool Add(UserInfo userinfo)
{
throw new NotImplementedException();
}
