<%
'商易仿淘宝4.0(多用户)
'ACCESS版演示网站：http://www.ftaobao.com(商易仿淘宝商城)
'SQL版演示网站：http://sql.ftaobao.com
'电话：0571-56907100
'QQ：1147100
%>
<body onLoad="show(C21),show(C22)">
<!--#include file="top.asp"-->
<%hy "login.asp"
left_open="shop"
'//是否已开店铺
set yz = conn.execute("select id,zt,name from shop where huiyuan='"&Request.Cookies(Rikee)("huiyuan")&"'")
if yz.eof then
Response.redirect "note.asp?errid=1"
Response.end
else
userid=yz(0)
username=yz(2)
Select case yz(1)
case "4"
Response.redirect "note.asp?errid=2"
Response.end
case "3"
Response.redirect "note.asp?errid=3"
Response.end
End Select
end if
yz.close:set yz=nothing%>

<table width="762" border="0" align="center" cellpadding="2" cellspacing="0" style='BORDER-COLLAPSE: collapse;MARGIN: 3px'>
  <tr> 
    <td height="22" colspan="2">您的位置： <A href="../index.asp">首页</A> &gt;&gt; <a href="index.asp">会员中心</a>&nbsp;&gt;&gt; <a href="rikeeshopindex.asp?abc=cpgl">商品管理</a> &gt;&gt; 过期商品</td>
  </tr>
  <tr> 
    <td width="180" valign="top">
<!--#include file="left.asp"-->
    </td>
	<%dim sj,sj2,sj_dw
	if shopnet("abc")<>"" and shopnet("id")<>"" then
	sjj=cint(request("sj"))
	sjj=cint(request("sj_dw"))
	newsj=Dateadd("h",sjj*sjj,sqlnow)
     Set rs = Server.CreateObject("ADODB.Recordset")
 	 sql="select * from chanpin where id ="&shopnet("id")
 	 rs.open sql,conn,3,2
	 if rs.eof then
     response.Write("<Script>alert('数据库没有此记录');window.location='auc_fend.asp';</script>")
	 else
	  rs("sj2")=newsj
	  rs.update
	  rs.close
	  set rs=nothing
	  response.Write("<Script>alert('商品重新上架成功,现转向到出售中商品页面');window.location='rikeeshopindex.asp?abc=cpgl';</script>")
	  response.end
	  end if
	  end if
%>
<td width="582" height="280" valign="top">
<%Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from chanpin where userid="&myuserid&" and sj2<now() order by sj desc"
rs.open sql,conn,3,1
%>
<!--#include file="../include/page.asp"-->
<%page1("10")%>
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td><table border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="1"><IMG SRC="../images/mytaobaobj1_3.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
            <td width="120" align="center" background="../images/mytaobaobj1_4.gif"><font color="#FFFFFF">过期商品</font><font color="#FFFFFF" span class="C">&nbsp;</font></td>
            <td width="1"><IMG SRC="../images/mytaobaobj1_6.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
          </tr>
        </table>
          <table border="0" align="left" cellpadding="0" cellspacing="0">
            <tr>
              <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
              <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="rikeeshopindex.asp?abc=cpgl">商品管理</a></span></font></td>
              <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
            </tr>
          </table>
        <table border="0" align="left" cellpadding="0" cellspacing="0">
            <tr>
              <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
              <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="buysell.asp?id=2">已卖商品</a></span></font></td>
              <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
            </tr>
        </table></td>
    </tr>
  </table>
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td height="4" bgcolor="1E88C1"></td>
    </tr>
  </table>
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td height="5"></td>
    </tr>
  </table>
  <br>
  <div align="center">
    <table width="100%" align="center" cellpadding="2" cellspacing="1" bgcolor="#cccccc">
      <tr align="center" valign="middle">
        <td width="104" height="21" background="../image/bk.gif" bgcolor="#efefef">重新结束时间</td>
        <td width="163" height="21" background="../image/bk.gif" bgcolor="#efefef">产品名称</td>
        <td width="28" height="21" background="../image/bk.gif" bgcolor="#efefef">审</td>
        <td width="57" height="21" align="center" nowrap="nowrap" background="../image/bk.gif" bgcolor="#efefef">方式</td>
        <td width="114" height="21" nowrap="nowrap" background="../image/bk.gif" bgcolor="#efefef">结束时间</td>
        <td width="69" height="21" nowrap="nowrap" background="../image/bk.gif" bgcolor="#efefef">重新上架</td>
      </tr>
      <%
	  
  if rs.eof then
  response.write "<tr><td colspan=6 align=center bgcolor=white height=21 valgin=middle>没有过期商品！</td></tr>"
  else	  
	  
	  
	  i=1
do while not rs.eof and i<=rs.pagesize%>
      <tr valign="middle"><form name="myform" method="post" action=?abc=yes>
        <td bgcolor="#FFFFFF"><input name="sj2" type="text" class="wenbenkuang" id="sj2" value="7" size="5" maxlength="3" />
            <select name="sj_dw" class="wenbenkuang" id="sj_dw">
              <option value="1">小时</option>
              <option value="24" selected="selected">天</option>
          </select></td>
        <td bgcolor="#FFFFFF"><%response.write "<a href=../merchandise.asp?id="&encode(rs("id"))&" target=_blank>·"&rs("mc")&"</a>"%></td>
        <td width="28" align="center" bgcolor="#FFFFFF"><%if rs("tui")<>0 then response.write "<font color=#ff6600>未</font>" else response.write "已" end if %></td>
        <td width="57" align="center" nowrap="nowrap" bgcolor="#FFFFFF"><%Select case rs("fs")
case 0
response.write "一口价"
case 1
response.write "<a href=?abc=pm&id="&rs("id")&">[拍卖]</a>"
case 2
response.write "议价"
End Select%>
          <input name="id" type="hidden" value="<%=rs("id")%>"></td>
        <td width="114" align="center" nowrap="nowrap" bgcolor="#FFFFFF"><%=rs("sj2")%></td>
        <td width="69" align="center" nowrap="nowrap" bgcolor="#FFFFFF"><input type="submit" name="Submit" value="提交" /></td></form>
      </tr>
      <%i=i+1
rs.MoveNext                                              
loop%>
      <tr align="center" valign="middle">
        <td height="21" colspan="6" background="../image/bk1.gif" bgcolor="#efefef"><%page2("abc=cpgl&keywords="&request("keywords")&"&xs="&request("xs")&"&")
rs.close:
end if 
%></td>
      </tr>
    </table>
    <br></div>

</td>
  </tr>
</table>
<br>
<!--#include file="../bottom.asp"-->
