From 351935155e6e7847c95060d127fca19b4337858b Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期一, 17 二月 2025 17:41:09 +0800
Subject: [PATCH] 1

---
 WebTM/views/WMS扫码模块/客户条码扫描/Gy_getCusBarCodeBillList.html |    2 
 WebTM/views/基础资料/隐藏列设置/Gy_GridView_Hide_New.html         |    2 
 WebTM/views/生产管理/日计划报表/ReportPODemandPlanBillList_S.html |  311 ---------------
 WebTM/views/系统管理/用户管理/Xt_UserList.html                   |  129 +++--
 WebTM/views/系统管理/用户管理/Xt_UserGroupList.html              |  127 +++--
 WebTM/views/系统管理/用户管理/Xt_UserListEdit.html               |   23 
 WebTM/views/生产管理/齐套分析/JIT_CompleteMaterlDetailList.html  |  204 ++-------
 WebTM/views/生产管理/宝工排产/JIT_DayPlanPlatForm.html           |   12 
 WebTM/views/生产管理/日计划报表/ReportPODemandPlanBillList.html   |  280 --------------
 9 files changed, 243 insertions(+), 847 deletions(-)

diff --git "a/WebTM/views/WMS\346\211\253\347\240\201\346\250\241\345\235\227/\345\256\242\346\210\267\346\235\241\347\240\201\346\211\253\346\217\217/Gy_getCusBarCodeBillList.html" "b/WebTM/views/WMS\346\211\253\347\240\201\346\250\241\345\235\227/\345\256\242\346\210\267\346\235\241\347\240\201\346\211\253\346\217\217/Gy_getCusBarCodeBillList.html"
index d73e5f0..b1046bf 100644
--- "a/WebTM/views/WMS\346\211\253\347\240\201\346\250\241\345\235\227/\345\256\242\346\210\267\346\235\241\347\240\201\346\211\253\346\217\217/Gy_getCusBarCodeBillList.html"
+++ "b/WebTM/views/WMS\346\211\253\347\240\201\346\250\241\345\235\227/\345\256\242\346\210\267\346\235\241\347\240\201\346\211\253\346\217\217/Gy_getCusBarCodeBillList.html"
@@ -410,7 +410,7 @@
 
 
                 var HMaker = sessionStorage["HUserName"];
