www.gusucode.com > 随缘网络产品管理系统 2.0码程序 > manage/ClassModifyBig.asp
<%@language=VBScript codepage=936 %> <% if not session("check")="checked" then response.Redirect "login.asp" end if %> <!--#include file="conn.asp"--> <% dim BigClassID,Action,rs,NewBigClassName,OldBigClassName,FoundErr,ErrMsg BigClassID=trim(Request("BigClassID")) Action=trim(Request("Action")) NewBigClassName=trim(Request("NewBigClassName")) OldBigClassName=trim(Request("OldBigClassName")) if BigClassID="" then response.Redirect("ClassManage.asp") end if Set rs=Server.CreateObject("Adodb.RecordSet") rs.Open "Select * from BigClass where BigClassID=" & CLng(BigClassID),conn,1,3 if rs.Bof and rs.EOF then FoundErr=True ErrMsg=ErrMsg & "<br><li>此产品大类不存在!</li>" else if Action="Modify" then if NewBigClassName="" then FoundErr=True ErrMsg=ErrMsg & "<br><li>产品大类名不能为空!</li>" end if if FoundErr<>True then rs("BigClassName")=NewBigClassName rs.update rs.Close set rs=Nothing conn.execute "Update SmallClass set BigClassName='" & NewBigClassName & "' where BigClassName='" & OldBigClassName & "'" conn.execute "Update news set BigClassName='" & NewBigClassName & "' where BigClassName='" & OldBigClassName & "'" call CloseConn() Response.Redirect "ClassManage.asp" end if end if if FoundErr=True then call WriteErrMsg() else %> <script language="JavaScript" type="text/JavaScript"> function checkBig() { if (document.form1.BigClassName.value=="") { alert("大类名称不能为空!"); document.form1.BigClassName.focus(); return false; } } </script> <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="ClassModifyBig.asp"> <table width="350" border="0" align="center" cellpadding="0" cellspacing="2" class="list"> <tr class="title"> <th height="25" colspan="2" align="center" bgcolor="#999999"> <a href="ClassManage.asp"><strong><span style="text-decoration: none"> <font color="#FFFFFF">产 品 类 别 设 置</font></span></strong></a> <br> </th> </tr> <tr class="title"> <td height="25" colspan="2" align="center" bgcolor="#999999"><strong>修改大类名称</strong></td> </tr> <tr class="tdbg"> <td width="44%" bgcolor="#C0C0C0"> <p align="right"><strong>大类ID:</strong></td> <td width="53%" bgcolor="#E3E3E3"><%=rs("BigClassID")%> <input name="BigClassID" type="hidden" id="BigClassID" value="<%=rs("BigClassID")%>"> <input name="OldBigClassName" type="hidden" id="OldBigClassName" value="<%=rs("BigClassName")%>"></td> </tr> <tr class="tdbg"> <td width="44%" bgcolor="#C0C0C0"> <p align="right"><strong>大类名称:</strong></td> <td bgcolor="#E3E3E3"> <input name="NewBigClassName" type="text" id="NewBigClassName" value="<%=rs("BigClassName")%>" size="20" maxlength="30"></td> </tr> <tr class="tdbg"> <td align="center" bgcolor="#C0C0C0" width="44%"> </td> <td align="center" bgcolor="#E3E3E3"> <div align="left"> <input name="Action" type="hidden" id="Action" 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 %>