pmcjc.asp

本网上拍卖系统选用ASP + SQL Server进行开发, 是一个基于Brower/ Server (浏览器/ 服务器) 并采用C2C (Customer to Customer 即个人——个人)运

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		<form action="pmcjcasp.asp" method="post">
<table border="0" width="675" height="510" id="table3">


	<tr>
		<td bgcolor="#C0C0C0" align="center" valign="top"> 
      <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="799AE1" id="table4" height="402">
     
 <%
     
SqlDatabaseName = "paimai"            			      '数据库名
SqlUsername = "sa"                                    '用户名
SqlPassword = " "                                      '用户密码
Dim Conn,ConnStr
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider = Sqloledb; Persist Security Info=false; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & ";"
Conn.Open ConnStr
     
	sql="select * from [ppm] where pdtid='"&request("pdtid")&"';"
	set rs=Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,1	'以写入方式打开
	session("pdtid")=rs("pdtid")
	session("pdtname")=rs("pdtname")
	session("pdtowner")=rs("pdtowner")
	session("pdtdesc")=rs("pdtdesc")
    session("pdtstart")=rs("pdtstart")
	session("pdtend")=rs("pdtend")
    session("pdtstartpri")=rs("pdtstartpri")
	session("pdtadd")=rs("pdtadd")
    
	
%>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="189" height="257" rowspan="5"><img src=<%=rs("pdtimage")%> width=189 height=257  ></td>
			<td width="106" height="44">
			<div align="center"><font color="#FF0000" size="1" face="幼圆">商品名称</font></div></td>
			<td width="357" height="44" colspan="3">
			<font size="1" face="幼圆" color="#FF0000"><%=rs("pdtname")%></font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="106" height="39">
			<font color="#FF0000" size="1" face="幼圆">商品描述</font></td>
			<td width="357" height="39" colspan="3">
			<font size="1" face="幼圆" color="#FF0000"><%=rs("pdtdesc")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="106" height="44">
			<font color="#FF0000" size="1" face="幼圆">商品底价</font></td>
			<td width="109" height="44">
			<font size="1" color="#FF0000" face="幼圆"><%=rs("pdtstartpri")%>　元</font></td>
			<td width="113" height="44">
			<font color="#FF0000" size="1" face="幼圆">商品新旧</font></td>
			<td width="129" height="44">
			<font size="1" face="幼圆" color="#FF0000"><%=rs("pdtoldnew")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="106" height="47">
			<font color="#FF0000" size="1" face="幼圆">加幅价格</font></td>
			<td width="109" height="47">
			<font size="1" color="#FF0000" face="幼圆"><%=rs("pdtadd")%>　元</font></td>
			<td width="113" height="47">
			<font color="#FF0000" size="1" face="幼圆">所有者</font></td>
			<td width="129" height="47"><a href="owner.asp?pdtowner=<%=rs("pdtowner")%>">
			<font size="1" face="幼圆" color="#FF0000"><%=rs("pdtowner")%></font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="106" height="40">
			<font color="#FF0000" size="1" face="幼圆">商品起拍时间</font></td>
			<td width="109" height="40">
			<font size="1" face="幼圆" color="#FF0000">　<%=rs("pdtstart")%></font></td>
			<td width="113" height="40">
			<font color="#FF0000" size="1" face="幼圆">商品结束时间</font></td>
			<td width="129" height="40">
			<font size="1" face="幼圆" color="#FF0000">　<%=rs("pdtend")%></font></td>
		</tr>

        <tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="18" colspan="5" valign="top">　<p>　　　　　　　　　　　　　　　　　　　　　　<b><font size="2" face="幼圆" color="#FF0000"><a href="pmcjck1.asp?pdtid=<%=rs("pdtid")%>"><font color="#FF0000">查看出价情况</font></a></font></b></td>
			<td height="142" rowspan="4">　</td>
		</tr>
<%
rs.close
set rs=nothing
%>

		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="23" colspan="5">
				<p><font face="幼圆" size="1" color="#FF0000"><input type="text" name="bidprice" size="20">　　我的出价</font></p>
			
			</td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="24" colspan="5">
				<p><font face="幼圆" size="1" color="#FF0000"><input type="text" name="bidtime" size="20" value="<% Response.write year(now()) & "." & month(now()) & "." & day(now())%>">　　购买时间　</font></p>
			
			</td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="72" colspan="5" rowspan="2">
			<input type="submit" value="出价" name="submit" ></td>
		</tr>
		
		</table>
		</td>
		 
	</tr>
	 
</table>