MES-WEB-LayUI.git

			@@ -10,6 +10,7 @@
			<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>
			</head>
			<body>
			<div class="layui-fluid">
			@@ -56,6 +57,92 @@
			<input type="text" class="layui-input" name="FStockName" id="FStockName">
			</div>
			</div>


			<hr />
			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<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>
			<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>

			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" 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>
			</select>
			</div>
			<div class="layui-inline">
			<input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
			</div>
			</div>

			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
			</div>
			</div>
			</div>
			</div>
			</div>
			@@ -75,7 +162,7 @@
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util'], function () {
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () {
			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			@@ -88,6 +175,7 @@
			, util = layui.util
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			//åå§åçé¢
			@@ -129,6 +217,8 @@
			set_InitGrid();
			//æ¥è¯¢
			get_Display(sWhere);

			ColFilter();
			}
			//#endregion

			@@ -140,33 +230,58 @@
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, totalRow: true
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			, cols: [[
			{ type: 'checkbox', fixed: 'left' }
			, { field: 'ç©æID', title: 'ç©æID', hide: true }
			, { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ' }
			, { field: 'ç©æåç§°', title: 'ç©æåç§°' }
			, { field: 'ç©æè§æ ¼åå·', title: 'ç©æè§æ ¼åå·' }
			, { field: 'ä»åºID', title: 'ä»åºID', hide: true }
			, { field: 'ä»åºç¼ç ', title: 'ä»åºç¼ç ' }
			, { field: 'ä»åºåç§°', title: 'ä»åºåç§°' }
			, { field: 'ä»ä½ID', title: 'ä»ä½ID', hide: true }
			, { field: 'ä»ä½åç§°', title: 'ä»ä½åç§°' }
			, { field: 'åºåä¸»åä½ID', title: 'åºåä¸»åä½ID', hide: true }
			, { field: 'åä½ç¼ç ', title: 'åä½ç¼ç ' }
			, { field: 'åä½åç§°', title: 'åä½åç§°' }
			, { field: 'æ¹å·', title: 'æ¹å·' }
			, { field: 'å¯ç¨åºåé', title: 'å¯ç¨åºåé' }
			, { field: 'ç»ç»ç¼ç ', title: 'ç»ç»ç¼ç ' }
			, { field: 'ç»ç»åç§°', title: 'ç»ç»åç§°' }
			, { field: 'è´§ä¸»ç±»å', title: 'è´§ä¸»ç±»å' }
			, { field: 'è´§ä¸»ID', title: 'è´§ä¸»ID' }
			, { field: 'è´§ä¸»ç¼ç ', title: 'è´§ä¸»ç¼ç ' }
			, { field: 'ç©æID', title: 'ç©æID', hide: true, sort: true }
			, { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', sort: true }
			, { field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true }
			, { field: 'ç©æè§æ ¼åå·', title: 'ç©æè§æ ¼åå·', sort: true }
			, { field: 'ä»åºID', title: 'ä»åºID', hide: true, sort: true }
			, { field: 'ä»åºç¼ç ', title: 'ä»åºç¼ç ', sort: true }
			, { field: 'ä»åºåç§°', title: 'ä»åºåç§°', sort: true }
			, { field: 'ä»ä½ID', title: 'ä»ä½ID', hide: true, sort: true }
			, { field: 'ä»ä½åç§°', title: 'ä»ä½åç§°', sort: true }
			, { field: 'åºåä¸»åä½ID', title: 'åºåä¸»åä½ID', hide: true, sort: true }
			, { field: 'åä½ç¼ç ', title: 'åä½ç¼ç ', sort: true }
			, { field: 'åä½åç§°', title: 'åä½åç§°', sort: true }
			, { field: 'æ¹å·', title: 'æ¹å·', sort: true }
			, { field: 'å¯ç¨åºåé', title: 'å¯ç¨åºåé', sort: true, totalRow: true }
			, { field: 'ç»ç»ç¼ç ', title: 'ç»ç»ç¼ç ', sort: true }
			, { field: 'ç»ç»åç§°', title: 'ç»ç»åç§°', sort: true }
			, { field: 'è´§ä¸»ç±»å', title: 'è´§ä¸»ç±»å', sort: true }
			, { field: 'è´§ä¸»ID', title: 'è´§ä¸»ID', sort: true }
			, { field: 'è´§ä¸»ç¼ç ', title: 'è´§ä¸»ç¼ç ', sort: true }
			]]
			};
			}
			//#endregion

			//#region ç¹å»è¡éä¸é«äº®
			table.on('row(mainTable)', function (obj) {
			//éä¸è¡æ¹åé¢è²
			var flag = !obj.tr.find(':checkbox:first').prop('checked');
			obj.tr.find(':checkbox').prop('checked', flag);
			if (flag) {
			obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //è®¾ç½®å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
			} else {
			obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
			}
			//mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
			layui.each(table.cache.mainTable, function (i, l) {
			if (obj.tr.index() == l.LAY_TABLE_INDEX) {
			l.LAY_CHECKED = flag;
			}
			});
			})
			//#endregion

			//#region æ¥è¯¢
			function get_Display(sWhere) {
			@@ -201,7 +316,80 @@
			var FMaterialName = $("#FMaterialName").val();
			var FStockNumber = $("#FStockNumber").val();
			var FStockName = $("#FStockName").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;
			}

			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 (FMaterialNumber) {
			sWhere += " and ç©æç¼ç like '%" + FMaterialNumber + "%'";
			}
			@@ -225,9 +413,36 @@
			$("#FMaterialName").val("");
			$("#FStockNumber").val("");
			$("#FStockName").val("");
			$("#ColContent").val("");
			$("#ColName").val("0");
			$("#Comparator").val("0");
			$("#ColContent1").val("");
			$("#ColName1").val("0");
			$("#Comparator1").val("0");
			$("#ColContent2").val("");
			$("#ColName2").val("0");
			$("#Comparator2").val("0")
			sWhere = "";
			}
			//#endregion
			//ä»¥ä¸æ¯layuiæ¨¡å
			//åææ¾ç¤ºä¸ææ¡
			function ColFilter() {
			var Organization = '<option value="0" selected="selected" ></option>';
			for (var i = 1; i < option.cols[0].length; i++) {
			if (option.cols[0][i].hide != true) {
			Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
			}
			}
			$("#ColName").empty();
			$("#ColName").append(Organization);
			$("#ColName1").empty();
			$("#ColName1").append(Organization);
			$("#ColName2").empty();
			$("#ColName2").append(Organization);

			form.render('select');
			}

			});
			</script>