| | |
| | | <!-- from asr_wrkin_view a--> |
| | | <!-- where 1=1--> |
| | | <!-- <include refid="viewWorkInConditionSql"></include>--> |
| | | select * from asr_wrkin_view |
| | | select *,manu_date manuDate,man_length manLength from asr_wrkin_view |
| | | where 1=1 |
| | | <include refid="viewWorkInConditionSql"></include> |
| | | </select> |
| | |
| | | |
| | | <!-- 不分页查询所有信息,用于excel导出 --> |
| | | <select id="getViewWorkOutAll" parameterType="com.zy.asrs.entity.ViewWorkInBean" resultType="com.zy.asrs.entity.ViewWorkInBean"> |
| | | select * |
| | | select *,manu_date manuDate,man_length manLength |
| | | from asr_wrkout_view a |
| | | where 1=1 |
| | | <include refid="viewWorkInConditionSql"></include> |