新增生产质量日报.没日日报,工序出站汇报单增加字段 设备工时,优化异常反馈列表和异常反馈验收列表查询

zrg

2024-11-11 6fbaaf885f0d63e86c53e13d6a006987daba70e6

新增生产质量日报.没日日报,工序出站汇报单增加字段 设备工时,优化异常反馈列表和异常反馈验收列表查询

 WebTM/WebTM.csproj

@@ -518,6 +518,8 @@
    <Content Include="views\质量管理\基础建模\Gy_ErrMsgBackType_Excel.html" />
    <Content Include="views\质量管理\基础建模\Gy_ErrType_Excel.html" />
    <Content Include="views\质量管理\异常反馈\OA_ErrMsgBackSelfQuery_BGT.html" />
    <Content Include="views\质量管理\质量报表\QC_QualityDailyReprot_Sum.html" />
    <Content Include="views\质量管理\质量报表\QC_QualityDailyReprot.html" />
    <Content Include="views\质量管理\质量报表\QC_FiveMenOneRingList.html" />
    <Content Include="views\质量管理\质量报表\QC_EquipMentCollectionTechParam.html" />
    <Content Include="views\设备管理\设备规程单\Sb_EquipDotCheckRule_Excel.html" />

 WebTM/WebTM.csproj.user

@@ -2,9 +2,9 @@
<Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\智云迈思\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\网站发布\后端代码\MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile>
    <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 />

 WebTM/layuiadmin/Scripts/webConfig.js

@@ -10,7 +10,7 @@
    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:8082/LuBaoAPI/";   //余思杰本地配置*/
    //var WEBURL = "http://localhost:8088/ARAPI/";      //余思杰本地配置(安瑞)
    //var WEBURL = "http://localhost/API/";             //潘浙游本地配置
    //var WEBURL = "http://61.164.86.218:8099/ABAPI/";  //奥邦

 WebTM/views/ÖÊÁ¿¹ÜÀí/Òì³£·´À¡/OA_ErrMsgBackSelfQuery.html

@@ -42,7 +42,7 @@
                            <div class="layui-input-block">
                                <input type="text" class="layui-input" lay-verify="HSourceName" name="HSourceName" id="HSourceName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                <input type="hidden" class="layui-input" lay-verify="HSourceID" name="HSourceID" id="HSourceID" value="0">
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHDeptID" id="btnHDeptID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="HSourceList" id="HSourceList" style="padding: 0 10px;float: right;margin-right: 3px;">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                            </div>
@@ -533,6 +533,44 @@
            }
            //#endregion

            //生产资源
            form.on('submit(HSourceList)', function () {
                //页面层-自定义
                layer.open({
                    type: 2,
                    skin: 'layui-layer-rim', //加上边框
                    title: '资源列表',
                    closeBtn: 1,
                    shift: 2,
                    area: ['80%', '80%'],
                    maxmin: true,
                    content: ['../../基础资料/生产基础资料/Gy_Source.html', '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('请选择数据');
                        }
                        $("#HSourceName").val(checkStatus.data[0].生产资源名称);
                        $("#HSourceID").val(checkStatus.data[0].HItemID);
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }
                    , btn2: function (index, layero) {
                        //按钮【按钮二】的回调
                        //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                    },
                    end: function () {

                    },
                    success: function (layero, index) {

                    }
                });
            });


            // èŽ·å–标签
            function getActiveTab() {

 WebTM/views/ÖÊÁ¿¹ÜÀí/Òì³£·´À¡/OA_ErrMsgBackSelfQuery_BGT.html

@@ -40,7 +40,7 @@
                            <div class="layui-input-block">
                                <input type="text" class="layui-input" lay-verify="HSourceName" name="HSourceName" id="HSourceName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                <input type="hidden" class="layui-input" lay-verify="HSourceID" name="HSourceID" id="HSourceID" value="0">
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHDeptID" id="btnHDeptID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="HSourceList" id="HSourceList" style="padding: 0 10px;float: right;margin-right: 3px;">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                            </div>
@@ -518,6 +518,45 @@
            }
            //#endregion

            //生产资源
            form.on('submit(HSourceList)', function () {
                //页面层-自定义
                layer.open({
                    type: 2,
                    skin: 'layui-layer-rim', //加上边框
                    title: '资源列表',
                    closeBtn: 1,
                    shift: 2,
                    area: ['80%', '80%'],
                    maxmin: true,
                    content: ['../../基础资料/生产基础资料/Gy_Source.html', '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('请选择数据');
                        }
                        $("#HSourceName").val(checkStatus.data[0].生产资源名称);
                        $("#HSourceID").val(checkStatus.data[0].HItemID);
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }
                    , btn2: function (index, layero) {
                        //按钮【按钮二】的回调
                        //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                    },
                    end: function () {

                    },
                    success: function (layero, index) {

                    }
                });
            });



            // èŽ·å–标签
            function getActiveTab() {

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

@@ -30,7 +30,7 @@
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group"> 
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-tab layui-tab-card" style="margin-top:20px;">
                            <ul class="layui-tab-title">
                                <li class="layui-this">镭雕码</li>
@@ -52,6 +52,12 @@
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="SN" id="SN" style="width:300px;">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">工序流转卡</label>
                                                <div class="layui-input-block">
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="HProcHBillNo" id="HProcHBillNo" >
                                                </div>
                                            </div>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
@@ -59,13 +65,13 @@
                                            <div class="layui-inline">
                                                <label class="layui-form-label">白标</label>
                                                <div class="layui-input-block">
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="SN_BB" id="SN_BB" style="background-color: #efefef4d; width: 215px; display: inline-block;" readonly>
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="SN_BB" id="SN_BB" style="background-color: #efefef4d; width: 215px; display: inline-block;" readonly disabled>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">黑标</label>
                                                <div class="layui-input-block">
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="SN_HB" id="SN_HB" style="background-color: #efefef4d; width: 215px; display: inline-block;" readonly>
                                                    <input type="text" class="layui-input ForFilteringSchemes" name="SN_HB" id="SN_HB" style="background-color: #efefef4d; width: 215px; display: inline-block;" readonly disabled>
                                                </div>
                                            </div>
                                            <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
@@ -168,12 +174,17 @@
                                    <div class="layui-row" style="padding:10px 0">
                                        <!--黑白标-->
                                        <table class="layui-hide" id="mainTable_HB_SN" lay-filter="mainTable_HB_SN"></table>
                                    </div>                                    
                                </div>                              
                                    </div>
                                </div>
                            </div>
                        </div>                                     
                        </div>
                        <script type="text/html" id="toolbarDemo">

                           
                        </script>
                        <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>
                            </div>
                        </script>
                    </form>
                </div>
@@ -229,11 +240,21 @@

            //#region æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                if ($('#SN').val() == "") {
                    layer.msg("请先输入SN码 ");
                if ($('#SN').val() == "" && $('#HProcHBillNo').val() == "") {
                    layer.msg("请先输入SN码 æˆ– æµè½¬å¡å·");
                    return;
                }
                get_FastQuery();//查询
            });
            //#endregion

            //#region å¤´å·¥å…·æ äº‹ä»¶
            table.on('toolbar(mainTable_HB_SN)', function (obj) {
                switch (obj.event) {                  
                    //导出按钮
                    case 'btn_Export': btn_Export();
                        break;
                };
            });
            //#endregion

@@ -303,33 +324,13 @@
            function get_FastQuery( ) {
               
                var SN = $("#SN").val();  //SN码
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HMaterName = $("#HMaterName").val();//物料名称
                var HMaterModel = $("#HMaterModel").val();//规格型号
                var HProcExchBillNo = $("#HProcExchBillNo").val();//主流转卡号
                var HICMOBillNo = $("#HICMOBillNo").val();//生产订单号
               
                var HProcHBillNo = $("#HProcHBillNo").val();//流转卡号            
                if (HProcHBillNo != "") {
                    get_Display_HProc(HProcHBillNo);
                } else {
                    get_Display(SN);
                }
                
                //if (SN) {
                //    sWhere += " and å”¯ä¸€ç  like '%" + SN + "%'";
                //}
                //if (HMaterNumber) {
                //    sWhere += " and ç‰©æ–™ä»£ç  like '%" + HMaterNumber + "%'";
                //}
                //if (HMaterName) {
                //    sWhere += " and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                //}
                //if (HMaterModel) {
                //    sWhere += " and è§„格型号 like '%" + HMaterModel + "%'";
                //}
                //if (HProcExchBillNo) {
                //    sWhere += " and æµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                //}
                //if (HICMOBillNo) {
                //    sWhere += " and ç”Ÿäº§è®¢å•å· like '%" + HICMOBillNo + "%'";
                //}

                get_Display(SN);
                sWhere = "";//调用接口后清空sWhere缓存
            }
            //#endregion
