📄 proview.asp
字号:
<!--#include file="../conndb.asp"-->
<html>
<head>
<title>查看问题基本信息</title>
<link rel="stylesheet" href="../style.css">
</head>
<%
Dim ProId,Title,LevelName,TypeName,SolveDate,CustName,Contact,CreateDate,cStatus,Poster,Detail
Dim rs
'读取参数pid
ProId = Request.QueryString("pid")
Set rs = Server.CreateObject("ADODB.RecordSet")
'设置SELECT语句，读取记录数据
sql = "SELECT p.*,c.CustName,t1.TypeName AS LevelName,t2.TypeName As TypeName" _
+ " FROM SrvProblem p,Customer c,Types t1,Types t2 " _
+ " WHERE p.CustId=c.CustId AND p.LevelId=t1.TypeId " _
+ " AND p.TypeId=t2.TypeId And p.ProId=" & ProId
rs.Open sql,conn,1,3
If Not rs.EOF Then
Title = rs("Title")
LevelName = rs("LevelName")
TypeName = rs("TypeName")
SolveDate = rs("SolveDate")
CustName = rs("CustName")
Contact = rs("Contact")
CreateDate = rs("CreateDate")
Poster = rs("Poster")
Detail = rs("Detail")
cStatus = rs("Status")
End If
rs.Close()
%>
<body leftmargin="1" topmargin="0">
<form name="form1" method="POST">
<br>
<table align="center" border="1" cellspacing="0" width="95%" bordercolor="#64B9E1" bordercolorlight="#64B9E1" bordercolordark="#FFFFFF">
<tr>
<td bgcolor="#FFFFFF" colspan="4" background="pic/srvpro.jpg" height="90" width="100%">
<p align="center"><b><font face="华文彩云" color="#000080" size="6">问题基本信息</font></b></p>
</td>
</tr>
<tr>
<td width="20%" bgcolor="#CEE7FF">选择客户名称</td>
<td width="40%"><%=CustName%> </td>
<td width="20%" bgcolor="#CEE7FF">问题联系人</td>
<td width="40%"><%=Contact%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">问题题目</td>
<td colspan="3"><%=Title%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">问题类别</td>
<td><%=TypeName%> </td>
<td bgcolor="#CEE7FF">问题严重级别</td>
<td><%=LevelName%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">期望解决日期</td>
<td><%=SolveDate%> </td>
<td bgcolor="#CEE7FF">当前状态</td>
<td><%=cStatus%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF" >问题描述</td>
<td colspan="3"><%=Detail%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">录入人</td>
<td><%=Poster%> </td>
<td bgcolor="#CEE7FF">录入日期</td>
<td><%=CreateDate%> </td>
</tr>
</table>
<p align=center><input type="button" value="关 闭" name="B2" OnClick="javascript:window.close();"></p>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -