status.asp

功能简介： 前台: 1.用户名注册:登 录 名：密码：确认密码：性别：查询权限： 地址： 联系电话： 移动电话： E - mail： 工作单位 2.系统优点管理,公告新闻管理,联系我们管理

  <!--#include file="conn.asp"-->
 <LINK 
href="images/25175css_pro.css" type=text/css rel=stylesheet> 
   
									  <%
										dim sss,sql11,zt1,zt2,zt18,zt17,zt16,zt15,zt14,zt13,zt12,zt11,zt10,zt9,zt8,zt7,zt6,zt5,zt4,zt3
										zt1=1
										zt2=1
										zt3=1
										zt4=1
										zt5=1
										zt6=1
										zt7=1
										zt8=1
										zt9=1
										zt10=1
										zt11=1
										zt12=1
										zt13=1
										zt14=1
										zt15=1
										zt16=1
										zt17=1
										zt18=1
										
										
										if request("city1")<>"" then
										 sss=request("city1")
								 		end if
										if request("city2")<>"" then
										 sss=request("city2")
								 		end if
										
										
										set rs2=server.createobject("adodb.recordset")
			sql11="select * from status where provinceid='"&sss&"'"
			rs2.open sql11,conn,1,1
			if not rs2.eof then
			
			
				do while not rs2.eof					
								
								if rs2("title")="cl_bh" then
									zt1=0
								end if
								if rs2("title")="cl_title" then
									zt2=0
								end if
								if rs2("title")="cl_xh" then
									zt3=0
								end if
								if rs2("title")="cl_dw" then
									zt4=0
								end if
								if rs2("title")="cl_zhj" then
									zt5=0
								end if
								if rs2("title")="cl_ajg" then
									zt6=0
								end if
								if rs2("title")="cl_bjg" then
									zt7=0
								end if
								if rs2("title")="cl_cjg" then
									zt8=0
								end if
								if rs2("title")="cl_djg" then
									zt9=0
								end if
								if rs2("title")="cl_ejg" then
									zt10=0
								end if
								if rs2("title")="cl_fjg" then
									zt11=0
								end if
								if rs2("title")="cl_cd" then
									zt12=0
								end if
								if rs2("title")="cl_dj" then
									zt13=0
								end if
								if rs2("title")="cl_pp" then
									zt14=0
								end if
								if rs2("title")="cl_yj" then
									zt15=0
								end if
								if rs2("title")="cl_bz1" then
									zt16=0
								end if
								if rs2("title")="cl_bz2" then
									zt17=0
								end if
								if rs2("title")="cl_bz3" then
									zt18=0
								end if
								
								
									
				  rs2.movenext
		     loop				
			end if
			rs2.close
		set rs2=nothing
										
																	  
											  %>
  <table>
   <tr>
									
									
                                <TD height=23  align="right" rowspan="4"   width="26%" >不显示字段：</TD>
								<TD height=23  align="left" width="65%" ><input type="checkbox"value="cl_bh" 
								<%if zt1=0 then response.write("checked") end if %>  name="sel2" />
代码&nbsp;
  <input type="checkbox"value="cl_title" <%if zt2=0 then response.write("checked") end if %> name="sel3" />
材料名称
<input type="checkbox"  value="cl_xh" <%if zt3=0 then response.write("checked") end if %> name="sel4" />
型号规格&nbsp;
<input type="checkbox" value="cl_dw" <%if zt4=0 then response.write("checked") end if %> name="sel" />
								单位
								<input type="checkbox" value="cl_zhj" <%if zt5=0 then response.write("checked") end if %> name="sel" />
								信息价								&nbsp;</TD>
									   </tr>
									
									 <tr>
									
									
                                
								<TD height=23  align="left" width="65%" ><p>
								  
								  <input type="checkbox"value="cl_ajg" <%if zt6=0 then response.write("checked") end if %> name="sel5" />
供应价
<input type="checkbox"value="cl_bjg" <%if zt7=0 then response.write("checked") end if %> name="sel" />
								到工地价&nbsp;
								<input type="checkbox"value="cl_cjg" <%if zt8=0 then response.write("checked") end if %> name="sel" />
								C价格&nbsp;
								<input type="checkbox"value="cl_djg" <%if zt9=0 then response.write("checked") end if %> name="sel" />
								D价格&nbsp;
								<input type="checkbox"value="cl_ejg" <%if zt10=0 then response.write("checked") end if %> name="sel" />
								E价格&nbsp;
								<input type="checkbox"value="cl_fjg" <%if zt11=0 then response.write("checked") end if %> name="sel" />
								  F价格&nbsp;
								
								  </TD>
                                    </tr>
									
									
									
									 <tr>
									
									
                                
								<TD height=23  align="left" width="65%" ><p>
								  <input name="sel" type="checkbox" <%if zt12=0 then response.write("checked") end if %> value="cl_cd" />
								  产地&nbsp;
								  <input type="checkbox"value="cl_dj" <%if zt13=0 then response.write("checked") end if %> name="sel" />
								  等级&nbsp;
								  <input type="checkbox"value="cl_pp" <%if zt14=0 then response.write("checked") end if %> name="sel" />
								  品牌&nbsp;
								  <input type="checkbox" value="cl_yj" <%if zt15=0 then response.write("checked") end if %> name="sel6" />
厂商&nbsp;
<input type="checkbox"value="cl_bz1" <%if zt16=0 then response.write("checked") end if %> name="sel6" />
地区&nbsp;
<input type="checkbox"value="cl_bz2" <%if zt17=0 then response.write("checked") end if %> name="sel6" />
供货单位及电话&nbsp;
<input type="checkbox"value="cl_bz3" <%if zt18=0 then response.write("checked") end if %> name="sel6" />
备注3&nbsp;</TD>
                                    </tr>
									
									 <tr>
									
									
                                
								<TD height=23  align="left" width="65%" ><p>&nbsp;</p></TD>
                                    </tr>
									</table>