1 .按时间段查询issueDate (开始日期) issueTwoDate (结束日期)
if (string utils.is not empty (issue date ) string utils.is not empty (issuetwodate ) ) {
SQL.append(andto_date ) to_char ) s.issuedate,(yyyy-mm-dd ),(yyyy-mm-dd )=to_date ) 3365292;
Params.put(issueDate ),issuedate );
SQL.append(andto_date ) to_char ) s.issuedate,(yyyy-mm-dd ),(yyyy-mm-dd )=to_date ) 3365292;
params.put(issueTwoDate )、issuetwodate );
}else{
if (string utils.is not empty (issue date ) ) }
SQL.append(andto_char ) s.issuedate,) yyyy-mm-dd )=to_char ) to_date ) 3360issuedate,) yyy-mm
Params.put(issueDate ),issuedate );
}
if (string utils.is not empty (issuetwodate ) ) }
SQL.append(andto_char ) s.issuedate,) yyyy-mm-dd )=to_char ) to_date ) 3360issuetwodate,(yyy-DD )
params.put(issueTwoDate )、issuetwodate );
}
}