?? 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">所屬區(qū)域：</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">所屬行業(yè)：</td>
<td class="STYLE19"> <%=rs("bus")%></td>
<td class="STYLE13">企業(yè)性質：</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">企業(yè)描述：</td>
<td colspan="3" class="STYLE19"> <%=rs("des")%></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13"><strong>企業(yè)人數(shù)：</strong></td>
<td class="STYLE19">
<%=rs("total")%>
</td>
<td class="STYLE13">管理層人數(shù)：</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">人數(shù)：</td>
<td class="STYLE19"> <%=rs("last_num")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">醫(yī)院：</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">其他聯(lián)系人：</td>
<td class="STYLE19"> <%=rs("second")%></td>
<td class="STYLE19"><span class="STYLE13">聯(lián)系電話：</span></td>
<td class="STYLE19"> <%=rs("second_tel")%></td>
</tr>
<%end if%>
<% if rs("third")<>"" then %>
<tr>
<td height="28" colspan="2" class="STYLE13">其他聯(lián)系人：</td>
<td class="STYLE19"> <%=rs("third")%></td>
<td class="STYLE19"><span class="STYLE13">聯(lián)系電話：</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 + -