-                if (HMaker != "admin") {
+                if (HMaker != "Admin") {
                     sWhere = " and 鍒跺崟浜� = '" + HMaker + "' ";
                 }
 
diff --git "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\351\232\220\350\227\217\345\210\227\350\256\276\347\275\256/Gy_GridView_Hide_New.html" "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\351\232\220\350\227\217\345\210\227\350\256\276\347\275\256/Gy_GridView_Hide_New.html"
index fb40b58..d8acdaa 100644
--- "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\351\232\220\350\227\217\345\210\227\350\256\276\347\275\256/Gy_GridView_Hide_New.html"
+++ "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\351\232\220\350\227\217\345\210\227\350\256\276\347\275\256/Gy_GridView_Hide_New.html"
@@ -403,7 +403,7 @@
                 , limit: 500
                 , cols: [[
                     { type: 'checkbox', fixed: 'left', style: 'background-color:#efefef4d;' }
-                    , { type: 'numbers', title: '搴忓彿', width: 100, style: 'background-color:#efefef4d;' }
+                    , { type: 'numbers', field:'搴忓彿', title: '搴忓彿', width: 100, style: 'background-color:#efefef4d;' }
                     , { field: 'ColumnName', title: '鍒楀悕', width: 100 }
                     , { file: 'IsHide', title: '鏄惁闅愯棌', width: 100, templet: '#IsHide' }
                     , { field: 'Alignment', title: '瀵归綈鏂瑰紡', width: 100, templet: '#Alignment' }
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
index 608cc8e..f5b9487 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\256\235\345\267\245\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
@@ -22,17 +22,17 @@
                     <form class="layui-form" action="" lay-filter="component-form-group">
                         <div style="padding: 10px; ">
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelImport" id="ExcelImport">Excel瀵煎叆</button>
-                            <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="btnLock" id="btnLock">閿佸畾</button>
-                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">瑙i攣</button>
-                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">榻愬鍒嗘瀽</button>
-                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">鎻愭枡杩愮畻</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">鐢熶骇璁㈠崟閫夊崟</button>
+                            <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="btnReady" id="btnReady">鍑嗗</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnProPC" id="btnProPC">鎺掍骇</button>
-                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">宸ヨ壓璺嚎</button>-->
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLock" id="btnLock">閿佸畾</button>
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">瑙i攣</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">閿佸畾宸ュ崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">瑙i攣宸ュ崟</button>
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">榻愬鍒嗘瀽</button>
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">鎻愭枡杩愮畻</button>
+                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">宸ヨ壓璺嚎</button>-->
                         </div>
                         <div class="layui-collapse resizable-container">
                             <div class="layui-colla-item">
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList.html"
index 361af3a..8cd624b 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList.html"
@@ -88,89 +88,6 @@
                                     </div>
 
                                     <hr />
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
-                                    </div>
                                 </div>
                             </div>
                         </div>
@@ -421,80 +338,6 @@
             var HSUPPLIERID = $("#HSUPPLIERID").val();//渚涘簲鍟�
             var HXQD = $("#HXQD").val();//闇�姹傚崟鍙�
             var HPURORDERNO = $("#HPURORDERNO").val();//閲囪喘璁㈠崟鍙�
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
             if (HBEGINDATE > HENDDATE) {
                 return layer.msg("寮�濮嬫棩鏈熶笉鑳藉皬浜庣粨鏉熸棩鏈�!");
             }
@@ -526,15 +369,6 @@
             $("#HSUPPLIERNAME").val("");
             $("#HXQD").val("");//闇�姹傚崟鍙�
             $("#HPURORDERNO").val("");//閲囪喘璁㈠崟鍙�
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
             form.render('select');
             sWhere = "";
         }
@@ -573,7 +407,7 @@
                 , area: ['90%', '90%']//澶у皬
                 , title: '渚涘簲鍟嗗垪琛�'//鏍囬
                 , shift: 2//寮瑰嚭鍔ㄧ敾
-                , content: ['../../鍩虹璧勬枡/閲囪喘鍩虹璧勬枡/Gy_Supplier.html', 'yes']
+                , content: ['../../鍩虹璧勬枡/閲囪喘鍩虹璧勬枡/Gy_Supplier.html?Type=HSup', 'yes']
                 , btn: ['纭畾', '鍙栨秷']
                 , btn1: function (index, layero) {//鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
                     var iframeWindow = window['layui-layer-iframe' + index]  //鑾峰彇寮规椤甸潰
@@ -605,110 +439,6 @@
             table.exportFile(ins.config.id, data, "xls");
         }
 
-        //闅愯棌鍒楄缃�
-        function get_HideColumn() {
-            var colName = "";
-            for (var i = 1; i < option.cols[0].length; i++) {
-                colName += option.cols[0][i]["title"] + ",";
-            }
-
-            colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
-            layer.open({
-                type: 2
-                , skin: "layui-layer-rim" //鍔犱笂杈规
-                , title: "闅愯棌鍒楄缃�"  //鏍囬
-                , closeBtn: 1  //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
-                , shift: 2 //寮瑰嚭鍔ㄧ敾
-                , area: ["50%", "90%"] //绐椾綋澶у皬
-                , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
-                , content: ['../../鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
-                , btn: ["纭畾", "鍙栨秷"]
-                , btn1: function (index, laero) {
-                    //鍒锋柊琛ㄦ牸鏁版嵁
-                    DisPlay_HideColumn();
-                    //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
-                    layer.close(index);//鍏抽棴寮圭獥
-                }
-            })
-        }
-
-        //鏄剧ず鍒楁暟鎹�
-        function DisPlay_HideColumn() {
-            $.ajax({
-                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
-                type: "GET",
-                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
-                success: function (data1) {
-                    if (data1.data.length != 0) {
-
-                        var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
-                        var titleData = [];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
-
-                        dataCol = data1.data[0].HGridString.split(',');
-
-                        for (var i = 0; i < option.cols[0].length - 1; i++) {
-                            if (dataCol[i]) {
-                                var dataCols = dataCol[i].split('|');
-                            }
-                            //闅愯棌鍒�
-                            if (dataCols[1] == 1) {
-                                option.cols[0][i + 1]["hide"] = true;
-                            }
-                            //璁剧疆鍐呭瀛椾綋澶у皬
-                            if (data1.data[0].HFontSize != 0) {
-                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
-                            } else {
-                                option.cols[0][i + 1]["style"] = "font-size:100%";
-                            }
-                            //璁剧疆鍒楀
-                            if (dataCols[3] > 0) {
-                                option.cols[0][i + 1]["width"] = dataCols[3];
-                            }
-                            //鏄剧ず鍒�
-                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
-                                option.cols[0][i + 1]["hide"] = false;
-                            }
-                            //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
-                            switch (dataCols[2]) {
-                                case "L":
-                                    option.cols[0][i + 1]["align"] = "left";
-                                    break;
-                                case "M":
-                                    option.cols[0][i + 1]["align"] = "center";
-                                    break;
-                                case "R":
-                                    option.cols[0][i + 1]["align"] = "right";
-                                    break;
-                            }
-                        }
-
-                        //鍙栨秷鍐荤粨鍒�
-                        for (var i = 1; i < option.cols[0].length - 1; i++) {
-                            if (option.cols[0][i]["fixed"] != null) {
-                                option.cols[0][i]["fixed"] = null;
-                            }
-                            else {
-                                break;
-                            }
-                        }
-                        //鍐荤粨鍒�
-                        if (data1.data[0].HFixCols != 0) {
-                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
-                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
-                                    data1.data[0].HFixCols += 1;
-                                }
-                                option.cols[0][i + 1]["fixed"] = "left";
-                            }
-                        }
-                        table.render(option);
-                    } else {
-                        table.render(option);
-                    }
-                }, error: function () {
-                    layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
-                }
-            })
-        }
         //鍒楁槑鏄剧ず涓嬫媺妗�
         function ColFilter() {
             var Organization = '<option  value="0" selected="selected" ></option>';
@@ -729,4 +459,12 @@
         //#endregion
         //浠ヤ笂鏄痩ayui妯″潡
     });
+    function GetHSupNameValue(obj) {
+        $("#HSUPPLIERID").val(obj[0].HItemID);
+        $("#HSUPPLIERNAME").val(obj[0].渚涘簲鍟嗗悕绉�);
+    }
+    function GetGyMaterial(obj) {
+        $("#HMATERIALID").val(obj.HItemID);
+        $("#HMATERIALNAME").val(obj.鐗╂枡鍚嶇О);
+    }
 </script>
