📄 printpage.asp

📁 客户管理系统使用ASP.NET和Access
💻 ASP
字号:
<!--#include file="islogin.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
 margin:0px;
 FONT-SIZE: 12px;
 FONT-FAMILY: "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
 background-color: #BEBFD9;
 scrollbar-face-color: #EAEAF2;
 scrollbar-highlight-color: #FFFFFF;
 scrollbar-shadow-color: #9395C0;
 scrollbar-3dlight-color: #F3F3F8;
 scrollbar-arrow-color: #9395C0;
 scrollbar-track-color: #F3F3F8;
 scrollbar-darkshadow-color: #F3F3F8;

}
body,td,th {
	font-size: 12px;
	font-family: 宋体;
}
A:link {
	FONT-SIZE: 9pt; COLOR: #3366CC; FONT-FAMILY: 宋体; TEXT-DECORATION: none
}
A.green{
color:#009900
}
A:visited {
	FONT-SIZE: 9pt; COLOR: #4f4f30; FONT-FAMILY: 宋体; TEXT-DECORATION: none
}
A:active {
	FONT-SIZE: 9pt; COLOR: #4f4f30; FONT-FAMILY: 宋体; TEXT-DECORATION: none
}
A:hover {
	FONT-SIZE: 9pt; COLOR: #3333CC; FONT-FAMILY: 宋体; TEXT-DECORATION: underline
}
.table_1
{
    BORDER: 1PX #5C609E SOLID ; 
    FONT: 12PX;
    WIDTH:95%;
}
.table_1_inc
{
    FONT: 12PX;
    WIDTH:100%;
	FONT-FAMILY: "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
}

.table_1_top 
{
    BORDER-BOTTOM: 1PX #5C609E SOLID ; 
	FONT: 12PX;
	FONT-FAMILY: "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
	COLOR:#FFFFFF;
	BACKGROUND-COLOR: #BEBFD9;
}
/*按纽*/
a.nnsonet_button {	
			font-size: 12px;	
			font-family: "宋体";	
			padding: 4px 8px;	
			border-top: 1px solid white;	
			border-right: 1px solid black;	
			border-bottom: 1px solid black;	
			border-left: 1px solid white;	
			text-align: center;	
			min-width: 75px;
			color: #000000;
			line-height: 300%;
			}
a.nnsonet_button:link { 	
			background-color: #D9D9D9; 	
			color: #000;	
			text-decoration: none;
						line-height: 300%;
			}
a.nnsonet_button:visited {	
			background-color: #D9D9D9; 	
			color: #000000;	
			text-decoration: none;	
			line-height: 300%;
			}
a.nnsonet_button:hover { 	
			background-color: #CCCCCC; 	
			color: #333333;	
			border-color: black white white black;	
			text-decoration: none;	
						line-height: 300%;
			}
a.nnsonet_button:active { 	
			background-color: #D9D9D9; 	
			color: #000000;	
			text-decoration: none;	
			line-height: 300%;
			}
.Font1 {
    line-height:18px;
}
/*div总局*/
#content{
width: 750px;
margin: 0 auto;
overflow: hidden;
}
#list{
width: 580px;
float: right;?
background: #FFF;
text-align: left;
}
#menu{
width: 170px;
float: left;
background: #F0F0F0;
text-align: left;
}
/* easy clearing */
#content:after
{
content: '[DO NOT LEAVE IT IS NOT REAL]'; 
display: block; 
height: 0; 
clear: both; 
visibility: hidden;
}
#content
{
display: inline-block;
}
/*\*/
#content
{
display: block;
}
/* end easy clearing */
/*\*/
#list, #menu
{
padding-bottom: 32767px !important;
margin-bottom: -32767px !important; 
}
@media all and (min-width: 0px) {
#list, #menu
{
padding-bottom: 0 !important;
margin-bottom: 0 !important; 
}
#list:before, #menu:before
{
content: '[DO NOT LEAVE IT IS NOT REAL]';
display: block;
background: inherit;
padding-top: 32767px !important;
margin-bottom: -32767px !important;
height: 0;
}
}
/**/

h1,h2,p{
margin: 0;
padding: .8em;
}
h1,h2{font-size: 20px;}
.formbox-comment {
	BORDER-RIGHT: #bad1da 1px solid; BORDER-TOP: #bad1da 1px solid; MARGIN-TOP: 10px; BACKGROUND: url(../images/bg2.gif) #fbfcfd repeat-x 0px 25px; BORDER-LEFT: #bad1da 1px solid; BORDER-BOTTOM: #bad1da 1px solid
}
-->
</style></head>

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" class="table_1_inc">
        <tr align="center" valign="middle" <%if (ww mod 2)=1 then%>bgcolor="#F8F8FA"<%end if%> >
          <td width="68" height="25" align="left"><strong>跟单人</strong></td>
          <td width="200" align="left"><strong>公司名称</strong></td>
          <td width="200" align="left"><strong>地址</strong></td>
          <td width="100" align="left"><strong>电话</strong></td>
          <td width="100" align="left"><strong>传真</strong></td>
          <td width="100" align="left"><strong>联系人</strong></td>
          <td><strong>时间</strong></td>
        </tr>
<%
v_date=date
set rs=server.createobject("adodb.recordset")
sql="select id,Member,Memberid,Company,Cadd,Ctel,Cfax,Cname,addtime from KH where left(cstr(addtime),10)='"&v_date&"' Order by Member"
rs.open sql,conn,1,1
%>        <% do while not rs.eof %>
        <tr align="center" <%if (ww mod 2)=1 then%>bgcolor="#F8F8FA"<%end if%> >
          <td align="left"><%=rs("Member")%></td>
          <td align="left"><%=rs("Company")%></td>
          <td align="left"><%=left(rs("Cadd"),25)%></td>
          <td align="left"><%=left(rs("Ctel"),25)%></td>
          <td align="left"><%=left(rs("Cfax"),25)%></td>
          <td align="left"><%=left(rs("Cname"),25)%></td>
          <td><%=formatDateTime(rs("addtime"),2)%></td>
        </tr>
   <%
   rs.movenext 
   loop
   %>
    </table></td>
  </tr>
</table>
<br>
</body>
</html>
<%
  rs.close
  set rs=nothing
  conn.close
  set conn=nothing
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -