MES-WEB-LayUI.git

			@@ -78,6 +78,61 @@
			<input type="text" class="layui-input" 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>
			@@ -217,7 +272,7 @@
			break;
			};
			});


			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½
			get_FastQuery();
			@@ -240,7 +295,7 @@

			// è¿åºç«æ¥è¯¢
			function get_Display2(sWhere) {


			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Cj_SingleStation/EntryAndExitRecords',
			@@ -251,6 +306,7 @@
			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 });
			@@ -303,7 +359,7 @@
			// $("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
			// $("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
			//}



			//å·æ°è¡¨æ ¼æ°æ®
			DisPlay_HideColumn();
			@@ -680,34 +736,104 @@
			// å¿«éè¿æ»¤
			function get_FastQuery() {
			var HBardCode = $("#HBardCode").val();


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

			var com = "";
			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 + "%''";
			com = "like'%" + ColContent + "%'";
			break;
			case "8":
			com = "like ''%" + ColContent + "''";
			com = "like'%" + ColContent + "'";
			break;
			case "9":
			com = "like ''" + ColContent + "%''";
			com = "like'" + ColContent + "%'";
			break;
			case "10":
			com = "not like ''%" + ColContent + "%''";
			com = "not like'%" + ColContent + "%'";
			break;
			default:
			com = "" + Comparator + " ''" + ColContent + "''";
			com = "" + Comparator + "'" + ColContent + "'";
			break;
			}
			com = " and (" + ColName + " " + com + ")";
			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 = "" + Comparator2 + "'" + ColContent2 + "'";
			break;
			}
			sWhere += " and " + ColName2 + " " + com2;
			}

			sWhere += com;
			//var com = "";
			//if (ColName != 0 && Comparator != 0) {
			// 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;
			// }
			// com = " and (" + ColName + " " + com + ")";
			//}

			//sWhere += com;

			if (HBardCode!="") {
			sWhere += " order by åºç«æ¶é´";
			@@ -721,7 +847,7 @@
			get_Display7(HBardCode);//å·¥èºåæ°
			get_Display4(HBardCode);//éä»¶åæ´è®°å½
			}


			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}

			@@ -729,6 +855,12 @@
			$("#HICMOBillNo").val("");
			$("#HBardCode").val("");
			$("#HProcExchBillNo").val("");
			$("#ColContent1").val("");
			$("#ColName1").val("0");
			$("#Comparator1").val("0");
			$("#ColContent2").val("");
			$("#ColName2").val("0");
			$("#Comparator2").val("0");
			$("#ColContent").val("");
			$("#ColName").val("0");
			$("#Comparator").val("0");
			@@ -771,7 +903,7 @@
			}
			})
			}


			//æ¾ç¤ºåæ°æ®
			function DisPlay_HideColumn() {
			$.ajax({
			@@ -864,7 +996,9 @@
			}
			}
			$("#ColName").empty();
			$("#ColName").append(Organization);
			$("#ColName").append(Organization); $("#ColName1").empty();
			$("#ColName1").append(Organization); $("#ColName2").empty();
			$("#ColName2").append(Organization);
			form.render('select');
			}
			//#endregion