\ No newline at end of file
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
index de1bc51..68b8ae4 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
@@ -89,90 +89,6 @@
                                             </div>
                                         </div>
                                     </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
-                                    </div>
                                 </div>
                             </div>
                         </div>
@@ -566,81 +482,6 @@
             var HXQD = $("#HXQD").val();//闇�姹傚崟鍙�
             var HPURORDERNO = $("#HPURORDERNO").val();//閲囪喘璁㈠崟鍙�
 
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
             if (HBEGINDATE > HENDDATE) {
                 return layer.msg("寮�濮嬫棩鏈熶笉鑳藉皬浜庣粨鏉熸棩鏈�!");
             }
@@ -682,15 +523,6 @@
             $("#HSUPPLIERNAME").val("");
             $("#HXQD").val("");//闇�姹傚崟鍙�
             $("#HPURORDERNO").val("");//閲囪喘璁㈠崟鍙�
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
             form.render('select');
             sWhere = " where 1=1 ";
         }
@@ -729,7 +561,7 @@
                 , area: ['90%', '90%']//澶у皬
                 , title: '渚涘簲鍟嗗垪琛�'//鏍囬
                 , shift: 2//寮瑰嚭鍔ㄧ敾
-                , content: ['../../鍩虹璧勬枡/閲囪喘鍩虹璧勬枡/Gy_Supplier.html', 'yes']
+                , content: ['../../鍩虹璧勬枡/閲囪喘鍩虹璧勬枡/Gy_Supplier.html?Type=HSup', 'yes']
                 , btn: ['纭畾', '鍙栨秷']
                 , btn1: function (index, layero) {//鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
                     var iframeWindow = window['layui-layer-iframe' + index]  //鑾峰彇寮规椤甸潰
@@ -764,140 +596,15 @@
             form.render('select');
         }
 
-        //#region 闅愯棌鍒楄缃�
-        function get_HideColumn() {
-            var colName = "";
-            var contentUrl = "";
-            for (var i = 1; i < option.cols[0].length; i++) {
-                colName += option.cols[0][i]["field"] + ",";
-            }
-            var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞
-            var urlLen = urlStr.split('/');
-            for (var i = 0; i < urlLen.length - 4; i++) {
-                contentUrl += "../";
-            }
-            colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
-
-            contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName;
-
-            layer.open({
-                type: 2
-                , skin: "layui-layer-rim" //鍔犱笂杈规
-                , title: "闅愯棌鍒楄缃�"  //鏍囬
-                , closeBtn: 1  //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
-                , shift: 2 //寮瑰嚭鍔ㄧ敾
-                , area: ["50%", "90%"] //绐椾綋澶у皬
-                , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
-                , content: [contentUrl, "yes"]
-                , btn: ["纭畾", "鍙栨秷"]
-                , btn1: function (index, laero) {
-                    //鍒锋柊琛ㄦ牸鏁版嵁
-                    DisPlay_HideColumn();
-                    //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
-                    layer.close(index);//鍏抽棴寮圭獥
-                }
-            })
-        }
-        //#endregion
-
-        //#region 鏄剧ず鍒楁暟鎹�
-        function DisPlay_HideColumn() {
-            $.ajax({
-                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
-                type: "GET",
-                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
-                success: function (data1) {
-                    if (data1.data.length != 0) {
-                        titleData = [];
-                        var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
-                        var newCols = [[]];//瀵瑰簲鏁版嵁搴撳垪椤哄簭col
-                        newCols[0].push(option.cols[0][0]);//鏀惧叆绗竴涓猚heckbox
-                        dataCol = data1.data[0].HGridString.split(',');
-                        //鍒楄缃垪鏁颁笌椤甸潰鍒楁暟鏄惁涓�鑷�
-                        if (dataCol.length == option.cols[0].length - 1) {
-                            //閬嶅巻瀵绘壘鍒楄缃搴斿垪鎸夐『搴忔彃鍏�
-                            for (var j = 0; j < option.cols[0].length - 1; j++) {
-                                for (var i = 0; i < option.cols[0].length - 1; i++) {
-                                    var dataCols = dataCol[j].split('|');
-                                    //閫夋嫨涓巇atacols鐩稿簲鍒楄繘琛屼慨鏀�
-                                    if (option.cols[0][i + 1]["field"] == dataCols[5]) {
-                                        //闅愯棌鍒�
-                                        if (dataCols[1] == 1) {
-                                            option.cols[0][i + 1]["hide"] = true;
-                                        }
-                                        //璁剧疆鍒楀
-                                        if (dataCols[3] > 0) {
-                                            option.cols[0][i + 1]["width"] = dataCols[3];
-                                        }
-                                        //璁剧疆鍐呭瀛椾綋澶у皬
-                                        if (data1.data[0].HFontSize != 0) {
-                                            option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
-                                        } else {
-                                            option.cols[0][i + 1]["style"] = "font-size:100%";
-                                        }
-                                        //鏄剧ず鍒�
-                                        if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
-                                            option.cols[0][i + 1]["hide"] = false;
-                                        }
-                                        //缁熻鍒�
-                                        if (dataCols[6] == 1) {
-                                            option.cols[0][i + 1]["totalRow"] = true;
-                                        }
-                                        //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
-                                        switch (dataCols[2]) {
-                                            case "L":
-                                                option.cols[0][i + 1]["align"] = "left";
-                                                break;
-                                            case "M":
-                                                option.cols[0][i + 1]["align"] = "center";
-                                                break;
-                                            case "R":
-                                                option.cols[0][i + 1]["align"] = "right";
-                                                break;
-                                        }
-                                        //璁剧疆琛ㄦ牸title灞炴�ф樉绀哄埆鍚�
-                                        if (dataCols[4] != null && dataCols[4] != "") {
-                                            option.cols[0][i + 1]["title"] = dataCols[4];
-                                        }
-                                        newCols[0].push(option.cols[0][i + 1]);
-                                    }
-                                }
-                            }
-                            //閬嶅巻寰幆鍚庡垽鏂搴斿垪鏁版槸鍚︿竴鑷�
-                            if (dataCol.length == newCols[0].length - 1) {
-                                option.cols = newCols;
-                                //鍙栨秷鍐荤粨鍒�
-                                for (var i = 1; i < option.cols[0].length - 1; i++) {
-                                    if (option.cols[0][i]["fixed"] != null) {
-                                        option.cols[0][i]["fixed"] = null;
-                                    }
-                                    else {
-                                        break;
-                                    }
-                                }
-                                //鍐荤粨鍒�
-                                if (data1.data[0].HFixCols != 0) {
-                                    for (var i = 0; i < data1.data[0].HFixCols; i++) {
-                                        if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
-                                            data1.data[0].HFixCols += 1;
-                                        }
-                                        option.cols[0][i + 1]["fixed"] = "left";
-                                    }
-                                }
-                            }
-                        }
-                        table.render(option);
-                    } else {
-                        table.render(option);
-                    }
-                }, error: function () {
-                    layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
-                }
-            })
-        }
-        //#endregion
-
         //#endregion
         //浠ヤ笂鏄痩ayui妯″潡
     });
