⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 produit_show.asp

📁 不错的进销存管理系统。功能比较全
💻 ASP
字号:
<%
if session("yida_username")="" then
%>
<script language="javascript">
top.location.href="../index.asp"
</script>
<%  
  response.end
end if
%>
<!-- #include file="../conn2.asp" -->
<!-- #include file="../const.asp" -->
<html>
<head>
<title><%=dianming%> - 产品详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style/style.css" rel="stylesheet" type="text/css">
<style>
body {
	background-color:#FFFFFF;
}
</style>
</HEAD>

<BODY>
<%
if fla13="0" and session("shiwei_id")<>"1" then
%>
<br><center><img src="../images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限,请与管理员联系!</font></center>
<%  
  response.end
end if
%>
<%
sql="select * from produit where id="&request("id")
set rs=conn.execute(sql)
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="../images/r_1.gif" alt="" /></td>
<td width="100%" background="../images/r_0.gif">
  <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td>&nbsp;产品详细信息</td>
	  <td align="right">&nbsp;</td>
    </tr>
  </table>
</td>
<td><img src="../images/r_2.gif" alt="" /></td>
</tr>
<tr>
<td></td>
<td>
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
      <tr>
        <td align="right" height="30">所属大类:</td>
        <td class="category">
          <%
	      sql="select * from bigclass where id="&rs("id_bigclass")
	      set rs_bigclass=conn.execute(sql)
	      %>
          <%=rs_bigclass("bigclass")%></td>
      </tr>  
      <tr>
        <td align="right" height="30">所属小类:</td>
        <td class="category">
          <%
	      sql="select * from smallclass where id="&rs("id_smallclass")
	      set rs_smallclass=conn.execute(sql)
		  %>
          <%if rs_smallclass.eof=false then%><%=rs_smallclass("smallclass")%><%else%>&nbsp;<%end if%></td>
      </tr>	   
      <tr>
        <td width="25%" height="30" align="right">产品名称: </td>
        <td width="75%" class="category"><%=rs("title")%></td>
      </tr>
      <tr>
        <td align="right" height="30">产品货号: </td>
        <td class="category"><%=rs("huohao")%></td>
      </tr>
      <tr>
        <td align="right" height="30">库存数量:</td>
        <td class="category">
		  <%
	      sql="select * from produit where huohao='"&rs("huohao")&"'"
	      set rs_shulian=conn.execute(sql)
	      nowshulian=0
		  nowtext=""
	      do while rs_shulian.eof=false
   	        nowshulian=nowshulian+rs_shulian("shulian")
			sql="select * from ku where id="&rs_shulian("id_ku")
			set rs_ku=conn.execute(sql)
		    nowtext=nowtext+rs_ku("ku")&"("&formatnumber(rs_shulian("shulian"),2)&"),"
	        rs_shulian.movenext
	      loop		  
		  %>
		  共<%=formatnumber(nowshulian,2)%>,<%=left(nowtext,len(nowtext)-1)%></td>
      </tr>
      <tr>
        <td align="right" height="30">产品单位:</td>
        <td class="category"><%=rs("danwei")%></td>
      </tr>		  
      <tr>
        <td align="right" height="30">产品价格:</td>
        <td class="category">推荐卖价:<%=formatnumber(rs("price"),2)%><%if session("shiwei_id")="1" or fla87="1" then%>,进货价:<%=formatnumber(rs("price2"),2)%><%end if%></td>
      </tr>	  
      <tr>
        <td align="right" height="30">规格:</td>
        <td class="category"><%=rs("guige")%></td>
      </tr>
      <tr>
        <td align="right" height="30">最低库存报警数量:</td>
        <td class="category"><%=rs("baojin")%></td>
      </tr>	  
      <tr>
        <td align="right" height="30">产品类型:</td>
        <td class="category"><%if rs("class")=0 then%>正常产品<%else%>公司赠品<%end if%></td>
      </tr>
      <tr>
        <td align="right" height="30">兑换所需积分:</td>
        <td class="category"><%=rs("duihuan")%></td>
      </tr>	  	  
      <tr>
        <td align="right" height="30">提成:</td>
        <td class="category">
		  <%if rs("tichen_type")=0 then%>按百分比提成<%else%>固定提成<%end if%>,
		  销售一件提成:<%=rs("tichen")%> <%if rs("tichen_type")=0 then%>%<%else%>元<%end if%>
		</td>
      </tr>
      <tr>
        <td align="right" height="30">产品备注:</td>
        <td class="category">
		  <%=replace(replace(rs("beizhu")&""," ","&nbsp;"),chr(13),"<br>")%></td>
      </tr>	  
	  <%if showpic="yes" then%>
      <tr>
        <td align="right" height="30">图片:</td>
        <td class="category">
		  <%if rs("photo")<>"" then%><a href="../upload/<%=rs("photo")%>" target="_blank"><img src="../upload/<%=rs("photo")%>" border="0"></a><%else%>无图<%end if%>
		</td>
      </tr>
	  <%end if%>		  		      
	  </table>
</td>
<td></td>
</tr>
<tr>
<td><img src="../images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="../images/r_3.gif" alt="" /></td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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