| | |
| | | contentType: 'application/json', |
| | | exts: 'xls|xlsx', //å
许ä¸ä¼ çç±»å |
| | | before: function (data) { |
| | | loadIndex = layer.load(2); |
| | | layer.load(); |
| | | }, |
| | | done: function (data1) { |
| | | layer.closeAll('loading'); |
| | | if (data1.count == 1) { |
| | | var HVersion_Import_Temp = Format(new Date(), "yyyy-MM-dd hh:mm:ss"); |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | data1.data[i].HVersion_Import = HVersion_Import_Temp; |
| | | } |
| | | |
| | | 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.closeAll('loading'); |
| | | layer.alert('导å
¥åºç°å¼å¸¸', { icon: 2 }); |
| | | } |
| | | }); |
| | |
| | | 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: 'hmainid', title: 'hmainid', width: 200, hide: true }); |
| | |
| | | columns.push({ field: 'HWorkShopID', title: 'HWorkShopID', hide: true }); |
| | | columns.push({ field: 'ç产车é´ç¼ç *', title: 'ç产车é´', width: 150}); |
| | | columns.push({ field: 'HSourceID', title: 'HSourceID', hide: true }); |
| | | columns.push({ field: 'çäº§èµæºç¼ç *', title: 'çäº§èµæº', edit: 'text', event: "HSourceID" }); |
| | | columns.push({ field: 'çäº§èµæºç¼ç *', title: 'çäº§èµæº', edit: 'text', event: "HSourceID" }); |
| | | columns.push({ field: '产è½', title: '产è½', edit: 'text' }); |
| | | columns.push({ field: 'ä¼å
级', title: 'ä¼å
级' }); |
| | | columns.push({ field: 'HEmpID', title: 'HEmpID', hide: true }); |
| | | columns.push({ field: 'åå·¥', title: 'åå·¥', width: 150 }); |
| | |
| | | columns.push({ field: 'ICMOBillHInterID', title: 'ICMOBillHInterID', hide: true}); |
| | | columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', hide: true }); |
| | | columns.push({ field: 'HProdORGID', title: 'HProdORGID', hide: true }); |
| | | 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 }) |
| | | columns.push({ field: 'HVersion_Import', title: '导å
¥åºåå·'}); |
| | | |
| | | 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 = 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 }) |
| | | } |
| | | |
| | | //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 = { |
| | |
| | | |
| | | //渲æé¡µé¢ |
| | | table.render(option); |
| | | } |
| | | } |
| | | |
| | | //导å
¥(ä¿å) |
| | | function set_AddNew(data) { |
| | | var msgError = ""; |
| | | |
| | | var num = []; |
| | | for (var i = 0; i < table.cache["mainTable"].length; i++) { |
| | | if (table.cache["mainTable"][i] != "") { |
| | | table.cache["mainTable"][i].LAY_TABLE_INDEX = i; |
| | | |
| | | if (table.cache["mainTable"][i].ç©æåç§°.indexOf("\"") != -1 || table.cache["mainTable"][i].ç©æåç§°.indexOf(";") != -1) { |
| | | table.cache["mainTable"][i].ç©æåç§° = table.cache["mainTable"][i].ç©æåç§°.replaceAll("\"", "â").replaceAll(";", "ï¼") |
| | | } |
| | | if (table.cache["mainTable"][i].è§æ ¼åå·.indexOf("\"") != -1 || table.cache["mainTable"][i].è§æ ¼åå·.indexOf(";") != -1) { |
| | | table.cache["mainTable"][i].è§æ ¼åå· = table.cache["mainTable"][i].è§æ ¼åå·.replaceAll("\"", "â").replaceAll(";", "ï¼") |
| | | } |
| | | |
| | | num.push(table.cache["mainTable"][i]) |
| | | } |
| | | } |
| | | data.field.HPRDORGID = sessionStorage["OrganizationID"];//ç»ç» |
| | | var sMainStr = JSON.stringify(data.field); |
| | | var sSubStr = JSON.stringify(num); |
| | | var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"]; |
| | | var index = layer.load(); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave", |
| | | async: true, |
| | | data: { "sMainSub": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { |
| | | layer.close(index); |
| | | 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: "温馨æç¤º" }); |
| | | |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | if (option.data[i].ç©æåç§°.indexOf("\"") != -1 || option.data[i].ç©æåç§°.indexOf(";") != -1) { |
| | | option.data[i].ç©æåç§° = option.data[i].ç©æåç§°.replaceAll("\"", "â").replaceAll(";", "ï¼") |
| | | } |
| | | }); |
| | | if (option.data[i].è§æ ¼åå·.indexOf("\"") != -1 || option.data[i].è§æ ¼åå·.indexOf(";") != -1) { |
| | | option.data[i].è§æ ¼åå· = option.data[i].è§æ ¼åå·.replaceAll("\"", "â").replaceAll(";", "ï¼") |
| | | } |
| | | } |
| | | |
| | | //夿æ¯å¦æå¯¼å
¥æéï¼å¦ææåå°æ»è£
车é´ä¹åçæ¥è®¡åå·¥åä½åº |
| | | if (!set_ModCheck("Sc_WorkBillSortBill_Edit")) { |
| | | layer.msg("导å
¥å¤±è´¥ï¼æ 导å
¥æéï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return; |
| | | } else { |
| | | if (!setWorkBillSortBillForDelete()) { |
| | | layer.msg("导å
¥å¤±è´¥ï¼å¾ææ¥è®¡åä½åºå¤±è´¥ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return; |
| | | } |
| | | } |
| | | |
| | | |
| | | var HDataSub = []; |
| | | |
| | | //JIT导å
¥è®¡åï¼æ¯æ¬¡å¯¼å
¥100è¡æ°æ®,å¯ä¿®æ¹içèªå¢å¼å³å®æ¯æ¬¡å¾ªç¯å¯¼å
¥çè¡æ° |
| | | 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"]; |
| | | var index = layer.load(); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave", |
| | | async: false, |
| | | data: { "sMainSub": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { |
| | | layer.close(index); |
| | | /* layer.msg("æäº¤æå");*/ |
| | | } |
| | | else { |
| | | layer.close(index); |
| | | msgError += data.Message + "ï¼"; |
| | | //layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.close(index); |
| | | msgError += err + "ï¼"; |
| | | //layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | if (msgError.length == 0) { |
| | | layer.msg("æäº¤æå"); |
| | | } else { |
| | | layer.msg(msgError, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | } |
| | | |
| | | //è¡å
å é¤ |
| | | 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); |
| | |
| | | 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 |
| | | |
| | | //#region ä½åºå¯¹åºç产车é´çæ¥è®¡åå·¥å |
| | | function setWorkBillSortBillForDelete() { |
| | | //æ¼æ¥ç产车é´çID |
| | | var HWorkShopIDArrayList = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | option.data[i]["åæ®å·"] = ""; |
| | | option.data[i]["hmainid"] = ""; |
| | | |
| | | |
| | | if ($.inArray(option.data[i]["HWorkShopID"], HWorkShopIDArrayList) == -1) { |
| | | HWorkShopIDArrayList.push(option.data[i]["HWorkShopID"]); |
| | | } |
| | | } |
| | | var HWorkShopIDListStr = ""; |
| | | for (var i = 0; i < HWorkShopIDArrayList.length; i++) { |
| | | if (i == HWorkShopIDArrayList.length - 1) { |
| | | HWorkShopIDListStr = HWorkShopIDArrayList[i]; |
| | | } else { |
| | | HWorkShopIDListStr = HWorkShopIDArrayList[i] + ","; |
| | | } |
| | | } |
| | | |
| | | //ä½åºå¯¹åºç产车é´IDçæ¥è®¡åå·¥å |
| | | var resultBool = false; |
| | | var sql = ""; |
| | | if (HWorkShopIDListStr != "") { |
| | | sql = "update Sc_WorkBillSortBillMain set HDeleteMan = '" + sessionStorage["HUserName"] + "',HDeleteDate = getdate(),HBillStatus = 4 where HWorkShopID in (" + HWorkShopIDListStr + ")"; |
| | | } else { |
| | | return resultBool; |
| | | } |
| | | var ModRightNameCheck = ""; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/CommonModel/commonMethod', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | resultBool = true; |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | return resultBool; |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | }); |