+    function GetHSupNameValue(obj) {
+        $("#HSUPPLIERID").val(obj[0].HItemID);
+        $("#HSUPPLIERNAME").val(obj[0].渚涘簲鍟嗗悕绉�);
+    }
+    function GetGyMaterial(obj) {
+        $("#HMATERIALID").val(obj.HItemID);
+        $("#HMATERIALNAME").val(obj.鐗╂枡鍚嶇О);
+    }
 </script>
\ No newline at end of file
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\351\275\220\345\245\227\345\210\206\346\236\220/JIT_CompleteMaterlDetailList.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\351\275\220\345\245\227\345\210\206\346\236\220/JIT_CompleteMaterlDetailList.html"
index e1334fe..080294d 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\351\275\220\345\245\227\345\210\206\346\236\220/JIT_CompleteMaterlDetailList.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\351\275\220\345\245\227\345\210\206\346\236\220/JIT_CompleteMaterlDetailList.html"
@@ -11,6 +11,7 @@
     <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
     <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
     <script src="../../../layuiadmin/PubCustom.js"></script>
+    <script src="../../../layuiadmin/SetColumn.js"></script>
 </head>
 <body>
     <div class="layui-fluid">
@@ -25,16 +26,16 @@
                                         <span>鏇村</span>
                                     </div>
                                 </div>
-                                <!--<div class="layui-inline">
-                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">鐗╂枡缂栫爜</label>
+                                <div class="layui-inline">
+                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">鐗╂枡鍚嶇О</label>
                                     <div class="layui-input-block" style="margin-left: 77px;">
                                         <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
-                                        <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="width: 60%;display: inline-block;">
+                                        <input type="text" class="layui-input" lay-verify="HMaterName" name="HMaterName" id="HMaterName" value="" style="width: 60%;display: inline-block;">
                                         <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterNumber" id="btnHMaterNumber" style="padding: 0 10px;float: right;margin-right: 3px;">
                                             <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                         </button>
                                     </div>
-                                </div>-->
+                                </div>
                                 <!--<div class="layui-inline" style="margin-left:30px">
                                     <label class="layui-form-label">榻愬鐘舵��</label>
                                     <div class="layui-input-block" style="width:190px;">
@@ -99,6 +100,7 @@
                         <script type="text/html" id="toolbarDemo">
                             <div class="layui-btn-container">
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button>
                             </div>
                         </script>
                     </form>
@@ -131,6 +133,7 @@
             , util = layui.util
         var sWhere = "";
         var option = [];
+        var ins = "";
         var HMaterID = 0;//鐗╂枡
         var HModName = "JIT_CompleteMaterlDetailList";
         var titleData = [];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
@@ -158,7 +161,11 @@
             switch (obj.event) {
                 //鍒楄缃�
                 case 'set_HideColumn':
-                    get_HideColumn();
+                    get_HideColumnNoPage(HModName, 1, option, get_FastQuery)
+                    break;
+                //瀵煎嚭excel
+                case 'get_export':
+                    get_Export();
                     break;
             };
         });
@@ -188,6 +195,25 @@
 
         //#region 鍒濆鍖栫晫闈�
         function set_ClearBill() {
+            option = {
+                elem: '#mainTable'
+                , toolbar: '#toolbarDemo'
+                , height: 'full-50'
+                , page: true
+                , cellMinWidth: 90
+                , totalRow: true
+                , limit: 50
+                , limits: [50, 500, 5000, 20000]
+                , done: function (res, curr, count) {
+                    //for (var i in res.data) {
+                    //    var item = res.data[i];
+
+                    //    if (item["榻愬鐘舵��"] == "鏈綈濂�") {
+                    //        $("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" });
+                    //    }
+                    //}
+                }
+            };
             //鍒濆鍖栨棩鏈�
             $("#HPlanDate").val(Format(new Date(), 'yyyy-MM-dd'));
             //鏌ヨ
@@ -243,30 +269,12 @@
                             }
                         }
 
