📄 yue.asp

📁 一款用ASP写的办公自动化软件
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=data/conn.asp-->
<%
	set rs=server.CreateObject("adodb.recordset")
	sql="select *  from ri where year='"&request("year")&"' and month='"&request("month")&"'"
	rs.open sql,conn,1,1
	if not rs.eof then
	set rs1=server.CreateObject("adodb.recordset")
	sql1="select sum(mei) as mm  from ri where month='"&request("month")&"'"
	rs1.open sql1,conn,1,1
	set rs2=server.CreateObject("adodb.recordset")
	sql2="select sum(gang) as gg  from ri where month='"&request("month")&"'"
	rs2.open sql2,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {
	font-size: 16px;
	font-weight: bold;
	color: #FFFFFF;
}
body,td,th {
	font-size: 12px;
}
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	color: #000000;
	text-decoration: none;
}
a:hover {
	color: #CCCCCC;
	text-decoration: none;
}
a:active {
	color: #CCCCCC;
	text-decoration: none;
}
body {
	background-color: #ffffff;
}
.style3 {color: #FFFFFF}
-->
</style>
</head>

<body>
<p>&nbsp;</p>
<table width="581" height="149" border="0" align="center" cellspacing="1" bgcolor="#336699">
  <tr bgcolor="BC82D6">
    <td height="77" colspan="3"><div align="center" class="style1 style3">锅炉生产运行月报表
      <table width="100%" border="0">
        <tr>
          <td> 　　【<a href=javascript:window.print();>打印</a>】
              <div align="right"></div></td>
        </tr>
      </table>
    </div></td>
  </tr>  <tr>
    <td width="145" height="40" background="images/tile_sub.gif"><div align="center">日期 </div></td>
    <td width="210" background="images/tile_sub.gif"><div align="center">消耗（煤，单位：吨）</div></td>
    <td width="216" background="images/tile_sub.gif"><div align="center">生产（钢材，单位：吨）</div>      
    <div align="center"></div>      <div align="center"></div>      <div align="center"></div></td>
    </tr>
	
  <tr>
    <td height="30" bgcolor="#FFFFFF"><div align="center"><%=rs("year")%>-<%=rs("month")%></div></td>
    <td bgcolor="#FFFFFF"><div align="center"><%= rs1("mm") %>&nbsp;</div></td>
    <td bgcolor="#FFFFFF"><div align="center"><%= rs2("gg") %></div>      <div align="center"></div>      <div align="center"></div></td>
  </tr>

   <tr bgcolor="#FFFFFF">
    <td height="30" colspan="3">&nbsp;     </td>
  </tr>
</table>
</body>
</html>
<%else
response.Write("<script language=javascript>alert('对不起没有您所要查找的信息！');location='javascript:history.go(-1)'</script>")
end if
%>
⌨️ 快捷键说明

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