public CreatedAtCount GetLoveCount(Guid?shareId)
{
string sql1 = " SELECT COUNT(Id) num FROM huangguan_sharereply WHERE IsDel = 0 and ShareId = '{0}'".FormatStr(shareId);
string sql2 = " SELECT COUNT(` Love`) num FROM huangguan_sharereply WHERE ` Love` = 1 and ShareId = '{0}'".FormatStr(shareId);
DataTable dt1 = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql1);
DataTable dt2 = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql2);
CreatedAtCount cr = new CreatedAtCount();
cr.ReplyerCount = Convert.ToInt32(dt1.Rows[0]["num"]);
cr.loveCount = Convert.ToInt32(dt2.Rows[0]["num"]);
return(cr);
}
public CreatedAtCount GetCreatedAtCount(Guid usrId)
{
DateTime ddddddd = DateTime.Now;
var dfdf = ddddddd.Year + "-" + ddddddd.Month + "-" + "1";
var ggggg = DateTime.Parse(dfdf);
string sql1 = "SELECT COUNT(*) num FROM huangguan_share where IsDel =0";
string sql2 = "SELECT COUNT(CreatedAt) num FROM huangguan_share WHERE CreatedAt >='{0}' and IsDel = 0".FormatStr(ggggg);
DataTable dt1 = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql1);
DataTable dt2 = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql2);
CreatedAtCount cr = new CreatedAtCount();
cr.count = Convert.ToInt32(dt1.Rows[0]["num"]);
cr.yesterdayCount = Convert.ToInt32(dt2.Rows[0]["num"]);
return(cr);
}
public CreatedAtCount LoveState(Guid shareId, Guid Replyer)
{
string sql1 = "SELECT ` Love` FROM huangguan_sharereply WHERE ` Love` IS NOT NULL and ShareId = '{0}' and Replyer ='{1}'".FormatStr(shareId, Replyer);
DataTable dt1 = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql1);
CreatedAtCount cr = new CreatedAtCount();
if (dt1.Rows.Count > 0)
{
cr.Love = Convert.ToInt32(dt1.Rows[0][" Love"]);
return(cr);
}
else
{
cr.Love = 0;
return(cr);
}
}
