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

📄 lingliaodan.asp

📁 网佳网络办公系统（以下简称OA）是一套基于B/S模式的无纸化办公系统。[显著特点：无须安装客户端] 主要功能模块：管理 公文 车辆 通知 档案 值班 人事 审批 仓库 主界面 软件下载 个
💻 ASP
字号:
🔍 
<!--#include file="bkconn.asp"-->
<%
if request.querystring("id")="" then
response.write "没有正确的ID号"
else
NUMBER=clng(request.querystring("id"))
'重新提取数据
set RST=conn.execute("select  * from 出库 where id=" &NUMBER)
aa=rst("材料名称")
'zongjine=rst("金额1")+rst("金额2")+rst("金额3")+rst("金额4")+rst("金额5")
a1=rst("金额1")
a2=rst("金额2")
a3=rst("金额3")
a4=rst("金额4")
a5=rst("金额5")
zonge=a1+a2+a3+a4+a5

'-----------------获取材料名称等信息start

if rst("材料名称2")<>"空" then
ziduan2=rst("材料名称2")
mingcheng2=left(ziduan2,Instr(ziduan2,"|")-1) '获取材料名称
saa2=mid(ziduan2,Instr(ziduan2,"|")+1,InstrRev(ziduan2,"|")-Instr(ziduan2,"|")-1)'型号
sbb2=right(ziduan2,len(ziduan2)-InstrRev(ziduan2,"|")) '单位
else
mingcheng2=rst("材料名称2")
end if
if rst("材料名称3")<>"空" then
ziduan3=rst("材料名称3")
mingcheng3=left(ziduan3,Instr(ziduan3,"|")-1) '获取材料名称
saa3=mid(ziduan3,Instr(ziduan3,"|")+1,InstrRev(ziduan3,"|")-Instr(ziduan3,"|")-1)'型号
sbb3=right(ziduan3,len(ziduan3)-InstrRev(ziduan3,"|")) '单位
else
mingcheng3=rst("材料名称3")
end if
if rst("材料名称4")<>"空" then
ziduan4=rst("材料名称4")
mingcheng4=left(ziduan4,Instr(ziduan4,"|")-1) '获取材料名称
saa4=mid(ziduan4,Instr(ziduan4,"|")+1,InstrRev(ziduan4,"|")-Instr(ziduan4,"|")-1)'型号
sbb4=right(ziduan4,len(ziduan4)-InstrRev(ziduan4,"|")) '单位
else
mingcheng4=rst("材料名称4")
end if
if rst("材料名称5")<>"空" then
ziduan5=rst("材料名称5")
mingcheng5=left(ziduan5,Instr(ziduan5,"|")-1) '获取材料名称
saa5=mid(ziduan5,Instr(ziduan5,"|")+1,InstrRev(ziduan5,"|")-Instr(ziduan5,"|")-1)'型号
sbb5=right(ziduan5,len(ziduan5)-InstrRev(ziduan5,"|")) '单位
else
mingcheng5=rst("材料名称5")
end if
'-----------------获取材料名称等信息end
end if
n=Year(date())
y=Month(date())
r=Day(date())
s=Hour(time())
f=Minute(time())
m=Second(time())
if len(y)=1 then y="0" & y
if len(r)=1 then r="0" & r
if len(s)=1 then s="0" & s
if len(f)=1 then f="0" & f
if len(m)=1 then m="0" & m
ssj=n & "-" & y & "-" & r
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>单号:<%=rst("id")%></title>
</head>

<body>

<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="555" id="AutoNumber1" height="53">
    <tr>
      <td width="555" height="16" colspan="3">供<span lang="en-us">--3</span>乙</td>
    </tr>
    <tr>
      <td width="174" height="37">
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-size:9pt" bordercolor="#111111" width="94%" id="AutoNumber2" height="46">
        <tr>
          <td width="42%" height="21">资金类别</td>
          <td width="58%" height="21">　</td>
        </tr>
        <tr>
          <td width="42%" height="24">材料科目</td>
          <td width="58%" height="24">　</td>
        </tr>
      </table>
      </td>
      <td width="214" height="37">
      <p align="center">坊 子 通 信 公 司<br>           
      <br>
      <b><a style="text-decoration: none" href="javascript:window.print()">领&nbsp;&nbsp; 料&nbsp;&nbsp; 单</a></b></td>           
      <td width="167" height="37">
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="95%" id="AutoNumber3" height="45">
        <tr>
          <td width="44%" rowspan="2" height="45">费用科目</td>
          <td width="56%" height="23">　</td>
        </tr>
        <tr>
          <td width="56%" height="21">　</td>
        </tr>
      </table>
      </td>
    </tr>
  </table>
  </center>
