admin_product.asp

该软件是帮助大学生更好的生活

    down_remark=code_admin(request.form("down_remark"))
    if isnumeric(csid) or len(csid)<1 then
      response.write "<font class=red_2>请选择产品类型！（二级分类）</font><br><br>"&go_back
    elseif len(name)<1 or not(isnumeric(price_1)) or not(isnumeric(price_2)) then
      response.write "<font class=red_2>产品名称和产品价格不能为空！</font><br><br>"&go_back
    elseif len(remark_1)>250 then
      response.write "<font class=red_2>产品简介不能超过250个字！</font><br><br>"&go_back
    else
      cid=mid(csid,1,instr(csid,"-")-1)
      sid=mid(csid,instr(csid,"-")+1,len(csid))
      set rs=server.createobject("adodb.recordset")
      sql="select * from "&data_name
      rs.open sql,conn,1,3
      rs.addnew
      rs("c_id")=cid
      rs("s_id")=sid
      rs("name")=name
      rs("remark_1")=remark_1
      rs("remark_2")=remark_2
      rs("price_1")=price_1
      rs("price_2")=price_2
      if len(smallimg)<3 then smallimg="no_pic.gif"
      rs("smallimg")=smallimg
      if len(bigimg)<3 then bigimg="no_pic.gif"
      rs("bigimg")=bigimg
      rs("serial")=serial
      rs("brand")=brand
      rs("stock")=stock
      rs("down_url")=down_url
      rs("down_remark")=down_remark
      if isgood="yes" then
        rs("isgood")=true
      else
        rs("isgood")=false
      end if
      if hidden="yes" then
        rs("hidden")=false
      else
        rs("hidden")=true
      end if
      rs("tim")=now_time
      rs("counter")=0
      rs("buy_counter")=0
      rs.update
      rs.close:set rs=nothing
      call upload_note(data_name,first_id(data_name))
      response.write "<font class=red>已成功添加了一个产品！</font><br><br><a href='?c_id="&cid&"&s_id="&sid&"'>点击返回</a><br><br>"
    end if
  else
%>
<form name='add_frm' action='<%response.write pageurl%>add=chk' method=post>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr><td colspan=10 class="title" align=center height=22><b>添加产品</b><input type=hidden name=upid value=''></td></tr>
  <tr class="tdbg"> 
    <td width='40%' align=right>产品名称：</td>
    <td width='60%'><input type=text size=70 name=name maxlength=50><%=redx%></td></tr>
  <tr class="tdbg"> 
    <td align=right>产品类型：</td>
    <td><select name=csid size=1><%
sql="select c_id,c_name from product_class where nsort='"&nsort&"' order by c_order,c_id"
set rs=conn.execute(sql)
do while not rs.eof
  nid=int(rs(0))
  response.write vbcrlf&"<option value='"&nid&"' class=bg_2>"&rs(1)&"</option>"
  sql2="select s_id,s_name from product_sort where c_id="&nid&" order by s_order,s_id"
  set rs2=conn.execute(sql2)
  do while not rs2.eof
    now_id=int(rs2(0))
    response.write vbcrlf&"<option value='"&nid&"-"&now_id&"'"
    if cid=nid and sid=now_id then response.write " selected"
    response.write ">　"&rs2(1)&"</option>"
    rs2.movenext
  loop
  rs2.close:set rs2=nothing
  rs.movenext
loop
rs.close:set rs=nothing
ispic=upload_time(now_time)
%></select><%=redx%>选择二级目录才有效&nbsp;&nbsp;&nbsp;&nbsp;<input type=checkbox name=isgood value='yes'>选为推荐&nbsp;&nbsp;&nbsp;&nbsp;<input type=checkbox name=hidden value='yes'>选为隐藏</td></tr>
  <tr class="tdbg"> 
  <td align=right>市场价格：</td><td><input type=text size=15 name=price_1 maxlength=10>&nbsp;&nbsp;&nbsp;&nbsp;会员价格：<input type=text size=15 name=price_2 maxlength=10>&nbsp;&nbsp;<%response.write redx%>（价格只能为数字）</td></tr>
  <tr class="tdbg"><td align=right>产品品牌：</td><td><input type=text size=15 name=brand maxlength=20>&nbsp;&nbsp;&nbsp;&nbsp;产品编号：<input type=text size=15 name=serial maxlength=20>&nbsp;&nbsp;库存：<select name=stock size=1>
