public QueryObject <CashDealLogSummary> Query(CashDealLogRequest request)
{
if (request.SubmitTimeMax != null)
{
request.SubmitTimeMax = request.SubmitTimeMax.Value.Date.AddDays(1);
}
if (request.SubmitTimeMin != null)
{
request.SubmitTimeMin = request.SubmitTimeMin.Value.Date;
}
return(new QueryObject <CashDealLogSummary>(_databaseInstance, "CashDealLogSummary.query", request));
}
public QueryObject <CashDealLog> Query(CashDealLogRequest request)
{
var sql = @"select * from CashDealLogs where (@submittimeMin is null or submittime >= @submittimeMin)
and (@submittimeMax is null or submittime < @submittimeMax)
";
if (request.SubmitTimeMax != null)
{
request.SubmitTimeMax = request.SubmitTimeMax.Value.Date.AddDays(1);
}
if (request.SubmitTimeMin != null)
{
request.SubmitTimeMin = request.SubmitTimeMin.Value.Date;
}
return(new QueryObject <CashDealLog>(_databaseInstance, sql, request));
}