-                        var option = {
-                            elem: '#mainTable'
-                            , toolbar: '#toolbarDemo'
-                            , height: 'full-50'
-                            , page: true
-                            , cellMinWidth: 90
-                            , totalRow: true
-                            , limit: 50
-                            , limits: [50, 500, 5000, 20000]
-                            , done: function (res, curr, count) {
-                                //for (var i in res.data) {
-                                //    var item = res.data[i];
-
-                                //    if (item["榻愬鐘舵��"] == "鏈綈濂�") {
-                                //        $("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" });
-                                //    }
-                                //}
-                            }
-                        };
+                        
                         option.cols = [col];
                         option.data = result.data;
-                        table.render(option);
 
-                        DisPlay_HideColumn();
+                        DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option);
+                        ins = table.render(option);
 
                         //layer.alert("鏌ヨ鎴愬姛", { icon: 1 });
                     } else {
@@ -292,9 +300,9 @@
             var HPlanDate = $("#HPlanDate").val();
             var HICMOBillNo = $("#HICMOBillNo").val();
 
-            if (HMaterID!="0") {
+            
                 sWhere += HMaterID;
-            }
+            
             //if (HMaterNumber) {
             //    sWhere += " and 鐗╂枡缂栫爜 like '%" + HMaterNumber + "%'";
             //}
@@ -339,7 +347,7 @@
                 , area: ['90%', '90%']//澶у皬
                 , title: '鐗╂枡鍒楄〃'//鏍囬
                 , shift: 2//寮瑰嚭鍔ㄧ敾
-                , content: ['../../Baseset/鍩虹璧勬枡/Gy_MaterialList.html', 'yes']
+                , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Material.html', 'yes']
                 , btn: ['纭畾', '鍙栨秷']
                 , btn1: function (index, layero) {//鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
                     var iframeWindow = window['layui-layer-iframe' + index]  //鑾峰彇寮规椤甸潰
@@ -349,133 +357,28 @@
                     }
                     //鑾峰彇鏁版嵁
                     $("#HMaterID").val(checkStatus.data[0].HItemID);
-                    $("#HMaterNumber").val(checkStatus.data[0].HNumber);
-                    $("#HMaterName").val(checkStatus.data[0].HName);
-                    $("#HMaterModel").val(checkStatus.data[0].HModel);
+                    /*$("#HMaterNumber").val(checkStatus.data[0].HNumber);*/
+                    $("#HMaterName").val(checkStatus.data[0].鐗╂枡鍚嶇О);
+                    //$("#HMaterModel").val(checkStatus.data[0].HModel);
                     layer.close(index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨�
                 }
                 , btn2: function (index, layero) { }
             })
 
         }
-
-        //闅愯棌鍒楄缃�
-        function get_HideColumn(value) {
-            var colName = "";
-
-            for (var i = 1; i < option.cols[0].length - 1; i++) {
-                colName += option.cols[0][i]["title"] + ",";
-            }
-
-            var contentUrl = "";
-            var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞
-            var urlLen = urlStr.split('/');
-            for (var i = 0; i < urlLen.length - 4; i++) {
-                contentUrl += "../";
-            }
-            colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
-
-            contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
-
-            layer.open({
-                type: 2
-                , skin: "layui-layer-rim" //鍔犱笂杈规
-                , title: "闅愯棌鍒楄缃�"  //鏍囬
-                , closeBtn: 1  //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
-                , shift: 2 //寮瑰嚭鍔ㄧ敾
-                , area: ["50%", "90%"] //绐椾綋澶у皬
-                , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
-                , content: [contentUrl, "yes"]
-                , btn: ["纭畾", "鍙栨秷"]
-                , btn1: function (index, laero) {
-                    //鍒锋柊琛ㄦ牸鏁版嵁
-                    DisPlay_HideColumn();
-                    //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
-                    layer.close(index);//鍏抽棴寮圭獥
-                }
-            })
-        }
-
-        //鏄剧ず鍒楁暟鎹� 鐗╂枡淇℃伅
-        function DisPlay_HideColumn() {
-            $.ajax({
-                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
-                type: "GET",
-                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
-                async: false,
-                success: function (data1) {
-                    if (data1.data.length != 0) {
-
-                        var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
-
-                        dataCol = data1.data[0].HGridString.split(',');
-
-                        for (var i = 0; i < option.cols[0].length - 2; i++) {
-                            var dataCols = dataCol[i].split('|');
-                            //闅愯棌鍒�
-                            if (dataCols[1] == 1) {
-                                option.cols[0][i + 1]["hide"] = true;
-                            }
-                            //璁剧疆鍒楀
-                            if (dataCols[3] > 0) {
-                                option.cols[0][i + 1]["width"] = dataCols[3];
-                            }
-                            //璁剧疆鍐呭瀛椾綋澶у皬
-                            if (data1.data[0].HFontSize != 0) {
-                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
-                            } else {
-                                option.cols[0][i + 1]["style"] = "font-size:100%";
-                            }
-                            //璁剧疆鍒楀
-                            //if (data1.data[0].HColumnWidth != 0) {
-                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
-                            //} else {
-                            //    option.cols[0][i + 1]["width"] = "";
-                            //}
-                            //鏄剧ず鍒�
-                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
-                                option.cols[0][i + 1]["hide"] = false;
-                            }
-                            //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
-                            switch (dataCols[2]) {
-                                case "L":
-                                    option.cols[0][i + 1]["align"] = "left";
-                                    break;
-                                case "M":
-                                    option.cols[0][i + 1]["align"] = "center";
-                                    break;
-                                case "R":
-                                    option.cols[0][i + 1]["align"] = "right";
-                                    break;
-                            }
-                        }
-
-                        //鍙栨秷鍐荤粨鍒�
-                        for (var i = 1; i < option.cols[0].length - 1; i++) {
-                            if (option.cols[0][i]["fixed"] != null) {
-                                option.cols[0][i]["fixed"] = null;
-                            }
-                            else {
-                                break;
-                            }
-                        }
-                        //鍐荤粨鍒�
-                        if (data1.data[0].HFixCols != 0) {
-                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
-                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
-                                    data1.data[0].HFixCols += 1;
-                                }
-                                option.cols[0][i + 1]["fixed"] = "left";
-                            }
-                        }
-                        table.render(option);
-                    } else {
-                        table.render(option);
+        function get_Export() {
+            var data = option.data;
+            data.forEach((item) => {
+                for (let itemobj in item) {
+                    if (item[itemobj] == null) {
+                        item[itemobj] = "";
                     }
-                }, error: function () {
-                    layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                    if (item[itemobj].length > 0) {  // 鍋囪瀛楁鍚嶄负field
+                        item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // 灏嗘崲琛岀鏇挎崲涓虹┖瀛楃涓�
+                    }
                 }
-            })
+            });
+            table.exportFile(ins.config.id, data, "xls");
         }
 
         //鑾峰彇鍙傛暟
