From 24efc0b0d99502afdebb6ef678b0cf4e91dcb084 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期五, 16 五月 2025 15:49:51 +0800
Subject: [PATCH] 组织物料启动检查项目防错装置优化

---
 WebTM/views/项目管理/工程项目/PM_ProjectTaskNeedCheckQuery.html |  329 +++++++++++++++++++++++++++---------------------------
 1 files changed, 162 insertions(+), 167 deletions(-)

diff --git "a/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectTaskNeedCheckQuery.html" "b/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectTaskNeedCheckQuery.html"
index 82a378f..51202cd 100644
--- "a/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectTaskNeedCheckQuery.html"
+++ "b/WebTM/views/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectTaskNeedCheckQuery.html"
@@ -94,7 +94,7 @@
                                                     <label class="layui-form-label" style="width: 85px;">浠诲姟瀹夎璐�</label>
                                                     <div class="layui-input-block" style="margin-left: 120px;">
                                                         <input type="number" class="layui-input" name="HTaskSetupMoney" lay-verify="HTaskSetupMoney" id="HTaskSetupMoney" value="0" style="float: left; width: 120px" readonly>
-                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckSetupMoney" id="btnCheckSetupMoney" style="float: left; padding: 0 10px;">
+                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckSetupMoney" id="btnCheckSetupMoney" style="float: left; padding: 0 10px;display:none;">
                                                             瀹℃牳
                                                         </button>
                                                     </div>
@@ -103,7 +103,7 @@
                                                     <label class="layui-form-label" style="width: 85px;">浠诲姟闄勫睘璐�</label>
                                                     <div class="layui-input-block" style="margin-left: 120px;">
                                                         <input type="number" class="layui-input" name="HTaskOtherMoney" lay-verify="HTaskOtherMoney" id="HTaskOtherMoney" value="0" style="float: left; width: 120px" readonly>
-                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckOtherMoney" id="btnCheckOtherMoney" style="float: left; padding: 0 10px;">
+                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckOtherMoney" id="btnCheckOtherMoney" style="float: left; padding: 0 10px; display: none;">
                                                             瀹℃牳
                                                         </button>
                                                     </div>
@@ -112,7 +112,7 @@
                                                     <label class="layui-form-label" style="width: 85px;">浠诲姟鑰冩牳璐�</label>
                                                     <div class="layui-input-block" style="margin-left: 120px;">
                                                         <input type="number" class="layui-input" name="HTaskExamMoney" lay-verify="HTaskExamMoney" id="HTaskExamMoney" value="0" style="float: left; width: 120px" readonly>
-                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckExamMoney" id="btnCheckExamMoney" style="float: left; padding: 0 10px;">
+                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckExamMoney" id="btnCheckExamMoney" style="float: left; padding: 0 10px; display: none;">
                                                             瀹℃牳
                                                         </button>
                                                     </div>
@@ -121,7 +121,7 @@
                                                     <label class="layui-form-label" style="width: 85px;">浠诲姟宸ヨ垂</label>
                                                     <div class="layui-input-block" style="margin-left: 120px;">
                                                         <input type="number" class="layui-input" name="HTaskWorkMoney" lay-verify="HTaskWorkMoney" id="HTaskWorkMoney" value="0" style="float: left; width: 120px" readonly>
-                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckWorkMoney" id="btnCheckWorkMoney" style="float: left; padding: 0 10px;">
+                                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnCheckWorkMoney" id="btnCheckWorkMoney" style="float: left; padding: 0 10px; display: none;">
                                                             瀹℃牳
                                                         </button>
                                                     </div>
@@ -137,20 +137,12 @@
                                             </div>
                                         </div>
                                         <div class="layui-tab" lay-filter="tab-POStockInBill" style=" background-color: white">
-                                            <ul class="layui-tab-title" lay-filter="tab-all">
-                                                <li lay-id="1" style="padding:1px;" class="layui-this">椤圭洰闃舵</li>
-                                                <li lay-id="2" style="padding:1px;">椤圭洰鎴愬憳</li>
-                                            </ul>
-                                            <div class="layui-tab-content">
-                                                <!--椤圭洰闃舵-->
-                                                <div class="layui-tab-item layui-show">
-                                                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
+                                            <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
+                                            <script type="text/html" id="toolbarDemo">
+                                                <div class="layui-btn-container" id="toolbarDemo_ButtonSet">
+                                                    <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
                                                 </div>
