/// <summary>
/// 设置状态为赋予的状态值1离线
/// </summary>
/// <param name="id"></param>
/// <param name="stateCode"></param>
public static User ModifyStatus(int id, int stateCode)
{
const string sql = "UPDATE Users SET UserStateId = @UserStateId WHERE Id = @Id";
SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@Id", id),
new SqlParameter("@UserStateId", stateCode)
});
return(GetUserById(id));
}
/// <summary>
/// 设置默认状态(离线)
/// </summary>
/// <param name="id"></param>
public static void ModifyStatus(int id)
{
const string sql = "UPDATE Users SET UserStateId = @UserStateId WHERE Id = @id";
const int STATUSCODE_OFFLINE = 1; //离线
SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@Id", id),
new SqlParameter("@UserStateId", STATUSCODE_OFFLINE)
});
}
public static DateTime ModifyUserOnlineTime(int id)
{
const string sql = "UPDATE Users SET LastOnlineTime = @LastOnlineTime WHERE Id = @Id";
DateTime dtNow = DateTime.Now;
SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@LastOnlineTime", dtNow),
new SqlParameter("@Id", id)
});
return(dtNow);
}
public static int ModifyBaseInfo(string MBId, string title, string content, string linkURL, int categroiesId)
{
const string sql = "UPDATE UserMessageBoard SET Title = @title,Article = @article,URL = @url,CategoriesId = @categroiesId WHERE MessageBoardId = @MBId";
return(SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@title", title),
new SqlParameter("@article", content),
new SqlParameter("@url", linkURL),
new SqlParameter("@categroiesId", categroiesId),
new SqlParameter("@MBId", MBId),
}));
}
public static User ModifyFactory(string sql, int id, SqlParameter[] parameter)
{
int i = SqlDBHelper.ExecuteCommand(sql, parameter);
if (i > 0)
{
return(GetUserById(id));
}
else
{
return(null);
}
}
/// <summary>
/// 修改基本信息
/// </summary>
/// <param name="id"></param>
/// <param name="address">地址</param>
/// <param name="phone">手机号码</param>
/// <param name="perSanlSynopsis">个人简介</param>
/// <param name="mail">邮箱</param>
/// <param name="name">姓名</param>
/// <param name="role">角色</param>
/// <returns></returns>
public static int ModifyBaseInfo(int id, string address, string phone, string perSanlSynopsis, string mail, string name, int role)
{
const string sql = "UPDATE Users SET Address = @address,Phone = @phone,Name = @name,Mail = @mail,PersonalSynopsis = @personalSynopsis,UserRoleId = @role WHERE Id = @id";
return(SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@role", role),
new SqlParameter("@address", address),
new SqlParameter("@phone", phone),
new SqlParameter("@personalSynopsis", perSanlSynopsis),
new SqlParameter("@mail", mail),
new SqlParameter("@name", name),
new SqlParameter("@id", id)
}));
}
public static bool ModifyUser(int id, string loginPwd)
{
const string sql = "UPDATE Users SET LoginPwd = @LoginPwd WHERE Id = @id";
int i = SqlDBHelper.ExecuteCommand(sql, new SqlParameter[] {
new SqlParameter("@LoginPwd", loginPwd),
new SqlParameter("@Id", id)
});
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加留言
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="title">标题</param>
/// <param name="article">内容</param>
/// <param name="url">链接</param>
/// <param name="comTime">发表时间</param>
/// <param name="categoriesId">分类ID</param>
/// <returns></returns>
public static bool AddUserMessageBoard(int userId, string title, string article, string url, DateTime comTime, int categoriesId)
{
const string sql = "INSERT INTO [dbo].[UserMessageBoard]([Id] ,[Title],[Article],[URL],[ComTime],[CategoriesId]) VALUES (@userId,@title,@article,@url,@comTime,@categoriesId)";
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@userId", userId),
new SqlParameter("@title", title),
new SqlParameter("@article", article),
new SqlParameter("@url", url),
new SqlParameter("@comTime", comTime),
new SqlParameter("@categoriesId", categoriesId)
};
if (SqlDBHelper.ExecuteCommand(sql, parameter) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static int DeleteMessageBoardByID(string id)
{
string sql = "DELETE FROM [UserMessageBoard] WHERE MessageBoardId = '" + id + "'";
return(SqlDBHelper.ExecuteCommand(sql));
}
public static int DelUserById(int id)
{
string sql = "DELETE FROM [dbo].[Users] WHERE [Id] = " + id;
return(SqlDBHelper.ExecuteCommand(sql));
}
