yangle
2023-02-08 3b4c230bbd4673f5b826bc01d52f84d38bc732c8
日计划维护
6个文件已修改
301 ■■■■ 已修改文件
WebTM/views/生产管理/生产日计划工单/JIT_DayPlanBillEdit.html 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/生产日计划工单/JIT_DayPlanBillList.html 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/生产计划平台/JIT_DayPlanPlatForm.html 82 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/生产计划平台/JIT_DayPlanPlatFormImport.html 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/计划管理/工艺路线/Gy_RoutingBill.html 88 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/计划管理/工艺路线/Gy_RoutingBillList.html 117 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/Éú²ú¹ÜÀí/Éú²úÈռƻ®¹¤µ¥/JIT_DayPlanBillEdit.html
@@ -938,6 +938,7 @@
                $.ajax({
                    type: "get",
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    async: false,
                    success: function (result) {
                        if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            var data = result.data;
WebTM/views/Éú²ú¹ÜÀí/Éú²úÈռƻ®¹¤µ¥/JIT_DayPlanBillList.html
@@ -391,19 +391,21 @@
        function set_DeleteBill() {
            var CheckStatus = table.checkStatus("mainTable");
            if (CheckStatus.data.length != 1) {
                return layer.msg("请选择一条数据!")
            if (CheckStatus.data.length == 0) {
                return layer.msg("请选择数据!")
            } else {
                layer.confirm('您确定要删除吗?', {
                    btn: ['确定', '取消'] //按钮
                    , btn1: function () {
                        var HInterID = CheckStatus.data[0].hmainid; //获取编号
                        var HEntryID = CheckStatus.data[0].hsubid; //获取第几条子数据
                        var HInterID = [];
                        for (var i = 0; i < CheckStatus.data.length; i++) {
                            HInterID.push(CheckStatus.data[i].hmainid + "_" + CheckStatus.data[i].hsubid)
                        }
                        $.ajax({
                            url: GetWEBURL() + '/Sc_WorkBillSortBill/DelWorkBillSortBillList'
                            , type: "GET"
                            , data: { "HInterID": HInterID, "HEntryID": HEntryID, "User": sessionStorage["HUserName"] }
                            , data: { "HInterID": HInterID.toString(), DataType: "1", "User": sessionStorage["HUserName"] }
                            , success: function (result) {
                                if (result.count == 1) {
                                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
WebTM/views/Éú²ú¹ÜÀí/Éú²ú¼Æ»®Æ½Ì¨/JIT_DayPlanPlatForm.html
@@ -148,6 +148,10 @@
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <!--<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>-->
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>
    var treeCkData = { id: 0 };
    var TagId = "";
@@ -244,6 +248,10 @@
                case 'set_HideColumn':
                    get_HideColumn();
                    break;
                //删除行
                case 'set_DeleteBill':
                    set_DeleteBill();
                    break;
            }
        });
@@ -296,6 +304,7 @@
        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
            set_GridCellCheck(obj); //行内快捷键筛选
        });
@@ -531,6 +540,7 @@
            columns.push({ field: '拆单数量', title: '拆单数量', width: 150 });//0
            columns.push({ field: '订单可排数量', title: '订单可排数量', width: 150 });
            columns.push({ field: '未入库数量', title: '未入库数量', width: 150 });//0
            columns.push({ fixed: 'right', title: '操作', toolbar: '#barDemo' });
            option = {
                elem: '#mainTable'
@@ -894,14 +904,15 @@
                    }
                    //获取数据
                    var hmainid = [];
                    var HEntryID = [];
                    //var HEntryID = [];
                    for (var i = 0; i < checkStatus.data.length; i++) {
                        hmainid.push(checkStatus.data[i]["hmainid"]);
                        HEntryID.push(checkStatus.data[i]["HEntryID"]);
                        if ($.inArray(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"], hmainid)==-1) {
                            hmainid.push(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"]);
                        }
                    }
                    //查询生产订单
                    SelectICMOBill(hmainid, HEntryID);
                    SelectICMOBill(hmainid);
                    layer.close(index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                }
@@ -910,12 +921,12 @@
        }
        //查询生产订单
        function SelectICMOBill(hmainid, HEntryID) {
        function SelectICMOBill(hmainid) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_ICMOBillList',
                type: "GET",
                data: { "hmainid": hmainid.toString(), "HEntryID": HEntryID.toString() },
                data: { "hmainid": hmainid.toString() },
                success: function (data1) {
                    if (data1.count == 1) {
                        var dataPush = [];
@@ -954,6 +965,65 @@
            });
        }
        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗?', function (index) {
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除!!!');
                    } else {
                        obj.del();
                        option.data = table.cache["mainTable"];//将数据绑定到data上
                        //table.reload(option);
                        layer.close(index);
                    }
                });
            }
        }
        //删除行
        function set_DeleteBill() {
            var CheckStatus = table.checkStatus("mainTable");
            if (CheckStatus.data.length == 0) {
                return layer.msg("请选择数据!")
            } else {
                layer.confirm('您确定要删除吗?', {
                    btn: ['确定', '取消'] //按钮
                    , btn1: function () {
                        var HInterID = [];
                        for (var i = 0; i < CheckStatus.data.length; i++) {
                            HInterID.push(CheckStatus.data[i].hmainid); //获取编号
                        }
                        $.ajax({
                            url: GetWEBURL() + '/Sc_WorkBillSortBill/DelWorkBillSortBillList'
                            , type: "GET"
                            , data: { "HInterID": HInterID.toString(), DataType: "2", "User": sessionStorage["HUserName"] }
                            , success: function (result) {
                                if (result.count == 1) {
                                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                        // å¾—到frame索引
                                        var index = layer.getFrameIndex(window.name);
                                        //关闭当前frame
                                        layer.close(index);
                                        //修改为功后刷新界面
                                        window.location.reload();
                                        ////重载tree
                                        //tree.reload('treeDepartment', {});
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                            }
                        })
                    }
                })
            }
        }
        //保存
        function set_AddNew(data) {
WebTM/views/Éú²ú¹ÜÀí/Éú²ú¼Æ»®Æ½Ì¨/JIT_DayPlanPlatFormImport.html
@@ -240,6 +240,7 @@
            columns.push({ field: '总齐套数量', title: '总齐套数量', width: 200 });
            columns.push({ field: 'ICMOBillHInterID', title: 'ICMOBillHInterID', hide: true});
            columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', hide: true });
            columns.push({ field: 'HProdORGID', title: 'HProdORGID', hide: true });
            for (var i = 0; i <= (SumMonth - dd); i++) {
                columns.push({ field: Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (dd + i), 'MM.dd'), edit: 'text', width:60 })
            }
WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBill.html
@@ -290,13 +290,13 @@
                                        <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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hmakers" id="hmakers" style="background-color:#efefef4d;" readonly>
                                            </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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hchecker" id="hchecker" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -310,13 +310,13 @@
                                        <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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hmakedate" id="hmakedate" style="background-color:#efefef4d;" readonly>
                                            </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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hcheckdate" id="hcheckdate" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -336,13 +336,13 @@
                                        <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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hupdater" id="hupdater" style="background-color:#efefef4d;" readonly>
                                            </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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hdeleteman" id="hdeleteman" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                    </div>
@@ -356,13 +356,13 @@
                                        <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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hupdatedate" id="hupdatedate" style="background-color:#efefef4d;" readonly>
                                            </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" name="" id="" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="hdeletedate" id="hdeletedate" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                    </div>
@@ -407,14 +407,14 @@
    <!--复选框 ä¸‹é“流转工序-->
    <script type="text/html" id="HNextProcFlag">
        <div class="layui-input-block" style="margin-left: 20px;">
            <input type="checkbox" name="HNextProcFlag" lay-filter="HNextProcFlag" id="HNextProcFlag{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
            <input type="checkbox" name="HNextProcFlag" disabled="disabled"  lay-filter="HNextProcFlag" id="HNextProcFlag{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
        </div>
    </script>
    <!--复选框 æµè½¬å·¥åº-->
    <script type="text/html" id="HFlowProc">
        <div class="layui-input-block" style="margin-left: 20px;">
            <input type="checkbox" name="HFlowProc" lay-filter="HFlowProc" id="HFlowProc{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
            <input type="checkbox" name="HFlowProc" disabled="disabled" lay-filter="HFlowProc" id="HFlowProc{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
        </div>
    </script>
@@ -485,7 +485,7 @@
                    , { field: 'HProcID_S', title: '工段', edit: 'text' }
                    , { field: 'HProcType', title: '工序类型', templet: '#HProcType' }//选择
                    , { field: 'HCenterID_SName', title: '产线中心', edit: 'text', event: "CheckHCenterID_S" }//f7
                    //, { field: 'HCenterID_S', title: '产线中心id', hide: true }//hide: true
                    , { field: 'HCenterID_S', title: '产线中心id', hide: true }//hide: true
                    , { field: 'HWorkQty_S', title: '产线产能', edit: 'text' }
                    , { field: 'HSubStdEmpQty_S', title: '产线人数', edit: 'text' }
                    , { field: 'HMouldNo', title: '模具编号', edit: 'text' }
@@ -496,11 +496,11 @@
                    , { field: 'HMyWorkDays', title: '生产周期', edit: 'text' }
                    , { field: 'HMyFixWorkDays', title: '固定生产天数', edit: 'text' }
                    , { field: '工序', title: '工序', edit: 'text', event: "CheckHProcID" }//f7
                    //, { field: 'HProcID', title: '工序ID', hide: true }//, hide: true
                    , { field: 'HProcID', title: '工序ID', hide: true }//, hide: true
                    , { field: '工作中心代码', title: '工作中心代码' }//不填
                    //, { field: 'HCenterID', title: '工作中心id', hide: true }//, hide: true
                    , { field: 'HCenterID', title: '工作中心id', hide: true }//, hide: true
                    , { field: '工作中心', title: '工作中心', edit: 'text', event: "CheckHCenterID" }//f7
                    //, { field: 'HSupID', title: '供应商ID', hide: true }
                    , { field: 'HSupID', title: '供应商ID', hide: true }
                    , { field: '供应商代码', title: '供应商代码' }
                    , { field: '供应商', title: '供应商', edit: 'text', width: 110, event: "CheckHSupID" }//f7
                    , { field: 'HSupFlag', title: '外协标记', templet: "#HSupFlag" }//checkbox
@@ -595,7 +595,7 @@
            }
            else if (OperationType == 2) {
                //禁用组织选项
                $("#HOrgID").attr("disabled", true);
                //$("#HOrgID").attr("disabled", true);
                RoadBillMain(linterid);
                $.ajax({
                    url: GetWEBURL() + "/Web/GetMAXNum",
@@ -851,6 +851,22 @@
            });
            //行内鼠标离开事件
            table.on('edit(mainTable)', function (obj) {
                if (obj.field == "HProcNo") {
                    var num = 0;
                    for (var i = 0; i < option.data.length; i++) {
                        if (obj.value == option.data[i]["HProcNo"]) {
                            num += 1;
                        }
                        if (num > 1) {
                            layer.msg("流水号:" + obj.value + "重复!");
                            return false;
                        }
                    }
                }
            })
            $('#HName').on('keydown', function (event) {//工艺路线名称
                if (event.keyCode == 118) {
                    layer.msg("工艺路线名称F7按钮")
@@ -1079,6 +1095,8 @@
                        $("#HMaterName").val(checkStatus.data[0].HName);//物料名称
                        $("#HMaterNumber").val(checkStatus.data[0].HNumber);//物料代码
                        $("#HMaterModel").val(checkStatus.data[0].HModel);//规格型号
                        $("#HUnitID").val(checkStatus.data[0].HUnitID);//计量单位id
                        $("#HUnitName").val(checkStatus.data[0].HUnitName);//计量单位名称
                        layer.close(index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                    }
@@ -1352,7 +1370,7 @@
                                , shift: 2 //弹出动画
                                , area: ["90%", "90%"] //窗体大小
                                , maxmin: true //设置最大最小按钮是否显示
                                , content: ["../../Baseset/基础资料/Gy_SupplierList.html", "yes"]
                                , content: ["../../基础资料/采购基础资料/Gy_Supplier.html", "yes"]
                                , btn: ["确定", "取消"]
                                , btn1: function (index, laero) {
                                    //按钮一  çš„回调
@@ -1364,9 +1382,9 @@
                                    }
                                    //更新表格缓存的数据
                                    obj.update({
                                        "供应商": checkStatus.data[0].HName
                                        "供应商": checkStatus.data[0].供应商名称
                                        , "HSupID": checkStatus.data[0].HItemID
                                        , "供应商代码": checkStatus.data[0].HNumber
                                        , "供应商代码": checkStatus.data[0].供应商代码
                                    })
                                    layer.close(index);//关闭弹窗
                                }
@@ -1396,6 +1414,9 @@
                        var IsHStopflag = d.data[0].默认工艺;
                        if (IsHStopflag == 1) {
                            $("input[name='checkboxHStandard']").prop("checked", true);
                        }
                        else {
                            $("input[name='checkboxHStandard']").prop("checked", false);
                        }
                        //主表
                        form.val("formData", { //formTest å³ class="layui-form" æ‰€åœ¨å…ƒç´ å±žæ€§ lay-filter="" å¯¹åº”的值
@@ -1430,6 +1451,15 @@
                            , "HProductNum": d.data[0].成品编号
                            , "HVerNum": d.data[0].版本
                            , "HOrgID": d.data[0].HOrgID
                            //其他信息
                            , "hmakers": d.data[0].制单人
                            , "hmakedate": d.data[0].制单日期==null?"":Format(new Date(d.data[0].制单日期), "yyyy-MM-dd")
                            , "hchecker": d.data[0].审核人
                            , "hcheckdate": d.data[0].审核日期 == null ? "" : Format(new Date(d.data[0].审核日期), "yyyy-MM-dd")
                            , "hupdater": d.data[0].修改人
                            , "hupdatedate": d.data[0].修改日期 == null ? "" : Format(new Date(d.data[0].修改日期), "yyyy-MM-dd")
                            , "hdeleteman": d.data[0].作废人
                            , "hdeletedate": d.data[0].作废日期 == null ? "" :Format(new Date(d.data[0].作废日期), "yyyy-MM-dd")
                        });
                        //子表  èµ‹å€¼
@@ -1548,21 +1578,17 @@
                //    layer.msg("生产班组没有选择");
                //    return false;
                //}
                var num = [];
                for (var i = 0; i < option.data.length; i++) {
                    if ($.inArray(option.data[i]["HProcNo"], num) == -1) {
                        num.push(option.data[i]["HProcNo"]);
                    } else {
                        layer.msg("流水号:" + option.data[i]["HProcNo"] + "重复!");
                        return false;
                    }
                }
                return true;
                //if ($("#HBillNo").val() == '') {
                //    layer.msg("错误的单据号", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                //    return false;
                //}
                //if ($("#HInterID").val() == '') {
                //    layer.msg("错误的内码", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                //    return false;
                //}
                //if (typeof (sSubStr) == "undefined") {
                //    layer.msg("没有物料明细记录", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                //    return false;
                //}
            }
            //隐藏列设置
WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBillList.html
@@ -35,9 +35,13 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据类型</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HOrderProcNO" id="HOrderProcNO">
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料代码</label>
                                    <div class="layui-input-block" style="margin-left: 77px;">
                                        <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                        <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -56,30 +60,44 @@
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--其他条件-->
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料代码</label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                                </button>
                                            </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" name="HMaterName" id="HMaterName" style="background-color:#efefef4d;" readonly>
                                            <label class="layui-form-label" style="width: 76px;">物料名称</label>
                                            <div class="layui-input-block" style="margin-left: 107px;">
                                                <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
                                            </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" name="HModel" id="HModel" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                </div>
                            </div>
@@ -93,10 +111,10 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-audit"><i class="layui-icon layui-icon-repeat"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Faudit"><i class="layui-icon layui-icon-refresh"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Faudit"><i class="layui-icon layui-icon-refresh"></i>反审核</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -299,10 +317,12 @@
                $("#HMaterNumber").val("");//物料
                $("#HModel").val("");//物料
                $("#HOrderProcNO").val("");//单据类型
                $("#btnSearch").click();
                $("#HName").val("");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                $("#HOrgID").val(sessionStorage["OrganizationID"]);
                form.render('select');
                $("#btnSearch").click();
                sWhere = "";
            }
            //#endregion
@@ -329,8 +349,6 @@
                        }
                        $("#HMaterID").val(checkStatus.data[0].HItemID);
                        $("#HMaterName").val(checkStatus.data[0].HName);
                        $("#HMaterNumber").val(checkStatus.data[0].HNumber);
                        $("#HModel").val(checkStatus.data[0].HModel);
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                    }
                })
@@ -350,6 +368,10 @@
                            option.data = data1.data;
                            table.render(option);
                            layer.close(ajaxLoad);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            layer.close(ajaxLoad);
@@ -367,12 +389,37 @@
            function get_FastQuery(number) {
                var HOrgID = "";
                var HOrderProcNO = $("#HOrderProcNO").val();//单据类型
                var HMaterID = $("#HMaterID").val();
                //var HMaterID = $("#HMaterID").val();
                var HMaterName = $("#HMaterName").val();
                var HMaterNumber = $("#HMaterNumber").val();
                var HModel = $("#HModel").val();
                //var HName = $("#HName").val();
                var WorkCenter = $("#WorkCenter").val();//单据号
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (number == 1) {
                    HOrgID = sessionStorage["OrganizationID"];
@@ -385,7 +432,7 @@
                    sWhere += " and å•据类型 like '%" + HOrderProcNO + "%'";
                }
                if (HMaterName) {
                    sWhere += "and HMaterID=" + HMaterID+"  and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                    sWhere += "and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                }
                if (HMaterNumber) {
                    sWhere += "and  ç‰©æ–™ä»£ç  like '%" + HMaterNumber + "%'";
@@ -636,6 +683,20 @@
                    }
                })
            }
            //#region åˆ—明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
            }
            //#endregion
            //#endregion
            //以上是layui模块