工资报表、生产订单列表、工艺路线列表、流转卡列表、工序出站汇报单列表回车查询；提料计划、缺料分析、齐套报表添加导出功能

yusijie

2024-12-05 596b25f7569404b6b3d72375f35bc0c005c3fa6a

工资报表、生产订单列表、工艺路线列表、流转卡列表、工序出站汇报单列表回车查询；提料计划、缺料分析、齐套报表添加导出功能

 WebTM/views/¹¤×ʹÜÀí/¹¤×ʽáËãµ¥(¸öÈË)/Pay_SingleBalBillList.html

@@ -238,6 +238,53 @@

            //#endregion

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //班组回车方法
            $('#HGroupName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //职员回车方法
            $('#HEmpName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });
           
            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion


            //#region è¿›å…¥é¡µé¢å³åŠ è½½

            //#region åˆå§‹åŒ–界面

 WebTM/views/¹¤×ʹÜÀí/¹¤×ʽáËãµ¥(¼¯Ìå)/Pay_GroupBalBillList.html

@@ -240,6 +240,52 @@

            //#region è¿›å…¥é¡µé¢å³åŠ è½½

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //班组回车方法
            $('#HGroupName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //职员回车方法
            $('#HEmpName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region åˆå§‹åŒ–界面

            set_ClearBill();

 WebTM/views/¹¤×ʹÜÀí/°à×éÖ°Ô±Çåµ¥/Gy_GroupEmpBillList.html

@@ -208,6 +208,38 @@
            });
            //#endregion

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region åˆå§‹åŒ–界面
            function set_ClearBill() {
                //初始化表格

 WebTM/views/¹¤×ʹÜÀí/¿¼Çڻ㱨µ¥/Pay_WorkTimesBillList.html

@@ -227,6 +227,38 @@

            //#region è¿›å…¥é¡µé¢å³åŠ è½½

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });
           
            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region åˆå§‹åŒ–界面

            set_ClearBill();

 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/MaterialShorAnalysisReport.html

@@ -49,6 +49,7 @@
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导出</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
@@ -176,6 +177,7 @@
        var sWhere = "";
        var option = [];
        var HModName = "MaterialShorAnalysisReport";
        var ins;                        //用于导出excel
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -207,6 +209,12 @@
        //#region æŸ¥è¯¢æŒ‰é’®
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery(2);
        });
        //#endregion

        //#region å¯¼å‡ºæŒ‰é’®
        form.on('submit(btnExport)', function (data) {
            getExportData();
        });
        //#endregion

