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