protected virtual string FormatReqBetweenRule(ReqBetweenRule rule)
{
//如果是时间范围查询
DateTimeOffset startDate; DateTimeOffset endDate;
if (DateTimeOffset.TryParse(rule.StartValue.ToString(), out startDate) && DateTimeOffset.TryParse(rule.EndValue.ToString(), out endDate))
{
return $"{rule.Field} between '{startDate.ToString("yyyy-MM-dd 00:00:00")}' and '{endDate.ToString("yyyy-MM-dd 23:59:59")}'";
}
else
{
return $"{rule.Field} between {rule.StartValue} and {rule.EndValue}";
}
}
protected virtual string FormatReqBetweenRule(ReqBetweenRule rule)
{
var field = $"{prefix}.{rule.Field}";
//如果是时间范围查询
DateTimeOffset startDate; DateTimeOffset endDate;
if (DateTimeOffset.TryParse(rule.StartValue.ToString(), out startDate) && DateTimeOffset.TryParse(rule.EndValue.ToString(), out endDate))
{
return($"{field} >= Convert.ToDateTime('{startDate.ToString("yyyy-MM-dd 00:00:00")}') && {field} <= Convert.ToDateTime('{endDate.ToString("yyyy-MM-dd 23:59:59")}')");
}
else
{
return($"{field} >= {rule.StartValue} && {field} <= {rule.EndValue}");
}
}
