MES-WEB-LayUI.git

			@@ -38,91 +38,51 @@
			<!--å¨ææ¸²æå¹´ä»½-->
			</select>
			</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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
			<option value="">è¯·éæ©</option>
			<option value="1">éäº§</option>
			<option value="0">ééäº§</option>
			</select>
			</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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
			<!--å¨ææ¸²æç»ç»-->
			</select>
			</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" style="padding: 0px; margin-left: 6%;">
			<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" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
			</select>
			</div>
			<div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ç©æç¼ç </label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px; margin-right: 3px;">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			<div class="layui-inline">
			<select name="Comparator" id="Comparator" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent" id="ColContent">
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">ç©æåç§°</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName">
			</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="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator1" id="Comparator1" lay-filter="Comparator1" 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>
			<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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
			<!--å¨ææ¸²æç»ç»-->
			</select>
			</div>
			<div class="layui-inline">
			<input type="text" class="layui-input" value="" name="ColContent1" id="ColContent1">
			</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="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator2" id="Comparator2" lay-filter="Comparator2" 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="ColContent2" id="ColContent2">
			</div>
			</div>
			</div>
			@@ -217,6 +177,12 @@
			form.on('submit(btnReSearch)', function (data) {
			set_ClearQuery();
			});

			//#region äº§åç¼ç
			form.on('submit(btnHMaterID)', function (data) {
			btnHMaterID();
			});
			//#endregion
			//#endregion

			//#region ç¹å»è¡éä¸é«äº®
			@@ -244,6 +210,8 @@
			// åå§åçé¢
			function set_ClearBill() {
			Year(); //åå§åå¹´
			Get_HProject(); //è·åé¡¹ç®å·
			GetGy_Division();//è·åäºä¸é¨
			set_InitGrid(); //åå§åè¡¨æ ¼
			get_FastQuery();
			//å è½½æ±ç¶å¾
			@@ -351,85 +319,21 @@
			//å¿«éæ¥è¯¢
			function get_FastQuery() {
			var HYear = $("#HYear").val();
			var HProject = $("#HProject").val();//é¡¹ç®å·
			var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç
			var HMaterName = $("#HMaterName").val();//ç©æåç§°
			var HBatchWork = $("#HBatchWork").val();//æ¯å¦éäº§
			var HDivisionName = $("#HDivisionName").val();//äºä¸é¨

			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();

			var ColName1 = $("#ColName1").val();//å¤éæ¡
			var Comparator1 = $("#Comparator1").val()
			var ColContent1 = $("#ColContent1").val();
			var ColName2 = $("#ColName2").val();//å¤éæ¡
			var Comparator2 = $("#Comparator2").val()
			var ColContent2 = $("#ColContent2").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;
			sWhere = {
			HYear: HYear
			, HProject: HProject
			, HMaterNumber: HMaterNumber
			, HMaterName: HMaterName
			, HBatchWork: HBatchWork
			, HDivisionName: HDivisionName
			}
			if (ColName1 != 0 && Comparator1 != 0) {
			var com1 = "";
			switch (Comparator1) {
			case "7":
			com1 = "like'%" + ColContent1 + "%'";
			break;
			case "8":
			com1 = "like'%" + ColContent1 + "'";
			break;
			case "9":
			com1 = "like'" + ColContent1 + "%'";
			break;
			case "10":
			com1 = "not like'%" + ColContent1 + "%'";
			break;
			default:
			com1 = "" + Comparator1 + "'" + ColContent1 + "'";
			break;
			}
			sWhere += " and " + ColName1 + " " + com1;
			}
			if (ColName2 != 0 && Comparator2 != 0) {
			var com2 = "";
			switch (Comparator2) {
			case "7":
			com2 = "like'%" + ColContent2 + "%'";
			break;
			case "8":
			com2 = "like'%" + ColContent2 + "'";
			break;
			case "9":
			com2 = "like'" + ColContent2 + "%'";
			break;
			case "10":
			com2 = "not like'%" + ColContent2 + "%'";
			break;
			default:
			com2 = "" + Comparator + "'" + ColContent + "'";
			break;
			}
			sWhere += " and " + ColName2 + " " + com2;
			}
			if (HYear) {
			sWhere += " and HYear = '" + HYear + "'";
			}
			get_Display(sWhere);
			get_Display(JSON.stringify(sWhere));
			//å è½½æ±ç¶å¾
			set_Graphics();
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			@@ -438,17 +342,13 @@
			//éç½®å¿«éæ¥è¯¢
			function set_ClearQuery() {
			$("#HYear").val(new Date().getFullYear());
			$("#HProject").val("");
			$("#HMaterNumber").val("");
			$("#HMaterName").val("");
			$("#HBatchWork").val("");
			$("#HDivisionName").val("");

			$("#btnSearch").click();
			$("#ColContent").val("");
			$("#ColName").val("0");
			$("#Comparator").val("0");
			$("#ColContent2").val("");
			$("#ColName2").val("0");
			$("#Comparator2").val("0");
			$("#ColContent1").val("");
			$("#ColName1").val("0");
			$("#Comparator1").val("0");
			$("#btnSearch").click();
			form.render('select');

			sWhere = "";
			@@ -468,6 +368,7 @@
			var H_X = [];//Xè½´æ é¢
			var HBackCount = [];//ä¸è¯æ»æ°
			var Pass = [];//åæ ¼ç
			var target = [];//ç®æ å¼
			var HTitle = "åæ ¼çè¶å¿å¾";//å¾å½¢æ é¢
			if (option.data.length > 0) {
			for (let i = 0; i < option.data.length; i++) {
			@@ -478,6 +379,7 @@

			HBackCount.push(option.data[i].ä¸è¯æ»æ°);
			Pass.push((option.data[i].åæ ¼ç).replace('%', ''));
			target.push(('95.00%').replace('%', ''))

			}
			}
			@@ -507,7 +409,7 @@
			}
			},
			legend: {
			data: ['ä¸è¯æ»æ°','åæ ¼ç'],
			data: ['ä¸è¯æ»æ°','åæ ¼ç','ç®æ å¼'],
			top: 'bottom', // å°å¾ä¾æ¾ç½®å¨å¾è¡¨çä¸æ¹
			left: 'center' // æè 'right'ï¼æ ¹æ®éè¦è°æ´æ°´å¹³ä½ç½®
			},
			@@ -552,7 +454,10 @@
			series: [
			{
			name: 'ä¸è¯æ»æ°',
			type: 'bar',
			type: 'bar',
			label: {
			show: true
			},
			barGap: 0,
			emphasis: {
			focus: 'series'
			@@ -562,11 +467,19 @@
			return value;
			}
			},
			itemStyle: {
			color: '#FF0000' // è®¾ç½®æ±ç¶å¾çº¢è²
			},
			data: HBackCount
			},
			{
			name: 'åæ ¼ç',
			type: 'line',
			yAxisIndex: 1, // ä½¿ç¨ç¬¬äºä¸ª y è½´
			label: {
			show: true,
			formatter: '{c}%'
			},
			tooltip: {
			valueFormatter: function (value) {
			return value;
			@@ -575,12 +488,35 @@
			itemStyle: {
			normal: {
			lineStyle: {
			color: 'green' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			color: '#0066FF' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			},
			color: 'green' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			color: '#0066FF' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			}
			},
			data: Pass
			},
			{
			name: 'ç®æ å¼',
			type: 'line',
			yAxisIndex: 1, // ä½¿ç¨ç¬¬äºä¸ª y è½´
			label: {
			show: true,
			formatter: '{c}%'
			},
			tooltip: {
			valueFormatter: function (value) {
			return value;
			}
			},
			itemStyle: {
			normal: {
			lineStyle: {
			color: '#FF0000' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			},
			color: '#FF0000' // è®¾ç½®çº¿æ¡é¢è²ä¸ºç»¿è²
			}
			},
			data: target
			}
			]
			};
			@@ -589,6 +525,82 @@
			}
			//#endregion

			//çäº§è½¦é´
			function DeptName() {
			//è·åè½¦é´å
			var HDeptName = '<option value="0" style="color:red;" selected>å¨é¨è½¦é´</option>';
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Sc_ICMOBill/GetHDeptList",
			async: false,
			data: { "HOrgID": sessionStorage["OrganizationID"] },
			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].HName + '" >' + data[i].HName + '</option>';
			else
			HDeptName += '<option style="color:blue;" value="' + data[i].HName + '">' + data[i].HName + '</option>';

			}
			$("#HDeptName").append(HDeptName);
			form.render('select');
			}
			layer.closeAll("loading");
			}
			})
			}

			//#region è·åé¡¹ç®å·
			function Get_HProject() {
			//è·åé¡¹ç®å·
			var HProjectList = '<option value="" style="color:red;" selected></option>';
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Gy_Material/Get_HProject",
			async: false,
			data: { "HOrgID": sessionStorage["OrganizationID"] },
			success: function (result) {
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>';
			}
			$("#HProject").append(HProjectList);
			form.render('select');

			}
			layer.closeAll("loading");
			}
			})
			}
			//#endregion

			//#region è·åäºä¸é¨
			function GetGy_Division() {
			//è·åäºä¸é¨
			var HDivisionList = '<option value="" style="color:red;" selected></option>';
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
			async: false,
			data: { "HOrgID": sessionStorage["OrganizationID"] },
			success: function (result) {
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			HDivisionList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>';
			}
			$("#HDivisionName").append(HDivisionList);
			form.render('select');

			}
			layer.closeAll("loading");
			}
			})
			}
			//#endregion

			//#region å¯¼åºExecel
			function get_Export() {
			@@ -749,6 +761,31 @@
			}
			//#endregion

			//ç©æåè¡¨
			function btnHMaterID() {
			layer.open({
			type: 2 //ç±»å
			, skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
			, area: ['90%', '90%']//å¤§å°
			, title: 'ç©æåè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_Material.html', 'yes']
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè°
			var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢
			var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test"
			if (checkStatus.data.length === 0) {
			return layer.msg('è¯·éæ©æ°æ®');
			}
			//è·åæ°æ®
			$("#HMaterNumber").val(checkStatus.data[0].ç©æä»£ç );
			$("#HMaterName").val(checkStatus.data[0].ç©æåç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			})
			}

			//ä»¥ä¸æ¯layuiæ¨¡å
			});
			</script>