器具管理： 保养记录单，点检记录单，上模单，下模单，故障登记单，维修派工单，维修工单，维修验收单 将分页模式，改为 数据库分页。 目前的分页模式，加载...

yangle

2024-12-24 ae825944a2eeb4741b45b989b97e72b0d4408142

器具管理： 保养记录单，点检记录单，上模单，下模单，故障登记单，维修派工单，维修工单，维修验收单 将分页模式，改为 数据库分页。 目前的分页模式，加载数据一多就很慢，需要改为数据库分页模式提高性能 （数据库分页的功能， 杜贺和翁涛涛已编写好 案例， 物料列表 目前就是 数据库分页）

 WebTM/views/Ä£Öξ߹ÜÀí/ÉÏÄ£µ¥/Sc_MouldLowerBillList.html

@@ -140,6 +140,7 @@
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position: relative; bottom: 0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_AddNew" lay-event="set_AddNew"><i class="layui-icon layui-icon-form"></i>新增</button>
@@ -194,6 +195,8 @@
        var option = [];
        var titleData = [];
        var HModName = "Sc_MouldLowerBillList";
        var page = 1;//分页数据
        var size = 50;
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -289,7 +292,11 @@

        //查询
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
            if (page != 1) {
                $("#page a:eq(1)").get(0).click();//点击分页栏第一页
            } else {
                get_FastQuery();
            }
        });

        // é‡ç½®æŒ‰é’®
@@ -304,6 +311,7 @@

        //初始化查询
        function set_ClearBill() {
            set_InitGrid();
            //查询当前登录用户有没有在当前模块设置默认过滤方案
            get_DefaultModule();
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
@@ -402,11 +410,121 @@
                sWhere += GetDataCols;
            }

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

        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 450
                , page: false
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
            }

            optionPage = {
                elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                count: 10000, //数据总数，从服务端得到
                limit: 50,
                limits: [50, 500, 5000, 50000],
                layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                jump: function (obj, first) {

                    //首次不执行
                    if (!first) {
                        //do something
                        page = obj.curr;
                        size = obj.limit;
                        get_FastQuery();
                    }
                }
            }
            laypage.render(optionPage);
        };

        //分页查询
        function get_DisplayPage(sWhere) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Sc_MouldUpperBill/Sc_MouldLowerBillListPage',
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                success: function (data1) {
                    option.limit = size;//改变表格页大小
                    if (data1.code == 1) {
                        optionPage.count = data1.count;//改变列表数据总数
                        var data = [];
                        var col = [];
                        //给空的数组赋值
                        for (var key in data1.list) {
                            //动态获取列表所有列名
                            data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            //获取不需要显示的列（H开头的列不显示）
                            var patrn = new RegExp(/^h/i);
                            if (patrn.test(data1.list[key].ColmCols)) {
                                titleData[key] = data1.list[key].ColmCols;
                            }
                        }
                        //在列表左边添加勾选框
                        col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                        for (var i = 0; i < data.length; i++) {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else {
                                switch (data[i].Type) {
                                    //int
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                        break;
                                    case 'Decimal':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                        break;
                                    case 'Int32':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                }
                            }
                        }

                        columns = col;
                        option.cols = [col];
                        option.data = data1.data;
                        option.totalRow = true;
                        laypage.render(optionPage);

                        //刷新表格数据
                        DisPlay_HideColumn();

                        layer.close(ajaxLoad);
                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }

                        //刷新按钮显示
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        var HBillType = "3847";
                        Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });
        }

        //查询
        function get_Display(sWhere) {
            var ajaxLoad = layer.load();

 WebTM/views/Ä£Öξ߹ÜÀí/ÉÏÄ£µ¥/Sc_MouldUpperBillList.html

@@ -140,6 +140,7 @@
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position: relative; bottom: 0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_AddNew" lay-event="set_AddNew"><i class="layui-icon layui-icon-form"></i>新增</button>
@@ -194,6 +195,8 @@
        var option = [];
        var titleData = [];
        var HModName = "Sc_MouldUpperBillList";
        var page = 1;//分页数据
        var size = 50;
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -289,7 +292,11 @@

        //查询
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
            if (page != 1) {
                $("#page a:eq(1)").get(0).click();//点击分页栏第一页
            } else {
                get_FastQuery();
            }
        });
     
        // é‡ç½®æŒ‰é’®
