| | |
| | | sWhere += " and " + ColName1 + " " + com1; |
| | | } |
| | | |
| | | if (ColName2 != 0 && Comparator2 != 0) { |
| | | var com2 = ""; |
| | | switch (Comparator2) { |
| | | case "7": |
| | | com2 = "like'%" + ColContent2 + "%'"; |
| | | break; |
| | | case "8": |
| | | com2 = "like'%" + ColContent2 + "'"; |
| | | break; |
| | | case "9": |
| | | com2 = "like'" + ColContent2 + "%'"; |
| | | break; |
| | | case "10": |
| | | com2 = "not like'%" + ColContent2 + "%'"; |
| | | break; |
| | | default: |
| | | com2 = "" + Comparator2 + "'" + ColContent2 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | //if (ColName2 != 0 && Comparator2 != 0) { |
| | | // var com2 = ""; |
| | | // switch (Comparator2) { |
| | | // case "7": |
| | | // com2 = "like'%" + ColContent2 + "%'"; |
| | | // break; |
| | | // case "8": |
| | | // com2 = "like'%" + ColContent2 + "'"; |
| | | // break; |
| | | // case "9": |
| | | // com2 = "like'" + ColContent2 + "%'"; |
| | | // break; |
| | | // case "10": |
| | | // com2 = "not like'%" + ColContent2 + "%'"; |
| | | // break; |
| | | // default: |
| | | // com2 = "" + Comparator2 + "'" + ColContent2 + "'"; |
| | | // break; |
| | | // } |
| | | // sWhere += " and " + ColName2 + " " + com2; |
| | | //} |
| | | |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |