hover_class_small_edit.asp

后台默认管理账号密码：admin 后台主要功能如下：一、系统管理：管理员管理

<!--#include file="toptable.asp"-->
<!--#include file="Inc/Function.asp"-->
<%
'=================================
'   良精科技企业管理系统
'   QQ在线客服:65961930 82993936
'   咨询定购Tel:010-81991660
'      [e-mail] 
'        www.liangjing.net
'  copyright(c)2001-2008 HoverCms 2007特别版
'=================================
%>
<%
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"))
Smallorder=trim(Request.form("Smallorder"))

sqlBig="select * from Hover_BigClass where BigClassName='" & BigClassName & "'"
Set rsBig= Server.CreateObject("ADODB.Recordset")
rsBig.open sqlBig,conn,1,1
BigClassName=rsBig("BigClassName")
rsBig.close

if SmallClassID="" then
	response.Redirect("Hover_Class.asp")
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select * from Hover_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("Smallorder")=Smallorder
     		rs.update
			rs.Close
    	 	set rs=Nothing
			if SmallClassName<>OldSmallClassName then
				conn.execute "Update Product set SmallClassName='" & SmallClassName & "' where BigClassName='" & BigClassName & "' and  SmallClassName='" & OldSmallClassName & "'"
	     	end if	
			call CloseConn()
    	 	Response.Redirect "Hover_Class.asp"
		end if
	end if
	if FoundErr=True then
		call WriteErrMsg()
	else
%>
<!-- #include file="Inc/Head.asp" -->
<BR>
<table cellpadding="3" cellspacing="1" border="0" width="97%" align="center" class="tableBorder">
	<form name="form1" method="post" action="Hover_Class_Small_edit.asp">
	<tr>
		<td class="title" height="25" align="center"  colspan="2"><strong>产 品 类 别 设 置</strong></td>
	</tr>
	<tr> 
									<td height="25" colspan="2" bgcolor="#F0F5F9" class="title2">选择您需要更改的产品类别。</td>
	  </tr>	<tr bgcolor="#999999" class="title"> 
					<td height="25" colspan="2" align="center" class="items">修改小类名称</td>
				</tr>
				<tr class="tdbg"> 
					<td width="446" height="22" align=right bgcolor="#C0C0C0" class="table">所属大类：</td>
					<td width="524" bgcolor="#E3E3E3" class="table"><%=rs("BigClassName")%> 
					<input name="SmallClassID" type="hidden" id="SmallClassID" value="<%=rs("SmallClassID")%>"> 
					<input name="OldSmallClassName" type="hidden" id="OldSmallClassName" value="<%=rs("SmallClassName")%>"> 
					<input name="EnOldSmallClassName" type="hidden" id="EnOldSmallClassName" value="<%=rs("EnSmallClassName")%>"> 
					<input name="BigClassName" type="hidden" id="BigClassName" value="<%=rs("BigClassName")%>"></td>
				</tr>
				<tr class="tdbg"> 
					<td height="22" align=right bgcolor="#C0C0C0" class="table">小类名称：</td>
					<td bgcolor="#E3E3E3" class="table">
					<input name="SmallClassName" type="text" id="SmallClassName" value="<%=rs("SmallClassName")%>" size="20" maxlength="30"></td>
				</tr>
				<tr class="tdbg"> 
					<td height="22" align=right bgcolor="#C0C0C0" class="table">顺序：</td>
					<td bgcolor="#E3E3E3" class="table">
					<input name="Smallorder" type="text" id="Smallorder" value="<%=rs("Smallorder")%>" size="5" maxlength="5"></td>
				</tr>
				<tr class="tdbg"> 
					<td height="22" colspan="2" align="center" bgcolor="#C0C0C0" class="table"> 
					<input name="Action" type="hidden" id="Action4" value="Modify">
					<input name="Save" type="submit" class="btn"  id="Save" value=" 修 改 ">    </td>
				</tr>
</form>	
</table>  
			

<BR>
<%htmlend%>
<%
	end if
end if
rs.close
set rs=nothing
call CloseConn()
%>