修改关联查询

liuxm

2024-06-03 4e254da6b41fb31d3329f8022dab8d8f29180d97

修改关联查询

 pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml

@@ -16,7 +16,7 @@
        <result property="deleted" column="deleted" jdbcType="TINYINT"/>
        <result property="remark" column="remark" jdbcType="VARCHAR"/>
        <association property="instruction"
            column="id" javaType="java.lang.Long" select="com.dy.pmsGlobal.daoPlt.PltProductMapper.selectProNameById" fetchType="eager" />
            column="id" javaType="java.lang.Long" select="com.dy.pmsGlobal.daoPr.PrWorkingInstructionMapper.selectByNodeId" fetchType="eager" />
    </resultMap>

    <sql id="Base_Column_List">

 pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml

@@ -14,6 +14,12 @@
        id,node_id,file_id
    </sql>

    <select id="selectByNodeId" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from pr_working_instruction
        where  node_id = #{nodeId,jdbcType=BIGINT}
    </select>
    <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />