导入功能

wtt

2024-09-20 ff41a949c32757a249cccd206aa41d63a2bbdcd9

导入功能

 WebTM/WebTM.csproj

@@ -347,6 +347,10 @@
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_CheckNoteItem.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_TechnologyParameterType.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_MaintainLev.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_EquipType_Excel.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_MaterType_Excel.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_Material_Excel.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_MouldType_Excel.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_TechnologyParameterType.html" />
    <Content Include="views\基础资料\公用基础资料\SumAdd_Gy_RestDay.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_RestDay.html" />
@@ -419,6 +423,7 @@
    <Content Include="views\模治具管理\模治具点检保养\Sc_MouldDotCheckBill_PDA.html" />
    <Content Include="views\模治具管理\模治具点检保养\Sc_MouldDotCheckBill_PDA_OLD.html" />
    <Content Include="views\模治具管理\模治具点检保养\Sc_MouldMaintainBill_PDA.html" />
    <Content Include="views\模治具管理\模治具管理\Gy_MouldFile_Excel.html" />
    <Content Include="views\模治具管理\模治具管理\Sc_MouldMaintainRuleBillList_PDA.html" />
    <Content Include="views\生产管理\异常反馈单\OA_ErrMsgBackSignBill_BrushCard.html" />
    <Content Include="views\生产管理\异常反馈单\Sc_MESExecptFeedBackBillResumeList.html" />
@@ -462,6 +467,9 @@
    <Content Include="views\设备管理\设备报表\Sb_EquipResumeCheckQuery.html" />
    <Content Include="views\设备管理\设备报表\Sb_EquipRepairReport.html" />
    <Content Include="views\设备管理\设备报表\编辑页面\Edit_Sb_EquipMentCollectionTechParam.html" />
    <Content Include="views\设备管理\设备档案\Gy_EquipFile_Excel.html" />
    <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_FiveMenOneRingList.html" />
    <Content Include="views\质量管理\质量报表\QC_EquipMentCollectionTechParam.html" />

 WebTM/views/grf/Á÷ת¿¨TK.grf

@@ -7,6 +7,9 @@
        Charset=134
    End
    Object Printer
        Size=11
        Width=14.8
        Height=21
        LeftMargin=1.5
        TopMargin=1.5
        RightMargin=1.5
@@ -82,39 +85,39 @@
    Items Column
        Item
            Name='Column14'
            Width=1.69333
            Width=1.16417
        End
        Item
            Name='Column1'
            Width=1.87854
            Width=1.21708
        End
        Item
            Name='Column2'
            Width=2.01083
            Width=1.32292
        End
        Item
            Name='Column16'
            Width=2.01083
            Width=1.21708
        End
        Item
            Name='Column3'
            Width=1.61396
            Width=1.00542
        End
        Item
            Name='Column8'
            Width=2.16958
            Width=1.64042
        End
        Item
            Name='Column9'
            Width=1.79917
            Width=1.19063
        End
        Item
            Name='Column12'
            Width=2.98979
            Width=1.79917
        End
        Item
            Name='Column15'
            Width=1.79917
            Width=1.19063
        End
    End
Object ColumnContent
@@ -139,6 +142,12 @@
                    Type=FieldBox
                    Name='FieldBox14'
                    Dock=Fill
                    Object Font
                        Name='宋体'
                        Size=75000,0
                        Weight=400
                        Charset=134
                    End
                    DataField='工序号'
                End
                    End
@@ -147,7 +156,7 @@
        Column='Column1'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -157,7 +166,7 @@
        Column='Column2'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -170,7 +179,7 @@
        Column='Column16'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -180,7 +189,7 @@
        Column='Column3'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -190,7 +199,7 @@
        Column='Column8'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -201,7 +210,7 @@
        Column='Column9'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -213,7 +222,7 @@
        Column='Column12'
        Object Font
            Name='宋体'
            Size=90000,0
            Size=75000,0
            Weight=400
            Charset=134
        End
@@ -221,6 +230,12 @@
    End
    Item
        Column='Column15'
        Object Font
            Name='宋体'
            Size=75000,0
            Weight=400
            Charset=134
        End
        DataField='班号'
    End