-                                                <!--椤圭洰鎴愬憳-->
-                                                <div class="layui-tab-item">
-                                                    <table class="layui-hide" id="mainTable1" lay-filter="mainTable1"></table>
-                                                </div>
-                                            </div>
+                                            </script>
                                         </div>
                                     </div>
                                 </div>
@@ -162,18 +154,6 @@
             </div>
         </div>
     </div>
-    <!--閲岀▼纰�-->
-    <script type="text/html" id="HIsKey">
-        <div class="layui-input-block" style="margin-left: 20px;">
-            <input type="checkbox" name="HIsKey" lay-filter="HIsKey" id="HIsKey{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
-        </div>
-    </script>
-    <!--椤圭洰缁忕悊-->
-    <script type="text/html" id="HIsPM">
-        <div class="layui-input-block" style="margin-left: 20px;">
-            <input type="checkbox" name="HIsPM" lay-filter="HIsPM" id="HIsPM{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
-        </div>
-    </script>
     <script>
         layui.config({
             base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
@@ -193,17 +173,16 @@
             var optionNeedCheck = [];
             var ins;                        //鐢ㄤ簬瀵煎嚭excel
             //涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
-            var titleData = ["hmainid", "HBillType", "HSupID", "HPSStyleID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid", "HMaterID", "HUnitID",
-                "HFeedback", "HPriority", "HUserID", "甯佸埆浠g爜", "閲囪喘鏂瑰紡浠g爜", "缁撶畻鏂瑰紡浠g爜", "閮ㄩ棬浠g爜", "涓荤浠g爜", "涓氬姟鍛樹唬鐮�", "璁¢噺鍗曚綅浠g爜", "HCheckFlowStatusID", "HCheckFlowID","HCheckItemID"];
+            var titleData = ["hmainid"];
             //#endregion
             //#endregion
             var HModName = "PM_ProjectTaskNeedCheckQuery";
-
+            var HModName2 = "PM_ProjectTaskNeedCheckQuery_SellOut";
             //#region 杩涘叆椤甸潰鏃㈠姞杞�
             //鍒濆鍖栬〃鏍�
             set_InitGrid();
-            //鏌ヨ
-            get_Display();
+
+            get_FastQuery();
             //#endregion
 
             //#region 鐐瑰嚮浜嬩欢鍖呮嫭on form浜嬩欢绛�
@@ -214,7 +193,7 @@
                     //case 'btn-Edit': get_ShowBill('mainTableNeedCheck');
                     //    break;
                     //鍒锋柊
-                    case 'get_Refresh': get_Display();
+                    case 'get_Refresh': get_FastQuery();
                         break;
                     //瀵煎嚭excel
                     case 'get_export':
@@ -231,10 +210,19 @@
                         table.exportFile(ins.config.id, optionNeedCheck.data, "xls");
                         break;
                     //鍒楄缃�
-                    case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], optionNeedCheck, get_Display);
+                    case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], optionNeedCheck, get_FastQuery);
                         break;
                 };
             });
+            table.on('toolbar(mainTable)', function (obj) {
+                switch (obj.event) {
+                    //鍒楄缃�
+                    case 'set_HideColumn': get_HideColumnNoPage(HModName2, sessionStorage["HUserName"], option, function () { });
+                        break;
+
+                };
+            });
+
             //#endregion
 
             //#region 閫�鍑�
@@ -266,23 +254,15 @@
             //#region 鐐瑰嚮琛岄�変腑楂樹寒
             table.on('row(mainTableNeedCheck)', function (obj) {
                 //閫変腑琛屾敼鍙橀鑹�
-                var flag = !obj.tr.find(':checkbox:first').prop('checked');
-                obj.tr.find(':checkbox').prop('checked', flag);
-                if (flag) {
-                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //璁剧疆澶嶉�夋閫変腑鏍峰紡
-                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹�
-                } else {
-                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//鍙栨秷澶嶉�夋閫変腑鏍峰紡
-                    $(obj.tr.selector).attr({ "style": "background:" });//鍙栨秷褰撳墠tr棰滆壊
-                }
-                //mainTable 涓鸿〃鏍糏D   娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊
-                layui.each(table.cache.mainTable, function (i, l) {
-                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
-                        l.LAY_CHECKED = flag;
-                    }
-                });
+                var flag = !obj.tr.find(':radio:first').prop('checked');
+                obj.tr.find(':radio').prop('checked', flag);
+                $('tr').attr({ "style": "background:" });
+                $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹�
+                //obj.tr.find('.layui-form-radio').addClass('layui-form-radioed');
+                
                 //鏄剧ず椤圭洰淇℃伅
                 RoadBillMain(obj.data["HInterID"]);
+                
             })
             //#endregion
 
