/// <summary> /// 获取某个用户所有发布的我爱分享网 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public List <shareModel> GetshareByCustomerID(Guid customerID) { string strSql = string.Format("SELECT * FROM dbo.ShortArticle WHERE CustomerID='{0}' ORDER BY CreateDate DESC", customerID); List <shareModel> list = new List <shareModel>(); try { using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <shareModel>(reader).ToList(); reader.Close(); } } catch (Exception w1) { Tool.WritrErro(w1); } return(list); }
/// <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>(); try { using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <ArticleCommentModel>(reader).ToList(); reader.Close(); } } catch (Exception w3) { Tool.WritrErro(w3); } return(list); }
/// <summary> /// 获取用户评论过的我爱分享网 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public List <shareModel> GetshareByComment(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.ArticleID in (SELECT ArticleID FROM dbo.ArticleComment WHERE CustomerID='{0}') ORDER BY CreateDate DESC", customerID); List <shareModel> list = new List <shareModel>(); try { using (SqlDataReader reader = DBHelper.GetDataReader(strSql.ToString())) { list = CommconHelper.ReaderToList <shareModel>(reader).ToList(); reader.Close(); } } catch (Exception q1) { Tool.WritrErro(q1); } return(list); }