/// <summary>
/// 得到今日更新记录
/// </summary>
/// <returns></returns>
public int GetUpdateRecordsCountByDate(DateTime begin, DateTime end)
{
int total = 0;
string query = "SELECT count(*) as Total FROM EXArticle WHERE DATEDIFF(ModifyDate,@Begin)>=0 and DATEDIFF(ModifyDate,@End) <=0";
using (Conn)
{
DapperCount count = Conn.Query <DapperCount>(query, new { Begin = begin, End = end }).SingleOrDefault();
total = count.Total;
}
return(total);
}
/// <summary>
/// 得到某个个时间段内的增加的临时博客的数量
/// </summary>
/// <param name="begin"></param>
/// <param name="end"></param>
/// <returns></returns>
public int GetAddRecordsCountByDate(DateTime begin, DateTime end)
{
int total = 0;
string query = "SELECT count(*) as Total FROM EXArticleTemp WHERE DATEDIFF(CreateDate,@Begin)>=0 and DATEDIFF(CreateDate,@End) <=0";
using (Conn)
{
DapperCount count = Conn.Query <DapperCount>(query, new { Begin = begin.ToString("yyyy-MM-dd"), End = end.ToString("yyyy-MM-dd") }).SingleOrDefault();
total = count.Total;
}
return(total);
}