@@ -337,13 +338,16 @@
            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
            function set_ClearQuery() {
                $("#SN").val("");
                $("#SN_HB").val("");
                $("#SN_BB").val("");
                $("#HMaterNumber").val("");
                $("#HMaterName").val("");
                $("#HMaterModel").val("");
                $("#HProcExchBillNo").val("");
                $("#HICMOBillNo").val("");              

                sWhere = "";
                $("#HProcHBillNo").val("");
                var SN = "";
                get_Display(SN);
            }
            //#endregion     

@@ -367,8 +371,8 @@

            //#region é»‘白标_重置过滤条件方法
            function set_ClearQuery_HB() {
                $("#SN_HB").val("");
                $("#SN_BB").val("");                      
                $("#SN_HB1").val("");
                $("#SN_BB1").val("");                      

                sWhere = "";
            }
@@ -387,7 +391,13 @@
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , cols: []
                    , cols: [
                        [
                            { type: 'checkbox', fixed: 'left' }
                            , { field: '流转卡', title: '流转卡', sort: true, width: 200 }
                            , { field: '物料名称', title: '物料名称', sort: true, width: 200 }
                        ]
                    ]
                    ,data:[]
                };
            }
@@ -478,13 +488,16 @@
            function set_InitGrid_HB_SN() {
                option_HB_SN = {
                    elem: '#mainTable_HB_SN'
                    , toolbar: '#toolbarDemo'
                    , page: false
                    , height: 500
                    , toolbar: '#toolbarDemo1'
                    , page: true
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , height: 800
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: Number.MAX_VALUE//默认显示全部
                    , cols: []
                    ,data:[]
                };
            }

@@ -523,7 +536,7 @@
                                        switch (data[j].Type) {
                                            //int
                                            case 'DateTime':
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200});
@@ -603,17 +616,7 @@
                                , cellMinWidth: 90
                            }
                            table.render(option_Measure);

                            option_HB_SN = {
                                elem: '#mainTable_HB_SN'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[3]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList3
                                , height: 'full-80'
                                , cellMinWidth: 90
                            }
                            table.render(option_HB_SN);
                                                 
                                                                   
                            $("#HMaterNumber").val(data1.data.h_p_QC_FiveMenOneRingList[0].物料代码);
                            $("#HMaterName").val(data1.data.h_p_QC_FiveMenOneRingList[0].物料名称);
                            $("#HMaterModel").val(data1.data.h_p_QC_FiveMenOneRingList[0].规格型号);