End
@@ -234,8 +249,8 @@
            Column='Column14'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -246,8 +261,8 @@
            Column='Column1'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -258,8 +273,8 @@
            Column='Column2'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -268,6 +283,12 @@
        Item
            GroupTitle=F
            Column='Column16'
            Object Font
                Name='宋体'
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
            Text='工段名称'
        End
@@ -276,8 +297,8 @@
            Column='Column3'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -288,8 +309,8 @@
            Column='Column8'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -300,8 +321,8 @@
            Column='Column9'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -312,8 +333,8 @@
            Column='Column12'
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
@@ -322,6 +343,12 @@
        Item
            GroupTitle=F
            Column='Column15'
            Object Font
                Name='宋体'
                Size=75000,0
                Bold=T
                Charset=134
            End
            TextAlign=MiddleCenter
            Text='班号'
        End
@@ -349,9 +376,9 @@
            Item
                Type=MemoBox
                Name='MemoBox1'
                Left=5.00063
                Width=4.78896
                Height=0.79375
                Left=4.20688
                Width=2.06375
                Height=0.687917
                Object Font
                    Name='宋体'
                    Size=180000,0
@@ -364,13 +391,13 @@
            Item
                Type=MemoBox
                Name='MemoBox3'
                Left=11.5888
                Left=7.88458
                Top=2.19604
                Width=2.61938
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -379,23 +406,29 @@
            Item
                Type=MemoBox
                Name='MemoBox4'
                Left=4.20688
                Left=2.59292
                Top=1.00542
                Width=2.98979
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Bold=T
                    Charset=134
                End
                TextAlign=MiddleCenter
                Text='QC检查方式：'
            End
            Item
                Type=MemoBox
                Name='MemoBox8'
                Left=5.60917
                Left=4.15396
                Top=2.19604
                Width=1.40229
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -404,13 +437,13 @@
            Item
                Type=FieldBox
                Name='FieldBox1'
                Left=13.2027
                Left=9.2075
                Top=2.19604
                Width=3.99521
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -419,13 +452,13 @@
            Item
                Type=FieldBox
                Name='FieldBox6'
                Left=6.61458
                Left=5.15938
                Top=2.19604
                Width=3.78354
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -434,13 +467,13 @@
            Item
                Type=SystemVarBox
                Name='SystemVarBox1'
                Left=16.5894
                Top=1.19063
                Width=2.80458
                Left=10.7421
                Top=1.13771
                Width=1.79917
                Height=0.423333
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -450,13 +483,13 @@
            Item
                Type=SystemVarBox
                Name='SystemVarBox2'
                Left=15.3988
                Top=1.19063
                Width=2.40771
                Left=9.94833
                Top=1.13771
                Width=1.21708
                Height=0.423333
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -465,13 +498,13 @@
            Item
                Type=MemoBox
                Name='MemoBox18'
                Left=0.79375
                Left=0.211667
                Top=2.98979
                Width=2.61938
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -480,13 +513,13 @@
            Item
                Type=MemoBox
                Name='MemoBox19'
                Left=0.79375
                Left=0.211667
                Top=2.19604
                Width=2.80458
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -495,13 +528,13 @@
            Item
                Type=FieldBox
                Name='FieldBox9'
                Left=2.40771
                Left=1.40229
                Top=2.19604
                Width=2.38125
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -510,13 +543,13 @@
            Item
                Type=FieldBox
                Name='FieldBox10'
                Left=2.59292
                Left=1.79917
                Top=2.98979
                Width=1.79917
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -525,13 +558,13 @@
            Item
                Type=MemoBox
                Name='MemoBox21'
                Left=11.5888
                Left=8.20208
                Top=3.81
                Width=2.80458
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -540,7 +573,7 @@
            Item
                Type=Barcode
                Name='Barcode1'
                Left=12.1973
                Left=7.99042
                Top=0.79375
                Width=1.98438
                Height=1.21708
