produit_add.asp

很实用的进销存管理系统

        <td align="right" height="30">经办人：</td>
        <td class="category">
		  <%
		  if session("shiwei_id")=1 then
			sql="select * from login order by id_zu,id"
			set rs_login=conn.execute(sql)
		  else
			sql="select * from login where id="&session("shiwei_id")
			set rs_login=conn.execute(sql)	  
		  end if
		  if rs_login.eof then
		  %>
	      <script language="javascript">
	        alert("请先添加员工！")
	        window.location.href="../system/user_add.asp"
	      </script>
		  <%
		  response.end
		  else
		  %>
		  <select name="id_login">
		  <%
		  do while rs_login.eof=false
		  %>
		    <option value="<%=rs_login("id")%>"<%if rs_login("username")=session("shiwei_username") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("bianhao")%>)</option>
		  <%
		    rs_login.movenext
		  loop
		  %>
		  </select>
		  <%
		  end if
		  %>		
		</td>
      </tr>
	  <tr>
	    <td align="right" height="30">备注：</td>
        <td class="category">
		  <textarea name="beizhu" cols="60" rows="3"></textarea>
		</td>
      </tr>   
      <tr>
	    <td height="30">　</td>
        <td class="category">
		  <input type="submit" value=" 确认添加 " onClick="return check1()" class="button">
		  <input type="hidden" name="hid1" value="ok">
		  <input type="reset" value=" 重新填写 " class="button">
		  </td>
      </tr>
	  </form>
</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>

<table cellpadding=0 cellspacing=0 width="98%" align=center><tr><td height="5"></td></tr></table>