@@ -657,12 +660,19 @@
                                for (var j = 0; j < data.length; j++) {
                                    if ($.inArray(data[j].name, titleData) > -1) {
                                        col.push({ field: data[j].id, title: data[j].name, align: 'center', hide: true }); //隐藏id列
                                    }                                   
                                    }
                                    else if (data[j].name == '白标号') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '白标号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.白标号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else {
                                        switch (data[j].Type) {
                                            //int
                                            case 'DateTime':
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200 });
@@ -675,14 +685,20 @@
                            //动态显示列名                           
                            option_HB_SN = {
                                elem: '#mainTable_HB_SN'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[3]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList3
                                , height: 'full-80'
                                , toolbar: '#toolbarDemo1'
                                , cols: [Listcol[0]]
                                , data: data1.data.h_v_QC_FiveMenOneRingList_HB
                                , height: 500
                                , page: true
                                , limit: 50
                                , limits: [50, 500, 5000, 20000]
                                , height: 800
                                , totalRow: true
                                , cellMinWidth: 90
                            }
                            table.render(option_HB_SN);
                           
                            ins = table.render(option_HB_SN);

                            layer.close(ajaxLoad);

                        } else {
@@ -697,155 +713,20 @@

            }
            //#endregion
                     
            //#endregion  ç›‘听网格表体事件

             //#region  ä¸»è¡¨æ ¼  æµè½¬å¡ç‚¹å‡»æ—¶é—´
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
            //#region å·¥åºæµè½¬å¡_查询
            function get_Display_HProc(HProcHBillNo) {
                var ajaxLoad = layer.load();
                var linterid;
                //单据号超链接
                if (obj.event == '流转卡') {                  //检查 obj.event æ˜¯å¦ç­‰äºŽå­—符串 '单据号'。如果等于，则执行if循环
                    linterid = data.流转卡id;                      
                } 
                $.ajax({
                    url: GetWEBURL() + '/QC_CustomerAppealReport/Get_QC_FiveMenOneRingList_Right',
                    url: GetWEBURL() + '/QC_CustomerAppealReport/Get_QC_FiveMenOneRingList_HProcHBillNoID',
                    type: "GET",
                    data: { "linterid": linterid, "user": sessionStorage["HUserName"] },
                    data: { "HProcHBillNo": HProcHBillNo, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var Listcol = [];
                            for (var i = 0; i < data1.list.length; i++) {
                                var data = [];
                                //给空的数组赋值
                                for (var key in data1.list[i].Columns) {
                                    data.push({ "id": data1.list[i].Columns[key].ColmCols, "name": data1.list[i].Columns[key].ColmCols, "Type": data1.list[i].Columns[key].ColmType });
                                }
                                var col = [];
                                col.push({ type: 'checkbox', fixed: 'left' });
                                for (var j = 0; j < data.length; j++) {
                                    if ($.inArray(data[j].name, titleData) > -1) {
                                        col.push({ field: data[j].id, title: data[j].name, align: 'center', hide: true }); //隐藏id列
                                    }
                                    else if (data[j].name == '单据号') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '单据号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.单据号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '职员') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '职员', templet: function (d) {
                                                return '<span style="color: blue;">' + d.职员 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '模具名称') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '模具名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.模具名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '设备名称') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '设备名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.设备名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '工序名称') {//添加超链接
                                         col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '工序名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.工序名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                         });
                                    }
                                    else {
                                         switch (data[j].Type) {
                                            //int
                                            case 'DateTime':
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: data[j].name });
                                        }
                                    }
                                }
                                Listcol.push(col);
                            }
                            //人
                            option_Man = {
                                elem: '#mainTable_Man'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[0]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                ,page: false
                            }
                            table.render(option_Man);
                            //机
                            option_Machine = {
                                elem: '#mainTable_Machine'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[1]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query1
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                , page: false
                            }
                            table.render(option_Machine);
                            //料
                            option_Material = {
                                elem: '#mainTable_Material'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[2]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query2
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                , page: false
                            }
                            table.render(option_Material);
                            //法
                            option_Method = {
                                elem: '#mainTable_Method'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[3]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query3
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Method);
                            //环
                            option_Environments = {
                                elem: '#mainTable_Environments'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[4]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query4
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Environments);
                            //测
                            option_Measure = {
                                elem: '#mainTable_Measure'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[5]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query5
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Measure);
                        if (data1.count == 1) {                           
                            var linterid = data1.data[0].hmainid;
                            getTable_Right(linterid);
                            layer.close(ajaxLoad);

                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
@@ -855,10 +736,44 @@
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });

            }
            //#endregion

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

            //#region  ä¸»è¡¨æ ¼  æµè½¬å¡ç‚¹å‡»äº‹ä»¶
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
                var ajaxLoad = layer.load();
                var linterid;
                //单据号超链接
                if (obj.event == '流转卡') {                  //检查 obj.event æ˜¯å¦ç­‰äºŽå­—符串 '单据号'。如果等于，则执行if循环
                    linterid = data.流转卡id;                      
                } 
                getTable_Right(linterid);
            });
            //#endregion  

            //#region副表格  
            //#region  é»‘白标页签  æµè½¬å¡ç‚¹å‡»äº‹ä»¶
            table.on('tool(mainTable_HB_SN)', function (obj) {
                var data = obj.data;
                //单据号超链接
                if (obj.event == '白标号') {                  //检查 obj.event æ˜¯å¦ç­‰äºŽå­—符串 '单据号'。如果等于，则执行if循环
                    $("#SN_BB1").val(data.白标号);
                    get_FastQuery_HB();
                }
                
            });
            //#endregion

            //#region å‰¯è¡¨æ ¼  
            //人
            table.on('tool(mainTable_Man)', function (obj) {
                var data = obj.data;
@@ -1439,7 +1354,159 @@
            });

            //#endregion     
           

            //#region æµè½¬å¡ç‚¹å‡»æŸ¥è¯¢ äººæœºæ–™æ³•çŽ¯
            function getTable_Right(linterid) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/QC_CustomerAppealReport/Get_QC_FiveMenOneRingList_Right',
                    type: "GET",
                    data: { "linterid": linterid, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var Listcol = [];
                            for (var i = 0; i < data1.list.length; i++) {
                                var data = [];
                                //给空的数组赋值
                                for (var key in data1.list[i].Columns) {
                                    data.push({ "id": data1.list[i].Columns[key].ColmCols, "name": data1.list[i].Columns[key].ColmCols, "Type": data1.list[i].Columns[key].ColmType });
                                }
                                var col = [];
                                col.push({ type: 'checkbox', fixed: 'left' });
                                for (var j = 0; j < data.length; j++) {
                                    if ($.inArray(data[j].name, titleData) > -1) {
                                        col.push({ field: data[j].id, title: data[j].name, align: 'center', hide: true }); //隐藏id列
                                    }
                                    else if (data[j].name == '单据号') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '单据号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.单据号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '职员') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '职员', templet: function (d) {
                                                return '<span style="color: blue;">' + d.职员 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '模具名称') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '模具名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.模具名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '设备名称') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '设备名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.设备名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else if (data[j].name == '工序名称') {//添加超链接
                                        col.push({
                                            field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: '工序名称', templet: function (d) {
                                                return '<span style="color: blue;">' + d.工序名称 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    }
                                    else {
                                        switch (data[j].Type) {
                                            //int
                                            case 'DateTime':
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, templet: "<div>{{d." + data[j].name + " ==null ?'':layui.util.toDateString(d." + data[j].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[j].id, title: data[j].name, align: 'center', sort: true, width: 200, event: data[j].name });
                                        }
                                    }
                                }
                                Listcol.push(col);
                            }
                            //人
                            option_Man = {
                                elem: '#mainTable_Man'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[0]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                , page: false
                            }
                            table.render(option_Man);
                            //机
                            option_Machine = {
                                elem: '#mainTable_Machine'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[1]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query1
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                , page: false
                            }
                            table.render(option_Machine);
                            //料
                            option_Material = {
                                elem: '#mainTable_Material'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[2]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query2
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , limit: Number.MAX_VALUE//默认显示全部
                                , page: false
                            }
                            table.render(option_Material);
                            //法
                            option_Method = {
                                elem: '#mainTable_Method'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[3]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query3
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Method);
                            //环
                            option_Environments = {
                                elem: '#mainTable_Environments'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[4]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query4
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Environments);
                            //测
                            option_Measure = {
                                elem: '#mainTable_Measure'
                                , toolbar: '#toolbarDemo'
                                , cols: [Listcol[5]]
                                , data: data1.data.h_p_QC_FiveMenOneRingList_Query5
                                , height: 'full-80'
                                , cellMinWidth: 90
                                , page: false
                            }
                            table.render(option_Measure);
                            layer.close(ajaxLoad);
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
           //#endregion  

            //#region éšè—åˆ—设置
            function get_HideColumn() {
                var colName = "";

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

New file
@@ -0,0 +1,557 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>生产质量日报_质量</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期间隔</label>
                                    <div class="layui-input-block">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">流转卡批次号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBatchNo" id="HBatchNo" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">是否量产</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
                                                <option value="">请选择</option>
                                                <option value="1">量产</option>
                                                <option value="0">非量产</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">项目号</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
                                                <!--动态渲染组织-->
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">事业部</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
                                                <!--动态渲染组织-->
                                            </select>
                                        </div>
                                    </div>
                                </div>                               
                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">工序名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" value="" style="background-color: #efefef4d; width: 75%; display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHProc" id="btnHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">操作员</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HReceiveMan" id="HReceiveMan" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">设备编号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" lay-verify="HEquipNumber" name="HEquipNumber" id="HEquipNumber" value="" style="background-color:#efefef4d;width: 75%;display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHEquip" id="btnHEquip" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                </div>
                            </div>
                        </div>
                        <div class="layui-tab layui-tab-card">
                            <div class="layui-tab-content">
                                <div class="layui-tab-item layui-show">
                                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                                </div>
                            </div>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script>
    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
    }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {

        //#region å…¬å…±å˜é‡
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;
        var HModName = "QC_QualityDailyReprot";
        var titleData = ["HInterID", "HProcExchInterID"];//表不需要显示的字段 å¯æ‰©å±•

        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
        //初始化界面
        set_ClearBill();

        //#endregion

        //#region è§¦å‘事件：包括form.on(){}格式的所有点击事件、选择事件等

        // å¤´å·¥å…·æ äº‹ä»¶
        table.on('toolbar(mainTable)', function (obj) {
            switch (obj.event) {               
                //导出excel
                case 'get_export':
                    get_Export();
                    break;
            };
        });

        //查询按钮
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
        });

        //重置
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
        });

        //日期间隔下拉列表监听
        form.on('select(HInitTimeCycle)', function (data) {
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
            if (HInitTimeCycle != -1) {
                $('#HBeginDate').prop('disabled', true);
                $('#HEndDate').prop('disabled', true);

                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));

                //执行查询方法
                get_FastQuery();
            } else {
                $('#HBeginDate').prop('disabled', false);
                $('#HEndDate').prop('disabled', false);
            }
        });

        //#endregion

        //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法

        // åˆå§‹åŒ–界面
        function set_ClearBill() {
            //初始化日期间隔、开始日期、结束日期
            setSelect_HInitTimeCycle();
            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            if (HInitTimeCycle != -1) {
                $('#HBeginDate').prop('disabled', true);
                $('#HEndDate').prop('disabled', true);
            } else {
                $('#HBeginDate').prop('disabled', false);
                $('#HEndDate').prop('disabled', false);
            }

            //根据日期间隔设置开始时间与结束时间
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            //初始化表
            set_InitGrid();
            Get_HProject(); //获取项目号
            GetGy_Division();//获取事业部
            //查询
            get_FastQuery();
        }
    
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: true
                , totalRow: true
                , limit: 500
                , data:[]
                , limits: [50, 500, 5000, 20000]
                , cols: []
            };
            table.render(option);
        }

        // æŸ¥è¯¢
        function get_Display(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/QC_CustomerAppealReport/GetQC_QualityDailyReprot',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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 });
                        }
                        //在列表左边添加勾选框
                        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) {
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                }
                            }
                        }
                        //动态显示列名
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , cols: [col]
                            , data: data1.data
                            , height: 'full-50'
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option);
                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                        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_FastQuery() {
            var HBeginDate = $("#HBeginDate").val();
            var HEndDate = $("#HEndDate").val();
            var HBatchNo = $("#HBatchNo").val();
            var HProject = $("#HProject").val();//项目号
            var HBatchWork = $("#HBatchWork").val();//是否量产
            var HDivisionName = $("#HDivisionName").val();//事业部
            var HProcName = $("#HProcName").val();//工序
            var HReceiveMan = $("#HReceiveMan").val();//操做员
            var HEquipNumber = $("#HEquipNumber").val();//设备编码

            sWhere = {
                HBeginDate: HBeginDate
                , HEndDate: HEndDate
                , HBatchNo: HBatchNo
                , HProject: HProject
                , HBatchWork: HBatchWork
                , HDivisionName: HDivisionName
                , HProcName: HProcName
                , HReceiveMan: HReceiveMan
                , HEquipNumber: HEquipNumber
            }
            get_Display(JSON.stringify(sWhere));
            sWhere = "";//调用接口后清空sWhere缓存
        }

        function set_ClearQuery() {
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //开始日期
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //结束日期          
            $("#HBatchWork").val("");
            $("#HProject").val("");
            $("#HReceiveMan").val("");
            $("#HBatchNo").val("");
            $("#HProcName").val("");
            $("#HEquipNumber").val("");          
            form.render('select');
            sWhere = "";
        }

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

        //#region èŽ·å–事业部
        function GetGy_Division() {
            //获取事业部
            var HDivisionList = '<option value="" style="color:red;" selected></option>';
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
                async: false,
                data: { "HOrgID": sessionStorage["OrganizationID"] },
                success: function (result) {
                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
                        }
                        $("#HDivisionName").append(HDivisionList);
                        form.render('select');

                    }
                    layer.closeAll("loading");
                }
            })
        }
        //#endregion

        //#region èŽ·å–项目号
        function Get_HProject() {
            //获取项目号
            var HProjectList = '<option value="" style="color:red;" selected></option>';
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Gy_Material/Get_HProject",
                async: false,
                data: { "HOrgID": sessionStorage["OrganizationID"] },
                success: function (result) {
                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
                        }
                        $("#HProject").append(HProjectList);
                        form.render('select');

                    }
                    layer.closeAll("loading");
                }
            })
        }
        //#endregion

        //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表
        function setSelect_HInitTimeCycle() {
            var valueList = [0, 1, 2, 3, 4, 5, 6, 29];
            var titleList = ["今天", "近两天", "近三天", "近四天", "近五天", "近六天", "近七天", "近30天"];

            var HInitTimeCycle_ArrayList = '<option  value="-1" selected="selected" >任意间隔</option>';
            for (var i = 0; i < valueList.length; i++) {
                HInitTimeCycle_ArrayList += '<option  style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>';
            }

            $("#HInitTimeCycle").empty();
            $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList);
            form.render('select');

            $("#HInitTimeCycle").val("2");
        }
        //#endregion

        //工序
        form.on('submit(btnHProc)', function () {
            //页面层-自定义
            layer.open({
                type: 2,
                skin: 'layui-layer-rim', //加上边框
                title: '工序列表',
                closeBtn: 1,
                shift: 2,
                area: ['90%', '90%'],
                maxmin: true,
                content: ['../../基础资料/生产基础资料/Gy_Process.html', '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('请选择数据');
                    }
                    $("#HProcName").val(checkStatus.data[0].工序名称);
                    layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                }
                , btn2: function (index, layero) {
                    //按钮【按钮二】的回调
                    //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                },
                end: function () {

                },
                success: function (layero, index) {

                }
            });
        });

        //#region æ˜¾ç¤ºåˆ—数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {

                        var dataCol = [];//数据库查询出的列数据
                        //var titleData = ["单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码"];//不需要显示的字段 å¯æ‰©å±•

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 1; i++) {
                            var dataCols = dataCol[i].split('|');
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }
            //#endregion

        //#endregion

        //以上是layui模块
    });




