meeting_order.htm

来自「全方面的OA管理程序代码」· HTM 代码 · 共 199 行

HTM
199
字号
<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<!--#include file="../inc/dbtools.htm"-->
<HTML>
<HEAD>
<TITLE>  </TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../CSS/main.css">
</HEAD>
<script src="Popup.js"></script>
<BODY BGCOLOR="#FFFFFF">
<div align=center>
<table border=1 cellpadding=3 cellspacing=0 width="90%" bgcolor=#EEEEEE bordercolordark="#FFFFFF" bordercolorlight="#999999">
<tr>
	<td colspan=5><INPUT TYPE="button" name="cmdreturn" value="返  回" class="font9boldwhite" onclick="javascript:history.back(-1);"></td>
</tr>
<tr bgcolor=#CCCCCC>
	<td>会议室名</td>
	<td>联系电话</td>
	<td>责任负责人</td>	
	<td>可使用人数</td>
	<td>备注</td>
</tr>
<tr>
	<td><%=name%></td>
	<td><%=telcode%></td>
	<td><%=owner%></td>
	<td><%=contain%>&nbsp;</td>
	<td><%=body%>&nbsp;</td>
</tr>
</table>
<form name="UserForm" method="post" action="">
<table border=1 cellpadding=3 cellspacing=0 width="90%" bgcolor=#EEEEEE bordercolordark="#FFFFFF" bordercolorlight="#999999">
<tr>
<td width=80>登陆用户:</td>
<td width=50><input type="text" name="OrderName" size=12 readonly class="input"></td>
<td colspan=2>使用部门:<%options "Department","tblDepartment","name",0%></td>
</tr>
<tr>
	<td width=80>开始时间:</td>
	<td width=60><input type="text" name="StartTime_y" size=10 class="input"></td>
	<td width=50>
	<select name="StartTime_h">
	<option value="8:">8时</option>
	<option value="9:">9时</option>
	<option value="10:">10时</option>
	<option value="11:">11时</option>
	<option value="12:">12时</option>
	<option value="13:">13时</option>
	<option value="14:">14时</option>
	<option value="15:">15时</option>
	<option value="16:">16时</option>
	<option value="17:">17时</option>
	<option value="18:">18时</option>
	</select>
	</td>
	<td>
	<select name="StartTime_m">
	<option value="00">00分</option>
	<option value="30">30分</option>
	</select>
	</td>
</tr>
<tr>
	<td width=80>终了时间:</td>
	<td width=60><input type="text" name="EndTime_y" size=10 class="input"></td>
	<td width=50>
	<select name="endTime_h">
	<option value="8:">8时</option>
	<option value="9:">9时</option>
	<option value="10:">10时</option>
	<option value="11:">11时</option>
	<option value="12:">12时</option>
	<option value="13:">13时</option>
	<option value="14:">14时</option>
	<option value="15:">15时</option>
	<option value="16:">16时</option>
	<option value="17:">17时</option>
	<option value="18:">18时</option>
	</select>
	</td>
	<td>
	<select name="endTime_m">
	<option value="00">00分</option>
	<option value="30">30分</option>
	</select>
	</td>
</tr>
<tr>
<td>会议主题</td>
<td colspan=3><input type="text" name="Title" value="" size=40 class="input"> <font color=red>*</font></td>
</tr>
<tr>
<td>会议主持人</td>
<td colspan=3><input type="text" name="Manager" value="" size=40 class="input"></td>
</tr>
<tr>
<td>参会人员</td>
<td colspan=2>
<textarea name="JoinMan" cols=40 rows=3 readonly></textarea>
</td>
<td align=center>
<INPUT TYPE="button" name="cmdAttach" value="指定人员" onclick="OpenWindow('ReadUsers.htm','UserWindow')">
<BR>
<input type="checkbox" name="JoinEvery" value="1">全部员工
<BR>
或某部门:<%options "JoinDepartment","tblDepartment","Name",0%>
</td>
</tr>
<tr>
<td>会议安排</td>
<td colspan=3>
<textarea name="Schedule" cols=50 rows=4></textarea>
</td>
</tr>
<tr>
<td>会议介绍</td>
<td colspan=3>
<textarea name="body" cols=50 rows=4></textarea>
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan=3 align=center>
<INPUT TYPE="submit" name="cmdUp" value="确  定" class="font9boldwhite" onclick="return CheckData();">
<INPUT TYPE="button" name="cmdreturn" value="返  回" class="font9boldwhite" onclick="javascript:history.back(-1);">
</td>
</tr>
</table>
<INPUT TYPE="hidden" name="MeetingID" value="<%=MeetingID%>">
<INPUT TYPE="hidden" name="JoinID" value="">
</form>
</div>
<BR><BR>
</BODY>
</HTML>
<script language=javascript>
function CheckDelete()
{
	return confirm("确实删除吗?");
}
function OpenWindow(url,windowname)
{
window.open(url,windowname,'left=100,top=50,height=350,width=650,toolbar=no,menubar=no,scrollbars=yes')
}
function OpenWindow1(url,windowname)
{
window.open(url,windowname,'left=150,top=100,height=80,width=420,toolbar=no,menubar=no,scrollbars=yes')
}
function CheckData()
{
	if ((jtrim(document.UserForm.JoinMan.value)=="") && (document.UserForm.JoinEvery.checked==false) && (jtrim(document.UserForm.JoinDepartment.value)=="0"))
	{
		alert ("请指定参会人员!");
		return false;
	}
	return true;
}
</script>
<script language="javascript" src="../inc/jtrim.js"></script>
<!--#include file="../inc/conn_close.htm"-->
<%
Function GetTableValue(TableName,Field,ValueField,Value)
	if TableName<>"" and Value<>"" then
		Set RsTmp = Server.Createobject("Adodb.recordset")
		strSql = "Select "& Field &" from "& TableName &" where "& ValueField &"='"& Value &"'"
		Rstmp.open strSql,oConn,1,1
		If not Rstmp.eof then
			GetTableValue=trim(Rstmp(Field))
		else
			GetTableValue=""
		end if
		Rstmp.close
		'set RsTmp = Nothing
	else
		GetTableValue=""
	end if
End Function

Sub AddData()
	sql=" INSERT INTO tblMeetingOrder(MeetingID,OrderID,Department,JoinEvery,JoinDepartment,OrderName,OrderTime,Schedule,StartTime,EndTime,Title,Manager,JoinMan,body,JoinID) VALUES("& MeetingId & _
		","& LoginID & _
		","& Department & _
		","& JoinEvery & _
		","& JoinDepartment & _
		",'"& OrderName & _
		"','"& OrderTime & _
		"','"& Schedule & _
		"','"& StartTime & _
		"','"& EndTime & _
		"','"& Title & _
		"','"& Manager & _
		"','"& Joinman & _
		"','"& body & _
		"','"& JoinID & _
		"');"
	oConn.execute (sql)
end sub
%>

⌨️ 快捷键说明

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