void getTemplate() { #region --------------帖子详细-------------------------- MSForumTopic TopicModel = new MSForumTopic(); MSForumTopicDAL TopicDel = new MSForumTopicDAL(); DataSet TopicDs = TopicDel.GetTopicDetail(strtid); if (null != TopicDs && TopicDs.Tables.Count > 0 && TopicDs.Tables[0].Rows.Count > 0) { TopicModel = DataConvert.DataRowToModel <MSForumTopic>(TopicDs.Tables[0].Rows[0]); } #endregion #region -----------帖子图集---------------- List <MSForumTopicAtlas> atlasModelList = new List <MSForumTopicAtlas>(); MSForumTopicAtlasDAL atlasDal = new MSForumTopicAtlasDAL(); DataSet altasDs = atlasDal.GetMSFTAtlasList(" and tid='" + strtid + "'"); if (altasDs != null && altasDs.Tables.Count > 0 && altasDs.Tables[0].Rows.Count > 0) { foreach (DataRow row in altasDs.Tables[0].Rows) { MSForumTopicAtlas atlasModel = DataConvert.DataRowToModel <MSForumTopicAtlas>(row); atlasModelList.Add(atlasModel); } } #endregion #region ---------点赞或喜欢------------ MSForumTopicLoveDAL lovelikeDal = new MSForumTopicLoveDAL(); string likecount = lovelikeDal.GetLoveOrLikeCount(strtid, "tlike").ToString(); string lovecount = lovelikeDal.GetLoveOrLikeCount(strtid, "tlove").ToString(); #endregion #region ---------评论列表以及图集信息------------ List <CommentListGetSet> commentModelList = new List <CommentListGetSet>(); MSForumCommentDAL commentDal = new MSForumCommentDAL(); DataSet commentDs = commentDal.GetCommentList(" and a.tid='" + strtid + "' "); List <MSForumTopicAtlas> commatlasModelList = new List <MSForumTopicAtlas>(); int commentcount = 0; if (commentDs != null && commentDs.Tables.Count > 0 && commentDs.Tables[0].Rows.Count > 0) { foreach (DataRow row in commentDs.Tables[0].Rows) { CommentListGetSet commentModel = DataConvert.DataRowToModel <CommentListGetSet>(row); string cmmid = commentModel.ID; if (commentModel.NickName == null || commentModel.NickName == "") { commentModel.NickName = "游客"; } #region ------------评论图集----------------------- DataSet commaltasDs = atlasDal.GetMSFTAtlasList(" and tid='comm" + cmmid + "'"); if (commaltasDs != null && commaltasDs.Tables.Count > 0 && commaltasDs.Tables[0].Rows.Count > 0) { foreach (DataRow commrow in commaltasDs.Tables[0].Rows) { MSForumTopicAtlas atlasModel = DataConvert.DataRowToModel <MSForumTopicAtlas>(commrow); commatlasModelList.Add(atlasModel); } } #endregion commentModelList.Add(commentModel); } } try { commentcount = commentDs.Tables[0].Rows.Count; } catch (Exception) { commentcount = 0; } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/commentlist.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); context.TempData["topicdetail"] = TopicModel; context.TempData["altaslist"] = atlasModelList; context.TempData["commentlist"] = commentModelList; context.TempData["commentatlaslist"] = commatlasModelList; context.TempData["commentcount"] = commentcount; context.TempData["errorscript"] = errorscript; context.TempData["likecount"] = likecount; context.TempData["lovecount"] = lovecount; context.TempData["fid"] = strfid; context.TempData["uid"] = strUid; context.TempData["footer"] = "奥琦微商易"; t.Render(Response.Output); }
public void getTemplate() { #region -----------获取客户信息--------- MSCustomers CustomerModel = new MSCustomers(); MSCustomersDAL CustomerDal = new MSCustomersDAL(); DataSet CustomerDs; if (strUid != null && strUid != "") { CustomerDs = CustomerDal.GetCustomerDetail(strUid); if (null != CustomerDs && CustomerDs.Tables.Count > 0 && CustomerDs.Tables[0].Rows.Count > 0) { CustomerModel = DataConvert.DataRowToModel <MSCustomers>(CustomerDs.Tables[0].Rows[0]); if (CustomerModel.NickName == null || CustomerModel.NickName == "" || CustomerModel.NickName.ToLower() == "null") { CustomerModel.NickName = "游客"; } } } #endregion #region ---------评论列表以及信息回复------------ List <CommentListGetSet> commentModelList = new List <CommentListGetSet>(); MSForumCommentDAL commentDal = new MSForumCommentDAL(); DataSet commentDs = commentDal.GetCommentList(" and a.[uid]='" + strUid + "' "); DataSet repcommentds; List <CommentListGetSet> repcommentModelList = new List <CommentListGetSet>(); int commentcount = 0; if (commentDs != null && commentDs.Tables.Count > 0 && commentDs.Tables[0].Rows.Count > 0) { foreach (DataRow row in commentDs.Tables[0].Rows) { CommentListGetSet commentModel = DataConvert.DataRowToModel <CommentListGetSet>(row); if (commentModel.NickName == null || commentModel.NickName == "") { commentModel.NickName = "游客"; } #region ----------------获取回复信息----------------------- string repid = commentModel.ID; repcommentds = commentDal.GetRepCommentList(" and a.[uid]='" + strUid + "' and a.UpID='" + repid + "' "); if (repcommentds != null && repcommentds.Tables.Count > 0 && repcommentds.Tables[0].Rows.Count > 0) { foreach (DataRow reprow in repcommentds.Tables[0].Rows) { CommentListGetSet repcommentModel = DataConvert.DataRowToModel <CommentListGetSet>(reprow); if (repcommentModel.NickName == null || repcommentModel.NickName == "") { repcommentModel.NickName = "游客"; } repcommentModelList.Add(repcommentModel); } } #endregion commentModelList.Add(commentModel); } } try { commentcount = commentDs.Tables[0].Rows.Count; } catch (Exception) { commentcount = 0; } #endregion #region --------------获取喜欢 总数------------------ int likecount = 0; MSForumTopicLoveDAL likeDal = new MSForumTopicLoveDAL(); try { likecount = likeDal.GetLoveOrLikeCountByUID(strUid, "tlike"); } catch (Exception) { likecount = 0; } #endregion #region ------------获取消息总数--------------- int msgcount = 0; try { msgcount = commentDal.GetCommentCountByUID(strUid); } catch (Exception) { msgcount = 0; } #endregion #region ---------帖子总数------------- int topiccount = 0; MSForumTopicDAL topicdal = new MSForumTopicDAL(); try { topiccount = topicdal.GetTopicCountByUID(strUid); } catch (Exception) { topiccount = 0; } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/Mycommentlist.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); context.TempData["customer"] = CustomerModel; context.TempData["commentlist"] = commentModelList; context.TempData["repcommentlist"] = repcommentModelList; context.TempData["fid"] = strfid; context.TempData["likecount"] = likecount; context.TempData["msgcount"] = msgcount; context.TempData["topiccount"] = topiccount; context.TempData["errorscript"] = errorscript; context.TempData["uid"] = strUid; context.TempData["footer"] = "奥琦微商易"; t.Render(Response.Output); }