/// <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)); }