<%Admin="vote"%>
<!--#include file="check.asp"-->
<!--#include file="inc/config.asp"-->
<!--#include file="mdb.asp"-->
<!--#include file="inc/FORMAT.asp"-->
<%
if session("adminlogin")<>sessionvar then
  Response.Write("<script language=javascript>alert('你尚未登錄，或者超時了！請重新登錄');this.top.location.href='admin.asp';</script>")
  response.end
else
if request.form("MM_insert") then
 if request.form("action")="newvote" then
  dim vtname,startdate,expiredate
  vtname=trim(replace(request.form("vt_name"),"'",""))
  startdate=request.form("vt_startdate")
  expiredate=request.form("vt_expiredate")
  if vtname="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須填寫投票主題！');history.back(1);</script>")
  end if
  if startdate="" then
    startdate=formatdatetime(now(),2)
  else
    startdate=formatdatetime(startdate,2)
  end if
  if expiredate="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須填寫該投票主題的過期日期！');history.back(1);</script>")
  else
    expiredate=formatdatetime(expiredate,2)
  end if
  
  if founderr then
    call diserror()
	response.end
  else
	sql="select * from votetopic"
	set rs=server.createobject("adodb.recordset")
	rs.open sql,conn,1,3
	rs.addnew
	rs("vt_name")=vtname
	rs("vt_startdate")=startdate
	rs("vt_expiredate")=expiredate
	rs.update
	rs.close
	set rs=nothing
	response.redirect "admin_vote.asp?action=vote"
  end if
 end if
 if request.form("action")="editvote" then
  dim vtid
  vtname=trim(replace(request.form("vt_name"),"'",""))
  startdate=request.form("vt_startdate")
  expiredate=request.form("vt_expiredate")
  if request.form("id")="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須指定操作的對象！');history.back(1);</script>")
  else
    vtid=cint(request.form("id"))
  end if
  if vtname="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須填寫投票主題！');history.back(1);</script>")
  end if
  if startdate="" then
    startdate=formatdatetime(now(),2)
  else
    startdate=formatdatetime(startdate,2)
  end if
  if expiredate="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須填寫該投票主題的過期日期！');history.back(1);</script>")
  else
    expiredate=formatdatetime(expiredate,2)
  end if
  
  if founderr then
    call diserror()
	response.end
  else
	sql="select * from votetopic where vt_id="&vtid
	set rs=server.createobject("adodb.recordset")
	rs.open sql,conn,1,3
	rs("vt_name")=vtname
	rs("vt_startdate")=startdate
	rs("vt_expiredate")=expiredate
	rs.update
	rs.close
	set rs=nothing
	response.redirect "admin_vote.asp?action=vote"
  end if
 end if
 if request.form("action")="delvote" then
  if request.form("id")="" then
    founderr=true
	Response.Write("<script language=javascript>alert('你必須指定操作的對象！');history.back(1);</script>")
  else
    vtid=cint(request.form("id"))
  end if
  
  if founderr then
    call diserror()
	response.end
  else
	sql="select * from votetopic where vt_id="&vtid
	set rs=server.createobject("adodb.recordset")
	rs.open sql,conn,1,3
	rs.delete
	rs.close
	set rs=nothing
	response.redirect "admin_vote.asp?action=vote"
  end if
 end if
 if request.form("action")="newitem" then
   dim itemname
   vtid=cint(request.form("id"))
   itemname=trim(replace(request.form("item_name"),"'",""))
   if vtid<1 then
     founderr=true
	 Response.Write("<script language=javascript>alert('非法的對象參數！');history.back(1);</script>")
   end if
   if itemname="" then
     founderr=true
	 Response.Write("<script language=javascript>alert('你必須填寫選項名稱！');history.back(1);</script>")
   end if
   
   if founderr then
     call diserror()
	 response.end
   else
	 sql="select * from voteitem"
	 set rs=server.createobject("adodb.recordset")
	 rs.open sql,conn,1,3
	 rs.addnew
	 rs("item_name")=itemname
	 rs("vt_id")=vtid
	 rs.update
	 rs.close
	 set rs=nothing
	 response.redirect "admin_vote.asp?action=vote&caction=edit&id="&vtid
   end if
 end if
 if request.form("action")="edititem" then
   dim itemid
   itemid=cint(request.form("id"))
   itemname=trim(replace(request.form("item_name"),"'",""))
   if itemid<1 then
     founderr=true
	 Response.Write("<script language=javascript>alert('非法的對象參數！');history.back(1);</script>")
   end if
   if itemname="" then
     founderr=true
	 Response.Write("<script language=javascript>alert('你必須填寫選項名稱！');history.back(1);</script>")
   end if
   
   if founderr then
     call diserror()
	 response.end
   else
	 sql="select * from voteitem where item_id="&itemid
	 set rs=server.createobject("adodb.recordset")
	 rs.open sql,conn,1,3
	 rs("item_name")=itemname
	 rs.update
	 rs.close
	 set rs=nothing
	 response.redirect "admin_vote.asp?action=vote&caction=edit&id="&request.form("vtid")
   end if
 end if
 if request.form("action")="delitem" then
   itemid=cint(request.form("id"))
   if itemid<1 then
     founderr=true
	 Response.Write("<script language=javascript>alert('非法的對象參數！');history.back(1);</script>")
   end if

   if founderr then
     call diserror()
	 response.end
   else
	 sql="select * from voteitem where item_id="&itemid
	 set rs=server.createobject("adodb.recordset")
	 rs.open sql,conn,1,3
	 rs("item_name")=itemname
	 rs.delete
	 rs.close
	 set rs=nothing
	 response.redirect "admin_vote.asp?action=vote&caction=edit&id="&request.form("vtid")
   end if
 end if
