<% dim strSQL,rs,rs_2,rs_3 ' strClass1ID=request.querystring("strClass1ID") ' if isempty(strClass1ID) or cint(strClass1ID)<1 then ' strClass1ID=1 ' end if '* 读取所有产品大类记录 strSQL="Select * From Level_1 Order By LevelID" set rs_2=conn.execute(strSQL) '* 显示产品大类列表 lngCount1 = 0 while not rs_2.eof lngCount1 = lngCount1 + 1 strClass2ID = rs_2.fields("LevelID") 'strPhotoFile = rsClass.fields("PhotoFile") ' Response.Write "" '显示大类及图片 Response.Write "" wend On Error Resume Next rs_2.close set rs_2=Nothing rs_3.close set rs_3=Nothing %>

 

" 'If Len(strPhotoFile)>0 Then ' Response.Write "" 'End If ' Response.Write "" Response.Write "" Response.Write "" '* 读取相应大类的产品品牌记录 'strSQL="Select * From Level_2 Where UpLevelID='" & strClass2ID & "' Order By UpLevelID, LevelID" strSQL="select Distinct Level_2.Levelname as levelname,Products.PinPaiID as PinPaiID from Products inner join Level_2 on Products.PinPaiID=Level_2.LevelID where Products.UpLevelID='" & strClass2ID & "' Order By Products.PinPaiID" set rs_3=conn.execute(strSQL) '* 显示相应的产品品牌列表 lngCount2 = 0 while not rs_3.eof lngCount2 = lngCount2 + 1 if (lngCount2 mod 3)=1 then if lngCount2<>1 then Response.Write "" end if Response.Write "" Response.Write "" else Response.Write "" end if rs_3.movenext if rs_3.eof and (lngCount2 mod 3)=1 then Response.Write "" end if if rs_3.eof and (lngCount2 mod 3)=2 then Response.Write "" end if 'Response.Write "
    View the products list of " & rs_3.fields("LevelName") & "
" 'Response.Write "    " & rs_3.fields("LevelName") & "" wend '* 如果此条PinPai下没有产品小类,则添加一空白行 If lngCount2 = 0 Then Response.Write "" End If Response.Write "" rs_2.movenext Response.Write "
 " & lngCount1 & ". " & rs_2.fields("LevelName") & "" Response.Write "
    " & rs_3.fields("LevelName") & "" & rs_3.fields("LevelName") & "        
    
    (该大类没有品牌)
 

fip技术与简约的完美结合

FIP,国际最著名的工业管路系统供应商,提供规格齐全的工业管道、管件、手动阀门、自动阀门和FLS自动化仪表测量控制仪

fip 打造坚实产品,适应恶劣的环境

IPEX--北美最负盛名的的美标塑料管路系统制造商,提供由管件管材和阀门组成的完整系统,工业管路系统主要包括:Xirtec 140(pvc),sch80,Xirtec 140(pvc)sch40,corzan(cpvc),shc80,Corzan(cpvc)sch40管材和管件

aka技术与品质的先驱者

高密度聚乙烯(PE100,PE80)热熔对焊管件制造基地,提供SDR11,SDR17,SDR33,多种压力输送系统,尺寸范围:20-2000MM

样本 下载

自动阀们中文样本

PPH中文样本