public async Task <int> GetSendFailureCountAsync(DateTime beginTime, DateTime endTime)
{
var filter = new SingleQueryFilter();
filter.AddGreaterOrEqual(nameof(PushProcessHistory.SendTime), beginTime);
filter.AddLessOrEqual(nameof(PushProcessHistory.SendTime), endTime);
return(await _repository.CountAsync(filter));
}
private void SingleFilterTest()
{
DapperSqlGenerator generator = this.MockGenerator();
SingleQueryFilter filter = new SingleQueryFilter();
filter.AddEqual("name", "evalue");
filter.AddGreaterOrEqual("gte", 1);
filter.AddGreater("gt", 0);
filter.AddLess("lt", 10000);
filter.AddLessOrEqual("lte", 999);
filter.AddNotEqual("null", null);
DynamicParameters parameters = new DynamicParameters();
generator.GenerateFilter <DapperEntityWithNoBool>(filter, parameters);
Assert.Equal(5, parameters.ParameterNames.Count()); // null 不作为参数。
}
private void CombinedFilterTest()
{
DapperSqlGenerator generator = this.MockGenerator();
SingleQueryFilter filter = new SingleQueryFilter();
filter.AddEqual("name", "evalue");
filter.AddGreaterOrEqual("gte", 1);
filter.AddGreater("gt", 0);
filter.AddLess("lt", 10000);
filter.AddLessOrEqual("lte", 999);
filter.AddNotEqual("null", null);
SingleQueryFilter filter2 = new SingleQueryFilter();
filter2.AddGreaterOrEqual("gte2", 1);
filter2.AddEqual("name2", "evalue");
filter2.AddGreater("gt2", 0);
filter2.AddLess("lt2", 10000);
filter2.AddLessOrEqual("lte2", 999);
filter2.AddNotEqual("null2", null);
SingleQueryFilter filter3 = new SingleQueryFilter();
filter3.AddEqual("name23", "evalue");
filter3.AddGreaterOrEqual("gte3", 1);
filter3.AddGreater("gt3", 0);
filter3.AddLess("lt3", 10000);
filter3.AddLessOrEqual("lte3", 999);
filter3.AddEqual("null3", null);
CombinedQueryFilter cf1 = new CombinedQueryFilter(filter2, filter3, BooleanClause.And);
CombinedQueryFilter cf2 = new CombinedQueryFilter(filter, cf1, BooleanClause.Or);
DynamicParameters parameters = new DynamicParameters();
generator.GenerateFilter <DapperEntityWithNoBool>(cf2, parameters);
Assert.Equal(15, parameters.ParameterNames.Count()); // null 不作为参数。
}