update

whycrzg

2021-02-01 f22f754c95700122e46371e453d099c17e6f2677

 src/main/java/com/fgkj/mapper/impl/BattDischarge_planMapper.java

@@ -17,9 +17,13 @@
   @Insert("insert into web_site.tb_battdischarge_plan(battgroupid,BattIndexInFbs,discharge_starttime,discharge_stoptime,discharge_state,discharge_reason,discharge_cleartype,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,plan_circle,plan_rate,note) " +
         "values(#{battgroupid},#{battIndexInFbs},#{discharge_starttime},#{discharge_stoptime},#{discharge_state},#{discharge_reason},#{discharge_cleartype},#{preset_time},#{preset_cap},#{preset_monvol},#{preset_groupvol},#{preset_curr},#{preset_mon},#{dcvolhighlimit},#{chargecurrset},#{plan_circle},#{plan_rate},#{note})")
   public int add(BattDischarge_plan obj);

   //8.1批量添加电池计划
   public boolean addPro(Object obj);
   @Insert("insert into web_site.tb_battdischarge_plan(battgroupid,battIndexInFbs,discharge_starttime,discharge_state,discharge_reason,discharge_cleartype," +
         "preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,plan_circle,plan_rate) " +
         "values(#{battgroupid},#{battIndexInFbs},#{discharge_starttime},#{discharge_state},#{discharge_reason}" +
         ",#{discharge_cleartype},#{preset_time},#{preset_cap} ,#{preset_monvol},#{preset_groupvol},#{preset_curr}" +
         ",#{preset_mon},#{dcvolhighlimit},#{chargecurrset} ,#{plan_circle},#{plan_rate})")
   public int addPro(BattDischarge_plan obj);


//   @Update("update web_site.tb_battdischarge_plan set battgroupid=#{battgroupid},battIndexInFbs=#{battIndexInFbs},discharge_starttime=#{discharge_starttime},discharge_stoptime=#{discharge_stoptime}," +
@@ -32,9 +36,14 @@
         "preset_monvol=#{preset_monvol},preset_groupvol=#{preset_groupvol},preset_curr=#{preset_curr},preset_mon=#{preset_mon},dcvolhighlimit=#{dcvolhighlimit}," +
         "chargecurrset=#{chargecurrset},note=#{note} where num=#{num}")
   public int update(BattDischarge_plan obj);
   

   //8.1批量修改放电计划的开始时间/放电参数的修改/启用计划和取消计划
   public int updatePro(List<BattDischarge_plan> obj);
   @Update("update web_site.tb_battdischarge_plan set discharge_starttime=#{discharge_starttime},discharge_cleartype=#{discharge_cleartype}," +
         "discharge_reason=#{discharge_reason},discharge_state=#{discharge_state},preset_time=#{preset_time},preset_cap=#{preset_cap}," +
         "preset_monvol=#{preset_monvol},preset_groupvol=#{preset_groupvol},preset_curr=#{preset_curr},preset_mon=#{preset_mon}," +
         "dcvolhighlimit=#{dcvolhighlimit},chargecurrset=#{chargecurrset}  ,plan_circle=#{plan_circle},plan_rate=#{plan_rate} " +
         "where battgroupid=#{battgroupid} and num=#{num}")
   public int updatePro(BattDischarge_plan obj);

   @Delete("delete from web_site.tb_battdischarge_plan where num=#{num} ")
   public int del(BattDischarge_plan obj);