绕组实验更新编辑接口

whycrzg

2021-05-22 296c4ac66375373b2e5ff1e6c49935f52afa683c

绕组实验更新编辑接口

 src/main/java/com/whyc/mapper/ExperimentWindingStep1Mapper.java

@@ -21,4 +21,6 @@

    //根据experiment_id编辑试验数据
    int updateById(ExperimentWindingStep1 windingStep1);

    int updateByIdandIndex(ExperimentWindingStep1 windingStep1);
}

 src/main/java/com/whyc/service/WindingExperimentService.java

@@ -192,10 +192,12 @@
        boolean bl = true;
        TransactionStatus transactionStatus = dataSourceTransactionManager.getTransaction(transactionDefinition);
        if (windingStep1s != null && windingStep1s.size() > 0) {
            Date saveTime = new Date();
            for (int i = 0; i < windingStep1s.size(); i++) {
                try {
                    ExperimentWindingStep1 windingStep1 = windingStep1s.get(i);
                    if (mapper1.updateById(windingStep1) > 0) {
                    windingStep1.setSaveTime(saveTime);
                    if (mapper1.updateByIdandIndex(windingStep1) > 0) {
                        bl = true;
                    } else {
                        bl = false;

 src/main/resources/mapper/ExperimentWindingStep1Mapper.xml

@@ -159,4 +159,18 @@
      where
        experiment_id = #{experimentId,jdbcType=VARCHAR}
    </update>

  <update id="updateByIdandIndex" parameterType="com.whyc.pojo.ExperimentWindingStep1">
    update `db_3.5mw_web`.tb_experiment_winding_step1
    set
    electric_current = #{electricCurrent},
    vol = #{vol},
    resistance = #{resistance},
    save_time = #{saveTime},
    temperature = #{temperature}
    WHERE
    experiment_id = #{experimentId} AND
    index_id = #{indexId} AND
    step = #{step}
  </update>
</mapper>