C#筛选项联动,联动筛选

 
  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                FillDep();
            }
          //  FillDG();
          //  if (!IsPostBack)
          //  {
          //      FillUI();
           // }
              
        }
 
 <asp:Label ID="Label2" runat="server" Text="筛选1:"></asp:Label>
                <asp:DropDownList ID="DropDLOne" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDLOne_SelectedIndexChanged">
                </asp:DropDownList>
                <asp:Label ID="lblCType" runat="server" Text="筛选2:"></asp:Label>
                <asp:DropDownList ID="ddlTosofDept" runat="server" Width="86px"></asp:DropDownList>

				
				 if (ddlTosofDept.Text != "全部")
                    swhere += " and TosOfDept='" + ddlTosofDept.Text + "' ";
					
			
			 private void FillDep()
        {
            DataTable DropDLTwo = new DataTable();
            DropDLTwo = hrc.GetTableTwoList(" order by OrderIndex ");
            
            DropDLOne.Items.Clear();
            DropDLOne.Items.Add("全部");

            for (int i = 0; i < DropDLTwo.Rows.Count; i++)
            {
                DropDLOne.Items.Add(Convert.ToString(DropDLTwo.Rows[i].ItemArray[1]));
            }
            FillDept();
        }
        private void FillDept()
        {
            DataTable dtTableOneList = new DataTable();
            dtTableOneList = hrc.GetTableOneList(" where xxxxName='"+ DropDLOne.SelectedValue+ "' ");

            ddlTosofDept.Items.Clear();
            ddlTosofDept.Items.Add("全部");
            for (int i = 0; i < dtTableOneList.Rows.Count; i++)
            {
                ddlTosofDept.Items.Add(Convert.ToString(dtTableOneList.Rows[i].ItemArray[1]));
            }
        }
		
		  protected void DropDLOne_SelectedIndexChanged(object sender, EventArgs e)
        {
            FillDept();
        }

  

posted @ 2021-09-05 21:08  刘贵庆  阅读(59)  评论(0编辑  收藏  举报