斯莫尔质量报表增加导出功能

zrg

2024-10-29 1d9a02ff017453c9888a1d054dac323a41ffdf84

斯莫尔质量报表增加导出功能

 WebTM/WebTM.csproj.user

@@ -3,7 +3,7 @@
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\智云迈思\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ProjectFiles</ProjectView>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />
    <IISExpressSSLPort />
@@ -12,5 +12,29 @@
    <IISExpressUseClassicPipelineMode />
    <UseGlobalApplicationHostFile />
  </PropertyGroup>
  <ProjectExtensions />
  <ProjectExtensions>
    <VisualStudio>
      <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
        <WebProjectProperties>
          <StartPageUrl>
          </StartPageUrl>
          <StartAction>CurrentPage</StartAction>
          <AspNetDebugging>True</AspNetDebugging>
          <SilverlightDebugging>False</SilverlightDebugging>
          <NativeDebugging>False</NativeDebugging>
          <SQLDebugging>False</SQLDebugging>
          <ExternalProgram>
          </ExternalProgram>
          <StartExternalURL>
          </StartExternalURL>
          <StartCmdLineArguments>
          </StartCmdLineArguments>
          <StartWorkingDirectory>
          </StartWorkingDirectory>
          <EnableENC>True</EnableENC>
          <AlwaysStartWebServerOnDebug>False</AlwaysStartWebServerOnDebug>
        </WebProjectProperties>
      </FlavorProperties>
    </VisualStudio>
  </ProjectExtensions>
</Project>

 WebTM/layuiadmin/Scripts/webConfig.js

@@ -7,8 +7,8 @@
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
    /*var WEBURL = "http://localhost:8082/API/";*/    //杜贺本地配置
    /*var WEBURL = "http://localhost/API/";*/    //潘浙游本地配置  
    //var WEBURL = "http://localhost:8082/API/";    //张瑞广本地配置
    var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置
    var WEBURL = "http://localhost:8082/API/";    //张瑞广本地配置
   /* var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置*/
    //var WEBURL = "http://47.96.97.237/API/";          //智云服务器
    /*var WEBURL = "http://localhost:8082/LuBaoAPI/"; */  //余思杰本地配置
    //var WEBURL = "http://localhost:8088/ARAPI/";      //余思杰本地配置(安瑞)

 WebTM/views/¹¤×ʹÜÀí/¸Úλ¼¼ÄÜÇåµ¥/HR_PostSkillBill.html