<option>有货</option>
<option>紧张</option>
<option>暂缺</option>
</select>&nbsp;&nbsp;</td></tr>
  <tr class="tdbg"><td align=right>相关下载：</td><td><input type=text size=70 name=down_url maxlength=100></td></tr>
  <tr class="tdbg"><td align=right>下载说明：</td><td><input type=text size=70 name=down_remark maxlength=50></td></tr>
  <tr class="tdbg"><td valign=top align=right><br>产品简介：<br>(少于250汉字)</td><td><textarea name=remark_1 rows=5 cols=70></textarea></td></tr>
  <tr class="tdbg" height=35<%response.write format_table(3,1)%>><td align=right><%call frm_ubb_type()%></td><td><%call frm_ubb("add_frm","remark_2","&nbsp;&nbsp;")%></td></tr>
  <tr class="tdbg"><td valign=top align=right><br>详细说明：</td><td><textarea name=remark_2 rows=8 cols=70></textarea></td></tr>
  <tr class="tdbg"><td align=right>上传图片&nbsp;<br>到详细说明内容：</td><td>
    <table border=0 width='100%' cellspacing=0 cellpadding=0>
      <tr><td><iframe frameborder=0 name=upload_frame width='100%' height=30 scrolling=no src='upload_product.asp?uppath=product&upname=a&uptext=remark_2'></iframe></td></tr>
	</table></td></tr>
  <tr class="tdbg"><td align=right valign=top>产品小图片：</td><td>
    <table border=0 width='100%' cellspacing=0 cellpadding=0>
     <tr><td><input type=text name=pics size=40 maxlength=50></td></tr>
     <tr><td><iframe frameborder=0 name=upload_frames width='100%' height=30 scrolling=no src='upload_product.asp?uppath=product&upname=<%response.write "ps"&ispic%>&uptext=pics'></iframe></td></tr>
     </table></td></tr>
  <tr class="tdbg"><td align=right valign=top>产品大图片：</td><td>
      <table border=0 width='100%' cellspacing=0 cellpadding=0>
        <tr><td><input type=text name=picb size=40 maxlength=50></td></tr>
        <tr><td><iframe frameborder=0 name=upload_frame width='100%' height=30 scrolling=no src='upload_product.asp?uppath=product&upname=<%response.write "pb"&ispic%>&uptext=picb'></iframe></td></tr>
      </table></td></tr>
  <tr class="tdbg"><td colspan=2 align=center height=25><input type=submit value=' 添 加 '></td></tr>
</table></form><%
  end if
end sub

sub news_main()
%>
<script language=javascript src='inc_shop/admin_del.js'></script>
<table border=0 width='80%' cellpadding=2 align=center>
  <tr valign=top>
    <td width='1%' nowrap><br>
	<img src="images/arrow.gif" border=0 align=absmiddle><a href="?">所有产品</a><br>
<%
  sql="select c_id,c_name from product_class where nsort='"&nsort&"' order by c_order,c_id"
  set rs=conn.execute(sql)
  do while not rs.eof
    nid=int(rs(0))
    if cid=nid then
      response.write vbcrlf&img_small("jt1")&"<a href='?c_id="&nid&"'><b><font class=red_3>"&rs(1)&"</b></font></a><br>"
    else
      response.write vbcrlf&img_small("jt0")&"<a href='?c_id="&nid&"'><font class=red_3>"&rs(1)&"</font></a><br>"
    end if
    sql2="select s_id,s_name from product_sort where c_id="&nid&" order by s_order,s_id"
    set rs2=conn.execute(sql2)
    do while not rs2.eof
      now_id=int(rs2(0))
      if sid=now_id then
        response.write vbcrlf&"　<a href='?c_id="&nid&"&s_id="&now_id&"'><font class=bluee>"&rs2(1)&"</a></a><br>"
      else
        response.write vbcrlf&"　<a href='?c_id="&nid&"&s_id="&now_id&"'>"&rs2(1)&"</a><br>"
      end if
      rs2.movenext
    loop
    rs2.close:set rs2=nothing
    rs.movenext
  loop
  rs.close
%></td>
    <td width='99%' align=center>
<form name=del_form action='<%=pageurl%>del_ok=ok' method=post>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<%
  if cid<>0 then
    sqladd=" where c_id="&cid
    pageurl=pageurl&"c_id="&cid&"&"
    if sid<>0 then
      sqladd=sqladd&" and s_id="&sid
      pageurl=pageurl&"s_id="&sid&"&"
    end if
  end if
  sql="select id,c_id,s_id,name,isgood,hidden from "&data_name&sqladd&" order by id desc"
  set rs=server.createobject("adodb.recordset")
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
    rssum=0
  else
    rssum=rs.recordcount
  end if
  if rssum mod nummer > 0 then
    thepages=rssum\nummer+1
  else
    thepages=rssum\nummer
  end if
  page=trim(request.querystring("page"))
  if not(isnumeric(page)) then page=1:viewpage=1
  if int(page)>thepages then
    viewpage=1
  else
    viewpage=page
  end if
  del_temp=nummer
  if rssum=0 then del_temp=0
  if int(page)=int(thepages) then
    del_temp=rssum-nummer*(thepages-1)
  end if
  if int(viewpage)<>1 then
    rs.move (viewpage-1)*nummer
  end if
  response.write "<tr class=title align=center height=22>" &_
                 "<td nowrap>序号</td><td norwap width='99%'>产品名称</td><td nowrap>显示</td><td nowrap>推荐</td><td nowrap>选择</td></tr>"
  for i=1 to nummer
    if rs.eof then exit for
    now_id=rs("id"):ncid=rs("c_id"):nsid=rs("s_id")
    response.write article_center()
    rs.movenext
  next
  response.write "<tr class=tdbg><td colspan=10 align=center>" & _
		 vbcrlf & "本栏现有<font class=red>"&rssum&"</font>个产品┋" & _
		 vbcrlf & "共<font class=red>"&thepages&"</font>页┋" & _
		 vbcrlf & "这是第<font class=red>"&viewpage&"</font>页┋<a href='?action=add&c_id="&cid&"&s_id="&sid&"'>发布产品</a></td></tr>" & _
		 vbcrlf & "<tr class=tdbg><td colspan=10 height=25 align=center>分页："&jk_pagecute(nummer,thepages,viewpage,pageurl,6,"#ff0000") & _
		 "　<input type=checkbox name=del_all value=1 onClick=selectall('"&del_temp&"')> 选中所有　<input type=submit value='删除所选' onclick=""return suredel('"&del_temp&"');""></td></tr>"
  rs.close:set rs=nothing
%>
</table></form>
    </td>
  </tr>
</table>
<%
end sub

function article_center()
  article_center="<tr class=tdbg>" & _
		"<td align=center>" & i+(viewpage-1)*nummer & ". </td><td>" & _
		 "<a href='?action=edit&c_id="&ncid&"&s_id="&nsid&"&id=" & now_id & "'>" & cuted(rs("name"),30) & "</a>" & _
		 "</td><td align=center><a href='?action=hidden&c_id="&cid&"&s_id="&sid&"&id="&now_id&"'>"
  if rs("hidden")=true then
    article_center=article_center&"显"
  else
    article_center=article_center&"<font class=red_2>隐</font>"
  end if
  article_center=article_center&"</a></td><td align=center><a href='?action=isgood&c_id="&cid&"&s_id="&sid&"&id="&now_id&"'>"
  if rs("isgood")=true then
    article_center=article_center&"<font class=red>是</font>"
  else
    article_center=article_center&"否"
  end if
  article_center=article_center&"</a></td><td align=center><input type=checkbox name=del_id value='"&now_id&"'></td></tr>"
end function
%>