controller
@ApiOperation(value="保存汇流修改数据",notes = "post")
@RequestMapping("/remitSSave")
public BusinessResult remitSSave(@RequestBody JSONObject remitParam) {
BusinessResult result = modelService.remitSSave(remitParam);
return result;
}
service
/**
* 保存汇流修改数据
*
* @return
*/
@Transactional
@Override
public BusinessResult remitSSave(JSONObject remitParam) {
//返回河道水位数据信息
List<TRiverparaEntity> tRiverparaEntities = tRiverparaDao.selectList(null);
//如果有插入过非默认参数,就删除然后插入
if (tRiverparaEntities.size() > 1) {
QueryWrapper<TRiverparaEntity> t = new QueryWrapper<>();
t.eq("nh_default", 0);
int delete = tRiverparaDao.delete(t);
}
String RiverLevel = JSONObject.toJSONString(remitParam.get("RiverLevel"));
//将参数json对象转换成对象
TRiverparaEntity tRiverparaEntity = JSONObject.parseObject(RiverLevel, TRiverparaEntity.class);
tRiverparaEntity.setNhDefault(0);
int insert = tRiverparaDao.insert(tRiverparaEntity);
//插入节点初始水位修改
String nodeLevel = JSONObject.toJSONString(remitParam.get("nodeLevel"));
//将参数对象转换成集合
List<TNodeEntity> tNodeEntitys = JSONObject.parseArray(nodeLevel, TNodeEntity.class);
//将集合里的数据循环取出
for (TNodeEntity tNodeEntity : tNodeEntitys) {
QueryWrapper<TNodeEntity> tNodeEntityQueryWrapper = new QueryWrapper<>();
//根据节点编号修改数据
tNodeEntityQueryWrapper.eq("node_index", tNodeEntity.getNodeIndex());
int insert1 = tNodeDao.update(tNodeEntity, tNodeEntityQueryWrapper);
}
//修改水位边界水位
//将修改的水位边界值数据转成String
String riverBoundrayS = JSONObject.toJSONString(remitParam.get("riverBoundray"));
//将String转成集合对象
List<TFragmentEntity> riverBoundrays = JSONObject.parseArray(riverBoundrayS, TFragmentEntity.class);
//取出集合每一个对象进行修改
for (TFragmentEntity riverBoundray : riverBoundrays) {
QueryWrapper<TFragmentEntity> riverBoundrayw = new QueryWrapper<>();
riverBoundrayw.eq("frag_index", riverBoundray.getFragIndex())
.eq("river_index", riverBoundray.getRiverIndex())
.eq("bOuterTyperWater", riverBoundray.getBoutertyperwater());
int insert2 = tFragmentDao.update(riverBoundray, riverBoundrayw);
}
//修改流量边界水位
//将修改的流量边界值数据转成String
String flowBoundraysS = JSONObject.toJSONString(remitParam.get("flowBoundrays"));
//将String转成集合对象
List<TFragmentEntity> flowBoundrays = JSONObject.parseArray(flowBoundraysS, TFragmentEntity.class);
//取出集合每一个对象进行修改
for (TFragmentEntity flowBoundray : flowBoundrays) {
QueryWrapper<TFragmentEntity> tFragmentEntityQueryWrapper = new QueryWrapper<>();
tFragmentEntityQueryWrapper.eq("frag_index", flowBoundray.getFragIndex())
.eq("river_index", flowBoundray.getRiverIndex())
.eq("bOuterTyperWater", flowBoundray.getBoutertyperwater());
int insert3 = tFragmentDao.update(flowBoundray, tFragmentEntityQueryWrapper);
}
return new BusinessResult.Builder().isSuccess(true).message("修改成功").build();
}