| | |
| | | <update id="updateSysWarehouse" parameterType="com.nanometer.smartlab.entity.SysWarehouse"> |
| | | update sys_warehouse set type=#{type}, name=#{name}, info_code=#{infoCode}, bar_code=#{barCode}, location1=#{location1}, location2=#{location2}, |
| | | update_time=now(),department=#{department} |
| | | <if test="temperatureMax != null and temperatureMax != ''"> |
| | | ,temperature_max = #{temperatureMax} |
| | | </if> |
| | | <if test="temperatureMin != null and temperatureMin != ''"> |
| | | ,temperature_min = #{temperatureMin} |
| | | </if> |
| | | <if test="humidityMax != null and humidityMax != ''"> |
| | | ,humidity_max = #{humidityMax} |
| | | </if> |
| | | <if test="humidityMin != null and humidityMin != ''"> |
| | | ,humidity_min = #{humidityMin} |
| | | </if> |
| | | where id=#{id} |
| | | </update> |
| | | |