@@ -315,25 +315,32 @@

            //#region åˆ¤æ–­å¹¶è®¾ç½®æ“ä½œç±»åž‹ã€é¡µé¢åˆå§‹åŒ–
            if (OperationType == null || OperationType == 1) {                            //新增
                ////禁用组织选项
                //$("#HOrgID").attr("disabled", true);
                OperationType = 1;

                OperationType = 1;
                //初始化项目阶段表
                get_InitGrid();

                //生成并设置主表的内码和单据号
                createBillNo();


                //初始化制单人和制单时间
                $("#HMaker").val(sessionStorage["HUserName"]);
                $("#HMakerDate").val(Format(new Date(), "yyyy-MM-dd"));

                //初始化日期
                $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));


            }
            else if (OperationType == 2) {//如果修改则走下面 new                                        //编辑
              
                //初始化项目阶段表
                get_InitGrid();
                RoadBillMain(linterid);
                //生成并设置主表的内码和单据号
                createBillNo();
                //初始化制单人和制单时间
                $("#HMaker").val(sessionStorage["HUserName"]);
                $("#HMakerDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化日期
                $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
                OperationType = 1;
            }
            else if (OperationType == 3) {//如果修改则走下面 new                                        //编辑
                ////禁用组织选项
@@ -824,9 +831,9 @@

                        //主表 èµ‹å€¼
                        form.val("formData", { //formTest å³ class="layui-form" æ‰€åœ¨å…ƒç´ å±žæ€§ lay-filter="" å¯¹åº”的值
                            "HInterID": data[0]["hmainid"]
                            , "HBillNo": data[0]["单据号"]
                            , "HDate": formatDate(data[0]["日期"])
                            "HInterID": OperationType == 2 ? "" :data[0]["hmainid"]
                            , "HBillNo": OperationType == 2 ? "" :data[0]["单据号"]
                            , "HDate": OperationType == 2 ? "" :formatDate(data[0]["日期"])
                            , "HDeptID": data[0]["HDeptID"]
                            , "HDeptName": data[0]["部门名称"]
                            , "HPostID": data[0]["HPostID"]

 WebTM/views/¹¤×ʹÜÀí/¸Úλ¼¼ÄÜÇåµ¥/HR_PostSkillBillList.html

@@ -146,6 +146,7 @@
                            <div class="layui-btn-container">
                                <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_Copy" id="set_Copy"><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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
@@ -225,6 +226,9 @@
                        break;
                    //编辑
                    case 'set_ShowBill': set_ShowBill();
                        break;
                    //复制
                    case 'set_Copy': set_Copy();
                        break;
                    //删除
                    case 'set_DeleteBill': set_DeleteBill();
@@ -574,6 +578,27 @@
            }
            //#endregion

            //复制
            function set_Copy() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var linterid = data[0].hmainid.toString();
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '新增' + HPageTitle
                        , shift: 0//弹出动画
                        , content: '../../工资管理/岗位技能清单/HR_PostSkillBill.html?OperationType=2&linterid=' + linterid + '&HSouceBillType='
                        , end: function () {
                            //刷新页面,
                            location.reload();
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }

            //#region åˆ é™¤
            function set_DeleteBill() {

 WebTM/views/Éú²ú¹ÜÀí/Òì³£·´À¡µ¥/Sc_Add_MESExecptFeedBackBillList.html

@@ -312,8 +312,11 @@
                                                    <div class="layui-inline">
                                                        <label class="layui-form-label">指派处理人:</label>
                                                        <div class="layui-input-inline">
                                                            <input type="text" name="HHandleEmpName" id="HHandleEmpName" class="layui-input" value="" style="float:left;" disabled>
                                                            <input type="hidden" name="HHandleEmpID" id="HHandleEmpID" class="layui-input" value="0" style="float:left;">
                                                            <input type="text" name="HHandleEmpName" id="HHandleEmpName" class="layui-input" value="" style="float:left;width:150px;" disabled>
                                                            <input type="hidden" name="HHandleEmpID" id="HHandleEmpID" class="layui-input" value="0" style="float:left;width:150px;">
                                                            <button type="button" lay-submit="" class="layui-btn" lay-filter="HHandleEmpList" id="HHandleEmpList" style="width:40px;">
                                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                            </button>
                                                        </div>
                                                    </div>
                                                    <div class="layui-inline">
@@ -728,8 +731,56 @@
                        $("#HHandleEmpName").val("孙文静");  //指派处理人
                        $("#HHandleEmpID").val(162622);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "环境原因") {
                        $("#HHandleEmpName").val("孙文静");  //指派处理人
                        $("#HHandleEmpID").val(162622);        //指派处理人
                        //$("#HHandleEmpName").val("孙文静");  //指派处理人
                        //$("#HHandleEmpID").val(162622);        //指派处理人
                    }
                }
                else if (sessionStorage["HDept"] == "生产部1-铁芯") {
                    if ($("#HErrMsgBackTypeName").val() == "人员原因") {
                        $("#HHandleEmpName").val("程帆");  //指派处理人
                        $("#HHandleEmpID").val(161720);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "设备原因") {
                        $("#HHandleEmpName").val("徐建洪");  //指派处理人
                        $("#HHandleEmpID").val(162576);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "材料原因") {
                        $("#HHandleEmpName").val("程帆");  //指派处理人
                        $("#HHandleEmpID").val(161720);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "工艺原因") {
                        $("#HHandleEmpName").val("王强");  //指派处理人
                        $("#HHandleEmpID").val(163378);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "模具原因") {
                        //$("#HHandleEmpName").val("吴斌");  //指派处理人
                        //$("#HHandleEmpID").val(162686);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "测试原因") {
                        $("#HHandleEmpName").val("张建鹏");  //指派处理人
                        $("#HHandleEmpID").val(162525);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "环境原因") {
                        $("#HHandleEmpName").val("吕双棋");  //指派处理人
                        $("#HHandleEmpID").val(162526);        //指派处理人
                    }
                }
                else if (sessionStorage["HDept"] == "生产部1-组装") {
                    if ($("#HErrMsgBackTypeName").val() == "人员原因") {
                        $("#HHandleEmpName").val("程帆");  //指派处理人
                        $("#HHandleEmpID").val(161720);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "设备原因") {
                        $("#HHandleEmpName").val("曾东鑫");  //指派处理人
                        $("#HHandleEmpID").val(162573);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "材料原因") {
                        $("#HHandleEmpName").val("程帆");  //指派处理人
                        $("#HHandleEmpID").val(161720);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "工艺原因") {
                        $("#HHandleEmpName").val("柯诗文");  //指派处理人
                        $("#HHandleEmpID").val(162661);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "模具原因") {
                        //$("#HHandleEmpName").val("吴斌");  //指派处理人
                        //$("#HHandleEmpID").val(162686);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "测试原因") {
                        $("#HHandleEmpName").val("刘龙飞");  //指派处理人
                        $("#HHandleEmpID").val(163180);        //指派处理人
                    } else if ($("#HErrMsgBackTypeName").val() == "环境原因") {
                        $("#HHandleEmpName").val("吕双棋");  //指派处理人
                        $("#HHandleEmpID").val(162526);        //指派处理人
                    }
                }
            }
@@ -751,6 +802,7 @@
                                EquipNumber = LoadData[0].设备编码; //产品名称
                            }
                            else {
                                EquipNumber = "";
                                layer.alert(data.Message, { icon: 5 });

                            }
