MES-WEB-LayUI.git

New file
			@@ -0,0 +1,406 @@
			ï»¿<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<head>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title>è®¾å¤è¿è¡ç¶æè¡¨</title>
			<meta name="renderer" content="webkit">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<script src="../../../layuiadmin/layui/layui.js"></script>
			<script src="../../../layuiadmin/layui/layui1.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>
			<script src="../../../layuiadmin/soulTable.slim.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<style>
			/æ ç¶å¾ç¹å»é«äº®åè²/
			.layui-tree-set-active > .layui-tree-entry .layui-tree-main {
			background: #aef0f7;
			}
			</style>
			</head>
			<body>
			<div class="layui-fluid">
			<div class="layui-col-md12">
			<div class="layui-card" style="padding: 1px">
			<div class="layui-card-body" style="padding: 1px;">
			<form class="layui-form" action="" lay-filter="component-form-group">
			<div class="layui-collapse">
			<div class="layui-colla-item">
			<div class="layui-inline">
			<label class="layui-form-label">å¼å§æ¥æ</label>
			<div class="layui-input-block">
			<input type="date" class="layui-input ForFilteringSchemes" id="HDate">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç»ææ¥æ</label>
			<div class="layui-input-block">
			<input type="date" class="layui-input ForFilteringSchemes" id="HDate1">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">è®¾å¤ç¼ç </label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" lay-verify="HEquipFileNo" name="HEquipFileNo" id="HEquipFileNo" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHEquip" id="btnHEquip" style="">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			</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" name="HName" id="HName">
			</div>
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="margin-left:40px;">
			æ¥è¯¢
			</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExit" id="btnExit" style="padding:0 5px">éåº</button>
			</div>
			</div>
			<div class="layui-row" style="padding:10px 0">
			<div class="layui-col-xs3 layui-inline" style="border: solid 1.5px #e0d6d64d;">
			<div id="TreeTable" class="demo-tree demo-tree-box"></div>
			</div>
			<div class="layui-col-xs8 layui-inline" style="padding-left: 10px; width: 73%">
			<div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable" style="margin-top:10px;"></table>
			</form>
			</div>
			</div>
			</div>
			</div>
			<script>
			//#region æå æ³¨é
			//#endregion
			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable', 'tree'], function () {

			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			, table = layui.table
			, form = layui.form
			, element = layui.element
			, laypage = layui.laypage
			, laydate = layui.laydate
			, soulTable = layui.soulTable
			, tree = layui.tree
			var sWhere = "";
			var option = [];
			var HModName = "SB_EquipRunningStatusReport";
			//ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±
			var titleData = ["HItemID", "Hprocid", "HUSEORGID"];
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½

			//åå§åçé¢
			set_ClearBill();
			//#endregion

			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç
			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery();
			});

			//éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			set_ClearQuery();
			});

			//éåºæé®
			form.on('submit(btnExit)', function (data) {
			Pub_Close(2);
			});

			//è®¾å¤
			form.on('submit(btnHEquip)', function (data) {//éæ©è®¾å¤
			layer.open({
			type: 2
			, area: ['80%', '80%']
			, title: 'è®¾å¤æ¡£æ¡'
			, shade: 0.6 //é®ç½©éæåº¦
			//, maxmin: true //åè®¸å¨å±æå°å
			, anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯
			, content: ['../../è®¾å¤ç®¡ç/è®¾å¤æ¡£æ¡/Gy_EquipFileMainList.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('è¯·éæ©æ°æ®');
			}
			$("#HEquipFileNo").val(checkStatus.data[0].è®¾å¤ç¼ç );
			$("#HName").val(checkStatus.data[0].è®¾å¤åç§°);
			layer.close(layer.index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			})
			});
			//#endregion


			//#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³

			//#region åå§åçé¢
			function set_ClearBill() {
			$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
			$("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_FastQuery();
			//
			get_Display_Tree();
			}
			//#endregion

			//#region æ¥è¯¢
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			//è¿å¥é¡µé¢æ¾ç¤ºçç¼ååè¡¨
			$.ajax({
			url: GetWEBURL() + '/SB_EquipRunningStatus/Report',
			type: "GET",
			data: { "sWhere": sWhere,"user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
			//è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
			var patrn = new RegExp(/^h/i);
			if (patrn.test(data1.list[key].ColmCols)) {
			titleData[key] = data1.list[key].ColmCols;
			}
			}
			//å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
			//col.push({ type: 'checkbox', fixed: 'left' });
			for (var i = 0; i < data.length; i++) {
			// if (data[i].name == 'HInterID' \|\| data[i].name == 'HBillType' \|\| data[i].name == 'hmainid') {
			if ($.inArray(data[i].name, titleData) > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
			}
			else {
			switch (data[i].Type) {
			//int
			case 'DateTime':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
			break;
			case 'long':
			case 'Int32':
			case 'Int64':
			case 'double':
			case 'Decimal':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
			}
			}
			}

			//å¨ææ¾ç¤ºåå
			option = {
			elem: '#mainTable'
			, cols: [col]
			, data: data1.data
			, height: 'full-80'
			, page: true
			, limits: [50, 500, 5000, 50000]
			, limit: 50
			, cellMinWidth: 90
			, totalRow: true
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			}
			ins = table.render(option);

			layer.close(ajaxLoad);
			if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
			ColFilter();
			}
			} else {
			option.data = data1.data
			ins = table.render(option);
			layer.close(ajaxLoad);
			//layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}

			});
			}
			//#endregion

			//#region å¿«éè¿æ»¤
			function get_FastQuery(sql) {
			var HDate = $("#HDate").val();
			var HDate1 = $("#HDate1").val();
			var HEquipFileNo = $("#HEquipFileNo").val();
			var HName = $("#HName").val();
			if (sql != null && sql != undefined && sql != "") {
			sWhere += sql;
			}
			if (HDate) {
			sWhere += " and CONVERT(varchar(100),æå±æ¥æ, 23) >= '" + HDate + "'";
			}
			if (HDate1) {
			sWhere += " and CONVERT(varchar(100),æå±æ¥æ, 23) <= '" + HDate1 + "'";
			}
			if (HEquipFileNo) {
			sWhere += " and è®¾å¤ç¼ç like '%" + HEquipFileNo + "%'";
			}
			if (HName) {
			sWhere += " and è®¾å¤åç§° like '%" + HName + "%'";
			}
			get_Display(sWhere);
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			//#endregion

			//#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
			function set_ClearQuery() {
			$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
			$("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
			$("#HEquipFileNo").val("");
			$("#HName").val("");
			form.render('select');
			sWhere = "";
			}
			//#endregion

			//åå§åè¡¨æ ¼
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, height: 'full-50'
			, page: true
			, totalRow: true
			, limits: [50, 500, 5000, 20000]
			, limit: 50 //æ¯é¡µé»è®¤æ¾ç¤ºçæ°é
			, cellMinWidth: 200
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}

			// æ ç¶å¾æ¥è¯¢
			function get_Display_Tree() {
			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/SB_EquipRunningStatus/ReportTreeGetList',
			type: "GET",
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			layer.close(ajaxLoad);
			var data = JSON.parse(data1.data);
			MenuMain(data);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			//éåçæä¸»èå
			function MenuMain(data) {
			var liStr = '[';
			//éåçæä¸»èå
			for (var i = 0; i < data.length; i++) {
			// å¤ææ¯å¦åå¨åèå
			if (data[i].children != null && data[i].children.length > 0) {
			liStr += '{"title": "' + data[i].id + "-" + data[i].title + '", "id": "' + data[i].id + '","spread":true,"type":"' + data[i].type + '","children": [';
			// éåè·ååèå
			for (var k = 0; k < data[i].children.length; k++) {
			liStr += getChildMenu(data[i].children[k], 0);
			}
			liStr = liStr.substring(0, liStr.length - 1);
			liStr += ']},';
			} else {
			liStr += '{"title": "' + data[i].id + "-" + data[i].title + '","type":"'+data[i].type+'", "id": "' + data[i].id + '"},';
			}
			};
			liStr = liStr.substring(0, liStr.length - 1);
			liStr += "]";
			var treeTable = JSON.parse(liStr);
			tree.render({
			elem: '#TreeTable' //é»è®¤æ¯ç¹å»èç¹å¯è¿è¡æ¶ç¼©
			, data: treeTable
			, click: function (obj) {
			//é«äº®åè²
			$(".layui-tree-set").removeClass('layui-tree-set-active');
			obj.elem.addClass('layui-tree-set-active');

			var data = obj.data; //è·åå½åç¹å»çèç¹æ°æ®
			var sql = "";

			if (data.id == "0") {
			sql = "";
			} else {
			if (data.type == "Department") {
			sql = " and HDeptID='" + data.id + "' ";
			} else if (data.type == "WorkCenter") {
			sql = " and HWorkCenterID='" + data.id + "' ";
			}
			}
			get_FastQuery(sql);
			}
			});
			}

			// éå½çæåèå
			function getChildMenu(subMenu, num) {
			num++;
			var subStr = '';
			if (subMenu.children != null && subMenu.children.length > 0) {
			subStr += '{"title": "' + subMenu.id + "-" + subMenu.title + '","type":"' + subMenu.type+'", "id": "' + subMenu.id + '", "children": [';
			for (var j = 0; j < subMenu.children.length; j++) {
			subStr += getChildMenu(subMenu.children[j], num);
			if (j + 1 == subMenu.children.length) {
			subStr = subStr.substring(0, subStr.length - 1);
			}
			}
			subStr += ']},';
			} else {
			subStr += '{"title": "' + subMenu.id + "-" + subMenu.title + '","type":"'+subMenu.type+'" , "id": "' + subMenu.id + '"},';
			}
			return subStr;
			}

			//#endregion

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

	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/设备管理/设备报表/SB_EquipRunningStatusReport.html	406 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -532,6 +532,7 @@
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤æ¥è¡¨\Sb_EquipRepairWorkBillReport.html" />
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤æ¥è¡¨\Sb_EquipDotCheckBillReport.html" />
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤æ¥è¡¨\Sb_EquipMaintainBillReport.html" />
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤æ¥è¡¨\SB_EquipRunningStatusReport.html" />
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤è§ç¨å\Sb_EquipDotCheckRuleList_PDA.html" />
			<Content Include="views\è®¾å¤ç®¡ç\è®¾å¤è§ç¨å\Sb_EquipMaintainRuleList_PDA.html" />
			<Content Include="views\è´¨éç®¡ç\åºç¡å»ºæ¨¡\Add_Edit_Gy_ErrMsgBackType.html" />