</script>

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

New file
@@ -0,0 +1,526 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>每日日报_质量</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期间隔</label>
                                    <div class="layui-input-block">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                    </div>
                                </div>                               
                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">是否量产</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
                                                <option value="">请选择</option>
                                                <option value="1">量产</option>
                                                <option value="0">非量产</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">项目号</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
                                                <!--动态渲染组织-->
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">事业部</label>
                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                            <select name="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
                                                <!--动态渲染组织-->
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">工序名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" value="" style="background-color: #efefef4d; width: 75%; display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHProc" id="btnHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                </div>                                                             
                            </div>
                        </div>
                        <div class="layui-tab layui-tab-card">
                            <div class="layui-tab-content">
                                <div class="layui-tab-item layui-show">
                                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                                </div>
                            </div>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script>
    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
    }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {

        //#region å…¬å…±å˜é‡
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var ins;
        var HModName = "QC_QualityDailyReprot_Sum";
        var titleData = ["HInterID", "HErrMsgBackTypeID", "HDeptID", "HHandleEmpID"];//表不需要显示的字段 å¯æ‰©å±•

        //#endregion

        //#region è¿›å…¥é¡µé¢å³åŠ è½½
        //初始化界面
        set_ClearBill();

        //#endregion

        //#region è§¦å‘事件：包括form.on(){}格式的所有点击事件、选择事件等

        // å¤´å·¥å…·æ äº‹ä»¶
        table.on('toolbar(mainTable)', function (obj) {
            switch (obj.event) {               
                //导出excel
                case 'get_export':
                    get_Export();
                    break;
            };
        });

        //查询按钮
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
        });

        //重置
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
        });

        //日期间隔下拉列表监听
        form.on('select(HInitTimeCycle)', function (data) {
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
            if (HInitTimeCycle != -1) {
                $('#HBeginDate').prop('disabled', true);
                $('#HEndDate').prop('disabled', true);

                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));

                //执行查询方法
                get_FastQuery();
            } else {
                $('#HBeginDate').prop('disabled', false);
                $('#HEndDate').prop('disabled', false);
            }
        });

        //#endregion

        //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法

        // åˆå§‹åŒ–界面
        function set_ClearBill() {
            //初始化日期间隔、开始日期、结束日期
            setSelect_HInitTimeCycle();
            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            if (HInitTimeCycle != -1) {
                $('#HBeginDate').prop('disabled', true);
                $('#HEndDate').prop('disabled', true);
            } else {
                $('#HBeginDate').prop('disabled', false);
                $('#HEndDate').prop('disabled', false);
            }

            //根据日期间隔设置开始时间与结束时间
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            //初始化表
            set_InitGrid();
            Get_HProject(); //获取项目号
            GetGy_Division();//获取事业部
            //查询
            get_FastQuery();
        }
    
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: true
                , totalRow: true
                , limit: 500
                , data:[]
                , limits: [50, 500, 5000, 20000]
                , cols: []
            };
            table.render(option);
        }

        // æŸ¥è¯¢
        function get_Display(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/QC_CustomerAppealReport/GetQC_QualityDailyReprot_Sum',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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 });
                        }
                        //在列表左边添加勾选框
                        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) {
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                }
                            }
                        }
                        //动态显示列名
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , cols: [col]
                            , data: data1.data
                            , height: 'full-50'
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option);
                        ins = table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                        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_FastQuery() {
            var HBeginDate = $("#HBeginDate").val();
            var HEndDate = $("#HEndDate").val();
            var HProject = $("#HProject").val();//项目号
            var HBatchWork = $("#HBatchWork").val();//是否量产
            var HDivisionName = $("#HDivisionName").val();//事业部
            var HProcName = $("#HProcName").val();//工序

            sWhere = {
                HBeginDate: HBeginDate
                , HEndDate: HEndDate
                , HProject: HProject
                , HBatchWork: HBatchWork
                , HDivisionName: HDivisionName
                , HProcName: HProcName
            }
            get_Display(JSON.stringify(sWhere));
            sWhere = "";//调用接口后清空sWhere缓存
        }

        function set_ClearQuery() {
            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //开始日期
            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //结束日期          
            $("#HBatchWork").val("");
            $("#HProject").val("");
            $("#HProcName").val("");         
            form.render('select');
            sWhere = "";
        }

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

        //#region èŽ·å–事业部
        function GetGy_Division() {
            //获取事业部
            var HDivisionList = '<option value="" style="color:red;" selected></option>';
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
                async: false,
                data: { "HOrgID": sessionStorage["OrganizationID"] },
                success: function (result) {
                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
                        }
                        $("#HDivisionName").append(HDivisionList);
                        form.render('select');

                    }
                    layer.closeAll("loading");
                }
            })
        }
        //#endregion

        //#region èŽ·å–项目号
        function Get_HProject() {
            //获取项目号
            var HProjectList = '<option value="" style="color:red;" selected></option>';
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Gy_Material/Get_HProject",
                async: false,
                data: { "HOrgID": sessionStorage["OrganizationID"] },
                success: function (result) {
                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
                        }
                        $("#HProject").append(HProjectList);
                        form.render('select');

                    }
                    layer.closeAll("loading");
                }
            })
        }
        //#endregion

        //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表
        function setSelect_HInitTimeCycle() {
            var valueList = [0, 1, 2, 3, 4, 5, 6, 29];
            var titleList = ["今天", "近两天", "近三天", "近四天", "近五天", "近六天", "近七天", "近30天"];

            var HInitTimeCycle_ArrayList = '<option  value="-1" selected="selected" >任意间隔</option>';
            for (var i = 0; i < valueList.length; i++) {
                HInitTimeCycle_ArrayList += '<option  style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>';
            }

            $("#HInitTimeCycle").empty();
            $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList);
            form.render('select');

            $("#HInitTimeCycle").val("29");
        }
        //#endregion

        //工序
        form.on('submit(btnHProc)', function () {
            //页面层-自定义
            layer.open({
                type: 2,
                skin: 'layui-layer-rim', //加上边框
                title: '工序列表',
                closeBtn: 1,
                shift: 2,
                area: ['90%', '90%'],
                maxmin: true,
                content: ['../../基础资料/生产基础资料/Gy_Process.html', '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('请选择数据');
                    }
                    $("#HProcName").val(checkStatus.data[0].工序名称);
                    layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                }
                , btn2: function (index, layero) {
                    //按钮【按钮二】的回调
                    //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                },
                end: function () {

                },
                success: function (layero, index) {

                }
            });
        });

        //#region æ˜¾ç¤ºåˆ—数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {

                        var dataCol = [];//数据库查询出的列数据
                        //var titleData = ["单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码"];//不需要显示的字段 å¯æ‰©å±•

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 1; i++) {
                            var dataCols = dataCol[i].split('|');
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }                         
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }
            //#endregion


        //#endregion

        //以上是layui模块
    });




