From 760eb97dd624b69e254d148c71347fe35171dcc9 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 05 十二月 2024 18:07:19 +0800
Subject: [PATCH] 增加字段部门字段

---
 ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml     |   12 +++++++++++-
 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java |    6 ++++++
 2 files changed, 17 insertions(+), 1 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java
index 30cc387..fb59dee 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java
@@ -329,6 +329,10 @@
     @TableField(exist = false)
     private String isBlack;
 
+    private Long dictCompId;
+
+    private String compName;
+
     @Override
     public String toString() {
         return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
@@ -354,6 +358,8 @@
                 .append("updateTime", getUpdateTime())
                 .append("deleted", getDeleted())
                 .append("dwPhone", getDwPhone())
+                .append("compId", getDictCompId())
+                .append("compName", getCompName())
                 .toString();
     }
 }
diff --git a/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml b/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
index 4f039c6..4fd3a12 100644
--- a/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
+++ b/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
@@ -33,6 +33,8 @@
         <result property="career" column="career"/>
         <result property="dwPhone" column="dw_phone"/>
         <result property="pym" column="pym"/>
+        <result property="dictCompId" column="dict_comp_id"/>
+        <result property="compName" column="comp_name"/>
     </resultMap>
 
     <sql id="selectTjCustomerVo">
@@ -63,7 +65,7 @@
                age_unit,
                career,
                dw_phone,
-               pym
+               pym,dictCompId,compName
         from tj_customer
     </sql>
 
@@ -86,6 +88,8 @@
             <if test="cusNumber != null ">and cus_number = #{cusNumber}</if>
             <if test="cusIsvip != null  and cusIsvip != ''">and cus_isvip = #{cusIsvip}</if>
             <if test="pym != null  and pym != ''">and pym = #{pym}</if>
+            <if test="dictCompId != null  and dictCompId != ''">and dict_comp_id = #{dictCompId}</if>
+            <if test="compName != null  and compName != ''">and comp_name = #{compName}</if>
         </where>
     </select>
 
@@ -124,6 +128,8 @@
             <if test="career != null">career,</if>
             <if test="dwPhone != null">dw_phone,</if>
             <if test="pym != null">pym,</if>
+            <if test="dictCompId != null">dict_comp_id,</if>
+            <if test="compName != null">comp_name,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="cusName != null and cusName != ''">#{cusName},</if>
@@ -153,6 +159,8 @@
             <if test="career != null">#{career},</if>
             <if test="dw_phone != null">#{dwPhone},</if>
             <if test="pym != null">#{pym},</if>
+            <if test="dictCompId != null">#{dictCompId},</if>
+            <if test="compName != null">#{compName},</if>
         </trim>
     </insert>
 
@@ -186,6 +194,8 @@
             <if test="career != null">career = #{career},</if>
             <if test="dwPhone != null">dw_phone = #{dwPhone},</if>
             <if test="pym != null">pym = #{pym},</if>
+            <if test="dictCompId != null">dict_comp_id = #{dictCompId},</if>
+            <if test="compName != null">comp_name = #{compName},</if>
         </trim>
         where cus_id = #{cusId}
     </update>

--
Gitblit v1.8.0