@@ -330,6 +310,17 @@
             //#endregion
 
             //#region 璇ラ〉闈㈡墍鏈夋柟娉�
+            //鐩存帴鎵ц鍒楄〃绛涢�� 鍔犺浇鏁版嵁鍒扮綉鏍�
+            //蹇�熻繃婊�
+            function get_FastQuery() {
+                //鍒濆璇濇寜閽偣鍑�
+                sWhere = " '"+addSWhereByOpenType() + "'";
+                //鏌ヨ
+                get_Display(sWhere);
+                //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
+                sWhere = "";
+            }
+
             //#region 鍒濆鍖栬〃鏍�
             function set_InitGrid() {
                 //璁剧疆瀹℃牳鎸夐挳涓嶅彲鐐瑰嚮
@@ -337,7 +328,6 @@
                 $('#btnCheckOtherMoney').prop('disabled', true).addClass('layui-btn-disabled');
                 $('#btnCheckExamMoney').prop('disabled', true).addClass('layui-btn-disabled');
                 $('#btnCheckWorkMoney').prop('disabled', true).addClass('layui-btn-disabled');
-
                 optionNeedCheck = {
                     elem: '#mainTableNeedCheck'
                     , toolbar: '#toolbarDemoNeedCheck'
@@ -352,100 +342,26 @@
 
                 option = {
                     elem: '#mainTable'
-                    //, toolbar: '#toolbarDemo'
-                    //, page: true
-                    //, limit: 500
-                    //, limits: [50, 500, 5000, 50000]
-                    , totalRow: true
-                    , cellMinWidth: 120
-                    , height: 400
-                    , cols: [[
-                        //{ type: 'checkbox', totalRowText: '鍚堣琛�' }
-                        { type: 'numbers', title: '搴忓彿', style: 'background-color: #f9f9f9;' }
-                        , { field: 'RowID', title: '琛屽彿', hide: true, style: 'background-color: #f9f9f9;' }                                                   //琛屾爣璇嗭紝鐢ㄤ簬涓嬩竴琛屻�佷笂涓�琛岃瘑鍒墍鍦ㄨ
-                        , { field: 'HProjectStageID', title: '椤圭洰闃舵ID', hide: true, style: 'background-color: #f9f9f9;' }
-                        , { field: 'HProjectStageName', title: '椤圭洰闃舵',  event: "HProjectStageName" }     //f7
-                        , { field: 'HStageNote', title: '椤圭洰璇︾粏鍐呭', style: 'background-color: #f9f9f9;' }
-                        , { field: 'HPMGoodsID', title: '鐩稿叧浜や粯鐗㊣D', hide: true, style: 'background-color: #f9f9f9;' }
-                        , { field: 'HPMGoodsName', title: '鐩稿叧浜や粯鐗�',  event: "HPMGoodsName" }            //f7
-                        , { field: 'HIsKey', title: '閲岀▼纰�', templet: "#HIsKey" }
-                        , { field: 'HRate', title: '涓氱哗鍗犳瘮',  totalRow: true }
-                        , { field: 'HEmpID', title: '闃舵璐熻矗浜篒D', hide: true, style: 'background-color: #f9f9f9;' }
-                        , { field: 'HEmpName', title: '闃舵璐熻矗浜�',  event: "HEmpName" }                    //f7
-                        , { field: 'HCheckEmpID', title: '闃舵瀹℃牳浜篒D', hide: true, style: 'background-color: #f9f9f9;' }
-                        , { field: 'HCheckEmpName', title: '闃舵瀹℃牳浜�',  event: "HCheckEmpName" }          //f7
-                        , { field: 'HFinishDate', title: '棰勮瀹屾垚鏃ユ湡', event: "HFinishDate" }
-                        , { field: 'HWorkDays', title: '棰勮浜哄ぉ',  totalRow: true }
-                        , { field: 'HRemarkSub', title: '澶囨敞', edit: 'text' }
-                    ]]
-                }
-                var rowdata = [
-                    {
-                        "RowID": 10
-                        , 'HProjectStageID': '0'
-                        , 'HProjectStageName': ''
-                        , 'HStageNote': ''
-                        , 'HPMGoodsID': '0'
-                        , 'HPMGoodsName': ''
-                        , 'HIsKey': false
-                        , 'HRate': '0'
-                        , 'HEmpID': '0'
-                        , 'HEmpName': ''
-                        , 'HCheckEmpID': '0'
-                        , 'HCheckEmpName': ''
-                        , 'HFinishDate': ''
-                        , 'HWorkDays': '0'
-                        , 'HRemarkSub': ''
-                    }
-                ];
-                option.data = rowdata;
-                table.render(option);
-                option1 = {
-                    elem: '#mainTable1'
-                    //, toolbar: '#toolbarDemo1'
-                    , page: false
-                    , totalRow: true
+                    , toolbar: '#toolbarDemo'
+                    , page: true
                     , limit: 500
-                    , limits: [50, 500, 5000, 50000]
+                    , limits: [50, 500, 1000, 2000]
+                    , totalRow: true
                     , cellMinWidth: 120
-                    , height: 400
-                    , cols: [[
-                        //{ type: 'checkbox', totalRowText: '鍚堣琛�' }
-                        { type: 'numbers', title: '搴忓彿', style: 'background-color: #f9f9f9;' }
-                        , { field: 'RowID', title: '琛屽彿', hide: true, style: 'background-color: #f9f9f9;' }                                                   //琛屾爣璇嗭紝鐢ㄤ簬涓嬩竴琛屻�佷笂涓�琛岃瘑鍒墍鍦ㄨ
-                        , { field: 'HEmployeeID', title: '椤圭洰鎴愬憳ID', hide: true, style: 'background-color: #f9f9f9;' }
-                        , { field: 'HEmployeeName', title: '椤圭洰鎴愬憳',  event: "HEmployeeName" }     //f7
-                        , { field: 'HIsPM', title: '鏄惁椤圭洰缁忕悊', templet: "#HIsPM" }
-                        , { field: 'HRate', title: '椤圭洰鍗犳瘮',  totalRow: true }
-                        , { field: 'HPlanAvgMoney', title: '棰勮鍒嗛厤涓氱哗',  totalRow: true }
-                        , { field: 'HPlanCountMoney', title: '棰勮鎻愭垚',  totalRow: true }
-                        , { field: 'HRemarkSub', title: '澶囨敞', edit: 'text' }
-                    ]]
+                    , height: 600
+                    , cols: [[]]
                 }
-                var rowdata1 = [
-                    {
-                        "RowID": 10
-                        , 'HEmployeeID': '0'
-                        , 'HEmployeeName': ''
-                        , 'HIsPM': false
-                        , 'HRate': '0'
-                        , 'HPlanAvgMoney': '0'
-                        , 'HPlanCountMoney': '0'
-                        , 'HRemarkSub': ''
-                    }
-                ];
-                option1.data = rowdata1;
-                table.render(option1);
             }
             //#endregion
 
             //#region 鍔犺浇琛ㄦ牸
-            function get_Display() {
+            function get_Display(sWhere) {
                 var ajaxLoad = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/PM_ProjectBill/NeedCheckQuery',
                     type: "GET",
-                    data: {"user": sessionStorage["HUserName"] },
+                    async: false,
+                    data: { "user": sessionStorage["HUserName"], "sWhere": sWhere },
                     success: function (data1) {
                         if (data1.count == 1) {
                             var data = [];//鍒楀瓧娈垫暟鎹�
@@ -455,7 +371,7 @@
                                 data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                             }
                             //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
-                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
+                            col.push({ type: 'radio', fixed: 'left', totalRowText: '鍚堣' });
                             for (var i = 0; i < data.length; i++) {
                                 // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                 if ($.inArray(data[i].name, titleData) > -1) {
@@ -481,7 +397,7 @@
                             optionNeedCheck.cols = [col];
                             optionNeedCheck.data = data1.data;
                             //鍒楄缃�
-                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], optionNeedCheck);
+                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], optionNeedCheck, titleData);
                             ins = table.render(optionNeedCheck);
                             layer.close(ajaxLoad);
                         } else {
@@ -507,8 +423,6 @@
                     data: { "HInterID": linterid, "user": sessionStorage["HUserName"] },
                     success: function (result) {
                         var tableMain = result.data[0];
-                        var tableSub = result.data[1];
-                        var tableSub_Emp = result.data[2];
                         //涓昏〃 璧嬪��
                         form.val("formData", { //formTest 鍗� class="layui-form" 鎵�鍦ㄥ厓绱犲睘鎬� lay-filter="" 瀵瑰簲鐨勫��
                             "HInterID": tableMain[0]["HInterID"]
@@ -540,36 +454,79 @@
                         if (tableMain[0]["HTaskWorkMoneyCheckFlag"] == false) {
                             $('#btnCheckWorkMoney').prop('disabled', false).removeClass('layui-btn-disabled');
                         }
-                        //娓叉煋椤圭洰闃舵琛�
-                        //璁剧疆椤圭洰闃舵琛ㄥ畬鎴愭棩鏈熺殑鏍煎紡
-                        for (var i = 0; i < tableSub.length; i++) {
-                            tableSub[i]["HFinishDate"] = Format(new Date(tableSub[i]["HFinishDate"]), "yyyy-MM-dd");
-                            tableSub[i].RowID = (i + 1) * 10;
-                        }
-                        option.data = tableSub;
-                        table.render(option);
-                        //瀵瑰瓙琛ㄤ腑鐨勫閫夋杩涜閫変腑
-                        for (var i = 0; i < tableSub.length; i++) {
-                            if (tableSub[i].HIsKey) {
-                                $('#HIsKey' + (i + 1)).attr("checked", true);
-                            }
-                        }
                         form.render('checkbox');
-                        //娓叉煋椤圭洰鎴愬憳琛�
-                        for (var i = 0; i < tableSub_Emp.length; i++) {
-                            tableSub_Emp[i].RowID = (i + 1) * 10;
-                        }
-                        option1.data = tableSub_Emp;
-                        table.render(option1);
-                        //瀵瑰瓙琛ㄤ腑鐨勯」鐩粡鐞嗗閫夋杩涜閫変腑
-                        for (var i = 0; i < tableSub_Emp.length; i++) {
-                            if (tableSub_Emp[i].HIsPM) {
-                                $('#HIsPM' + (i + 1)).attr("checked", true);
-                            }
-                        }
-                        form.render('checkbox');
+                        RoadBillSub(linterid);
                     }
                 })
+            }
+            //#endregion
+
+            //#region 鑾峰彇閿�鍞嚭搴撳崟鍒楄〃
+            function RoadBillSub(linterid)//鍔犺浇琛ㄥご
+            {
+                var ajaxLoad = layer.load();//閬僵
+                //鏄庣粏鍒楄〃
+                var sql = "exec h_p_PM_GetSellOutBillListByHProjectID " + linterid ;
+                $.ajax({
+                    url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
+                    type: "GET",
+                    async: false,
+                    data: { "sWhere": sql },
+                    success: function (data1) {
+                        if (data1.count == 1) {
+                            var data = [];//鍒楀瓧娈垫暟鎹�
+                            var col = [];
+                            var totalArray = [];
+                            var titleData = [];
+                            //缁欑┖鐨勬暟缁勮祴鍊�
+                            for (var key in data1.list) {//寰簭閬嶅巻鏁扮粍
+                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });//浠庢瘡涓璞′腑鎻愬彇鏁版嵁
+                                //鑾峰彇涓嶉渶瑕佹樉绀虹殑鍒楋紙H寮�澶寸殑鍒椾笉鏄剧ず锛�
+                                var patrn = new RegExp(/^h/i);
+                                if (patrn.test(data1.list[key].ColmCols)) {
+                                    titleData[key] = data1.list[key].ColmCols;
+                                }
+                            }
+                            //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
+                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
+                            for (var i = 0; i < data.length; i++) {//閬嶅巻data鏁扮粍閲嶇殑鏁版嵁
+                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
+                                if ($.inArray(data[i].name, titleData) > -1) {//妫�鏌ata銆恑銆�.name鏄惁鍦ㄦ暟缁勪腑  //璁$畻鍒�
+                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
+                                }
+                                else if ($.inArray(data[i].name, totalArray) > -1) { //璁$畻鍒�  
+                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120, filter: true });
+                                }  else {
+                                    switch (data[i].Type) {
+                                        //int
+                                        case 'DateTime':
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, filter: true, templet: "<div>{{d." + (data[i].name == "琛屽叧闂棩鏈�" ? "琛屽叧闂汉" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
+                                            break;
+                                        default:
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, filter: true });
+                                    }
+                                }
+                            }
+                            option.cols = [col];
+                            option.data = data1.data;
+                            //缁熻鏉愭枡璐�
+                            let totalAmount = data1.data.reduce((accumulator, currentValue) => {
+                                return accumulator + currentValue.閲戦;
+                            }, 0);
+                            $("#HTaskMaterMoney").val(totalAmount);
+                            //鍒楄缃�
+                            DisPlay_HideColumn(HModName2, sessionStorage["HUserName"], option, titleData);
+                            table.render(option);
+                            layer.close(ajaxLoad);
+                        } else {
+                            layer.alert(data1.code + data1.Message, { icon: 5 });
+                            layer.close(ajaxLoad);
+                        }
+                    }, error: function () {
+                        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                        layer.close(ajaxLoad);
+                    }
+                });
             }
             //#endregion
 
