库位使用率表字段映射修复

pang.jiabao

昨天 4bea5cda1593e2aa6468501e75701e1729f2e315

库位使用率表字段映射修复

 src/main/resources/mapper/ViewStockUseMapper.xml

@@ -2,7 +2,16 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.asrs.mapper.ReportQueryMapper">

    <resultMap id="ViewStockUseMap" type="com.zy.asrs.entity.ViewStockUseBean">
        <result property="row1" column="row1"/>
        <result property="total_qty" column="total_qty"/>
        <result property="full_qty" column="full_qty"/>
        <result property="null_qty" column="null_qty"/>
        <result property="forbid_qty" column="forbid_qty"/>
        <result property="empty_qty" column="empty_qty"/>
        <result property="full_rate" column="full_rate"/>
        <result property="occ_rate" column="occ_rate"/>
    </resultMap>
<!-- mapper不支持sql语句嵌套时，采用sql片段包含方式，解决xml标签问题 -->
<sql id="viewStockUseConditionSql">    
        <if test="row1!=null and row1!='' ">
@@ -11,7 +20,7 @@
</sql>

<!-- 分页查询所有信息 -->
<select id="queryViewStockUseList" parameterType="com.zy.asrs.entity.ViewStockUseBean" resultType="com.zy.asrs.entity.ViewStockUseBean">
<select id="queryViewStockUseList" parameterType="com.zy.asrs.entity.ViewStockUseBean" resultMap="ViewStockUseMap">
select top (#{pageSize}) * from asr_stk_use_view 
<where>
    row1 not in (select top ((#{pageNumber}-1)*#{pageSize}) row1 from asr_stk_use_view