@@ -492,4 +395,9 @@
         //#endregion
         //浠ヤ笂鏄痩ayui妯″潡
     });
+    function GetGyMaterial(obj) {
+        $("#HMaterID").val(obj.HItemID);
+        /*$("#HMaterNumber").val(checkStatus.data[0].HNumber);*/
+        $("#HMaterName").val(obj.鐗╂枡鍚嶇О);
+    }
 </script>
\ No newline at end of file
diff --git "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserGroupList.html" "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserGroupList.html"
index ff5108d..cd83f4a 100644
--- "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserGroupList.html"
+++ "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserGroupList.html"
@@ -263,6 +263,7 @@
                     , toolbar: '#toolbarDemo'
                     , height: 'full-50'
                     , page: true
+                    , totalRow: true
                     , cellMinWidth: 90
                     , limit: 50
                     , limits: [50, 500, 5000, 20000]
@@ -619,62 +620,82 @@
                     data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         if (data1.data.length != 0) {
-
+                            titleData = [];
                             var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
-                            var titleData = ["HGroupID"];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
-
+                            var newCols = [[]];//瀵瑰簲鏁版嵁搴撳垪椤哄簭col
+                            newCols[0].push(option.cols[0][0]);//鏀惧叆绗竴涓猚heckbox
                             dataCol = data1.data[0].HGridString.split(',');
-
-                            for (var i = 0; i < option.cols[0].length - 1; i++) {
-                                var dataCols = dataCol[i].split('|');
-                                //闅愯棌鍒�
-                                if (dataCols[1] == 1) {
-                                    option.cols[0][i + 1]["hide"] = true;
-                                }
-                                //璁剧疆鍐呭瀛椾綋澶у皬
-                                if (data1.data[0].HFontSize != 0) {
-                                    option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
-                                } else {
-                                    option.cols[0][i + 1]["style"] = "font-size:100%";
-                                }
-                                //璁剧疆鍒楀
-                                if (dataCols[3] > 0) {
-                                    option.cols[0][i + 1]["width"] = dataCols[3];
-                                }
-                                //鏄剧ず鍒�
-                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["field"], titleData) == -1) {
-                                    option.cols[0][i + 1]["hide"] = false;
-                                }
-                                //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
-                                switch (dataCols[2]) {
-                                    case "L":
-                                        option.cols[0][i + 1]["align"] = "left";
-                                        break;
-                                    case "M":
-                                        option.cols[0][i + 1]["align"] = "center";
-                                        break;
-                                    case "R":
-                                        option.cols[0][i + 1]["align"] = "right";
-                                        break;
-                                }
-                            }
-
-                            //鍙栨秷鍐荤粨鍒�
-                            for (var i = 1; i < option.cols[0].length - 1; i++) {
-                                if (option.cols[0][i]["fixed"] != null) {
-                                    option.cols[0][i]["fixed"] = null;
-                                }
-                                else {
-                                    break;
-                                }
-                            }
-                            //鍐荤粨鍒�
-                            if (data1.data[0].HFixCols != 0) {
-                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
-                                    if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
-                                        data1.data[0].HFixCols += 1;
+                            //鍒楄缃垪鏁颁笌椤甸潰鍒楁暟鏄惁涓�鑷�
+                            if (dataCol.length == option.cols[0].length - 1) {
+                                //閬嶅巻瀵绘壘鍒楄缃搴斿垪鎸夐『搴忔彃鍏�
+                                for (var j = 0; j < option.cols[0].length - 1; j++) {
+                                    for (var i = 0; i < option.cols[0].length - 1; i++) {
+                                        var dataCols = dataCol[j].split('|');
+                                        //閫夋嫨涓巇atacols鐩稿簲鍒楄繘琛屼慨鏀�
+                                        if (option.cols[0][i + 1]["field"] == dataCols[5]) {
+                                            //闅愯棌鍒�
+                                            if (dataCols[1] == 1) {
+                                                option.cols[0][i + 1]["hide"] = true;
+                                            }
+                                            //璁剧疆鍒楀
+                                            if (dataCols[3] > 0) {
+                                                option.cols[0][i + 1]["width"] = dataCols[3];
+                                            }
+                                            //璁剧疆鍐呭瀛椾綋澶у皬
+                                            if (data1.data[0].HFontSize != 0) {
+                                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
+                                            } else {
+                                                option.cols[0][i + 1]["style"] = "font-size:100%";
+                                            }
+                                            //鏄剧ず鍒�
+                                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
+                                                option.cols[0][i + 1]["hide"] = false;
+                                            }
+                                            //缁熻鍒�
+                                            if (dataCols[6] == 1) {
+                                                option.cols[0][i + 1]["totalRow"] = true;
+                                            }
+                                            //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
+                                            switch (dataCols[2]) {
+                                                case "L":
+                                                    option.cols[0][i + 1]["align"] = "left";
+                                                    break;
+                                                case "M":
+                                                    option.cols[0][i + 1]["align"] = "center";
+                                                    break;
+                                                case "R":
+                                                    option.cols[0][i + 1]["align"] = "right";
+                                                    break;
+                                            }
+                                            //璁剧疆琛ㄦ牸title灞炴�ф樉绀哄埆鍚�
+                                            if (dataCols[4] != null && dataCols[4] != "") {
+                                                option.cols[0][i + 1]["title"] = dataCols[4];
+                                            }
+                                            newCols[0].push(option.cols[0][i + 1]);
+                                        }
                                     }
-                                    option.cols[0][i + 1]["fixed"] = "left";
+                                }
+                                //閬嶅巻寰幆鍚庡垽鏂搴斿垪鏁版槸鍚︿竴鑷�
+                                if (dataCol.length == newCols[0].length - 1) {
+                                    option.cols = newCols;
+                                    //鍙栨秷鍐荤粨鍒�
+                                    for (var i = 1; i < option.cols[0].length - 1; i++) {
+                                        if (option.cols[0][i]["fixed"] != null) {
+                                            option.cols[0][i]["fixed"] = null;
+                                        }
+                                        else {
+                                            break;
+                                        }
+                                    }
+                                    //鍐荤粨鍒�
+                                    if (data1.data[0].HFixCols != 0) {
+                                        for (var i = 0; i < data1.data[0].HFixCols; i++) {
+                                            if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
+                                                data1.data[0].HFixCols += 1;
+                                            }
+                                            option.cols[0][i + 1]["fixed"] = "left";
+                                        }
+                                    }
                                 }
                             }
                             table.render(option);
