| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.Map; |
| | | |
| | | @Service |
| | | public class Dev6159PowerParamService { |
| | | @Autowired(required = false) |
| | |
| | | PageHelper.startPage(1,1); |
| | | QueryWrapper queryWrapper=new QueryWrapper(); |
| | | queryWrapper.eq("dev_id",devId); |
| | | for(int n=0; n<40; n++) |
| | | for(int n=0; n<240; n++) |
| | | { |
| | | |
| | | Dev6159PowerParam parm=mapper.selectOne(queryWrapper); |
| | |
| | | public Response setDev6159Swtich(int devId, String swtichName, int swtichState) { |
| | | QueryWrapper wrapper=new QueryWrapper(); |
| | | wrapper.eq("dev_id",devId); |
| | | wrapper.last(" limi t 1"); |
| | | wrapper.last(" limit 1"); |
| | | Dev6159PowerYx powerYx=yxMapper.selectOne(wrapper); |
| | | UpdateWrapper updateWrapper=new UpdateWrapper(); |
| | | if(powerYx!=null){ |
| | | //刷实时数据 |
| | | updateWrapper.set("k11_state",powerYx.getK11State()); |
| | | updateWrapper.set("k12_state",powerYx.getK12State()); |
| | | updateWrapper.set("k13_state",powerYx.getK13State()); |
| | | updateWrapper.set("k14_state",powerYx.getK14State()); |
| | | updateWrapper.set("k15_state",powerYx.getK15State()); |
| | | updateWrapper.set("k16_state",powerYx.getK16State()); |
| | | updateWrapper.set("k17_state",powerYx.getK17State()); |
| | | updateWrapper.set("k18_state",powerYx.getK18State()); |
| | | updateWrapper.set("dk11_ctl",powerYx.getK11State()); |
| | | updateWrapper.set("dk12_ctl",powerYx.getK12State()); |
| | | updateWrapper.set("dk13_ctl",powerYx.getK13State()); |
| | | updateWrapper.set("dk14_ctl",powerYx.getK14State()); |
| | | updateWrapper.set("dk15_ctl",powerYx.getK15State()); |
| | | updateWrapper.set("dk16_ctl",powerYx.getK16State()); |
| | | updateWrapper.set("dk17_ctl",powerYx.getK17State()); |
| | | updateWrapper.set("dk18_ctl",powerYx.getK18State()); |
| | | }else{ |
| | | updateWrapper.set("k11_state",0); |
| | | updateWrapper.set("k12_state",0); |
| | | updateWrapper.set("k13_state",0); |
| | | updateWrapper.set("k14_state",0); |
| | | updateWrapper.set("k15_state",0); |
| | | updateWrapper.set("k16_state",0); |
| | | updateWrapper.set("k17_state",0); |
| | | updateWrapper.set("k18_state",0); |
| | | updateWrapper.set("dk11_ctl",0); |
| | | updateWrapper.set("dk12_ctl",0); |
| | | updateWrapper.set("dk13_ctl",0); |
| | | updateWrapper.set("dk14_ctl",0); |
| | | updateWrapper.set("dk15_ctl",0); |
| | | updateWrapper.set("dk16_ctl",0); |
| | | updateWrapper.set("dk17_ctl",0); |
| | | updateWrapper.set("dk18_ctl",0); |
| | | } |
| | | updateWrapper.set(swtichName.toString(),swtichState); |
| | | updateWrapper.eq("dev_id",devId); |
| | | int flag=mapper.update((Dev6159PowerParam) ActionUtil.objeNull,updateWrapper); |
| | | mapper.update((Dev6159PowerParam) ActionUtil.objeNull,updateWrapper); |
| | | //设置自己修改的开关 |
| | | String swtichSql=" UPDATE db_ram_db.tb_dev6159_power_param SET "+swtichName+"="+swtichState+" WHERE dev_id ="+devId; |
| | | int flag=mapper.updateSwtichName(swtichSql); |
| | | boolean bl=false; |
| | | if(flag>0){ |
| | | bl=send6159CmdToDev(FBS9100_ComBase.CMD_ControlDKSwitch,devId); |