?? show_report_touchman_bak.asp
字號(hào):
<%@ LANGUAGE="VBSCRIPT"%>
<!--#include file="../conn.asp"-->
<!--#include file="function.asp"-->
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>聯(lián)系人報(bào)表</TITLE></HEAD>
<link rel="STYLESHEET" href="../css.css" type="text/css">
<script language="VBScript">
sub page_onclick(page)
dim str
str = "<input type=hidden name=movepage value='"& page &"'>"
str = str & "<input type=hidden name=textsql value='"& window.frmMain.textsql.value &"'>"
ifmList01.form1.innerHtml = str
ifmList01.form1.submit()
end sub
</script>
<body>
<%
textsql="select * from touchman where 1=1 "
if request("typeid")=1 then
if request("s_section")<>"0" then
textsql=textsql & " and TouchmanSection='"&trim(request("s_section"))&"'"
end if
if request("s_duty")<>"0" then
textsql=textsql & " and touchmanduty='"&trim(request("s_duty"))&"'"
end if
if request("s_operator")<>"0" then
textsql=textsql & " and TouchmanCreatorID="&trim(request("s_operator"))
end if
end if
if request("typeid")=2 then
if trim(request("txtkeyword"))<>"" then
if request("key_kind")="touchmanclientid" then
textsql=textsql & " and "& request("key_kind")& " in (select clientid from client where clientname like '%"& CheckStrInput(trim(request("txtkeyword")))&"%' )"
else
textsql=textsql & " and "& request("key_kind") &" like '%"&CheckStrInput(trim(request("txtkeyword")))&"%'"
end if
end if
end if
textsql=textsql & "order by TouchmanID desc"
%>
<form method="POST" name="frmMain">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="720">
<TR >
<TD height="20" align="center">
<input type=hidden name=textsql value="<%=encrypt(textsql)%>">
<%
set rs = server.createobject("adodb.recordset")
rs.open textsql,conn,3
if not rs.eof then
rs.pagesize=25
pcount = rs.pagecount
for i=1 to pcount
%>
<a style='cursor:hand' onclick='javascript:page_onclick("<%=i%>")'><%=i%></a>
<%
next
%>
<TD>
</TR>
<TR>
<TD align="center">
<iframe id="ifmList01" frameborder="0" height="610" width="715" src="show_report_touchman01.asp?textsql=<%=encrypt(textsql)%>" marginwidth="0" marginheight="0" framespacing="0"></iframe>
</TD>
</TR>
<TR >
<TD height="20" align="center">
<%
for i=1 to pcount
%>
<a style='cursor:hand' onclick='javascript:page_onclick("<%=i%>")'><%=i%></a>
<%
next
%>
<TD>
</TR>
<%else%>
<TR >
<TD >
沒(méi)有相應(yīng)紀(jì)錄
<TD>
</TR>
<% end if%>
</TABLE>
</form>
</BODY>
</HTML>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -