From 90f4e6774b6e72e4674f514b80281b5e2829e4e0 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 09 五月 2023 10:33:17 +0800
Subject: [PATCH] 流转卡编辑进去染色要求改为可修改 物料列表 、生产订单列表、工艺路线列表、流转卡列表 ,过滤条款把物料代码。物料名称。规格型号放在最上面不需要点更多去查看

---
 WebTM/views/生产管理/生产任务单/Sc_ICMOBillList.html | 1060 +++++++++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 970 insertions(+), 90 deletions(-)

diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
index 999b435..2091d32 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
@@ -27,39 +27,132 @@
                                         <span>鏇村</span>
                                     </div>
                                 </div>
-                                <div class="layui-inline">
-                                    <label class="layui-form-label">寮�濮嬫棩鏈�</label>
-                                    <div class="layui-input-block">
-                                        <input type="date" class="layui-input" id="HDate">
-                                    </div>
-                                </div>
-                                <div class="layui-inline">
-                                    <label class="layui-form-label">缁撴潫鏃ユ湡</label>
-                                    <div class="layui-input-block">
-                                        <input type="date" class="layui-input" id="HDate1">
-                                    </div>
-                                </div>
-                                <div class="layui-inline">
-                                    <label class="layui-form-label">鍗曟嵁鍙�</label>
-                                    <div class="layui-input-block">
-                                        <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter">
-                                    </div>
-                                </div>
-                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
-                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
-                                </button>
-                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
-
-                                <div class="layui-colla-content">
+                                <div class="layui-row">
                                     <div class="layui-inline">
-                                        <div class="layui-inline">
-                                            <span>鍏朵粬鏉′欢></span>
+                                        <label class="layui-form-label">瑙勬牸鍨嬪彿</label>
+                                        <div class="layui-input-block">
+                                            <input type="text" class="layui-input" name="HModel" id="HModel">
+                                        </div>
+                                    </div>                                   
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label">涓氬姟鐘舵��</label>
+                                        <div class="layui-input-block">
+                                            <select name="HStatus" id="HStatus" lay-verify="required" lay-search class="layui-input">
+                                                <!--  <option value="鍏ㄩ儴">鍏ㄩ儴</option>-->
+                                                <option value="寮�宸�">寮�宸�</option>
+                                                <option value="璁″垝">璁″垝</option>
+                                                <option value="璁″垝纭">璁″垝纭</option>
+                                                <option value="涓嬭揪">涓嬭揪</option>
+
+                                                <option value="0">鍏ㄩ儴</option>
+                                                <option value="瀹屽伐">瀹屽伐</option>
+                                                <option value="缁撴">缁撴</option>
+                                            </select>
+
+                                        </div>
+                                    </div>
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label">鏄惁涓嬫帹鐢熸垚娴佽浆鍗�</label>
+                                        <div class="layui-input-block" style="margin-top:10px">
+                                            <select name="HSF" id="HSF" lay-verify="required" lay-search class="layui-input">
+                                                <!--  <option value="鍏ㄩ儴">鍏ㄩ儴</option>-->
+                                                <option value="鍏ㄩ儴" selected="selected">鍏ㄩ儴</option>
+                                                <option value="宸蹭笅鎺�">宸蹭笅鎺�</option>
+                                                <option value="鏈笅鎺�" >鏈笅鎺�</option>
+                                            </select>
+                                        </div>
+                                    </div>
+                                </div>
+                                <div class="layui-row">
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label">鐗╂枡缂栫爜</label>
+                                        <div class="layui-input-block">
+                                            <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
+                                        </div>
+                                    </div>
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label">鐢熶骇杞﹂棿</label>
+                                        <div class="layui-input-block">
+                                            <select name="HDeptName" id="HDeptName" lay-verify="required" lay-search class="layui-input">
+
+                                                <!--鍔ㄦ�佹覆鏌撹溅闂�-->
+                                            </select>
                                         </div>
                                     </div>
                                     <div class="layui-inline">
                                         <label class="layui-form-label">鍗曟嵁鍙�</label>
                                         <div class="layui-input-block">
                                             <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter">
+                                        </div>
+                                    </div>
+                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
+                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+                                    </button>
+                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
+                                </div>
+                                <div class="layui-colla-content">
+                                    <div class="layui-row">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">鍗曟嵁绫诲瀷</label>
+                                            <div class="layui-input-block">
+                                                <input type="text" class="layui-input" name="HBillType" id="HBillType">
+                                            </div>
+                                        </div>
+                                        
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">鍞竴ID</label>
+                                            <div class="layui-input-block">
+                                                <input type="text" class="layui-input" name="HERPID" id="HERPID">
+                                            </div>
+                                        </div>
+                                    </div>                                   
+                                    <div class="layui-row" style="margin-top:5px">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">杩囨护</label>
+                                            <div class="layui-input-block">
+                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
+                                                </select>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <select name="Comparator" id="Comparator" 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" value="" name="ColContent" id="ColContent">
+                                        </div>
+                                    </div>
+                                    <div class="layui-row" style="margin-top:5px">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">鍗曟嵁鍙�</label>
+                                            <div class="layui-input-block">
+                                                <input type="text" class="layui-input" name="HBillno2" id="HBillno2" style="width:190px;">
+                                            </div>
+                                        </div>
+                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">閲嶆柊鍚屾</button>
+
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">寮�濮嬫棩鏈�</label>
+                                            <div class="layui-input-block">
+                                                <input type="date" class="layui-input" id="HDate">
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">缁撴潫鏃ユ湡</label>
+                                            <div class="layui-input-block">
+                                                <input type="date" class="layui-input" id="HDate1">
+                                            </div>
                                         </div>
                                     </div>
                                 </div>
