view.asp

功能齐全的oa系统

<% option explicit%>

<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="/include/Page.asp" -->
<%

	Dim C
	Dim IntID
	Dim ObjDB,ObjRS,ObjRSName,ObjRSGuest,conn
	
	IntID = Request.QueryString("ID")
    if Cint(IntID)=0 Then
    	Response.Write "<script language=javascript>alert('请选择联系人');history.back();</script>"
    	Response.End
    End if
    
	Set conn=Server.CreateObject("ADODB.Connection")
	OpenDBCrm( conn )
	Set C = Server.CreateObject ("CMS2003.DBhandle")
	
	C.Init(conn)
   
	Set ObjRS = C.View("Select * From T_CRM_LinkMan Where ID = " & IntID)
	Set ObjDB = Server.CreateObject("ADODB.Connection")
	OpenDB objDB
        Set ObjRSName = ObjDB.Execute("Select TrueName From t_OA_SYS_Account_Character Where AccountID = " & Objrs("Lcreater"))
	Set ObjRSGuest = C.View("Select Gname From T_CRM_Guest Where ID = " & Objrs("Guest_id"))
	
	conn.Close
	Set conn = Nothing

%>



<%'==================================================================%>
<%Sub Main%>
<%'------------------------------------------------------------------%>

	
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<input type=hidden name=ID value="<%=Request.QueryString("ID")%>">
	<table class=Ltable cellspacing=1 cellpadding=3>
	<tr class=LHtr align="middle">
		<td width="15%">联系人基本信息</td>
		<td width="85%"> </td>
	</tr>
	<tr class=Ltr>
		<td>姓名</td>
		<td><input type="text" readonly class=Input Check=0 Show="姓名" name="_Lname" value="<%=ObjRS("Lname")%>"></td>
	</tr>
	<%if ObjRSGuest("Gname")="" or IsNull(ObjRSGuest("Gname")) Then%>
	<tr class=Ltr>
		<td>所属客户</td>
		<td><input type="text" readonly class=Input Check=0 Show="所属客户" name="_Gname" value="不祥"></td>
	</tr>
	<%else%>
	<tr class=Ltr>
		<td>所属客户</td>
		<td><input type="text" readonly class=Input Check=0 Show="所属客户" name="_Gname" value="<%=ObjRSGuest("Gname")%>"></td>
	</tr>
	<%End if%>
	<tr class=Ltr>
		<td>部门</td>
		<td><input type="text" readonly class=Input Check=0 Show="部门" name="_Lpart" value="<%=ObjRS("Lpart")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>职务</td>
		<td><input type="text" readonly class=Input Check=0 Show="职务" name="_Lposition" value="<%=ObjRS("Lposition")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>移动电话</td>
		<td><input type="text" readonly class=Input Check=0 Show="移动电话" name="_Lmobile" value="<%=ObjRS("Lmobile")%>"></td>
	</tr>
	</table>
  	<table id=MoreInfo class=Ltable cellspacing=1 cellpadding=3>
  	<tr class=LStr>
	<td width="15%">联系人详细信息</td>
	<td width="85%" colspan=3> </td>
  	</tr>
	<tr class=Ltr>
		<td>家里电话</td>
		<td><input type="text" readonly class=Input Check=0 Show="家里电话" name="_Lphone" value="<%=ObjRS("Lphone")%>"></td>
	
		<td>办公室电话</td>
		<td><input type="text" readonly class=Input Check=0 Show="办公室电话" name="_Loffice" value="<%=ObjRS("Loffice")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>地址</td>
		<td><input type="text" readonly class=Input Check=0 Show="地址" name="_Laddress" value="<%=ObjRS("Laddress")%>"></td>
	
		<td>邮编</td>
		<td><input type="text" readonly class=Input Check=0 Show="邮编" name="_Lpost" value="<%=ObjRS("Lpost")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>传真</td>
		<td><input type="text" readonly class=Input Check=0 Show="传真" name="_Lfox" value="<%=ObjRS("Lfox")%>"></td>
	
		<td>电子信箱</td>
		<td><input type="text" readonly class=Input Check=0 Show="电子信箱" name="_Lemail" value="<%=ObjRS("Lemail")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>爱好</td>
		<td><input type="text" readonly class=Input Check=0 Show="爱好" name="_Llike" value="<%=ObjRS("Llike")%>"></td>
	
		<td>纪念日</td>
		<td><input type="text" readonly class=Input Check=0 Show="纪念日" name="_Lmemory" value="<%=ObjRS("Lmemory")%>"></td>
	</tr>
		<tr class=Ltr>
		<td>国家/地区</td>
		<td><input type="text" readonly class=Input Check=0 Show="国家/地区" name="_Lcountry" value="<%=ObjRS("Lcountry")%>"></td>
	
		<td>所在城市</td>
		<td><input type="text" readonly class=Input Check=1 Show="所在城市" name="_Lcity"  value="<%=ObjRS("Lcity")%>"></td>
	</tr>
	<%if ObjRSName("TrueName")="" or IsNull(ObjRSName("TrueName")) Then%>
	<tr class=Ltr>
		<td>创建人</td>
		<td><input type="text" readonly class=Input Check=1 Show="创建人" name="_TrueName"  value="不祥"></td>
	
	<%else%>
	
	<tr class=Ltr>
		<td>创建人</td>
		<td><input type="text" readonly class=Input Check=1 Show="创建人" name="_TrueName"  value="<%=ObjRSName("TrueName")%>"></td>
	
	<%End if%>
	
		<td>创建时间</td>
		<td><input type="text" readonly class=Input Check=1 Show="创建时间" name="_CreateTime"  value="<%=ObjRS("CreateTime")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>最后拜访日期</td>
		<td><input type="text" readonly class=Input Check=1 Show="最后拜访日期" name="_Lvisitdate"  value="<%=ObjRS("Lvisitdate")%>"></td>
	
		<td>最后电话日期</td>
		<td><input type="text" readonly class=Input Check=1 Show="最后电话日期" name="_Lcalldate"  value="<%=ObjRS("Lcalldate")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>备注</td>
		<td colspan=3><textarea cols="40" rows="3" readonly class=Input Check=0 Show="备注" name="_Remark"><%=ObjRS("Remark")%></textarea></td>
	</tr>
	</table>
	<table cellspacing=1 cellpadding=3>
	<tr>
		<td>
		<input type="button" class=Button value="返 回" onclick="doList()" id=button1 name=button1></td>
		<td></td>
	</tr>
	</table>
	</FORM>
	


<%'------------------------------------------------------------------%>
<%
ObjRSName.Close
set ObjRSName=Nothing
End Sub%>
<%'==================================================================%>

<!-- #include virtual="Templet/Templet.asp" -->