@@ -304,12 +311,123 @@

        //初始化查询
        function set_ClearBill() {
            set_InitGrid();
            //查询当前登录用户有没有在当前模块设置默认过滤方案
            get_DefaultModule();
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            //get_FastQuery();
        }

        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 450
                , page: false
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
            }

            optionPage = {
                elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                count: 10000, //数据总数，从服务端得到
                limit: 50,
                limits: [50, 500, 5000, 50000],
                layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                jump: function (obj, first) {

                    //首次不执行
                    if (!first) {
                        //do something
                        page = obj.curr;
                        size = obj.limit;
                        get_FastQuery();
                    }
                }
            }
            laypage.render(optionPage);
        };

        //分页查询
        function get_DisplayPage(sWhere) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Sc_MouldUpperBill/Sc_MouldUpperBillListPage',
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                success: function (data1) {
                    option.limit = size;//改变表格页大小
                    if (data1.code == 1) {
                        optionPage.count = data1.count;//改变列表数据总数
                        var data = [];
                        var col = [];
                        //给空的数组赋值
                        for (var key in data1.list) {
                            //动态获取列表所有列名
                            data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            //获取不需要显示的列（H开头的列不显示）
                            var patrn = new RegExp(/^h/i);
                            if (patrn.test(data1.list[key].ColmCols)) {
                                titleData[key] = data1.list[key].ColmCols;
                            }
                        }
                        //在列表左边添加勾选框
                        col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                        for (var i = 0; i < data.length; i++) {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else {
                                switch (data[i].Type) {
                                    //int
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                        break;
                                    case 'Decimal':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                        break;
                                    case 'Int32':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                }
                            }
                        }

                        columns = col;
                        option.cols = [col];
                        option.data = data1.data;
                        option.totalRow = true;
                        laypage.render(optionPage);

                        //刷新表格数据
                        DisPlay_HideColumn();

                        layer.close(ajaxLoad);
                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }

                        //刷新按钮显示
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        var HBillType = "3846";
                        Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });
        }


        //快速过滤
        function get_FastQuery() {
@@ -402,7 +520,8 @@
                sWhere += GetDataCols;
            }

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

 WebTM/views/Ä£Öξ߹ÜÀí/Æ÷¾ßάÐÞÅɹ¤µ¥/Sc_MouldRepairSendWorkBillList.html

@@ -186,6 +186,7 @@
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position: relative; bottom: 0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
@@ -229,7 +230,9 @@
            var option = [];
            var HBillType = "3843";
            var HModName = "Sc_MouldRepairSendWorkBillList";

            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
            var page = 1;//分页数据
            var size = 50;
            //#endregion

            //#region ã€åŠ¨æ€èŽ·å–模块名称】
@@ -252,7 +255,11 @@

            // æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });

            //头工具栏事件
@@ -351,14 +358,15 @@
            //#region  æ­¤é¡µé¢æ‰€æœ‰çš„方法
            // åˆå§‹åŒ–界面
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                //初始化日期
                //影响到快速过滤的查询，所以先注释
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                //查询
                //get_Display(sWhere);
                get_FastQuery();
            }

            //初始化表格
@@ -367,8 +375,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , totalRow: true
                    , page: false
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
@@ -434,6 +441,101 @@
                        , { field: '作废日期', title: '作废日期', width: 200, templet: "<div>{{d.作废日期 ==null ?'':layui.util.toDateString(d.作废日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
                    ]]
                };

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            }


            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MouldRepairSendWorkBill/GetMouldRepairSendWorkBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);
                            table.render(option);
                            layer.close(ajaxLoad);

                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);


                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //进入页面显示的缓存列表
@@ -606,7 +708,8 @@
                //        layer.alert("接口失效!", { icon: 5 });
                //    }
                //});
                get_Display(sWhere);
                //get_Display(sWhere);
                get_DisplayPage(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }


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

