<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
|
<%Session.CodePage=65001%>
|
<!--#include virtual="/inc/chkadmin.gds"-->
|
<!--#include virtual="/inc/function.gds"-->
|
<%
|
'各种返回信息
|
SystemMessageType=trim(Request("SystemMessageType"))
|
SMT=trim(Request("SMT"))
|
if SystemMessageType="3" then
|
if SMT="1" then
|
SystemMessageTXT="部门列表更新完成"
|
elseif SMT="2" then
|
SystemMessageTXT="货架修改完成"
|
elseif SMT="3" then
|
SystemMessageTXT="新建货架完成"
|
elseif SMT="4" then
|
SystemMessageTXT="货架删除完成"
|
end if
|
elseif SystemMessageType="1" then
|
if SMT="1" then
|
SystemMessageTXT="请选择需要修改的货架"
|
elseif SMT="2" then
|
SystemMessageTXT="请选择需要删除的货架"
|
elseif SMT="3" then
|
SystemMessageTXT="每次只可以删除一个货架"
|
end if
|
elseif SystemMessageType="4" then
|
if SMT="1" then
|
SystemMessageTXT="数据不足!!"
|
elseif SMT="2" then
|
SystemMessageTXT="修改失败!!"
|
elseif SMT="3" then
|
SystemMessageTXT="请输入新货架名称!!"
|
elseif SMT="4" then
|
SystemMessageTXT="货架名称重复,请重新输入!!"
|
end if
|
end If
|
|
searchTXT=trim(Request("searchTXT"))
|
|
page_URL="&searchTXT="&searchTXT
|
|
acc1=clng(request("page"))
|
if acc1=empty then acc1=clng(1)
|
QuantityInt = 20
|
acc2=0
|
acc3=0
|
|
Set rs = Server.CreateObject("ADODB.Recordset")
|
if searchTXT<>"" then
|
searchSql=" vtitle in ('WarehouseShelves') and (vtext like '%"&searchTXT&"%' or vtitle='"&searchTXT&"' or vOrder in (select WarehouseID from MRP_Warehouse where WarehouseName like '%"&searchTXT&"%')) "
|
orderby=" order by vOrder, id desc"
|
else
|
'searchSql=" OA_execLevel in (0,1) and (OA_B2bID=0 or OA_B2bID in (select SupplierID from B2B_Supplier where Supplier_is=0) or OA_B2bID in (select DealerID from B2B_Dealer where Dealer_is=0))"
|
searchSql=" vtitle in ('WarehouseShelves') "
|
orderby=" order by id desc"
|
end If
|
StockWarehouseTypes = ""
|
sql="select WarehouseID,WarehouseName from MRP_Warehouse order by WarehouseID desc"
|
rs.open Sql,objConn,1,1
|
do while not rs.Eof
|
If CInt(StockWarehouseID)=rs("WarehouseID") Then StockWarehouseName = rs("WarehouseName")
|
StockWarehouseTypes = StockWarehouseTypes & rs("WarehouseID") &","& rs("WarehouseName") & "|"
|
rs.movenext
|
Loop
|
rs.close()
|
StockWarehouseTypes = left(StockWarehouseTypes,len(StockWarehouseTypes)-1)
|
StockWarehouseTypesPS = SPLIT(StockWarehouseTypes,"|")
|
%>
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<title><%=LindemanAdmin%></title>
|
<!--#include virtual="/inc/ccs.gds"-->
|
</head>
|
<body onkeydown="xKeyEvent(event)">
|
<!--#INCLUDE FILE="menu_header.gds" -->
|
<!-- content -->
|
<div id="content">
|
<!--#INCLUDE FILE="MRP_menu_left.gds" -->
|
<!-- content / right -->
|
<div id="right">
|
<!-- table -->
|
<div class="box">
|
<!-- box / title -->
|
<div class="title">
|
<h5>货架管理 <%=searchTXT%></h5>
|
<ul class="links">
|
<li><a onclick="javascript:dictionaryCreate.style.display='block';">新建</a></li>
|
<li><a onClick="form1_dictionary_update()">修改</a></li>
|
<li><a onClick="form1_dictionary_delete()">删除</a></li>
|
<div class="search">
|
<form action="MRP_WarehouseShelves.gds" method="post">
|
<div class="input">
|
<input type="text" id="search" name="searchTXT" value="<%=searchTXT%>" />
|
</div>
|
<div class="button">
|
<input type="submit" name="submit" value="搜索" />
|
</div>
|
</form>
|
</div>
|
</ul>
|
<script LANGUAGE="javascript">
|
//修改货架
|
function form1_dictionary_update(){
|
document.form1.action = "admin_save.gds";
|
document.form1.admin_save.value="16"
|
form1.submit();
|
}
|
//删除货架
|
function form1_dictionary_delete(){
|
document.form1.action = "admin_save.gds";
|
document.form1.admin_save.value="18"
|
form1.submit();
|
}
|
//选择修改货架
|
function form1_dictionary_Edit(id){
|
if (document.getElementById('Show_vID_'+id).style.display=="none")
|
{
|
document.getElementById('Show_vID_'+id).style.display='';
|
document.getElementById('Edit_vID_'+id).style.display='none';
|
document.getElementById('vID_'+id).disabled=true;
|
document.getElementById('Show_vtext_'+id).style.display='';
|
document.getElementById('Edit_vtext_'+id).style.display='none';
|
document.getElementById('vtext_'+id).disabled=true;
|
document.getElementById('Show_vType_'+id).style.display='';
|
document.getElementById('Edit_vType_'+id).style.display='none';
|
document.getElementById('vType_'+id).disabled=true;
|
document.getElementById('Show_vOrder_'+id).style.display='';
|
document.getElementById('Edit_vOrder_'+id).style.display='none';
|
document.getElementById('vOrder_'+id).disabled=true;
|
document.getElementById('Show_vOrder2_'+id).style.display='';
|
document.getElementById('Edit_vOrder2_'+id).style.display='none';
|
document.getElementById('vOrder2_'+id).disabled=true;
|
}
|
else
|
{
|
document.getElementById('Show_vID_'+id).style.display='none';
|
document.getElementById('Edit_vID_'+id).style.display='';
|
document.getElementById('vID_'+id).disabled=false;
|
document.getElementById('Show_vtext_'+id).style.display='none';
|
document.getElementById('Edit_vtext_'+id).style.display='';
|
document.getElementById('vtext_'+id).disabled=false;
|
document.getElementById('Show_vType_'+id).style.display='none';
|
document.getElementById('Edit_vType_'+id).style.display='';
|
document.getElementById('vType_'+id).disabled=false;
|
document.getElementById('Show_vOrder_'+id).style.display='none';
|
document.getElementById('Edit_vOrder_'+id).style.display='';
|
document.getElementById('vOrder_'+id).disabled=false;
|
document.getElementById('Show_vOrder2_'+id).style.display='none';
|
document.getElementById('Edit_vOrder2_'+id).style.display='';
|
document.getElementById('vOrder2_'+id).disabled=false;
|
}
|
}
|
//新建货架-关闭上传窗口
|
function JS_dictionaryCreateClose()
|
{
|
dictionaryCreate.style.display="none";
|
}
|
//新建货架-保存
|
function JS_dictionaryCreateSave()
|
{
|
form2.submit();
|
}
|
</script>
|
</div>
|
<%sql="select top 1 vID,vtext,vtitle,vType,vMono,vOrder,vOrder2 from dictionary where "&searchSql&" order by id desc"
|
rs.open sql,objConn,1,1
|
if not rs.eof Then
|
vID = rs("vID")+1
|
vtext = rs("vtext")
|
vtitle= rs("vtitle")
|
vType = rs("vType")
|
vMono = rs("vMono")
|
vOrder= rs("vOrder")
|
vOrder2=rs("vOrder2")
|
end If
|
rs.close()
|
If vID="" Then vID=1
|
%>
|
<div class="dialogJ dialogJfix dialogJshadow" id="dictionaryCreate" style="width: 370px; right: 80px; top: 150px;display:none;">
|
<div class="dialogJtitle">
|
<a href="javascript:JS_dictionaryCreateClose();" class="dialogJclose" title="关闭本窗口"> </a>
|
<span class="dialogJtxt" id="EditPhotoTXT">新建货架</span>
|
</div>
|
<form id="form2" name="form2" action="admin_save.gds" method="post">
|
<input name="admin_save" type="hidden" value="17">
|
<input name="vtitle" type="hidden" value="WarehouseShelves">
|
<input name="vMono" type="hidden" value="货架信息">
|
<input name="searchTXT" type="hidden" value="<%=searchTXT%>">
|
<input name="page" type="hidden" value="<%=acc1%>">
|
<div class="dialogJcontent">
|
<div class="dialogJbody" id="dialogJbody" style="height: 100px;">
|
<div class="modify-album-name">
|
<span>ID ：</span>
|
<input id="vID" name="vID" type="text" value="<%=vID%>" style="width: 74px;" maxlength="99/">
|
<span>状态：</span>
|
<input id="vType" name="vType" type="text" value="1" style="width: 25px;" maxlength="99/">(0无效,1有效)
|
</div>
|
<div class="modify-album-name">
|
<span>货架名称：</span>
|
<input id="vtext" name="vtext" type="text" value="" maxlength="99/">
|
</div>
|
<div class="modify-album-name">
|
<span>所属仓库：</span>
|
<select name="vOrder" id="vOrder" style="padding: 5px 0 5px 8px;">
|
<option value="">请选择</option>
|
<%for z = 0 to UBOUND(StockWarehouseTypesPS)
|
StockWarehouseTypesPS1=SPLIT(StockWarehouseTypesPS(z),",")
|
WID=StockWarehouseTypesPS1(0)
|
WName=StockWarehouseTypesPS1(1)
|
%>
|
<option value="<%=WID%>"><%=WName%></option>
|
<%next%>
|
</select>
|
</div>
|
<div class="modify-album-name">
|
<span>货架备注：</span>
|
<input id="vOrder2" name="vOrder2" type="text" value="" maxlength="99/">
|
</div>
|
</div>
|
</div>
|
</form>
|
<div class="dialogJanswers">
|
<input type="button" class="dialogJbtn first-child" onclick="JS_dictionaryCreateSave()" value="确定">
|
<input type="button" class="dialogJbtn" onclick="JS_dictionaryCreateClose()" value="取消">
|
</div>
|
</div>
|
<!-- end box / title -->
|
<%' vtitle='OA_Department' and vType>0
|
|
|
|
'vtitle,vID,vOrder,id
|
sql="select id,vID,vtext,vtitle,vType,vMono,vOrder,vOrder2,WarehouseName from dictionary,MRP_Warehouse where WarehouseID=vOrder and "&searchSql&orderby
|
rs.open sql,objConn,1,1
|
if not rs.eof then
|
rs.pagesize=QuantityInt
|
rs.absolutepage=acc1
|
acc2=rs.pagecount
|
acc3=rs.recordcount
|
else
|
SystemMessageType=2
|
SystemMessageTXT="数据库中相关无数据！"
|
end if
|
%>
|
<!--#include virtual="/inc/SystemMessages.gds" -->
|
<div class="table">
|
<form id="form1" name="form1" action="" method="post">
|
<input name="admin_save" type="hidden" value="16">
|
<input name="vtitle" type="hidden" value="WarehouseShelves">
|
<input name="searchTXT" type="hidden" value="<%=searchTXT%>">
|
<input name="page" type="hidden" value="<%=acc1%>">
|
<table>
|
<thead>
|
<tr>
|
<th class="selected"><input type="checkbox" class="checkall" /></th>
|
<th>ID</th>
|
<th>货架名称</th>
|
<th>所属仓库</th>
|
<th>货架备注</th>
|
<th>货架状态</th>
|
<th class="last"></th>
|
</tr>
|
</thead>
|
<tbody>
|
|
<%i=1
|
do while not rs.Eof and i<=QuantityInt
|
id = rs("id")
|
vID = rs("vID")
|
vtext = rs("vtext")
|
vtitle= rs("vtitle")
|
vType = rs("vType")
|
vMono = rs("vMono")
|
vOrder= rs("vOrder")
|
vOrder2=rs("vOrder2")
|
WarehouseName=rs("WarehouseName")
|
If vType>1 Then
|
vTypeTXT=""
|
For I = 2 to vType
|
vTypeTXT=vTypeTXT&"--"
|
Next
|
ClassName=vTypeTXT&vtext
|
Else
|
ClassName=vtext
|
End If
|
i=i+1
|
%>
|
<input name="dictionaryID_<%=id%>" type="hidden" value="<%=dictionaryID%>">
|
<input name="vtitle_<%=id%>" type="hidden" value="<%=vtitle%>">
|
<input name="vMono_<%=id%>" type="hidden" value="<%=vMono%>">
|
<tr>
|
<td class="selected"><input type="checkbox" id="ID_<%=id%>" name="ID" value="<%=id%>" onclick="javascript:form1_dictionary_Edit('<%=id%>')"/></td>
|
<td class="selected" id="Show_vID_<%=id%>"><%=vID%></td>
|
<td class="selected" id="Edit_vID_<%=id%>" style="display:none;"><input id="vID_<%=id%>" name="vID_<%=id%>" class="small" style="width:50px;text-align: center;" value="<%=vID%>" type="text" disabled="true"></td>
|
<td class="category" id="Show_vtext_<%=id%>" style="text-align: left;"> <%=ClassName%></td>
|
<td class="category" id="Edit_vtext_<%=id%>" style="display:none;"><input id="vtext_<%=id%>" name="vtext_<%=id%>" class="small" style="width:120px;text-align: center;" value="<%=vtext%>" type="text" disabled="true"></td>
|
<td class="category" id="Show_vOrder_<%=id%>"><%=WarehouseName%></td>
|
<td class="category" id="Edit_vOrder_<%=id%>" style="display:none;">
|
<select name="vOrder_<%=id%>" id="vOrder_<%=id%>" style="padding: 1px 0 1px 8px;" disabled="true">
|
<%for z = 0 to UBOUND(StockWarehouseTypesPS)
|
StockWarehouseTypesPS1=SPLIT(StockWarehouseTypesPS(z),",")
|
WID=StockWarehouseTypesPS1(0)
|
WName=StockWarehouseTypesPS1(1)
|
%>
|
<option value="<%=WID%>"<%If CInt(WID)=CInt(vOrder) Then Response.Write " selected"%>><%=WName%></option>
|
<%next%>
|
</select>
|
</td>
|
<td class="date" id="Show_vOrder2_<%=id%>" style="text-align: left;"><%=vOrder2%></td>
|
<td class="date" id="Edit_vOrder2_<%=id%>" style="display:none;text-align: left;"><input id="vOrder2_<%=id%>" name="vOrder2_<%=id%>" class="small" style="width:400px;text-align: center;" value="<%=vOrder2%>" type="text" disabled="true"></td>
|
<td class="category last" id="Show_vType_<%=id%>"><%=vType%></td>
|
<td class="category last" id="Edit_vType_<%=id%>" style="display:none;"><input id="vType_<%=id%>" name="vType_<%=id%>" class="small" style="width:40px;text-align: center;" value="<%=vType%>" type="text" disabled="true"></td>
|
|
|
</tr>
|
<%rs.movenext
|
loop
|
rs.close()
|
%>
|
<%for j=i to 21%>
|
<tr>
|
<td class="selected"> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td class="last"> </td>
|
|
</tr>
|
<%next%>
|
</tbody>
|
</table>
|
<!-- pagination -->
|
<div class="pagination pagination-left">
|
<div class="results">
|
<%
|
ShowingLeast = (acc1-1)*QuantityInt+1
|
ShowingMax = QuantityInt*acc1
|
if ShowingMax>acc3 then ShowingMax=acc3
|
%>
|
<span><%="显示 "& ShowingLeast &"-"& ShowingMax &" of "&acc3%></span>
|
</div>
|
<%if acc2>1 then%>
|
<ul class="pager">
|
<%if acc1=1 then%>
|
<li class="disabled">« 上页</li>
|
<%else%>
|
<li><a href="?page=<%=acc1-1%><%=page_URL%>">« 上页</a></li>
|
<%end if%>
|
<%
|
acc4=""
|
for i=1 to acc2
|
if acc2<=9 then
|
acc4=acc4&","&i
|
else
|
if i=1 then
|
acc4=acc4&","&i
|
elseif acc1<=5 and i<=7 then
|
acc4=acc4&","&i
|
elseif acc1>=acc2-4 and i>=acc2-6 then
|
acc4=acc4&","&i
|
elseif i>=acc1-2 and i<=acc1+2 then
|
acc4=acc4&","&i
|
elseif i=acc2 then
|
acc4=acc4&","&i
|
elseif i=2 or i=acc2-1 then
|
acc4=acc4&",0"
|
end if
|
end if
|
next
|
acc4SP=SPLIT(acc4,",")
|
for i = 1 to UBOUND(acc4SP)%>
|
<%if acc4SP(i)="0" then%>
|
<li class="separator">...</li>
|
<%elseif acc1=cint(acc4SP(i)) then%>
|
<li class="current"><%=acc4SP(i)%></li>
|
<%else%>
|
<li><a href="?page=<%=acc4SP(i)%><%=page_URL%>"><%=acc4SP(i)%></a></li>
|
<%end if%>
|
<%next%>
|
<%if acc1>=acc2 then%>
|
<li class="disabled">下页 »</li>
|
<%else%>
|
<li><a href="?page=<%=acc1+1%><%=page_URL%>">下页 »</a></li>
|
<%end if%>
|
</ul>
|
<%end if%>
|
</div>
|
<!-- end pagination -->
|
</form>
|
</div>
|
</div>
|
<!-- end table -->
|
|
|
</div>
|
<!-- end content / right -->
|
</div>
|
<!-- end content -->
|
<!--#include FILE="vicgame.asp"-->
|
</body>
|
</html>
|
