请教大家一个奇怪的问题 - ASP技术论坛

eournet

等　级：论坛游民
帖　子：103
专家分：26
注　册：2010-5-22
结帖率：55.56%

楼主

已结贴√ 问题点数：20 回复次数：3

请教大家一个奇怪的问题

图片附件: 游客没有浏览图片的权限，请登录或注册

<%
'[ZJXM_ZYGL] (C) 2009-2010 江阴电信分公司线路维护中心 Inc.
'$Id: print_whd.asp 2010-04-06 $

if request.Cookies("shiwei_username")="" then
%>
<script language="javascript">
top.location.href="../index.asp"
</script>
<%
 response.end
end if
%>



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../style2.css" rel="stylesheet" type="text/css">
<script language=javascript>
function preview() {
bdhtml=window.document.body.innerHTML;
sprnstr="";
eprnstr="";
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 topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" style="position: absolute; top: 0; left:0; right:0; bottom:0; width:0; height:0; z-index:0">
<%
set rs_whd=conn.execute("select * from whd where zu=false and bianhao='"&request("bianhao")&"'")
nowid_gys=rs_whd("id_gys")
nowid_login=rs_whd("id_login")
set rs_login=conn.execute("select * from login where id="&rs_whd("id_login"))
if rs_login.eof then
 nowlogin=rs_whd("login")
else
 nowlogin=rs_login("username")
end if
%>

<div align="center">
<table border="2" cellspacing="0" cellpadding="0" bordercolor="#000000" height="0" bordercolorlight="#000000" bordercolordark="#000000">
 
 <tr>
 <th height="35" colspan="8">维护类日常维修、抢修派修施工单</th>
 </tr>
 <tr>
 <th height="25" colspan="8">---施工单关联主要信息,工单打印日期:<%=date()%>---</th>
 </tr>
 <tr>
 <th height="25">主管部门</th>
 <th height="25" width="31%" colspan="2">
 <%=rs_whd("id_gys")%></th>
 <th height="25" width="18%" colspan="2">
 工单编码</th>
 <th height="25" width="32%" colspan="3">
 NO:<%=rs_whd("bianhao")%></th>
 </tr>
 <tr>
 <th height="25">维修类别</th>
 <th height="25" width="16%"><%=rs_whd("gys")%></th>
 <th height="25" width="15%">工单名称</th>
 <th height="25" width="18%" colspan="2">
 <%=rs_whd("price")%></th>
 <th height="25" width="11%">施工原因</th>
 <th height="25" width="21%" colspan="2">
 <%=rs_whd("type")%></th>
 </tr>
 <tr>
 <th height="25">区域派修责任人</th>
 <th height="25" width="16%"><%=nowlogin%></th>
 <th height="25" width="15%">
 相关支局</th>
 <th height="25" width="18%" colspan="2">
 <%=rs_whd("id_produit")%></th>
 <th height="25" width="11%">
 派修时间</th>
 <th height="25" width="21%" colspan="2">
 <%=rs_whd("selldate")%></th>
 </tr>
 <tr>
 <th height="25">施工负责人</th>
 <th height="25" width="16%"><%=rs_whd("guige")%></th>
 <th height="25" width="15%">
 施工单位</th>
 <th height="25" width="18%" colspan="2">
 <%=rs_whd("ku")%></th>
 <th height="25" width="11%">
 指定竣工时间</th>
 <th height="25" width="21%" colspan="2">
 <%=rs_whd("enddate")%></th>
 </tr>
 <tr>
 <th height="25">施工地点</th>
 <th height="25" width="31%" colspan="2">
 <%=rs_whd("id_huiyuan")%></th>
 <th height="25" width="18%" colspan="2">
 施工单主题</th>
 <th height="25" width="32%" colspan="3">
 <%=rs_whd("price")%></th>
 </tr>
 <tr>
 <th height="30">主要工作量</th>
 <td height="50" width="81%" colspan="7" align="center"><%=rs_whd("beizhu")%></td>
 </tr>
 <tr>
 <th height="25" colspan="8"> ---施工单使用主要材料明细---<tr>
 <td height="585" colspan="8" valign="top" style="text-align: center; text-indent: 0; margin-left: 0; margin-right: 0; margin-top: 0">
 <div align="center">
 <table border="1" width="100%" cellspacing="1" height="100%" id="table2" bordercolor="#000000">
 
 <tr>
 <td width="28" align="center">
 主 
 
 要 
 
 材 
 
 料 
 
 表</td>
 <td valign="top" height="585">
 <div align="center">
 <table border="1" width="100%" cellspacing="0" id="table5" bordercolorlight="#FFFFFF" bordercolordark="#000000" bordercolor="#000000" cellpadding="0">
 <td height="20" bordercolor="#000000" align="center" width="17%" nowrap valign="middle">
 材料名称</td>
 <td height="20" width="31%" bordercolor="#000000" align="center" nowrap>
 型号规格</td>
 <td height="20" width="9%" bordercolor="#000000" align="center" nowrap>
 数量</td>
 <td height="20" width="7%" bordercolor="#000000" align="center" nowrap>
 单位</td>
 <td height="20" width="10%" bordercolor="#000000" align="center" nowrap>
 材料单价</td>
 <td height="20" width="12%" bordercolor="#000000" align="center" nowrap>
 单项合计</td>
 <td height="20" width="11%" bordercolor="#000000" align="center" nowrap>
 领料情况</td>

 <%
 totalprice2=0
 do while rs_whd.eof=false
 set rs_produit=conn.execute("select * from produit where huohao='"&rs_whd("huohao")&"'")
 %>
 　<tr>
 <%if showpic="yes" then%><%end if%>
 <td align="center" height="20" bordercolor="#000000" width="17%" nowrap><%=rs_whd("title")%>
 <td align="center" height="20" width="31%" bordercolor="#000000" nowrap>
 <%=rs_whd("huohao")%>
 
 <td align="center" height="20" width="9%" bordercolor="#000000" nowrap><%=formatnumber(rs_whd("shulian"),2)%>
 <td align="center" height="20" width="7%" bordercolor="#000000" nowrap><%=rs_whd("id_danwei")%>
 <td align="center" height="20" width="10%" bordercolor="#000000" nowrap><%=formatnumber(rs_whd("price2"),2)%>
 <td align="center" height="20" width="12%" bordercolor="#000000" nowrap><%=formatnumber(rs_whd("price2")*rs_whd("shulian"),2)%></tr>
 <td align="center" height="20" width="11%" bordercolor="#000000" nowrap>
 □</tr>
 <%
 totalprice2=totalprice2+rs_whd("price2")*rs_whd("shulian")
 rs_whd.movenext
 loop
 %>
 　<tr>
 <td height="20" colspan="5" align="center" bordercolor="#000000" nowrap>
 总计</td>
 <td height="20" width="12%" align="center" bordercolor="#000000" nowrap><%=formatnumber(totalprice2,2)%>
 　</td>
 <td height="20" width="11%" align="center" bordercolor="#000000" nowrap>
 　</td>
 </tr></th>
 </tr></td>
 </tr>
 </table>

 </div>

 </td>
 </tr>
 </table>

 </div>

 <tr>
 <th height="30">签发人</th>
 <th height="30" width="31%" colspan="2">　</th>
 <th height="30" width="18%" colspan="2">
 签发时间</th>
 <th height="30" width="32%" colspan="3">
 年       月      
 日 </th>
 </tr>
 <tr>
 <th height="30">施工负责人</th>
 <th height="30" width="31%" colspan="2">　</th>
 <th height="30" width="18%" colspan="2">
 实际竣工时间</th>
 <th height="30" width="32%" colspan="3">
 年       月      
 日 </th>
 </tr>

 <tr>
 <th height="25" colspan="8" width="100%">
其他需要说明的问题：</th>
 </tr>
 <tr>
 <th height="25" colspan="8" width="100%">
 派修人：                          领料：                             
线路室：                        
仓库：</th>
 </tr>
 </table>
                                                                                                
 </div>
　
</body>
</html>