1

zrg

2024-06-24 87c39697d9f0bf17ac97e241158f43c64e23e117

 WebTM/views/Ä£Öξ߹ÜÀí/Ä£Öξ߹ÜÀí/Gy_BarCodeBillList.html

@@ -67,9 +67,20 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">源单单号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HSourceBillNo" id="HSourceBillNo">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">物料名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName">
                                    </div>
                                </div> <div class="layui-inline">
                                    <label class="layui-form-label">物料代码</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
@@ -251,6 +262,8 @@
                    case 'btn-reload':
                        $("#HBarCode").val("");
                        $("#HMaterName").val("");
                        $("#HSourceBillNo").val("");
                        $("#HMaterNumber").val("");
                        sWhere = "";
                        get_Display(sWhere);
                        break;
@@ -308,7 +321,9 @@
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //结束日期
                $("#HBarCode").val("");
                $("#HSourceBillNo").val("");
                $("#HMaterName").val("");
                $("#HMaterNumber").val("");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
@@ -323,7 +338,9 @@
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBarCode = $("#HBarCode").val();
                var HSourceBillNo = $("#HSourceBillNo").val();
                var HMaterName = $("#HMaterName").val();
                var HMaterNumber = $("#HMaterNumber").val();                
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
@@ -350,17 +367,24 @@
                    sWhere += " and " + ColName + " " + com;
                }
                if (HBeginDate) {
                    sWhere += " and CONVERT(varchar(100),生产日期, 23) >= '" + HBeginDate + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HBeginDate + "'";
                }
                if (HEndDate) {
                    sWhere += " and CONVERT(varchar(100),生产日期, 23) <= '" + HEndDate + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HEndDate + "'";
                }
                if (HBarCode) {
                    sWhere += " and æ¡ç ç¼–号 like '" + HBarCode + "'";
                    sWhere += " and æ¡ç ç¼–号 like '%" + HBarCode + "%'";
                }
                if (HMaterName) {
                    sWhere += " and ç‰©æ–™åç§° like'" + HMaterName + "'";
                    sWhere += " and ç‰©æ–™åç§° like'%" + HMaterName + "%'";
                }
                if (HMaterNumber) {
                    sWhere += " and ç‰©æ–™ä»£ç  like'%" + HMaterNumber + "%'";
                }                
                if (HSourceBillNo) {
                    sWhere += " and æºå•å•å· like '%" + HSourceBillNo + "%'";
                }

                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            });