view.asp

功能齐全的oa系统

<% option explicit%>

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

	Dim C,conn
	Dim IntID
	Dim ObjDB,ObjRS,ObjRSType,ObjRSGuest,ObjRSName
	Dim SQLSTR
	
	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_Guest_industry 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("Creater"))
	
	'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>
    <%
	SQLSTR="Select Gtype From T_CRM_Guest_type Where ID = " & cint(ObjRS("Gtype_ID"))
	'response.Write SQLSTR
	'response.End
	Set ObjRSType = conn.Execute(SQLSTR)
	if ObjRSType.Eof And ObjRSType.Bof  Then
	%> 
	<tr class=Ltr>
		<td>所属行业</td>
		<td><input type="text" readonly class=Input Check=0 Show="所属行业" name="_Gtype" value="不祥"></td>
	</tr>
	
	<%else%>
	<tr class=Ltr>
		<td>所属行业</td>
		<td><input type="text" readonly class=Input Check=0 Show="所属行业" name="_Gtype" value="<%=ObjRSType("Gtype")%>"></td>
	</tr>
	<%End if%>
	<tr class=Ltr>
		<td>客户类型</td>
		<td><input type="text" readonly class=Input Check=0 Show="客户类型" name="_Gindustry" value="<%=ObjRS("Gindustry")%>"></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>
	</tr>
	<%else%>
	
	<tr class=Ltr>
		<td>创建人</td>
		<td><input type="text" readonly class=Input Check=1 Show="创建人" name="_TrueName"  value="<%=ObjRSName("TrueName")%>"></td>
	</tr>
	<%End if%>
	<tr class=Ltr>
		<td>创建时间</td>
		<td><input type="text" readonly class=Input Check=1 Show="创建时间" name="_CreateTime"  value="<%=ObjRS("CreateTime")%>"></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
ObjRSType.close
set ObjRSType=Nothing
ObjDB.close
set ObjDB=NOthing
conn.close
set conn=Nothing
End Sub%>
<%'==================================================================%>

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