📄 product_class.asp

📁 商会商会商会商会商会商会商会商会商会商会商会商会商会
💻 ASP
字号:
<%@ Language=VBScript %>
<%
Response.Buffer=true
Response.Expires=0

if Session("userqx")>="1" and Session("userqx")<="9" then
else
	Response.Redirect "warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
dept=Request.QueryString("dept")
flag=Request.QueryString("flag")
myflag=Request.QueryString("myflag")
classcode=Request.QueryString("classcode")
parentcode=Request.QueryString("parentcode")
if flag="" then flag="0"

delclass=Request.QueryString("delclass")
if myflag="" then myflag="0"
if classcode="" then classcode="0"

tablename="product_class"
enflag="0"
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")

if delclass<>"" then
	sqltext="select top 1 classcode from product where classcode='"+delclass+"'"
	rs.Open sqltext,cn,1,1
	if rs.EOF then
		sqltext="delete from "+tablename+" where classcode='"+delclass+"'"
		cn.Execute sqltext
		reflag="1"
	else
		Response.Write "<font color=red>警告:该类别下已有具体产品,不能删除!</font>"
	end if
	rs.Close
end if

if parentcode="" then
	sqltext="select classcode,classname from "+tablename+" where parentcode='0' and flag='"+flag+"' and basclass='"+dept+"' order by sortnum"
	rs.Open sqltext,cn,1,1
	if not rs.EOF then
		parentcode=trim(rs(0))
		title=trim(rs(1))
		rs.Close
	else
		rs.Close
		Response.Redirect("product_root.asp")	
	end if
else
	sqltext="select classcode,classname from "+tablename+" where classcode='"+parentcode+"'"
	rs.Open sqltext,cn,1,1
	if not rs.EOF then
		title=trim(rs(1))
		rs.Close
	else
		rs.Close
		Response.End
	end if
end if		

htmltitle="产品小类管理"
htmlname="product_class.asp?parentcode="+parentcode+"&flag="+flag+"&dept="+dept

if Request.ServerVariables("REQUEST_METHOD")="POST" then
	sortnum=Request.Form("sortnum")
	if classcode="0" then
		sqltext="select top 1 classcode from "+tablename+" where parentcode='"+parentcode+"' order by classcode desc"
		rs.Open sqltext,cn,1,1
		if rs.EOF then
			classcode=parentcode+"101"
		else
			classcode=rs(0)+1
		end if
		rs.Close
		if sortnum="" or not isnumeric(sortnum) then
			sqltext="select top 1 sortnum from "+tablename+" where parentcode='"+parentcode+"' order by sortnum desc"
			rs.Open sqltext,cn,1,1
			if rs.EOF then
				sortnum=10	
			else
				sortnum=rs(0)+10
			end if
			rs.Close
		end if
		rs.Open tablename,cn,3,3
		rs.AddNew
		rs("classcode")=classcode
		rs("parentcode")=parentcode
		rs("byasc")="asc"
		rs("flag")=flag
	else
		sqltext="select * from "+tablename+" where classcode='"+classcode+"'"
		rs.Open sqltext,cn,3,3
	end if
	rs("qxflag")="11110000"
	rs("basclass")=dept
	if isnumeric(sortnum) then rs("sortnum")=sortnum
	rs("classname")=trim(Request.Form("classname"))
	if enflag="1" then
		rs("content")=trim(Request.Form("content"))
		rs("classname2")=trim(Request.Form("classname2"))
		rs("content2")=trim(Request.Form("content2"))
	end if

	'Response.Write classcode
	'Response.End
	rs.Update
	rs.Close
	myflag="0"
	reflag="1"
end if
%>
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;}
.t1 {font:12px 宋体;color=000000} 
.t2 {font:12px 宋体;color:ffffff} 

.bt1 {font:14px 宋体;color=000000} 
.bt2 {font:14px 宋体;color:ffffff} 

A:link {color: #000066}
A:visited {color: #000066}
A:hover {color: #ff0000}

A.r1:link {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:visited {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:hover {font-size:12px;text-decoration:underline;color:#ff6600;}

A.r2:link {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:visited {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:hover {font-size:12px;text-decoration:underline;color:#ff6600;}
-->
</style>
</HEAD>

<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="2">
	<tr><td align="left">
		<table width="100%" border="0" cellspacing="0" cellpadding="0" height=24>
			<form name="xxform" method=post >
			<tr valign=bottom>
				<td style="font-size:12px;">&nbsp;
				<font color=DarkSlateGray style="font-size:14px"><b><%=htmltitle%></b></font>
				<font color=#ff4500 style="font-size:12px">(<%=title%>)</font>
				<a href="<%=htmlname%>">[刷新列表]</a>
				<a href="<%=htmlname%>&myflag=1">[增加]</a>
				</td>
				<td>
					选择产品大类:
		            <select name="select" onChange="if(this.options[this.selectedIndex].value!='$') {window.open(this.options[this.selectedIndex].value,'_self')}" >
					 <%
					 sql="select * from product_class where parentcode='0' and basclass='"+dept+"'"
					 rs2.Open sql,cn,1,1
					 do while not rs2.EOF
					 %> 
					  <option value="product_class.asp?parentcode=<%=trim(rs2("classcode"))%>&dept=<%=dept%>" <%if parentcode=rs2(0) then Response.Write("selected")%>><%=trim(rs2("classname"))%>&nbsp;</option>
					 <%
						rs2.MoveNext
					 loop
					 rs2.Close
					 %> 
			        </select>
				</td>
			</tr>
			</form>
	     </table>
	</td></tr>
	<%
		sqltext="select * from product_class where parentcode='"+parentcode+"' and flag='"+flag+"' order by sortnum"
		rs.Open sqltext,cn,1,1
		
		listcount=30
		rs.PageSize=listcount
		if pageno="" then pageno=1 else pageno=cint(pageno)	
		if rs.PageCount>0 then rs.AbsolutePage=pageno

	%>
	<tr><td height=200 valign=top>
		<table width="100%" border="0" cellspacing="1" cellpadding="1">
			<tr bgcolor="527c72" style="color:#ffffff" align="center">
				<td height=20 width="35" class=t2></td>
				<td class=t2 width=40>序号</td>
				<td class=t2 width=50>编号</td>
				<td class=t2 align=center>小类名称</td>
				<%if enflag="1" then%>
				<td class=t2 align=center>英文名称</td>
				<%end if%>
				<td class=t2 align=center width=90>类别图片</td>
				<td class=t2 align=center width=60>产品维护</td>
				<td class=t2 align=center width=10></td>
			</tr>
		<%
		i=1
		do while not rs.EOF 
			if (i mod 2)=0 then
				Response.Write("<tr bgcolor=fefefe>")
			else
				Response.Write("<tr bgcolor=efefef>")
			end if	
		%>
			<td width="35" align=right>
				<div align=center><img onclick="delrec('<%=trim(rs("classcode"))%>')" src="images/delete.gif" style="cursor:hand"></div>
			</td>
			<td width=40 align="center" height=22><%=rs("sortnum")%></td>
			<td width=50 align="center"><%=rs("classcode")%></td>
			<td align="left" height=20><a href="<%=htmlname%>&myflag=1&classcode=<%=trim(rs("classcode"))%>"><%=trim(rs("classname"))%></td>
			<%if enflag="1" then%>
			<td align="left" height=20><%=trim(rs("classname2"))%></td>
			<%end if%>
			<td width=120 align="center" height=20>
				<a href="Javascript:editimage('<%=rs("classcode")%>')">图片</a>
				<%if rs("picflag")="1" then Response.Write("<font color=red style='font-size:12px'>(有)</font>") else Response.Write("<font color=navy style='font-size:12px'>(无)</font>")%>
			</td>
			<td width=60 align="center" height=20><a href="product_admin.asp?classcode=<%=trim(rs("classcode"))%>&flag=<%=flag%>">产品维护</td>
			<td width=10 align="center" height=20>
			</td>
			</tr>
		<%	
			i=i+1
			rs.MoveNext
		loop
		rs.Close
		%>
		</table>
	</td></tr>
</table>
<%if myflag="1" then%>
<form action="<%=htmlname%>&classcode=<%=classcode%>" method=post name=form1 onsubmit="return checkform(form1)" autocomplete = "off">
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
	<%
	 if classcode="0" then
	 else
	  sqltext="select * from "+tablename+" where classcode='"+classcode+"'"
	  rs.Open sqltext,cn,1,1
	  if not rs.EOF then
		sortnum=rs("sortnum")
		classname=trim(rs("classname"))
		classname2=trim(rs("classname2"))
	  end if
	  rs.Close
	 end if 		
	%>
	<tr bgcolor=898989><td colspan=2 height=20><font class=t2>具体内容</font></td></tr>
	<tr><td width=600>
		<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
			<tr><td width=70 class=td1 align=right height=5></td>
				<td class=td2></td></tr>
			<tr><td width=70 class=td1 align=right>序号</td>
				<td class=td2><INPUT type="text" value="<%=sortnum%>" name=sortnum maxlength=10 size=10></td></tr>
			<tr><td width=70 class=td1 align=right>类别名称：</td>
				<td class=td2>
					<input type="text" value="<%=classname%>" name=classname maxlength=30 size=30><font color=red>*</font>
				</td></tr>
			<%if enflag="1" then%>	
			<tr><td width=70 align=right>类别介绍：</td>
				<td><textarea rows=6 cols=56 name=content style="font-family:宋体" ><%=content%></textarea></td>
			</tr>
			<tr><td width=70 class=td1 align=right>英文名称：</td>
				<td class=td2>
					<input type="text" value="<%=classname2%>" name=classname2 maxlength=50 size=50><font color=red>*</font>
				</td></tr>
			<tr><td width=70 align=right>介绍(英)：</td>
				<td><textarea rows=6 cols=56 name=content2 style="font-family:宋体" ><%=content2%></textarea></td>
			</tr>
			<%end if%>	
			<tr><td class=td2 bgcolor=ffffff ></td><td class=td2 bgcolor=ffffff align=left><br>
				&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" value="确认提交"> &nbsp;&nbsp;&nbsp;&nbsp;
			</td></tr>
		</table>
		</td>
		<td>&nbsp;</td>
	</tr>
</table>	
</form>
<%end if%>
</body>
</html>

<script language="Javascript">

	function delrec(code)
	{
		if (confirm("您确认要删除("+code+")吗？")==true)
		{
			window.location.href="<%=htmlname%>&pageno=<%=pageno%>&delclass="+code
		}
	}

	function checkform(form)
	{
		var flag=true;
		if(form("classname").value==""){alert("请输入小类名称!");form("classname").focus();return false;}
		return flag;
	}

	function editimage(keyno)
	{
		var str
		str="../admin/pic_upload.asp?keyno="+keyno+"&tablename=product_class&keyword=classcode&strflag=1"
		window.open(str,"mywin","toolbar=no,location=no,directories=no,status=no,resizable=no,menubar=no,scrollbars=yes,width=550,height=400,left=120,top=70")
	}

</script>
<%if reflag="1" then%>	
<script language="Javascript">parent.tree.location.reload();</script>
<%end if%>
💿 文件大小 6644 K
👤 上传用户 sunny_02
📂 所属分类书籍源码
🏷️ 相关标签

#商
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -