?? report_touchman_bak.asp
字號(hào):
<!--#INCLUDE FILE="../conn.asp"-->
<META NAME="Keywords" CONTENT="FastReport"/>
<META NAME="Description" CONTENT="The FastReport report"/>
<LINK href="../css.css" rel="stylesheet" type="text/css" media="all">
<HEAD></head>
<script language="VBScript">
sub print_onclick(id)
fm1.typeid.value=id
fm1.action="show_report_touchman.asp"
fm1.submit
end sub
sub down_onclick(id)
fm1.typeid.value=id
fm1.action="down_report_touchman.asp"
fm1.submit
end sub
</script>
<body >
<form style="scrollbars:no" method="post" name="fm1" target="_blank" >
<input type="hidden" name="typeid">
<table width="80%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><div align="right">
<table width="100%" cellpadding="0" cellspacing="0" bgcolor="#F2F2F2">
<tr bgcolor="#FFFFFF">
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="180" bgcolor="#566CDB"><font color="#FFFFFF"><img src="../images/DispStation.gif">報(bào)表-聯(lián)系人報(bào)表
</font></td>
<td><div align="right"> </div></td>
</tr>
</table>
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="middle" bgcolor="#FFFFFF"><table width="96%" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><fieldset>
<legend>范圍選擇</legend>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%"><div align="right">部門: </div>
<div align="right"></div></td>
<td width="80%">
<select name="s_section" class=text120 >
<option value="0" selected >全部</option>
<%
set rs_s = server.createobject("adodb.recordset")
sql_s= "select * from section order by sectionid "
rs_s.open sql_s,conn,3
if not rs_s.eof then
for i=1 to rs_s.recordcount
%>
<option value=<%=rs_s("sectionid")%>> <%=rs_s("sectionname")%></option>
<%
rs_s.movenext
next
end if
set rs_s=nothing
%>
</select>
</td>
</tr>
<tr>
<td><div align="right">職務(wù): </div>
<div align="right"></div></td>
<td>
<select name="s_duty" class=text120>
<option value="0" selected >全部</option>
<%
set rs_s = server.createobject("adodb.recordset")
sql_s= "select distinct touchmanduty from touchman "
rs_s.open sql_s,conn,3
if not rs_s.eof then
for i=1 to rs_s.recordcount
%>
<option value="<%=rs_s("touchmanduty")%>"> <%=rs_s("touchmanduty")%></option>
<%
rs_s.movenext
next
end if
set rs_s=nothing
%>
</select>
</td>
</tr>
<tr>
<td><div align="right">操作者: </div>
<div align="right"></div></td>
<td><select name="s_operator" class=text120 >
<option value="0" selected >全部</option>
<%
set rs_s = server.createobject("adodb.recordset")
sql_s= "select distinct username,userid from [user] order by userid "
rs_s.open sql_s,conn,3
if not rs_s.eof then
for i=1 to rs_s.recordcount
%>
<option value=<%=rs_s("userid")%>> <%=rs_s("username")%></option>
<%
rs_s.movenext
next
end if
set rs_s=nothing
%>
</select>
</td>
</tr>
</table>
<br>
<br>
</fieldset></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<table width="100%">
<tr>
<td width="80%"> <div align="right">
<input type="button" name="Button" value="下載結(jié)果" class="button_all" onClick="down_onclick(1)"
style="width:100px"></div></td>
<td ><div align="right">
<input type="button" name="Button" value="打印報(bào)表" class="button_all" onClick="print_onclick(1)"
style="width:100px">
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="middle" bgcolor="#FFFFFF"><table width="96%" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><fieldset>
<legend>模糊查詢</legend>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%"><div align="right">關(guān)鍵字: </div>
</td>
<td width="30%"><input type="text" name="txtkeyword"></td>
<td width="50%" >
<select name="key_kind" class=text120>
<option value="touchmanclientid" selected >所屬客戶</option>
<option value="touchmanophone"> 辦公電話</option>
<option value="touchmanaddress"> 詳細(xì)地址</option>
</select></td>
</tr>
</table>
<br>
<br>
</fieldset></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<table width="100%">
<tr>
<td width="80%"> <div align="right">
<input type="button" name="Button" value="下載結(jié)果" class="button_all" onClick="down_onclick(2)"
style="width:100px"></div></td>
<td ><div align="right">
<input type="button" name="Button" value="打印報(bào)表" class="button_all" onClick="print_onclick(2)"
style="width:100px">
</div>
</td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</form>
</BODY>
</HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -