| | |
| | | * 固定值 |
| | | */ |
| | | @ApiModelProperty("固定值") |
| | | private Double fixValue; |
| | | private String fixValue; |
| | | } |
| | |
| | | String retStr = "-1"; |
| | | switch (key) { |
| | | case "EQUAL": //等于 |
| | | retStr = " is null OR = '' "; |
| | | retStr = " is null"; |
| | | break; |
| | | case "UNEQUAL": //不等于 |
| | | retStr = " is not null "; |
| | |
| | | varStr = "concat(" + varStr +") AS val"; |
| | | |
| | | if (StringUtil.isNotBlank(rules.getIsGate())) { |
| | | sqlStr += " and a.\"is_gate\" = " + rules.getIsGate(); |
| | | |
| | | String gateStr = rules.getIsGate().equals("1") ?"'有闸水库'":"'无闸水库'"; |
| | | |
| | | sqlStr += " and a.\"is_gate\" = " + gateStr; |
| | | } |
| | | |
| | | // 拼接条件有问题,不操作 |
| | |
| | | ( |
| | | res_id,rule_id,rule_name,rule_description,create_time,update_time,val, |
| | | is_gate,eng_scal,is_danger,town_code,town_name,county_code,county_name,city_code,city_name, |
| | | res_reg_code,res_name,rz,tb_weir_top_elevation,tb_norm_pool_stag,tb_control_z,tb_des_fl_stag,tb_dam_top_elevation,tb_dead_stag,remark |
| | | res_reg_code,res_name,rz,tb_weir_top_elevation,tb_flse_lim_stag,tb_norm_pool_stag,tb_control_z,tb_des_fl_stag,tb_dam_top_elevation,tb_dead_stag,remark |
| | | ) |
| | | select |
| | | distinct |
| | |
| | | a."name" as res_name, |
| | | f."rz" as rz, |
| | | g."tb_weir_top_elevation", |
| | | d2."tb_flse_lim_stag", |
| | | c."tb_norm_pool_stag", |
| | | b."tb_control_z", |
| | | c."tb_des_fl_stag", |
| | |
| | | import lombok.AllArgsConstructor; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | @Service |
| | | @AllArgsConstructor |
| | |
| | | } |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public Integer addQualityManage(Long ruleId, String varStr, String whereStr) { |
| | | |
| | | qualityManageDetailService.saveQualityManageDetail(ruleId,varStr,whereStr); |