end if
%>
<HTML><HEAD><TITLE>管理中心</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="inc/admin.css" type=text/css rel=StyleSheet>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
</HEAD>
<body onkeydown=return(!(event.keyCode==78&&event.ctrlKey)) >
<%if request.querystring("action")="newvote" then%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form1" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            新增投票主題</td>
          </tr>
          <tr class=lanyuds> 
            <td width="16%">主題名稱</td>
            <td width="84%"> 
              <input type="text" name="vt_name" size="50" maxlength="50" class="textarea">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="16%">開始日期</td>
            <td width="84%"> 
              <input type="text" name="vt_startdate" size="30" class="textarea">
              例子：2002-09-30 </td>
          </tr>
          <tr class=lanyuds> 
            <td width="16%">過期日期</td>
            <td width="84%"> 
              <input type="text" name="vt_expiredate" size="30" class="textarea">
              同上</td>
          </tr>
          <tr class=lanyuqs align="center"> 
            <td colspan="2" height="30" bgcolor="#F5F5F5"> 
              <input type="submit" name="Submit" value="確定新增" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button">
            </td>
          </tr>
          <input type="hidden" name="action" value="newvote">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if
	  if request.querystring("action")="vote" then
sql="select * from votetopic"
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=lanyubk style="border-collapse: collapse">
        <tr class=lanyuss> 
          <td colspan="3">
          投票主題管理</td>
        </tr>
        <tr class=lanyuqs align="center"> 
          <td width="10%">編號</td>
          <td width="60%">投票主題</td>
          <td width="30%">操作</td>
        </tr>
<%do while not rs.eof%>
        <tr class=lanyuds> 
          <td align="center"><%=rs("vt_id")%>　</td>
          <td><%=rs("vt_name")%>　</td>
          <td align="center"><a href="admin_vote.asp?action=vote&caction=edit&id=<%=rs("vt_id")%>">編輯</a> 
            <a href="admin_vote.asp?action=vote&caction=del&id=<%=rs("vt_id")%>">刪除</a></td>
        </tr>
<%rs.movenext
loop