@@ -590,7 +547,7 @@
                                     //鍏抽棴褰撳墠frame
                                     layer.close(index);
                                     //淇敼涓哄姛鍚庡埛鏂扮晫闈�
-                                    get_Display();
+                                    get_FastQuery();
                                 });
 
                             } else {
@@ -607,6 +564,44 @@
             }
             //#endregion
 
+            //#region 鍒ゆ柇鏄洿鎺ユ墦寮�椤甸潰杩樻槸鍏跺畠椤甸潰閫氳繃閫夋嫨鎸夐挳鎵撳紑锛屽苟鏄剧ず鐩稿簲鏁版嵁
+            function addSWhereByOpenType() {
+                //鑾峰彇鍙傛暟
+                var params = get_UrlVars();
+                var openType = params[params[0]]; //浠庡弬鏁颁腑鑾峰彇 鎵撳紑鏂瑰紡
+                var addSWhere = openType;
+                //鏍规嵁閫掑叆鍙傛暟闅愯棌瀵瑰簲鎸夐挳鍜屾樉绀哄垪
+                if (openType == "SetupMoney") {
+                    $('#btnCheckSetupMoney').show();
+                    //titleData.push("浠诲姟宸ヨ垂瀹℃牳");
+                    //titleData.push("浠诲姟鑰冩牳璐瑰鏍�");
+                    //titleData.push("浠诲姟闄勫睘璐瑰鏍�");
+                } else if (openType == "OtherMoney") {
+                    $('#btnCheckOtherMoney').show();
+                    //titleData.push("浠诲姟瀹夎璐瑰鏍�");
+                    //titleData.push("浠诲姟宸ヨ垂瀹℃牳");
+                    //titleData.push("浠诲姟鑰冩牳璐瑰鏍�");
+                } else if (openType == "ExamMoney") {
+                    $('#btnCheckExamMoney').show();
+                    //titleData.push("浠诲姟瀹夎璐瑰鏍�");
+                    //titleData.push("浠诲姟宸ヨ垂瀹℃牳");
+                    //titleData.push("浠诲姟闄勫睘璐瑰鏍�");
+                } else if (openType == "WorkMoney") {
+                    $('#btnCheckWorkMoney').show();
+                    //titleData.push("浠诲姟瀹夎璐瑰鏍�");
+                    //titleData.push("浠诲姟鑰冩牳璐瑰鏍�");
+                    //titleData.push("浠诲姟闄勫睘璐瑰鏍�");
+                } else {
+                    addSWhere="other"
+                    //titleData.push("浠诲姟瀹夎璐瑰鏍�");
+                    //titleData.push("浠诲姟宸ヨ垂瀹℃牳");
+                    //titleData.push("浠诲姟鑰冩牳璐瑰鏍�");
+                    //titleData.push("浠诲姟闄勫睘璐瑰鏍�");
+                }
+                return addSWhere;
+            }
+            //#endregion\
+
             //#endregion
 
 

--
Gitblit v1.9.1