@@ -1085,6 +1137,44 @@
                });
            });

            //指派处理人弹窗
            form.on('submit(HHandleEmpList)', function () {
                //页面层-自定义
                layer.open({
                    type: 2,
                    skin: 'layui-layer-rim', //加上边框
                    title: '发送人列表',
                    closeBtn: 1,
                    shift: 2,
                    area: ['80%', '80%'],
                    maxmin: true,
                    content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HEmp', 'yes'],
                    btn: ['确定', '取消']
                    , btn1: function (index, layero) {

                        //按钮【按钮一】的回调
                        var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }
                        $("#HHandleEmpID").val(checkStatus.data[0].HItemID);
                        $("#HHandleEmpName").val(checkStatus.data[0].职员名称);
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                        $("#HDescription").val(generateString(Datetime, Person, HSourceName, HICMOBillNo, HType, EquipNumber));
                    }
                    , btn2: function (index, layero) {
                        //按钮【按钮二】的回调
                        //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                    },
                    end: function () {

                    },
                    success: function (layero, index) {

                    }
                });
            });

            //接收部门
            form.on('submit(HRecDeptList)', function () {
@@ -1245,6 +1335,9 @@
                        if (DeptName == "生产部3") {
                            $("#HQEMan").val(162622);
                            $("#HQEManName").val("孙文静");
                        } else{
                            $("#HQEMan").val(162525);
                            $("#HQEManName").val("张建鹏");
                        }
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_BadProductsReport.html

@@ -131,6 +131,7 @@
                        </div>
                        <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -160,6 +161,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_BadProductsReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -181,6 +183,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -321,7 +326,7 @@
                            }
                        }
                        table.render(option);

                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();

