| | |
|---|
| | | String retStr = "-1"; |
|---|
| | | switch (key) { |
|---|
| | | case "EQUAL": //等于 |
|---|
| | | retStr = " is null OR = '' "; |
|---|
| | | retStr = " is null"; |
|---|
| | | break; |
|---|
| | | case "UNEQUAL": //不等于 |
|---|
| | | retStr = " is not null "; |
|---|
| | |
|---|
| | | } else if (rc.getRelation().equals("OR")) { |
|---|
| | | relation = " OR "; |
|---|
| | | } else { |
|---|
| | | relation = " WHERE "; |
|---|
| | | relation = " WHERE ("; |
|---|
| | | } |
|---|
| | | |
|---|
| | | sqlStr += relation + getPropSqlStr(rc.getBasic()); |
|---|
| | |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | sqlStr += ")"; |
|---|
| | | |
|---|
| | | 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; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 拼接条件有问题，不操作 |
|---|
| | |
|---|
| | | log.info("查询条件错误，请检查规则设置......：", sqlStr); |
|---|
| | | return R.fail(-1, sqlStr + "\\n 查询条件错误，请检查规则设置"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | Integer ret = 0; |
|---|
| | | try { |
|---|
| | |
|---|
| | | log.info("执行完成......："); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 执行sql |
|---|
| | | // 执行sql |
|---|
| | | return R.data(ret); |
|---|
| | | } |
|---|
| | | } |
|---|
