add_news.asp

具有计划、任务、通告、公文、员工档案、等网络办公功能

<%@language="VBscript"%>
<%Response.Expires=0%>
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")

function opendb(DBPath,sessionname,dbsort)
dim conn
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../../db/#sdoa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
set opendb=session(sessionname)
end function

	set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select * from userinf where username='" & oabusyusername&"'"
rs.open sql,conn,1
cook_allow_control_note=rs("allow_control_note")     
conn.close
set conn=nothing
set rs=nothing
if cook_allow_control_note="no" then
	response.write("<script language=""javascript"">")
	response.write("alert(""对不起，你没有进行此项操作的权限！"");")
	response.write("</script>")
	response.end
	end if
%>
<!--#include file="../include/checkadmin.asp"-->
<!--#include file="../include/conn.asp"-->

<style>
	td{font-size:13px;}
</style>
<script language="javascript">
	function OpenHTMLEditor(){
		window.open('./htmleditor/editor.html','','width=768,height=500,top=10,left=10');
	}
	function OpenHTMLPreview(){
		srcstr=document.all.content.value
		srcstr=srcstr.replace("[HTML]","");
		srcstr=srcstr.replace("[/HTML]","");
		PreviewPage=window.open('','_blank','');
		PreviewPage.document.write(srcstr);
	}
</script>
<script language="javascript">
	function doSubmit(){
		var obj=document.frmadd;

		if(obj.columnid.value==""){
			alert("请选择目录！");
			obj.columnid.focus();
			return false;
		}

		if(obj.title.value==""){
			alert("标题不能为空！");
			obj.title.focus();
			return false;
		}

		if(obj.content.value==""){
			alert("内容不能为空！");
			obj.content.focus();
			return false;
		}

		if(obj.imgname.value!=""){
			var filename;
			var fileext;
			filename=obj.imgname.value;
			fileext=filename.substr(filename.length-3,3);
			fileext=fileext.toUpperCase();
			if ((fileext != "GIF") && (fileext != "JPG")){                  
                  alert("图片格式不正确，请选择GIF或JPG图片！");
                  return false;
			}
		}
	}
</script>
<table border="0" cellspacing="1" width="600" >
  <form name="frmadd" enctype="multipart/form-data" method="post" action="add_news_ok.asp" onsubmit="javascript:return doSubmit();">
  <input type="hidden" name="action" value="addnew">
  <tr>
    <td height="23"><img src="images/spacer.gif" width="10" height="1"><font style="font-size:13px;" ><b>增加新闻</b></font></td>
  </tr>
  <tr>
    <td height="23" bgcolor="#FFFFFF">
	<br>
	<table align="center" border="0" width="96%">
	  <tr>
		<td height="26">目录</td>
		<td>
		<select name="columnid">
		<option value=""></option>
		<%
		set rs_root=conn.execute("select columnid,columnname from tbl_news_column where columnparentid=0 order by columnid desc")
		do while not rs_root.eof
			response.write("<option value="&rs_root("columnid")&">⊙"&rs_root("columnname")&"</option>")
			set rs_child=conn.execute("select columnid,columnname from tbl_news_column where columnparentid="&rs_root("columnid")&" order by columnid desc")
			do while not rs_child.eof
				response.write("<option value="&rs_child("columnid")&"> ├─"&rs_child("columnname")&"</option>")
				rs_child.movenext
			loop
			rs_root.movenext
		loop
		set rs_root=nothing
		%>
		</select>
		</td>
	  </tr>
	  <tr>
		<td height="26">标题</td>
		<td><input type="text" name="title" style="width:480px;"></td>
	  </tr>
	  <tr>
		<td colspan="2" height="8"></td>
	  </tr>
	  <tr>
		<td height="26">图片</td>
		<td><input type="file" name="imgname" style="width:480px;"></td>
	  </tr>
	  <tr style="display:none;">
		<td height="26">图片位置</td>
		<td>		
		<select name="imgposition">
		<option value="0" selected>默认位置</option>
		<option value="1">上</option>
		<option value="2">中</option>
		<option value="3">下</option>
		</select>
		</td>
	  </tr>
	  <tr>
		<td height="26">图片链接</td>
		<td><input type="text" name="imgurl" style="width:410px;"></td>
	  </tr>
	  <tr>
		<td colspan="2" height="8"></td>
	  </tr>
	  <tr>
		<td height="26">标记</td>
		<td>
		<input type="checkbox" name="index" value="1">首页新闻
		<input type="checkbox" name="important" value="1">重点新闻
		</td>
	  </tr>
	  <tr>
		<td height="26" valign="top">内容</td>
		<td><textarea name="content" style="width:480px;height:180px;"></textarea></td>
	  </tr>
	</table>
	<br>
	</td>
  </tr>
  <tr>
    <td height="23" colspan="2" align="center">
	<input type=button name=b1 style="width:60px;" value="编辑器" onclick="javascript:OpenHTMLEditor();">
	<input type=button name=b2 style="width:60px;" value="预览" onclick="javascript:OpenHTMLPreview();"><br>
	<input type="submit" name="btnSubmit" value="确定" style="width:60px;">
	<input type="reset" name="btnReset" value="取消" style="width:60px;">
	</td>
  </tr>
  </form>
</table>