select s.*,to_date(s.sxcu1m02,'yyyy/mm/dd'),to_date(s.sxcu1m26,'yyyy/mm/dd'),to_date(s.sxcu1m27,'yyyy/mm/dd'),d.name,e.cnname
from sxcu1m s,yc_dx_department d,yc_dx_employees e
where s.sxcu1m05=d.code(+) and s.sxcu1m06=e.code(+) and 1=1
${if (len(建档人员)==0,"","and sxcu1m03='"+建档人员+"'")}
${if (len(使用部门)==0,"","and sxcu1m05='"+使用部门+"'")}
${if (len(保管人)==0,"","and sxcu1m06='"+保管人+"'")}
${if (len(电脑名称)==0,"","and sxcu1m01='"+电脑名称+"'")}
${if (len(耐用年)==0,"","and sxcu1m24='"+耐用年+"'")}
--${if (len(耐用年)==0,"","and cnname='"+耐用年+"'")}
--${if (len(建档日期)==0,"","and s.sxcu1m02>='"+建档日期+"'")}
AND sxcu1m04 >=to_date('${建档日期}','yyyy/MM/dd')
and sxcu1m26 >=to_char('${起算日}','yyyy/MM/dd')
and sxcu1m27 >=to_char('${耐用年限}','yyyy/MM/dd')
--${if (len(起算日)==0,"","and s.sxcu1m26>='"+起算日+"'")}
--and
--to_date(s.sxcu1m02,'yyyy/mm/dd') >=to_date('${建档日期}','yyyy/mm/dd')
--and 1=1 and to_date(s.sxcu1m26,'yyyy/mm/dd')>=to_date('${起算日}','yyyy/mm/dd')
----to_date(s.sxcu1m27,'yyyy/mm/dd')>=to_date('${耐用年限}','yyyy/mm/dd') and
----to_date(s.sxcu1m02,'yyyy/mm/dd')>=to_date('${建档日期}','yyyy/mm/dd')
order by s.sxcu1m04
日期查询不起作用，加上这几个，一条数据都查不出来
其中sxcu1m04是日期类型，其他的都是字符串类型的
