| | |
| | | <if test="equipmentElectricStatisticalVo.equipmentName != null and equipmentElectricStatisticalVo.equipmentName != ''"> |
| | | AND equipmentName LIKE CONCAT(CONCAT('%',#{equipmentElectricStatisticalVo.equipmentName}),'%') |
| | | </if> |
| | | <if test="equipmentElectricStatisticalVo.axisType != null and equipmentElectricStatisticalVo.axisType != ''"> |
| | | AND axisType = #{equipmentElectricStatisticalVo.axisType} |
| | | <if test="equipmentElectricStatisticalVo.axistype != null and equipmentElectricStatisticalVo.axistype != ''"> |
| | | AND axisType = #{equipmentElectricStatisticalVo.axistype} |
| | | </if> |
| | | <if test="equipmentElectricStatisticalVo.createDate != null and equipmentElectricStatisticalVo.createDate != ''"> |
| | | AND createDate = #{equipmentElectricStatisticalVo.createDate} |
| | |
| | | <if test="equipmentElectricStatisticalVo.equipmentName != null and equipmentElectricStatisticalVo.equipmentName != ''"> |
| | | AND equipmentName LIKE CONCAT(CONCAT('%',#{equipmentElectricStatisticalVo.equipmentName}),'%') |
| | | </if> |
| | | <if test="equipmentElectricStatisticalVo.axisType != null and equipmentElectricStatisticalVo.axisType != ''"> |
| | | AND axisType = #{equipmentElectricStatisticalVo.axisType} |
| | | <if test="equipmentElectricStatisticalVo.axistype != null and equipmentElectricStatisticalVo.axistype != ''"> |
| | | AND axisType = #{equipmentElectricStatisticalVo.axistype} |
| | | </if> |
| | | <if test="equipmentElectricStatisticalVo.startDate != null and equipmentElectricStatisticalVo.startDate != '' and equipmentElectricStatisticalVo.endDate != null and equipmentElectricStatisticalVo.endDate != ''"> |
| | | AND createDate BETWEEN #{equipmentElectricStatisticalVo.startDate} AND #{ equipmentElectricStatisticalVo.endDate } |