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

📄 all_company_detail.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" %>
<html>
<%
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>浏览公司信息</title>
<style type="text/css">
<!--
.style2 {
	font-size: 24px;
	font-weight: bold;
	font-family: "黑体";
}
-->
</style>
<link href="../../Css/bd_font_size.css" rel="stylesheet" type="text/css">
</head>

<body background="../img/allbg.gif">
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select * from GSCOTT.company_info_table where company_name='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
%>
<div align="center">
<center>
<table width="582" height="650"border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr align="center" valign="middle" bgcolor="#0281FF">
    <td height="77" colspan="2" align="center" valign="middle"><span class="style2">公司信息详细信息</span></td>
    </tr>
  <tr>
    <td width="218" height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size">公司名称:</td>
    <td width="364" align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size">
      <%=rs("company_name")%>    </td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right"> 联系人:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_linkman")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right">执照号:</div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_idcard")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right"> 所在省份:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_province")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right"> 所在城市:</div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_city")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right"> 公司地址:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_address")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right">邮编: </div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_zipcode")%></td>
  </tr>
  <tr>
    <td height="27" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right">联系电话:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_telphone")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right">联系人手机:</div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_lmmobilephone")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right">联系人Email:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_lmemail")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right">传真:</div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_fax")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><div align="right">注册时间:</div></td>
    <td align="center" valign="middle" bgcolor="#4AA5FF" class="bd_font_size"><%=rs("company_date")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><div align="right">备注(可不填):</div></td>
    <td align="center" valign="middle" bgcolor="#ACD6FF" class="bd_font_size"><%=rs("company_remark")%></td>
  </tr>
  <tr bgcolor="#4AA5FF" class="bd_font_size">
    <td height="57" colspan="2" align="right" valign="middle"><a href="update_company_certain.asp?id=<%=request.QueryString("id")%>">修改</a>&nbsp;&nbsp;<a href="../change_model/del_company_certain.asp">删除</a>&nbsp;&nbsp;<a href="javascript:window.close()">关闭窗口</a></td>
    </tr>
  <tr>
    <td height="165">&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>
</center>
</div>
</body>
<%
  rs.close
  set rs=nothing
%>
</html>

⌨️ 快捷键说明

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