1

ch

2022-04-14 5535e952a9ad15a997a183ed224c7f01e5aacbf2

 WebTM/views/Ä£Öξ߹ÜÀí/Ä£Öξֿ߲â¹ÜÀí/Sc_MouldProdInBillList.html

@@ -30,6 +30,12 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus" lay-filter="HStatus" style="width:190px;">
@@ -52,7 +58,13 @@
                                        <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
                                    </div>
                                </div>
                               
                                <div class="layui-inline">
                                    <label class="layui-form-label">组织名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HStockOrgName" id="HStockOrgName" style="width:190px;">
                                    </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>
                                </button>
@@ -61,12 +73,6 @@
                                    <div class="layui-inline">
                                        <div class="layui-inline">
                                            <span>其他条件></span>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
@@ -85,6 +91,18 @@
                                        <label class="layui-form-label">器具代码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HModelNumber" id="HModelNumber" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">仓库</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HWhName" id="HWhName" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">往来单位</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HSupName" id="HSupName" style="width:190px;">
                                        </div>
                                    </div>
                                </div>
@@ -209,6 +227,7 @@
                    , { field: '使用寿命', title: '使用寿命', width: 200 }
                    , { field: '设计寿命', title: '设计寿命', width: 200 }
                    , { field: '剩余寿命', title: '剩余寿命', width: 200 }
                    , { field: '库存组织', title: '库存组织', width: 125 }
                    , { field: 'HWHID', title: 'HWHID', width: 200, hide: true }
                    , { field: '收料仓库代码', title: '仓库代码', width: 200 }
                    , { field: '收料仓库', title: '仓库名称', width: 200 }
@@ -636,15 +655,18 @@

            }

            //快速过滤
            å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery(table, option) {
                var HStatus = $("select[name='HStatus']").val();//状态
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HStockOrgName = $("#HStockOrgName").val(); //组织
                var HBillNo = $("#HBillNo").val(); //单据号
                var HDept = $("#HDept").val();       //部门信息
                var HMaterNumber = $("#HMaterNumber").val();       //部门信息
                var HModelNumber = $("#HModelNumber").val();       //部门信息
                var HMaterNumber = $("#HMaterNumber").val();   //物料代码    
                var HModelNumber = $("#HModelNumber").val();    //器具代码
                var HWhName = $("#HWhName").val();  //仓库名称
                var HSupName = $("#HSupName").val();    //往来单位
                if (HStatus) {
                    switch (HStatus) {
                        case '-1':   //全部
@@ -668,11 +690,14 @@
                if (HEndDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HEndDate + "'";
                }
                if (HStockOrgName) {
                    sWhere += " and åº“存组织 like '%" + HStockOrgName + "%'";
                }
                if (HBillNo) {
                    sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
                }
                if (HDept) {
                    sWhere += " and éƒ¨é—¨åç§° like '%" + HDept + "%'";
                    sWhere += " and éƒ¨é—¨ like '%" + HDept + "%'";
                }
                if (HMaterNumber) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + HMaterNumber + "%'";
@@ -680,11 +705,18 @@
                if (HModelNumber) {
                    sWhere += " and æ¨¡å…·ä»£ç  like '%" + HModelNumber + "%'";
                }
                if (HWhName) {
                    sWhere += " and æ”¶æ–™ä»“库 like '%" + HWhName + "%'";
                }
                if (HSupName) {
                    sWhere += " and å¾€æ¥å•ä½ like '%" + HSupName + "%'";
                }
                var index = layer.load(0);
                get_Display(sWhere);
                //调用接口后清空sWhere缓存
                sWhere = "";
            }
           
            //重置过滤条件
            function set_ClearQuery() {
                $('#HStatus').find("option[value='-1']").attr("selected", true);
@@ -694,6 +726,9 @@
                $("#HDept").val("");
                $("#HMaterNumber").val("");
                $("#HModelNumber").val("");
                $("#HWhName").val("");
                $("#HSupName").val("");
                $("#HStockOrgName").val("");
                sWhere = "";
                get_Display(sWhere);
            }