js select 联动查找

最新推荐文章于 2023-10-07 15:03:47 发布

狼魂豹速

最新推荐文章于 2023-10-07 15:03:47 发布

阅读量457

点赞数

本文链接：https://blog.csdn.net/liufeifeihuawei/article/details/106098472

版权

<%@page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title></title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
		<script type="text/javascript" src="<%=basePath %>js/jquery-1.8.0.min.js"></script>
	<script language="javascript" type="text/javascript" src="<%=basePath %>/js/My97DatePicker/WdatePicker.js"></script>
	<script language="javascript" type="text/javascript" src="<%=basePath %>/js/common/key.js"></script>
		<script language="javascript" type="text/javascript" src="<%=basePath %>/js/check.js"></script>
<style>
	body{
		margin:0px;
		padding:0px;
		font-size:12px;
		color:black;
	}
	fieldset{ 
		padding:10px; 
		margin:10px; 
		width:800px; 
		color:#333; 
		border:#b5d6e6 dashed 1px;
	}
	legend{
		color:#06c; 
		font-weight:800; 
		background:#fff;
	}
	.td{
		height:35px;
		line-height:35px;
		width:90px;
		text-align:right;
		float:left;
		font-size:12px;
	}
	.smalltd{
		height:30px;
		line-height:30px;
		width:200px;
		text-align:right;
		float:left;
		font-size:12px;
	}
	.td_f{
		text-align:left;
		width:120px;
		background-color: lightgray;
	}
	.smalltd_f{
		text-align:left;
		width:45px;
		background-color: lightgray;
	}
	.input{
		margin-left:10px;
		width:150px;
	}
	.mininput{
		margin-left:10px;
		width:40px;
	}
	.maxinput{
		margin-left:10px;
		width:300px;
	}
	.select{
		margin-left:10px;
		width:200px;
	}
	.area{
		width:540px;
		height:50px;
		margin-left:10px;
	}
	.smalltitle{
		font-size:12px;
		font-weight:bolder;
	}
	.value{
		margin-left:5px;
		font-size:12px;
		color:blue;
		font-weight: bolder;
	}
	</style>
	<script type="text/javascript">
	function check(){
		var regxs = new RegExp("^[0-9]*$");
		var tf_ng1 = document.getElementById("tf_ng1").value.trim();
		var tf_ng2 = document.getElementById("tf_ng2").value.trim();
		var tf_ng3 = document.getElementById("tf_ng3").value.trim();
		var tf_ng4 = document.getElementById("tf_ng4").value.trim();
		var tf_ng5 = document.getElementById("tf_ng5").value.trim();
		var tf_ng6 = document.getElementById("tf_ng6").value.trim();
		var tf_ng7 = document.getElementById("tf_ng7").value.trim();
		var tf_ng8 = document.getElementById("tf_ng8").value.trim();
		var tf_ng9 = document.getElementById("tf_ng9").value.trim();
		var tf_ng10 = document.getElementById("tf_ng10").value.trim();
		var tf_ng11 = document.getElementById("tf_ng11").value.trim();
		var tf_ng12 = document.getElementById("tf_ng12").value.trim();
		var tf_ng13 = document.getElementById("tf_ng13").value.trim();
		var tf_ng14 = document.getElementById("tf_ng14").value.trim();
		var tf_ng15 = document.getElementById("tf_ng15").value.trim();
		var tf_ng16 = document.getElementById("tf_ng16").value.trim();
		var tf_ng17 = document.getElementById("tf_ng17").value.trim();
		var tf_ng18 = document.getElementById("tf_ng18").value.trim();
		var tf_ng19 = document.getElementById("tf_ng19").value.trim();
		var tf_ng20 = document.getElementById("tf_ng20").value.trim();
		var tf_ng21 = document.getElementById("tf_ng21").value.trim();
		var tf_ng22 = document.getElementById("tf_ng22").value.trim();
		var tf_ng23 = document.getElementById("tf_ng23").value.trim();
		var tf_ng24 = document.getElementById("tf_ng24").value.trim();
		var tf_ng25 = document.getElementById("tf_ng25").value.trim();
		var tf_ng26 = document.getElementById("tf_ng26").value.trim();
		var tf_ng27 = document.getElementById("tf_ng27").value.trim();
		var tf_ng28 = document.getElementById("tf_ng28").value.trim();
		if(!regxs.test(tf_ng1) || !regxs.test(tf_ng2) || !regxs.test(tf_ng3) || !regxs.test(tf_ng4) || 
				!regxs.test(tf_ng5) ||	!regxs.test(tf_ng6) || !regxs.test(tf_ng7)){
			alert("不良项目输入非法,只能为数字(0-9)组成,请检查后再输入");
			return false;
		}
		var tf_trPcs = document.getElementById("tf_trPcs").value.trim();
		var tf_ccPcs = document.getElementById("tf_ccPcs").value.trim();
		var tf_machNo = document.getElementById("tf_machNo").value.trim();
		var tf_feedBox = document.getElementById("tf_feedBox").value.trim();
		var tf_sTime = document.getElementById("tf_sTime").value.trim();
		var tf_eTime = document.getElementById("tf_eTime").value.trim();

		if(tf_trPcs == null || tf_trPcs == "" || tf_ccPcs == "" ||tf_ccPcs == null || tf_machNo == "" || 
				tf_machNo == null || tf_feedBox == null || tf_feedBox == "" || tf_sTime == null || 
				tf_sTime == "" || tf_eTime == "" || tf_eTime == null || tf_ng1 == "" || tf_ng1 == null || 
				tf_ng2 == "" || tf_ng2 == null || tf_ng3 == "" || tf_ng3 == null || tf_ng4 == "" || 
				tf_ng4 == null || tf_ng5 == "" || tf_ng5 == null || tf_ng6 == "" || tf_ng6 == null || 
				tf_ng7 == "" || tf_ng7 == null || tf_ng8 == "" || tf_ng8 == null || tf_ng9 == "" || 
				tf_ng9 == null || tf_ng10 == "" || tf_ng10 == null || tf_ng11 == "" || tf_ng11 == null || 
				tf_ng12 == "" || tf_ng12 == null || tf_ng13 == "" || tf_ng13 == null || tf_ng14 == "" || 
				tf_ng14 == null || tf_ng15 == "" || tf_ng15 == null || tf_ng16 == "" || tf_ng16 == null || 
				tf_ng17 == "" || tf_ng17 == null || tf_ng18 == "" || tf_ng18 == null || tf_ng19 == "" || 
				tf_ng19 == null || tf_ng20 == "" || tf_ng20 == null || tf_ng21 == "" || tf_ng21 == null || 
				tf_ng22 == "" || tf_ng22 == null || tf_ng23 == "" || tf_ng23 == null || tf_ng24 == "" || 
				tf_ng24 == null || tf_ng25 == "" || tf_ng25 == null || tf_ng26 == "" || tf_ng26 == null || 
				tf_ng27 == "" || tf_ng27 == null || tf_ng28 == "" || tf_ng28 == null){
			alert("请将信息填写完整!");
			return false;
		}
		
		var count = parseInt(tf_ccPcs)+parseInt(tf_ng1)+parseInt(tf_ng2)+parseInt(tf_ng3)+parseInt(tf_ng4)+
		parseInt(tf_ng5)+parseInt(tf_ng6)+parseInt(tf_ng7)+parseInt(tf_ng8)+parseInt(tf_ng9)+
		parseInt(tf_ng10)+parseInt(tf_ng11)+parseInt(tf_ng12)+parseInt(tf_ng13)+parseInt(tf_ng14)+
		parseInt(tf_ng15)+parseInt(tf_ng16)+parseInt(tf_ng17)+parseInt(tf_ng18)+parseInt(tf_ng19)+
		parseInt(tf_ng20)+parseInt(tf_ng21)+parseInt(tf_ng22)+parseInt(tf_ng23)+parseInt(tf_ng24)+
		parseInt(tf_ng25)+parseInt(tf_ng26)+parseInt(tf_ng27)+parseInt(tf_ng28);
		console.log(count+"===>"+tf_ng1+"--"+tf_ng2+"--"+tf_ng3+"--"+tf_ng4+"--"+tf_ng5+"--"+tf_ng6+"--"+tf_ng7+"--"+
				tf_ng8+"--"+tf_ng9+"--"+tf_ng10+"--"+tf_ng11+"--"+tf_ng12+"--"+tf_ng13+"--"+tf_ng14+"--"+tf_ng15+"--"+
				tf_ng16+"--"+tf_ng17+"--"+tf_ng18+"--"+tf_ng19+"--"+tf_ng20+"--"+tf_ng21+"--"+tf_ng22+"--"+tf_ng23+"--"+
				tf_ng24+"--"+tf_ng25+"--"+tf_ng26+"--"+tf_ng27+"--"+tf_ng28);
		if(tf_trPcs != count){
			alert("产出不等于投入,请检查后再输入"+tf_trPcs+"!="+count);
			return false;
		}
		
		return true;
	}
	function checkZk(){
		var zk_flag = document.getElementById("zk_flag").value.trim();
		var zk_flag2 = document.getElementById("zk_flag2").value.trim();
		var tf_p4 = document.getElementById("tf_p4").value.trim();
		var tf_p5 = document.getElementById("tf_p5").value.trim();
		
		if((tf_p4 == "" || tf_p4 == null) && (tf_p5 == "" || tf_p5 == null)){
			alert("请选择测试针卡.")
			return false;
		}
	/* 	if(zk_flag2 == "1"){
			if(tf_p5 == "" || tf_p5 == null){
				alert("请选择测试针卡.")
				return false;
			}
		} */
		return true;
	}
	
	/* var nos = JSON.parse('${listNo}');
	
	function changeSelect(){
		var type = $('#type').val();
		var options = "";
		var noSelect = [];
		for(var i = 0; i < nos.length; i++) {
		    var obj = nos[i];
		    if(obj["tf_name"] == type){
		    	noSelect.push(obj);
		    }
		}
		for(var i = 0; i < noSelect.length; i++) {
			options += "<option value='"+ noSelect[i]["tf_no"] +"'>"+ noSelect[i]["tf_no"] +"</options>";
			
		}
		$('#no').find('option').remove();
		$('#no').append(options);
	} */
	function changeSelect(){
		var type = $('#type').val();
		 var options = "";
		 var i = 0;
		  $.ajax({
				type : 'POST',
				dataType : "json",
				url : "testMachineAction!getSelect.action?type="+ type,
				success : function(data) {
					for(var i = 0; i < data.length; i++) {
						options += "<option value='"+ data[i]["tf_no"] +"'>"+ data[i]["tf_no"] +"</options>";
					}
					$('#no').find('option').remove();
					$('#no').append(options); 
				},
				error : function(err) {
					console.log(err)
				}
			});
	}
	</script>
  </head>
  <body oncontextmenu="return false" onsubmit="return checkZk()" onkeydown="checkKey()">
      	<!-- 
      	 <form onsubmit="return check()" action="dqfnAction!submit.action" method="post">
      	 -->
			<form action="dqfnFtAction!updFtLog.action" method="post">
			<fieldset>
		    	<legend>单片测试信息处理...</legend>
		    		<input type="hidden" name="tf_dingdan" id="tf_dingdan" value="${list[1].tf_dingdan}"/>
		    		<input type="hidden" name="tf_dingdan_id" id="tf_dingdan_id" value="${list[1].tf_id}" />
		    		<input type="hidden" name="tf_id" id="tf_id" value="${list[0][0]}"/>
		    		<input type="hidden" name="log_id" id="log_id" value="${log.tf_id}"/>
		    		
		    		<table cellpadding="0" cellspacing="1" border="0">
		    			<tr>
		    				<td class="td">封装形式</td>
		    				<td class="td_f"><span class="value">${list[3].tf_name}</span></td>
		    				<td class="td">产品型号</td>
		    				<td class="td_f"><span class="value">${list[4].tf_name}</span></td>
		    				<td class="td">生产批号</td>
		    				<td class="td_f"><span class="value">${list[0][1]}</span></td>
		    			</tr>
		    			<tr>
		    				<td class="td">订单号</td>
		    				<td class="td_f"><span class="value">${list[1].tf_dingdan}</span></td>
		    				<td class="td">订单类型</td>
		    				<td class="td_f"><span class="value">${list[1].tf_yongtu}</span></td>
		    				<td class="td">片号</td>
		    				<td class="td_f"><span class="value">${log.tf_p1 }</span></td>
		    				<input type="hidden" id="tf_p1" name="tf_p1" value="${log.tf_p1 }"/>
		    			</tr>
					<tr>
						<td colspan="6" style="height: 20px; line-height: 20px;">
							<span class="smalltitle">基本数据录入</span>
						</td>
					</tr>
					<tr>
						<td class="td">
							设备编号
						</td>
						<td class="td_f">
							<select id="tf_p2" name="tf_p2" class="input">
								<option value="">
									请选择设备编号...
								</option>
								<c:if test="${log.tf_p2 != '' && log.tf_p2 != null}">
								<option selected="selected" value="${log.tf_p2 }">${log.tf_p2 }</option>
								</c:if>
								<%for(int i = 1;i < 22;i++){ %>
								<% 
								String flag = "00"+i;
								flag = flag.substring(flag.length()-2);
								%>
								<option value="P/P-#<%=flag %>">P/P-#<%=flag %></option>
								<%} %>
							</select>
						</td>
						<%-- <td class="td">
							测试机号
						</td>
						<td class="td_f">
							<input class="input" id="tf_p3" name="tf_p3" type="text" value="${log.tf_p3 }" />
						</td> --%>
						<td class="td">
							投入数量
						</td>
						<td class="td_f">
							<input class="input" id="tf_tr" name="tf_tr" type="text" value="${log.tf_tr }" />
						</td>
						<td class="td">
							产出数量
						</td>
						<td class="td_f">
							<input class="input" id="tf_cc" name="tf_cc" type="text" value="${log.tf_cc }" />
						</td> 
					</tr>
					<tr>
						<td class="td">
							测试针卡1<input type="hidden" id="zk_flag" name="zk_flag" value="<c:choose><c:when test="${listZk != [] }">1</c:when><c:otherwise>0</c:otherwise></c:choose>"/>
						</td>
						<td class="td_f">
							<select id="tf_p4" name="tf_p4" class="input">
								<option value="">
									请选择针卡编号...
								</option>
								<c:forEach items="${listZk }" var="zk">
									<c:choose>
										<c:when test="${zk.tf_id == log.tf_p4 }">
											<option value="${zk.tf_id }" selected="selected">${zk.tf_name }</option>
										</c:when>
										<c:otherwise>
											<option value="${zk.tf_id }">${zk.tf_name }</option>
										</c:otherwise>
									</c:choose>
								</c:forEach>
							</select>
						</td>
						<td class="td">
							测试针卡2<input type="hidden" id="zk_flag2" name="zk_flag2" value="<c:choose><c:when test="${listZk2 != [] }">1</c:when><c:otherwise>0</c:otherwise></c:choose>"/>
						</td>
						<td class="td_f">
							<select id="tf_p5" name="tf_p5" class="input">
								<option value="">
									请选择针卡编号...
								</option>
								<c:forEach items="${listZk2 }" var="zk">
									<c:choose>
										<c:when test="${zk.tf_id == log.tf_p5 }">
											<option value="${zk.tf_id}" selected="selected">${zk.tf_name }</option>
										</c:when>
										<c:otherwise>
											<option value="${zk.tf_id}">${zk.tf_name }</option>
										</c:otherwise>
									</c:choose>
								</c:forEach>
							</select>
						</td> 
					</tr>
					<tr>
						<td class="td">测试机类型</td>
						<td class="td_f">
							<select class="input" id="type" name="type" onchange="changeSelect();">
								<option value="" >请选择测试机类型...</option>
								<c:forEach items="${listTest}" var="test" >
									<option value="${test}">${test}</option>
								</c:forEach>
							</select>
						</td>
						<td class="td">测试机编号</td>
						<td class="td_f">
							<select class="input" id="no" name="no">
								<c:forEach items="${listNo}" var="no" >
								<%-- 	<option value="${no }">${no}</option> --%>
								</c:forEach>
							</select>
						</td>
					</tr>
					<jsp:include page="FT_log_ngField.jsp"></jsp:include>
					<tr>
						<td class="td">
							生产备注
						</td>
						<td colspan="5" class="td_f"
							style="height: 60px; line-height: 60px;">
							<textarea class="area" name="tf_remark" id="tf_remark">${log.tf_remark}</textarea>
						</td>
					</tr>
					<tr>
		    				<td colspan="6" align="center" style="height:50px;line-height:50px;">
		    					<!-- 如果flag='N' 则修改tf_opeFlag1='Y',tf_opeFlag2='N',tf_opeFlag3='N'
		    						如果 flag='Y' 则修改tf_opeFlag1='Y',tf_opeFlag2='Y',tf_opeFlag3='Y' -->
		    					<input type="hidden" id="flag" name="flag" value="${flag }"/>
		    					<input type="button" onclick="javascript:window.location.reload();" value="刷新"/>&nbsp;&nbsp;&nbsp;&nbsp;
		    					<input type="button" onclick="javascript:window.history.back(-1);" value="返回 "/>&nbsp;&nbsp;&nbsp;&nbsp;
		    					<input type="submit" class="submit" value="保存"/>
		    				</td>
		    			</tr>
		    		</table>
		  	</fieldset>
		</form>
  </body>
</html>

package com.system.dqfn.action;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.Date;
import java.util.List;
import com.system.action.SystemAction;
import com.system.dqfn.model.TestMachine;
import com.system.dqfn.util.ExcelUtil;
import com.system.ds.utils.DTOBuilder;
import com.system.utils.UserUtils;
import com.system.utils.UuidUtil;
import net.sf.json.JSONArray;

@SuppressWarnings("serial")
public class TestMachineAction extends SystemAction {
	
	// 接收文件上传的MIME类型
	private String UploadContext;
	
	//上传的文件,要与jsp中的name一致
	private File file;
	
	//文件名
	private String filename;

	public String getUploadContext() {
		return UploadContext;
	}

	public void setUploadContext(String uploadContext) {
		UploadContext = uploadContext;
	}

	public File getFile() {
		return file;
	}

	public void setFile(File file) {
		this.file = file;
	}

	public String getFilename() {
		return filename;
	}

	public void setFilename(String filename) {
		this.filename = filename;
	}

	/*
	 * lff 3042073 2020-5-9 15:48 测试机列表页面
	 */
	@SuppressWarnings("unchecked")
	public String list() {
		String flag = res.getParameter(request, "flag", "Y");
		List<TestMachine> list = (List<TestMachine>) systemService
				.findListByHql("from TestMachine where tf_flag = '" + flag + "' order by tf_inputdate");
		request.setAttribute("list", list);
		request.setAttribute("flag", flag);
		return "list";
	}

