中-12-ElePriceMapper.xml;4行

lxw

2023-10-30 195e80e4c94f6734f01b89afedb58ee56ff0a1b9

中-12-ElePriceMapper.xml;4行

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

@@ -6,7 +6,7 @@
import java.util.List;

public interface ElePriceMapper extends CustomMapper<ElePrice> {
    int addElePrice(@Param("entity")ElePrice elePrice);
    //int addElePrice(@Param("entity")ElePrice elePrice);

    int createEleprice(@Param("tableName")String tableName);


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

@@ -25,9 +25,11 @@
                ElePrice elePrice = list.get(i);
                if (i==0){
                    mapper.createEleprice("tb_eleprice_"+ elePrice.getTmpId());
                    mapper.addElePrice(elePrice);
                    //mapper.addElePrice(elePrice);
                    subService.addElePrice(elePrice);
                }else {
                    mapper.addElePrice(elePrice);
                    //mapper.addElePrice(elePrice);
                    subService.addElePrice(elePrice);
                }

            }
@@ -42,9 +44,11 @@
                if (i==0){
                    mapper.createEleprice("tb_eleprice_"+ elePrice.getTmpId());
                    mapper.deleteEleprice("tb_eleprice_"+ elePrice.getTmpId());
                    mapper.addElePrice(elePrice);
                    //mapper.addElePrice(elePrice);
                    subService.addElePrice(elePrice);
                }else {
                    mapper.addElePrice(elePrice);
                    //mapper.addElePrice(elePrice);
                    subService.addElePrice(elePrice);
                }

            }

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

@@ -518,10 +518,16 @@
        subService.delete(1000094,1);*/
        /*7
        subService.deleteByNum("tb_eleprice_1014",5);*/
        /*10*/

        Date date5=ThreadLocalUtil.parse("2023-08-01 11:19:20",1);
        Date date6=ThreadLocalUtil.parse("2023-08-03 04:42:35",1);
        List list=subService.getListByStationId(date5,date6,"42010011","tb_battalarm_data_history_2023_08");
        return  new Response().setII(1,true,list,null);
        /*10List list=subService.getListByStationId(date5,date6,"42010011","tb_battalarm_data_history_2023_08");*/
        ElePrice ele=new ElePrice();
        ele.setTmpId(1015);
        ele.setTmpStarttime(date5);
        ele.setTmpStoptime(date6);
        ele.setElePrice(20f);
        subService.addElePrice(ele);
        return  new Response().setII(1,true,ele,null);
    }
}

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

@@ -2022,4 +2022,11 @@
        });
        return list;
    }

    //12-ElePriceMapper.xml;4行
    public void addElePrice(ElePrice elePrice){
        String sql=" insert into web_site.tb_eleprice_"+elePrice.getTmpId()+" (Tmp_id,Tmp_starttime,Tmp_stoptime,Ele_price) " +
                "        values( "+elePrice.getTmpId()+",'"+ThreadLocalUtil.format(elePrice.getTmpStarttime(),4)+"','"+ThreadLocalUtil.format(elePrice.getTmpStoptime(),4)+"',"+elePrice.getElePrice()+")";
        sqlExecuteService.execute(sql);
    }
}

 src/main/resources/mapper/ElePriceMapper.xml

@@ -1,10 +1,10 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.ElePriceMapper" >
    <insert id="addElePrice" parameterType="com.whyc.pojo.ElePrice" >
    <!--<insert id="addElePrice" parameterType="com.whyc.pojo.ElePrice" >
        insert into web_site.tb_eleprice_${entity.tmpId} (Tmp_id,Tmp_starttime,Tmp_stoptime,Ele_price)
        values( #{entity.tmpId},#{entity.tmpStarttime},#{entity.tmpStoptime},#{entity.elePrice})
    </insert>
    </insert>-->
    <update id="createEleprice">
        CREATE TABLE IF NOT EXISTS web_site.${tableName} (
        `num` int(11) NOT NULL AUTO_INCREMENT,