@@ -69,9 +162,23 @@
                         <script type="text/html" id="toolbarDemo">
                             <div class="layui-btn-container">
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>涓嬫帹</button>
-                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill_pl"><i class="layui-icon layui-icon-form"></i>鎵归噺涓嬫帹</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill_dh"><i class="layui-icon layui-icon-form"></i>澶氳涓嬫帹</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>鏂板</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Edit"><i class="layui-icon layui-icon-form"></i>缂栬緫</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_copy"><i class="layui-icon layui-icon-form"></i>澶嶅埗</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew_NT"><i class="layui-icon layui-icon-file-b"></i>鏂板(鏃犲垪琛�)</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Edit_NT"><i class="layui-icon layui-icon-form"></i>缂栬緫(鏃犲垪琛�)</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_copy_NT"><i class="layui-icon layui-icon-form"></i>澶嶅埗(鏃犲垪琛�)</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill"><i class="layui-icon layui-icon-form"></i>瀹℃牳</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck"><i class="layui-icon layui-icon-form"></i>鍙嶅鏍�</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button>
+                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Excel"><i class="layui-icon layui-icon-file-b"></i>Excel瀵煎叆</button>-->
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get-view"><i class="layui-icon layui-icon-tips"></i>棰勮</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get-print"><i class="layui-icon layui-icon-print"></i>鎵撳嵃</button>
                             </div>
                         </script>
                     </form>
@@ -101,11 +208,43 @@
             //var sWhere = " 浜у搧浠g爜 = 'BX0002'";
             var sWhere = "";
             var sWhere = "";
+            var HModName = "Sc_ICMOBillList";
+            var HDeptID = 0;
 
+            var params = getUrlVars();
+            var HDeptID = params[params[0]];
 
+            //鍒ゆ柇鏄惁鏈夊弬鏁颁紶閫�
+           
+
+            //鍒濆鍖栬〃鏍�
+            DisPlay_HideColumn();
             //鍒濆鍖栫晫闈�
             set_ClearBill();
+            //鑾峰彇杞﹂棿鍒�
+            var HDeptName = '<option value="0" style="color:red;" selected>鍏ㄩ儴杞﹂棿</option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Sc_ICMOBill/GetHDeptList",
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            if (i == 0)
+                                HDeptName += '<option  style="color:blue;"  value="' + data[i].HItemID + '" >' + data[i].HName + '</option>';
+                            else
+                                HDeptName += '<option  style="color:blue;" value="' + data[i].HItemID + '">' + data[i].HName + '</option>';
 
+                        }
+                        $("#HDeptName").append(HDeptName);
+                        if (!isNaN(HDeptID)) {
+                            $("#HDeptName").val(HDeptID);
+                        }
+                        form.render('select');
+                    }
+                    layer.closeAll("loading");
+                }
+            })
             //#endregion
 
 
@@ -113,10 +252,47 @@
             table.on('toolbar(mainTable)', function (obj) {
                 switch (obj.event) {
                     //涓嬫帹
-                    case 'set_ShowBill': set_ShowBill();
+                    case 'set_ShowBill': set_ShowBill(); 
+                        break;
+                    //鎵归噺涓嬫帹
+                    case 'set_ShowBill_pl': set_ShowBill_pl(); //set_ShowBill_pl
+                        break;
+                    //澶氳涓嬫帹
+                    case 'set_ShowBill_dh': set_ShowBill_dh();
+                        break;
+                    //鏂板
+                    case 'set_AddNew': set_AddNew();
+                        break;
+                    //缂栬緫
+                    case 'set_Edit': set_Edit();
+                        break;
+                    //澶嶅埗
+                    case 'set_copy': set_copy();
+                        break;
+                    //鏂板(鏃犲垪琛�)
+                    case 'set_AddNew_NT': set_AddNew_NT();
+                        break;
+                    //缂栬緫(鏃犲垪琛�)
+                    case 'set_Edit_NT': set_Edit_NT();
+                        break;
+                    //澶嶅埗(鏃犲垪琛�)
+                    case 'set_copy_NT': set_copy_NT();
+                        break;
+                    //瀹℃牳
+                    case 'set_CheckBill': set_CheckBill();
+                        break;
+                    //鍙嶅鏍�
+                    case 'set_AbandonCheck': set_AbandonCheck();
                         break;
                     //鍒犻櫎
                     case 'set_DeleteBill': set_DeleteBill();
+                        break;
+                    //瀵煎叆
+                    case 'set_Excel': set_Excel();
+                        break;
+                    case 'get-view': get_ViewReport();
+                        break;
+                    case 'get-print': get_PrintReport();
                         break;
                     //鍒锋柊
                     case 'get_Refresh': get_Refresh();
@@ -124,7 +300,20 @@
                     //閫�鍑烘寜閽�
                     case 'get_Exit': Pub_Close(2);
                         break;
+                    //鎵撳嵃
+                    case 'btn-print':
+                        get_PrintReport();
+                        break;
+                    //鍒楄缃�
+                    case 'set_HideColumn':
+                        get_HideColumn();
+                        break;
                 };
+            });
+
+            //閲嶆柊鍚屾鎸夐挳
+            form.on('submit(btnResCnz)', function (data) {
+                set_ResCnz();
             });
 
             //閲嶇疆鎸夐挳
@@ -149,6 +338,87 @@
             //#endregion
 
 
