archive_query_conditionvalue_modify.jsp

oa 源码

					while(ir1.hasNext()){
						aqcd = (ArchiveQueryConditionDb)ir1.next();
				%>
				  <script>
				  document.all.<%=tableShortCode%>_<%=fieldCode%>[<%=indexs%>].value = '<%=aqcd.getInputValue()%>';
				  </script>
				<%
						indexs++;
					}

				}else{
				%>			  	
				  <select name="<%=tableShortCode%>_<%=fieldCode%>">
					 <%=options%>
				  </select>
				 <%
				 } 
				 %>		  
				  <input type="button" onClick='addORConditionSel(this,"<%=tableShortCode%>_<%=fieldCode%>")' value="添加或条件">
			    </td>
			   </tr>
			  </table>
			 </td>
          </tr>
<%			   
		   }else{		   
		   //处理日期字段
		   if(Integer.parseInt(tfid.getFieldType()) == tfid.SELEDATE){
			   Vector vt1 = aqcd.list(sql);
%>
          <tr>
            <td width="16%" noWrap><%=tfid.getFieldName()%>：</td>         
			<td width="84%" noWrap>
			 <table id="<%=tableShortCode%>_<%=fieldCode%>_TABLE" width="100%">
			   <tr>
<%

			    if(vt1.size() > 0){
					String inputValue1 = "", inputValue2 = "", type = "0";
					int isFind = -1, value1 = 0, value2 = 0;
					Iterator ir1 = vt1.iterator();
					if(ir1.hasNext()){
						aqcd = (ArchiveQueryConditionDb)ir1.next();
						conditionSign = aqcd.getConditionSign();
						if(ir1.hasNext()){
						    isFind = aqcd.getInputValue().indexOf("_");
							if(isFind == -1){
							    inputValue1 = aqcd.getInputValue();
								type = "0";
								aqcd = (ArchiveQueryConditionDb)ir1.next();
								inputValue2 = aqcd.getInputValue();
							}else{
								value1 = Integer.parseInt(aqcd.getInputValue().split("\\_")[1]);
								value2 = Integer.parseInt(aqcd.getInputValue().split("\\_")[0]);
								inputValue1 = Integer.toString(value1 - value2);
								type = "2";
								aqcd = (ArchiveQueryConditionDb)ir1.next();
								value1 = Integer.parseInt(aqcd.getInputValue().split("\\_")[1]);
								value2 = Integer.parseInt(aqcd.getInputValue().split("\\_")[0]);
								inputValue2 = Integer.toString(value1 - value2);
							}
						}else{
							isFind = aqcd.getInputValue().indexOf("_");
							if(isFind == -1){
								inputValue1 = aqcd.getInputValue();
								type = "1";
							}else{
								value1 = Integer.parseInt(aqcd.getInputValue().split("\\_")[1]);
								value2 = Integer.parseInt(aqcd.getInputValue().split("\\_")[0]);
								inputValue1 = Integer.toString(value1 - value2);
								type = "3";
							}
						}	
				if(inputValue1.equals("null"))
					inputValue1 = "";
				if(inputValue2.equals("null"))
					inputValue2 = "";						
%>
				<td width="14%">
					<select name="<%=tableShortCode%>_<%=fieldCode%>_COND" onChange="selDate(<%=tableShortCode%>_<%=fieldCode%>_TABLE,'<%=tableShortCode%>_<%=fieldCode%>_COND')">
						<option value="0">精确段时间</option>
						<option value="1">精确点时间</option>
						<option value="2">模糊段时间</option>
						<option value="3">模糊点时间</option>
					</select>	
					<script>
					form1.<%=tableShortCode%>_<%=fieldCode%>_COND.value = '<%=type%>';
					</script>			
				</td>
				<td width="70%" align="left" id="SEGMENT_DATE_TD" <%if(!type.equals("0")){%> style="display:none" <%}%>>
					从 
					  <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_FROMDATE" readonly <%if(type.equals("0")){%> value="<%=inputValue1%>" <%}%>><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_FROMDATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					至 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_TODATE" readonly <%if(type.equals("0")){%> value="<%=inputValue2%>" <%}%>><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_TODATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">	
				</td>
				<td width="70%" align="left" id="POINT_DATE_TD" <%if(!type.equals("1")){%> style="display:none" <%}%>>
					<select name="<%=tableShortCode%>_<%=fieldCode%>_SIGN">
						<option value="=">等于</option>
						<option value=">">大于</option>
						<option value="<">小于</option>
						<option value="<=">小于等于</option>
						<option value=">=">大于等于</option>
					</select>
					<%if(type.equals("1")){%>
					<script>
					form1.<%=tableShortCode%>_<%=fieldCode%>_SIGN.value = '<%=aqcd.getConditionSign()%>';
					</script>
					<%}%>
					&nbsp;&nbsp;<input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_DATE" readonly <%if(type.equals("1")){%> value="<%=inputValue1%>" <%}%>><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_DATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
				</td>
			    <td width="70%" align="left" id="VAGUE_SEGMENT_YEAR_TD" <%if(!type.equals("2")){%> style="display:none" <%}%>>
				    参照时间 
				      <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_SEGMENT_YEAR" readonly <%if(type.equals("2")){%> value="<%=aqcd.getInputValue().split("_")[1]%>" <%}%>><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_SEGMENT_YEAR', 'yyyy')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					从 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_FROMYEAR" <%if(type.equals("2")){%> value="<%=inputValue1%>" <%}%>>
					至 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_TOYEAR" <%if(type.equals("2")){%> value="<%=inputValue2%>" <%}%>>(周岁或年)
				</td>
				<td width="70%" align="left" id="VAGUE_POINT_YEAR_TD" <%if(!type.equals("3")){%> style="display:none" <%}%>>
				    参照时间 
				      <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_POINT_YEAR" readonly <%if(type.equals("3")){%> value="<%=aqcd.getInputValue().split("_")[1]%>" <%}%>><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_POINT_YEAR', 'yyyy')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					<select name="<%=tableShortCode%>_<%=fieldCode%>_VAGUE_SIGN">
						<option value="=" selected>等于</option>
						<option value=">">大于</option>
						<option value="<">小于</option>
						<option value="<=">小于等于</option>
						<option value=">=">大于等于</option>
					</select>
					<%if(type.equals("3")){%>
					<script>
					form1.<%=tableShortCode%>_<%=fieldCode%>_VAGUE_SIGN.value = '<%=aqcd.getConditionSign()%>';
					</script>
					<%}%>
					&nbsp;&nbsp;<input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_YEAR" <%if(type.equals("3")){%> value="<%=inputValue1%>" <%}%>>			
				</td>
<%
					}
				}else{
%>
				<td width="14%">
					<select name="<%=tableShortCode%>_<%=fieldCode%>_COND" onChange="selDate(<%=tableShortCode%>_<%=fieldCode%>_TABLE,'<%=tableShortCode%>_<%=fieldCode%>_COND')">
						<option value="0" selected>精确段时间</option>
						<option value="1">精确点时间</option>
						<option value="2">模糊段时间</option>
						<option value="3">模糊点时间</option>
					</select>				
				</td>
				<td width="70%" align="left" id="SEGMENT_DATE_TD">
					从 
					  <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_FROMDATE" readonly><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_FROMDATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					至 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_TODATE" readonly><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_TODATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">	
				</td>
				<td width="70%" align="left" id="POINT_DATE_TD" style="display:none">
					<select name="<%=tableShortCode%>_<%=fieldCode%>_SIGN">
						<option value="=" selected>等于</option>
						<option value=">">大于</option>
						<option value="<">小于</option>
						<option value="<=">小于等于</option>
						<option value=">=">大于等于</option>
					</select>
					&nbsp;&nbsp;<input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_DATE" readonly><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_DATE', 'yyyy-MM-dd')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
				</td>
			    <td width="70%" align="left" id="VAGUE_SEGMENT_YEAR_TD" style="display:none">
				    参照时间 
				      <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_SEGMENT_YEAR" readonly><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_SEGMENT_YEAR', 'yyyy')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					从 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_FROMYEAR">
					至 <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_TOYEAR">(周岁或年)
				</td>
				<td width="70%" align="left" id="VAGUE_POINT_YEAR_TD" style="display:none">
				    参照时间 
				      <input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_POINT_YEAR" readonly><img style="CURSOR: hand" onClick="SelectDate('<%=tableShortCode%>_<%=fieldCode%>_REFERENCE_POINT_YEAR', 'yyyy')" src="../images/form/calendar.gif" align="absMiddle" border="0" width="26" height="26">
					<select name="<%=tableShortCode%>_<%=fieldCode%>_VAGUE_SIGN">
						<option value="=" selected>等于</option>
						<option value=">">大于</option>
						<option value="<">小于</option>
						<option value="<=">小于等于</option>
						<option value=">=">大于等于</option>
					</select>
					&nbsp;&nbsp;<input size="10" name="<%=tableShortCode%>_<%=fieldCode%>_YEAR">			
				</td>
<%
				}	
%>
			   </tr>
			 </table>
			</td>
          </tr>		  
<%		 
			 }  
		   }
		 }
       }
	   j++;
	}   
%>
        </tbody>
      </table>
      </td>
    </tr>  
    <tr>
      <td align="center"><input value="保存查询条件字段" type="submit">
		<input type="hidden" name="conditionFieldCodeStr" value="<%=conditionFieldCodeStr%>"> 
		<input type="hidden" name="id" value="<%=queryId%>"> 
		<input type="hidden" name="tableFullCodeStr" value="<%=tableFullCodeStr%>">
		&nbsp;&nbsp;    </td>
    </tr>
  </table>
</form>
</body>
</html>