addnew.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<!-- #include virtual="include/SelectValue.asp" -->
<%
Dim ObjDB,ObjRS,StrSQL,C
Dim Topic,IsSingle,ParentID,SubID
Dim i

if session("AccountID")="" then
%>
<script language=javascript>
  alert("因登录时间过长，会话失效，请退出重新登陆！")
</script>
<%  
  Response.End
end if
    
Set ObjDB = Server.CreateObject("ADODB.Connection")
OpenDB ObjDB

If Request.Form.Count > 0 Then
  Topic = Request.Form("Topic")
  IsSingle = Request.Form("IsSingle")
  SubID = Request.Form("SubID")
  
  StrSQL = "Select Max(ParentID) Parent from t_OA_Public_Vote"
  Set C = Server.CreateObject ("CMS2003.DBHandle")
  C.Init (ObjDB)
  Set ObjRS = C.View (StrSQL)
  ParentID = ObjRS("Parent") + 1
  StrSQL = "insert into t_OA_Public_Vote(Topic,IsSingle,ParentID,SubID,AccountID) values('" & Topic & "','" & IsSingle & "','" & ParentID & "',0,'" & Session("AccountID") & "')"
  ObjDB.Execute StrSQL
  
  for i= 1 to 10
    If Request.Form("Item" & i) <> "" Then
      StrSQL = "insert into t_OA_Public_Vote(Topic,IsSingle,ParentID,SubID,AccountID) values('" & Request.Form("Item" & i) & "','" & IsSingle & "','" & ParentID & "'," & i & ",'" & Session("AccountID") & "')"
      ObjDB.Execute StrSQL
    End If
  next
  Response.Redirect "List.asp"
  
  ObjDB.Close
  Set ObjDB = Nothing
End If

Sub Main
%>
  <form action="addnew.asp" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
  <table class=Ltable cellspacing=1 cellpadding=3>
  <tr class=LHtr>
    <td width="15%">新增联系人</td>
    <td width="85%"> </td>
  </tr>
  <tr class=Ltr>
    <td>投票名称</td>
    <td><input type="text" class=Input Check=1 Show="投票名称" name="Topic" value=""></td>
  </tr>
  <tr class=Ltr>
    <td>选项1</td>
    <td><input type="text" class=Input Check=1 Show="选项1" name="Item1" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项2</td>
    <td><input type="text" class=Input Check=1 Show="选项2" name="Item2" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项3</td>
    <td><input type="text" class=Input name="Item3" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项4</td>
    <td><input type="text" class=Input name="Item4" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项5</td>
    <td><input type="text" class=Input name="Item5" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项6</td>
    <td><input type="text" class=Input name="Item6" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项7</td>
    <td><input type="text" class=Input name="Item7" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项8</td>
    <td><input type="text" class=Input name="Item8" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项9</td>
    <td><input type="text" class=Input name="Item9" ></td>
  </tr>
  <tr class=Ltr>
    <td>选项10</td>
    <td><input type="text" class=Input name="Item10" ></td>
  </tr>
  <tr class=Ltr>
    <td>投票方式</td>
    <td>单选<input type="radio" value="1" checked name="IsSingle">多选<input type="radio" value="0"  name="IsSingle"></td>
  </tr>
  <table cellspacing=1 cellpadding=3>
  <tr>
    <td>
    <input type="submit"  name="Submit" class=Button value="提 交"><input type="button" class=Button value="取 消"onclick="doList()" id=button1 name=button1></td>
    <td></td>
  </tr>
  </table>
  </form>
<%
End Sub
%>
<!-- #include file="Templet.asp" -->