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