自由与蓝天

昔日高山流水,快剑江湖,长街奔马。 今日谷歌百度,种菜发贴,写写代码。

博客园 首页 新随笔 联系 订阅 管理

    意图:通过点击ListBox,GridView表格切换数据源,显示不同的数据表格。

     最初,我起了一些Javascript代码,收效甚微,加之不好调试,又恐耽搁进度。没有办法,找了个最笨的方法,也算是过墙梯吧。闲话且停,代码呈上:

    

javascript代码部分
function visitSelected(){
     
var osel_Access=document.getElementById("sel_Access");
     
var i=osel_Access.options[osel_Access.selectedIndex].value;
  
if(i=="AccessDataSource1")
  {    
           window.document.all.div_ASPxGridView1.style.display
="block"
           window.document.all.div_ASPxGridView2.style.display
="none";
            window.document.all.div_ASPxGridView3.style.display
="none";
              window.document.all.div_ASPxGridView4.style.display
="none"
            window.document.all.div_ASPxGridView5.style.display
="none";
             window.document.all.div_ASPxGridView6.style.display
="none"
  }
    
if(i=="AccessDataSource2")
  {    
           window.document.all.div_ASPxGridView1.style.display
="none";
           window.document.all.div_ASPxGridView2.style.display
="block"
            window.document.all.div_ASPxGridView3.style.display
="none";
            window.document.all.div_ASPxGridView4.style.display
="none"
            window.document.all.div_ASPxGridView5.style.display
="none";
             window.document.all.div_ASPxGridView6.style.display
="none"
  }
   
    
if(i=="AccessDataSource3")
  {    
           window.document.all.div_ASPxGridView1.style.display
="none";
           window.document.all.div_ASPxGridView2.style.display
="none";
            window.document.all.div_ASPxGridView3.style.display
="block"
            window.document.all.div_ASPxGridView4.style.display
="none"
            window.document.all.div_ASPxGridView5.style.display
="none";
             window.document.all.div_ASPxGridView6.style.display
="none"
            
  }
     
if(i=="AccessDataSource4")
  {    
           window.document.all.div_ASPxGridView1.style.display
="none";
           window.document.all.div_ASPxGridView2.style.display
="none";
             window.document.all.div_ASPxGridView3.style.display
="none";
            window.document.all.div_ASPxGridView4.style.display
="block"
             window.document.all.div_ASPxGridView5.style.display
="none";
             window.document.all.div_ASPxGridView6.style.display
="none";
  }
     
if(i=="AccessDataSource5")
  {    
           window.document.all.div_ASPxGridView1.style.display
="none";
           window.document.all.div_ASPxGridView2.style.display
="none";
           window.document.all.div_ASPxGridView3.style.display
="none";
           window.document.all.div_ASPxGridView4.style.display
="none";
            window.document.all.div_ASPxGridView5.style.display
="block"
           window.document.all.div_ASPxGridView6.style.display
="none"
            
  }
     
if(i=="AccessDataSource6")
  {    
           window.document.all.div_ASPxGridView1.style.display
="none";
           window.document.all.div_ASPxGridView2.style.display
="none";
             window.document.all.div_ASPxGridView3.style.display
="none";
           window.document.all.div_ASPxGridView4.style.display
="none";
           window.document.all.div_ASPxGridView5.style.display
="none";
            window.document.all.div_ASPxGridView6.style.display
="block"
            
  }
  }

 

 

Aspx代码
  <div id="project_query">  
                  
<select id="sel_Access" name="selColor" multiple="true" onchange="visitSelected()" style="height: 109px"><!-- 加size="3"为列表框 -->
                     
<option value="AccessDataSource1">项目概况与规模指标表</option>
                     
<option value="AccessDataSource2">项目工艺参数指标表</option>
                     
<option value="AccessDataSource3">项目等级与环境功能区划表</option>
                     
<option value="AccessDataSource4">污染物排放指标表</option>
                     
<option value="AccessDataSource5">环境污染防治措施指标表</option>
                     
