/// <summary>
/// 根据ID查找帖子
/// </summary>
/// <param name="PostID">获取PostID</param>
/// <returns>返回一个对象</returns>
public static Posts_M PostByID(string PostID)
{
Posts_M Post = new Posts_M();
string sql = "select * from Posts where PostId=" + PostID;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
dr.Read();
if (dr["PostId"] != DBNull.Value)
{
Post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
Post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
Post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
Post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
Post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
}
dr.Close();
return(Post);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["PostId"]))
{
Posts_M Post = Posts_B.PostByID(Request.QueryString["PostId"]);
Page.Title = Post.Title;
lblTitle.Text = Post.Title;
PostDesc.Text = Post.Post;
PublishTime.Text = Post.PublishTime.ToShortDateString();
int CategoryId = Post.TaxonomyId;
CategoryName.Text = Taxonomy_B.getTaxonomyByID(CategoryId.ToString()).TaxonomyName;
}
else
{
Response.Redirect("Index.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlcate.DataSource = Taxonomy_B.TaxList();
ddlcate.DataValueField = "TaxonomyId";
ddlcate.DataTextField = "TaxonomyName";
ddlcate.DataBind();
if (!string.IsNullOrWhiteSpace(Request.QueryString["postId"]))
{
Posts_M post = Posts_B.PostByID(Request.QueryString["postId"]);
txtTitle.Text = post.Title;
ddlcate.Text = post.TaxonomyId.ToString();
postdesc.Text = post.Post;
btnaddpost.Text = "修改";
}
}
}
protected void CommentList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
HiddenField UserId = e.Item.FindControl("UserId") as HiddenField;
Label userName = e.Item.FindControl("userName") as Label;
if (!string.IsNullOrWhiteSpace(UserId.Value))
{
Users_M user = Users_B.UserByID(UserId.Value);
userName.Text = user.Username;
}
HiddenField PostId = e.Item.FindControl("PostId") as HiddenField;
Label PostTitle = e.Item.FindControl("PostTitle") as Label;
if (!string.IsNullOrWhiteSpace(PostId.Value))
{
Posts_M post = Posts_B.PostByID(PostId.Value);
PostTitle.Text = post.Title;
}
}
/// <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="pageSize">页数大小</param>
/// <param name="pageIndex">页码</param>
/// <returns>返回集合</returns>
public static List <Posts_M> PostListPager(string pageSize, string pageIndex)
{
List <Posts_M> list = new List <Posts_M>();
string sql = string.Format("select top ({0}) *from Posts where PostId not in (select top (({1}-1)*{0}) PostId from Posts order by PostId) order by PostId", pageSize, pageIndex);
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Posts_M post = new Posts_M();
if (dr["PostId"] != DBNull.Value)
{
post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
list.Add(post);
}
}
dr.Close();
return(list);
}
/// <summary>
/// 通过类型ID查找帖子集合
/// </summary>
/// <param name="TaxID">获取类型ID</param>
/// <returns>返回集合</returns>
public static List <Posts_M> PostListByTaxID(string TaxID)
{
List <Posts_M> list = new List <Posts_M>();
string sql = "select * from Posts where TaxonomyId =" + TaxID;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
Posts_M post = new Posts_M();
if (dr["PostId"] != DBNull.Value)
{
post.PostId = Convert.ToInt32(dr["PostId"]);
}
if (dr["TaxonomyId"] != DBNull.Value)
{
post.TaxonomyId = Convert.ToInt32(dr["TaxonomyId"]);
}
if (dr["Title"] != DBNull.Value)
{
post.Title = Convert.ToString(dr["Title"]);
}
if (dr["Post"] != DBNull.Value)
{
post.Post = Convert.ToString(dr["Post"]);
}
if (dr["PublishTime"] != DBNull.Value)
{
post.PublishTime = Convert.ToDateTime(dr["PublishTime"]);
}
list.Add(post);
}
}
dr.Close();
return(list);
}
protected void btnaddpost_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["postId"]))
{
Posts_M post = new Posts_M();
post.PostId = Convert.ToInt32(Request.QueryString["postId"]);
post.Title = txtTitle.Text;
post.TaxonomyId = Convert.ToInt32(ddlcate.Text);
post.Post = postdesc.Text;
if (Posts_B.updatePost(post))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改成功');location.href='AdminPost.aspx';</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改失败');</script>");
}
}
else
{
Posts_M post = new Posts_M();
post.Title = txtTitle.Text;
post.TaxonomyId = Convert.ToInt32(ddlcate.Text);
post.Post = postdesc.Text;
if (Posts_B.addPost(post))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加成功');</script>");
txtTitle.Text = "";
postdesc.Text = "";
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加失败');</script>");
}
}
}
/// <summary>
/// 修改帖子
/// </summary>
/// <param name="post">接收类</param>
/// <returns>返回影响行数是否大于0</returns>
public static bool updatePost(Posts_M post)
{
return(Posts_D.updatePost(post));
}
/// <summary>
/// 添加帖子
/// </summary>
/// <param name="post">接收类</param>
/// <returns>返回影响行数是否大于0</returns>
public static bool addPost(Posts_M post)
{
return(Posts_D.addPost(post));
}
