classmodifysmall.asp

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

<%@language=vbscript codepage=936 %>
<!--#include file="../inc/Conn.asp"-->
<!--#include file="Admin.asp"-->
<!--#include file="Inc/Function.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"))
EnSmallClassName=trim(Request.form("EnSmallClassName"))
OldEnSmallClassName=trim(request.form("OldEnSmallClassName"))
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("EnSmallClassName")=EnSmallClassName
     		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
			if EnSmallClassName<>OldEnSmallClassName then
				conn.execute "Update Product set EnSmallClassName='" & EnSmallClassName & "' where BigClassName='" & BigClassName & "' and SmallClassName='" & OldEnSmallClassName & "'"
	     	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 checkSmall()
{
  if (document.form2.BigClassName.value=="")
  {
    alert("请先添加大类名称！");
	document.form2.BigClassName.focus();
	return false;
  }

  if (document.form2.SmallClassName.value=="")
  {
    alert("小类名称不能为空！");
	document.form2.SmallClassName.focus();
	return false;
  }
}
</script>
<!-- #include file="Inc/Head.asp" -->
<form name="form1" method="post" action="ClassModifySmall.asp?Action=Modify">
        <table width="377" border="0" align="center" cellpadding="0" cellspacing="1" class=border>
          <tr class="title"> 
            <td height="25" colspan="2" align="center" class=Title><strong>添加小类</strong></td>
          </tr>
          <tr class="tdbg"> 
            <td width="258" align="right" class=tdbgl><strong>所属大类：</strong></td>
            <td width="712"><%=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" align="right" class=tdbgl><strong>小类名称：</strong></td>
            <td><input name="SmallClassName" type="text" id="SmallClassName" value="<%=rs("SmallClassName")%>" size="30" maxlength="50" /></td>
          </tr>
          <tr class="tdbg">
            <td height="22" align="right" class=tdbgl><div align="right"><strong>英文小类名称：</strong></div></td>
            <td height="22" align="center"><div align="left">
              <input name="EnSmallClassName" type="text" id="EnSmallClassName" value="<%=rs("EnSmallClassName")%>" size="30" maxlength="50" />
            </div></td>
          </tr>
          <tr class="tdbg"> 
            <td height="22" align="center" class=tdbgl>&nbsp; </td>
            <td height="22" align="center"> <div align="left"> 
                <input name="Action" type="hidden" id="Action3" value="Add">
                <input name="Add" type="submit" value=" 添 加 ">
              </div></td>
          </tr>
  </table>
</form>
<!-- #include file="Inc/Foot.asp" -->
<%
end if
call CloseConn()
end if
%>