</div>
<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-size:9pt" bordercolor="#111111" width="554" id="AutoNumber4" height="46">
    <tr>
      <td width="389" colspan="2" height="15">领料单位 <span lang="en-us"><%=rst("领料单位")%></span></td>
      <td width="165" height="15">发料仓库 <span lang="en-us"><%=rst("存放仓库")%></span></td>
    </tr>
    <tr>
      <td width="170" height="16">工作单号 <span lang="en-us"><%=rst("id")%></span></td>
      <td width="219" height="16">领料编号 <span lang="en-us"><%=rst("id")%></span></td>
      <td width="165" height="16">发料单号 <span lang="en-us"><%=rst("id")%></span></td>
    </tr>
    <tr>
      <td width="170" height="15">用&nbsp;&nbsp;&nbsp; 途 <span lang="en-us">           
      <%=rst("领料用途")%></span></td>
      <td width="219" height="15">填制日期 <span lang="en-us"><%=ssj%></span></td>
      <td width="165" height="15">发料日期 <span lang="en-us"><%=rst("出库时间")%></span></td>
    </tr>
  </table>
  </center>
</div>
<div align="center">
  <center>
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-size: 9pt" bordercolor="#111111" width="554" id="AutoNumber5" height="153">
    <tr>
      <td width="53" height="19" align="center" rowspan="2">器材编号</td>
      <td width="130" height="19" align="center" rowspan="2">器材名称及规格</td>
      <td width="33" height="19" align="center" rowspan="2">计量单位</td>
      <td width="93" height="12" align="center" colspan="2">数量</td>
      <td width="38" height="19" align="center" rowspan="2">新旧程度</td>
      <td width="56" height="19" align="center" rowspan="2">单价</td>
      <td width="65" height="19" align="center" rowspan="2">金额</td>
      <td width="77" height="19" align="center" rowspan="2">库号</td>
    </tr>
    <tr>
      <td width="45" height="9" align="center">请领</td>
      <td width="45" height="9" align="center">实发</td>
    </tr>
    <tr>
      <td width="53" height="20" align="center"><span lang="en-us"><%=rst("材料编号")%></span></td>
      <td width="130" height="20"><span lang="en-us"><%=rst("材料名称")%></span>|<span lang="en-us"><%=rst("规格型号")%></span></td>
      <td width="33" height="20" align="center"><span lang="en-us"><%=rst("单位")%></span></td>
      <td width="93" height="20" colspan="2" align="center"><span lang="en-us">
      <%=rst("数量")%></span>|<span lang="en-us"><%=rst("实领数量")%></span></td>
      <td width="38" height="20">　</td>
      <td width="56" height="20" align="center"><span lang="en-us"><%=rst("单价1")%></span></td>
      <td width="65" height="20" align="center"><span lang="en-us"><%=rst("金额1")%></span></td>
      <td width="77" height="20">&nbsp;<span lang="en-us"><%=rst("存放仓库")%></span></td>
    </tr>
    <tr><%if mingcheng2="空" then%>
      <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21">　</td>
      <td width="33" height="21" align="center">　</td>
      <td width="93" height="21" colspan="2" align="center">　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center">　</td>
      <td width="65" height="21" align="center">　</td>
      <td width="77" height="21">　</td>
      <%else%>
       <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21"><%=mingcheng2%>|<%=saa2%>　</td>
      <td width="33" height="21" align="center"><%=sbb2%>　</td>
      <td width="93" height="21" colspan="2" align="center"><%=rst("数量2")%>|<%=rst("实领数量2")%>　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center"><%=rst("单价2")%>　</td>
      <td width="65" height="21" align="center"><%=rst("金额2")%>　</td>
      <td width="77" height="21"><%=rst("仓库2")%>　</td>
      <%end if%>
    </tr>
     <tr><%if mingcheng3="空" then%>
      <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21">　</td>
      <td width="33" height="21" align="center">　</td>
      <td width="93" height="21" colspan="2" align="center">　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center">　</td>
      <td width="65" height="21" align="center">　</td>
      <td width="77" height="21">　</td>
      <%else%>
       <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21"><%=mingcheng3%>|<%=saa3%>　</td>
      <td width="33" height="21" align="center"><%=sbb3%>　</td>
      <td width="93" height="21" colspan="2" align="center"><%=rst("数量3")%>|<%=rst("实领数量3")%>　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center"><%=rst("单价3")%>　</td>
      <td width="65" height="21" align="center"><%=rst("金额3")%>　</td>
      <td width="77" height="21"><%=rst("仓库3")%>　</td>
      <%end if%>
    </tr>
    <tr><%if mingcheng4="空" then%>
      <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21">　</td>
      <td width="33" height="21" align="center">　</td>
      <td width="93" height="21" colspan="2" align="center">　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center">　</td>
      <td width="65" height="21" align="center">　</td>
      <td width="77" height="21">　</td>
      <%else%>
       <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21"><%=mingcheng4%>|<%=saa4%>　</td>
      <td width="33" height="21" align="center"><%=sbb4%>　</td>
      <td width="93" height="21" colspan="2" align="center"><%=rst("数量4")%>|<%=rst("实领数量4")%>　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center"><%=rst("单价4")%>　</td>
      <td width="65" height="21" align="center"><%=rst("金额4")%>　</td>
      <td width="77" height="21"><%=rst("仓库4")%>　</td>
      <%end if%>
    </tr>
    <tr><%if mingcheng5="空" then%>
      <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21">　</td>
      <td width="33" height="21" align="center">　</td>
      <td width="93" height="21" colspan="2" align="center">　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center">　</td>
      <td width="65" height="21" align="center">　</td>
      <td width="77" height="21">　</td>
      <%else%>
       <td width="53" height="21" align="center"><span lang="en-us"></span></td>
      <td width="130" height="21"><%=mingcheng5%>|<%=saa5%>　</td>
      <td width="33" height="21" align="center"><%=sbb5%>　</td>
      <td width="93" height="21" colspan="2" align="center"><%=rst("数量5")%>|<%=rst("实领数量5")%>　</td>
      <td width="38" height="21">　</td>
      <td width="56" height="21" align="center"><%=rst("单价5")%>　</td>
      <td width="65" height="21" align="center"><%=rst("金额5")%>　</td>
      <td width="77" height="21"><%=rst("仓库5")%>　</td>
      <%end if%>
    </tr>
    <tr>
      <td width="53" height="24">
      <p align="center">备 注</td>
      <td width="294" height="24" colspan="5">　</td>
      <td width="55" height="24">
      <p align="center">金额合计</td>
      <td width="141" height="24" colspan="2"><%=zonge%></td>
    </tr>
  </table>
  </center>
</div>
<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-size: 9pt" bordercolor="#111111" width="557" id="AutoNumber6" height="23">
    <tr>
      <td width="29" height="23">记帐</td>
      <td width="65" height="23">　</td>
      <td width="43" height="23">发料单位主管</td>
      <td width="98" height="23">&nbsp;<span lang="en-us"><%=rst("签批人")%></span></td>
      <td width="26" height="23">管料</td>
      <td width="80" height="23">&nbsp;<span lang="en-us"><%=rst("发料人")%></span></td>
      <td width="41" height="23">领料单位主管</td>
      <td width="106" height="23">　</td>
      <td width="27" height="23">领料</td>
      <td width="42" height="23">&nbsp;<span lang="en-us"><%=rst("领料人")%></span></td>
    </tr>
  </table>
  </center>
</div>
     <div id="Layer1" style="position: absolute; width: 129; height: 133; z-index: 54; left: 445; top: 191"><img border="0" src="PIC/zhang.gif"></div> 
</body>

</html>
<%
conn.close  
set conn=nothing  
%>

⌨️ 快捷键说明

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