</script>

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

@@ -360,7 +360,12 @@
                                                <input type="text" class="layui-input" name="HModel" id="HModel" value="" style="width: 190px;" readonly>
                                            </div>
                                        </div>

                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">设备工时</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMachineWorkTimes" id="HMachineWorkTimes" value="0" style="width: 190px;" >
                                            </div>
                                        </div>
                                        <div class="layui-col-xs8 layui-inline">
                                            <label class="layui-form-label">备注</label>
                                            <div class="layui-input-block">
@@ -942,6 +947,7 @@
                                "HMouldNo": data.模具编码,
                                "HMouldName": data.模具名称,
                                "HModel": data.模具型号,
                                "HMachineWorkTimes": data.设备工时
                            });
                            if (data.是否审核 == "true") {
                                $('#set_CheckBill').addClass("layui-btn-disabled").attr("disabled", true);//审核按钮禁用

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

@@ -280,6 +280,12 @@
                                                <input type="text" class="layui-input" name="HModel" id="HModel" value="" style="width: 150px;" readonly>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 65px;">设备工时</label>
                                            <div class="layui-input-block" style="margin-left: 95px;">
                                                <input type="text" class="layui-input" name="HMachineWorkTimes" id="HMachineWorkTimes" value="0" style="width: 150px;" >
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>