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

📄 viewretail.asp

📁 asp+sql的教室申请系统,可以完成一个学期的教室分配情况
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/CSYD.asp" -->
<%
Dim rs__MMColParam
rs__MMColParam = "1"
If (Request.QueryString("ID") <> "") Then 
  rs__MMColParam = Request.QueryString("ID")
End If
%>
<%
Dim rs
Dim rs_numRows

Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_CSYD_STRING
rs.Source = "SELECT * FROM CS_SQInfo WHERE ID = " + Replace(rs__MMColParam, "'", "''") + ""
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()

rs_numRows = 0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="Style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
	background-image: url(images/002_03.gif);
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>

<body>
<table width="100%" height="92"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top" bgcolor="#CCCCCC"><table width="100%" height="190"  border="0" cellpadding="0" cellspacing="1">
      <tr bgcolor="#F0F7F0">
        <td colspan="2"><div align="center"><strong>申请信息</strong></div></td>
        </tr>
      <tr bgcolor="#F0F7F0">
        <td width="28%"><div align="right">申请部门:</div></td>
        <td width="72%"><%=(rs.Fields.Item("sq_bumen").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">申请人姓名:</div></td>
        <td><%=(rs.Fields.Item("sq_xingming").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">专用教室名称:</div></td>
        <td><%=(rs.Fields.Item("sq_changsuo").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">申请单位:</div></td>
        <td><%=(rs.Fields.Item("sq_danwei").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">使用时间:</div></td>
        <td><%=(rs.Fields.Item("usetime").Value)%>&nbsp;第<%=(rs.Fields.Item("sq_day").Value)%>节课</td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">活动主题:</div></td>
        <td><%=(rs.Fields.Item("sq_neirong").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">需用设备:</div></td>
        <td><%=(rs.Fields.Item("sq_yaoqiu").Value)%></td>
      </tr>
      <tr bgcolor="#F0F7F0">
        <td><div align="right">申请时间:</div></td>
        <td><%=(rs.Fields.Item("sq_date").Value)%></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
<%
rs.Close()
Set rs = Nothing
%>

⌨️ 快捷键说明

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