From 7c92d0185e478029308fe3e22e74ee331d57464a Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 12 三月 2025 10:46:09 +0800 Subject: [PATCH] tableSelect优化,欠料运算优化 --- WebTM/layuiadmin/modules/tableSelect.js | 4 WebTM/views/采购管理/采购订单/Cg_POOrderBillEdit.html | 675 +++++++++++++++++++++++++++++++++++--------------------- WebTM/views/生产管理/欠料运算/JIT_MaterialLevelShorAnalysisReport.html | 14 WebTM/views/计划管理/工艺路线/Gy_RoutingBillWorkQty.html | 4 4 files changed, 436 insertions(+), 261 deletions(-) diff --git a/WebTM/layuiadmin/modules/tableSelect.js b/WebTM/layuiadmin/modules/tableSelect.js index 0c64501..17c16bb 100644 --- a/WebTM/layuiadmin/modules/tableSelect.js +++ b/WebTM/layuiadmin/modules/tableSelect.js @@ -23,9 +23,9 @@ opt.searchKey = opt.searchKey || 'keyword';//鍙涓敤锛屽垎鍓� opt.table.page = opt.table.page || false; opt.table.height = opt.table.height || 290; - elem.off('click').on('click', function(e) { + elem.off('keyup').on('keyup', function(e) { e.stopPropagation(); - if($('div.tableSelect').length >= 1){ + if ($('div.tableSelect').length >= 1 || elem.val().length<=2) { return false; } diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html" index 89da67e..f5b4bd0 100644 --- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html" +++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\254\240\346\226\231\350\277\220\347\256\227/JIT_MaterialLevelShorAnalysisReport.html" @@ -251,13 +251,17 @@ function set_InitGrid() { var columns = []; - columns.push({ type: 'checkbox', fixed: 'left', sort: true}); + columns.push({ type: 'checkbox', fixed: 'left', sort: true }); + columns.push({ field: '闇�姹傝溅闂碔D', title: '闇�姹傝溅闂碔D', sort: true, filter: true }); + columns.push({ field: '闇�姹傝溅闂寸紪鐮�', title: '闇�姹傝溅闂寸紪鐮�', sort: true, filter: true }); + columns.push({ field: '闇�姹傝溅闂村悕绉�', title: '闇�姹傝溅闂村悕绉�', sort: true, filter: true }); columns.push({ field: '鐗╂枡ID', title: '鐗╂枡ID', sort: true, filter: true }); columns.push({ field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', sort: true, filter: true }); columns.push({ field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', sort: true, filter: true }); - columns.push({ field: '鐢熶骇杞﹂棿ID', title: '鐢熶骇杞﹂棿ID', sort: true, filter: true }); - columns.push({ field: '鐢熶骇杞﹂棿缂栫爜', title: '鐢熶骇杞﹂棿缂栫爜', sort: true, filter: true }); - columns.push({ field: '鐢熶骇杞﹂棿鍚嶇О', title: '鐢熶骇杞﹂棿鍚嶇О', sort: true, filter: true }); + columns.push({ field: '鐗╂枡灞炴��', title: '鐗╂枡灞炴��', sort: true, filter: true }); + columns.push({ field: '渚涜揣杞﹂棿ID', title: '渚涜揣杞﹂棿ID', sort: true, filter: true }); + columns.push({ field: '渚涜揣杞﹂棿缂栫爜', title: '渚涜揣杞﹂棿缂栫爜', sort: true, filter: true }); + columns.push({ field: '渚涜揣杞﹂棿鍚嶇О', title: '渚涜揣杞﹂棿鍚嶇О', sort: true, filter: true }); columns.push({ field: '鏄惁鍖归厤鍒拌鍗�', title: '鏄惁鍖归厤鍒拌鍗�', sort: true, filter: true, templet: function (d) { return d.鏄惁鍖归厤鍒拌鍗� ? '鍚�' : '鏄�'; } }); //columns.push({ field: 'HPOOrderBillRemark', title: '鎽樿' }); //columns.push({ field: 'HPOOrderBillNote', title: '澶囨敞' }); @@ -404,7 +408,7 @@ sWhere += " and T1.HStockORGID= " + HORGID+" "; } if (HWorkShopID != 0) { - sWhere += " and T1.HWorkShopID= " + HWorkShopID + " "; + sWhere += " and T1.HSupplyWorkShopID= " + HWorkShopID + " "; } //if (HBEGINDATE != null && HENDDATE != null) { // sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' "; diff --git "a/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillWorkQty.html" "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillWorkQty.html" index 12d705d..7544f12 100644 --- "a/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillWorkQty.html" +++ "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/\345\267\245\350\211\272\350\267\257\347\272\277/Gy_RoutingBillWorkQty.html" @@ -119,7 +119,7 @@ var option = []; var rowdata = [{ "HInterID": HBillInterID, "HEntryID": HBillEntryID, "HSourceID": 0, "HSourceNumber": "", "HSourceName": "" - , "HWorkQty_Source": "", "HEntryStdEmpQty": "", "HEntryStdEmpAvg": "", "HSortNum": "", "HRemark": "" + , "HWorkQty_Source": "0", "HEntryStdEmpQty": "0", "HEntryStdEmpAvg": "0", "HSortNum": "0", "HRemark": "" }]; //#endregion @@ -149,7 +149,7 @@ //鏂板琛岃〃鏍兼暟鎹� var NewRow = { "HInterID": HBillInterID, "HEntryID": HBillEntryID, "HSourceID": 0, "HSourceNumber": "", "HSourceName": "" - , "HWorkQty_Source": "", "HEntryStdEmpQty": "", "HEntryStdEmpAvg": "", "HSortNum": "", "HRemark": "" + , "HWorkQty_Source": 0, "HEntryStdEmpQty": 0, "HEntryStdEmpAvg": 0, "HSortNum": 0, "HRemark": "" }; switch (obj.event) { diff --git "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillEdit.html" "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillEdit.html" index 9788e0c..0335409 100644 --- "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillEdit.html" +++ "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillEdit.html" @@ -1013,48 +1013,48 @@ function set_InitGrid() { //渚涘簲鍟嗚緭鍏ユ - tableSelect.render({ - elem: '#HSupName',//杈撳叆妗哾om閫夋嫨 - searchKey: '渚涘簲鍟嗗悕绉�,HItemID',//鏌ヨ鐨勫垪鍚� - sWhere: '',//table鎼滅储sWhere鏉′欢 //榛樿绛涢�夐」 - ajaxSelect: function (sWhere) { - var data = ''; - $.ajax({ - url: GetWEBURL() + '/Gy_Supplier/list', - type: "GET", - data: { "sWhere": sWhere, "user": '缈佹稕娑�', "Organization": '娴欐睙鏅轰簯杩堟��' }, - async: false, - success: function (data1) { - if (data1.count == 1) { - data = data1.data - } - }, - error: function () { - layer.alert('鑾峰彇鍒楄〃澶辫触锛�', { icon: 15, title: '閫氫俊閿欒' }); - } - }); - return data; - },//璁剧疆鍓嶇鍒嗛〉鏃跺彲浠ヨ缃殑 - table: { - //url: GetWEBURL() + 'Gy_Supplier/page', - //where: { user: '缈佹稕娑�', Organization: '娴欐睙鏅轰簯杩堟��' }, - cols: [[ - { type: 'radio', fixed: 'left' },//闇�瑕佸姞杩欎釜fixed灞炴�т笉鐒剁偣鍑籧heckbox浼氳Е鍙戣鐐瑰嚮瀵艰嚧鏃犳硶姝g‘鐐瑰嚮 - { field: 'HItemID', title: 'HItemID' }, - { field: '渚涘簲鍟嗗悕绉�', title: '渚涘簲鍟嗗悕绉�' }, - ]], - page: true, - limit: 5, - limits:[5] - }, - done: function (elem, data) { - if (data != []) { - $("#HSupName").val(data.data[0]['渚涘簲鍟嗗悕绉�']); - $("#HSupID").val(data.data[0]['HItemID']); - } + //tableSelect.render({ + // elem: '#HSupName',//杈撳叆妗哾om閫夋嫨 + // searchKey: '渚涘簲鍟嗗悕绉�,HItemID',//鏌ヨ鐨勫垪鍚� + // sWhere: '',//table鎼滅储sWhere鏉′欢 //榛樿绛涢�夐」 + // ajaxSelect: function (sWhere) { + // var data = ''; + // $.ajax({ + // url: GetWEBURL() + '/Gy_Supplier/list', + // type: "GET", + // data: { "sWhere": sWhere, "user": '缈佹稕娑�', "Organization": '娴欐睙鏅轰簯杩堟��' }, + // async: false, + // success: function (data1) { + // if (data1.count == 1) { + // data = data1.data + // } + // }, + // error: function () { + // layer.alert('鑾峰彇鍒楄〃澶辫触锛�', { icon: 15, title: '閫氫俊閿欒' }); + // } + // }); + // return data; + // },//璁剧疆鍓嶇鍒嗛〉鏃跺彲浠ヨ缃殑 + // table: { + // //url: GetWEBURL() + 'Gy_Supplier/page', + // //where: { user: '缈佹稕娑�', Organization: '娴欐睙鏅轰簯杩堟��' }, + // cols: [[ + // { type: 'radio', fixed: 'left' },//闇�瑕佸姞杩欎釜fixed灞炴�т笉鐒剁偣鍑籧heckbox浼氳Е鍙戣鐐瑰嚮瀵艰嚧鏃犳硶姝g‘鐐瑰嚮 + // { field: 'HItemID', title: 'HItemID' }, + // { field: '渚涘簲鍟嗗悕绉�', title: '渚涘簲鍟嗗悕绉�' }, + // ]], + // page: true, + // limit: 5, + // limits:[5] + // }, + // done: function (elem, data) { + // if (data != []) { + // $("#HSupName").val(data.data[0]['渚涘簲鍟嗗悕绉�']); + // $("#HSupID").val(data.data[0]['HItemID']); + // } - } - }) + // } + //}) option = { elem: '#mainTable' // 浣跨敤#mainTable浣滀负琛ㄦ牸鐨凞OM鍏冪礌 , toolbar: '#toolbarDemo' //鍔犺浇tolbardemo杩欎釜琛ㄦ牸 @@ -1376,234 +1376,393 @@ function set_GridCellCheck(obj) { //瀹氫箟浜嗕竴涓悕涓簊et_GridCellCheck鐨勫嚱鏁帮紝瀹冩帴鍙椾竴涓弬鏁皁bj //浣跨敤$(document).off('keydown', ".layui-table-edit")鏉ョЩ闄わ紙濡傛灉瀛樺湪鐨勮瘽锛変箣鍓嶇粦瀹氬埌鏂囨。涓墍鏈�.layui-table-edit绫诲厓绱犱笂鐨刱eydown浜嬩欢鐩戝惉鍣� $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) { + try { + if (event.key == "F7") {//妫�鏌ヨЕ鍙戜簨浠剁殑閿洏鎸夐敭鏄惁鏄疐7閿� + //鐗╂枡 + if (obj.event == "HMaterID") {//鍒ゆ柇浼犲叆鐨刼bj瀵硅薄鐨別vent灞炴�ф槸鍚︾瓑浜庡瓧绗︿覆"HMaterID" + var HOrgID = $("#HOrgID").val(); //鑾峰彇id="HOrgID"鐨勫厓绱犱腑鑾峰彇鍏跺�硷紝骞跺皢璇ュ�煎瓨鍌ㄥ湪鍙橀噺HOrgID涓� + layer.open({ //鎵撳紑灞� + type: 2 // //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "鐗╂枡鍒楄〃" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["90%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Material.html?openType=2&HOrgID=' + HOrgID, 'yes'] //椤甸潰鍔犺浇 + , btn: ["纭畾", "鍙栨秷"] //灞炴�у畾涔変簡寮瑰嚭灞備笂鐨勬寜閽暟鈥滅‘瀹氣�濆拰鈥滃彇娑� + , btn1: function (index, laero) { //褰撶偣鍑烩�滅‘瀹氣�濇寜閽椂浼氳璋冪敤 + //鎸夐挳涓� 鐨勫洖璋� + var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹� + OptionData = checkStatus.data[0]; //鎶婇�変腑鏁版嵁鐨勭涓�鏉¤祴鍊肩粰OptionData鍙橀噺 + var TaxRate = getHTaxRateByHSupID(); + //閫変腑澶氳鏃� + if (checkStatus.data.length > 1) { + var rowIndex = $(obj.tr).attr("data-index") * 1; //attr("data-index")鐢ㄤ簬鑾峰彇璇r鍏冪礌涓奷ata-index灞炴�х殑鍊�*1杞崲绫诲瀷鐒跺悗璧嬪�肩粰rowIndex + for (var i = 0; i < checkStatus.data.length; i++) { //鍒ゆ柇閫変腑鐨勬暟鎹殑闀垮害 鐢ㄤ簬閬嶅巻checkStatus.data鏁扮粍涓殑姣忎釜鍏冪礌 + if (rowIndex + i >= option.data.length) { //鍒ゆ柇rowIndex + i鐨勭储寮曡秴鍑轰簡option.data鏁扮粍鐨勯暱搴︼紝璇存槑option.data鏁扮粍闇�瑕佹墿灞曚互鍖呭惈鏇村琛� + var NewRow = { + "HMaterID": 0, "鐗╂枡浠g爜": "", "鐗╂枡鍚嶇О": "", "瑙勬牸鍨嬪彿": "", "HUnitID": 0, "璁¢噺鍗曚綅": "", "HWHID": 0, "HWHName": "", "HQty": 1, "HRemark": "" + , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "1", "HRelTaxPrice": "0", "HTaxRate": "0", "HTaxMoney": "0", "HlineTotal": "0", "HlineTotalBB": "0", "HDate": Format(new Date, "yyyy- MM - dd") + }; // 鍒涘缓涓�涓柊鐨勫寘鍚暟缁� 鍏跺垵濮嬪�间负绌烘垨鑰�0 鎴栬�呮槸鏃堕棿鏍煎紡 - if (event.key == "F7") {//妫�鏌ヨЕ鍙戜簨浠剁殑閿洏鎸夐敭鏄惁鏄疐7閿� - //鐗╂枡 - if (obj.event == "HMaterID") {//鍒ゆ柇浼犲叆鐨刼bj瀵硅薄鐨別vent灞炴�ф槸鍚︾瓑浜庡瓧绗︿覆"HMaterID" - var HOrgID = $("#HOrgID").val(); //鑾峰彇id="HOrgID"鐨勫厓绱犱腑鑾峰彇鍏跺�硷紝骞跺皢璇ュ�煎瓨鍌ㄥ湪鍙橀噺HOrgID涓� - layer.open({ //鎵撳紑灞� - type: 2 // //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 - , skin: "layui-layer-rim" //鍔犱笂杈规 - , title: "鐗╂枡鍒楄〃" //鏍囬 - , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 - , shift: 2 //寮瑰嚭鍔ㄧ敾 - , area: ["90%", "90%"] //绐椾綋澶у皬 - , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� - , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Material.html?openType=2&HOrgID=' + HOrgID, 'yes'] //椤甸潰鍔犺浇 - , btn: ["纭畾", "鍙栨秷"] //灞炴�у畾涔変簡寮瑰嚭灞備笂鐨勬寜閽暟鈥滅‘瀹氣�濆拰鈥滃彇娑� - , btn1: function (index, laero) { //褰撶偣鍑烩�滅‘瀹氣�濇寜閽椂浼氳璋冪敤 - //鎸夐挳涓� 鐨勫洖璋� - var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰 - var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹� - OptionData = checkStatus.data[0]; //鎶婇�変腑鏁版嵁鐨勭涓�鏉¤祴鍊肩粰OptionData鍙橀噺 - var TaxRate = getHTaxRateByHSupID(); - //閫変腑澶氳鏃� - if (checkStatus.data.length > 1) { - var rowIndex = $(obj.tr).attr("data-index") * 1; //attr("data-index")鐢ㄤ簬鑾峰彇璇r鍏冪礌涓奷ata-index灞炴�х殑鍊�*1杞崲绫诲瀷鐒跺悗璧嬪�肩粰rowIndex - for (var i = 0; i < checkStatus.data.length; i++) { //鍒ゆ柇閫変腑鐨勬暟鎹殑闀垮害 鐢ㄤ簬閬嶅巻checkStatus.data鏁扮粍涓殑姣忎釜鍏冪礌 - if (rowIndex + i >= option.data.length) { //鍒ゆ柇rowIndex + i鐨勭储寮曡秴鍑轰簡option.data鏁扮粍鐨勯暱搴︼紝璇存槑option.data鏁扮粍闇�瑕佹墿灞曚互鍖呭惈鏇村琛� - var NewRow = { - "HMaterID": 0, "鐗╂枡浠g爜": "", "鐗╂枡鍚嶇О": "", "瑙勬牸鍨嬪彿": "", "HUnitID": 0, "璁¢噺鍗曚綅": "", "HWHID": 0, "HWHName": "", "HQty": 1, "HRemark": "" - , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "1", "HRelTaxPrice": "0", "HTaxRate": "0", "HTaxMoney": "0", "HlineTotal": "0", "HlineTotalBB": "0", "HDate": Format(new Date, "yyyy- MM - dd") - }; // 鍒涘缓涓�涓柊鐨勫寘鍚暟缁� 鍏跺垵濮嬪�间负绌烘垨鑰�0 鎴栬�呮槸鏃堕棿鏍煎紡 + table.cache["mainTable"].push(NewRow); //鍒涘缓鏂扮殑鍖呭惈鏁扮粍 浼犲叆table.cache["mainTable"]鏁扮粍 + option.data = table.cache["mainTable"]; //鎶婁紶鍏� table.cache["mainTable"]鏁扮粍鐨勫�艰祴鍊肩粰option.data 鐨勫睘鎬� - table.cache["mainTable"].push(NewRow); //鍒涘缓鏂扮殑鍖呭惈鏁扮粍 浼犲叆table.cache["mainTable"]鏁扮粍 - option.data = table.cache["mainTable"]; //鎶婁紶鍏� table.cache["mainTable"]鏁扮粍鐨勫�艰祴鍊肩粰option.data 鐨勫睘鎬� - - table.render(option);//娓叉煋鐣岄潰 + table.render(option);//娓叉煋鐣岄潰 + } + var HMaterID = checkStatus.data[i].HItemID; //checkStatus.data鏁扮粍涓殑褰撳墠鍏冪礌锛堢储寮曚负i锛変腑鑾峰彇HItemID灞炴�х殑鍊� 骞惰祴鍊肩粰HMaterID + var resultData = getMaterialByMaterID(HMaterID); //浣跨敤HMaterID浣滀负鍙傛暟鏉ヨ皟鐢╣etMaterialByMaterID鍑芥暟鏉ヨ幏鍙栬鐗╂枡鐨勮缁嗕俊鎭� + option.data[rowIndex + i].HMaterID = resultData.HMaterID; //灏唎ption.data鏁扮粍涓搴旇鐨凥MaterID灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].鐗╂枡浠g爜 = resultData.HMaterNumber; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡浠g爜 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].鐗╂枡鍚嶇О = resultData.HMaterName; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡鍚嶇О 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].瑙勬牸鍨嬪彿 = resultData.HMaterModel; //灏唎ption.data鏁扮粍涓搴旇鐨� 瑙勬牸鍨嬪彿 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].HUnitID = resultData.HUnitID; //灏唎ption.data鏁扮粍涓搴旇鐨� HUnitID 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].璁¢噺鍗曚綅 = resultData.HUnitName; //灏唎ption.data鏁扮粍涓搴旇鐨� 璁¢噺鍗曚綅 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID 鏇存柊璁¢噺鍗曚綅灞炴�� + option.data[rowIndex + i].HQty = 1; //灏嗗搴旇鐨凥Qty灞炴�э紙鍙兘浠h〃鏁伴噺锛夎缃负1銆傝繖琛ㄧず瀵逛簬姣忎釜閫変腑鐨勭墿鏂欙紝鍏堕粯璁ゆ暟閲忚璁剧疆涓�1 + option.data[rowIndex + i].HTaxRate = TaxRate; } - var HMaterID = checkStatus.data[i].HItemID; //checkStatus.data鏁扮粍涓殑褰撳墠鍏冪礌锛堢储寮曚负i锛変腑鑾峰彇HItemID灞炴�х殑鍊� 骞惰祴鍊肩粰HMaterID - var resultData = getMaterialByMaterID(HMaterID); //浣跨敤HMaterID浣滀负鍙傛暟鏉ヨ皟鐢╣etMaterialByMaterID鍑芥暟鏉ヨ幏鍙栬鐗╂枡鐨勮缁嗕俊鎭� - option.data[rowIndex + i].HMaterID = resultData.HMaterID; //灏唎ption.data鏁扮粍涓搴旇鐨凥MaterID灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID - option.data[rowIndex + i].鐗╂枡浠g爜 = resultData.HMaterNumber; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡浠g爜 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID - option.data[rowIndex + i].鐗╂枡鍚嶇О = resultData.HMaterName; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡鍚嶇О 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID - option.data[rowIndex + i].瑙勬牸鍨嬪彿 = resultData.HMaterModel; //灏唎ption.data鏁扮粍涓搴旇鐨� 瑙勬牸鍨嬪彿 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID - option.data[rowIndex + i].HUnitID = resultData.HUnitID; //灏唎ption.data鏁扮粍涓搴旇鐨� HUnitID 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID - option.data[rowIndex + i].璁¢噺鍗曚綅 = resultData.HUnitName; //灏唎ption.data鏁扮粍涓搴旇鐨� 璁¢噺鍗曚綅 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID 鏇存柊璁¢噺鍗曚綅灞炴�� - option.data[rowIndex + i].HQty = 1; //灏嗗搴旇鐨凥Qty灞炴�э紙鍙兘浠h〃鏁伴噺锛夎缃负1銆傝繖琛ㄧず瀵逛簬姣忎釜閫変腑鐨勭墿鏂欙紝鍏堕粯璁ゆ暟閲忚璁剧疆涓�1 - option.data[rowIndex + i].HTaxRate = TaxRate; + table.render(option); //閲嶆柊娓叉煋琛ㄦ牸浠ユ樉绀烘洿鏂板悗鐨勬暟鎹� } - table.render(option); //閲嶆柊娓叉煋琛ㄦ牸浠ユ樉绀烘洿鏂板悗鐨勬暟鎹� + + layer.closeAll(); //鍏抽棴鎵�鏈夐�氳繃layer + //layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� } - - layer.closeAll(); //鍏抽棴鎵�鏈夐�氳繃layer - //layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� - } - , btn2: function (index, layero) { //褰撶偣鍑烩�滃彇娑堚�濇寜閽椂浼氳璋冪敤 - //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 - //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 - }, - end: function () { - //閫氳繃渚涘簲鍟唅d鑾峰彇绋庣巼 - var HSupID = $("#HSupID").val(); - if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") { - var Dec = getDecByMaterID(OptionData.HItemID) //鑾峰彇绮惧害 - var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //鏁伴噺绮惧害 - var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //鍗曚环绮惧害 - var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //閲戦绮惧害 - $.ajax({ - url: GetWEBURL() + "/Gy_Supplier/xg", - //url: "http://localhost:12761/Gy_Supplier/xg", - type: "GET", - data: { - "HInterID": HSupID - }, - success: function (d) { - var HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�) * 0.01; - var HExRate = $("#HExRate").val(); //姹囩巼 - //鏁版嵁鏍¢獙鍚堟牸锛岄噸绠楄褰� - var HQty = obj.data.HQty * 1; //鏁伴噺 - var HPrice = obj.data.HPrice * 1; //鍗曚环 - var HMoney = HQty * HPrice; //閲戦=鏁伴噺*鍗曚环 - var HTaxMoney = Number((HMoney * HTaxRate)); //绋庨=閲戦*绋庣巼 - var HlineTotal = HMoney + HTaxMoney; //浠风◣鍚堣=閲戦+绋庨 - var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //鍚◣鍗曚环=鍗曚环*(1+绋庣巼) - var HDiscountRate = obj.data.HDiscountRate * 1; //鎶樻墸鐜� - var HRelTaxPrice = Number((HTaxPrice * HDiscountRate)); //瀹為檯鍚◣鍗曚环=鍚◣鍗曚环*鎶樻墸鐜� - var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate)); //鏈綅甯佷环绋庡悎璁�=(绋庨+閲戦)*姹囩巼 - //鏁板瓧绮惧害 - HQty = Number(HQty.toFixed(HQtyDec)); - HPrice = Number(HPrice.toFixed(HPriceDec)); - HMoney = Number(HMoney.toFixed(HMoneyDec)); - HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec)); - HlineTotal = Number(HlineTotal.toFixed(HMoneyDec)); - HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec)); - HRelTaxPrice = Number(HRelTaxPrice.toFixed(HPriceDec)); - HlineTotalBB = Number(HlineTotalBB.toFixed(HMoneyDec)); - obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 - "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� - , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 - , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О - , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 - , "HUnitID": OptionData.HUnitID - , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О - , "HTaxRate": HTaxRate * 100 - , HQty: HQty //鏇存柊HQty瀛楁锛孒Qty - , HPrice: HPrice //鏇存柊HPrice瀛楁锛孒Price - , HMoney: HMoney //鏇存柊HMoney瀛楁锛孒Money - , HTaxMoney: HTaxMoney //鏇存柊HTaxMoney瀛楁锛孒TaxMoney - , HlineTotal: HlineTotal //鏇存柊HlineTotal瀛楁锛孒lineTotal - , HTaxPrice, HTaxPrice //鏇存柊HTaxPrice瀛楁锛孒TaxPrice - , HRelTaxPrice: HRelTaxPrice //鏇存柊HRelTaxPrice瀛楁锛屽叾鍊兼潵鑷彉閲廐RelTaxPrice - , HlineTotalBB: HlineTotalBB //鏇存柊HlineTotalBB瀛楁锛屽叾鍊兼潵鑷彉閲廐lineTotalBB - }) - } - }); - } else { - obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 - "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� - , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 - , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О - , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 - , "HUnitID": OptionData.HUnitID + , btn2: function (index, layero) { //褰撶偣鍑烩�滃彇娑堚�濇寜閽椂浼氳璋冪敤 + //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 + //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 + }, + end: function () { + //閫氳繃渚涘簲鍟唅d鑾峰彇绋庣巼 + var HSupID = $("#HSupID").val(); + if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") { + var Dec = getDecByMaterID(OptionData.HItemID) //鑾峰彇绮惧害 + var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //鏁伴噺绮惧害 + var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //鍗曚环绮惧害 + var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //閲戦绮惧害 + $.ajax({ + url: GetWEBURL() + "/Gy_Supplier/xg", + //url: "http://localhost:12761/Gy_Supplier/xg", + type: "GET", + data: { + "HInterID": HSupID + }, + success: function (d) { + if (d.code == 1) { // 濡傛灉鏈嶅姟鍣ㄨ繑鍥炵殑鏁版嵁涓殑`code瀛楁绛変簬1锛岃繖鍙兘琛ㄧず瀹℃牳鎿嶄綔鎴愬姛鎵ц + HTaxRate = 0; + if (typeof (d.data[0].澧炲�肩◣鐜�) == undefined || d.data[0].澧炲�肩◣鐜� == null) { + layer.alert("鍙戠敓閿欒鏁版嵁搴撹〃澧炲�肩◣鐜囧瓧娈垫湁璇�!", { icon: 5 }); + } else { + HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�); + } + var HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�) * 0.01; + var HExRate = $("#HExRate").val(); //姹囩巼 + //鏁版嵁鏍¢獙鍚堟牸锛岄噸绠楄褰� + var HQty = obj.data.HQty * 1; //鏁伴噺 + var HPrice = obj.data.HPrice * 1; //鍗曚环 + var HMoney = HQty * HPrice; //閲戦=鏁伴噺*鍗曚环 + var HTaxMoney = Number((HMoney * HTaxRate)); //绋庨=閲戦*绋庣巼 + var HlineTotal = HMoney + HTaxMoney; //浠风◣鍚堣=閲戦+绋庨 + var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //鍚◣鍗曚环=鍗曚环*(1+绋庣巼) + var HDiscountRate = obj.data.HDiscountRate * 1; //鎶樻墸鐜� + var HRelTaxPrice = Number((HTaxPrice * HDiscountRate)); //瀹為檯鍚◣鍗曚环=鍚◣鍗曚环*鎶樻墸鐜� + var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate)); //鏈綅甯佷环绋庡悎璁�=(绋庨+閲戦)*姹囩巼 + //鏁板瓧绮惧害 + HQty = Number(HQty.toFixed(HQtyDec)); + HPrice = Number(HPrice.toFixed(HPriceDec)); + HMoney = Number(HMoney.toFixed(HMoneyDec)); + HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec)); + HlineTotal = Number(HlineTotal.toFixed(HMoneyDec)); + HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec)); + HRelTaxPrice = Number(HRelTaxPrice.toFixed(HPriceDec)); + HlineTotalBB = Number(HlineTotalBB.toFixed(HMoneyDec)); + obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 + "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� + , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 + , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О + , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 + , "HUnitID": OptionData.HUnitID + , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О + , "HTaxRate": HTaxRate * 100 + , HQty: HQty //鏇存柊HQty瀛楁锛孒Qty + , HPrice: HPrice //鏇存柊HPrice瀛楁锛孒Price + , HMoney: HMoney //鏇存柊HMoney瀛楁锛孒Money + , HTaxMoney: HTaxMoney //鏇存柊HTaxMoney瀛楁锛孒TaxMoney + , HlineTotal: HlineTotal //鏇存柊HlineTotal瀛楁锛孒lineTotal + , HTaxPrice, HTaxPrice //鏇存柊HTaxPrice瀛楁锛孒TaxPrice + , HRelTaxPrice: HRelTaxPrice //鏇存柊HRelTaxPrice瀛楁锛屽叾鍊兼潵鑷彉閲廐RelTaxPrice + , HlineTotalBB: HlineTotalBB //鏇存柊HlineTotalBB瀛楁锛屽叾鍊兼潵鑷彉閲廐lineTotalBB + }) + } + else { + layer.alert(result.Message, { icon: 5, btn: ['閫�鍑�'], time: 100000, offset: 't' }); //result.msg瀵硅薄锛屾彁绀哄脊绐� 绫诲瀷涓�5锛� 鎸夐挳锛屽拰鎸夐挳鐨勫悕绉颁负閫�鍑� 鏃堕棿 涓�100绉掞紝浠ュ強鍋忕Щ閲忥紙`offset: 't' + } + + } + }); + } else { + obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 + "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� + , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 + , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О + , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 + , "HUnitID": OptionData.HUnitID + , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О + }) + } + } + }); + } + //璁¢噺鍗曚綅 + if (obj.event == "HUnitID") { //鍒ゆ柇 obj.event浜嬩欢 鏄惁绛変簬瀛楃涓� 'HUnitID'銆傚鏋滅瓑浜庯紝鍒欐墽琛宨f寰幆 + layer.open({ + type: 2 //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "璁¢噺鍗曚綅鍒楄〃" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["90%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Unit.html', 'yes'] //璁剧疆 iframe 鐨� URL锛孶RL 涓寘鍚簡鏌ヨ鍙傛暟锛屾潵璋冪敤鎵�闇�瑕佺殑鍊� + , 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("璇烽�夋嫨涓�鏉℃暟鎹�"); //鎻愮ず璇烽�変腑涓�鏉� + } + OptionData = checkStatus.data[0]; + //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� + obj.update({ + "HUnitID": checkStatus.data[0].HItemID + , "璁¢噺鍗曚綅": checkStatus.data[0].璁¢噺鍗曚綅鍚嶇О + }) + layer.close(index);//鍏抽棴寮圭獥 + } + , end: function () { + obj.update({ + "HUnitID": OptionData.HItemID , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О }) } - } - }); + }) + } + + //浠撳簱 + if (obj.event == "HWHID") { //鍒ゆ柇obj.event浜嬩欢 鐨勫瓧绗︿覆鏄惁==HWHID + var HOrgName = $('select[name="HOrgID"] option:selected').text(); + layer.open({ //鎵撳紑灞� + type: 2 //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "璁¢噺鍗曚綅鍒楄〃" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["90%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Warehouse.html?type=Warehouse&HOrgName=' + HOrgName, 'yes']//璁剧疆 iframe 鐨� URL锛孶RL 涓寘鍚簡鏌ヨ鍙傛暟锛屾潵璋冪敤鎵�闇�瑕佺殑鍊� + , 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("璇烽�夋嫨涓�鏉℃暟鎹�"); + } + OptionData = checkStatus.data[0]; + //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� + obj.update({ + "HWHID": checkStatus.data[0].HItemID + , "HWHName": checkStatus.data[0].浠撳簱鍚嶇О + }) + layer.close(index);//鍏抽棴寮圭獥 + } + , end: function () { + obj.update({ + "HWHID": OptionData.HItemID + , "HWHName": OptionData.浠撳簱鍚嶇О + }) + } + }) + } + obj.event = ""; //鎶奲oj.event灞炴�� 鍒濆鍖栦负绌� + return false; } - //璁¢噺鍗曚綅 - if (obj.event == "HUnitID") { //鍒ゆ柇 obj.event浜嬩欢 鏄惁绛変簬瀛楃涓� 'HUnitID'銆傚鏋滅瓑浜庯紝鍒欐墽琛宨f寰幆 - layer.open({ - type: 2 //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 - , skin: "layui-layer-rim" //鍔犱笂杈规 - , title: "璁¢噺鍗曚綅鍒楄〃" //鏍囬 - , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 - , shift: 2 //寮瑰嚭鍔ㄧ敾 - , area: ["90%", "90%"] //绐椾綋澶у皬 - , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� - , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Unit.html', 'yes'] //璁剧疆 iframe 鐨� URL锛孶RL 涓寘鍚簡鏌ヨ鍙傛暟锛屾潵璋冪敤鎵�闇�瑕佺殑鍊� - , btn: ["纭畾", "鍙栨秷"] //鑷畾涔夐�夋嫨鎸夐挳 鍏舵寜閽殑鍚嶇О涓� 纭畾锛屽彇娑� - , btn1: function (index, laero) { //鎸夐挳鐩戝惉 璋冪敤鍥炶皟 + // 澶勭悊璧勬簮鐨勪唬鐮� + } catch (error) { + // 澶勭悊寮傚父鐨勪唬鐮� + layer.alert("鍙戠敓閿欒!" + error, { icon: 5 }); + } + }) + + $('.layui-table-box tbody td[data-field="鐗╂枡浠g爜"]').off('dblclick').on('dblclick', function () { + + try { + //鎵嬪姩澶辩劍 + var element = document.getElementById("HBillNo"); + element.focus(); + + var HOrgID = $("#HOrgID").val(); //鑾峰彇id="HOrgID"鐨勫厓绱犱腑鑾峰彇鍏跺�硷紝骞跺皢璇ュ�煎瓨鍌ㄥ湪鍙橀噺HOrgID涓� + layer.open({ //鎵撳紑灞� + type: 2 // //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "鐗╂枡鍒楄〃" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["90%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Material.html?openType=2&HOrgID=' + HOrgID, 'yes'] //椤甸潰鍔犺浇 + , btn: ["纭畾", "鍙栨秷"] //灞炴�у畾涔変簡寮瑰嚭灞備笂鐨勬寜閽暟鈥滅‘瀹氣�濆拰鈥滃彇娑� + , btn1: function (index, laero) { //褰撶偣鍑烩�滅‘瀹氣�濇寜閽椂浼氳璋冪敤 //鎸夐挳涓� 鐨勫洖璋� var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰 var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹� + OptionData = checkStatus.data[0]; //鎶婇�変腑鏁版嵁鐨勭涓�鏉¤祴鍊肩粰OptionData鍙橀噺 + var TaxRate = getHTaxRateByHSupID(); + //閫変腑澶氳鏃� + if (checkStatus.data.length > 1) { + var rowIndex = $(obj.tr).attr("data-index") * 1; //attr("data-index")鐢ㄤ簬鑾峰彇璇r鍏冪礌涓奷ata-index灞炴�х殑鍊�*1杞崲绫诲瀷鐒跺悗璧嬪�肩粰rowIndex + for (var i = 0; i < checkStatus.data.length; i++) { //鍒ゆ柇閫変腑鐨勬暟鎹殑闀垮害 鐢ㄤ簬閬嶅巻checkStatus.data鏁扮粍涓殑姣忎釜鍏冪礌 + if (rowIndex + i >= option.data.length) { //鍒ゆ柇rowIndex + i鐨勭储寮曡秴鍑轰簡option.data鏁扮粍鐨勯暱搴︼紝璇存槑option.data鏁扮粍闇�瑕佹墿灞曚互鍖呭惈鏇村琛� + var NewRow = { + "HMaterID": 0, "鐗╂枡浠g爜": "", "鐗╂枡鍚嶇О": "", "瑙勬牸鍨嬪彿": "", "HUnitID": 0, "璁¢噺鍗曚綅": "", "HWHID": 0, "HWHName": "", "HQty": 1, "HRemark": "" + , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "1", "HRelTaxPrice": "0", "HTaxRate": "0", "HTaxMoney": "0", "HlineTotal": "0", "HlineTotalBB": "0", "HDate": Format(new Date, "yyyy- MM - dd") + }; // 鍒涘缓涓�涓柊鐨勫寘鍚暟缁� 鍏跺垵濮嬪�间负绌烘垨鑰�0 鎴栬�呮槸鏃堕棿鏍煎紡 - if (checkStatus.data.length != 1) { //鍒ゆ柇閫変腑鐨勬暟鎹槸鍚︿负涓�鏉� - return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�"); //鎻愮ず璇烽�変腑涓�鏉� - } - OptionData = checkStatus.data[0]; - //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� - obj.update({ - "HUnitID": checkStatus.data[0].HItemID - , "璁¢噺鍗曚綅": checkStatus.data[0].璁¢噺鍗曚綅鍚嶇О - }) - layer.close(index);//鍏抽棴寮圭獥 - } - , end: function () { - obj.update({ - "HUnitID": OptionData.HItemID - , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О - }) - } - }) - } + table.cache["mainTable"].push(NewRow); //鍒涘缓鏂扮殑鍖呭惈鏁扮粍 浼犲叆table.cache["mainTable"]鏁扮粍 + option.data = table.cache["mainTable"]; //鎶婁紶鍏� table.cache["mainTable"]鏁扮粍鐨勫�艰祴鍊肩粰option.data 鐨勫睘鎬� - //浠撳簱 - if (obj.event == "HWHID") { //鍒ゆ柇obj.event浜嬩欢 鐨勫瓧绗︿覆鏄惁==HWHID - var HOrgName = $('select[name="HOrgID"] option:selected').text(); - layer.open({ //鎵撳紑灞� - type: 2 //琛ㄧず寮瑰嚭灞傜殑鍐呭鏄竴涓� iframe 绫诲瀷涓�2 - , skin: "layui-layer-rim" //鍔犱笂杈规 - , title: "璁¢噺鍗曚綅鍒楄〃" //鏍囬 - , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 - , shift: 2 //寮瑰嚭鍔ㄧ敾 - , area: ["90%", "90%"] //绐椾綋澶у皬 - , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� - , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Warehouse.html?type=Warehouse&HOrgName=' + HOrgName, 'yes']//璁剧疆 iframe 鐨� URL锛孶RL 涓寘鍚簡鏌ヨ鍙傛暟锛屾潵璋冪敤鎵�闇�瑕佺殑鍊� - , 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("璇烽�夋嫨涓�鏉℃暟鎹�"); + table.render(option);//娓叉煋鐣岄潰 + } + var HMaterID = checkStatus.data[i].HItemID; //checkStatus.data鏁扮粍涓殑褰撳墠鍏冪礌锛堢储寮曚负i锛変腑鑾峰彇HItemID灞炴�х殑鍊� 骞惰祴鍊肩粰HMaterID + var resultData = getMaterialByMaterID(HMaterID); //浣跨敤HMaterID浣滀负鍙傛暟鏉ヨ皟鐢╣etMaterialByMaterID鍑芥暟鏉ヨ幏鍙栬鐗╂枡鐨勮缁嗕俊鎭� + option.data[rowIndex + i].HMaterID = resultData.HMaterID; //灏唎ption.data鏁扮粍涓搴旇鐨凥MaterID灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].鐗╂枡浠g爜 = resultData.HMaterNumber; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡浠g爜 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].鐗╂枡鍚嶇О = resultData.HMaterName; //灏唎ption.data鏁扮粍涓搴旇鐨� 鐗╂枡鍚嶇О 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].瑙勬牸鍨嬪彿 = resultData.HMaterModel; //灏唎ption.data鏁扮粍涓搴旇鐨� 瑙勬牸鍨嬪彿 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].HUnitID = resultData.HUnitID; //灏唎ption.data鏁扮粍涓搴旇鐨� HUnitID 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID + option.data[rowIndex + i].璁¢噺鍗曚綅 = resultData.HUnitName; //灏唎ption.data鏁扮粍涓搴旇鐨� 璁¢噺鍗曚綅 灞炴�ф洿鏂颁负浠巖esultData瀵硅薄涓幏鍙栫殑鐗╂枡ID 鏇存柊璁¢噺鍗曚綅灞炴�� + option.data[rowIndex + i].HQty = 1; //灏嗗搴旇鐨凥Qty灞炴�э紙鍙兘浠h〃鏁伴噺锛夎缃负1銆傝繖琛ㄧず瀵逛簬姣忎釜閫変腑鐨勭墿鏂欙紝鍏堕粯璁ゆ暟閲忚璁剧疆涓�1 + option.data[rowIndex + i].HTaxRate = TaxRate; } - OptionData = checkStatus.data[0]; - //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� - obj.update({ - "HWHID": checkStatus.data[0].HItemID - , "HWHName": checkStatus.data[0].浠撳簱鍚嶇О - }) - layer.close(index);//鍏抽棴寮圭獥 + table.render(option); //閲嶆柊娓叉煋琛ㄦ牸浠ユ樉绀烘洿鏂板悗鐨勬暟鎹� } - , end: function () { - obj.update({ - "HWHID": OptionData.HItemID - , "HWHName": OptionData.浠撳簱鍚嶇О + + layer.closeAll(); //鍏抽棴鎵�鏈夐�氳繃layer + //layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� + } + , btn2: function (index, layero) { //褰撶偣鍑烩�滃彇娑堚�濇寜閽椂浼氳璋冪敤 + //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 + //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 + }, + end: function () { + //閫氳繃渚涘簲鍟唅d鑾峰彇绋庣巼 + var HSupID = $("#HSupID").val(); + if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") { + var Dec = getDecByMaterID(OptionData.HItemID) //鑾峰彇绮惧害 + var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //鏁伴噺绮惧害 + var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //鍗曚环绮惧害 + var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //閲戦绮惧害 + $.ajax({ + url: GetWEBURL() + "/Gy_Supplier/xg", + //url: "http://localhost:12761/Gy_Supplier/xg", + type: "GET", + data: { + "HInterID": HSupID + }, + success: function (d) { + var HTaxRate = 0; + if (typeof (d.data[0].澧炲�肩◣鐜�) == undefined) { + layer.alert("鍙戠敓閿欒鏁版嵁搴撹〃鏃犲鍊肩◣鐜囧瓧娈�!", { icon: 5 }); + } else { + HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�) * 0.01; + } + var HExRate = $("#HExRate").val(); //姹囩巼 + //鏁版嵁鏍¢獙鍚堟牸锛岄噸绠楄褰� + var HQty = obj.data.HQty * 1; //鏁伴噺 + var HPrice = obj.data.HPrice * 1; //鍗曚环 + var HMoney = HQty * HPrice; //閲戦=鏁伴噺*鍗曚环 + var HTaxMoney = Number((HMoney * HTaxRate)); //绋庨=閲戦*绋庣巼 + var HlineTotal = HMoney + HTaxMoney; //浠风◣鍚堣=閲戦+绋庨 + var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //鍚◣鍗曚环=鍗曚环*(1+绋庣巼) + var HDiscountRate = obj.data.HDiscountRate * 1; //鎶樻墸鐜� + var HRelTaxPrice = Number((HTaxPrice * HDiscountRate)); //瀹為檯鍚◣鍗曚环=鍚◣鍗曚环*鎶樻墸鐜� + var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate)); //鏈綅甯佷环绋庡悎璁�=(绋庨+閲戦)*姹囩巼 + //鏁板瓧绮惧害 + HQty = Number(HQty.toFixed(HQtyDec)); + HPrice = Number(HPrice.toFixed(HPriceDec)); + HMoney = Number(HMoney.toFixed(HMoneyDec)); + HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec)); + HlineTotal = Number(HlineTotal.toFixed(HMoneyDec)); + HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec)); + HRelTaxPrice = Number(HRelTaxPrice.toFixed(HPriceDec)); + HlineTotalBB = Number(HlineTotalBB.toFixed(HMoneyDec)); + obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 + "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� + , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 + , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О + , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 + , "HUnitID": OptionData.HUnitID + , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О + , "HTaxRate": HTaxRate * 100 + , HQty: HQty //鏇存柊HQty瀛楁锛孒Qty + , HPrice: HPrice //鏇存柊HPrice瀛楁锛孒Price + , HMoney: HMoney //鏇存柊HMoney瀛楁锛孒Money + , HTaxMoney: HTaxMoney //鏇存柊HTaxMoney瀛楁锛孒TaxMoney + , HlineTotal: HlineTotal //鏇存柊HlineTotal瀛楁锛孒lineTotal + , HTaxPrice, HTaxPrice //鏇存柊HTaxPrice瀛楁锛孒TaxPrice + , HRelTaxPrice: HRelTaxPrice //鏇存柊HRelTaxPrice瀛楁锛屽叾鍊兼潵鑷彉閲廐RelTaxPrice + , HlineTotalBB: HlineTotalBB //鏇存柊HlineTotalBB瀛楁锛屽叾鍊兼潵鑷彉閲廐lineTotalBB + }) + } + }); + } else { + obj.update({ //鏇存柊琛ㄦ牸鏁版嵁 + "HMaterID": OptionData.HItemID //璁剧疆HItemID鐨勫�间负鈥淗BillNo鈥濆瓧娈电殑鍊糎ItemID`鐨勫�� + , "鐗╂枡浠g爜": OptionData.鐗╂枡浠g爜 + , "鐗╂枡鍚嶇О": OptionData.鐗╂枡鍚嶇О + , "瑙勬牸鍨嬪彿": OptionData.瑙勬牸鍨嬪彿 + , "HUnitID": OptionData.HUnitID + , "璁¢噺鍗曚綅": OptionData.璁¢噺鍗曚綅鍚嶇О }) } - }) - } - obj.event = ""; //鎶奲oj.event灞炴�� 鍒濆鍖栦负绌� - return false; - } - }) - //鐗╂枡琛ㄦ牸涓嬫媺鎼滅储妗� - tableSelect.render({ - elem: 'td[data-field="鐗╂枡浠g爜"] .layui-table-edit', - checkedKey: 'HItemID', - searchKey: '鐗╂枡浠g爜', - sWhere: '',//table鎼滅储sWhere鏉′欢 - table: { - url: GetWEBURL() + 'Gy_Material/page', - where: { user: '缈佹稕娑�', Organization: '娴欐睙鏅轰簯杩堟��' }, - cols: [[ - { type: 'checkbox',fixed:'left' }, - { field: 'HItemID', title: 'HItemID' }, - { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜' }, - { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О' }, - ]], - page: true, - limit: 5, - limits: [5] - }, - done: function (elem, data) { - $(".layui-table-edit").blur();//鍗曞厓鏍煎け鍘荤劍鐐� - setTableByHMater(obj, data); + } + }); + + obj.event = ""; + } catch (error) { + layer.alert("鍙戠敓閿欒!" + error, { icon: 5 }); } - }) + + }); + + //鐗╂枡琛ㄦ牸涓嬫媺鎼滅储妗� + //tableSelect.render({ + // elem: 'td[data-field="鐗╂枡浠g爜"] .layui-table-edit', + // checkedKey: 'HItemID', + // searchKey: '鐗╂枡浠g爜', + // sWhere: '',//table鎼滅储sWhere鏉′欢 + // table: { + // url: GetWEBURL() + 'Gy_Material/page', + // where: { user: '缈佹稕娑�', Organization: '娴欐睙鏅轰簯杩堟��' }, + // cols: [[ + // { type: 'checkbox',fixed:'left' }, + // { field: 'HItemID', title: 'HItemID' }, + // { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜' }, + // { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О' }, + // ]], + // page: true, + // limit: 5, + // limits: [5] + // }, + // done: function (elem, data) { + // $(".layui-table-edit").blur();//鍗曞厓鏍煎け鍘荤劍鐐� + // setTableByHMater(obj, data); + // } + //}) } //閫夋嫨鐗╂枡鍗曢�夋垨澶氶�夋敼鍙樿〃鏍间俊鎭� function setTableByHMater(obj, data) { @@ -1996,7 +2155,7 @@ //#region 閫氳繃渚涘簲鍟唅d鑾峰彇绋庣巼 function getHTaxRateByHSupID() { - var HTaxRate; + var HTaxRate = 0; //閫氳繃渚涘簲鍟唅d鑾峰彇绋庣巼 var HSupID = $("#HSupID").val(); if (HSupID != 0) { @@ -2008,7 +2167,19 @@ "HInterID": HSupID }, success: function (d) { - HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�); + if (d.code == 1) { + HTaxRate = 0; + if (typeof (d.data[0].澧炲�肩◣鐜�) == undefined || d.data[0].澧炲�肩◣鐜� == null) { + layer.alert("鍙戠敓閿欒鏁版嵁搴撹〃澧炲�肩◣鐜囧瓧娈垫湁璇�!", { icon: 5 }); + } else { + HTaxRate = parseInt(d.data[0].澧炲�肩◣鐜�); + } + } + else { + layer.alert(result.message, { icon: 5, btn: ['閫�鍑�'], time: 100000, offset: 't' }); //result.msg瀵硅薄锛屾彁绀哄脊绐� 绫诲瀷涓�5锛� 鎸夐挳锛屽拰鎸夐挳鐨勫悕绉颁负閫�鍑� 鏃堕棿 涓�100绉掞紝浠ュ強鍋忕Щ閲忥紙`offset: 't' + } + }, error: function (err) { + layer.alert("鍙戠敓閿欒!" + err, { icon: 5 }); } }); } else { -- Gitblit v1.9.1