MES-WEB-LayUI.git

			@@ -140,6 +140,7 @@
			<script type="text/html" id="toolbarDemo">
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_insert" id="get_insert"><i class="layui-icon layui-icon-export"></i>å¿«æ·æ°å¢</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="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" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			@@ -189,6 +190,10 @@
			//å¯¼åºexcel
			case 'get_export':
			get_Export();
			break;
			//å¿«æ·æ°å¢
			case 'get_insert':
			get_insert();
			break;
			//å·æ°
			case 'get_Refresh': get_Refresh();
			@@ -320,7 +325,7 @@
			Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

			//å·æ°è¡¨æ ¼æ°æ®
			//DisPlay_HideColumn();
			DisPlay_HideColumn();

			layer.close(ajaxLoad);

			@@ -434,6 +439,10 @@

			var sql = "select * from h_v_Cg_PODemandPlanConfigBillReportForLack where 1=1 " + sWhere;

			if (defaintOperationByCompanyName()) {
			sql += " and (ISNULL(FStaffId,0) = 0 or FStaffId in (select HEmpID from Gy_Czygl where Czymc = '" + sessionStorage["HUserName"] + "') or '" + sessionStorage["HUserName"] + "' = 'admin') ";
			}

			get_Display(sql);
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			@@ -462,7 +471,7 @@

			//#region å¯¼åºExecel
			function get_Export() {
			var ModRightNameCheck = "Cg_PODemandPlanConfigBillReportForLack";
			var ModRightNameCheck = "Cg_PODemandPlanConfigBillReportForLack_ExportExcel";

			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			@@ -471,7 +480,28 @@
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			table.exportFile(ins.config.id, option.data, "xls");
			var addExportStr = ["ä¾åºåä»£ç "];
			var data = option.data;
			for (var i = 0; i < data.length; i++) {
			for (var j = 0; j < addExportStr.length; j++) {
			var temp = data[i][addExportStr[j]].indexOf("'");
			if (temp != 0) {
			data[i][addExportStr[j]] = "'" + data[i][addExportStr[j]];
			}
			}
			}
			data.forEach((item) => {
			for (let itemobj in item) {
			if (item[itemobj] == null) {
			item[itemobj] = "";
			}
			if (item[itemobj].length > 0) { // åè®¾åæ®µåä¸ºfield
			item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});
			table.exportFile(ins.config.id, data, "xls");
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			@@ -479,6 +509,69 @@
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion

			//#region å¿«æ·æ°å¢
			function get_insert() {
			var CheckStatus = table.checkStatus("mainTable");
			if (set_ModCheck("Cg_PODemandPlanConfigBill_Edit") == false) {
			return layer.msg("æ æé!")
			}
			if (CheckStatus.data.length == 0) {
			return layer.msg("è¯·éæ©æ°æ®!")
			} else {
			layer.confirm('æ¨ç¡®å®è¦æ°å¢åï¼', {
			btn: ['ç¡®å®', 'åæ¶'] //æé®
			, btn1: function () {
			var ajaxLoad = layer.load();
			var message = "";
			for (var i = 0; i < CheckStatus.data.length; i++) {
			var sql = "exec h_p_Cg_PODemandPlanConfigBillReportForLack_Copy " + CheckStatus.data[i].HOrgID + "," + CheckStatus.data[i].HMaterID + "," + CheckStatus.data[i].HSupID
			$.ajax({
			url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
			type: "GET",
			async: false,
			data: { "sWhere": sql },
			success: function (data1) {
			if (data1.count == 1) {
			message += i + "." + data1.data[0].Remark + CheckStatus.data[i].ç©æåç§° + "\\n"
			} else {
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			layer.alert(message, { icon: 5 });
			layer.close(ajaxLoad);
			//å·æ°æ°æ®
			get_FastQuery(2);
			}
			})
			}
			}
			//#endregion

			//#region è·åå¬å¸åï¼æ ¹æ®å¬å¸è¿è¡å®å¶åå¼å
			function defaintOperationByCompanyName() {
			var result = false;
			$.ajax({
			url: GetWEBURL() + '/Xt_getInfo/getCompanyName',
			async: false,
			type: "GET",
			data: {},
			success: function (data1) {
			if (data1.count == 1) {
			if (data1.data == "å®å·¥") {
			result = true;
			}
			}
			}, error: function (e) {
			}
			});
			return result;
			}
			//#endregion

			@@ -622,6 +715,26 @@
			form.render('select');
			}
			//#endregion
			//æéå¤å®
			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 () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			return Permission;
			}
			});

			//#endregion