@@ -553,16 +586,22 @@
            Item
                Type=FieldBox
                Name='FieldBox11'
                Left=12.5942
                Left=9.60438
                Top=3.81
                Width=4.60375
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
                DataField='批次'
            End
            Item
                Type=Barcode
                Name='Barcode2'
                Left=1.5875
                Left=0.211667
                Top=0.608542
                Width=2.59292
                Height=1.40229
@@ -573,19 +612,31 @@
            Item
                Type=StaticBox
                Name='StaticBox1'
                Left=10.795
                Left=7.99042
                Top=0.211667
                Width=1.79917
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
                Text='流转卡号'
            End
            Item
                Type=FieldBox
                Name='FieldBox13'
                Left=12.5942
                Left=9.60438
                Top=0.211667
                Width=4.20688
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
                DataField='单据号'
            End
            Item
@@ -594,21 +645,33 @@
                Left=0.211667
                Width=5.79438
                Height=0.582083
                Object Font
                    Name='宋体'
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
                Text='任务单号：[#任务单号#]'
            End
            Item
                Type=MemoBox
                Name='MemoBox25'
                Left=7.19667
                Left=5.00063
                Top=1.00542
                Width=1.19063
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Bold=T
                    Charset=134
                End
                Text='抽检'
            End
            Item
                Type=ShapeBox
                Name='ShapeBox1'
                Left=8.59896
                Left=5.79438
                Top=1.00542
                Width=0.608542
                Height=0.582083
@@ -616,30 +679,36 @@
            Item
                Type=MemoBox
                Name='MemoBox26'
                Left=9.60438
                Left=6.40292
                Top=1.00542
                Width=1.19063
                Width=1.40229
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Bold=T
                    Charset=134
                End
                Text='抽检'
            End
            Item
                Type=ShapeBox
                Name='ShapeBox2'
                Left=11.0067
                Left=7.19667
                Top=1.00542
                Width=0.608542
                Width=0.582083
                Height=0.582083
            End
            Item
                Type=MemoBox
                Name='MemoBox27'
                Left=5.60917
                Left=3.81
                Top=2.98979
                Width=4.60375
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -648,13 +717,13 @@
            Item
                Type=MemoBox
                Name='MemoBox28'
                Left=11.5888
                Left=8.255
                Top=2.98979
                Width=6.21771
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -663,13 +732,13 @@
            Item
                Type=MemoBox
                Name='MemoBox29'
                Left=0.79375
                Left=0.211667
                Top=3.81
                Width=4.60375
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -678,13 +747,13 @@
            Item
                Type=MemoBox
                Name='MemoBox30'
                Left=5.60917
                Left=3.99521
                Top=3.81
                Width=4.60375
                Width=3.99521
                Height=0.608542
                Object Font
                    Name='宋体'
                    Size=90000,0
                    Size=75000,0
                    Bold=T
                    Charset=134
                End
@@ -706,32 +775,26 @@
                Object Border
                    Styles=[DrawLeft|DrawRight|DrawBottom]
                End
                ColumnCount=8
                ColumnCount=7
                RowCount=2
                Items FreeGridColumn
                    Item[1]
                        Width=1.6933
                        Width=2.3813
                    End
                    Item[2]
                        Width=1.8785
                        Width=1.3229
                    End
                    Item[3]
                        Width=2.0108
                        Width=1.2171
                    End
                    Item[4]
                        Width=2.0108
                        Width=1.0054
                    End
                    Item[5]
                        Width=1.614
                        Width=1.6404
                    End
                    Item[6]
                        Width=2.1696
                    End
                    Item[7]
                        Width=1.7992
                    End
                    Item[8]
                        Width=4.789
                        Width=1.1906
                    End
                            End
            Items FreeGridRow

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_EquipType.html

@@ -52,6 +52,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>反审核</button>
@@ -126,6 +127,9 @@
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //浏览
                    case 'btn-view':