diff --git "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserList.html" "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserList.html"
index 0528ed2..6470717 100644
--- "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserList.html"
+++ "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserList.html"
@@ -275,6 +275,7 @@
                     , toolbar: '#toolbarDemo'
                     , height: 'full-50'
                     , page: true
+                    , totalRow: true
                     , cellMinWidth: 90
                     , limit: 50
                     , limits: [50, 500, 5000, 20000]
@@ -620,64 +621,82 @@
                     data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         if (data1.data.length != 0) {
-
+                            titleData = [];
                             var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
-                            var titleData = ["hmainid"];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
-
+                            var newCols = [[]];//瀵瑰簲鏁版嵁搴撳垪椤哄簭col
+                            newCols[0].push(option.cols[0][0]);//鏀惧叆绗竴涓猚heckbox
                             dataCol = data1.data[0].HGridString.split(',');
-
-                            for (var i = 0; i < option.cols[0].length - 1; i++) {
-                                if (dataCol[i]) {
-                                    var dataCols = dataCol[i].split('|');
-                                }
-                                //闅愯棌鍒�
-                                if (dataCols[1] == 1) {
-                                    option.cols[0][i + 1]["hide"] = true;
-                                }
-                                //璁剧疆鍐呭瀛椾綋澶у皬
-                                if (data1.data[0].HFontSize != 0) {
-                                    option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
-                                } else {
-                                    option.cols[0][i + 1]["style"] = "font-size:100%";
-                                }
-                                //璁剧疆鍒楀
-                                if (dataCols[3] > 0) {
-                                    option.cols[0][i + 1]["width"] = dataCols[3];
-                                }
-                                //鏄剧ず鍒�
-                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["field"], titleData) == -1) {
-                                    option.cols[0][i + 1]["hide"] = false;
-                                }
-                                //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
-                                switch (dataCols[2]) {
-                                    case "L":
-                                        option.cols[0][i + 1]["align"] = "left";
-                                        break;
-                                    case "M":
-                                        option.cols[0][i + 1]["align"] = "center";
-                                        break;
-                                    case "R":
-                                        option.cols[0][i + 1]["align"] = "right";
-                                        break;
-                                }
-                            }
-
-                            //鍙栨秷鍐荤粨鍒�
-                            for (var i = 1; i < option.cols[0].length - 1; i++) {
-                                if (option.cols[0][i]["fixed"] != null) {
-                                    option.cols[0][i]["fixed"] = null;
-                                }
-                                else {
-                                    break;
-                                }
-                            }
-                            //鍐荤粨鍒�
-                            if (data1.data[0].HFixCols != 0) {
-                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
-                                    if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
-                                        data1.data[0].HFixCols += 1;
+                            //鍒楄缃垪鏁颁笌椤甸潰鍒楁暟鏄惁涓�鑷�
+                            if (dataCol.length == option.cols[0].length - 1) {
+                                //閬嶅巻瀵绘壘鍒楄缃搴斿垪鎸夐『搴忔彃鍏�
+                                for (var j = 0; j < option.cols[0].length - 1; j++) {
+                                    for (var i = 0; i < option.cols[0].length - 1; i++) {
+                                        var dataCols = dataCol[j].split('|');
+                                        //閫夋嫨涓巇atacols鐩稿簲鍒楄繘琛屼慨鏀�
+                                        if (option.cols[0][i + 1]["field"] == dataCols[5]) {
+                                            //闅愯棌鍒�
+                                            if (dataCols[1] == 1) {
+                                                option.cols[0][i + 1]["hide"] = true;
+                                            }
+                                            //璁剧疆鍒楀
+                                            if (dataCols[3] > 0) {
+                                                option.cols[0][i + 1]["width"] = dataCols[3];
+                                            }
+                                            //璁剧疆鍐呭瀛椾綋澶у皬
+                                            if (data1.data[0].HFontSize != 0) {
+                                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
+                                            } else {
+                                                option.cols[0][i + 1]["style"] = "font-size:100%";
+                                            }
+                                            //鏄剧ず鍒�
+                                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
+                                                option.cols[0][i + 1]["hide"] = false;
+                                            }
+                                            //缁熻鍒�
+                                            if (dataCols[6] == 1) {
+                                                option.cols[0][i + 1]["totalRow"] = true;
+                                            }
+                                            //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
+                                            switch (dataCols[2]) {
+                                                case "L":
+                                                    option.cols[0][i + 1]["align"] = "left";
+                                                    break;
+                                                case "M":
+                                                    option.cols[0][i + 1]["align"] = "center";
+                                                    break;
+                                                case "R":
+                                                    option.cols[0][i + 1]["align"] = "right";
+                                                    break;
+                                            }
+                                            //璁剧疆琛ㄦ牸title灞炴�ф樉绀哄埆鍚�
+                                            if (dataCols[4] != null && dataCols[4] != "") {
+                                                option.cols[0][i + 1]["title"] = dataCols[4];
+                                            }
+                                            newCols[0].push(option.cols[0][i + 1]);
+                                        }
                                     }
-                                    option.cols[0][i + 1]["fixed"] = "left";
+                                }
+                                //閬嶅巻寰幆鍚庡垽鏂搴斿垪鏁版槸鍚︿竴鑷�
+                                if (dataCol.length == newCols[0].length - 1) {
+                                    option.cols = newCols;
+                                    //鍙栨秷鍐荤粨鍒�
+                                    for (var i = 1; i < option.cols[0].length - 1; i++) {
+                                        if (option.cols[0][i]["fixed"] != null) {
+                                            option.cols[0][i]["fixed"] = null;
+                                        }
+                                        else {
+                                            break;
+                                        }
+                                    }
+                                    //鍐荤粨鍒�
+                                    if (data1.data[0].HFixCols != 0) {
+                                        for (var i = 0; i < data1.data[0].HFixCols; i++) {
+                                            if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
+                                                data1.data[0].HFixCols += 1;
+                                            }
+                                            option.cols[0][i + 1]["fixed"] = "left";
+                                        }
+                                    }
                                 }
                             }
                             table.render(option);
