📄 advice_add.asp
字号:
<!--#include file ="date.asp"-->
<!--#include file ="conn.asp"-->
<style type="text/css">
<!--
.STYLE2 {font-size: 18px}
.STYLE3 {
font-size: 18px;
font-weight: bold;
color: #FFFFFF;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
body {
background-color: #ECF2FF;
margin-left: 0px;
margin-right: 0px;
}
.STYLE5 {
font-size: 12px;
color: #000055;
}
.STYLE18 {font-size: 16}
.STYLE19 {font-size: 12px}
.STYLE25 {font-size: 14px; font-weight: bold; }
.STYLE13 {font-size: 12px; font-weight: bold; }
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<BODY leftmargin="10" topmargin="0">
<p align="center" class="STYLE2">
<table width="100%" height="35" border="0" background="image/top.gif" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="STYLE3">添加建议</div></td>
</tr>
</table>
<% if request("action")="save" then
id=request.form("id")
set rr=server.CreateObject("adodb.recordset")
wwdsql="select * from advice"
rr.open wwdsql,conn,1,3
rr.addnew
rr("company_id")=id
rr("advice")=request.form("advice")
rr("advicer")=session("cname")
rr("time")=now()
rr.update
%>
<br><br>保存成功！
<br><br>
<%
else%>
<%id=request("id")
exec="select * from company where id="&id
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<form name="form1" method="post" action="advice_add.asp?action=save">
<label>
<input name="id" type="hidden" value="<%=rs("id")%>">
</label>
<p align="center">
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="5" background="../image/headerbg.gif"><strong>基本信息</strong></td>
</tr>
<tr>
<td height=28 colspan="2" class="STYLE19" ><strong>销 售 员：</strong></td>
<td width="173" class="STYLE19"> <%=rs("seller")%></td>
<td width="79" class="STYLE13">是否共享：</td>
<td width="240" class="STYLE19"> <%=rs("share")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">客户名称：</td>
<td colspan="3" class="STYLE19"> <%=rs("name")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">客户简称：</td>
<td class="STYLE19"> <%=rs("short")%></td>
<td class="STYLE13">所属区域：</td>
<td class="STYLE19"> <%=rs("area")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">单位地址：</td>
<td colspan="3" class="STYLE19"> <%=rs("address")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">公司电话：</td>
<td class="STYLE19"> <%=rs("tel")%></td>
<td class="STYLE13">传<span class="STYLE19"> </span><span class="STYLE19"> </span>真：</td>
<td class="STYLE19"> <%=rs("fax")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">所属行业：</td>
<td class="STYLE19"> <%=rs("bus")%></td>
<td class="STYLE13">企业性质：</td>
<td class="STYLE19"> <%=rs("nature")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">客户来源：</td>
<td class="STYLE19"> <%=rs("source")%></td>
<td class="STYLE13">客户类别：</td>
<td class="STYLE19"> <%=rs("cate")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">企业描述：</td>
<td colspan="3" class="STYLE19"> <%=rs("des")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13"><strong>企业人数：</strong></td>
<td class="STYLE19">
<%=rs("total")%>
</td>
<td class="STYLE13">管理层人数：</td>
<td class="STYLE19"> <%=rs("high")%></td>
</tr>
<tr>
<td width="29" rowspan="2" class="STYLE13">上次体检</td>
<td width="46" height="28" class="STYLE13">时间：</td>
<td class="STYLE19"> <%=rs("last_time")%></td>
<td class="STYLE13">人数：</td>
<td class="STYLE19"> <%=rs("last_num")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">医院：</td>
<td class="STYLE19"> <%=rs("last_hos")%></td>
<td class="STYLE13">价格：</td>
<td class="STYLE19"> <%=rs("last_price")%>元/人</td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">主管部门：</td>
<td class="STYLE19"> <%=rs("depart")%></td>
<td class="STYLE13">负责人：</td>
<td class="STYLE19"> <%=rs("charge")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">职务：</td>
<td class="STYLE19"> <%=rs("charge_post")%></td>
<td class="STYLE19"><span class="STYLE13">手机：</span></td>
<td class="STYLE19"> <%=rs("charge_phone")%></td>
</tr>
<% if rs("second")<>"" then %>
<tr>
<td height="28" colspan="2" class="STYLE13">其他联系人：</td>
<td class="STYLE19"> <%=rs("second")%></td>
<td class="STYLE19"><span class="STYLE13">联系电话：</span></td>
<td class="STYLE19"> <%=rs("second_tel")%></td>
</tr>
<%end if%>
<% if rs("third")<>"" then %>
<tr>
<td height="28" colspan="2" class="STYLE13">其他联系人：</td>
<td class="STYLE19"> <%=rs("third")%></td>
<td class="STYLE19"><span class="STYLE13">联系电话：</span></td>
<td class="STYLE19"> <%=rs("third_tel")%></td>
</tr><%end if%>
</table>
<%
idd=rs("id")
exe="select * from follow where company_id='"&idd&"'"
set ds=server.createobject("adodb.recordset")
ds.open exe,conn,1,1
Do While Not ds.Eof
%><br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="../image/headerbg.gif"><span class="STYLE25">跟踪情况</span></td>
</tr>
<tr>
<td height=28 width="80" ><span class="STYLE19">拜访销售员：</span></td>
<td width="200" class="STYLE19"><span class="STYLE19"> </span><%=ds("seller")%>
</td>
<td width="80" class="STYLE19"><span class="STYLE19">拜访人：</span></td>
<td width="209" class="STYLE19"><span class="STYLE19">
<%=ds("customer")%>
</span></td>
</tr>
<tr>
<td height="28"><span class="STYLE19">拜访时间：</span></td>
<td class="STYLE19"><span class="STYLE19"> </span><%=ds("date")%><span class="STYLE19"> </span><%=ds("time1")%>-<%=ds("time2")%></td>
<td class="STYLE19">拜访方式：</td>
<td class="STYLE19"><span class="STYLE19"> </span><%=ds("mode")%></td>
</tr>
<tr>
<td height=28><span class="STYLE19">拜访目的：</span></td>
<td colspan="3" class="STYLE19"><span class="STYLE19"> </span><%=ds("aim")%></td>
</tr>
<tr>
<td height="28"><span class="STYLE19">拜访记录：</span></td>
<td colspan="3" class="STYLE19"><span class="STYLE19"> </span><%=ds("record")%></td>
</tr>
<tr>
<td height="28"><span class="STYLE19">情况分析：</span></td>
<td colspan="3" class="STYLE19"><span class="STYLE19"> </span><%=ds("ana")%></td>
</tr>
<tr>
<td height="28"><span class="STYLE19">跟踪计划：</span></td>
<td colspan="3" class="STYLE19"><span class="STYLE19"> </span><%=ds("plan")%></td>
</tr>
</table>
<% ds.MoveNext
Loop %>
<%
exet="select * from advice where company_id='"&idd&"'"
set ss=server.createobject("adodb.recordset")
ss.open exet,conn,1,1
Do While Not ss.Eof
%><br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="../image/headerbg.gif"><span class="STYLE25">跟踪情况</span></td>
</tr>
<tr>
<td height=28 width="80" ><span class="STYLE19">建议日期：</span></td>
<td width="200" class="STYLE19"><span class="STYLE19"> </span><%=ss("time")%>
</td>
<td width="80" class="STYLE19"><span class="STYLE19">建议人：</span></td>
<td width="209" class="STYLE19"><span class="STYLE19">
<%=ss("advicer")%>
</span></td>
</tr>
<tr>
<td height="28"><span class="STYLE19">建议内容：</span></td>
<td colspan="3" class="STYLE19"><span class="STYLE19"> </span><%=ss("advice")%><span class="STYLE19"> </span></td>
</tr>
</table>
<% ss.MoveNext
Loop %>
<br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" background="../image/headerbg.gif"><span class="STYLE25">添加部门建议</span></td>
</tr>
<tr>
<td><textarea name="advice" cols="80" rows="3"></textarea></td>
</tr>
</table>
<br>
<br>
<label>
<div align="center">
<input type="submit" name="Submit4" value="提交">
<input type="reset" name="Submit5" value="重置">
</div>
</label>
</form>
<%end if%>
<table width="100%" height="18" border="0" background="image/bottom.gif" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="bottom"><div align="center"><span class="STYLE5">版权所有 杰尔康</span><br />
</div></td>
</tr>
</table>
</BODY>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -