| | |
| | | //SNç åè½¦æ¹æ³ |
| | | $('#HBarcode_SN').on('keydown', function (event) { |
| | | if (event.keyCode == 13) { |
| | | get_FastQuery(2); |
| | | } |
| | | //get_FastQuery(2); |
| | | $('#HBarcode_SN').val($('#HBarcode_SN').val() + ',') |
| | | //console.log($('#HBarcode_SN').val()); |
| | | } |
| | | }); |
| | | |
| | | //æ æ¿ç åè½¦æ¹æ³ |
| | |
| | | // sWhere += " and DSN like '%" + HBarcode_SN + "%'"; |
| | | //} |
| | | if (HBarcode_SN) { |
| | | HBarcode_SN = HBarcode_SN.substring(0, HBarcode_SN.length - 1) |
| | | HBarcode_SN = HBarcode_SN.replace(/ï¼/g, ',') |
| | | .split(',') |
| | | .map(item => `'${item.trim()}'`) |
| | |
| | | if (HBarcode_ZX) { |
| | | sWhere += "and ä¸ç®±ç like '%" + HBarcode_ZX + "%'"; |
| | | } |
| | | //if (HDate) { |
| | | // sWhere += " and CONVERT(varchar(100),çäº§æ¥æ, 23) >= '" + HDate + "'"; |
| | | //} |
| | | //if (HDate1) { |
| | | // sWhere += " and CONVERT(varchar(100),çäº§æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | //} |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),çäº§æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),çäº§æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |