| | |
| | | com1 = "" + Comparator1 + "'" + ColContent1 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName1 + " " + com1; |
| | | sqlWhere += " and " + ColName1 + " " + com1; |
| | | } |
| | | if (ColName2 != 0 && Comparator2 != 0) { |
| | | var com2 = ""; |
| | |
| | | com2 = "" + Comparator2 + "'" + ColContent2 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | sqlWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | if (HBillNo) |
| | | sqlWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | if (itemobj === 'è§æ ¼åå·') { |
| | | item[itemobj] = item[itemobj].replace(/,/g, 'ï¼'); // æ¿æ¢è±æéå·ä¸ºä¸æéå· |
| | | } |
| | | } |
| | | }); |
| | | |