public bool DelModule(int ModuleId)
{
string sqlStr = "Delete from tbModule where ModuleId=@ModuleId";
SqlParameter[] param =
{
new SqlParameter("@ModuleId", ModuleId)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool CreateModule(Module module)
{
string sqlStr = "insert into tbModule(ModuleName,ModuleIntro,BuildDate) values(@ModuleName,@ModuleIntro,@BuildDate)";
SqlParameter[] param =
{
new SqlParameter("@ModuleName", module.ModuleName),
new SqlParameter("@ModuleIntro", module.ModuleIntro),
new SqlParameter("@BuildDate", module.BuildDate)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool UpdateModule(Module module)
{
string sqlStr = "Update tbModule set ModuleName=@ModuleName,ModuleIntro=@ModuleIntro where moduleId=@moduleId";
SqlParameter[] param =
{
new SqlParameter("@ModuleName", module.ModuleName),
new SqlParameter("@ModuleIntro", module.ModuleIntro),
new SqlParameter("@moduleId", module.ModuleID)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool UpdateReplay(Revert replay)
{
string sqlStr = "Update tbRevert set RevertTitle=@RevetTitle, RevertContent=@RevertContent where RervertId=@RevertId";
SqlParameter[] param =
{
new SqlParameter("@RevertTitle", replay.RevertTitle),
new SqlParameter("@RevertContent", replay.RevertContent),
new SqlParameter("@RevertId", replay.RevertID)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool DelReplay(int RevertId)
{
string sqlStr = "Delete from tbRevert where RevertId=@RevertId";
SqlParameter[] param =
{
new SqlParameter("@RevertId", RevertId)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateUser(User user)
{
string strSql = "update tbUser set userPswd=@userPassword,userSex=@userSex,userAge=@userAge,userEmail=@userEmail,userAddress=@userAddress,userRole=@userRole,userPhoto=@userPhoto where userID=@userId";
SqlParameter[] param =
{
new SqlParameter("@userId", user.UserID),
new SqlParameter("@userPassword", user.UserPswd),
new SqlParameter("@userSex", user.UserSex),
new SqlParameter("@userAge", user.UserAge),
new SqlParameter("@userEmail", user.UserEmail),
new SqlParameter("@userAddress", user.UserAddress),
new SqlParameter("@userRole", user.UserRole),
new SqlParameter("@userPhoto", user.UserPhoto)
};
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(strSql, param))
{
return(true);
}
else
{
return(false);
}
}
public bool CreateReplay(Revert replay)
{
string sqlStr = "insert into tbRevert(revertTitle,revertContent,revertDate,postID,userID) values(@RevertTitle,@RevertContent,@RevertDate,@postId,@userId)";
SqlParameter[] param =
{
new SqlParameter("@RevertTitle", replay.RevertTitle),
new SqlParameter("@RevertContent", replay.RevertContent),
new SqlParameter("@RevertDate", replay.RevertDate),
new SqlParameter("@postId", replay.PostID),
new SqlParameter("@userId", replay.UserID)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="user">用户Model</param>
/// <returns>bool型数据</returns>
public bool CreateUser(User user)
{
string strSql = "insert into tbUser(userName,userPswd,userSex,userAge,userEmail,userAddress,userRole,userPhoto) values(@userName,@userPassword,@userSex,@userAge,@userEmail,@userAddress,@userRole,@UserPhoto)";
SqlParameter[] param =
{
new SqlParameter("@userName", user.UserName),
new SqlParameter("@userPassword", user.UserPswd),
new SqlParameter("@userSex", user.UserSex),
new SqlParameter("@userAge", user.UserAge),
new SqlParameter("@userEmail", user.UserEmail),
new SqlParameter("@userAddress", user.UserAddress),
new SqlParameter("@userRole", user.UserRole),
new SqlParameter("@UserPhoto", user.UserPhoto),
};
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(strSql, param))
{
return(true);
}
else
{
return(false);
}
}
public bool DelPost(int postId)
{
string sqlStr = "Delete from tbPost where postId=@postId";
SqlParameter[] param =
{
new SqlParameter("@postId", postId)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool UpdatePost(Post post)
{
string sqlStr = "update tbPost set postTitle=@postTitle,postContent=@postContent where postId=@postId";
SqlParameter[] param =
{
new SqlParameter("@postTitle", post.PostTitle),
new SqlParameter("@postContent", post.PostContent),
new SqlParameter("@postId", post.PostID)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool CreatePost(Post post)
{
string sqlStr = "insert into tbPost(postTitle,postContent,postDate,userId,ModuleId) values(@postTitle,@postContent,@postDate,@userId,@ModuleId)";
SqlParameter[] param =
{
new SqlParameter("@postTitle", post.PostTitle),
new SqlParameter("@postContent", post.PostContent),
new SqlParameter("@postDate", post.PostDate),
new SqlParameter("@userId", post.UserID),
new SqlParameter("@ModuleId", post.ModuleID)
};
try
{
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(sqlStr, param))
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="userID">用户ID</param>
/// <returns></returns>
public bool DelUser(int userID)
{
string strSql = "delete from tbUser where userID=@userid";
SqlParameter[] param =
{
new SqlParameter("@userid", userID)
};
SQLHelper help = new SQLHelper();
if (help.ExecuteCommand(strSql, param))
{
return(true);
}
else
{
return(false);
}
}
