classmodifybig.asp

广州市拓尔家具网源码 后台:mrsystem 用户名密码admin

<%@language=vbscript codepage=936 %>
<!--#include file="../inc/Conn.asp"-->
<!--#include file="Admin.asp"-->
<!--#include file="Inc/Function.asp"-->
<%
dim BigClassID,Action,rs,NewBigClassName,OldEnBigClassName,NewEnBigClassName,OldBigClassName,FoundErr,ErrMsg
BigClassID=trim(Request("BigClassID"))
Action=trim(Request("Action"))
NewBigClassName=trim(Request("NewBigClassName"))
OldBigClassName=trim(Request("OldBigClassName"))
NewEnBigClassName=trim(Request("NewEnBigClassName"))
OldEnBigClassName=trim(Request("OldEnBigClassName"))

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("EnBigClassName")=NewEnBigClassName			
    	 	rs.update
			rs.Close
	     	set rs=Nothing
			if NewBigClassName<>OldBigClassName then
				conn.execute "Update SmallClass set BigClassName='" & NewBigClassName & "' where BigClassName='" & OldBigClassName & "'"
				conn.execute "Update Product set BigClassName='" & NewBigClassName & "' where BigClassName='" & OldBigClassName & "'"
     		end if
			
			if NewEnBigClassName<>OldEnBigClassName then
				conn.execute "Update SmallClass set EnBigClassName='" & NewEnBigClassName & "' where EnBigClassName='" & OldEnBigClassName & "'"
				conn.execute "Update Product set EnBigClassName='" & NewEnBigClassName & "' where EnBigClassName='" & OldEnBigClassName & "'"
     		end if		
			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>
<!-- #include file="Inc/Head.asp" -->
       <form name="form1" method="post" action="ClassModifyBig.asp?action=Modify">
        <table width="386" border="0" align="center" cellpadding="0" cellspacing="1" class="border">
          <tr> 
            <td height="25" colspan="2" align="center" class="Title"><strong>修改大类</strong></td>
          </tr>
          <tr> 
            <td width="258" height="10" class=tdbgl> <div align="right"><strong>大类ID：</strong></div></td>
            <td width="735" class=tdbg><%=rs("BigClassID")%>
              <input name="BigClassID" type="hidden" id="BigClassID" value="<%=rs("BigClassID")%>" />
              <input name="OldBigClassName" type="hidden" id="OldBigClassName" value="<%=rs("BigClassName")%>" />
              <input name="OldEnBigClassName" type="hidden" id="OldEnBigClassName" value="<%=rs("EnBigClassName")%>" /></td>
          </tr>
          <tr>
            <td height="10" class="tdbgl"><div align="right"><strong>大类名称：</strong></div></td>
            <td class="tdbg"><input name="NewBigClassName" type="text" id="NewBigClassName" value="<%=rs("BigClassName")%>" size="30" maxlength="50" /></td>
          </tr>
          <tr bgcolor="#C0C0C0" class="tdbg">
            <td height="22" align="center" class=tdbgl><div align="right"><strong>英文大类名称：</strong></div></td>
            <td height="22" align="center" class=tdbg><div align="left">
              <input name="NewEnBigClassName" type="text" id="NewEnBigClassName" value="<%=rs("EnBigClassName")%>" size="30" maxlength="50" />
            </div></td>
          </tr>
          <tr bgcolor="#C0C0C0" class="tdbg"> 
            <td height="22" align="center" class=tdbgl>&nbsp; </td>
            <td height="22" align="center" class=tdbg> <div align="left"> 
                <input name="Action" type="hidden" id="Action" value="Add">
                <input name="Add" type="submit" value=" 修 改">
              </div></td>
          </tr>
</table>
<!-- #include file="Inc/Foot.asp" -->
<%
end if
call CloseConn()
end if 
%>