chenhaozhe
2026-04-14 909594494a1e9b6b4e8919c0268c2aebec16151b
WebTM/views/³µ¼ä¹ÜÀí/µ¥Æ·¹ýÕ¾_СÎÀ/Cj_ProcessItemStationPlatform_UnbindList.html
@@ -32,25 +32,37 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">工单号</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HICMOBillNo" id="HICMOBillNo">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HICMOBillNo" id="HICMOBillNo" onfocus="this.select();">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">SN码</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_SN" id="HBarcode_SN">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_SN" id="HBarcode_SN" onfocus="this.select();">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">栈板码</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_ZB" id="HBarcode_ZB">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_ZB" id="HBarcode_ZB" onfocus="this.select();">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">中箱码</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBarcode_ZX" id="HBarcode_ZX">
                                        <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>
@@ -185,7 +197,7 @@
            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
@@ -306,16 +318,48 @@
            });
            //#endregion
            //工单号回车方法
            $('#HICMOBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery(2);
                }
            });
            //SN码回车方法
            $('#HBarcode_SN').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    //get_FastQuery(2);
                    $('#HBarcode_SN').val($('#HBarcode_SN').val() + ',')
                    //console.log($('#HBarcode_SN').val());
                }
            });
            //栈板码回车方法
            $('#HBarcode_ZB').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery(2);
                }
            });
            //中箱码回车方法
            $('#HBarcode_ZX').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery(2);
                }
            });
            //#endregion
            //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„æ–¹æ³•
            //#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();
                //查询
                get_FastQuery(1);
                //get_FastQuery(1);
            }
            //#endregion
@@ -425,6 +469,8 @@
                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();//复选框
@@ -500,16 +546,33 @@
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HICMOBillNo) {
                    sWhere += " and ç”Ÿäº§è®¢å•号 like '%" + HICMOBillNo + "%'";
                    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 + "%'";
                    sWhere += "and  æ ˆæ¿ç  like '%" + HBarcode_ZB + "%'";
                }
                if (HBarcode_ZX) {
                    sWhere += " and ä¸­ç®±ç  like '%" + 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);
@@ -523,6 +586,8 @@
                $("#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");
@@ -533,7 +598,8 @@
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                form.render('select');
                get_FastQuery("")
                sWhere = "";
            }
            //#endregion
@@ -549,7 +615,7 @@
                            item[itemobj] = "";
                        }
                        if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                            item[itemobj] = item[itemobj].toString().replaceALL(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                            item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '').replace(/[\r\n]+/g, '').replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                        }
                    }
                });