public static IEnumerable <ArticleCommentModel> SelectArticleCommentByPKID(int PKID, string UserID, int PageIndex = 1, int PageSize = 10) { var dt = ArticleComment.SelectArticleCommentByPKID(PKID, UserID, PageIndex, PageSize); return(dt.Rows.Cast <DataRow>().Select(row => new ArticleCommentModel(row)).Select(a => { a.PhoneNum = CommentHelper.GetCommentUserName(a.PhoneNum, 0); a.UserName = CommentHelper.GetCommentUserName(a.UserName, 0); return a; })); }
/// <summary> /// 热门评论 /// </summary> /// <param name="PKID"></param> /// <param name="UserID"></param> /// <returns></returns> public static IEnumerable <ArticleCommentModel> GetArticleCommentTop3(int PKID, string UserID) { var dt = ArticleComment.GetArticleCommentTop3(PKID, UserID); if (dt == null || dt.Rows.Count == 0) { return(new ArticleCommentModel[0]); } return(dt.Rows.Cast <DataRow>().Select(row => new ArticleCommentModel(row)).Select(a => { a.PhoneNum = CommentHelper.GetCommentUserName(a.PhoneNum, 0); //a.UserName = CommentHelper.GetCommentUserName(a.RealName, 0); return a; })); }
/// <summary> /// 查询相关文章,以及置顶评论 /// </summary> /// <param name="PKID"></param> /// <param name="Category"></param> /// <param name="UserId"></param> /// <param name="IsLikeNew"></param> /// <returns></returns> public static NewsInfoModel SelectNewsInfo(int PKID, int Category, string UserId = "", bool IsLikeNew = false) { try { var ds = Articles.SelectNewsInfo(PKID, Category); if (ds != null && ds.Tables.Count == 2) { NewsInfoModel model = new NewsInfoModel(); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { model.CommentItems = (List <tbl_CommentModel>)Helper.ModelConvertHelper <tbl_CommentModel> .ConvertToModel(ds.Tables[0]); if (model.CommentItems != null && model.CommentItems.Count > 0) { model.CommentItems.ForEach(w => w.UserName = CommentHelper.GetCommentUserName(w.UserName, 0)); } } else { model.CommentItems = null; } if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { model.ArticleItems = (List <tbl_ArticleModel>)Helper.ModelConvertHelper <tbl_ArticleModel> .ConvertToModel(ds.Tables[1]); } else { model.ArticleItems = null; } return(model); } return(null); } catch (Exception ex) { return(null); } }