📄 setlist.asp
字号:
<%response.write "<INPUT TYPE=""hidden"" name=""logic" & iCount+1 & """ value=""and""><INPUT TYPE=""hidden"" name=""Field" & iCount+1 & """ style=""width:100"" value=""" & oRS("field_type") & "|" & oRS("field_str") & """>"
response.write oRS("field_name")%>
</td>
</tr>
<tr >
<td >
<%
jump=fnSearchInput(oRS("input_type"),oRS("Filter_type"),oRS("filter_data").value,iCount+1)
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
iCount=iCount+jump
end if
oRS.movenext
wend
oRS.close
response.write "<SCRIPT LANGUAGE=""JavaScript"">" & vbCrLf
response.write " iFilter=" & iCount & vbCrLf
response.write " initFilter=" & iCount & vbCrLf
response.write "</SCRIPT>"
%>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" align="center" height="45">
<input type="submit" name="ok1" value="确定">
<input type="reset" name="reset" value="重置" onclick="ClsFilterTables(document.all['Filter'])">
</td>
</tr>
</table>
<!-- FILTER -->
<table width="100%" border="1" cellspacing="0" cellpadding="1" class="leftTable" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" height="100%" id="MenuTR2" style="display:none">
<tr bgcolor="#E8E8E8">
<td align="center"> </td>
</tr>
<tr bgcolor="#E8E8E8">
<td align="center">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#666666" bordercolordark="#FFFFFF" background="../../images/calendar/images/image--banyuan--cccccc--2.gif">
<tr bgcolor="#F2F1F1" align="center">
<td height="16" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="cursor:hand" onclick="ShowMenu(1)">
<tr align="center">
<td align=center> 查 找 </td>
</tr>
</table>
</td>
<td height="16" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor=#D7D6CE>
<tr align="center">
<td align=center> 筛 选 </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" align="center" height="0">
<table width=100% cellspacing=0>
<!--
<tr style="display:none">
<td bgcolor="#F5F5F5">
<select name="logic0">
<option value="and">和
<option value="or">或
</select>
</td>
</tr>
-->
<tr>
<td bgcolor="#F5F5F5">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#E8E8E8">
<tr >
<td >
字段：
</td>
<td >
<select name="Field0" style="width:100" onchange="fnChangeFilterInput(FilterInput0,this.value,0)">
<%=filterSelect%>
</select>
</td>
</tr>
<tr >
<td >
</td>
<td >
<select name="operator0">
<option value="like">包含</option>
<option value="=">=</option>
<option value=">">></option>
<option value="<"><</option>
<option value=">=">>=</option>
<option value="<="><=</option>
<option value="<>">不等于</option>
</select>
</td>
</tr>
<tr >
<td >
</td>
<td >
<div id="FilterInput0">
<%=FilterInput%>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" align="center" height="0">
<Div id="Filter">
</Div>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" align="center" height="45">
<%response.write "<INPUT TYPE=""hidden"" NAME=""FilterCount"" value="& iCount &">"%>
<input type="submit" name="ok" value="确定">
<input type="reset" name="reset" value="重置" onclick="ClsFilterTables(document.all['Filter'])">
<input type="button" name="add" value="增加条件" onclick="javascript:addFilterTable(document.all['Filter'])">
</td>
</tr>
</table>
</td>
<td bgcolor="#CCCCCC" width="1"><img src="../images/point.gif" width="1" height="1"></td>
</tr>
</table>
<!-- Left -->
</td>
<td width="91%" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td width="91%" height="80">
<!-- top -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr valign="top">
<td height="22">
<%
BannerTitle="人事管理 -> <a href=""human_infolist.asp"">职员资料维护表</a>"
%>
<!--#include virtual="/_inc/banner/banner01.asp"-->
</td>
</tr>
<!-- 过滤器 -->
<tr valign="top">
<td height="10">
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td bgcolor="#F2F1F1" nowrap>显示</td>
<td bgcolor="#F2F1F1" nowrap>
<%
oRS.open "select * from fn_table_col where table_id="&table_id,oCon
while not oRS.eof
if instr(col_id,","&oRS("id")&",")>0 or session("userid")=1 then
response.write "<input type=""checkbox"" name=""priv" & oRS("id") & """ value=""1"" checked onClick=""document.sendForm.submit();"">"& oRS("Field_name")
end if
oRS.movenext
wend
oRS.close
%>
</td>
</tr>
<%
oRS.open "select * from fn_table where id="&table_id,oCon
if oRS.eof then
response.write "no this table"
response.end
end if
TABLE_SUM_FIELD_STR = oRS("TABLE_SUM_FIELD_STR")
oRS.close
if len(TABLE_SUM_FIELD_STR)>0 then
%>
<tr>
<td bgcolor="#F2F1F1" nowrap>统计</td>
<td bgcolor="#F2F1F1" nowrap>
<%
aSUM_FIELD = split(TABLE_SUM_FIELD_STR,",")
STATCOUNT = ubound(aSUM_FIELD)
for each field_id in aSUM_FIELD
oRS.open "select id,field_name from fn_table_col where id="&field_id,oCon
if not oRS.eof then response.write "<input type=""radio"" name=""statistic"" value=""" & oRS("id") & """ onClick=""document.sendForm.submit();"">按" & oRS("field_name") & "统计"
oRS.close
next
%>
</td>
</tr>
<INPUT TYPE="hidden" NAME="STATCOUNT" VALUE="<%=STATCOUNT%>">
<%
end if
%>
</table>
</td>
</tr>
<INPUT TYPE="hidden" name="submitit" value="yes">
<INPUT TYPE="hidden" name="table_id" value="<%=table_id%>">
<!---->
<tr>
<td height="18" valign="bottom">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#666666" bordercolordark="#FFFFFF" background="/images/calendar/images/image--banyuan--cccccc--2.gif">
<tr bgcolor="#F2F1F1" align="center">
<td height="16">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td><img src="/images/calendar/xiaoyuan.gif" width="12" height="10"></td>
<td><img src="/images/calendar/xiaoyuan.gif" width="12" height="10"></td>
<td><img src="/images/calendar/xiaoyuan.gif" width="12" height="10"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- top -->
</td>
</tr>
<tr>
<td height="100%">
<iframe id=main
style="Z-INDEX: 1; VISIBILITY: inherit; WIDTH: 100%; HEIGHT: 100%"
name="main" src="setlist_table.asp?table_id=<%=table_id%>"
frameborder=0></iframe>
</td>
</tr>
</table>
</td>
</tr>
</table>
</FORM>
</body>
</html>
<html><script language="JavaScript"> </script></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -