/// <summary> /// 获取精品文字评论 /// </summary> /// <param name="articleID"></param> /// <returns></returns> public List <ArticleCommentModel> GetArticleCommentList(Guid articleID) { string strSql = string.Format("SELECT *,(SELECT CustomerName FROM dbo.Customer c WHERE c.CustomerID=a.CustomerID) as CustomerName,(SELECT Sex FROM dbo.Customer c WHERE c.CustomerID=a.CustomerID) as CustomerSex FROM dbo.ArticleComment a WHERE a.ArticleID='{0}' ORDER BY CreateDate DESC", articleID); List <ArticleCommentModel> list = new List <ArticleCommentModel>(); using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <ArticleCommentModel>(reader).ToList(); reader.Close(); } return(list); }
/// <summary> /// 获取用户自己发布的精品文字 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public List <ShortArticleModel> GetShortArticleByMy(Guid customerID) { string strSql = string.Format("SELECT *,(SELECT CustomerName FROM dbo.Customer c WHERE c.CustomerID=a.CustomerID) as CustomerName,(SELECT count(1) FROM [ArticleLike] l WHERE l.ArticleID=a.ArticleID) as LikeCount,(SELECT count(1) FROM [ArticleComment] c WHERE c.ArticleID=a.ArticleID) as CommentCount, (SELECT Sex FROM dbo.Customer c WHERE c.CustomerID=a.CustomerID) as CustomerSex FROM dbo.ShortArticle a WHERE a.CustomerID ='{0}' ORDER BY CreateDate DESC", customerID); List <ShortArticleModel> list = new List <ShortArticleModel>(); using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <ShortArticleModel>(reader).ToList(); reader.Close(); } return(list); }
/// <summary> /// 获取某个用户所有发布的精品文字 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public List <ShortArticleModel> GetShortArticleByCustomerID(Guid customerID) { string strSql = string.Format("SELECT * FROM dbo.ShortArticle WHERE CustomerID='{0}' ORDER BY CreateDate DESC", customerID); List <ShortArticleModel> list = new List <ShortArticleModel>(); using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <ShortArticleModel>(reader).ToList(); reader.Close(); } return(list); }