<script language= "javascript">
function newpage(htmlurl) {
var newwin=window.open(htmlurl,"newWin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no,top=2,left=2,width=600,height=350");
newwin.focus();
return false;
}
</script>
<script language="JavaScript">
<!--
function checkvalue()
{
document.forms.page.value=""
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
// if (e.name != 'chkall')
e.checked = true// form.chkall.checked;
}
}
-->
</script>
sqlstr="select * from card"
if Uname<>"" then
sqlstr=sqlstr &" where name like '%"&Uname&"%' "
end if
if Ucard_sort<>"" then
if Uname<>"" then
sqlstr=sqlstr &" and card_sort like '%"&Ucard_sort&"%' "
else
sqlstr=sqlstr &" where card_sort like '%"&Ucard_sort&"%' "
end if
end if
if Ukeyword<>"" then
if Uname<>"" or Ucard_sort<>"" then
sqlstr=sqlstr &" and (company like '%"&Ukeyword&"%' or address like '%"&Ukeyword&"%' or principalship like '%"&Ukeyword&"%' or email like '%"&Ukeyword&"%') "
else
sqlstr=sqlstr &" where company like '%"&Ukeyword&"%' or address like '%"&Ukeyword&"%' or principalship like '%"&Ukeyword&"%' or email like '%"&Ukeyword&"%' "
end if
end if
UI_id = session("SI_id")
if Uname="" and Ucard_sort="" and Ukeyword="" then
sqlstr = sqlstr & " where card_user_id = '"&UI_id&"' "
else
sqlstr = sqlstr & " and card_user_id = '"&UI_id&"' "
end if
set rs=server.createobject("ADODB.Recordset")
rs.open sqlstr,conn,1,3
if rs.eof then
response.write "<center>没有找到符合要求的名片!</center>"
else
Rs.pagesize=pagesize
page=Request("page")
if (page-Rs.pagecount) > 0 then
page=Rs.pagecount
elseif page = "" or page < 1 then
page = 1
end if
Rs.absolutepage=page
%>
<table border="0" width="100%" align="center" >
<form action="envelope.asp" method="post" name="form">
<tr align="center" bgcolor="#999999">
<td width="9%"><input style="letter-spacing:-5 px;" type="button" value=" 全 选 " onClick="CheckAll(this.form)"></td>
<td width="18%"><strong>姓名</strong></td>
<td width="37%"><strong>单位</strong></td>
<td width="15%"><strong>名片类别</strong></td>
<td width="20%"><strong>电话</strong></td>
</tr>
<%
do while not rs.eof
i = i + 1
if i > Rs.pagesize then
exit do
end if
%>
<tr align="center" bgcolor="#CCCCCC">
<td><input name="card_id" type="checkbox" id="card_id" value="<%=rs("card_id")%>"></td>
<td width="18%"><%=rs("name")%></td>
<td width="37%" bgcolor="#CCCCCC"><%=rs("company")%></td>
<td width="15%"><%=rs("card_sort")%></td>
<td><%=rs("phone")%></td>
</tr>
<%rs.movenext
loop%>
<tr>
<td colspan="5" >
<div align="center">
<input type="hidden" value="*添加到信封打印列表" onClick="if(confirm('确认添加到信封打印列表么?')){form.action='envelope_to_list.asp';form.submit();}">
<span class="textbotton"><a onClick="form.action='envelope_to_list.asp';form.submit();" href="envelope_set.asp" target="_blank">预览@打印</a></span></div></td>
</tr>
</form>