2025-05-13

zhaowenxuan

4 天以前 0f6f7302d471aa425055c68c28524c801548a9f1

2025-05-13

 ltkj-admin/src/main/resources/sql/Ö°Òµ²¡.sql

@@ -17,4 +17,7 @@
ALTER TABLE tj_order ADD COLUMN zhiye_ksjhrq DATETIME NULL COMMENT '开始接害日期';
ALTER TABLE tj_order ADD COLUMN zhiye_gh VARCHAR(255) NULL COMMENT '工号';
ALTER TABLE tj_order ADD COLUMN zhiye_cj VARCHAR(255) NULL COMMENT '车间';
ALTER TABLE tj_order ADD COLUMN zhiye_jl VARCHAR(255) NULL COMMENT '职业结论';
ALTER TABLE tj_order ADD COLUMN zhiye_jg VARCHAR(255) NULL COMMENT '职业结果';



 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjOrder.java

@@ -492,6 +492,16 @@
     */
    private String zhiyeCj;

    /**
     * èŒä¸šç»“论
     */
    private String zhiyeJl;

    /**
     * èŒä¸šç»“æžœ
     */
    private String zhiyeJg;

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)

 ltkj-hosp/src/main/resources/mapper/hosp/TjOrderMapper.xml

@@ -41,6 +41,8 @@
        <result property="zhiyeKsjhrq" column="zhiye_ksjhrq"/>
        <result property="zhiyeGh" column="zhiye_gh"/>
        <result property="zhiyeCj" column="zhiye_cj"/>
        <result property="zhiyeJl" column="zhiye_jl"/>
        <result property="zhiyeJg" column="zhiye_jg"/>
    </resultMap>

    <sql id="selectTjOrderVo">
@@ -82,7 +84,7 @@
               heshou_time,
               is_hz,
               get_type,
               tj_category,zhiye_jhgln,zhiye_jhgly,zhiye_ksjhrq,zhiye_gh,zhiye_cj
               tj_category,zhiye_jhgln,zhiye_jhgly,zhiye_ksjhrq,zhiye_gh,zhiye_cj,zhiye_jl,zhiye_jg
        from tj_order
    </sql>

@@ -219,6 +221,8 @@
            <if test="zhiyeKsjhrq != null">zhiye_ksjhrq,</if>
            <if test="zhiyeGh != null">zhiye_gh,</if>
            <if test="zhiyeCj != null">zhiye_cj,</if>
            <if test="zhiyeJl != null">zhiye_jl,</if>
            <if test="zhiyeJg != null">zhiye_jg,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="userId != null">#{userId},</if>
@@ -264,6 +268,8 @@
            <if test="zhiyeKsjhrq != null">#{zhiyeKsjhrq},</if>
            <if test="zhiyeGh != null">#{zhiyeGh},</if>
            <if test="zhiyeCj != null">#{zhiyeCj},</if>
            <if test="zhiyeJl != null">#{zhiyeJl},</if>
            <if test="zhiyeJg != null">#{zhiyeJg},</if>
        </trim>
    </insert>

@@ -314,6 +320,8 @@
            <if test="zhiyeKsjhrq != null">zhiye_ksjhrq = #{zhiyeKsjhrq},</if>
            <if test="zhiyeGh != null">zhiye_gh = #{zhiyeGh},</if>
            <if test="zhiyeCj != null">zhiye_cj = #{zhiyeCj},</if>
            <if test="zhiyeJl != null">zhiye_jl = #{zhiyeJl},</if>
            <if test="zhiyeJg != null">zhiye_jg = #{zhiyeJg},</if>
        </trim>
        where order_id = #{orderId}
    </update>