| | |
|---|
| | | String var = Convert.toStr(var1); |
|---|
| | | if (dataBasyType == DataBaseType.SQL_SERVER) { |
|---|
| | | // charindex(',100,' , ',0,100,101,') <> 0 |
|---|
| | | return "charindex('," + var + ",' , ','+" + var2 + "+',') <> 0"; |
|---|
| | | return "charindex(',%s,' , ','+%s+',') <> 0".formatted(var, var2); |
|---|
| | | } else if (dataBasyType == DataBaseType.POSTGRE_SQL) { |
|---|
| | | // (select position(',100,' in ',0,100,101,')) <> 0 |
|---|
| | | return "(select position('," + var + ",' in ','||" + var2 + "||',')) <> 0"; |
|---|
| | | return "(select position(',%s,' in ','||%s||',')) <> 0".formatted(var, var2); |
|---|
| | | } else if (dataBasyType == DataBaseType.ORACLE) { |
|---|
| | | // instr(',0,100,101,' , ',100,') <> 0 |
|---|
| | | return "instr(','||" + var2 + "||',' , '," + var + ",') <> 0"; |
|---|
| | | return "instr(','||%s||',' , ',%s,') <> 0".formatted(var2, var); |
|---|
| | | } |
|---|
| | | // find_in_set(100 , '0,100,101') |
|---|
| | | return "find_in_set(" + var + " , " + var2 + ") <> 0"; |
|---|
| | | return "find_in_set(%s , %s) <> 0".formatted(var, var2); |
|---|
| | | } |
|---|
| | | } |
|---|