@@ -388,7 +392,16 @@
                    layer.msg('请选择一行数据打印！');
                }
            }

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '工序资料导入'
                    , shift: 0//弹出动画
                    , content: './Gy_EquipType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //审核/反审核
            function set_CheckBill(num) {
                var checkStatus = table.checkStatus('mainTable')

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_EquipType_Excel.html

New file
@@ -0,0 +1,230 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>设备分类导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_EquipType/Gy_EquipType_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '设备分类', title: '设备分类', width: 120 }
                    , { field: '设备分类代码', title: '设备分类代码', width: 120 }
                    , { field: '助记码', title: '助记码', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_EquipType/Gy_EquipType_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_MaterType.html

@@ -142,6 +142,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="btn-Add"><i class="layui-iconlayuiiconfileb"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="btn-Edit"><i class="layuiiconlayuiiconform"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="btn-Delete"><i class="layuiiconlayuiicon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
@@ -223,6 +224,9 @@
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //保存方案
                    case 'set_SaveScheme': set_SaveScheme();
@@ -560,6 +564,17 @@
            }
            //#endregion

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '物料分类导入'
                    , shift: 0//弹出动画
                    , content: './Gy_MaterType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }

            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Gy_MaterType_ExportExcel";

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_MaterType_Excel.html

New file
@@ -0,0 +1,233 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>物料分类导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_MaterType/Gy_MaterType_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '物料分类', title: '物料分类', width: 120 }
                    , { field: '物料分类代码', title: '物料分类代码', width: 120 }
                    , { field: 'HParentID', title: 'HParentID', width: 120, hide: true }
                    , { field: '父类代码', title: '父类代码', width: 120 }
                    , { field: '父类名称', title: '父类名称', width: 120 }
                    , { field: '助记码', title: '助记码', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_MaterType/Gy_MaterType_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_Material.html

@@ -142,6 +142,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-NumAdd" id="btn-NumAdd"><i class="layu i-iconlayuiiconfileb"></i>流水号新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="btn-Edit"><i class="layuiiconlayuiiconform"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-copy" id="btn-copy"><i class="layuiiconlayuiiconform"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="btn-Delete"><i class="layuiiconlayuiicon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>反审核</button>
@@ -259,6 +260,9 @@
                        break;
                    //新增流水号按钮
                    case 'btn-NumAdd': set_NumAddNew();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    case 'btn-NumAdd':
                        set_NumAddNew();
@@ -749,7 +753,16 @@
                });
            }
            //#endregion

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '工序资料导入'
                    , shift: 0//弹出动画
                    , content: './Gy_Material_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //#region åˆ é™¤
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_Material_Excel.html