diff --git "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserListEdit.html" "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserListEdit.html"
index 060bb38..dbca90c 100644
--- "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserListEdit.html"
+++ "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_UserListEdit.html"
@@ -55,7 +55,7 @@
                                                             <label class="layui-form-label">缂栫爜</label>
                                                             <div class="layui-input-inline">
                                                                 <input class="layui-input" name="Czybm" lay-verify="Czybm" id="Czybm" autocomplete="off" style="float:left;width:150px;">
-                                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="CzybmList" style="width:40px;">
+                                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="CzybmList" style="width:40px;display:none;">
                                                                     <i style="margin-left:-9px;">閲嶇疆</i>
                                                                 </button>
                                                             </div>
@@ -64,7 +64,7 @@
                                                             <label class="layui-form-label">鐢ㄦ埛鍚�</label>
                                                             <div class="layui-input-inline">
                                                                 <input class="layui-input" name="Czymc" id="Czymc" autocomplete="off" style="float:left;width:150px;">
-                                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="CzymcList" style="width:40px;">
+                                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="CzymcList" style="width: 40px; display: none;">
                                                                     <i style="margin-left:-9px;">閲嶇疆</i>
                                                                 </button>
                                                             </div>
@@ -530,14 +530,17 @@
 
             //閫�鍑�
             form.on('submit(Exit)', function (data) {
-                if (linterid == undefined) {
-                    //鍏抽棴椤电
-                    Pub_Close(2);
-                }
-                else {
-                    //鍏抽棴椤电
-                    Pub_Close(1);
-                }
+                //閫昏緫鍒犻櫎鏂规硶
+                layer.confirm("閫�鍑哄墠璇风‘淇濇暟鎹凡淇濆瓨锛屾槸鍚︾户缁��鍑猴紵", { title: "閫�鍑虹‘璁�" }, function (index) {
+                    if (linterid == undefined) {
+                        //鍏抽棴椤电
+                        Pub_Close(2);
+                    }
+                    else {
+                        //鍏抽棴椤电
+                        Pub_Close(1);
+                    }
+                })
             });
 
             //#endregion

--
Gitblit v1.9.1