修改

“djh”

5 天以前 99132a43bf344f2aafdd9894b0762d2eedd9767b

修改

 multi-system/src/main/resources/mapper/system/CatalogueMapper.xml

@@ -16,7 +16,7 @@
    </insert>

    <update id="updateCatalogueData">
        UPDATE `train_exam`.`catalogue_data`
        UPDATE `catalogue_data`
        SET
            <if test="companyId!=null">
                `company_id` = #{companyId},
@@ -43,7 +43,8 @@
            `id` = #{id}
    </update>
    <update id="updateCatalogueDataFile">
            UPDATE `train_exam`.`catalogue_data_file`
            UPDATE `catalogue_data_file`
                set
                <if test="catalogueId!=null">
                    `catalogue_id` = #{catalogueId},
                </if>
@@ -63,7 +64,7 @@
                    `type` = #{type},
                </if>
                <if test="delFlag != null and delFlag != ''" >
                    del_flag = #{item.delFlag},
                    del_flag = #{delFlag},
                </if>
                <if test="updateBy != null" >
                    update_by = #{updateBy},
@@ -123,15 +124,18 @@
        SELECT
            id,
            `catalogue_data_id`,
            company_id,
            catalogue_id,
            `name`,
            `file_path`,
            file_name,
            `type`,
            `create_by`,
            `create_time`
        FROM
            catalogue_data_file
        WHERE
            company_id = #{companyId} and catalogue_id = #{catalogueId}
            company_id = #{companyId} and catalogue_id = #{catalogueId} and del_flag =1
    </select>
    <select id="selectByCompanyId" resultType="com.gkhy.exam.system.domain.CatalogueData">
        SELECT

 multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml

@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityDecomposeMapper">
    <insert id="insertDecompose" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO
            `train_exam`.`quality_decompose`
           `quality_decompose`
            ( `company_id`, `quality_id`, `number`, `serial`, `fiction_id`, `fiction_name`, `fiction_time`, `check_id`,`check_name`,
             `check_time`, `ratify_id`, `ratify_name`, `ratify_time`, `create_by`, `create_time`)
        VALUES

 multi-system/src/main/resources/mapper/system/QualityMapper.xml

@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityMapper">

    <insert id="insertQuality" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO `train_exam`.`quality` (
        INSERT INTO `quality` (
            `company_id`,`company_name`,`year`,`num`,`type`, `depart_id`,`depart_name`,`method`,`compilation_id`, `compilation_name`,`compilation_time`,`quality_id`,`quality_name`,
            `quality_time`,`lead_id`,`lead_name`,`lead_time`,`create_by`,`create_time`
        )

 multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml

@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityTargetMapper">

    <insert id="insertQualityTargets">
        INSERT INTO `train_exam`.`quality_target` (
        INSERT INTO `quality_target` (
            `company_id`,`quality_id`,`message`,`num`,`method`,`calculate`,`data_source`,`depart_name`,
            `frequency`,`duty_name`,`remark`,`create_by`,`create_time`
        )