%
Dim I,i_rank,S_WeiXin,S_QQ,ResultPro,S_Class,s_eqixiu,i_count,S_ClassSplit,S_ClassCount,sqlWhere,XlResult,CpXl,S_Cname,ChanPinXlYesOrNo,CpResult,txtClounm,txtBnsId
CreateConn()
Set Rs = Conn.Execute("Select S_Name,S_Des,Cast(S_Cont As VarChar(4000)),S_Logo,S_Video,S_Contact,I_IsOpen,S_LxName,S_Tel,S_Phone,S_QQ,S_Fax,S_Email,S_URL,S_Adr,I_ID,S_Cname,(select i_rank from m_user where i_cmpid=m_bns.i_id),S_WeiXin,I_Flag,s_class,S_Zcont From m_bns Where I_ID = '29344'")
S_QQ = Rs(10)
i_rank = Rs(17)
S_WeiXin = Rs(18)
s_class= Rs(20)
S_Cname= Rs(16)
txtBnsId= Rs(15)
txtClounm=8
Result = Rs.GetRows()
Rs.CLose()
Set Rs = Nothing
i_count= Conn.Execute("Select count(i_id) From m_zt Where i_cmpid = '29344'")(0)
if i_count>0 then
s_eqixiu=Conn.Execute("Select s_bpic From m_zt Where i_cmpid = '29344'")(0)
end if
%>
歡迎光臨<%=Result(0,0)%>主打
<%
'//讀出該公司三個產品系列
Set Rs = Conn.Execute("Select Top 3 I_ID,S_Name From m_pro Where I_CmpID = '"&Result(15,0)&"' And i_state = '1' Order By I_Order Asc,I_ID Desc")
Do While Not Rs.EOF
%>
<%=Rs(1)%>|
<%
Rs.MoveNext
Loop
Rs.Close()
Set Rs = Nothing
%>
<%
'//讀出該公司三個產品系列
Set Rs = Conn.Execute("Select S_Name,S_Cname,I_ID From m_bnsprotype Where I_CmpId = '"&Result(15,0)&"' Order By I_Order Asc")
IF Not Rs.EOF THEN
%>
<%
ELSE
ChanPinXlYesOrNo = "No"
Rs.Close()
Set Rs = Nothing
END IF
'//讀出該公司三個產品系列
%>
<%
IF ChanPinXlYesOrNo = "Yes" THEN
For I = 0 To Ubound(CpResult,2)
%>
<%=CpResult(0,I)%>(<%=Conn.Execute("Select Count(I_ID) From m_pro Where I_CmpID = '"&Result(15,0)&"' And i_xlid = '"&CpResult(2,I)&"' And i_state = '1'")(0)%>個)
<%
Set Rs = Conn.Execute("Select Top 21 I_ID,S_Bpic,S_Name From m_pro Where I_CmpID = '"&Result(15,0)&"' And i_xlid = '"&CpResult(2,I)&"' And i_state = '1' Order By I_Order Asc,I_ID Desc")
Do While Not Rs.EOF
%>
<%
Rs.MoveNext
Loop
Rs.Close()
Set Rs = Nothing
%>
<%
Next
%>
<%
Set CpResult = Nothing '--釋放上邊查詢產品系列的CpResult
ELSE
%>
<%
Set Rs = Conn.Execute("Select Top 20 I_ID,S_Bpic,S_Name From m_pro Where I_CmpID = '"&Result(15,0)&"' And i_state = '1' Order By I_Order Asc,I_ID Desc")
Do While Not Rs.EOF
%>
<%
'企業類別示例:1,12,4,5
S_Class = s_class
'把類別以,號分開
S_ClassSplit = Split(s_class,",")
'合計有多少個類別
S_ClassCount = Ubound(S_ClassSplit)
For I = 0 To S_ClassCount
sqlWhere = sqlWhere & "charindex(',"&S_ClassSplit(I)&",',','+ s_class +',') >= 1 Or "
Next
IF sqlWhere = "" THEN
sqlWhere = ""
ELSE
sqlWhere = "Where ("&Left(sqlWhere,(LEN(sqlWhere)-4))&")"
END IF
Set Rs = Conn.Execute ("Select Top 8 S_Cname,S_Name From m_bns "&sqlWhere&" Order By I_ID Desc")
IF Not Rs.EOF THEN
%>