New file
@@ -0,0 +1,255 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>物料导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_Material/Gy_Material_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '物料名称', title: '物料名称', width: 120 }
                    , { field: '物料代码', title: '物料代码', width: 120 }
                    , { field: '规格型号', title: '规格型号', width: 120 }
                    , { field: '助记码', title: '助记码', width: 120 }
                    , { field: '版本号', title: '版本号', width: 120 }
                    , { field: 'HMaterClsID', title: 'HMaterClsID', width: 120, hide: true }
                    , { field: '物料属性', title: '物料属性', width: 120 }
                    , { field: 'HUnitGroupID', title: 'HUnitGroupID', width: 120, hide: true }
                    , { field: '计量单位组', title: '计量单位组', width: 120 }
                    , { field: 'HUnitID', title: 'HUnitID', width: 120, hide: true }
                    , { field: '计量单位代码', title: '计量单位代码', width: 120 }
                    , { field: '计量单位', title: '计量单位', width: 120 }
                    , { field: 'HSecUnitID', title: 'HSecUnitID', width: 120, hide: true }
                    , { field: '辅助计量单位', title: '辅助计量单位', width: 120 }
                    , { field: '换算率', title: '换算率', width: 120 }
                    , { field: 'HWhID', title: 'HWhID', width: 120, hide: true }
                    , { field: '默认仓库', title: '默认仓库', width: 120 }
                    , { field: '最高库存', title: '最高库存', width: 120 }
                    , { field: '最低库存', title: '最低库存', width: 120 }
                    , { field: '安全库存', title: '安全库存', width: 120 }
                    , { field: '采购单价', title: '采购单价', width: 120 }
                    , { field: '销售单价', title: '销售单价', width: 120 }
                    , { field: '计划单价', title: '计划单价', width: 120 }
                    , { field: '标准成本', title: '标准成本', width: 120 }
                    , { field: '保质期', title: '保质期', width: 120 }
                    , { field: '最小订货量', title: '最小订货量', width: 120 }
                    , { field: '最大订货量', title: '最大订货量', width: 120 }
                    , { field: '英文名称', title: '英文名称', width: 120 }
                    , { field: '英文规格', title: '英文规格', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_Material/Gy_Material_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_MouldType.html

@@ -154,6 +154,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit" id="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>审核</button>
@@ -234,6 +235,9 @@
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //浏览
                    case 'btn-view':
@@ -692,7 +696,16 @@
                });

            }

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '器具分类导入'
                    , shift: 0//弹出动画
                    , content: './Gy_MouldType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //删除
            function set_DeleteBill() {
                var ModRightNameDelete = 'Gy_MouldType_Delete';

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_MouldType_Excel.html

New file
@@ -0,0 +1,230 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>器具分类导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_MouldType/Gy_MouldType_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '器具分类', title: '器具分类', width: 120 }
                    , { field: '器具分类代码', title: '器具分类代码', width: 120 }
                    , { field: '助记码', title: '助记码', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_MouldType/Gy_MouldType_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

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

@@ -74,6 +74,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btnModify"><i class="layui-icon layui-icon-edit"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btndelete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>反审核</button>
@@ -138,6 +139,9 @@
                        break;
                    //打印
                    case 'btn-print': get_PrintReport();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //编辑按钮
                    case 'btnModify': set_ShowBill();
@@ -404,7 +408,16 @@
                    layer.msg('请选择一行数据编辑！');
                }
            }

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '工序资料导入'
                    , shift: 0//弹出动画
                    , content: './Gy_MouldFile_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //删除
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')

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

