From bd85276c0dbc3e9317ac806bef07b75e8f22401c Mon Sep 17 00:00:00 2001 From: 刘小明 <liuxm_a@163.com> Date: 星期一, 29 七月 2024 09:16:32 +0800 Subject: [PATCH] mapper 及xml整理 --- pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml | 20 +++++++++----------- pms-parent/pms-global/src/main/resources/mapper/BaUserMapper.xml | 10 ++++------ pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml | 4 +--- 3 files changed, 14 insertions(+), 20 deletions(-) diff --git a/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml index 7ec9208..6ef3a61 100644 --- a/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml +++ b/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml @@ -79,9 +79,7 @@ <select id="selectSome" resultMap="BaseResultMap"> select - <include refid="Base_Column_List" > - <property name="alias" value="r"/> - </include> + <include refid="Base_Column_List" /> from ba_log r <trim prefix="where " suffixOverrides="and"> <if test="userId != null and userId != ''"> diff --git a/pms-parent/pms-global/src/main/resources/mapper/BaUserMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/BaUserMapper.xml index df8f57d..4926dde 100644 --- a/pms-parent/pms-global/src/main/resources/mapper/BaUserMapper.xml +++ b/pms-parent/pms-global/src/main/resources/mapper/BaUserMapper.xml @@ -40,9 +40,9 @@ <!--@mbg.generated--> id, `name`, phone, `password`, supper_admin, disabled, deleted, create_dt </sql> - <sql id="part_Column_List"><![CDATA[ - ${alias}.id, ${alias}.name, ${alias}.phone, ${alias}.password, ${alias}.disabled,${alias}.create_dt - ]]></sql> +<!-- <sql id="part_Column_List"><![CDATA[--> +<!-- ${alias}.id, ${alias}.name, ${alias}.phone, ${alias}.password, ${alias}.disabled,${alias}.create_dt--> +<!-- ]]></sql>--> <sql id="Login_Column_List"> id, name, phone, supper_admin </sql> @@ -116,9 +116,7 @@ </select> <select id="selectSome" parameterType="java.util.Map" resultMap="someResultMap"> select - <include refid="part_Column_List" > - <property name="alias" value="bu"/> - </include> + <include refid="Base_Column_List"/> from ba_user bu # left join ba_user_role ur on ur.user_id=bu.id where bu.supper_admin!=1 and bu.deleted!=1 diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml index 1289a16..e94234a 100644 --- a/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml +++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml @@ -19,14 +19,14 @@ id,reason,disabled, deleted,pro_id,sort </sql> - <sql id="part_Column_List"> - ${alias}.id, - ${alias}.reason, - ${alias}.pro_id, - ${alias}.sort, - ${alias}.deleted, - ${alias}.disabled - </sql> +<!-- <sql id="part_Column_List">--> +<!-- ${alias}.id,--> +<!-- ${alias}.reason,--> +<!-- ${alias}.pro_id,--> +<!-- ${alias}.sort,--> +<!-- ${alias}.deleted,--> +<!-- ${alias}.disabled--> +<!-- </sql>--> <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> @@ -80,9 +80,7 @@ <select id="selectSome" resultMap="BaseResultMap"> select - <include refid="part_Column_List" > - <property name="alias" value="t"/> - </include> + <include refid="Base_Column_List"/> from plt_product_scrapping_reason t where t.deleted!=1 <trim prefix="and" suffixOverrides="and"> -- Gitblit v1.8.0