<option value="AccessDataSource6">评估结论表</option>
                   
</select>
          
</div>  
        
<h6 class="pb_index_h6">建设项目列表</h6>
         
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, 报告书编制时间, 项目施工起始日期, 项目施工结束日期, 建设项目性质, [工程投资(万元)] AS 工程投资_万元, [环保投资(万元)] AS 环保投资_万元, [占地面积(公顷)] AS 占地面积_公顷 FROM Project_Summary ORDER BY 建设项目编号">
         
</asp:AccessDataSource>
         
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, 行业类别, 烟囱型式, [设计煤种的烟气出口直径(米)] AS 煤种烟气出口直径_米, [设计煤种的烟囱高度(米)] AS 煤种的烟囱高度_米, [设计煤种的烟气出口速率(米每秒)] AS 煤种烟气出口速率_米每秒, [设计煤种的烟气出口温度(摄氏度)] AS 设计煤种的烟气出口温度_摄氏度 FROM Project_Technology">
         
</asp:AccessDataSource>
         
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, 大气评价等级, 水环境评价等级, 大气环境功能区级别, 地表水水质级别, 地下水水质级别 FROM Project_Environment">
         
</asp:AccessDataSource>
         
<asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, [生活废水排放量(万吨每年)] AS 生活废水排放量_万吨每年, [生产废水排放量(万吨每年)] AS 生产废水排放量_万吨每年, 排放的重金属名称, [重金属排放量(吨每年)] AS 重金属排放量_吨每年 FROM Project_Discharge">
         
</asp:AccessDataSource>
         
<asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, 除尘装置种类, [除尘效率(%)] AS 除尘效率_百分比, 废水处理方式, [废水处理效率(%)] AS 废水处理效率_百分比 FROM Project_Measure">
         
</asp:AccessDataSource>
         
<asp:AccessDataSource ID="AccessDataSource6" runat="server" DataFile="~/App_Data/heavy_metal_project.mdb"
             SelectCommand
="SELECT 建设项目编号, 建设项目名称, 评估结论, 产业政策符合性, 规划符合性, 环境风险可控性, [公众反对比例(%)] AS 公众反对比例_百分比 FROM Project_Evaluation">
         
</asp:AccessDataSource>
         
<div id="project_query_gridview">
         
<div id="div_ASPxGridView1">
         
<dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False"
             DataSourceID
="AccessDataSource1" KeyFieldName="建设项目编号">
             
<Columns>
                 
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn  Caption="项目名称" VisibleIndex="1">
                 
<DataItemTemplate>
                  
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# "Project_info.aspx?ID="+Eval("建设项目编号") %>'
                            Text='
