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>&nbsp;&nbsp;&nbsp;&nbsp;该产品尚未经过管理员审核,不能加入拍卖。")
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>&nbsp;&nbsp;&nbsp;&nbsp;该产品正在拍卖中,不能重复加入。如果想中途停止拍卖,请联系"&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>&nbsp;&nbsp;&nbsp;已成功将该产品加入拍卖场,系统正在转向到拍卖查看页...")
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>&nbsp;<span class="STYLE4">(添加信息前请查看网页下方的备注)</span></td>
    </tr>
    <tr valign="middle"> 
      <td width="120" height="25" align="center" bgcolor="#E8F1FF">产品名称</td>
      <td height="25" bgcolor="#E8F1FF">&nbsp;<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">&nbsp; </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 + -
显示快捷键?