⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 closeschedule.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
字号:
<!--#include file="../config.ini"-->
<%
on error resume next
if Request("Mod")="Delete" then
	Dim Conn
	Dim CurPage
	Set Conn=Server.CreateObject("ADODB.Connection")
	dim rstCheck
	set rstCheck=server.CreateObject("ADODB.Recordset")
	dim rstAdd
	set rstAdd=server.CreateObject("ADODB.Recordset")
	Conn.Open ConnString
		Conn.execute "update Schedule set  Closed=1 where Id"&" ="&Request("Id")
		rstCheck.open "select * from Schedule where Id"&" ="&Request("Id"),Conn,2,3,1
		rstAdd.open "select * from Schedule ",Conn,2,3,1
		if rstCheck("Continued")=true then
		rstAdd.addnew
		rstAdd("AssignedTo") = rstCheck("AssignedTo")
		rstAdd("Creator") = rstCheck("Creator")
		rstAdd("Schedule") = rstCheck("Schedule")
		rstAdd("TaskType") = rstCheck("TaskType")
		rstAdd("account") = rstCheck("account")
		rstAdd("Description") = rstCheck("Description")
		rstAdd("ScheduleDate") = rstCheck("NextDate")
		rstAdd("ScheduleTime") = rstCheck("ScheduleTime")
		rstAdd("Closed") = 0
		rstAdd("Location") = rstCheck("Location")
		rstAdd("Continued") =0
		'rstAdd("NextDate") = rstCheck("NextDate")
		rstAdd.update
		end if
	if err.number<>0 then
	Response.Write err.number
	Response.End 	
	end if
	Conn.Close 
	Set Conn=nothing
	%>
	<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
		window.opener.location.reload(true);
		window.close();
	</SCRIPT>
	<%
end if
%>
<html>
<head>
<title>确认完成</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
function DoDelete_onclick() {
	form1.Mod.value='Delete';
	form1.submit();
	return;
	}
</SCRIPT>
</head>
<body bgcolor="#FFFFFF" text="#000000">

<div align="center"><font color="#000000"><br>
  <br>
  </font>
  <form name="form1" method="post" action="">
  <input type=hidden name=Mod>
     
    <table width="100%">
      <tr><td><div align="center"><font class=title>确认要完成?</font></div></td></tr></table><br>
    <br>
	<img src="../images/button_confirm.gif" style="cursor:hand" border=0 language=javascript onclick="return DoDelete_onclick();">&nbsp;	
	<img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();">
  </form>
  <font color="#000000"> </font></div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -