📄 provider_view.asp
字号:
<!--#include file="../title.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<link rel="stylesheet" type="text/css" href="../css/css.css">
</head>
<%
dim pro_id,sql
pro_id=request("id")
sql="select * from provider where provider_id = "&pro_id&" "
rs.open sql,conn
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" height="266">
<br><br>
<tr>
<td align="center" valign="top" height="266" >
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="579" id="AutoNumber2" height="272">
<tr>
<td colspan="6" height="48" width="577">
<p align="center"><b><font size="7">客户资料卡</font></b>
</td>
</TR>
<tr>
<td width="70" height="19"><b>公司名称</b></td>
<td colspan="5" width="506" height="19"><font color="#FFFFFF">
<%=rs("provider_name")%></font>
</td>
</tr>
<tr>
<td width="70" height="19"><b>公司地址</b>：</td>
<td colspan="5" width="506" height="19"><font color="#FFFFFF">
<%=rs("provider_address")%></font>
</td>
</tr>
<tr>
<td width="70" height="18"><b>公司性质</b>：</td>
<%
kind=rs("provider_kind")
if kind<>"" then
sql2="select * from kind where kind_id = "&kind&" "
rs2.open sql2,conn
%>
<td width="125" height="18" ><font color="#FFFFFF"><%=rs2("kind_name")%></font></td>
<%rs2.close
else
%>
<td width="75" height="18" ></td>
<%end if%>
<td width="73" height="18" ><b>公司规模</b>：</td>
<%
size=rs("provider_size")
if size<>"" then
sql3="select * from size where size_id = "&size&" "
rs3.open sql3,conn
%>
<td width="75" height="18" ><font color="#FFFFFF"><%=rs3("size_name")%></font></td>
<%rs3.close
else%>
<td width="75" height="18" ></td>
<%end if%>
<td width="73" height="18" ><b>行业分类</b>：</td>
<%
trade=rs("provider_trade")
if trade<>"" then
sql4="select * from trade where trade_id = "&trade&" "
rs4.open sql4,conn
%>
<td width="156" height="18" ><font color="#FFFFFF"><%=rs4("trade_name")%></font></td>
<%rs4.close
else%>
<td width="75" height="18" ></td>
<%end if%>
</tr>
<tr>
<td width="70" height="19"><b>负 责 人</b>：</td>
<td width="125" height="19" ><font color="#FFFFFF">
<%=rs("provider_principal")%></font>
</td>
<%
corner=rs("corner_id")
if corner<>"" then
sql5="select * from corner where corner_id = "&corner&" "
rs5.open sql5,conn
%>
<td width="73" height="19" ><b>区 域</b>：</td>
<td width="75" height="19" ><font color="#FFFFFF"><%=rs5("corner_name")%></font></td>
<%rs5.close
else%>
<td width="75" height="18" ></td>
<%end if%>
<td width="73" height="19" ><b>邮 编</b>：</td>
<td width="156" height="19" ><font color="#FFFFFF">
<%=rs("provider_post")%></font>
</td>
</tr>
<tr>
<td width="70" height="19"><b>电 话</b>：</td>
<td width="125" height="19" ><font color="#FFFFFF">
<%=rs("provider_phone")%></font>
</td>
<td width="73" height="19" ><b>分 机</b>：</td>
<td width="75" height="19" ><font color="#FFFFFF">
<%=rs("provider_extension")%></font>
</td>
<td width="73" height="19" ><b>传 真</b>：</td>
<td width="156" height="19" ><font color="#FFFFFF">
<%=rs("provider_fax")%></font>
</td>
</tr>
<tr>
<td width="70" height="19" ><b>联 系 人</b>：</td>
<td width="125" height="19" ><font color="#FFFFFF">
<%=rs("provider_linkman")%></font>
</td>
<td width="73" height="19" ><b>性 别</b>：</td>
<td width="75" height="19" ><font color="#FFFFFF">
<%
if rs("provider_sex")=true then
response.write "男"
else
response.write "女"
end if
%></font>
</td>
<td width="73" height="19" ><b>职 务</b>：</td>
<td width="156" height="19" ><font color="#FFFFFF">
<%=rs("provider_function")%></font>
</td>
</tr>
<tr>
<td width="70" height="19" ><b>网 址</b>：</td>
<td colspan="2" width="199" height="19"><font color="#FFFFFF">
<%=rs("provider_www")%></font>
</td>
<td width="75" height="19" ><b>E-mail</b>：</td>
<td colspan="2" width="230" height="19"><font color="#FFFFFF">
<%=rs("provider_mail")%></font>
</td>
</tr>
<tr>
<td width="70" height="19" ><b>开 户 行</b>：</td>
<td colspan="2" width="199" height="19"><font color="#FFFFFF">
<%=rs("provider_bank")%></font>
</td>
<td width="75" height="19" ><b>账 号</b>：</td>
<td colspan="2" width="230" height="19"><font color="#FFFFFF">
<%=rs("provider_accounts")%></font>
</td>
</tr>
<tr>
<td width="577" colspan="6" height="12"><b>主要业务</b>：</td>
</tr>
<tr>
<td width="577" colspan="6" height="51"><font color="#FFFFFF">
<%=rs("provider_operation")%></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<%rs.close%><!--#include file="../copyright.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -