From c4c531fac0ff55969628d4497135252c7c1d0905 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期四, 15 五月 2025 14:49:16 +0800 Subject: [PATCH] 三升排产导入功能 --- WebTM/WebTM.csproj.user | 2 WebTM/views/生产管理/三升排产/JIT_DayPlanPlatForm.html | 4 WebTM/views/生产管理/三升排产/JIT_DayPlanPlatFormImport_SS_Sec.html | 397 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ WebTM/views/生产管理/三升排产/JIT_DayPlanPlatFormImport_SS.html | 2 WebTM/WebTM.csproj | 1 5 files changed, 402 insertions(+), 4 deletions(-) diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj index ce19f89..9f4e49f 100644 --- a/WebTM/WebTM.csproj +++ b/WebTM/WebTM.csproj @@ -578,6 +578,7 @@ <Content Include="views\妯℃不鍏风鐞哱妯℃不鍏风鐞哱Sc_MouldMaintainRuleBill_Excel.html" /> <Content Include="views\妯℃不鍏风鐞哱妯℃不鍏风鐞哱Sc_MouldMaintainRuleBillList_PDA.html" /> <Content Include="views\鐢熶骇绠$悊\涓夊崌鎺掍骇\JIT_DayPlanPlatForm.html" /> + <Content Include="views\鐢熶骇绠$悊\涓夊崌鎺掍骇\JIT_DayPlanPlatFormImport_SS_Sec.html" /> <Content Include="views\鐢熶骇绠$悊\涓夊崌鎺掍骇\JIT_DayPlanPlatFormImport_SS.html" /> <Content Include="views\鐢熶骇绠$悊\瀹濆伐鎺掍骇\Cg_PODemandPlanConfigBillReportForLack.html" /> <Content Include="views\鐢熶骇绠$悊\瀹濆伐鎺掍骇\Gy_RoutingBillReportForLack.html" /> diff --git a/WebTM/WebTM.csproj.user b/WebTM/WebTM.csproj.user index 980f848..e33a50f 100644 --- a/WebTM/WebTM.csproj.user +++ b/WebTM/WebTM.csproj.user @@ -3,7 +3,7 @@ <PropertyGroup> <NameOfLastUsedPublishProfile>D:\鏅轰簯杩堟�漒MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>D:\宸ヤ綔浠g爜\鏅轰簯杩堟�漒MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\LAYUI.pubxml</NameOfLastUsedPublishProfile> - <ProjectView>ProjectFiles</ProjectView> + <ProjectView>ShowAllFiles</ProjectView> <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> <UseIISExpress>true</UseIISExpress> <Use64BitIISExpress /> diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" index 82310a5..f48231c 100644 --- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" +++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" @@ -2072,7 +2072,7 @@ , area: ['100%', '100%'] , title: 'Excel瀵煎叆' , shift: 0//寮瑰嚭鍔ㄧ敾 - , content: '../鐢熶骇璁″垝骞冲彴/JIT_DayPlanPlatFormImport.html?OperationType=1' + , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS_Sec.html?OperationType=1' , end: function () { //鍒锋柊椤甸潰, location.reload(); @@ -2085,7 +2085,7 @@ type: 2 , skin: 'layui-layer-rim' //鍔犱笂杈规 , area: ['100%', '100%'] - , title: 'Excel瀵煎叆' + , title: '浜ゆ湡瀵煎叆' , shift: 0//寮瑰嚭鍔ㄧ敾 , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS.html?OperationType=1' , end: function () { diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html" index 10a2573..8d22de9 100644 --- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html" +++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS.html" @@ -2,7 +2,7 @@ <html> <head> <meta charset="utf-8" /> - <title>鐢熶骇鏃ヨ鍒掑鍏�</title> + <title>鐢熶骇鏃ヨ鍒掍氦鏈熷鍏�</title> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS_Sec.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS_Sec.html" new file mode 100644 index 0000000..c41b279 --- /dev/null +++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatFormImport_SS_Sec.html" @@ -0,0 +1,397 @@ +锘�<!DOCTYPE html> +<html> +<head> + <meta charset="utf-8" /> + <title>鐢熶骇鏃ヨ鍒掑鍏�</title> + <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> + <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> + <script src="../../../layuiadmin/layui/layui.js"></script> + <script src="../../../layuiadmin/Scripts/json2.js"></script> + <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> + <script src="../../../layuiadmin/Scripts/webConfig.js"></script> + <script src="../../../layuiadmin/PubCustom.js"></script> +</head> +<body> + <div class="layui-fluid" style="padding: 0;"> + <div class="layui-card" style="padding: 2px;background-color: #efefef;"> + <div class="layui-card-body" style="padding: 1px;"> + <form class="layui-form" action="" lay-filter="formData" style="background-color:white;"> + <div style="padding: 10px; "> + <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">瀵煎叆鏁版嵁</button> + <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">閫�鍑�</button> + <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">鏂囦欢涓婁紶</button> + </div> + <div class="layui-tab" lay-filter="tab-POStockInBill"> + <div class="layui-tab-content"> + <!--鍩烘湰淇℃伅--> + <div class="layui-tab-item layui-show"> + <div class="layui-form-item" style="padding-top: 10px;"> + <div class="layui-row"> + <div class="layui-inline"> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">鍗曟嵁鏃ユ湡</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 75px;" disabled> + </div> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">璁㈠崟绫诲瀷</label> + <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> + <select name="HOrderType" id="HOrderType" lay-verify="HOrderType"> + <option value="鐢熶骇璁㈠崟">鐢熶骇璁㈠崟</option> + <option value="濮斿璁㈠崟">濮斿璁㈠崟</option> + </select> + </div> + </div> + <div class="layui-inline"> + <div class="layui-inline"> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="hidden" name="HPRDORGID" id="HPRDORGID" lay-verify="HPRDORGID"> + </div> + </div> + </div> + </div> + </div> + </div> + </div> + </div> + <table class="" id="mainTable" lay-filter="mainTable"></table> + </form> + </div> + </div> + </div> +</body> +</html> +<script type="text/html" id="barDemo"> + <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">鍒犻櫎</a> +</script> +<script> + + layui.config({ + base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� + }).extend({ + index: 'lib/index' //涓诲叆鍙fā鍧� + }).use(['index', 'form', 'laydate', 'table', 'element', 'upload'], function () { + + //#region 鍏叡鍙橀噺 + + var $ = layui.$ + , admin = layui.admin + , layer = layui.layer + , table = layui.table + , form = layui.form + , laydate = layui.laydate + , excel = layui.excel + , upload = layui.upload + , element = layui.element; + + var option = []; + //#endregion + + //#region 杩涘叆椤甸潰鍗冲姞杞� + + var params = getUrlVars(); + var OperationType = params[params[0]]; //浠庡弬鏁颁腑鑾峰彇 鏁版嵁绫诲瀷 娣诲姞 淇濆瓨 + + //鍒濆鍖栫晫闈� + set_ClearBill(); + + //#endregion + + //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛� + + //琛屽唴浜嬩欢 + table.on('tool(mainTable)', function (obj) { + set_GridDelete(obj); //琛屽唴鍒犻櫎 + set_GridCellCheck(obj);//琛屽唴蹇嵎閿瓫閫� + //#region 淇敼鏃堕棿 + var data = obj.data; + //鏃ヨ鍒掔敓浜ф棩鏈� + if (obj.event == 'HPlanEndDate') { + var field = $(this).data('field'); + laydate.render({ + elem: this.firstChild + , show: true //鐩存帴鏄剧ず + , closeStop: this + , done: function (nowDate) { + //鏃堕棿閫夋嫨瀹屾垚锛岃鏁版嵁鏇存柊 + data[field] = nowDate; + obj.update(data); + } + }); + } + //#endregion + + }); + + //鏂囦欢涓婁紶 + upload.render({ + elem: '#UpLoad', + url: GetWEBURL() + '/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_SS_Sec', + contentType: 'application/json', + exts: 'xls|xlsx', //鍏佽涓婁紶鐨勭被鍨� + before: function (data) { + loadIndex = layer.load(2); + }, + done: function (data1) { + if (data1.count == 1) { + option.data = data1.data; + table.render(option); + layer.close(loadIndex); + } else { + layer.close(loadIndex); + layer.alert(data1.code + data1.Message, { icon: 5 }); + } + }, + error: function (err) { + debugger + layer.alert('瀵煎叆鍑虹幇寮傚父', { icon: 2 }); + } + }); + + //閫�鍑� + form.on('submit(Cancel)', function () { + if (OperationType == 1) { + Pub_Close(1); + } + else { + Pub_Close(2); + } + }) + + //瀵煎叆 淇濆瓨鏁版嵁 + form.on('submit(btnSave)', function (data) { + if (table.cache["mainTable"] != null) { + set_AddNew(data); + } + else { + layer.msg("鏃犳暟鎹�,璇峰厛瀵煎叆鏁版嵁!"); + } + }) + + + //#endregion + + //#region 姝ら〉闈㈡墍鏈夌殑鏂规硶 + + //#region 鍒濆鍖栫晫闈� + function set_ClearBill() { + //鍒濆鍖栨椂闂� + $("#HDate").val(Format(new Date(), "yyyy-MM-dd")); + //鍒濆鍖栬〃鏍� + set_InitGrid(); + } + + //#endregion + + //鍒濆鍖栬〃鏍� + function set_InitGrid() { + + var myDate = new Date(); + var yyyy = myDate.getFullYear(); + var MM = myDate.getMonth() + 1; + var dd = myDate.getDate(); + var SumMonth = 31; //鍔ㄦ�佷袱鏈堜箣宸� new Date(yyyy, MM, 0).getDate() + var columns = []; + var HBEGINDATE = new Date(new Date($("#HDate").val())).getDate(); //鑾峰彇寮�濮嬫棩鏈熷ぉ鏁� + + columns.push({ type: 'checkbox', fixed: 'left' }); + columns.push({ field: 'HMaterID', title: 'HMaterID', width: 150, hide: true }); + columns.push({ field: 'hmainid', title: 'hmainid', width: 150, hide: true }); + columns.push({ field: 'ICMOBillHInterID', title: 'ICMOBillHInterID', width: 150, hide: true }); + columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', width: 150, hide: true }); + columns.push({ field: '瀹㈡埛璁㈠崟鍙�', title: '瀹㈡埛璁㈠崟鍙�', width: 200, edit: true }); + columns.push({ field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', width: 150, edit: true }); + columns.push({ field: '灏忔椂浜ц兘', title: '灏忔椂浜ц兘', edit: 'text' }); + columns.push({ field: '浼樺厛绾�', title: '浼樺厛绾�' }); + columns.push({ field: 'HSourceID', title: 'HSourceID', hide: true }); + columns.push({ field: '鐢熶骇璧勬簮缂栫爜', title: '鐢熶骇璧勬簮', edit: 'text', event: "HSourceID" }); + columns.push({ field: '璁″垝缁撴潫鏃ユ湡', title: '璁″垝缁撴潫鏃ユ湡', width: 150, event: "HPlanEndDate", edit: true }); + + var k = 0;//鏀堕泦寰幆娆℃暟 + var Days = 45; + for (var j = 0; j <= (Days - k); j++) { + columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true }) + //璺ㄥ勾鐨勮瘽 浼氫粠涓�鏈堜竴鍙峰紑濮� + if (MM == 12 && (HBEGINDATE + j) == 31) { + yyyy += 1; + MM = 1; + SumMonth = new Date(yyyy, MM, 0).getDate(); + HBEGINDATE = 0; + k += j; + j = 0; + } else if ((HBEGINDATE + j) == SumMonth) { //璺ㄦ湀 鏈堟暟鍔犱竴 澶╂暟浠庝竴寮�濮� + HBEGINDATE = 0; + MM += 1; + SumMonth = new Date(yyyy, MM, 0).getDate(); + k += j; + j = 0; + } + } + + //for (var i = 0; i <= (SumMonth - dd); i++) { + // columns.push({ field: Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (dd + i), 'MM.dd'), edit: 'text', width:80 }) + //} + //for (var i = 1; i <= dd; i++) { + // columns.push({ field: Format(yyyy + '/' + (MM + 1) + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM + 1) + '/' + i, 'MM.dd'), edit: 'text', width: 80 }) + //} + columns.push({ fixed: 'right', title: '鎿嶄綔', toolbar: '#barDemo' }); + + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , height: 'full-190' + , page: true + , cellMinWidth: 90 + , limit: 50 + , limits: [50, 500, 5000, 20000] + , loading: false + , cols: [columns] + }; + table.render(option); + } + + //瀵煎叆(淇濆瓨) + function set_AddNew(data) { + + var num = []; + + //鍒ゆ柇鏄惁鏈夊鍏ユ潈闄愶紝濡傛灉鏈夊垯灏嗘�昏杞﹂棿涔嬪墠鐨勬棩璁″垝宸ュ崟浣滃簾 + if (!set_ModCheck("Sc_WorkBillSortBill_Edit")) { + layer.msg("瀵煎叆澶辫触锛佹棤瀵煎叆鏉冮檺锛�", { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" }); + return; + } + + var HDataSub = []; + var index = layer.load(); + layer.msg("寮�濮嬪鍏�"); + //JIT瀵煎叆璁″垝锛屾瘡娆″鍏�100琛屾暟鎹�,鍙慨鏀筰鐨勮嚜澧炲�煎喅瀹氭瘡娆″惊鐜鍏ョ殑琛屾暟 + for (var i = 0; i < option.data.length; i += 100) { + HDataSub = option.data.slice(i, i + 100) + + data.field.HPRDORGID = sessionStorage["OrganizationID"];//缁勭粐 + var sMainStr = JSON.stringify(data.field); + var sSubStr = JSON.stringify(HDataSub); + var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"]; + + $.ajax({ + type: "POST", + url: GetWEBURL() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave_SS_Sec", + async: false, + data: { "sMainSub": sMainSub }, + dataType: "json", + success: function (data) { + if (data.count == 1) { + layer.close(index); + $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true); + layer.msg("鎻愪氦鎴愬姛"); + } + else { + layer.close(index); + layer.msg(data.Message, { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" }); + } + }, + error: function (err) { + layer.close(index); + layer.msg("閿欒:" + err, { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" }); + } + }); + } + layer.close(index); + } + + //琛屽唴鍒犻櫎 + function set_GridDelete(obj) { + var rowIndex = $(obj.tr).attr("data-index"); + if (obj.event === 'del') { + layer.confirm('鐪熺殑鍒犻櫎琛屽悧锛�', function (index) { + obj.del(); + table.cache["mainTable"].splice(rowIndex, 1); //鈶″交搴曠Щ闄ゅ厓绱狅紝浠庣紦瀛橀噷绉婚櫎杩欎竴琛� + option.data = table.cache["mainTable"];//灏嗘暟鎹粦瀹氬埌data涓� + table.reload(option); + layer.close(index); + }); + } + } + + //琛屽唴鍒犻櫎蹇嵎閿� + function set_GridCellCheck(obj) { + $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) { + if (event.key == "F7") { + //鐢熶骇璧勬簮 + if (obj.event == "HSourceID") { + layer.open({ + type: 2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "鐢熶骇璧勬簮鍒楄〃" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["90%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ["../../鍩虹璧勬枡/鐢熶骇鍩虹璧勬枡/Gy_Source.html", "yes"] + , btn: ["纭畾", "鍙栨秷"] + , btn1: function (index, laero) { + //鎸夐挳涓� 鐨勫洖璋� + var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹� + + if (checkStatus.data.length != 1) { + return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�"); + } + //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� + obj.update({ + "HSourceID": checkStatus.data[0].HItemID + , "鐢熶骇璧勬簮缂栫爜": checkStatus.data[0].鐢熶骇璧勬簮浠g爜 + }) + layer.close(index);//鍏抽棴寮圭獥 + } + }) + } + obj.event = ""; + return false; + } + + }) + } + + //鑾峰彇鍙傛暟 + 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; + } + + //#region 鏉冮檺鍒ゅ畾 + function set_ModCheck(ModRightNameCheck) { + var Permission = false; + $.ajax({ + type: "GET", + url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + async: false, + data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, + success: function (result) { + if (result.count == 1) { + Permission = true; + } else { + //layer.alert("褰撳墠妯″潡娌℃湁鏌ヨ鏉冮檺!", { icon: 5 }); + } + }, error: function (e) { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + return Permission; + } + //#endregion + + //#endregion + + }); + +</script> \ No newline at end of file -- Gitblit v1.9.1