Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/eyes
| | |
| | | import java.util.List; |
| | | |
| | | @Data |
| | | @ApiModel(value = "镜架出入库DTO") |
| | | @ApiModel(value = "镜片出入库DTO") |
| | | public class TWarehousingLensDTO extends TWarehousing { |
| | | |
| | | @ApiModelProperty(value = "镜架出入库明细列表") |
| | |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, brand, supplier, series, refractiveIndex, ballMirror, columnMirror, type, total, createTime, updateTime, createBy, updateBy, isDelete, count, seriesId |
| | | id, brand, supplier, series, refractiveIndex, ballMirror, columnMirror, `type`, total, createTime, updateTime, createBy, updateBy, isDelete, `count`, seriesId |
| | | </sql> |
| | | <select id="pageLensList" resultType="com.jilongda.manage.vo.TLensWarehousingDetailVO"> |
| | | select tlwd.id, tlwd.warehousingId, tlwd.brand, tlwd.supplier, tlwd.series, tlwd.total, tlwd.refractiveIndex, tlwd.ballMirror, tlwd.code, tlwd.createTime,tlwd.columnMirror, |
| | | tlwd.updateTime, tlwd.createBy, tlwd.updateBy, tlwd.isDelete, tlwd.type |
| | | tlwd.updateTime, tlwd.createBy, tlwd.updateBy, tlwd.isDelete, tlwd.`type` |
| | | from t_lens_warehousing_detail tlwd |
| | | left join t_warehousing tw on tlwd.warehousingId = tw.id |
| | | <where> |
| | |
| | | and tlwd.series = #{query.series} |
| | | </if> |
| | | <if test="query.type != null and query.type != ''"> |
| | | and tlwd.type = #{query.type} |
| | | and tlwd.`type` = #{query.type} |
| | | </if> |
| | | <if test="query.refractiveIndex != null and query.refractiveIndex != ''"> |
| | | and tlwd.refractiveIndex = #{query.refractiveIndex} |