ClassModifySmall.asp 随缘网络产品管理系统 2.0码程序 - ASP源码程序

www.gusucode.com > 随缘网络产品管理系统 2.0码程序 > manage/ClassModifySmall.asp
    <%@language=VBScript codepage=936 %>
<%
if not session("check")="checked" then
response.Redirect "login.asp"
end if
%>
<!--#include file="conn.asp"-->
<%
dim SmallClassID,Action,BigClassName, SmallClassName, OldSmallClassName,rs,FoundErr,ErrMsg
SmallClassID=trim(Request("SmallClassID"))
Action=trim(Request("Action"))
BigClassName=trim(Request.form("BigClassName"))
SmallClassName=trim(Request.form("SmallClassName"))
OldSmallClassName=trim(request.form("OldSmallClassName"))
if SmallClassID="" then
	response.Redirect("ClassManage.asp")
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select * from SmallClass where SmallClassID="&SmallClassID&"",conn,1,3
if rs.Bof or rs.EOF then
	FoundErr=True
	ErrMsg=ErrMsg & "<br><li>此文章小类不存在！</li>"
else
	if Action="Modify" then
		if SmallClassName="" then
			FoundErr=True
			ErrMsg=ErrMsg & "<br><li>文章小类名不能为空！</li>"
		end if
		if FoundErr<>True then
			rs("SmallClassName")=SmallClassName
     		rs.update
			rs.Close
    	 	set rs=Nothing
			conn.execute "Update news set SmallClassName='" & SmallClassName & "' where SmallClassName='" & OldSmallClassName & "'"
			call CloseConn()
    	response.write "<script language='javascript'>" & chr(13)
		response.write "alert('修改成功！');" & Chr(13)
		response.write "window.document.location.href='ClassManage.asp';"&Chr(13)
		response.write "</script>" & Chr(13)
Response.End
		end if
	end if
	if FoundErr=True then
		call WriteErrMsg()
	else
%>

<head>
<link href="images/private.css" rel="stylesheet" type="text/css" />
<script language='javascript' src='images/private.js'></SCRIPT>
</head>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td align="center" valign="top"><form name="form1" method="post" action="ClassModifySmall.asp">
        <table width="350" border="0" align="center" cellpadding="0" cellspacing="2" class="list">
          <tr bgcolor="#999999" class="title"> 
            <th height="25" colspan="2" align="center">
      <a href="ClassManage.asp"><strong><span style="text-decoration: none">
			<font color="#FFFFFF">产 品 类 别 设 置</font></span></strong></a> <br> 
			</th>
          </tr>
          <tr class="tdbg"> 
            <td width="98%" height="22" bgcolor="#C0C0C0" colspan="2">
			<p align="center"><strong>修改小类名称</strong></td>
          </tr>
          <tr class="tdbg"> 
            <td width="44%" height="22" bgcolor="#C0C0C0">
			<p align="right"><strong>所属大类：</strong></td>
            <td width="54%" bgcolor="#E3E3E3"><%=rs("BigClassName")%> <input name="SmallClassID" type="hidden" id="SmallClassID" value="<%=rs("SmallClassID")%>"> 
              <input name="OldSmallClassName" type="hidden" id="OldSmallClassName" value="<%=rs("SmallClassName")%>"> 
              <input name="BigClassName" type="hidden" id="BigClassName" value="<%=rs("BigClassName")%>"></td>
          </tr>
          <tr class="tdbg"> 
            <td height="22" bgcolor="#C0C0C0" width="44%">
			<p align="right"><strong>小类名称：</strong></td>
            <td bgcolor="#E3E3E3"> <input name="SmallClassName" type="text" id="SmallClassName" value="<%=rs("SmallClassName")%>" size="20" maxlength="30"></td>
          </tr>
          <tr class="tdbg"> 
            <td height="22" align="center" bgcolor="#C0C0C0" width="44%">　</td>
            <td align="center" bgcolor="#E3E3E3"> <div align="left"> 
                <input name="Action" type="hidden" id="Action4" value="Modify">
                <input name="Save" type="submit" id="Save" value=" 修 改 ">
              </div></td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>
<%
end if
end if
rs.close
set rs=nothing
%>