@@ -503,6 +508,13 @@
        });


        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
        //#endregion


        //隐藏列设置
        function get_HideColumn() {
            var colName = "";

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrManagerLedgerReport.html

@@ -102,6 +102,7 @@
                        </div>
                        <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -131,6 +132,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_ErrManagerLedgerReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -152,6 +154,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -317,6 +322,7 @@
                            }
                        }
                        table.render(option);
                        ins = table.render(option);

                        //刷新表格数据
                        DisPlay_HideColumn();
@@ -426,6 +432,12 @@
        }
        //#endregion

        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
        //#endregion

        //隐藏列设置
        function get_HideColumn() {
            var colName = "";

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrManagerLedgerReport_EquipTop3Issue.html

@@ -102,6 +102,7 @@
                        </div>
                        <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="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -133,6 +134,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var ins;                //用于导出excel
            var HModName = "QC_ErrManagerLedgerReport_EquipTop3Issue";
            var HEquipIssue = []; //设备问题
            //#endregion
@@ -386,6 +388,9 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
            //重置按钮
@@ -504,6 +509,7 @@
                            option.data = data1.data;

                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -598,6 +604,12 @@
            }
            //#endregion

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrManagerLedgerReport_Issue.html

@@ -102,6 +102,7 @@
                        </div>
                        <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="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -133,6 +134,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var ins;                //用于导出excel
            var HModName = "QC_ErrManagerLedgerReport_Issue";
            var HIssueType = []; //问题类型
            //#endregion
@@ -386,6 +388,9 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
            //重置按钮
@@ -504,6 +509,7 @@
                            option.data = data1.data;

                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -601,6 +607,12 @@
            }
            //#endregion

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrManagerLedgerReport_Source.html

@@ -102,6 +102,7 @@
                        </div>
                        <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="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -133,6 +134,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var ins;                //用于导出excel
            var HModName = "QC_ErrManagerLedgerReport_Source";
            var HSourceName = []; //生产资源名称
            //#endregion
@@ -386,6 +388,9 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
            //重置按钮
@@ -504,6 +509,7 @@
                            option.data = data1.data;

                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -599,7 +605,14 @@
                    }
                })
            }
        //#endregion
            //#endregion

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion


            //隐藏列设置
            function get_HideColumn() {

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ErrManagerLedgerReport_SourceOfTheProblem.html

@@ -102,6 +102,7 @@
                        </div>
                        <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="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -133,6 +134,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var ins;                //用于导出excel
            var HModName = "QC_ErrManagerLedgerReport_SourceOfTheProblem";
            var HSourceOfTheProblem = []; //异常问题来源
            //#endregion
@@ -386,6 +388,9 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
            //重置按钮
@@ -504,6 +509,7 @@
                            option.data = data1.data;

                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -601,6 +607,13 @@
            }
            //#endregion

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion


            //隐藏列设置
            function get_HideColumn() {
                var colName = "";

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_InspectionFormReport.html

@@ -215,6 +215,7 @@
                        </div>
                        <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="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -246,6 +247,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var ins;                //用于导出excel
            var HModName = "QC_InspectionFormReport";
            var optionAVG = [];
            var optionS = [];
@@ -272,6 +274,9 @@
                    //隐藏列设置
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
@@ -441,6 +446,7 @@
                                optionAVG[0] = data1.data[limit + 1];
                                optionS[0] = data1.data[limit + 2];
                                table.render(option);
                                ins = table.render(option);
                                set_PPK();
                                set_CPK();
                                set_Line();
@@ -702,6 +708,12 @@
                return sum;
            }

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //折线图
            function set_Line() {
                //#region【折线图】

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_MoistureContentDataLedger.html

@@ -106,6 +106,7 @@
                        </div>
                        <script type="text/html" id="toolbarDemo1">
                            <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -135,6 +136,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_MoistureContentDataLedger";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -156,6 +158,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -302,7 +307,7 @@
                        }

                        table.render(option);

                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                        layer.close(ajaxLoad);
