bs_vote_add.asp

此系统都是基于ASP+ACCESS技术开发的电子商务平台,属于全自动化、全智能的在线方式管理、维护、更新的网站管理系统。此系统直接上传到你的网站空间就可以使用了

<!--#include file="bsconfig.asp"-->
<%
'=================================
'
'   冠龙科技 公司(企业)网站管理系统
'    Apollo  [e-mail] 
'        www.xnhost.cn
'
'  copyright(c)2006 LkStar
'
'=================================
%>
<%
dim Title,VoteTime,Action,IsSelected
dim rs,sql
Title=trim(request.form("Title"))
VoteTime=trim(request.form("VoteTime"))
if VoteTime="" then VoteTime=now()
Action=trim(request("Action"))
IsSelected=trim(request("IsSelected"))

dim i
if Title<>"" then
	sql="select top 1 * from Vote"
	Set rs= Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,3
	rs.addnew
	rs("Title")=Title
	for i=1 to 8
		if trim(request("select"&i))<>"" then
			rs("select"&i)=trim(request("select"&i))
			if request("answer"&i)="" then
				rs("answer"&i)=0
			else
				rs("answer"&i)=clng(request("answer"&i))
			end if
		end if
	next
	rs("VoteTime")=VoteTime
	rs("VoteType")=request("VoteType")
	if IsSelected="" then IsSelected=false
	if IsSelected="True" then conn.execute "Update Vote set IsSelected=False where IsSelected=True"
	rs("IsSelected")=IsSelected
	rs.update
	rs.close
	set rs=nothing
	call CloseConn()
	Response.Redirect "Bs_Vote.asp"
end if
%>
<!-- #include file="Inc/Head.asp" -->
<BR>
<table cellpadding="2" cellspacing="1" border="0" width="560" align="center" class="a2">
	<tr>
		<td class="a1" height="25" align="center"><strong>添 加 调 查</strong></td>
	</tr>
	<tr class="a4">
		<td align="center">
      <br>
			<form method="POST" action="Bs_Vote_Add.asp">
        <table width="500" border="0" align="center" cellpadding="0" cellspacing="2" Class="border">
          <tr class="tdbg"> 
            <td width="81" height="22" align="right" bgcolor="#C0C0C0">主题：</td>
            <td colspan="3" bgcolor="#E3E3E3">
							<input name="Title" type="text" size="45" maxlength="50"></td>
					</tr>
<% for i=1 to 8%>
					<tr class="tdbg"> 
            <td height="22" align="right" bgcolor="#C0C0C0">选项<%=i%>：</td>
            <td width="281" bgcolor="#E3E3E3">
							<input type="text" name="select<%=i%>" size="36"></td>
            <td width="41" align="right" bgcolor="#E3E3E3">票数：</td>
            <td width="87" bgcolor="#E3E3E3">
							<input type="text" name="answer<%=i%>" size="5"></td>
					</tr>
<%next%>
				  <tr class="tdbg"> 
            <td height="22" align="right" bgcolor="#C0C0C0">调查类型：</td>
            <td colspan="3" bgcolor="#E3E3E3">
						<select name="VoteType" id="VoteType">
							<option value="Single" selected>单选</option>
							<option value="Multi">多选</option>
						</select></td>
					</tr>
					<tr class="tdbg">
            <td height="22" align="right" bgcolor="#C0C0C0">&nbsp;</td>
            <td colspan="3" bgcolor="#E3E3E3">
							<input name="IsSelected" type="checkbox" id="IsSelected" value="True" checked>
							设为最新调查</td>
					</tr>
					<tr class="tdbg"> 
            <td height="25" colspan=4 align=center><BR>
              <input name="Submit" type="submit" id="Submit" value=" 添 加 "> 
							&nbsp; <input  name="Reset2" type="reset" id="Reset2" value=" 清 除 "> </td>
					</tr>
				</table>
			</form>
		</td>
	</tr>
</table>
<BR>
<%htmlend%>