//文本框
//显示
===============查询两个日期之间的数据===============================
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
//出货日期 oisDate
if(oqcIssueBean.getOisDate()!=null && !oqcIssueBean.getOisDate().toString().isEmpty()
&& oqcIssueBean.getEndOisDate()!=null && !oqcIssueBean.getEndOisDate().toString().isEmpty())
{
strWhere=strWhere+" AND OI.oisDate BETWEEN to_date('"+sdf.format(oqcIssueBean.getOisDate())+"','yyyy-MM-dd') AND to_date('"+sdf.format(oqcIssueBean.getEndOisDate())+"','yyyy-MM-dd')";
}
else if(oqcIssueBean.getOisDate()!=null && !oqcIssueBean.getOisDate().toString().isEmpty())
{
strWhere=strWhere+" AND OI.oisDate = to_date('"+sdf.format(oqcIssueBean.getOisDate())+"','yyyy-MM-dd')";
}