<% set rs=server.createobject("adodb.recordset")
sql="select * from type1 order by t1_id1 asc"
rs.open sql,conn,1,1
do while not rs.eof
t1_id = rs("t1_id")
t1_name = rs("t1_name")
if t1_name == 分析仪器 or 无损检测仪器 or 气体检测仪 or 电子工具 then
t1_name = 1
else if t1_name == 安规测试仪 or 电子电工
t1_name = 2
else
t1_name = 3
end if
%>
| 青岛销售部 |
<% Select Case CInt(t1_name)
case 1
%>
|
<% case 2 %>
|
<% case 3 %>
|
| 天津销售部 |
|
<%
Select Case CInt(t1_name)
case 1
End Select
rs.movenext
loop
rsclose()
%>
|