<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">　</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">
	  <form name="form3">
      <tr>
        <td align="right" height="30">所属大类：</td>
        <td class="category">
    <%
	sql="select * from bigclass order by id"
	set rs_bigclass=conn.execute(sql)
	if rs_bigclass.eof then
	%>
	<script language="javascript">
	  alert("请先添加产品大类！")
	  window.location.href="../system/bigclass_add.asp"
	</script>
	<%	
	response.end
	end if
	nowbigclass=request("bigclass")
	if nowbigclass="" then
	  nowbigclass=rs_bigclass("id")
	end if
	%>
	  <select name="bigclass" onChange="form3.submit()">
        <%
	do while rs_bigclass.eof=false
	%>
        <option value="<%=rs_bigclass("id")%>"<%if trim(cstr(rs_bigclass("id")))=nowbigclass then%> selected="selected"<%end if%>><%=rs_bigclass("bigclass")%></option>
        <%
	  rs_bigclass.movenext
	loop
	%>
      </select>		  
		  </td>
      </tr>	
	  </form>
	  <form name="form2"> 
	  <input type="hidden" name="bigclass" value="<%=nowbigclass%>">
      <tr>
        <td align="right" height="30">所属小类：</td>
        <td class="category">
    <%
	sql="select * from smallclass where id_bigclass="&nowbigclass&" order by id"
	set rs_smallclass=conn.execute(sql)
	%>
	  <select name="smallclass">
	    <option value="0"></option>
        <%
	do while rs_smallclass.eof=false
	%>
        <option value="<%=rs_smallclass("id")%>"<%if trim(cstr(rs_smallclass("id")))=nowsmallclass then%> selected="selected"<%end if%>><%=rs_smallclass("smallclass")%></option>
        <%
	  rs_smallclass.movenext
	loop
	%>
      </select>  
		  </td>
      </tr>	   
      <tr>
        <td width="20%" height="30" align="right">产品名称：</td>
        <td width="80%" class="category">
		  <input name="title" type="text" style="width:200px;">&nbsp;<font color="#ff0000">*</font></td>
      </tr>
      <tr>
        <td align="right" height="30">产品货号：</td>
        <td class="category">
          <input type="text" name="huohao" style="width:200px">&nbsp;<font color="#ff0000">*</font></td>
      </tr>
      <tr>
        <td align="right" height="30">加入仓库：</td>
        <td class="category">
    <%
	if session("shiwei_id")=1 then
	  sql="select * from ku order by id"
	  set rs_ku=conn.execute(sql)
	else
	  sql="select * from ku where instr(login,'"&session("shiwei_id")&",')>0 order by id"
	  set rs_ku=conn.execute(sql)	  
	end if
	if rs_ku.eof then
	%>
	<script language="javascript">
	  alert("没有属于你管理的仓库,请先添加仓库！")
	  window.location.href="../system/ku_add.asp"
	</script>
	<%
	response.end
	end if
	%>
	  <select name="ku">
        <%
	do while rs_ku.eof=false
	%>
        <option value="<%=rs_ku("id")%>"<%if rs_ku("moren") then%> selected="selected"<%end if%>><%=rs_ku("ku")%></option>
        <%
	  rs_ku.movenext
	loop
	%>
      </select>			  
		  </td>
      </tr>	  
      <tr>
        <td align="right" height="30">入库数量：</td>
        <td class="category"><input type="text" name="shulian" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))" value="1">
          &nbsp;<font color="#ff0000">*</font></td>
      </tr>
      <tr>
        <td align="right" height="30">产品单位：</td>
        <td class="category">
    <%
	sql="select * from danwei order by id"
	set rs_danwei=conn.execute(sql)
	if rs_danwei.eof then
	%>
	<script language="javascript">
	  alert("请先添加单位！")
	  window.location.href="../system/danwei_add.asp"
	</script>
	<%
	response.end
	end if
	%>
	  <select name="danwei">
        <%
	do while rs_danwei.eof=false
	%>
        <option value="<%=rs_danwei("danwei")%>"><%=rs_danwei("danwei")%></option>
        <%
	  rs_danwei.movenext
	loop
	%>
      </select>
	  <font color="#666666">(只用于普通识别，不能换算)</font>		  </td>
      </tr>		  
      <tr>
        <td align="right" height="30">产品价格：</td>
        <td class="category">推荐卖价：<input type="text" name="price" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">
		  <font color="#666666">元</font>
		  进货价：<input type="text" name="price2" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))">
          <font color="#666666">元</font></td>
      </tr>	  
      <tr>
        <td align="right" height="30">规格：</td>
        <td class="category"><input type="text" name="guige" style="width:200px"></td>
      </tr>
      <tr>
        <td align="right" height="30">最低库存报警数量：</td>
        <td class="category"><input type="text" name="baojin" style="width:100px" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))" value="0"> 
          <font color="#666666">(设为零将不会报警)</font></td>
      </tr>	  
      <tr>
        <td align="right" height="30">经办人：</td>
        <td class="category">
		  <%
		  if session("shiwei_id")=1 then
			sql="select * from login order by id_zu,id"
			set rs_login=conn.execute(sql)
		  else
			sql="select * from login where id="&session("shiwei_id")
			set rs_login=conn.execute(sql)	  
		  end if
		  if rs_login.eof then
		  %>
	      <script language="javascript">
	        alert("请先添加员工！")
	        window.location.href="../system/user_add.asp"
	      </script>
		  <%
		  response.end
		  else
		  %>
		  <select name="id_login">
		  <%
		  do while rs_login.eof=false
		  %>
		    <option value="<%=rs_login("id")%>"<%if rs_login("username")=session("shiwei_username") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("bianhao")%>)</option>
		  <%
		    rs_login.movenext
		  loop
		  %>
		  </select>
		  <%
		  end if
		  %>		</td>
      </tr>	
      <tr>
        <td align="right" height="30">供应商：</td>
        <td class="category">
		  <%
		  sql="select * from gys order by id"
		  set rs_gys=conn.execute(sql)
		  %>
		  <select name="id_gys">
		    <option value="0"></option>
		  <%
		  do while rs_gys.eof=false
		  %>
		    <option value="<%=rs_gys("id")%>"><%=rs_gys("company")%></option>
		  <%
		    rs_gys.movenext
		  loop
		  %>
		  </select>
		</td>
      </tr>		  
      <tr>
        <td align="right" height="30">产品类型：</td>
        <td class="category">
		  <select name="class">
		    <option value="0">正常产品</option>
			<option value="1">公司赠品</option>
		  </select>
		  </td>
      </tr>
      <tr>
        <td align="right" height="30">兑换所需积分：</td>
        <td class="category">
          <input type="text" name="duihuan" style="width:100px" onKeyUp="this.value=this.value.replace(/\D/g,'')"  onafterpaste="this.value=this.value.replace(/\D/g,'')" value="0">
          <font color="#666666">(会员兑换此礼品所需积分)</font></td>
      </tr>	  	  
      <tr>
        <td align="right" height="30">提成类型：</td>
        <td class="category">
		  <select name="tichen_type" onChange="chg1(this.value)">
		    <option value="0">按百分比提成</option>
			<option value="1">固定提成</option>
		  </select>
		</td>
      </tr>		    
      <tr>
        <td align="right" height="30">员工提成：</td>
        <td class="category">
		  销售一件提成：<input type="text" name="tichen" style="width:50px" value="0">
		  <font color="#666666"><span id="bian1">%</span></font></td>
      </tr>
      <tr>
        <td align="right" height="30">产品备注：</td>
        <td class="category">
          <textarea name="beizhu" cols="60" rows="3"></textarea>
        </td>
      </tr>	  
	  <%if showpic="yes" then%>
      <tr>
        <td align="right" height="30">产品图片：</td>
        <td class="category">
		  <table cellpadding="3" cellspacing="0" width="100%"><tr><td width="20%" align="center">
		  <div id=pic style="width:100;height:100;background-color:ffffff;border:solid 1 #FBA685"><br><br><br>&nbsp;&nbsp;&nbsp;暂无图片</div></td>
		  <td width="80%">
		  <font color="#ff0000">选择完图片后，请点击上传按钮上传图片！</font><br>
          <iframe src="../uploadpic.asp" width=400 height=30 frameborder=none framespacing=0 scrolling=no noresize marginwidth=0 marginheight=0></iframe><br>
          <font color=999999>所选图片都必须是 jpg 或 gif 格式</font>
		  </td></tr></table>
		</td>
      </tr>	
	  <%end if%>	  	  
      <tr>
	    <td height="30">　</td>
        <td class="category"><input type="submit" value=" 确认添加 " onClick="return check()" class="button">&nbsp;&nbsp;&nbsp;&nbsp;
		  <input type="hidden" name="hid2" value="ok">
		  <input type="hidden" name="photo" value="">
		  <input type="reset" value=" 重新填写 " class="button">		</td>
      </tr>
	  </form>
</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>