	/*
	 * lff 3042073 2020-5-9 15:47 测试机增加跳转页面
	 */
	public String addUI() {
		return "addUI";
	}

	/*
	 * lff 3042073 2020-5-9 15:48 
	 * 测试机更新跳转页面
	 */
	public String editUI() {
		TestMachine list = (TestMachine) systemService
				.findObjectByHql("from TestMachine where tf_id = '" + res.getParameter(request, "tf_id", "") + "'");
		request.setAttribute("list", list);
		return "editUI";
	}

	/**3042073
	 * 2020 05-14
	 * ajax 选择查询
	 */
	@SuppressWarnings("unchecked")
	public void getSelect() {
		String type = res.getParameter(request, "type", "");
		List<TestMachine> list = (List<TestMachine>) systemService
				.findListByHql("from TestMachine where tf_name= '" + type + "'and tf_flag='Y'");
		JSONArray json = JSONArray.fromObject(list);
		System.out.println(json);
		try {
			response.getWriter().print(json.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 3042073
	 * excel 导入功能
	 * */
	public void getImportData() {
		StringBuilder message = new StringBuilder();
		ExcelUtil<TestMachine> util = new ExcelUtil<TestMachine>(TestMachine.class);
		try {
			//创建文件字节输入流对象
			InputStream in = new FileInputStream(file);
			List<TestMachine> list = util.importExcel(in);
			for(TestMachine t : list){
				try {
					t.setTf_id(UuidUtil.get32UUID());
					t.setTf_flag("Y");
					t.setTf_inputdate(sdf.format(new Date()));
					t.setTf_inputmen(UserUtils.getUser(request).getTf_name());
					systemService.save(t);
					
				} catch (Exception e) {
					e.printStackTrace();
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			//将数据返回到前端
			response.getWriter().print(message.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	
	/*
	 * lff 3042073 2020-5-9 15:50 
	 * 测试机增加or 更新
	 */
	public String add() {
		String tf_id = res.getParameter(request, "tf_id", "");
		TestMachine obj = null;
		TestMachine test = (TestMachine) systemService.findObjectByHql("from TestMachine where tf_id ='" + tf_id + "'");
		if ("".equals(tf_id)) {
			obj = (TestMachine) DTOBuilder.getDTO(request, TestMachine.class);
			obj.setTf_id(UuidUtil.get32UUID());
			obj.setTf_inputmen(UserUtils.getUser(request).getTf_name());
			obj.setTf_flag("Y");
			obj.setTf_inputdate(sdf.format(new Date()));
			systemService.save(obj);
			return SUCCESS;
		} else {
			try {
				DTOBuilder.updateDTO(request, test);
				systemService.update(test);
			} catch (Exception e) {
				e.printStackTrace();
			}
			return SUCCESS;
		}
	}

	/* 废止状态 */
	public void updateFlag() {
		TestMachine test = (TestMachine) systemService
				.findObjectByHql("from TestMachine where tf_id = '" + res.getParameter(request, "tf_id", "") + "'");
		test.setTf_flag("N");
		systemService.update(test);
		try {
			response.sendRedirect("testMachineAction!list.action?flag=N");
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	/* 删除 */
	public void delete() {
		TestMachine test = (TestMachine) systemService
				.findObjectByHql("from TestMachine where tf_id = '" + res.getParameter(request, "tf_id", "") + "'");
		systemService.delete(test);
		try {
			response.sendRedirect("testMachineAction!list.action?flag=N");
		} catch (Exception e) {

		}
	}

}

狼魂豹速

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
js select 联动查找

<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>&lt
复制链接

扫一扫