NewsEdit.asp
上传用户:dbstep
上传日期:2022-08-06
资源大小:2803k
文件大小:10k
- <HTML xmlns="http://www.w3.org/1999/xhtml">
- <HEAD>
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
- <TITLE>编辑新闻</TITLE>
- <link rel="stylesheet" href="Images/CssAdmin.css">
- <script language="javascript" src="../skweb/JS/Admin.js"></script>
- </HEAD>
- <!--#include file="../skweb/Const.asp" -->
- <!--#include file="../skweb/ConnSiteData.asp" -->
- <!-- #include file="../fckeditor/fckeditor.asp" -->
- <!--#include file="CheckAdmin.asp"-->
- <%
- if Instr(session("AdminPurview"),"|23,")=0 then
- response.write ("<font color='red')>你不具有该管理模块的操作权限,请返回!</font>")
- response.end
- end if
- '========判断是否具有管理权限
- %>
- <BODY>
- <%
- dim Result
- Result=request.QueryString("Result")
- dim ID,NewsName,ViewFlag,SortName,SortID,SortPath,VoticeFlag,BigPic
- dim GroupID,GroupIdName,Exclusive,NoticeFlag,Source,Content
- ID=request.QueryString("ID")
- call NewsEdit()
- %>
-
- <table width="100%" border="0" cellpadding="3" >
- <form name="editForm" method="post" action="NewsEdit.asp?Action=SaveEdit&Result=<%=Result%>&ID=<%=ID%>">
- <tr>
- <td height="24" nowrap bgcolor="#EBF2F9"><table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC" id=editNews idth="100%">
- <tr>
- <td height="29" colspan="2" background="Images/menutitle.gif" bgcolor="#FFFFFF"><table width="470" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td width="121"><strong><font color="#000000" size="2">新闻管理</font></strong></td>
- <td width="87"><a href="NewsEdit.asp?Result=Add"><img src="Images/x1.gif" width="52" height="17" border="0"></a></td>
- <td width="87"><a href="NewsList.asp"><img src="Images/xlm.gif" width="52" height="17" border="0"></a></td>
- <td width="87"><a href="NewsSort.asp"><img src="Images/xx.gif" width="52" height="17" border="0"></a></td>
- <td width="88"> </td>
- </tr>
- </table></td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">新闻名称:</td>
- <td bgcolor="#FFFFFF"><input name="NewsName" type="text" class="textfield" id="NewsName" style="WIDTH: 240;" value="<%=NewsName%>" maxlength="100"> * 不少于3个字符
- <input name="ViewFlag" type="checkbox" style='HEIGHT: 13px;WIDTH: 13px;' value="1" <%if ViewFlag then response.write ("checked")%>> 显示
- <input name="NoticeFlag" type="checkbox" style="HEIGHT: 13px;WIDTH: 13px;" value="1" <%if NoticeFlag then response.write ("checked")%>>
- 公告</td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">所属类别:</td>
- <td bgcolor="#FFFFFF"><input name="SortID" type="text" class="textfield" id="SortID" style="WIDTH: 40;background-color:#EBF2F9;" value="<%=SortID%>" readonly> <input name="SortPath" type="text" class="textfield" id="SortPath" style="WIDTH: 80;background-color:#EBF2F9;" value="<%=SortPath%>" readonly> <input name="SortName" type="text" class="textfield" id="SortName" value="<%=SortName%>" style="WIDTH: 140;background-color:#EBF2F9;" readonly> <a href="javaScript:OpenScript('SelectSort.asp?Result=News',500,500,'')"><img src="Images/Select.gif" width="30" height="16" border="0" align="absmiddle"></a></td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">新闻来源:</td>
- <td bgcolor="#FFFFFF"><input name="Source" type="text" class="textfield" style="WIDTH: 240;" value="<%=Source%>" maxlength="100"></td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">查看权限:</td>
- <td bgcolor="#FFFFFF"><select name="GroupID" class="textfield">
- <% call SelectGroup() %>
- </select>
- <input name="Exclusive" type="radio" value=">=" <%if Exclusive="" or Exclusive=">=" then response.write ("checked")%>> 隶属<input type="radio" <%if Exclusive="=" then response.write ("checked")%> name="Exclusive" value="=">专属 [隶属:权限值≥可查看,专属:权限值=可查看]</td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">新闻主图:</td>
- <td bgcolor="#FFFFFF"><input name="BigPic" type="text" class="textfield" style="WIDTH: 240;" value="<%=BigPic%>" maxlength="100"> <a href="javaScript:OpenScript('UpFileForm.asp?Result=BigPic',460,180)"><img src="Images/Upload.gif" width="30" height="16" border="0" align="absmiddle"></a></td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">首页标记:</td>
- <td bgcolor="#FFFFFF"><input name="VoticeFlag" type="checkbox" id="VoticeFlag" style="HEIGHT: 13px;WIDTH: 13px;" value="1" <%if VoticeFlag then response.write ("checked")%>>
- 首页标记要在首页显示FLASH图片必须选上</td>
- </tr>
- <tr>
- <td height="24" align="right" bgcolor="#FFFFFF">备注说明:</td>
- <td bgcolor="#FFFFFF"><font color="red">上传文件必须是JPEG格式,宽为360PX 高180px 以首页合协处理</font></td>
- </tr>
- <tr>
- <td height="24" align="right" valign="top" bgcolor="#FFFFFF">信息内容:<br>
- <td bgcolor="#FFFFFF"><%
- Dim oFCKeditor
- Set oFCKeditor = New FCKeditor
- oFCKeditor.BasePath = "../fckeditor/"
- oFCKeditor.ToolbarSet = "Default"
- oFCKeditor.Width = "100%"
- oFCKeditor.Height = "400"
- oFCKeditor.Value = content
- oFCKeditor.Create "Content"
- %></td>
- </tr>
- <tr>
- <td height="30" align="right" bgcolor="#FFFFFF"> </td>
- <td valign="bottom" bgcolor="#FFFFFF"><input name="submitSaveEdit" type="submit" class="button" id="submitSaveEdit" value="保存" style="WIDTH: 80;" ></td>
- </tr>
- </table></td>
- </tr>
- </form>
- </table>
- </BODY>
- </HTML>
- <%
- sub NewsEdit()
- dim Action,rsRepeat,rs,sql
- Action=request.QueryString("Action")
- if Action="SaveEdit" then '保存编辑产品信息
- set rs = server.createobject("adodb.recordset")
- if len(trim(request.Form("NewsName")))<3 then
- response.write ("<script language=javascript> alert('新闻名称为必填项目!');history.back(-1);</script>")
- response.end
- end if
- if Result="Add" then '创建产品信息
- sql="select * from sk_News"
- rs.open sql,conn,1,3
- rs.addnew
- rs("NewsName")=trim(Request.Form("NewsName"))
- if Request.Form("ViewFlag")=1 then
- rs("ViewFlag")=Request.Form("ViewFlag")
- else
- rs("ViewFlag")=0
- end if
- if Request.Form("SortID")="" and Request.Form("SortPath")="" then
- response.write ("<script language=javascript> alert('请选择所属分类!');history.back(-1);</script>")
- response.end
- else
- rs("SortID")=Request.Form("SortID")
- rs("SortPath")=Request.Form("SortPath")
- end if
- rs("Source")=trim(Request.Form("Source"))
- if Request.Form("NoticeFlag")=1 then
- rs("NoticeFlag")=Request.Form("NoticeFlag")
- else
- rs("NoticeFlag")=0
- end if
- GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
- rs("GroupID")=GroupIdName(0)
- rs("Exclusive")=trim(Request.Form("Exclusive"))
- rs("BigPic")=trim(Request.Form("BigPic"))
- if Request.Form("VoticeFlag")=1 then
- rs("VoticeFlag")=Request.Form("VoticeFlag")
- else
- rs("VoticeFlag")=0
- end if
- rs("Content")=trim(Request.Form("Content"))
- rs("AddTime")=now()
- end if
- if Result="Modify" then '修改产品信息
- sql="select * from sk_News where ID="&ID
- rs.open sql,conn,1,3
- rs("NewsName")=trim(Request.Form("NewsName"))
- if Request.Form("ViewFlag")=1 then
- rs("ViewFlag")=Request.Form("ViewFlag")
- else
- rs("ViewFlag")=0
- end if
- if Request.Form("SortID")<>"" and Request.Form("SortPath")<>"" then
- rs("SortID")=Request.Form("SortID")
- rs("SortPath")=Request.Form("SortPath")
- else
- response.write ("<script language=javascript> alert('请选择所属分类!');history.back(-1);</script>")
- response.end
- end if
- rs("Source")=trim(Request.Form("Source"))
- if Request.Form("NoticeFlag")=1 then
- rs("NoticeFlag")=Request.Form("NoticeFlag")
- else
- rs("NoticeFlag")=0
- end if
- GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
- rs("GroupID")=GroupIdName(0)
- rs("Exclusive")=trim(Request.Form("Exclusive"))
- rs("BigPic")=trim(Request.Form("BigPic"))
- if Request.Form("VoticeFlag")=1 then
- rs("VoticeFlag")=Request.Form("VoticeFlag")
- else
- rs("VoticeFlag")=0
- end if
- rs("Content")=trim(Request.Form("Content"))
- end if
- rs.update
- rs.close
- set rs=nothing
- Response.Redirect("Tips/news.asp")
- else '提取产品信息
- if Result="Modify" then
- set rs = server.createobject("adodb.recordset")
- sql="select * from sk_News where ID="& ID
- rs.open sql,conn,1,1
- if rs.bof and rs.eof then
- response.write ("数据库读取记录出错!")
- response.end
- end if
- NewsName=rs("NewsName")
- ViewFlag=rs("ViewFlag")
- SortName=SortText(rs("SortID"))
- SortID=rs("SortID")
- SortPath=rs("SortPath")
- Source=rs("Source")
- NoticeFlag=rs("NoticeFlag")
- GroupID=rs("GroupID")
- Exclusive=rs("Exclusive")
- BigPic=rs("BigPic")
- VoticeFlag=rs("VoticeFlag")
- Content=rs("Content")
- rs.close
- set rs=nothing
- end if
- end if
- end sub
- %>
- <%
- sub SelectGroup()
- dim rs,sql
- set rs = server.createobject("adodb.recordset")
- sql="select GroupID,GroupName from sk_MemGroup"
- rs.open sql,conn,1,1
- if rs.bof and rs.eof then
- response.write("未设组别")
- end if
- while not rs.eof
- response.write("<option value='"&rs("GroupID")&"┎╂┚"&rs("GroupName")&"'")
- if GroupID=rs("GroupID") then response.write ("selected")
- response.write(">"&rs("GroupName")&"</option>")
- rs.movenext
- wend
- rs.close
- set rs=nothing
- end sub
- %>
- <%
- '生成所属类别--------------------------
- Function SortText(ID)
- Dim rs,sql
- Set rs=server.CreateObject("adodb.recordset")
- sql="Select * From sk_NewsSort where ID="&ID
- rs.open sql,conn,1,1
- SortText=rs("SortName")
- rs.close
- set rs=nothing
- End Function
- %>