1

wangyi

2026-04-02 96785ebcfe1bc9210f3d9d4056f4ec29fb60d810

 WebTM/views/ÖÊÁ¿¹ÜÀí/³ö³§¼ìÑéµ¥/QC_OutCompCheckBillList.html

@@ -155,6 +155,7 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="btn_Export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
@@ -197,6 +198,7 @@
            var size = 50;
            var sWhere = "";
            var HModName = "QC_OutCompCheckBillList";
            var ins;                //用于导出excel
            //#region è¿›å…¥é¡µé¢å³åŠ è½½

            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
@@ -220,6 +222,9 @@
            //#region å¤´å·¥å…·æ äº‹ä»¶
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                    //新增按钮
                    case 'set_AddNew': set_AddNew();
                        break;
@@ -475,6 +480,7 @@
                            option.totalRow = true;
                            table.render(option);
                            laypage.render(optionPage);
                            ins = table.render(option);

                            DisPlay_HideColumn();
                            
@@ -817,7 +823,25 @@
            }
            //#endregion

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                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().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                        }
                        if (itemobj === '规格型号') {
                            item[itemobj] = item[itemobj].replace(/,/g, '，');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                        }
                    }
                });

                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //#region éšè—åˆ—设置
            function get_HideColumn() {