+            option_YQN = {
+                elem: '#mainTable'
+                , toolbar: '#toolbarDemo'
+                , height: 'full-50'
+                , page: true
+                , cellMinWidth: 90
+                , limit: 50
+                , limits: [50, 500, 5000, 20000]
+                , cols: [[
+                    { type: 'checkbox', fixed: 'left' }
+                    , { field: 'hmainid', title: 'hmainid', sort: true, width: 165, hide: true }
+                    , { field: 'HEntryID', title: 'HEntryID', sort: true, width: 165, hide: true }
+
+                    , { field: '鏃ユ湡', title: '鏃ユ湡', sort: true, width: 120, hide: true }
+                    , { field: '閿�鍞鍗曟棩鏈�', title: '閿�鍞鍗曟棩鏈�', sort: true, width: 120, hide: true }
+                    , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', sort: true, width: 170, hide: true }
+
+                    , { field: '閿�鍞鍗曟棩鏈�', title: '閿�鍞鍗曟棩鏈�', sort: true, width: 200 }
+                    , { field: '閿�鍞鍗曠紪鍙�', title: '閿�鍞鍗曠紪鍙�', sort: true, width: 200 }
+                    , { field: '閿�鍞墿鏂欏悕绉�', title: '閿�鍞墿鏂欏悕绉�', sort: true, width: 200 }
+                    , { field: '鍖呰鏂瑰紡', title: '鍖呰鏂瑰紡', sort: true, width: 150 }
+                    , { field: '閿�鍞暟閲�', title: '閿�鍞暟閲�', sort: true, width: 150 }
+                    , { field: '閿�鍞鍗曡仈绯讳汉', title: '閿�鍞鍗曡仈绯讳汉', sort: true, width: 150 }
+                    , { field: '涓氬姟鐘舵��', title: '涓氬姟鐘舵��', sort: true, width: 150 }
+
+                    , { field: '璁㈠崟璺熻釜鍙�', title: '璁㈠崟璺熻釜鍙�', sort: true, width: 120, hide: true }
+                    , { field: 'HDeptID', title: 'HDeptID', hide: true }
+                    , { field: '鐢熶骇杞﹂棿浠g爜', title: '鐢熶骇杞﹂棿浠g爜', width: 115, hide: true }
+                    , { field: '鐢熶骇杞﹂棿', title: '鐢熶骇杞﹂棿', width: 115, hide: true }
+                    , { field: 'HMaterID', title: 'HMaterID', hide: true }
+                    , { field: '浜у搧浠g爜', title: '浜у搧浠g爜', width: 160, hide: true }
+                    , { field: '浜у搧鍚嶇О', title: '浜у搧鍚嶇О', width: 160, hide: true }
+                    , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 215, hide: true }
+                    , { field: 'hunitid', title: 'hunitid', hide: true }
+                    , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 115, hide: true }
+                    , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', hide: true }
+
+                    , { field: 'hempid', title: 'hempid', hide: true }
+                    , { field: '涓氬姟鍛樹唬鐮�', title: '涓氬姟鍛樹唬鐮�', width: 100, hide: true }
+                    , { field: '涓氬姟鍛�', title: '涓氬姟鍛�', hide: true }
+                    , { field: 'hcusid', title: 'hcusid', hide: true }
+                    , { field: '瀹㈡埛浠g爜', title: '瀹㈡埛浠g爜', hide: true }
+                    , { field: '瀹㈡埛', title: '瀹㈡埛', hide: true }
+                    , { field: 'HCenterID', title: 'HCenterID', hide: true }
+                    , { field: '宸ヤ綔涓績浠g爜', title: '宸ヤ綔涓績浠g爜', hide: true }
+                    , { field: '宸ヤ綔涓績', title: '宸ヤ綔涓績', hide: true }
+                    , { field: 'hbomid', title: 'hbomid', hide: true }
+                    , { field: 'BOM鍗曠紪鐮�', title: 'BOM鍗曠紪鐮�', hide: true }
+                    , { field: 'HRoutingInterID', title: 'HRoutingInterID', hide: true }
+                    , { field: '宸ヨ壓璺嚎浠g爜', title: '宸ヨ壓璺嚎浠g爜', hide: true }
+                    , { field: '宸ヨ壓璺嚎', title: '宸ヨ壓璺嚎', hide: true }
+                    , { field: '璁″垝寮�宸ユ棩鏈�', title: '璁″垝寮�宸ユ棩鏈�', hide: true }
+                    , { field: '璁″垝瀹屽伐鏃ユ湡', title: '璁″垝瀹屽伐鏃ユ湡', hide: true }
+                    , { field: '鏈�杩熷紑宸ユ棩鏈�', title: '鏈�杩熷紑宸ユ棩鏈�', hide: true }
+                    , { field: '鏈�杩熷畬宸ユ棩鏈�', title: '鏈�杩熷畬宸ユ棩鏈�', hide: true }
+                    , { field: '榻愬鏁伴噺', title: '榻愬鏁伴噺', hide: true }
+                    , { field: '璁″垝鐢熶骇鏁伴噺', title: '璁″垝鐢熶骇鏁伴噺', hide: true }
+                    , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺', hide: true }
+                    , { field: '鏈叧鑱旀暟閲�', title: '鏈叧鑱旀暟閲�', hide: true }
+                    , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞', hide: true }
+                    , { field: 'hsubid', title: 'hsubid', hide: true }
+                    , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', hide: true }
+                    , { field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', hide: true }
+                    , { field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', hide: true }
+                    , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', hide: true }
+                    , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', hide: true }
+                    , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', hide: true }
+                    , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', hide: true }
+                    , { field: '淇敼浜�', title: '淇敼浜�', hide: true }
+                    , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', hide: true }
+                    , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', hide: true }
+                    , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', hide: true }
+                    , { field: '浣滃簾浜�', title: '浣滃簾浜�', hide: true }
+                    , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', hide: true }
+                    , { field: '琛屽叧闂汉', title: '琛屽叧闂汉', hide: true }
+                    , { field: '鍏抽棴绫诲瀷', title: '鍏抽棴绫诲瀷', hide: true }
+                    , { field: '鍗曟嵁绫诲瀷', title: '鍗曟嵁绫诲瀷', hide: true }
+                    , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', hide: true }
+                ]]
+            };
+
             function set_InitGrid() {
                 $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                 $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
@@ -157,67 +427,104 @@
                     , toolbar: '#toolbarDemo'
                     , height: 'full-50'
                     , page: true
-                    , cellMinWidth: 90
+                    , cellMinWidth: 'auto'
+                    , totalRow: true
                     , limit: 50
                     , limits: [50, 500, 5000, 20000]
                     , cols: [[
-                        { type: 'checkbox', fixed: 'left' }
-                        //{ field: 'hmainid', title: 'hmainid', sort: true, width: 165 }
-                        , { field: '鏃ユ湡', title: '鏃ユ湡', sort: true, width: 120 }
-                        , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', sort: true, width: 170 }
-                        , { field: '璁㈠崟璺熻釜鍙�', title: '璁㈠崟璺熻釜鍙�', width: 105 }
-                        //, { field: 'HDeptID', title: 'HDeptID' }
-                        , { field: '鐢熶骇杞﹂棿浠g爜', title: '鐢熶骇杞﹂棿浠g爜', width: 115 }
-                        , { field: '鐢熶骇杞﹂棿', title: '鐢熶骇杞﹂棿', width: 115 }
-                        //, { field: 'HMaterID', title: 'HMaterID' }
-                        , { field: '浜у搧浠g爜', title: '浜у搧浠g爜', width: 160 }
-                        , { field: '浜у搧鍚嶇О', title: '浜у搧鍚嶇О', width: 160 }
-                        , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 215 }
-                        //, { field: 'hunitid', title: 'hunitid' }
-                        , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 115 }
-                        , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅' }
-                        //, { field: 'hempid', title: 'hempid' }
-                        , { field: '涓氬姟鍛樹唬鐮�', title: '涓氬姟鍛樹唬鐮�', width: 100 }
-                        , { field: '涓氬姟鍛�', title: '涓氬姟鍛�' }
-                        , { field: 'hcusid', title: 'hcusid' }
-                        , { field: '瀹㈡埛浠g爜', title: '瀹㈡埛浠g爜' }
+                        { type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' }
+                        , { field: 'hmainid', title: 'hmainid', sort: true, hide: true }
+                        , { field: 'HEntryID', title: 'HEntryID', sort: true, hide: true }
+                        , { field: '鏃ユ湡', title: '鏃ユ湡' }
+                        , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', sort: true }
+                        , { field: '浜у搧浠g爜', title: '浜у搧浠g爜' }
+                        , { field: '浜у搧鍚嶇О', title: '浜у搧鍚嶇О'}
                         , { field: '瀹㈡埛', title: '瀹㈡埛' }
-                        //, { field: 'HCenterID', title: 'HCenterID' }
-                        , { field: '宸ヤ綔涓績浠g爜', title: '宸ヤ綔涓績浠g爜' }
-                        , { field: '宸ヤ綔涓績', title: '宸ヤ綔涓績' }
-                        //, { field: 'hbomid', title: 'hbomid' }
-                        , { field: 'BOM鍗曠紪鐮�', title: 'BOM鍗曠紪鐮�' }
-                        //, { field: 'HRoutingInterID', title: 'HRoutingInterID' }
-                        , { field: '宸ヨ壓璺嚎浠g爜', title: '宸ヨ壓璺嚎浠g爜' }
-                        , { field: '宸ヨ壓璺嚎', title: '宸ヨ壓璺嚎' }
+                        , { field: '涓氬姟鍛�', title: '涓氬姟鍛�' }
+                        , { field: 'HWidth', title: '闂ㄥ箙' }
+                        , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿' }
+                        , { field: '鐢熶骇浠诲姟鍗曟暟閲�', title: '鐢熶骇璁㈠崟鏁伴噺', totalRow: true }
+                        , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅' }
+                        , { field: '鏄惁涓嬫帹鐢熸垚娴佽浆鍗�', title: '鏄惁涓嬫帹鐢熸垚娴佽浆鍗�', sort: true }
+                        , { field: '鍒跺崟浜�', title: '鍒跺崟浜�' }
+                        , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡' }
+                        , { field: '鐘舵��', title: '鐘舵��', sort: true }
+                        //, { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 115 }
+                        , { field: 'HAuxQty', title: '杈呮暟閲�' }
+                        , { field: 'HAuxUnitName', title: '杈呭姪鍗曚綅' }
                         , { field: '璁″垝寮�宸ユ棩鏈�', title: '璁″垝寮�宸ユ棩鏈�' }
                         , { field: '璁″垝瀹屽伐鏃ユ湡', title: '璁″垝瀹屽伐鏃ユ湡' }
                         , { field: '鏈�杩熷紑宸ユ棩鏈�', title: '鏈�杩熷紑宸ユ棩鏈�' }
                         , { field: '鏈�杩熷畬宸ユ棩鏈�', title: '鏈�杩熷畬宸ユ棩鏈�' }
-                        , { field: '榻愬鏁伴噺', title: '榻愬鏁伴噺' }
-                        , { field: '璁″垝鐢熶骇鏁伴噺', title: '璁″垝鐢熶骇鏁伴噺' }
-                        , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺' }
-                        , { field: '鏈叧鑱旀暟閲�', title: '鏈叧鑱旀暟閲�' }
-                        , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞' }
-                        //, { field: 'hsubid', title: 'hsubid' }
-                        , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿' }
-                        , { field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�' }
-                        , { field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�' }
-                        , { field: '鍒跺崟浜�', title: '鍒跺崟浜�' }
-                        , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡' }
                         , { field: '瀹℃牳浜�', title: '瀹℃牳浜�' }
                         , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡' }
                         , { field: '淇敼浜�', title: '淇敼浜�' }
                         , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡' }
                         , { field: '鍏抽棴浜�', title: '鍏抽棴浜�' }
                         , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡' }
-                        , { field: '浣滃簾浜�', title: '浣滃簾浜�' }
-                        , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡' }
-                        , { field: '琛屽叧闂汉', title: '琛屽叧闂汉' }
-                        , { field: '鍏抽棴绫诲瀷', title: '鍏抽棴绫诲瀷' }
-                        , { field: '鍗曟嵁绫诲瀷', title: '鍗曟嵁绫诲瀷' }
-                        , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�' }
+                        , { field: '鍞竴ID', title: '鍞竴ID', sort: true, }
+                        , { field: '鐢熶骇杞﹂棿浠g爜', title: '鐢熶骇杞﹂棿浠g爜'  }
+                        , { field: '鐢熶骇杞﹂棿', title: '鐢熶骇杞﹂棿',  }
+                        , { field: '鍖呰鏍囪瘑浠g爜', title: '鍖呰鏍囪瘑浠g爜' }
+                        , { field: '鍖呰鏍囪瘑', title: '鍖呰鏍囪瘑',  }
+                        , { field: '榻愬鏁伴噺', title: '榻愬鏁伴噺' }
+                        , { field: '璁″垝鐢熶骇鏁伴噺', title: '璁″垝鐢熶骇鏁伴噺' }
+                        , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺' }
+                        , { field: '鏈叧鑱旀暟閲�', title: '鏈叧鑱旀暟閲�' }
+                        , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞' }
+                        //, { field: '浣滃簾浜�', title: '浣滃簾浜�', hide: true }
+                        //, { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', hide: true }
+                        //, { field: '閿�鍞鍗曟棩鏈�', title: '閿�鍞鍗曟棩鏈�', sort: true, width: 120, hide: true }
+                        , { field: '閿�鍞鍗曟棩鏈�', title: '閿�鍞鍗曟棩鏈�', sort: true  }
+                        , { field: '閿�鍞鍗曠紪鍙�', title: '閿�鍞鍗曠紪鍙�', sort: true }
+                        , { field: '閿�鍞墿鏂欏悕绉�', title: '閿�鍞墿鏂欏悕绉�', sort: true }
+                        , { field: '鍖呰鏂瑰紡', title: '鍖呰鏂瑰紡', sort: true }
+                        , { field: '閿�鍞暟閲�', title: '閿�鍞暟閲�', sort: true }
+                        , { field: '閿�鍞鍗曡仈绯讳汉', title: '閿�鍞鍗曡仈绯讳汉', sort: true }
+                        , { field: '涓氬姟鐘舵��', title: '涓氬姟鐘舵��', sort: true }
+                        //, { field: '璁㈠崟璺熻釜鍙�', title: '璁㈠崟璺熻釜鍙�', sort: true, width: 120, hide: true }
+                        //, { field: 'HDeptID', title: 'HDeptID', hide: true}
+                        //, { field: 'HMaterID', title: 'HMaterID', hide: true }
+                        //, { field: 'hunitid', title: 'hunitid', hide: true }
+                        //, { field: 'hempid', title: 'hempid' , hide: true}
+                        //, { field: '涓氬姟鍛樹唬鐮�', title: '涓氬姟鍛樹唬鐮�', width: 100, hide: true}
+                       
+                        //, { field: 'hcusid', title: 'hcusid', hide: true }
+                        //, { field: '瀹㈡埛浠g爜', title: '瀹㈡埛浠g爜', hide: true }
+                      
+                        //, { field: 'HCenterID', title: 'HCenterID' , hide: true}
+                        //, { field: '宸ヤ綔涓績浠g爜', title: '宸ヤ綔涓績浠g爜', hide: true}
+                        //, { field: '宸ヤ綔涓績', title: '宸ヤ綔涓績', hide: true}
+                        //, { field: 'hbomid', title: 'hbomid' , hide: true}
+                        //, { field: 'BOM鍗曠紪鐮�', title: 'BOM鍗曠紪鐮�', hide: true }
+                        //, { field: 'HRoutingInterID', title: 'HRoutingInterID' , hide: true}
+                        , { field: '宸ヨ壓璺嚎浠g爜', title: '宸ヨ壓璺嚎浠g爜'}
+                        , { field: '宸ヨ壓璺嚎', title: '宸ヨ壓璺嚎'}
+                        //, { field: 'hsubid', title: 'hsubid' , hide: true}
+                        //, { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', hide: true}
+                        //, { field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', hide: true}
+                        //, { field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', hide: true}
+                        //, { field: '琛屽叧闂汉', title: '琛屽叧闂汉', hide: true}
+                        //, { field: '鍏抽棴绫诲瀷', title: '鍏抽棴绫诲瀷', hide: true}
+                        //, { field: '鍗曟嵁绫诲瀷', title: '鍗曟嵁绫诲瀷', hide: true}
+                        //, { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', hide: true}
                     ]]
+                    , done: function (res, curr, count) {
+                        var $data = $('div[lay-id="mainTable"]').find('.layui-table-body').find('tr').eq(0).find('td');
+                        var $head = $('div[lay-id="mainTable"]').find('.layui-table-header').find('tr').eq(0).find('th');
+                        var $total = $('div[lay-id="mainTable"]').find('.layui-table-total').find('tr').eq(0).find('td');
+                        for (var i = 0; i < $data.length; i++) {
+                            var l1 = $data.eq(i).find('div').width();
+                            var l2 = $head.eq(i).find('div').width();
+                            if (l1 > l2) {
+                                $head.eq(i).find('div').width(l1);
+                                $total.eq(i).find('div').width(l1);
+                            } else {
+                                $data.eq(i).find('div').width(l2);
+                                $total.eq(i).find('div').width(l2);
+                            }
+                        }
+                    }
                 };
             }
 