<%Eval("建设项目名称"%>' Target="_blank"></asp:HyperLink> 
                    
<%-- <a href="#"><%# Eval("建设项目名称")%></a>--%>
                 
</DataItemTemplate>
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="报告书编制时间" VisibleIndex="2">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="项目施工起始日期" VisibleIndex="3">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="项目施工结束日期" VisibleIndex="4">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="建设项目性质" VisibleIndex="5">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="工程投资_万元" VisibleIndex="6">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="环保投资_万元" VisibleIndex="7">
                 
</dxwgv:GridViewDataTextColumn>
                 
<dxwgv:GridViewDataTextColumn FieldName="占地面积_公顷" VisibleIndex="8">
                 
</dxwgv:GridViewDataTextColumn>
            
<dxwgv:GridViewDataColumn Caption="Details" VisibleIndex="8" Width="5%">
                 
<DataItemTemplate>
                     
<href="#" onclick="OnMoreInfoClick(this, '<%# Container.KeyValue %>')">More Info...</a>
                 
</DataItemTemplate>
             
</dxwgv:GridViewDataColumn>
             
</Columns>
         
</dxwgv:ASPxGridView>
         
</div>
         
<div id="div_ASPxGridView2" style="display:none;">
             
<dxwgv:ASPxGridView ID="ASPxGridView2" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource2" KeyFieldName="建设项目编号">
                 
<Columns>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目名称" VisibleIndex="1">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="行业类别" VisibleIndex="2">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="烟囱型式" VisibleIndex="3">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="煤种烟气出口直径_米" VisibleIndex="4">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="煤种的烟囱高度_米" VisibleIndex="5">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="煤种烟气出口速率_米每秒" VisibleIndex="6">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="设计煤种的烟气出口温度_摄氏度" VisibleIndex="7">
                     
</dxwgv:GridViewDataTextColumn>
                 
</Columns>
             
</dxwgv:ASPxGridView>
            
</div>
         
<div id="div_ASPxGridView3" style="display:none;">
             
<dxwgv:ASPxGridView ID="ASPxGridView3" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource3" KeyFieldName="建设项目编号">
                 
<Columns>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目名称" VisibleIndex="1">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="大气评价等级" VisibleIndex="2">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="水环境评价等级" VisibleIndex="3">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="大气环境功能区级别" VisibleIndex="4">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="地表水水质级别" VisibleIndex="5">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="地下水水质级别" VisibleIndex="6">
                     
</dxwgv:GridViewDataTextColumn>
                 
</Columns>
             
</dxwgv:ASPxGridView>
                  
</div>  
            
<div id="div_ASPxGridView4" style="display:none;"> 
             
<dxwgv:ASPxGridView ID="ASPxGridView4" runat="server" AutoGenerateColumns="False"
                 DataSourceID
="AccessDataSource4" KeyFieldName="建设项目编号">
                 
<Columns>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目名称" VisibleIndex="1">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="生活废水排放量_万吨每年" VisibleIndex="2">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="生产废水排放量_万吨每年" VisibleIndex="3">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="排放的重金属名称" VisibleIndex="4">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="重金属排放量_吨每年" VisibleIndex="5">
                     
</dxwgv:GridViewDataTextColumn>
                 
</Columns>
             
</dxwgv:ASPxGridView>
                  
</div>  
            
<div id="div_ASPxGridView5" style="display:none;"> 
             
<dxwgv:ASPxGridView ID="ASPxGridView5" runat="server" AutoGenerateColumns="False"
                 DataSourceID
="AccessDataSource5" KeyFieldName="建设项目编号">
                 
<Columns>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目名称" VisibleIndex="1">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="除尘装置种类" VisibleIndex="2">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="除尘效率_百分比" VisibleIndex="3">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="废水处理方式" VisibleIndex="4">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="废水处理效率_百分比" VisibleIndex="5">
                     
</dxwgv:GridViewDataTextColumn>
                 
</Columns>
             
</dxwgv:ASPxGridView>
                  
</div>  
            
<div id="div_ASPxGridView6" style="display:none;"> 
             
<dxwgv:ASPxGridView ID="ASPxGridView6" runat="server" AutoGenerateColumns="False"
                 DataSourceID
="AccessDataSource6" KeyFieldName="建设项目编号">
                 
<Columns>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目编号" ReadOnly="True" VisibleIndex="0">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="建设项目名称" VisibleIndex="1">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="评估结论" VisibleIndex="2">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="产业政策符合性" VisibleIndex="3">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="规划符合性" VisibleIndex="4">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="环境风险可控性" VisibleIndex="5">
                     
</dxwgv:GridViewDataTextColumn>
                     
<dxwgv:GridViewDataTextColumn FieldName="公众反对比例_百分比" VisibleIndex="6">
                     
</dxwgv:GridViewDataTextColumn>
                 
</Columns>
             
</dxwgv:ASPxGridView>
            
</div> 
         
</div>

 

     总结:这是通过javascript触发listbox的onchang事件来显示与隐藏girdview所在的div。需要注意的是页面初始化时需要对<div2>....<div6>进行隐藏。即

  <div id="div_ASPxGridView3" style="display:none;"> 

     反过来说,这么做也没有什么不好,至少条理清晰,方便后边的output成pdf or word or excel。

posted on 2010-11-17 16:17  自由与蓝天  阅读(213)  评论(0)    收藏  举报