/// <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);
}
