From 3f4c3b0257ae514e2f07f554c33eb95b1ce01b05 Mon Sep 17 00:00:00 2001 From: Fancy <Fancy.fx@outlook.com> Date: 星期五, 18 十月 2024 17:29:58 +0800 Subject: [PATCH] command --- pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java | 4 ++++ pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml | 8 ++++++-- 2 files changed, 10 insertions(+), 2 deletions(-) diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java index b65c6f4..e17ac86 100644 --- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java +++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java @@ -35,6 +35,10 @@ */ @JSONField(serializeUsing= ObjectWriterImplToString.class) public Long proId; + @TableField(exist = false) + public String proName; + @TableField(exist = false) + public String proType; /** * 鎸囦护绫诲瀷:娴嬭瘯鎸囦护(1)銆佽缃寚浠�(2) diff --git a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml index ae65b18..0491b4d 100644 --- a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml +++ b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml @@ -19,6 +19,10 @@ <result property="updatedDate" column="updated_date" jdbcType="TIMESTAMP"/> <association property="creatorName" column="creator" javaType="java.lang.Long" select="com.dy.pmsGlobal.daoBa.BaUserMapper.selectNameByUserId" fetchType="eager"/> + <association property="proName" column="pro_id" javaType="java.lang.Long" + select="com.dy.pmsGlobal.daoPlt.PltProductMapper.selectProNameById" fetchType="eager" /> + <association property="proType" column="pro_id" javaType="java.lang.Long" + select="com.dy.pmsGlobal.daoPlt.PltProductMapper.selectProTypeById" fetchType="eager" /> </resultMap> <sql id="Base_Column_List"> @@ -54,7 +58,7 @@ name like concat('%', #{name}, '%') and </if> <if test="proId != null"> - proId = #{proId,jdbcType=BIGINT} + pro_id = #{proId,jdbcType=BIGINT} and </if> <if test="value != null and value !=''"> value like concat('%', #{value}, '%') and @@ -79,7 +83,7 @@ name like concat('%', #{name}, '%') and </if> <if test="proId != null"> - proId = #{proId,jdbcType=BIGINT} + pro_id = #{proId,jdbcType=BIGINT} and </if> <if test="value != null and value !=''"> value like concat('%', #{value}, '%') and -- Gitblit v1.8.0