@@ -404,6 +409,11 @@
        }
        //#endregion

        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
        //#endregion

        //隐藏列设置
        function get_HideColumn() {

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_PerformanceScrapLedger.html

@@ -97,6 +97,7 @@
                        </div>
                        <script type="text/html" id="toolbarDemo1">
                            <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -126,6 +127,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_PerformanceScrapLedger";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -147,6 +149,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -301,13 +306,9 @@
                        }

                        table.render(option);

                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();

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

                        layer.close(ajaxLoad);
                    } else {
@@ -407,6 +408,11 @@
        }
        //#endregion

        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
        //#endregion

        //隐藏列设置
        function get_HideColumn() {

 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_QualityStatisticsDailyReport.html

@@ -138,6 +138,7 @@
                        </div>
                        <script type="text/html" id="toolbarDemo1">
                            <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -167,6 +168,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_QualityStatisticsDailyReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -188,6 +190,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -229,6 +234,12 @@
            $("#HMonth").val(new Date().getMonth()+1);
            form.render('select');
        }

        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
         //#endregion

        //生产车间
        function DeptName() {
@@ -370,7 +381,7 @@
                      
                        option.data=data1.data
                        table.render(option);

                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();


 WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_RegistrationForTestingReport.html

@@ -102,6 +102,7 @@
                        </div>
                        <script type="text/html" id="toolbarDemo1">
                            <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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
@@ -131,6 +132,7 @@
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;                //用于导出excel
        var HModName = "QC_RegistrationForTestingReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//子表不需要显示的字段 å¯æ‰©å±•

@@ -152,6 +154,9 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn': get_HideColumn();
                    break;
                //导出按钮
                case 'btn_Export': btn_Export();
                    break;
            };
        });
@@ -318,15 +323,10 @@
                            option.data = data1.data
                        }


                        table.render(option);

                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();

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

                        layer.close(ajaxLoad);
                    } else {
@@ -488,7 +488,11 @@
            }
        });
    

        //#region å¯¼å‡ºExecel
        function btn_Export() {
            table.exportFile(ins.config.id, option.data, "xls");
        }
        //#endregion

        //隐藏列设置
        function get_HideColumn() {

 WebTM/views/³µ¼ä¹ÜÀí/Æô¶¯µã¼ìµ¥/Gy_WorkBeginDotCheckListBill.html

@@ -325,7 +325,20 @@
                $('#HOrgID').attr("disabled", true);

            }

            else if (OperationType == 2) {//如果修改则走下面 new                                        //编辑
               
                //初始化项目阶段表
                get_InitGrid();
                RoadBillMain(linterid);
                //生成并设置主表的内码和单据号
                createBillNo();
                //初始化制单人和制单时间
                $("#HMaker").val(sessionStorage["HUserName"]);
                $("#HMakerDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化日期
                $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
                OperationType = 1;
            }
            else if (OperationType == 3) {//如果修改则走下面 new

                //初始化子表

 WebTM/views/³µ¼ä¹ÜÀí/Æô¶¯µã¼ìµ¥/Gy_WorkBeginDotCheckListBillList.html

@@ -168,6 +168,7 @@
                            <div class="layui-btn-container">
                                <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_Copy" id="set_Copy"><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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
@@ -179,7 +180,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>                              
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                            </div>
                        </script>
                    </form>
@@ -245,6 +246,9 @@
                        break;
                    //编辑
                    case 'set_ShowBill': set_ShowBill();
                        break;
                    //复制
                    case 'set_Copy': set_Copy();
                        break;
                    //删除
                    case 'set_DeleteBill': set_DeleteBill();
@@ -687,6 +691,28 @@
            }
            //#endregion

            //复制
            function set_Copy() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var linterid = data[0].HInterID.toString();
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '设备启动点检清单列表-新增'
                        , shift: 0//弹出动画
                        , content: '../../车间管理/启动点检单/Gy_WorkBeginDotCheckListBill.html?OperationType=2&linterid=' + linterid + '&HSouceBillType='
                        , end: function () {
                            //刷新页面,
                            location.reload();
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }


            //#region åˆ é™¤
            function set_DeleteBill() {