@@ -190,6 +190,7 @@
                                    </div>
                                </div>
                            </div>
                            <div id="page" style="position: relative; bottom: 0;"></div>
                            <script type="text/html" id="toolbarDemo">
                                <div class="layui-btn-container">
                                    <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
@@ -214,7 +215,7 @@
                            <script type="text/html" id="xuhao1">
                                {{d.LAY_TABLE_INDEX+1}}
                            </script>
                    </form>
</form>
                </div>
            </div>
        </div>
@@ -246,7 +247,9 @@
            var option = [];
            var HBillType = "3807";
            var HModName = "Sb_MouldRepairWorkBillList";
            var titleData = ["hmainid","单据ID", "单据类型", "HMouldID", "HEquipID", "HEmpID", "HManagerID", "HDeptID", "HSupID", "hsubid", "HRepairID", "源单主内码", "源单子内码", "HBillType"];//不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hmainid", "单据ID", "单据类型", "HMouldID", "HEquipID", "HEmpID", "HManagerID", "HDeptID", "HSupID", "hsubid", "HRepairID", "源单主内码", "源单子内码", "HBillType"];//不需要显示的字段 å¯æ‰©å±•
            var page = 1;//分页数据
            var size = 50;
            //#endregion

            //#region ã€åŠ¨æ€èŽ·å–模块名称】
@@ -361,7 +364,11 @@

            // æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });

            // é‡ç½®æŒ‰é’®
@@ -394,7 +401,8 @@
                //初始化表格(子表2)
                set_InitGrid2();
                //查询
                get_Display(sWhere);
                //get_Display(sWhere);
                get_FastQuery();
            }

            //初始化表格
@@ -405,8 +413,7 @@
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , page: true
                    , totalRow: true
                    , page: false
                    , cellMinWidth: 90
                    , cols: [[
                        { type: 'checkbox', fixed: 'left', totalRowText: '合计行' }
@@ -475,6 +482,97 @@
                        , { field: 'HBillType', title: 'HBillType', width: 200, hide: true }
                    ]]
                };

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            }

            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sb_MouldRepairWorkBill/GetMouldRepairWorkBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);

                            //刷新表格数据
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //查询
@@ -902,7 +1000,8 @@
                    sWhere += " and ç»´ä¿®é¡¹ç›® like '%" + RepairItem + "%'";
                }

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

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

@@ -33,15 +33,15 @@
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">单据类型</label>
                                    <div class="layui-input-block">
                                        <select name="HBillType" id="HBillType">
                                            <option value="">所有</option>
                                            <option value="ZHXJ">下架找货单</option>
                                            <option value="ZHSJ">上架归还单</option>
                                        </select>
                                    </div>
                                </div>-->
            <label class="layui-form-label">单据类型</label>
            <div class="layui-input-block">
                <select name="HBillType" id="HBillType">
                    <option value="">所有</option>
                    <option value="ZHXJ">下架找货单</option>
                    <option value="ZHSJ">上架归还单</option>
                </select>
            </div>
        </div>-->
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
@@ -162,6 +162,7 @@
                                </div>
                            </div>
                            <table class="" id="mainTable" lay-filter="mainTable"></table>
                            <div id="page" style="position: relative; bottom: 0;"></div>
                            <script type="text/html" id="toolbarDemo">
                                <div class="layui-btn-container">
                                    <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
@@ -179,7 +180,7 @@

                                </div>
                            </script>
                    </form>
</form>
                </div>
            </div>
        </div>
@@ -211,7 +212,9 @@
            var option = [];
            var HModName = "Sc_MouldConkBookBillList";
            var HBillType = "3815";
            var titleData = ["hmainid","单据ID", "单据类型", "hempid", "HConkTypeID", "HDeptID", "HMouldID", "hsubid", "HConkReasonID", "HManagerID", "表体备注", "源单主内码", "源单子内码","HEmpID","HBillType"];//不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hmainid", "单据ID", "单据类型", "hempid", "HConkTypeID", "HDeptID", "HMouldID", "hsubid", "HConkReasonID", "HManagerID", "表体备注", "源单主内码", "源单子内码", "HEmpID", "HBillType"];//不需要显示的字段 å¯æ‰©å±•
            var page = 1;//分页数据
            var size = 50;
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -261,7 +264,11 @@

            //查询按钮
            form.on('submit(btnSearch)', function (data) {//选择仓位
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });

            //重置按钮
