/// <summary>
/// 添加访客及其评论
/// </summary>
/// <param name="PostId">帖子id</param>
/// <param name="UserName">访客姓名</param>
/// <param name="UserEmail">访客邮箱</param>
/// <param name="CommentMeta">评论内容</param>
/// <param name="UserIP">访客IP</param>
/// <returns>返回是否添加成功</returns>
public static bool AddComment(string PostId, string UserName, string UserEmail, string CommentMeta, string UserIP)
{
SqlParameter paramPostId = new SqlParameter();
paramPostId.ParameterName = "@PostId";
paramPostId.DbType = DbType.String;
paramPostId.Value = PostId;
SqlParameter paramUserName = new SqlParameter();
paramUserName.ParameterName = "@Username";
paramUserName.DbType = DbType.String;
paramUserName.Value = UserName;
SqlParameter paramUserEmail = new SqlParameter();
paramUserEmail.ParameterName = "@UserEmail";
paramUserEmail.DbType = DbType.String;
paramUserEmail.Value = UserEmail;
SqlParameter paramCommentMeta = new SqlParameter();
paramCommentMeta.ParameterName = "@Commentsmeta";
paramCommentMeta.DbType = DbType.String;
paramCommentMeta.Value = CommentMeta;
SqlParameter paramUserIP = new SqlParameter();
paramUserIP.ParameterName = "@UserIP";
paramUserIP.DbType = DbType.String;
paramUserIP.Value = UserIP;
return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Comment", paramPostId, paramUserName, paramUserEmail, paramCommentMeta, paramUserIP));
}
/// <summary>
/// 注册
/// </summary>
/// <param name="Admin">接收Admin类</param>
/// <returns>返回是否注册成功</returns>
public static bool Register(Admin_M Admin)
{
SqlParameter paramAdminName = new SqlParameter();
paramAdminName.ParameterName = "@AdminName";
paramAdminName.DbType = DbType.String;
paramAdminName.Value = Admin.Adminlogin;
SqlParameter paramAdminPwd = new SqlParameter();
paramAdminPwd.ParameterName = "@AdminPwd";
paramAdminPwd.DbType = DbType.String;
paramAdminPwd.Value = Admin.Adminpassword;
return(SQLDBHelper.ExecuteNonQuery("proc_Register", paramAdminName, paramAdminPwd));
}
/// <summary>
/// 增
/// </summary>
/// <param name="tax"></param>
/// <returns></returns>
public static bool addTax(Taxonomy_M tax)
{
SqlParameter paramTaxName = new SqlParameter();
paramTaxName.ParameterName = "@TaxonomyName";
paramTaxName.DbType = DbType.String;
paramTaxName.Value = tax.TaxonomyName;
SqlParameter paramTaxdesc = new SqlParameter();
paramTaxdesc.ParameterName = "@Taxonomydesc";
paramTaxdesc.DbType = DbType.String;
paramTaxdesc.Value = tax.Taxonomydesc;
return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Tax", paramTaxName, paramTaxdesc));
}
/// <summary>
/// 添加帖子
/// </summary>
/// <param name="post">接收类</param>
/// <returns>返回影响行数是否大于0</returns>
public static bool addPost(Posts_M post)
{
SqlParameter paramTaxID = new SqlParameter();
paramTaxID.ParameterName = "@TaxonomyId";
paramTaxID.DbType = DbType.String;
paramTaxID.Value = post.TaxonomyId;
SqlParameter paramTitle = new SqlParameter();
paramTitle.ParameterName = "@Title";
paramTitle.DbType = DbType.String;
paramTitle.Value = post.Title;
SqlParameter paramPost = new SqlParameter();
paramPost.ParameterName = "@Post";
paramPost.DbType = DbType.String;
paramPost.Value = post.Post;
return(SQLDBHelper.ExecuteNonQuery("proc_Insert_Post", paramTaxID, paramTitle, paramPost));
}
/// <summary>
/// 改
/// </summary>
/// <param name="tax"></param>
/// <returns></returns>
public static bool updateTax(Taxonomy_M tax)
{
SqlParameter paramTaxName = new SqlParameter();
paramTaxName.ParameterName = "@TaxonomyName";
paramTaxName.DbType = DbType.String;
paramTaxName.Value = tax.TaxonomyName;
SqlParameter paramTaxdesc = new SqlParameter();
paramTaxdesc.ParameterName = "@Taxonomydesc";
paramTaxdesc.DbType = DbType.String;
paramTaxdesc.Value = tax.Taxonomydesc;
SqlParameter paramTaxId = new SqlParameter();
paramTaxId.ParameterName = "@TaxonomyId";
paramTaxId.DbType = DbType.String;
paramTaxId.Value = tax.TaxonomyId;
return(SQLDBHelper.ExecuteNonQuery("proc_Update_Tax", paramTaxName, paramTaxdesc, paramTaxId));
}
/// <summary>
/// 删
/// </summary>
/// <param name="commentid">接收评论id</param>
/// <returns>返回是否删除成功</returns>
public static bool delcomment(string commentid)
{
string sql = "delete from Comments where CommentId=" + commentid;
return(SQLDBHelper.ExecuteNonQuery(sql));
}
/// <summary>
/// 根据帖子ID删除
/// </summary>
/// <param name="postID">接收帖子ID</param>
/// <returns>返回是否删除成功</returns>
public static bool delBypostId(string postID)
{
string sql = "delete from Posts where PostId=" + postID;
return(SQLDBHelper.ExecuteNonQuery(sql));
}
/// <summary>
/// 删
/// </summary>
/// <param name="taxId"></param>
/// <returns></returns>
public static bool delTax(string taxId)
{
string sql = "delete from Taxonomy where TaxonomyId=" + taxId;
return(SQLDBHelper.ExecuteNonQuery(sql));
}