New file
@@ -0,0 +1,259 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>器具主档导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_MouldFile/Gy_MouldFile_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '器具名称', title: '器具名称', width: 120 }
                    , { field: '器具编号', title: '器具编号', width: 120 }
                    , { field: 'HMouldTypeID', title: 'HMouldTypeID', width: 120, hide: true }
                    , { field: '器具分类', title: '器具分类', width: 120 }
                    , { field: '器具规格', title: '器具规格', width: 120 }
                    , { field: '器具型号', title: '器具型号', width: 120 }
                    , { field: '穴数', title: '穴数', width: 120 }
                    , { field: '辅助属性1', title: '辅助属性1', width: 120 }
                    , { field: '辅助属性2', title: '辅助属性2', width: 120 }
                    , { field: '图号', title: '图号', width: 120 }
                    , { field: 'HMaterID', title: 'HMaterID', width: 120, hide: true }
                    , { field: '对应ERP物料代码', title: '对应ERP物料代码', width: 120 }
                    , { field: '对应ERP物料', title: '对应ERP物料', width: 120 }
                    , { field: 'HUnitID', title: 'HUnitID', width: 120, hide: true }
                    , { field: '计量单位', title: '计量单位', width: 120 }
                    , { field: '器具出厂编号', title: '器具出厂编号', width: 120 }
                    , { field: 'HDeptID', title: 'HDeptID', width: 120, hide: true }
                    , { field: '使用部门', title: '使用部门', width: 120 }
                    , { field: '状态', title: '状态', width: 120 }
                    , { field: 'HWHID', title: 'HWHID', width: 120, hide: true }
                    , { field: '默认仓库', title: '默认仓库', width: 120 }
                    , { field: 'HSPID', title: 'HSPID', width: 120, hide: true }
                    , { field: '默认仓位', title: '默认仓位', width: 120 }
                    , { field: '版本号', title: '版本号', width: 120 }
                    , { field: '设计寿命', title: '设计寿命', width: 120 }
                    , { field: '使用寿命', title: '使用寿命', width: 120 }
                    , { field: '条形码', title: '条形码', width: 120 }
                    , { field: 'HSupID', title: 'HSupID', width: 120, hide: true }
                    , { field: '供应商代码', title: '供应商代码', width: 120}
                    , { field: '供应商', title: '供应商', width: 120 }
                    , { field: 'HMadeSupID', title: 'HMadeSupID', width: 120, hide: true }
                    , { field: '制造商', title: '制造商', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_MouldFile/Gy_MouldFile_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/É豸¹ÜÀí/É豸µµ°¸/Gy_EquipFileMainList.html

@@ -72,6 +72,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btnAdd"><i class="layui-icon layui-icon-add-1"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btnModify"><i class="layui-icon layui-icon-edit"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btndelete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
@@ -137,6 +138,9 @@
                        break;
                    //预览
                    case 'btn-view': get_ViewReport();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //打印
                    case 'btn-print': get_PrintReport();
@@ -440,7 +444,16 @@
                    layer.msg('请选择一行数据删除！');
                }
            }

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '设备档案导入'
                    , shift: 0//弹出动画
                    , content: './Gy_EquipFile_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //审核/反审核
            function set_CheckBill(num) {
                var checkStatus = table.checkStatus('mainTable')

 WebTM/views/É豸¹ÜÀí/É豸µµ°¸/Gy_EquipFile_Excel.html

New file
@@ -0,0 +1,257 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>设备档案导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_EquipFileMain/Gy_EquipFileMain_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '设备名称', title: '设备名称', width: 120 }
                    , { field: '设备编号', title: '设备编号', width: 120 }
                    , { field: 'HEquipTypeID', title: 'HEquipTypeID', width: 120, hide: true }
                    , { field: '设备分类', title: '设备分类', width: 120 }
                    , { field: '设备规格', title: '设备规格', width: 120 }
                    , { field: '设备型号', title: '设备型号', width: 120 }
                    , { field: 'HMaterID', title: 'HMaterID', width: 120, hide: true }
                    , { field: '对应ERP物料代码', title: '对应ERP物料代码', width: 120 }
                    , { field: '对应ERP物料', title: '对应ERP物料', width: 120 }
                    , { field: 'HUnitID', title: 'HUnitID', width: 120, hide: true }
                    , { field: '计量单位', title: '计量单位', width: 120 }
                    , { field: '设备出厂日期', title: '设备出厂日期', width: 120 }
                    , { field: '设备出厂编号', title: '设备出厂编号', width: 120 }
                    , { field: 'HDeptID', title: 'HDeptID', width: 120, hide: true }
                    , { field: '使用部门', title: '使用部门', width: 120 }
                    , { field: 'HUseEmpID', title: 'HUseEmpID', width: 120, hide: true }
                    , { field: '使用负责人', title: '使用负责人', width: 120 }
                    , { field: 'HRepairEmpID', title: 'HRepairEmpID', width: 120, hide: true }
                    , { field: '维护负责人', title: '维护负责人', width: 120 }
                    , { field: '安装地点', title: '安装地点', width: 120 }
                    , { field: '安装日期', title: '安装日期', width: 120 }
                    , { field: '运行开始日期', title: '运行开始日期', width: 120 }
                    , { field: '工程编码', title: '工程编码', width: 120 }
                    , { field: '条形码', title: '条形码', width: 120 }
                    , { field: '产地', title: '产地', width: 120 }
                    , { field: '品牌', title: '品牌', width: 120 }
                    , { field: 'HSupID', title: 'HSupID', width: 120, hide: true }
                    , { field: '供应商', title: '供应商', width: 120 }
                    , { field: 'HMadeSupID', title: 'HMadeSupID', width: 120, hide: true }
                    , { field: '制造商', title: '制造商', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_EquipFileMain/Gy_EquipFileMain_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/ÖÊÁ¿¹ÜÀí/»ù´¡½¨Ä£/Gy_ErrMsgBackType.html

@@ -135,6 +135,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="AddButton"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="EditButton"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="DeleteButton"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>反审核</button>
@@ -197,6 +198,9 @@
                        break;
                    //删除
                    case 'btn-Delete': set_DeleteBill();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -519,6 +523,17 @@
            function get_Refresh() {
                $("#btnSearch").trigger('click');
            }
            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '工序资料导入'
                    , shift: 0//弹出动画
                    , content: './Gy_ErrMsgBackType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }

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

 WebTM/views/ÖÊÁ¿¹ÜÀí/»ù´¡½¨Ä£/Gy_ErrMsgBackType_Excel.html

New file
@@ -0,0 +1,229 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>异常反馈类型导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_ErrMsgBackType/Gy_ErrMsgBackType_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '异常反馈类型', title: '异常反馈类型', width: 120 }
                    , { field: '异常反馈类型代码', title: '异常反馈类型代码', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_ErrMsgBackType/Gy_ErrMsgBackType_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>

 WebTM/views/ÖÊÁ¿¹ÜÀí/»ù´¡½¨Ä£/Gy_ErrType.html

@@ -132,6 +132,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Edit" id="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Delete" id="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit" id="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit" id="btn-Audit"><i class="layui-icon layui-icon-radio"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Stop" id="btn-Stop"><i class="layui-icon layui-icon-radio"></i>禁用</button>
@@ -197,6 +198,9 @@
                        break;
                    //删除
                    case 'btn-Delete': set_DeleteBill();
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    //审核按钮
                    case 'btn-Audit':
@@ -489,6 +493,18 @@
                    }
                });
            }

            //导入
            function set_SouceExcel() {
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '异常类型导入'
                    , shift: 0//弹出动画
                    , content: '../基础建模/Gy_ErrType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }

            //编辑
            function set_ShowBill() {
                var checkStatus = table.checkStatus('mainTable')

 WebTM/views/ÖÊÁ¿¹ÜÀí/»ù´¡½¨Ä£/Gy_ErrType_Excel.html

New file
@@ -0,0 +1,229 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>异常类型导入</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;" >
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入数据</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--基本信息-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">

                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                        </div>
                    </script>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], 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
            , util = layui.util
            , tree = layui.tree
            , util = layui.util
            , upload = layui.upload


        var option = [];
        //#endregion

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

        //初始化界面
        set_ClearBill();


        //#endregion

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

        //文件上传
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Gy_ErrType/Gy_ErrType_Excel',
            contentType: 'application/json',
            exts: 'xls|xlsx', //允许上传的类型
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                } else {
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('导入出现异常', { icon: 2 });
            }
        });

        //行内事件
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //行内删除
        });

        //导入  ä¿å­˜æ•°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("无数据,请先导入数据!");
            }
        })

        //退出
        form.on('submit(Cancel)', function () {
            Pub_Close(1);
        })


        //#endregion

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

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


        //初始化表格
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-120'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
                    , { field: '组织代码', title: '组织代码', width: 120 }
                    , { field: '组织名称', title: '组织名称', width: 120 }
                    , { field: '异常类型', title: '异常类型', width: 120 }
                    , { field: '异常类型代码', title: '异常类型代码', width: 120 }
                    , { field: '备注', title: '备注', width: 120 }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
            };

            //渲染页面
            table.render(option);
            //DisPlay_HideColumn();
        }

        //行内删除
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('真的删除行吗？', function (index) {
                    console.log("索引为:" + rowIndex);
                    if (rowIndex === '0') {
                        layer.msg('首行无法删除！！！');
                    } else {
                        var oldData = option.data;
                        oldData.splice(obj.tr.data('index'), 1)
                        option.data = oldData;//将数据绑定到data上
                        table.render(option);
                        layer.close(index);
                    }
                });
            }
        }

        //导入(保存)
        function set_AddNew(data) {
            var num = [];
            for (var i = 0; i < option.data.length; i++) {
                if (option.data[i] != "") {
                    num.push(option.data[i])
                }
            }

            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr + '&和' + sessionStorage["HUserName"];
            var index = layer.load();

            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Gy_ErrType/Gy_ErrType_btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        layer.close(index);
                        layer.msg(data.Message);
                        option.data = null;
                        table.cache["mainTable"] = null;
                        table.render(option);
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                }
            });
        }

        //#endregion

    });

</script>