www.pudn.com > Zhwebcode.rar > ClassAddSmall.asp, change:2008-10-07,size:3822b


<%@language=vbscript codepage=936 %> 
<!--#include file="Conn.asp"--> 
<!--#include file="Admin.asp"--> 
<!--#include file="Inc/Function.asp"--> 
<% 
dim Action,BigClassName,SmallClassName,rs,FoundErr,ErrMsg 
Action=trim(Request("Action")) 
BigClassName=trim(request("BigClassName")) 
SmallClassName=trim(request("SmallClassName")) 
if Action="Add" then 
	if BigClassName="" then 
		FoundErr=True 
		ErrMsg=ErrMsg & "<br><li>产品大类名不能为空!</li>" 
	end if 
	if SmallClassName="" then 
		FoundErr=True 
		ErrMsg=ErrMsg & "<br><li>产品小类名不能为空!</li>" 
	end if 
	if FoundErr<>True then 
		Set rs=Server.CreateObject("Adodb.RecordSet") 
		rs.open "Select * From SmallClass Where BigClassName='" & BigClassName & "' AND SmallClassName='" & SmallClassName & "'",conn,1,3 
		if not rs.EOF then 
			FoundErr=True 
			ErrMsg=ErrMsg & "<br><li>“" & BigClassName & "”中已经存在产品小类“" & SmallClassName & "”!</li>" 
		else 
     		rs.addnew 
			rs("BigClassName")=BigClassName 
    	 	rs("SmallClassName")=SmallClassName 
     		rs.update 
	     	rs.Close 
    	 	set rs=Nothing 
     		call CloseConn() 
			Response.Redirect "ClassManage.asp"   
		end if 
	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" --> 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> 
  <tr>  
    <td align="center" valign="top"> <br> <br> 
      <strong>产 品 类 别 设 置</strong> <br> <br> <br> <form name="form2" method="post" action="ClassAddSmall.asp" onSubmit="return checkSmall()"> 
        <table width="350" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#666666" class="border"> 
          <tr class="title">  
            <td height="30" colspan="2" align="center" bgcolor="#EFEFEF"><strong>添加小类</strong></td> 
          </tr> 
          <tr>  
            <td width="126" height="26" bgcolor="#EFEFEF"><strong>所属大类:</strong></td> 
            <td width="218" bgcolor="#FCFCFC">  
              <select name="BigClassName"> 
                <% 
	dim rsBigClass 
	set rsBigClass=server.CreateObject("adodb.recordset") 
	rsBigClass.open "Select * From BigClass",conn,1,1 
	if rsBigClass.bof and rsBigClass.bof then 
		response.write "<option>请先添加产品大类</option>" 
	else 
		do while not rsBigClass.eof 
			if rsBigClass("BigClassName")=BigClassName then 
				response.write "<option value='"& rsBigClass("BigClassName") & "' selected>" & rsBigClass("BigClassName") & "</option>" 
			else 
				response.write "<option value='"& rsBigClass("BigClassName") & "'>" & rsBigClass("BigClassName") & "</option>" 
			end if 
			rsBigClass.movenext 
		loop 
	end if 
	rsBigClass.close 
	set rsBigClass=nothing 
	%> 
              </select> 
            </td> 
          </tr> 
          <tr>  
            <td width="126" height="26" bgcolor="#EFEFEF"><strong>小类名称:</strong></td> 
            <td bgcolor="#FCFCFC">  
              <input name="SmallClassName" type="text" size="20" maxlength="30"> 
            </td> 
          </tr> 
          <tr>  
            <td height="26" colspan="2" align="center" bgcolor="#FCFCFC">  
                <input name="Action" type="hidden" id="Action3" value="Add"> 
                <input name="Add" type="submit" value=" 添 加 "></td> 
          </tr> 
        </table> 
      </form></td> 
  </tr> 
</table> 
<!-- #include file="Inc/Foot.asp" --> 
<% 
end if 
call CloseConn() 
%>