@@ -324,7 +331,8 @@
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                //get_Display(sWhere);
                get_FastQuery();
            }

            //初始化表格
@@ -333,7 +341,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , page: false
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
@@ -391,6 +399,25 @@
                        , { field: 'hbilltype', title: 'hbilltype', width: 200 }
                    ]]
                };

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            }

            //查询
@@ -564,10 +591,83 @@
                if (EndHCreateDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + EndHCreateDate + "'";
                }
                get_Display(sWhere);
                //get_Display(sWhere);
                get_DisplayPage(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }

            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MouldConkBookBill/GetMouldConkBookBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);

                            //刷新表格数据
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //新增
            function set_AddNew() {
                //页面层-自定义

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

@@ -159,6 +159,7 @@
                                    </div>
                                </div>
                                <table class="" id="mainTable" lay-filter="mainTable"></table>
                                <div id="page" style="position: relative; bottom: 0;"></div>
                                <script type="text/html" id="toolbarDemo">
                                    <div class="layui-btn-container">
                                        <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-add-1"></i>新增</button>
@@ -211,7 +212,10 @@
            var option2 = [];
            var HModName = "Sc_MouldDotCheckBillList";
            var HBillType = "3821";
            var titleData = ["hmainid", "HPlanInterID", "HDotCheckItemID", "单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码", "HBillType", "HMouldDotCheckRuleID","HShiftsID"];//不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hmainid", "HPlanInterID", "HDotCheckItemID", "单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码", "HBillType", "HMouldDotCheckRuleID", "HShiftsID"];//不需要显示的字段 å¯æ‰©å±•

            var page = 1;//分页数据
            var size = 50;
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -228,9 +232,8 @@
            //初始化表格
            set_InitGrid();
            //加载数据到网格
            get_Display(sWhere);
            //初始化表格
            DisPlay_HideColumn();
            //get_Display(sWhere);
            get_FastQuery();
            //#endregion

            //#region è§¦å‘事件：包括form.on(){}格式的所有点击事件、选择事件等
@@ -343,7 +346,11 @@
            }
            //查询按钮
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });
            //快速过滤
            function get_FastQuery() {
@@ -443,7 +450,8 @@
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + EndHCreateDate + "'";
                }

                get_Display(sWhere);
                get_DisplayPage(sWhere);
                //get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }
            //初始化表格
@@ -452,7 +460,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 450
                    , page: true
                    , page: false
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
@@ -500,8 +508,103 @@
                    //    , { field: 'hbilltype', title: 'hbilltype', width: 200 }
                    //]]
                }

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            };

            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MouldDotCheckBill/GetMouldDotCheckBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);
                            //刷新表格数据
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);

                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }


            //新增
            function set_AddNew() {
                layer.open({

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

@@ -177,6 +177,7 @@
                                        </div>
                                    </div>
                                </div>
                                <div id="page" style="position: relative; bottom: 0;"></div>
                                <script type="text/html" id="toolbarDemo">
                                    <div class="layui-btn-container">
                                        <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-add-1"></i>新增</button>
@@ -199,7 +200,7 @@
                                <script type="text/html" id="xuhao1">
                                    {{d.LAY_TABLE_INDEX+1}}
                                </script>
                    </form>
</form>
                </div>
            </div>
        </div>
@@ -238,6 +239,8 @@
            var option2 = [];
            var HModName = "Sc_MouldMaintainBillList";
            var HBillType = "3819";
            var page = 1;//分页数据
            var size = 50;

            var titleData = ["hmainid","单据ID", "单据类型", "HMouldID","HEmpID","HBillType"];//不需要显示的字段 å¯æ‰©å±•
            //#endregion
@@ -328,7 +331,11 @@

            // æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });

            // é‡ç½®æŒ‰é’®
@@ -350,7 +357,8 @@
                //初始化表格(子表)
                set_InitGrid2();
                //查询
                get_Display(sWhere);
                //get_Display(sWhere);
                get_DisplayPage(sWhere);

            }

@@ -360,7 +368,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: '400'
                    , page: true
                    , page: false
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: 50
@@ -394,6 +402,25 @@
                    ]]
                };
                table.render(option);

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);

                //刷新按钮显示
                var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
@@ -578,6 +605,82 @@
                });
            }

            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MouldMaintainBill/GetMouldMaintainBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);
                            //刷新表格数据
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);

                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //快速过滤
            function get_FastQuery() {
                var HBillType = $("#HBillType").val();//单据类型
@@ -671,7 +774,8 @@
                if (EndHCreateDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + EndHCreateDate + "'";
                }
                get_Display(sWhere);
                get_DisplayPage(sWhere);
                //get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }

@@ -694,7 +798,8 @@
                $("#Comparator1").val("0");
                form.render('select');
                sWhere = "";
                get_Display(sWhere);
                //get_Display(sWhere);
                get_DisplayPage(sWhere);
            }

            //新增

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

@@ -33,15 +33,15 @@
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">单据类型</label>
                                    <div class="layui-input-block">
                                        <select name="HBillType" id="HBillType">
                                            <option value="">所有</option>
                                            <option value="ZHXJ">下架找货单</option>
                                            <option value="ZHSJ">上架归还单</option>
                                        </select>
                                    </div>
                                </div>-->
                <label class="layui-form-label">单据类型</label>
                <div class="layui-input-block">
                    <select name="HBillType" id="HBillType">
                        <option value="">所有</option>
                        <option value="ZHXJ">下架找货单</option>
                        <option value="ZHSJ">上架归还单</option>
                    </select>
                </div>
            </div>-->
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
@@ -156,6 +156,7 @@
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position: relative; bottom: 0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
@@ -169,8 +170,6 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-generate" id="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-exit" id="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>


                            </div>
                        </script>
                    </form>
@@ -205,6 +204,9 @@
            var option = [];
            var HBillType = "3817";
            var HModName = "Sc_MouldRepairCheckBillList";
            var titleData = [];
            var page = 1;//分页数据
            var size = 50;
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -220,7 +222,8 @@
            //初始化表格
            set_InitGrid();
            //加载数据到网格
            get_Display(sWhere);
            //get_Display(sWhere);
            get_FastQuery();
            //#endregion


@@ -268,7 +271,11 @@
            });
            //查询按钮
            form.on('submit(btnSearch)', function () {//选择仓位
                get_FastQuery();
                if (page != 1) {
                    $("#page a:eq(1)").get(0).click();//点击分页栏第一页
                } else {
                    get_FastQuery();
                }
            });
            //重置按钮
            form.on('submit(btnReSearch)', function () {
@@ -285,8 +292,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , totalRow: true
                    , page: false
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
@@ -344,7 +350,100 @@
                        , { field: '子负责人', title: '子负责人', width: 200, sort: true }
                    ]]
                };

                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {

                        //首次不执行
                        if (!first) {
                            //do something
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            };

            //分页查询
            function get_DisplayPage(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MouldRepairCheckBill/GetMouldRepairCheckBillListPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                //动态获取列表所有列名
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //获取不需要显示的列（H开头的列不显示）
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 160 });
                                            break;
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        case 'Int32':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 });
                                    }
                                }
                            }

                            columns = col;
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            laypage.render(optionPage);
                            table.render(option);

                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
                            layer.close(ajaxLoad);

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //查询
            function get_Display(sWhere) {
@@ -583,7 +682,8 @@
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + EndHCreateDate + "'";
                }

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

@@ -604,7 +704,8 @@
                $("#Comparator1").val("0");
                form.render('select');
                sWhere = "";
                get_Display(sWhere);
                //get_Display(sWhere);
                get_DisplayPage(sWhere);
            }