@@ -282,11 +290,11 @@
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: false
                , page: true
                , cellMinWidth: 90
                , totalRow: true
                , limit: 20000
                , limits: [50, 500, 5000, 20000]
                , limit: 1000
                , limits: [50, 500,1000, 5000, 20000]
                , loading: false
                , cols: [columns]
                , done: function (res, page, count) {
@@ -298,11 +306,16 @@
                            var dateNowTime = Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + i), 'yyyy-MM-dd');
                            if (item[dateNowTime] != null) {
                                if (NumCount > parseFloat(item[dateNowTime])) {
                                    //库存数量>需求数量：剩余可用库存数量=库存数量-需求数量
                                    NumCount -= parseFloat(item[dateNowTime]);
                                } else {
                                    //库存数量<需求数量：剩余可用库存数量=0
                                    NumCount = 0;

                                    var num = 7;//即时库存与日期挨着  ä»Žå³æ—¶åº“存开始算
                                    tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']");
                                    rq = tr.children()[num + 1 + i];
                                    //rq = tr.children()[num + 1 + i];
                                    rq = tr.children()[num + i];
                                    rq.style.color = '#f66161';//然后变色
                                    rq = tr.children()[num];
                                    rq.style.color = '#f66161';//然后变色
@@ -380,6 +393,144 @@

        //#endregion

        //#region èŽ·å–导出数据
        function getExportData() {
            var data;//导出的数据
            var ajaxLoad = layer.load();
            var HORGID = $("#HORGID").val();//组织           
            var HBEGINDATE = $("#HBEGINDATE").val();//提料日期
            var HENDDATE = $("#HENDDATE").val();//至
            //var HMATERIALID = $("#HMATERIALID").val();//物料/产品
            //var HSUPPLIERID = $("#HSUPPLIERID").val();//供应商
            //var HXQD = $("#HXQD").val();//需求单号
            //var HPURORDERNO = $("#HPURORDERNO").val();//采购订单号
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").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 (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            if (HBEGINDATE > HENDDATE) {
                return layer.msg("开始日期不能小于结束日期!");
            }

            sWhere = {
                HORGID: HORGID
                , HBEGINDATE: HBEGINDATE
                , HENDDATE: HENDDATE
                //, HMATERIALID: HMATERIALID
                //, HSUPPLIERID: HSUPPLIERID
                //, HXQD: HXQD
                //, HPURORDERNO: HPURORDERNO
            }

            $.ajax({
                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/MaterialShorAnalysisReport',
                type: "GET",
                data: { "sWhere": JSON.stringify(sWhere) },//, "user": sessionStorage["HUserName"]
                success: function (result) {
                    if (result.count == 1) {
                        data = result.data;

                        option.data = data;
                        ins = table.render(option);

                        data.forEach((item) => {
                            for (let itemobj in item) {
                                if (item[itemobj] == null) {
                                    item[itemobj] = "";
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            }
                        });

                        table.exportFile(ins.config.id, data, "xls");

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

            sWhere = "";
        }
        //#endregion

        //#region å¿«é€Ÿè¿‡æ»¤
        function get_FastQuery(number) {
            var HORGID = "";

 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportMOMaterReadysBillList.html

@@ -56,6 +56,7 @@
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导出</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                        <div class="layui-inline">
@@ -200,6 +201,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                        //用于导出excel
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -241,6 +243,12 @@
        });
        //#endregion

        //#region å¯¼å‡ºæŒ‰é’®
        form.on('submit(btnExport)', function (data) {
            getExportData();
        });
        //#endregion

        //#endregion

        //#region æœ¬é¡µé¢è¢«è°ƒç”¨çš„所有方法
@@ -261,7 +269,7 @@
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                //, toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: false
                , cellMinWidth: 90
@@ -349,6 +357,139 @@

        //#endregion

        //#region èŽ·å–导出数据
        function getExportData() {
            var data;//导出的数据
            var ajaxLoad = layer.load();
            var HORGID = $("#HORGID").val();//组织           
            var HMATERIALID = $("#HMATERIALID").val();//物料/产品
            var HDeptID = $("#HDeptID").val();//生产车间
            var HSCZYID = $("#HSCZYID").val();//生产资源
            var HXQD = $("#HXQD").val();//需求单号
            var HMOBILLNO = $("#HMOBILLNO").val();//生产订单号

            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").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 (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            sWhere = {
                HORGID: HORGID
                , HMATERIALID: HMATERIALID
                , HDeptID: HDeptID
                , HSCZYID: HSCZYID
                , HXQD: HXQD
                , HMOBILLNO: HMOBILLNO
            }
           
            $.ajax({
                url: GetWEBURL() + '/JIT_Complete/ReportMOMaterReadysBillList',
                type: "GET",
                data: { "sWhere": JSON.stringify(sWhere) },//, "user": sessionStorage["HUserName"]
                success: function (result) {
                    if (result.count == 1) {
                        data = result.data;

                        option.data = data;
                        ins = table.render(option);

                        data.forEach((item) => {
                            for (let itemobj in item) {
                                if (item[itemobj] == null) {
                                    item[itemobj] = "";
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            }
                        });

                        table.exportFile(ins.config.id, data, "xls");

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

            sWhere = "";
        }
        //#endregion

        //#region å¿«é€Ÿè¿‡æ»¤
        function get_FastQuery(number) {
            var HORGID = "";

 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportPODemandPlanBillList_S.html

@@ -48,6 +48,7 @@
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导出</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
@@ -188,7 +189,7 @@
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () {
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable','flow'], function () {
        //#region å…¬ç”¨å˜é‡
        var $ = layui.$
            , admin = layui.admin
@@ -202,8 +203,10 @@
            , tree = layui.tree
            , util = layui.util
            , soulTable = layui.soulTable
            , flow = layui.flow
        var sWhere = " where 1=1 ";
        var option = [];
        var ins;                        //用于导出excel
        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -238,6 +241,12 @@
            get_FastQuery(2);
        });
        //#endregion

        //#region å¯¼å‡ºæŒ‰é’®
        form.on('submit(btnExport)', function (data) {
            getExportData();
        });
        //#endregion       

        //#endregion

@@ -312,12 +321,12 @@

            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                //, toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: false
                , page: true
                , cellMinWidth: 90
                , limit: 20000
                , limits: [50, 500, 5000, 20000]
                , limit: 1000
                , limits: [50, 500,1000, 5000, 20000]
                , totalRow: true
                , loading: false
                , cols: [columns]
@@ -358,7 +367,8 @@
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
                success: function (result) {
                    if (result.count == 1) {
                    if (result.count == 1) {                      

                        option.data = result.data;
                        table.render(option);
                        layer.close(ajaxLoad);
@@ -376,6 +386,157 @@

        //#endregion

        //#region èŽ·å–导出数据
        function getExportData() {
            var data;//导出的数据
            var ajaxLoad = layer.load();
            var HORGID = $("#HORGID").val();//组织           
            var HBEGINDATE = $("#HBEGINDATE").val();//提料日期
            var HENDDATE = $("#HENDDATE").val();//至
            var HMATERIALID = $("#HMATERIALID").val();//物料/产品
            var HSUPPLIERID = $("#HSUPPLIERID").val();//供应商
            var HXQD = $("#HXQD").val();//需求单号
            var HPURORDERNO = $("#HPURORDERNO").val();//采购订单号

            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").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 (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }

            if (HBEGINDATE > HENDDATE) {
                return layer.msg("开始日期不能小于结束日期!");
            }

            if (HORGID != "") {
                sWhere += " and a.HPURCHASEORGID= " + HORGID + " ";
            }

            if (HBEGINDATE != null && HENDDATE != null) {
                sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' ";
            }
            if (HMATERIALID != 0) {
                sWhere += " and B.HMaterID= " + HMATERIALID + " ";
            }
            if (HSUPPLIERID != 0) {
                sWhere += " and A.HSupplierID= " + HSUPPLIERID + " ";
            }
            if (HXQD) {
                sWhere += " and HSeOrderBillNo like''% " + HXQD + "%'' ";
            }
            if (HPURORDERNO) {
                sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' ";
            }
            
            //查询语句
            $.ajax({
                url: GetWEBURL() + '/JIT_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
                success: function (result) {
                    if (result.count == 1) {
                        data = result.data;

                        option.data = data;
                        ins = table.render(option);

                        data.forEach((item) => {
                            for (let itemobj in item) {
                                if (item[itemobj] == null) {
                                    item[itemobj] = "";
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            }
                        });

                        table.exportFile(ins.config.id, data, "xls");
                     
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(result.code + result.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });
            sWhere = "";
        }
        //#endregion

        //#region å¿«é€Ÿè¿‡æ»¤
        function get_FastQuery(number) {
            var HORGID = "";

 WebTM/views/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillList.html

@@ -433,6 +433,73 @@
            set_ClearBill();
            //#endregion

            //#region å›žè½¦æŸ¥è¯¢
          
            //物料代码回车方法
            $('#HMaterName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //规格型号回车方法
            $('#HModel').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //单据号回车方法
            $('#WorkCenter').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //销售订单号回车方法
            $('#HSeOrderBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //单据类型回车方法
            $('#HBillType').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //唯一ID回车方法
            $('#HERPID').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion


            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {

 WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBillList.html

@@ -585,6 +585,59 @@
            })
            //#endregion

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#WorkCenter').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //物料代码回车方法
            $('#HMaterNumber').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //物料名称回车方法
            $('#HMaterName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //规格型号回车方法
            $('#HModel').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
            function set_ClearQuery() {
                var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
@@ -1452,7 +1505,7 @@

            //#region èŽ·å–导出数据
            function getExportData() {
                var data;;//导出的数据
                var data;//导出的数据
                var ajaxLoad = layer.load();
                var HDate = $("#HBeginDate").val();//开始日期
                var HDate1 = $("#HEndDate").val();//结束日期

 WebTM/views/³µ¼ä¹ÜÀí/¹¤Ðò³öÕ¾»ã±¨µ¥/Cj_StationOutBillList.html

@@ -361,7 +361,9 @@
                } else {
                    get_FastQuery();
                }
            });
            });            

            //#region å›žè½¦æŸ¥è¯¢

            //生产订单回车方法
            $('#HWorkBillNo').on('keydown', function (event) {
@@ -374,6 +376,7 @@
                    $("#btnSearch").click();
                }
            });

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                var HBillNo = $('#HBillNo').val();
@@ -385,6 +388,7 @@
                    $("#btnSearch").click();
                }
            });

            //工序流转卡回车方法
            $('#HProcExchBillNo').on('keydown', function (event) {
                var HProcExchBillNo = $('#HProcExchBillNo').val();
@@ -397,6 +401,51 @@
                }
            });

            //操作员代码回车方法
            $('#HEmpNumber').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //操作员名称回车方法
            $('#HEmpName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //产品代码回车方法
            $('#HNumber').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //当前工序回车方法
            $('#HName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion


            //点击主表带出从表数据
            table.on('row(mainTable)', function (obj) { //注：tool æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"


 WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/Sc_ProcessExchangeBillList.html

@@ -639,6 +639,73 @@
            });
            //#endregion

            //#region å›žè½¦æŸ¥è¯¢

            //订单跟踪号回车方法
            $('#HOrderProcNO').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //任务单号回车方法
            $('#HWorkBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //物料回车方法
            $('#HProcExchBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //单据号回车方法
            $('#HBillNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //批次号回车方法
            $('#HBatchNo').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //唯一ID回车方法
            $('#HERPID').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„方法
            function set_ClearBill() {
                get_Dept();