whyclxw
2025-05-28 e16302f9d475c7cc4dd18c5abf1a23cb5502e362
src/main/java/com/whyc/service/StandardFeatureCurveService.java
@@ -2,6 +2,7 @@
import cn.hutool.json.JSONUtil;
import com.whyc.dto.InterfaceParam;
import com.whyc.dto.ReportBattDTO;
import com.whyc.dto.Response;
import com.whyc.dto.StandardFeatureCurve;
import com.whyc.dto.paramter.AlarmPar;
@@ -96,7 +97,8 @@
               //mapper.createTable(titleNameUnion);
               subService.createTable(titleNameUnion);
           }else{ //存在表,先清空数据
               commonMapper.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
               //commonMapper.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
               subService.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
           }
           //mapper.insertBatch(titleNameUnion,curveList2);
           subService.insertBatch(titleNameUnion,curveList2);
@@ -519,8 +521,8 @@
        /*7
        subService.deleteByNum("tb_eleprice_1014",5);*/
        Date date5=ThreadLocalUtil.parse("2023-04-11 16:08:20",1);
        Date date6=ThreadLocalUtil.parse("2023-04-12 01:48:19",1);
        Date date5=ThreadLocalUtil.parse("2023-08-01 10:39:16",1);
        Date date6=ThreadLocalUtil.parse("2023-08-11 12:11:42",1);
        /*10List list=subService.getListByStationId(date5,date6,"42010011","tb_battalarm_data_history_2023_08");*/
        /*12
        ElePrice ele=new ElePrice();
@@ -549,8 +551,86 @@
        subService.deleteEleprice("tb_eleprice_1001");
        subService.createEleprice("tb_eleprice_1016");
        List list=subService.getList("tb_eleprice_1002");*/
        /*24*/
        int tableNum= subService.judgeTable_realdata("1000003_2020_12");
        /*24
        int tableNum= subService.judgeTable_realdata("1000003_2020_12");*/
        /*29
        BattRealdata realdata = new BattRealdata();
        realdata.setTableName("1000018_2023_09");
        realdata.setRecrodTime(date5);
        realdata.setRecrodTime1(date6);
        realdata.setMonNum(19);
        realdata.setRoteN(7);
        //List list=subService.searchMaxNum2(realdata);
        //int maxNum=subService.searchMaxNum(realdata);
        List list=subService.serchByCondition2(realdata);*/
        /*32
        List list= subService.getList(1000011,1);*/
        /*33
        List list= subService.getListByStationId_pwr(date5,date6,"42010020","tb_pwrdev_alarm_history_2023");*/
        /*35
        //List list= subService.serchByCondition(7,1,1000069,1);
        Ld9testdata ld9testdata=new Ld9testdata();
        ld9testdata.setBattGroupId(1000069);
        ld9testdata.setTestRecordCount(1);
        //List list= subService.serchByInfo(ld9testdata);
        Ld9testdataInf ld9inf=new Ld9testdataInf();
        ld9inf.setBattGroupId(1000069);
        ld9inf.setTestRecordCount(1);
        //List list= subService.getLD9AllGroupByTestRecordCount(ld9inf);
        Map map= subService.getLD9AllGroupTimeLong(ld9inf);*/
        /*37
        //float vol=subService.calcAvgVol_stop(1000028,1);
        //BattTestDataStop btsp=subService.findByMonNum(1000028,1);
        BattTestDataStop stop=new BattTestDataStop();
        stop.setBattGroupId(1000028);
        stop.setMonNum(1);
        stop.setTestRecordCount(1);
        stop.setMonVol(1.0f);
        //float cap= subService.getRealCap(stop);
        List list= subService.getTestDataStop(1000028,date5);*/
        /*38
        ReportBattDTO dto=new ReportBattDTO();
        dto.setBattGroupId(1000007);
        dto.setTestType(5);
        dto.setMonNum(0);
        dto.setStationName("山西省-太原市-迎泽区-局机房119-局机房站-2");
        dto.setStationName1("山西省");
        List list= subService.searchByBattGroupId5(dto);*/
        /*45
        //List list= subService.getList_fbo(1000048,5);
        int monCount=subService.getMonCuntBytestRecordCount(1000048,5);*/
        /*46
        ReportBattDTO dto=new ReportBattDTO();
        dto.setBattGroupId(1000007);
        dto.setTestType(2);
        dto.setMonNum(0);
        dto.setStationName("山西省-太原市-迎泽区-局机房119-局机房站-2");
        dto.setStationName1("山西省");
        List list= subService.searchByBattGroupId(dto);*/
        /*49
        int flag=subService.updateFlag("AppServer_Reinit_BattGroupData_EN");*/
        /*52
        int judgeNUm= subService.judge(1000007);*/
        /*55
        List list=subService.getListByStationId_dev(date5,date6,"42010020","tb_devalarm_data_history_2023_08");*/
        /*60
        PwrdevAlarmParam param=new PwrdevAlarmParam();
        param.setPowerDeviceId(110000001);
        param.setAlarmLimith(1f);
        param.setAlarmLimitl(1f);
        param.setAlarmLevel(2);
        param.setUseralarmEn(0);
        param.setAlarmId(110119l);
        int flag=subService.updateParam(param);*/
        /*61
        //List list=subService.serchisStandard(1000059);
        //List list=subService.serchCurrent(1000059);
        //List list=subService.getResInfoByBattGroupId(1000059);
        subService.deleteByTestRecordCount(1000059,1);*/
        /*93
        subService.truncate("db_batt_testdata","tb_battresdata_1000003");*/
        /*107*/
        int tableNum=subService.judgeTable_pwr("110000001_2023_04");
        return  new Response().setII(1,true,tableNum,null);
    }
}