| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_ZX" id="HBarcode_ZX" onfocus="this.select();"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:110px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:110px;"> |
| | | </div> |
| | | </div> |
| | | |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | |
| | | var titleData = ["hmainid","hsubid","HProdOrgID"]; |
| | | |
| | | //#region ã卿è·å模ååç§°ã |
| | | var HModuleType = ""; |
| | | var HModuleType = "Cj_ProcessItemStationPlatform_UnbindList"; |
| | | //éè¿åæ®ç±»åï¼ä»æ°æ®åºå¨æè·ååæ®æ¨¡åå½å,å¼ç¨jsæä»¶ PageTitle.js |
| | | var HPageTitle = get_PageTitle(HModuleType) == "" ? document.title : get_PageTitle(HModuleType); |
| | | //#endregion |
| | |
| | | //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()); |
| | | } |
| | | }); |
| | | |
| | | //æ æ¿ç åè½¦æ¹æ³ |
| | |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - (1000 * 60 * 60 * 24 * 7)), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | |
| | | var HBarcode_SN = $("#HBarcode_SN").val(); //SNå· |
| | | var HBarcode_ZB = $("#HBarcode_ZB").val(); //æ æ¿ç |
| | | var HBarcode_ZX = $("#HBarcode_ZX").val(); //ä¸ç®±ç |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | |
| | | //ä»»æåæ®µè¿æ»¤ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | |
| | | sWhere += " and å·¥åç¼å· like '%" + HICMOBillNo + "%'"; |
| | | } |
| | | |
| | | //if (HBarcode_SN) { |
| | | // sWhere += " and DSN like '%" + HBarcode_SN + "%'"; |
| | | //} |
| | | if (HBarcode_SN) { |
| | | sWhere += " and DSN like '%" + HBarcode_SN + "%'"; |
| | | HBarcode_SN = HBarcode_SN.substring(0, HBarcode_SN.length - 1) |
| | | HBarcode_SN = HBarcode_SN.replace(/ï¼/g, ',') |
| | | .split(',') |
| | | .map(item => `'${item.trim()}'`) |
| | | .join(','); |
| | | |
| | | console.log("å¤çç»æ:", HBarcode_SN); |
| | | sWhere += " and DSN in (" + HBarcode_SN + ")"; |
| | | } |
| | | if (HBarcode_ZB) { |
| | | sWhere += "and æ æ¿ç like '%" + HBarcode_ZB + "%'"; |
| | | |
| | | } |
| | | 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 + "'"; |
| | | } |
| | | |
| | | get_Display(sWhere); |
| | |
| | | $("#HBarcode_SN").val(""); |
| | | $("#HBarcode_ZB").val(""); |
| | | $("#HBarcode_ZX").val(""); |
| | | $("#HBeginDate").val(Format(new Date(new Date() - (1000 * 60 * 60 * 24 * 7)), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |