admin_vote.asp

后台登陆admin.asp

            <td colspan="2"> 
              <input type="text" name="vt_expiredate" size="30" class="textarea" value="<%=rs("vt_expiredate")%>">
            </td>
          </tr>
          <tr class=Hxcmsqs> 
            <td colspan="3"><a href="admin_vote.asp?action=newitem&id=<%=rs("vt_id")%>">新增投票选项</a></td>
          </tr>
         <%sql="select * from voteitem where vt_id="&cint(request.querystring("id"))
           set rs2=server.createobject("adodb.recordset")
           rs2.open sql,conn,1,1
           do while not rs2.eof%>
          <tr class=Hxcmsds> 
            <td width="18%">投票选项</td>
            <td width="57%"><%=rs2("item_name")%> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="newshead"><%=rs2("item_count")%></span>票</td>
            <td width="25%" align="center"><a href="admin_vote.asp?action=edititem&id=<%=rs2("item_id")%>&vt_id=<%=request.querystring("id")%>">编辑</a> 
              <a href="admin_vote.asp?action=delitem&id=<%=rs2("item_id")%>&vt_id=<%=request.querystring("id")%>">删除</a></td>
          </tr>
         <%rs2.movenext
           loop
           if rs2.eof and rs2.bof then%>
          <tr class=Hxcmsds> 
            <td colspan="3">当前没有投票选项！</td>
          </tr>
         <%end if
           rs2.close
           set rs2=nothing%>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="3">
              <input type="submit" name="Submit" value="确定修改" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button">
            </td>
          </tr>
          <input type="hidden" name="id" value="<%=rs("vt_id")%>">
          <input type="hidden" name="action" value="editvote">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%
rs.close
set rs=nothing
end if
'================www.ynsky.com.cn===============
if request.querystring("action")="newitem" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('你必须指定操作的对象！');history.back(1);</script>")
  response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("id"))
set rs=conn.execute(sql)%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
   <form name="form3" method="post" action="">
	<tr class=Hxcmsss> 
          <td colspan="2">新增投票选项</td>
        </tr>
        <tr class=Hxcmsds> 
          <td width="13%">所属主题</td>
          <td width="87%"><%=rs("vt_name")%></td>
        </tr>
        <tr class=Hxcmsds> 
          <td>选项名称</td>
          <td><input type="text" name="item_name" size="40" maxlength="50" class="textarea"></td>
        </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2">
              <input type="submit" name="Submit" value="确定新增" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button"></td>
        </tr>
		<input type="hidden" name="id" value="<%=rs("vt_id")%>">
		<input type="hidden" name="action" value="newitem">
		<input type="hidden" name="MM_insert" value="true">
	</form>
      </table>
<%rs.close
set rs=nothing
end if
'================www.ynsky.com.cn===============
if request.querystring("action")="edititem" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('你必须指定操作的对象！');history.back(1);</script>")
  response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("vt_id"))
set rs=conn.execute(sql)
sql="select item_id,item_name from voteitem where item_id="&cint(request.querystring("id"))
set rs2=conn.execute(sql)%>
 <table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
        <form name="form3" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">修改投票选项</td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="13%">所属主题</td>
            <td width="87%"><%=rs("vt_name")%>　</td>
          </tr>
          <tr class=Hxcmsds> 
            <td>选项名称</td>
            <td><input type="text" name="item_name" size="40" maxlength="50" class="textarea" value="<%=rs2("item_name")%>"></td>
          </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2"> 
              <input type="submit" name="Submit" value="确定修改" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button">
              [<a href="admin_vote.asp?action=vote&caction=edit&id=<%=request.querystring("vt_id")%>">返回</a>] 
            </td>
          </tr>
          <input type="hidden" name="vtid" value="<%=rs("vt_id")%>">
          <input type="hidden" name="id" value="<%=rs2("item_id")%>">
          <input type="hidden" name="action" value="edititem">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
'================www.ynsky.com.cn===============
if request.querystring("action")="delitem" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('你必须指定操作的对象！');history.back(1);</script>")
  response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("vt_id"))
set rs=conn.execute(sql)
sql="select item_id,item_name from voteitem where item_id="&cint(request.querystring("id"))
set rs2=conn.execute(sql)%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
   <form name="form3" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">删除投票选项</td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="13%">所属主题</td>
            <td width="87%"><%=rs("vt_name")%>　</td>
          </tr>
          <tr class=Hxcmsds> 
            <td>选项名称</td>
            <td><%=rs2("item_name")%> 　</td>
          </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2"> 
              <input type="submit" name="Submit" value="确定删除" class="button">
              [<a href="admin_vote.asp?action=vote&caction=edit&id=<%=request.querystring("vt_id")%>">返回</a>] </td>
          </tr>
          <input type="hidden" name="vtid" value="<%=rs("vt_id")%>">
          <input type="hidden" name="id" value="<%=rs2("item_id")%>">
          <input type="hidden" name="action" value="delitem">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
'================www.ynsky.com.cn===============
if request.querystring("action")="vote" and request.querystring("caction")="del" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('你必须指定操作的对象！');history.back(1);</script>")
  response.end
end if
sql="select * from votetopic where vt_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
 <table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">删除投票主题</td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="18%">主题名称</td>
            <td width="82%"> <%=rs("vt_name")%> 　</td>
          </tr>
          <tr class=Hxcmsds> 
            <td>开始日期</td>
            <td> <%=rs("vt_startdate")%> 　</td>
          </tr>
          <tr class=Hxcmsds> 
            <td>过期日期</td>
            <td> <%=rs("vt_expiredate")%> 　</td>
          </tr>
          <%sql="select * from voteitem where vt_id="&cint(request.querystring("id"))
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof
%>
          <tr class=Hxcmsds> 
            <td width="18%">投票选项</td>
            <td width="82%"><%=rs2("item_name")%> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="newshead"><%=rs2("item_count")%></span>票</td>
          </tr>
          <%rs2.movenext
            loop
            if rs2.eof and rs2.bof then%>
          <tr class=Hxcmsds> 
            <td colspan="2">当前没有投票选项！</td>
          </tr>
          <%end if
            rs2.close
            set rs2=nothing%>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2"> 
              <input type="submit" name="Submit" value="确定删除" class="button">
              [<a href="admin_vote.asp?action=vote">返回</a>] </td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("vt_id")%>">
          <input type="hidden" name="action" value="delvote">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%
rs.close
set rs=nothing
end if
'================www.ynsky.com.cn===============
if request.querystring("action")="vote" and request.querystring("caction")="ipdel" then
	Sql = "delete from vcount"
        Conn.Execute(Sql)
        response.Write "<script>alert('清空投票IP成功！');this.location.href='admin_vote.asp?action=vote';</script>"
        Response.End
End If
end if

'****************************************************
%>