paimai_add.asp
来自「电子商务系统Easy_Buy是一个在线销售系统」· ASP 代码 · 共 145 行
ASP
145 行
<!--#include file="0.asp"-->
<!--#include file="../../conn/conn.asp" -->
<!--#include file="../../conn/je.asp"-->
<%
'只有经过管理员审核的产品才能加入拍卖
if conn.execute("select tui from chanpin where id="&request("id")&"")(0)<>0 then
Response.Write("<br><br> 该产品尚未经过管理员审核,不能加入拍卖。")
Response.end
end if
'正在拍卖的产品不能重复
if conn.execute("select count(id) from paimai_cp where cpid="&request("id")&" and p_zt=0")(0)>0 then
Response.Write("<br><br> 该产品正在拍卖中,不能重复加入。如果想中途停止拍卖,请联系"&my_name&"工作人员。")
Response.end
end if
'处理拍卖品
if request("add")="yes" then
if request("p_jg1")="" or not(isnumeric(request("p_jg1"))) or request("p_jg2")="" or not(isnumeric(request("p_jg2"))) or request("sj")="" or not(isnumeric(request("sj"))) then
response.write "错误提示:拍卖底价、竞价幅度、结拍时间不能为空,不只是数值。"
response.end
else
set cp= conn.execute("select * from chanpin where id="&request("id")&"")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from paimai_cp"
rs.open sql,conn,1,3
rs.addnew
rs("cpid")=cp("id")
rs("lbid")=cp("lbid")
rs("userid")=cp("userid")
rs("mc")=cp("mc")
rs("xt")=cp("xt")
rs("zt")=cp("zt")
rs("dt")=cp("dt")
rs("jp")=cp("jp")
rs("js")=cp("js")
rs("p_jg1")=request("p_jg1")
rs("p_jg2")=request("p_jg2")
rs("p_jg3")=request("p_jg1")
rs("sj2")=dateadd("h",request("sj"),now())
rs.update
rs.close
cp.close
'加到另一个数据库
set rsr=server.createobject("adodb.recordset")
sqls="select ss from chanpin where id='"&request("id")&"'"
rsr.open sqls,conn,1,3
rsr("ss")="1"
rsr.addnew
Response.Write("<meta http-equiv=refresh content=1;url=paimai.asp><br><br> 已成功将该产品加入拍卖场,系统正在转向到拍卖查看页...")
Response.end
end if
end if%>
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<STYLE>
BODY {
SCROLLBAR-FACE-COLOR: #799ae1;
SCROLLBAR-HIGHLIGHT-COLOR: #799ae1;
SCROLLBAR-SHADOW-COLOR: #799ae1;
SCROLLBAR-3DLIGHT-COLOR: #799ae1;
SCROLLBAR-ARROW-COLOR: #fcfcfc;
SCROLLBAR-TRACK-COLOR: #aabfec;
SCROLLBAR-DARKSHADOW-COLOR: #799ae1;
SCROLLBAR-BASE-COLOR: #799ae1;
background-color: #CAD7F7;
}
.STYLE3 {
color: #FFFFFF;
font-weight: bold;
}
.STYLE4 {color: #FFFFFF}
</STYLE>
<form action=?add=yes method="post" name="myform" id="myform">
<script language="javascript">
<!--//
function checksignup() {
if ( document.myform.p_jg1.value == '' ) {
window.alert('请输入产品拍卖底价!!');
document.myform.p_jg1.focus();
}
else if ( document.myform.p_jg2.value == '' ) {
window.alert('请输入加价幅度,单位为元!!');
document.myform.p_jg2.focus();
}
else if (isNaN( document.myform.p_jg1.value)) {
window.alert('请输入产品拍卖底价,只能是数字!!');
document.myform.p_jg1.focus();
}
else if (isNaN( document.myform.p_jg2.value)) {
window.alert('请输入加价幅度,只能是数字!!');
document.myform.p_jg2.focus();
}
else if ( document.myform.sj.value == '' ) {
window.alert('请输入结拍时间!!');
document.myform.sj.focus();
}
else if (isNaN( document.myform.sj.value)) {
window.alert('请输入结拍时间,只能是数值!!');
document.myform.sj.focus();
}
else {
return true;
}
return false;
}
//-->
</script>
<br>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr valign="middle" bgcolor="#f1f1f1">
<td height="25" colspan="2" background="../../images/admin_bg_11.gif"><span class="STYLE3"> 加入拍卖场</span> <span class="STYLE4">(添加信息前请查看网页下方的备注)</span></td>
</tr>
<tr valign="middle">
<td width="120" height="25" align="center" bgcolor="#E8F1FF">产品名称</td>
<td height="25" bgcolor="#E8F1FF"> <b><font color="#FF6600"><%=conn.execute("select mc from chanpin where id="&request("id")&"")(0)%></font></b></td>
</tr>
<tr valign="middle">
<td width="120" height="25" align="center" bgcolor="#E8F1FF">拍卖底价</td>
<td height="25" bgcolor="#E8F1FF"> <input name="p_jg1" type="text" id="p_jg1" size="10" maxlength="20">
(拍卖起价)拍卖品开始叫价的起拍价格 </td>
</tr>
<tr valign="middle">
<td height="25" align="center" bgcolor="#E8F1FF">加价幅度</td>
<td height="25" bgcolor="#E8F1FF"><input name="p_jg2" type="text" id="p_jg2" size="10" maxlength="20">
每次竞价的最低加价</td>
</tr>
<tr valign="middle">
<td height="25" align="center" bgcolor="#E8F1FF">结拍时间</td>
<td height="25" bgcolor="#E8F1FF"><input name="sj" type="text" id="sj" value="1" size="5" maxlength="3">
小时,时间一到系统将自动结拍,并自动发信通知中标方和拍卖方</td>
</tr>
<tr valign="middle">
<td width="120" height="25" align="center" bgcolor="#E8F1FF"> </td>
<td height="25" bgcolor="#E8F1FF"> <p>
<input name="Submit" type="submit" value="提交" ONCLICK="javascript:return checksignup()">
<input name="Submit2" type="reset" value="重置">
<input name="id" type="hidden" id="id" value="<%=request("id")%>">
</p></td>
</tr>
</table>
<table width="99%" align="center">
<tr>
<td><font color="#FF6600"><strong>注:</strong></font>凡拍卖的商品时间结束,后请查看商品情况。</td>
</tr>
</table><br>
</form><% set s=nothing %>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?