| | |
| | | |
| | | 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; |
| | |
| | | //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); |
| | |
| | | /*7 |
| | | subService.deleteByNum("tb_eleprice_1014",5);*/ |
| | | |
| | | Date date5=ThreadLocalUtil.parse("2023-09-19 10:00:09",1); |
| | | Date date6=ThreadLocalUtil.parse("2023-09-26 06:53:56",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(); |
| | |
| | | //List list=subService.searchMaxNum2(realdata); |
| | | //int maxNum=subService.searchMaxNum(realdata); |
| | | List list=subService.serchByCondition2(realdata);*/ |
| | | /*32*/ |
| | | List list= subService.getList(1000011,1); |
| | | return new Response().setII(1,true,list,null); |
| | | /*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); |
| | | } |
| | | } |