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

📄 dx_todepot.asp

📁 功能介绍： 1、产品入库
💻 ASP
字号:
🔍 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--#include file="Inc/Config.asp"-->
<!--#include file="inc/Dx_admin_check.asp"-->
<title><%=WebName%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet" type="text/css">
<style>
body {
	background-color:#FFFFFF;
}
</style>
<script language="javascript">
function collapse(img, objName)
{
	var obj;
	obj = document.getElementById(objName);
	if (img.src.indexOf('open') != -1)
	{
		img.src = img.src.replace('open', 'close');
		obj.style.display = 'none';
	}
	else
	{
		img.src = img.src.replace('close', 'open');
		obj.style.display = '';
	}
}
</script>

<script language=javascript>
function preview() { 
	bdhtml=window.document.body.innerHTML; 
	sprnstr="<!--startprint-->"; 
	eprnstr="<!--endprint-->"; 
	prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17); 
	prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr)); 
	window.document.body.innerHTML=prnhtml; 
	window.print(); 
	window.document.body.innerHTML=bdhtml; 
}
</script>
</HEAD>

<BODY>
<%
'if session("Dx_Admin")="" then
%>
<!--<br><center><img src="Images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限，请与管理员联系！</font></center>-->
<%  
 ' response.end
'end if
%>
<script>
function CheckAll(form)  {
  for (var i=0;i<form.elements.length;i++)    {
    var e = form.elements[i];
    if (e.name != 'chkall')       
		e.checked = form.chkall.checked; 
   }
  }
</script>

<%

sql="select * from [dx_site]"
rst.open sql,conn,1,1
if not rst.eof then
	dx_site_money=rst("dx_site_money")
else
	call ShowErr("请先初始化!","dx_site.asp")
end if
rst.close
dx_product_depot = request.QueryString("dx_product_depot")
dx_product_class = request.QueryString("dx_product_class")
keyword = request.QueryString("keyword")
order1 = request.QueryString("order1")
%>

<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>
<!--startprint-->
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
<form name="ToDepot" action="del.asp" method="get">
<input name="n" type="hidden" value="2" /> 
  <tr align="center">
    <td class="category" width="10">&nbsp;</td>
    <td class="category" height="30"><a href="?order1=<%if request("order1")="dx_ToDepot_id asc" then%>dx_ToDepot_id desc<%else%>dx_ToDepot_id asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">编号<%if request("order1")="dx_ToDepot_id asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category"><a href="?order1=<%if request("order1")="dx_product_model asc" then%>dx_product_model desc<%else%>dx_product_model asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">型号<%if request("order1")="dx_product_model asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category"><a href="?order1=<%if request("order1")="dx_product_depot asc,dx_ToDepot_buy_count asc" then%>dx_product_depot desc,dx_ToDepot_buy_count desc<%else%>dx_product_depot desc,dx_ToDepot_buy_count asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">入库数量/现有数量/【存放仓库】<%if request("order1")="dx_product_depot asc,dx_ToDepot_buy_count asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category"><a href="?order1=<%if request("order1")="dx_class_name asc" then%>dx_class_name desc<%else%>dx_class_name asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">类型<%if request("order1")="dx_class_name asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category"><a href="?order1=<%if request("order1")="dx_ToDepot_buy_price asc" then%>dx_ToDepot_buy_price desc<%else%>dx_ToDepot_buy_price asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">进货单价<%if request("order1")="dx_ToDepot_buy_price asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category"><a href="?order1=<%if request("order1")="dx_ToDepot_sell_price asc" then%>dx_ToDepot_sell_price desc<%else%>dx_ToDepot_sell_price asc<%end if%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>" class="title">出售单价<%if request("order1")="dx_ToDepot_sell_price asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
	<td class="category">修改</td>
    <td class="category">删除</td>
  </tr>
<%
keyword1 = split(keyword)
sql="select * from [Product_to_ToDepot] where "

if dx_product_depot<>"" then
	sql=sql&"dx_depot_name='"&dx_product_depot&"' and "
end if
if dx_product_class<>"" then
	sql=sql&"dx_class_name='"&dx_product_class&"' and "
end if
if request.QueryString("keyword")<>"" then
	for k = 0 to Ubound(keyword)
	sql=sql&"dx_product_model='"&keyword1(k)&"' and "
	next
end if
sql=left(sql,len(sql)-4)

if order1<>"" then
	sql=sql&" order by "&order1&""
else
	sql=sql&" order by dx_ToDepot_id desc"	
end if

'response.Write(sql)
'response.End()
'sql="select * from [Product_to_ToDepot] order by dx_ToDepot_id desc"
rs.open sql,conn,1,1
if not rs.eof then
	Dx_ToDepot_count=9
	rs.pagesize=Dx_ToDepot_count
	page_now=1
	if trim(request.QueryString("page"))<>"" then
		page_now=cint(trim(request.QueryString("page")))
	end if
	if page_now>rs.pagecount or page_now<0 then
		page_now=1
	end if
	rs.absolutepage=page_now
		i=1
	while(not rs.eof) and i<Dx_ToDepot_count+1
%>
  <tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''" >
    <td align="center"><img src="Images/folder_close.gif" width="2" style="cursor:hand" onClick="collapse(this, 'buy<%=i%>')" /></td>
	<td align="center" height="25"><%=rs("dx_ToDepot_id")%></td>
	<td align="center"><%=rs("dx_product_model")%></td>
	<td align="center"><%=rs("dx_ToDepot_buy_count")%>/<%=rs("dx_ToDepot_now_count")%>/【<%=rs("dx_depot_name")%>】</td>
	<td align="center"><%=rs("dx_class_name")%></td>
	<td align="center"><%=rs("dx_ToDepot_buy_price")%></td>	
	<td align="center"><%=rs("dx_ToDepot_sell_price")%></td>
	<td align="center"><a href="dx_ToDepot_edit.asp?dx_ToDepot_id=<%=rs("dx_ToDepot_id")%>"><img src="Images/res.gif" border="0" hspace="2" align="absmiddle">修改</a></td>	
    <td align="center"><input type="checkbox" name="id" value="<%=rs("dx_ToDepot_id")%>" style="border:0"></td>	
  </tr>

  <tr id="buy<%=i%>" style="display:none;">
    <td colspan="16" class="category">
	  <table align="center" cellpadding="4" cellspacing="1" class="grid" border="1" width="100%">
		<tr align="center">
		  <td width="70">图片</td>
		  <td height="30">货号</td>
		  <td>产品名称</td>
		  <td>出货仓库</td>
		  <td>数量</td>
		  <td>退货价</td>
		  <td>金额</td>
		</tr>	  
	    <tr>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>
		  <td align="center">&nbsp;</td>		  
		</tr>
	  </table>
	</td>
  </tr>
<%
	rs.movenext
	i=i+1
	wend
else
%>
  <tr align="center" onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
    <td colspan="16" height="25" align="center" style="color:red"><b>没有找到记录</b></td>
  </tr>
<%end if%>
  <tr>
    <td colspan="16" height="30" class="category">
	<table cellpadding=0 cellspacing=0 width="100%">
	<tr>
	<td width="20%" align="left" style="color:#FF0000;">&nbsp;</td>  
	<td width="80%" align="right">
<%
	if page_now=1 then 
		response.Write("第一页"&vbTab)
	else response.Write("<a href='?page=1&dx_product_class="&dx_product_class&"&keyword="&keyword&"&dx_product_depot="&dx_product_depot&"'>第一页</a>"&vbTab)
	end if
	if page_now>1 and rs.pagecount>1 then 
		response.Write("<a href=""?page="&page_now-1&"&dx_product_class="&dx_product_class&"&keyword="&keyword&"&dx_product_depot="&dx_product_depot&""">上一页</a>"&vbTab)
	else response.Write("上一页"&vbTab)
	end if
	if page_now<rs.pagecount then 
		response.Write("<a href=""?page="&page_now+1&"&dx_product_class="&dx_product_class&"&keyword="&keyword&"&dx_product_depot="&dx_product_depot&""">下一页</a>"&vbTab)
	else response.Write("下一页"&vbTab)
	end if
	if page_now<>rs.pagecount then 
		response.Write("<a href=""?page="&rs.pagecount&"&dx_product_class="&dx_product_class&"&keyword="&keyword&"&dx_product_depot="&dx_product_depot&""">尾页</a>"&vbTab)
    else response.Write("尾页"&vbTab)
	end if 
%>
		<select name="page" onChange="javascript:location.href='?dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&dx_product_depot=<%=dx_product_depot%>&page='+this.options[this.selectedIndex].value">
		<%
		for p = 1 to rs.pagecount
		%>
		  <option <%if page_now=p then%>selected="selected"<%end if%> value="<%=p%>"><%=p%></option>
		<%
		next
		rs.close
		%>
		</select>
		<input name="chkall" type="checkbox" id="chkall" value="select" onClick="CheckAll(this.form)" style="border:0"> 全选
		<input type="submit" value="删 除" onClick="return confirm('此操作无法恢复！！！请慎重！！！\n\n确定要删除所选择的退货记录吗？')" class="button">
	</td>
  </tr></table></td></tr>

</form>   
</table>
<!--endprint-->
</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 + -