//将一条数据转化为Post-model数据
//帖子的第一张图片，内容的前200个字符
public Post_model ToPictureModel(DataRow row)
{
Post_model post_model = new Post_model();
post_model.postContent = row["content"].ToString(); //内容
post_model.firstPostPhotoUrl = row["PostPhoto_PhotoUrl"].ToString(); //图
post_model.postId = (int)row["id"];
return(post_model);
}
/// <summary>
/// 将一条数据转化为Post_model数据
/// 原贴帖子id 标题 内容的前200字符 帖子的第一张图片 日期
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public Post_model ToShortModel(DataRow row)
{
Post_model post_model = new Post_model();
post_model.postId = (int)row["id"];
post_model.postCaption = row["caption"].ToString();
post_model.postContent = row["content"].ToString();
post_model.firstPostPhotoUrl = row["photoUrl"].ToString();
post_model.postDate = (DateTime)row["datetime"];
return(post_model);
}
/// <summary>
/// 获取帖子编号为postId的数据,一条数据
/// </summary>
/// <param name="postId">帖子编号</param>
/// <returns></returns>
public Post_model GetOnePost(int postId)
{
string sqlStr = "select * from PostView where id=@postId";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@postId", postId)
};
DataTable dataTable = SqlHelper.ExecuteDataTable(sqlStr, parameters);
Post_model post_model = new Post_model();
post_model = ToModel(dataTable.Rows[0]);
return(post_model);
}
public ActionResult PostDetails()
{
LoginStatusConfig(); //配置登录状态
int postId = Convert.ToInt32(Request["postId"]);
//获取postId的原帖数据
Post_bll post_bll = new Post_bll();
Post_model post_mode = post_bll.GetOnePost(postId);
ViewData["post_mode"] = post_mode;
//获取对postId原帖的回帖数据
ReplyPost_bll replyPost_bll = new ReplyPost_bll();
List <ReplyPost_model> replyPost_modelList = replyPost_bll.GetReplyPost(postId);
return(View(replyPost_modelList));
}
/// <summary>
/// 将一条数据转化为Post_model数据
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public Post_model ToModel(DataRow row)
{
Post_model post_model = new Post_model();
post_model.User.userId = (int)row["userId"];
post_model.User.userName = row["userName"].ToString();
post_model.User.signature = (row["signature"] != DBNull.Value ? row["signature"].ToString() : null);
post_model.User.touXiangUrl = row["touXiangUrl"].ToString();
post_model.postId = (int)row["id"];
post_model.postCaption = row["caption"].ToString();
post_model.postContent = row["content"].ToString();
post_model.firstPostPhotoUrl = row["PostPhoto_PhotoUrl"].ToString();
post_model.postDate = (DateTime)row["datetime"];
post_model.postHtmlUrl = row["htmlUrl"].ToString();
post_model.postSupportCount = (int)row["supportCount"];
post_model.Theme.themeName = row["themeName"].ToString();
post_model.Theme.themeId = (int)row["themeId"];
post_model.commentCount = (row["commentCount"] != DBNull.Value ? (int)row["commentCount"] : 0);
post_model.tuiTieCount = (row["tuiTieCount"] != DBNull.Value ? (int)row["tuiTieCount"] : 0);
return(post_model);
}
