MES-WEB-LayUI.git

			@@ -29,32 +29,133 @@

			<div class="layui-card-body">
			<!--<div class="test-table-reload-btn" style="margin-bottom: 10px;">-->
			<form class="layui-form" action="">
			<div class="layui-form-item">
			<div class="layui-inline">
			<label class="layui-form-label">åæ®å·</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HBillNo" id="HBillNo">
			<form class="layui-form" action="" lay-filter="component-form-group">
			<div class="layui-collapse">
			<div class="layui-colla-item">
			<div class="layui-colla-title layui-inline" >
			<div class="layui-inline">
			<span>æ´å¤</span>
			</div>
			</div>
			<!--ç¬¬ä¸å±è¿æ»¤-->
			<div class="layui-inline">
			<label class="layui-form-label">åæ®å·</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HBillNo" id="HBillNo">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">å¼å§æ¥æ</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HDate1" id="HDate1">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç»ææ¥æ</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HDate2" id="HDate2">
			</div>
			</div>
			<div class="layui-inline" >
			<label class="layui-form-label">å¤å®ç»è®º</label>
			<div class="layui-input-block" style="width:120px">
			<select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
			<option value=""></option>
			<option value="åæ ¼">åæ ¼</option>
			<option value="ä¸åæ ¼">ä¸åæ ¼</option>
			</select>
			</div>

			</div>
			<div class="layui-inline">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query" id="f_Query">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			<!--ç¬¬äºæè¿æ»¤-->
			<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" style="width:120px">
			<input type="text" class="layui-input" name="HNumber" id="HNumber">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç©æåç§°</label>
			<div class="layui-input-block" style="width:120px" >
			<input type="text" class="layui-input" name="HName" id="HName">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">è§æ ¼åå·</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HModel" id="HModel">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">è´¨æ£å</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HName1" id="HName1">
			</div>
			</div>
			</div>
			</div>
			<!--ç¬¬ä¸æè¿æ»¤-->
			<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" style="width:120px">
			<input type="text" class="layui-input" name="HName2" id="HName2">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">çäº§åç§°</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HName3" id="HName3">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">å·¥åºæµè½¬å¡</label>
			<div class="layui-input-block" style="width:120px">
			<input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
			</div>
			</div>
			</div>
			</div>
			<!--èªå®ä¹è¿æ»¤-->
			<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" style="width:120px">
			<select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline" style="width:120px">
			<select name="Comparator" id="Comparator" 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" style="width:120px">
			<input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
			</div>
			</div>
			</div>
			</div>

			<div class="layui-inline">
			<label class="layui-form-label">å¼å§æ¥æ</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HDate1" id="HDate1">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç»ææ¥æ</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HDate2" id="HDate2">
			</div>
			</div>
			<div class="layui-inline">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>

			</div>

			</form>
			@@ -79,6 +180,14 @@
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="btn-Delete" lay-event="btn-Delete"><i class="layui-icon layui-icon-form"></i>å é¤</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideColumn" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Close" id="btn-Close"><i class="layui-icon layui-icon-radio"></i>å³é</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeClose" id="btn-DeClose"><i class="layui-icon layui-icon-radio"></i>åå³é</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>ä½åº</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>åä½åº</button>
			<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Exit" id="ExitButton"><i class="layui-icon layui-icon-logout"></i>éåº</button>
			</div>
			</script>
			</div>
			@@ -306,8 +415,147 @@
			var HBillType = "7505";
			get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
			break;
			//å·æ°
			case 'get_Refresh': get_Refresh();
			break;
			//éåºæé®
			case 'get_Exit': Pub_Close(2);
			break;
			//å®¡æ ¸æé®
			case 'btn-Audit':
			set_CheckBill(0);
			break;
			//åå®¡æ ¸æé®
			case 'btn-DeAudit':
			set_CheckBill(1);
			break;
			//å³éæé® ï¼1:å³éã2:åå³éï¼
			case 'btn-Close':
			set_CloseBill(1);
			break;
			//åå³éæé®
			case 'btn-DeClose':
			set_CloseBill(2);
			break;
			//ä½åºæé® ï¼1:ä½åºã2:åä½åºï¼
			case 'btn-Drop':
			set_DropBill(1);
			break;
			//åä½åºæé®
			case 'btn-DeDrop':
			set_DropBill(2);
			break;
			};
			});
			//å·æ°
			function get_Refresh() {
			$("#f_Query").trigger('click');
			}

			//#region åå®¡æ ¸/å®¡æ ¸æ°æ®
			function set_CheckBill(num) {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length === 1) {
			var InterID = data[0].hmainid.toString();
			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/QC_ValueTable/QC_FirstPieceCheckValue", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "HInterID": InterID, "IsAudit": num, "CurUserName": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			// å¾å°frameç´¢å¼
			var index = layer.getFrameIndex(window.name);
			//å³éå½åframe
			layer.close(index);
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			$("#f_Query").trigger('click');
			});

			} else {
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼');
			}
			}

			//#region åå³é/å³éæ°æ®
			function set_CloseBill(num) {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length === 1) {
			var InterID = data[0].hmainid.toString();
			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/QC_ValueTable/CloseQC_FirstPieceCheckBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "HInterID": InterID, "Type": num, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			// å¾å°frameç´¢å¼
			var index = layer.getFrameIndex(window.name);
			//å³éå½åframe
			layer.close(index);
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			$("#f_Query").trigger('click');
			});

			} else {
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼');
			}
			}

			//#region åä½åº/ä½åºæ°æ®
			function set_DropBill(num) {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length === 1) {
			var InterID = data[0].hmainid.toString();
			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/QC_ValueTable/DropQC_FirstPieceCheckBills", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "HInterID": InterID, "Type": num, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			// å¾å°frameç´¢å¼
			var index = layer.getFrameIndex(window.name);
			//å³éå½åframe
			layer.close(index);
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			$("#f_Query").trigger('click');
			});

			} else {
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼');
			}
			}

			///å è½½æ¾ç¤ºæ°æ®
			//function RoadHBillNo(sqlWhere) {
			@@ -397,9 +645,9 @@
			DisPlay_HideColumn();
			table.render(option);

			//if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
			// ColFilter();
			//}
			if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
			ColFilter();
			}
			//å·æ°æé®æ¾ç¤º
			var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡
			var HBillType = "7505";
			@@ -505,24 +753,61 @@
			//if ($("#HStatus").val() != "")
			// sqlWhere += " and ç¶æ like ^^%" + $("#HStatus").val() + "%^^";
			var HBillNo = $("#HBillNo").val();//åæ®å·
			var HNumber = $("#HNumber").val();//ç©æä»£ç
			var HNumber = $("#HNumber").val();//ç©æç¼ç
			var HName = $("#HName").val();//ç©æåç§°
			var HModel = $("#HModel").val();//è§æ ¼åå·
			var HDate1 = $("#HDate1").val();//å¼å§æ¥æ
			var HDate2 = $("#HDate2").val();//ç»ææ¥æ
			var HDate2 = $("#HDate2").val();//ç»ææ¥æ
			var HLastResult = $("#HLastResult").val();//å¤å®ç»è®º
			var HName1 = $("#HName1").val();//è´¨æ£ååç§°
			var HName2 = $("#HName2").val();//æ£éªé¡¹ç®
			var HName3 = $("#HName3").val();//çäº§èµæºåç§°
			var HProcExchBillNo = $("#HProcExchBillNo").val();//å·¥åºæµè½¬å¡
			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").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 (HBillNo)
			sqlWhere += " and åæ®å· like '%" + HBillNo+ "%'";
			if (HNumber)
			sqlWhere += " and ç©æä»£ç like '%" + HNumber + "%'";
			sqlWhere += " and ç©æç¼ç like '%" + HNumber + "%'";
			if (HName)
			sqlWhere += " and ç©æåç§° like '%" + HName + "%'";
			if (HModel)
			sqlWhere += " and è§æ ¼åå· like '%" + HModel + "%'";
			//if ($("#HClStatus").val() != "")
			// sqlWhere += " and å³éç¶æ like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HPURCHASEORGID").val() != "")
			// sqlWhere += " and éè´ç»ç» like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
			if (HLastResult)
			sqlWhere += " and å¤å®ç»è®º like '" + HLastResult + "%'";
			if (HName1)
			sqlWhere += " and è´¨æ£ååç§° like '%" + HName1 + "%'";
			if (HName2)
			sqlWhere += " and æ£éªé¡¹ç® like '%" + HName2 + "%'";
			if (HName3)
			sqlWhere += " and çäº§èµæºåç§° like '%" + HName3 + "%'";
			if (HProcExchBillNo)
			sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'";

			if (HDate1) {
			sqlWhere += " and æ¥æ >= '" + HDate1 + "'";
			}
			@@ -538,7 +823,10 @@
			// sqlWhere += " and æªå³èæ°é > 0";
			// }
			//}

			//if ($("#HClStatus").val() != "")
			// sqlWhere += " and å³éç¶æ like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HPURCHASEORGID").val() != "")
			// sqlWhere += " and éè´ç»ç» like ^^%" + $("#HPURCHASEORGID").val() + "%^^";

			var Time = $("#Time").val();
			var dd = new Date();
			@@ -778,6 +1066,19 @@
			}
			})
			}

			//#region åææ¾ç¤ºä¸ææ¡
			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);
			form.render('select');
			}
			});
			</script>
			</body>