@@ -234,7 +541,11 @@
                             option.data = data1.data;
                             table.render(option);
                             layer.close(ajaxLoad);
-                            //layer.alert("鏌ヨ鎴愬姛", { icon: 1 });
+
+                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
+                                ColFilter();
+                            }
+                            layer.close(ajaxLoad);
                         } else {
                             layer.close(ajaxLoad);
                             layer.alert(data1.code + data1.Message, { icon: 5 });
@@ -250,10 +561,62 @@
 
             //#region 蹇�熻繃婊�
             function get_FastQuery() {
-                var HDate = $("#HDate").val();//寮�濮嬫棩鏈�
+                var HDate =  $("#HDate").val();;//寮�濮嬫棩鏈�
                 var HDate1 = $("#HDate1").val();//缁撴潫鏃ユ湡
                 var HOrderProcNO = $("#HOrderProcNO").val();//璁㈠崟璺熻釜鍙�
                 var WorkCenter = $("#WorkCenter").val();//鍗曟嵁鍙�
+                var HMaterName = $("#HMaterName").val();//鍗曟嵁鍙�
+                var HErpID = $("#HERPID").val();//鍞竴鏍囪瘑
+                var HDeptName = $("#HDeptName").val();//鍗曟嵁鍙�
+                var HStatus = $("#HStatus").val();//鍗曟嵁鍙�
+                var HBillType = $("#HBillType").val();//鍗曟嵁绫诲瀷
+                var HSF = $("#HSF").val();//鍗曟嵁绫诲瀷
+                var HModel = $("#HModel").val();//瑙勬牸鍨嬪彿
+                var ColName = $("#ColName").val();//澶嶉�夋
+                var Comparator = $("#Comparator").val()
+                var ColContent = $("#ColContent").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;
+                }
+
+                //浼犻�掔殑鍙傛暟涓嶄负NAN
+                if (!isNaN(HDeptID) && HDeptName==0) {
+                    HDeptName = HDeptID;
+                }
+                if (!isNaN(HDeptID)) {
+                    HStatus = "寮�宸�";
+                }
+
+                if (HSF) {//鍒ゆ柇鎵撳嵃鐘舵��
+                    if (HSF == "鍏ㄩ儴") {
+                        sWhere += "";
+                    }
+                    if (HSF == "宸蹭笅鎺�") {
+                        sWhere += " and 鏄惁涓嬫帹鐢熸垚娴佽浆鍗� like '%" + HSF + "%' ";
+                    }
+                    if (HSF == "鏈笅鎺�") {
+                        sWhere += " and 鏄惁涓嬫帹鐢熸垚娴佽浆鍗� like '%" + HSF + "%' ";
+                    }
+                }
                 if (HDate) {
                     sWhere += " and 鏃ユ湡 >= '" + HDate + "'";
                 }
@@ -266,6 +629,27 @@
                 if (WorkCenter) {
                     sWhere += " and 鍗曟嵁鍙� like '%" + WorkCenter + "%'";
                 }
+                if (HMaterName) {
+                    sWhere += " and 浜у搧浠g爜 like '%" + HMaterName + "%'";
+                }
+                if (HDeptName && HDeptName!=0) {
+                    sWhere += " and HDeptID = " + HDeptName ;
+                }
+                if (HStatus && HStatus != 0) {
+                    sWhere += " and 鐘舵��  like '%" + HStatus + "%'";
+                }
+                if (HBillType) {
+                    sWhere += " and 鍗曟嵁绫诲瀷 like '%" + HBillType + "%'";
+                }
+                if (HErpID) {
+                    sWhere += " and 鍞竴ID like '%" + HErpID + "%'";
+                } 
+                if (HModel) {
+                    sWhere += " and 瑙勬牸鍨嬪彿 like '%" + HModel + "%'";
+                }
+                //if (HSF) {
+                //    sWhere += " and 鏄惁涓嬫帹鐢熸垚娴佽浆鍗� like '%" + HSF + "%'";
+                //}
                 get_Display(sWhere);
                 sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
             }
@@ -273,11 +657,20 @@
 
             //#region 閲嶇疆杩囨护鏉′欢鏂规硶
             function set_ClearQuery() {
-                $("#HDate").val("");//寮�濮嬫棩鏈�
-                $("#HDate1").val("");//缁撴潫鏃ユ湡
+                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//寮�濮嬫棩鏈�
+                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));;//缁撴潫鏃ユ湡
                 $("#HOrderProcNO").val("");//璁㈠崟璺熻釜鍙�
                 $("#WorkCenter").val("");//鍗曟嵁鍙�
+                $("#HDeptName").val("");//鍗曟嵁鍙�
+                $("#HMaterName").val("");//鍗曟嵁鍙�
+                $("#HDeptName").val("");//鍗曟嵁鍙�
+                $("#HStatus").val("");//鍗曟嵁鍙�
+                $("#HModel").val("");//瑙勬牸鍨嬪彿
                 $("#btnSearch").click();
+                $("#ColContent").val("");
+                $("#ColName").val("0");
+                $("#Comparator").val("0");
+                form.render('select');
                 sWhere = "";
             }
             //#endregion
@@ -302,21 +695,205 @@
             //        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
             //    }
             //});
-            //缂栬緫鍗曟嵁
+
+            //涓嬫帹鍗曟嵁
             function set_ShowBill() {
                 var checkStatus = table.checkStatus('mainTable')
                     , data = checkStatus.data;
                 if (data.length === 1) {
                     var linterid = data[0].hmainid.toString();
+                    var HEntryID = data[0].HEntryID.toString();
                     layer.open({
                         type: 2
                         , area: ['100%', '100%']
                         , title: '宸ュ簭娴佽浆鍗�-缂栬緫'
                         , shift: 0//寮瑰嚭鍔ㄧ敾
-                        , content: '../../杞﹂棿绠$悊/宸ュ簭娴佽浆鍗�/Sc_ProcessExchangeBill.html?OperationType=2&linterid=' + linterid + '&HSouceBillType=3772'
+                        , content: '../../杞﹂棿绠$悊/宸ュ簭娴佽浆鍗�/Sc_ProcessExchangeBill.html?OperationType=2&linterid=' + linterid + '&HEntryID=' + HEntryID+'&HSouceBillType=3772'
                     })
                 } else {
                     layer.msg('璇烽�夋嫨涓�琛屾暟鎹笅鎺紒');
+                }
+            }
+
+            //鎵归噺涓嬫帹鍗曟嵁
+            function set_ShowBill_pl() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (data.length === 1) {
+                    var linterid = data[0].hmainid.toString();
+                    var HEntryID = data[0].HEntryID.toString();
+                    layer.open({
+                        type: 2
+                        , area: ['100%', '100%']
+                        , title: '宸ュ簭娴佽浆鍗�-缂栬緫'
+                        , shift: 0//寮瑰嚭鍔ㄧ敾
+                        , content: '../../杞﹂棿绠$悊/宸ュ簭娴佽浆鍗�/Sc_ProcessExchangeBill_Mul.html?OperationType=2&linterid=' + linterid + '&HEntryID=' + HEntryID + '&HSouceBillType=3772'
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨涓�琛屾暟鎹笅鎺紒');
+                }
+            }
+
+            //澶氳鎵归噺涓嬫帹鍗曟嵁
+            function set_ShowBill_dh() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (data.length != 0) {
+                    layer.confirm("纭瑕佷笅鎺ㄥ悧?", function (index) {
+                        var wait = layer.load();
+                        var hmainid = [];
+                        for (var i = 0; i < checkStatus.data.length; i++) {
+                            var linterid = data[i].hmainid.toString();
+                            var HEntryID = data[i].HEntryID.toString();
+                            hmainid.push(linterid + "|" + HEntryID);
+                        }
+                       
+                        $.ajax({
+                            url: GetWEBURL() + '/Sc_ICMOBill/Sc_ICMOReportBill_dh',
+                            type: "GET",
+                            data: { "HInterID": hmainid.toString(), "user": sessionStorage["HUserName"], "OrganizationID": sessionStorage["OrganizationID"]  },
+                            success: function (result) {
+                                if (result.count == 1) {
+                                    layer.alert(result.Message);
+                                    layer.close(wait);
+                                } else {
+                                    layer.alert(result.code + result.Message, { icon: 5 });
+                                    layer.close(wait);
+                                }
+                            }, error: function () {
+                                layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                                layer.close(wait);
+                            }
+                        });
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨鏁版嵁涓嬫帹锛�');
+                }
+            }
+
+            //鏂板
+            function set_AddNew() {
+                layer.open({
+                    type: 2
+                    , skin: 'layui-layer-rim' //鍔犱笂杈规
+                    , area: ['100%', '100%']
+                    , title: '鐢熶骇璁㈠崟鏂板'
+                    , shift: 0//寮瑰嚭鍔ㄧ敾
+                    , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit.html?OperationType=1&linterid='
+                    , end: function () {
+                        //鍒锋柊椤甸潰,
+                        location.reload();
+                    }
+                })
+            }
+
+            // 缂栬緫
+            function set_Edit() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (checkStatus.data.length === 1) {
+                    var linterid = data[0].hmainid;
+
+                    layer.open({
+                        type: 2
+                        , area: ['100%', '100%']
+                        , title: '鐢熶骇璁㈠崟缂栬緫'
+                        , shift: 0//寮瑰嚭鍔ㄧ敾
+                        , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit.html?OperationType=3&linterid=' + linterid +''
+                        , end: function () {
+                            //鍒锋柊椤甸潰,
+                            location.reload();
+                        }
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
+                }
+            }
+
+            // 澶嶅埗
+            function set_copy() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (checkStatus.data.length === 1) {
+                    var linterid = data[0].hmainid;
+
+                    layer.open({
+                        type: 2
+                        , area: ['100%', '100%']
+                        , title: '鐢熶骇璁㈠崟缂栬緫'
+                        , shift: 0//寮瑰嚭鍔ㄧ敾
+                        , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit.html?OperationType=2&linterid=' + linterid + ''
+                        , end: function () {
+                            //鍒锋柊椤甸潰,
+                            location.reload();
+                        }
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
+                }
+            }
+
+            //鏂板(鏃犲垪琛�)
+            function set_AddNew_NT() {
+                layer.open({
+                    type: 2
+                    , skin: 'layui-layer-rim' //鍔犱笂杈规
+                    , area: ['100%', '100%']
+                    , title: '鐢熶骇璁㈠崟鏂板'
+                    , shift: 0//寮瑰嚭鍔ㄧ敾
+                    , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit_NoTable.html?OperationType=1&linterid=&HEntryID=1'
+                    , end: function () {
+                        //鍒锋柊椤甸潰,
+                        location.reload();
+                    }
+                })
+            }
+
+            // 缂栬緫(鏃犲垪琛�)
+            function set_Edit_NT() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (checkStatus.data.length === 1) {
+                    var linterid = data[0].hmainid;
+                    var HEntryID = data[0].hsubid;
+
+                    layer.open({
+                        type: 2
+                        , area: ['100%', '100%']
+                        , title: '鐢熶骇璁㈠崟缂栬緫'
+                        , shift: 0//寮瑰嚭鍔ㄧ敾
+                        , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit_NoTable.html?OperationType=3&linterid=' + linterid + '&HEntryID=' + HEntryID
+                        , end: function () {
+                            //鍒锋柊椤甸潰,
+                            location.reload();
+                        }
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
+                }
+            }
+
+            // 澶嶅埗(鏃犲垪琛�)
+            function set_copy_NT() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                if (checkStatus.data.length === 1) {
+                    var linterid = data[0].hmainid;
+                    var HEntryID = data[0].hsubid;
+
+                    layer.open({
+                        type: 2
+                        , area: ['100%', '100%']
+                        , title: '鐢熶骇璁㈠崟缂栬緫'
+                        , shift: 0//寮瑰嚭鍔ㄧ敾
+                        , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit_NoTable.html?OperationType=2&linterid=' + linterid + '&HEntryID=' + HEntryID
+                        , end: function () {
+                            //鍒锋柊椤甸潰,
+                            location.reload();
+                        }
+                    })
+                } else {
+                    layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
                 }
             }
 
@@ -360,24 +937,327 @@
 
             }
             //#endregion
-            //laydate.render({
-            //    elem: '#HDate'
-            //    , type: 'datetime'
-            //    , trigger: 'click'
-            //    , format:'yyyy-MM-dd HH:mm'
-            //});
+
+            //瀵煎叆
+            function set_Excel() {
+                layer.open({
+                    type: 2
+                    , skin: 'layui-layer-rim' //鍔犱笂杈规
+                    , area: ['100%', '100%']
+                    , title: '鐢熶骇璁㈠崟瀵煎叆'
+                    , shift: 0//寮瑰嚭鍔ㄧ敾
+                    , content: '../鐢熶骇浠诲姟鍗�/Sc_ICMOBillImport.html?OperationType=1'
+                    , end: function () {
+                        //鍒锋柊椤甸潰,
+                        location.reload();
+                    }
+                })
+            }
+
+            //閲嶆柊鍚屾鎸夐挳
+            function set_ResCnz() {
+                var HBillno2 = $('#HBillno2').val();
+                $.ajax({
+                    url: GetWEBURL() + '/Sc_ICMOBill/Sc_ICMOBillViewApi',
+                    type: "GET",
+                    data: { "BillNo": HBillno2, "BillType": 3710 },
+                    success: function (result) {
+                        if (result.count == 1) {
+                            layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
+                                // 寰楀埌frame绱㈠紩
+                                var index = layer.getFrameIndex(window.name);
+                                //鍏抽棴褰撳墠frame
+                                layer.close(index);
+                                //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+                                window.location.reload();
+                            });
+
+                        } else {
+                            layer.alert(result.code + result.Message, { icon: 5 });
+                        }
+                    }, error: function () {
+                        layer.close(wait);
+                        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                    }
+                });
+            }
+            //#endregion
+           
             //#region 鍒锋柊
             function get_Refresh() {
                 set_ClearQuery();
-                get_Display(sWhere);
+                get_FastQuery();
+            }
+            //#endregion
+
+            //#region 鎵撳嵃
+            //棰勮
+            function get_ViewReport() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                var PrintIds = "";
+                if (checkStatus.data.length >= 1) {
+                    for (var i = 0; i < data.length; i++) {
+                        PrintIds += data[i].hmainid+"0"+data[i].HEntryID + ","
+                    }
+                    PrintIds = PrintIds.substring(0, PrintIds.length - 1);
+                    layer.open({
+                        type: 2
+                        , area: ['50%', '50%']
+                        , title: '鎵撳嵃妯$増閫夋嫨'
+                        , shade: 0.6 //閬僵閫忔槑搴�
+                        , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+                        , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + PrintIds + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HIcmoBill', 'yes']
+                        , resize: false
+                    })
+                }
+                else {
+                    layer.msg('璇烽�夋嫨鑷冲皯涓�琛屾暟鎹墦鍗帮紒');
+                }
+            }
+
+            //鎵撳嵃
+            function get_PrintReport() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+                var PrintIds = "";
+                if (checkStatus.data.length >= 1) {
+                    for (var i = 0; i < data.length; i++) {
+                        PrintIds += data[i].hmainid + "-" + data[i].HEntryID + ","
+                    }
+                    PrintIds = PrintIds.substring(0, PrintIds.length - 1);
+                    layer.open({
+                        type: 2
+                        , area: ['50%', '50%']
+                        , title: '鎵撳嵃妯$増閫夋嫨'
+                        , shade: 0.6 //閬僵閫忔槑搴�
+                        , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+                        , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + PrintIds + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HIcmoBill', 'yes']
+                        , resize: false
+                    })
+                }
+                else {
+                    layer.msg('璇烽�夋嫨鑷冲皯涓�琛屾暟鎹墦鍗帮紒');
+                }
+            }
+
+            //闅愯棌鍒楄缃�
+            function get_HideColumn() {
+                var colName = "";
+                var contentUrl = "";
+                for (var i = 1; i < option.cols[0].length - 1; i++) {
+                    colName += option.cols[0][i]["title"] + ",";
+                }
+                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"] },
+                    success: function (data1) {
+                        if (data1.data.length != 0) {
+
+
+                            var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
+                            var titleData = ["hmainid", "HEntryID", "浣滃簾浜�", "浣滃簾鏃ユ湡", "閿�鍞鍗曟棩鏈�", "璁㈠崟璺熻釜鍙�", "HDeptID", "HMaterID", "hunitid", "hempid", "涓氬姟鍛樹唬鐮�", "涓氬姟鍛�", "hcusid", "瀹㈡埛浠g爜", "瀹㈡埛", "HCenterID", "宸ヤ綔涓績浠g爜", "宸ヤ綔涓績", "hbomid", "BOM鍗曠紪鐮�", "HRoutingInterID", "宸ヨ壓璺嚎浠g爜", "宸ヨ壓璺嚎", "hsubid", "婧愬崟鍗曞彿", "婧愬崟涓诲唴鐮�", "婧愬崟瀛愬唴鐮�", "琛屽叧闂汉", "鍏抽棴绫诲瀷", "鍗曟嵁绫诲瀷", "璁″垝璺熻釜鍙�"];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
+
+                            dataCol = data1.data[0].HGridString.split(',');
+
+                            for (var i = 0; i < option.cols[0].length - 2; i++) {
+                                if (dataCol[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);
+                        }
+                    }, error: function () {
+                        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                    }
+                })
+            }
+
+            //瀹℃牳
+            function set_CheckBill() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+
+                if (data.length == 1) {
+                    layer.confirm("纭瑕佸鏍稿悧?", function (index) {
+                        var wait = layer.load();
+                        var HInterID = data[0].hmainid;
+                        $.ajax({
+                            url: GetWEBURL() + '/Sc_ICMOBill/CheckSc_ICMOReportBill',
+                            type: "GET",
+                            data: { "HInterID": HInterID, "Type": 1, "user": sessionStorage["HUserName"] },
+                            success: function (result) {
+                                if (result.count == 1) {
+                                    get_FastQuery();
+                                    layer.msg(result.Message, { icon: 1 });
+                                    layer.close(wait);
+                                } else {
+                                    layer.alert(result.code + result.Message, { icon: 5 });
+                                    layer.close(wait);
+                                }
+                            }, error: function () {
+                                layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                                layer.close(wait);
+                            }
+                        });
+                    })
+                } else {
+                    layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�!");
+                }
+            }
+
+            //鍙嶅鏍�
+            function set_AbandonCheck() {
+                var checkStatus = table.checkStatus('mainTable')
+                    , data = checkStatus.data;
+
+                if (data.length == 1) {
+                    layer.confirm("纭瑕佸弽瀹℃牳鍚�?", function (index) {
+                        var wait = layer.load();
+                        var HInterID = data[0].hmainid;
+                        $.ajax({
+                            url: GetWEBURL() + '/Sc_ICMOBill/CheckSc_ICMOReportBill',
+                            type: "GET",
+                            data: { "HInterID": HInterID, "Type": 2, "user": sessionStorage["HUserName"] },
+                            success: function (result) {
+                                if (result.count == 1) {
+                                    get_FastQuery();
+                                    layer.msg(result.Message, { icon: 1 });
+                                    layer.close(wait);
+                                } else {
+                                    layer.alert(result.code + result.Message, { icon: 5 });
+                                    layer.close(wait);
+                                }
+                            }, error: function () {
+                                layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                                layer.close(wait);
+                            }
+                        });
+                    })
+                } else {
+                    layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�!");
+                }
+            }
+
+            //鍒楁槑鏄剧ず涓嬫媺妗�
+            function ColFilter() {
+                var Organization = '<option  value="0" selected="selected" ></option>';
+                for (var i = 1; i < option.cols[0].length; i++) {
+                    if (option.cols[0][i].hide != true) {
+                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
+                    }
+                }
+                $("#ColName").empty();
+                $("#ColName").append(Organization);
+                form.render('select');
+            }
+
+
+            //鑾峰彇鍙傛暟
+            function getUrlVars() {
+                var vars = [], hash;
+                var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
+                for (var i = 0; i < hashes.length; i++) {
+                    hash = hashes[i].split('=');
+                    vars.push(hash[0]);
+                    vars[hash[0]] = hash[1];
+                }
+                return vars;
             }
             //#endregion
 
             //浠ヤ笂鏄痩ayui妯″潡
         });
-
-
-
 
     </script>
 

--
Gitblit v1.9.1