GridView嵌套GridView的一些操作,包括取得主键,CHECKBOX全选等

最新推荐文章于 2022-02-22 17:58:38 发布
原创 最新推荐文章于 2022-02-22 17:58:38 发布 · 1.5k 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
标签
#asp #server #object #textbox #user
#table
本文介绍了一个使用 ASP.NET 实现的用户权限管理系统，通过下拉菜单选择部门或学校后，可以展示对应用户列表并进行全选操作。系统还支持根据部门筛选用户，并允许对用户进行选择标记。
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">



<STYLE type=text/css>BODY {
    MARGIN-TOP: 0px; FONT-SIZE: 9pt; MARGIN-LEFT: 4px; MARGIN-RIGHT: 0px; FONT-FAMILY: "宋体"
}
A {
    FONT-WEIGHT: 400; FONT-SIZE: 13px; COLOR: black; TEXT-DECORATION: none
}
A:hover {
    FONT-WEIGHT: 400; FONT-SIZE: 13px; COLOR: red; TEXT-DECORATION: underline
}
A:active {
    FONT: 9pt "宋体"; CURSOR: hand; COLOR: #ff0033
}
</style>
    <title>无标题页</title>

    <script type="text/javascript">

      
function show(tips,flag,url){
var my_tips=document.all.mytips;
if(flag){
    my_tips.style.display="";
    if (url!=null){my_tips.innerHTML="<img src='"+url+"'align=left>"+tips;}
    else{ my_tips.innerHTML=tips;}
    my_tips.style.left=event.clientX+10;
    my_tips.style.top=event.clientY+10;
   }
else 
  {
   my_tips.style.display="none";
   }
}
    </script>

</head>
<body>
    <form id="form1" runat="server">
        <div>
            &nbsp;<table>
                <tr>
                    <td>
<a href="#"  tips="请选择类别" onmousemove=show(this.tips,1) onmouseout=show(this.tips,0)>请选择类别</a>
                    
                        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                            <asp:ListItem>请选择</asp:ListItem>
                            <asp:ListItem Value="部门">部门/科室</asp:ListItem>
                            <asp:ListItem>学校</asp:ListItem>
                        </asp:DropDownList>
                        <asp:CheckBox ID="chk_All" runat="server" OnCheckedChanged="chk_All_CheckedChanged"
                            Text="全选" AutoPostBack="True" />
                        <asp:Button ID="btn_Submit" runat="server" OnClick="btn_Submit_Click" Text="确定" />
                        
                        </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td>
                        &nbsp;<asp:GridView ID="grv_DepartMent" runat="server" AutoGenerateColumns="False"
                            DataKeyNames="DepartmentID" OnRowDataBound="grv_DepartMent_RowDataBound" OnRowCommand="grv_DepartMent_RowCommand">
                            <Columns>
                                <asp:BoundField DataField="DepartmentID" HeaderText="DepartmentID" />
                                <asp:BoundField DataField="DepartMentName" HeaderText="部门名称" />
                                <asp:TemplateField>
                                    <EditItemTemplate>
                                        <asp:CheckBox ID="CheckBox1" runat="server" />
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:CheckBox ID="chk_SelectDepartment" runat="server" AutoPostBack="True" OnCheckedChanged="chk_SelectDepartment_CheckedChanged"
                                            Text="选择该部门" />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <asp:GridView ID="grv_User" runat="server" AutoGenerateColumns="False" Width="100%">
                                            <Columns>
                                                <asp:BoundField DataField="RealName" HeaderText="用户名" />
                                                <asp:TemplateField>
                                                    <EditItemTemplate>
                                                        <asp:CheckBox ID="CheckBox1" runat="server" />
                                                    </EditItemTemplate>
                                                    <ItemTemplate>
                                                        <asp:CheckBox ID="chk_User" runat="server" />
                                                    </ItemTemplate>
                                                    <ItemStyle Width="15px" />
                                                </asp:TemplateField>
                                            </Columns>
                                        </asp:GridView>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <EmptyDataTemplate>
                                <asp:GridView ID="grv_User" runat="server" AutoGenerateColumns="False" ShowHeader="False">
                                    <Columns>
                                        <asp:BoundField DataField="RealName" />
                                        <asp:TemplateField>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:CheckBox ID="chk_User" runat="server" Text="选择" />
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>
                            </EmptyDataTemplate>
                        </asp:GridView>
                    </td>
                    <td>
                        <asp:DataList ID="dlst_DepartMent" runat="server" DataKeyField="DepartMentID" OnItemDataBound="dlst_DepartMent_ItemDataBound">
                            <ItemTemplate>
                                &nbsp;
                                <table style="width: 100%; height: 100%">
                                    <tr>
                                        <td>
                                            <asp:Label ID="lbl_DepartMentName" runat="server" Text='<%# Eval("DepartMentName") %>'></asp:Label>
                                            <asp:CheckBox ID="chk_DepartMent" runat="server" AutoPostBack="True" OnCheckedChanged="chk_DepartMent_CheckedChanged" /></td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <asp:GridView ID="grv_UserView" runat="server" AutoGenerateColumns="False" Width="100%">
                                                <Columns>
                                                    <asp:BoundField DataField="RealName" HeaderText="用户名" />
                                                    <asp:TemplateField>
                                                        <ItemStyle Width="15px" />
                                                        <ItemTemplate>
                                                            <asp:CheckBox ID="chk_SUser" runat="server" />
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                </Columns>
                                            </asp:GridView>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                        </td>
                                    </tr>
                                </table>
                            </ItemTemplate>
                            <HeaderTemplate>
                                <asp:CheckBox ID="chk_SelectAll" runat="server" AutoPostBack="True" OnCheckedChanged="chk_SelectAll_CheckedChanged"
                                    Text

 

后台代码:

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using BigOA.Logic;
using BigOA.Data;

public partial class test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SetList();
            LoadDepartMentData();
           
        }
        if (Request["ID"] != null)
        {
 
        }
    }


    /// <summary>
    /// 用户列表
    /// </summary>
    private void SetList()
    {
        if (DropDownList1.SelectedIndex > 0)
        {
            chk_All.Enabled = true;

            string dtype = DropDownList1.SelectedValue;
            BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfo_SelectDTypeTableAdapter Adapter = new BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfo_SelectDTypeTableAdapter();
            BigOA.Data.User_BasicInfo.User_BasicInfo_SelectDTypeDataTable Table = Adapter.GetDataByDType(dtype);
            Adapter.Dispose();

            dgv_SchoolDepartment.DataSource = Table;
            dgv_SchoolDepartment.DataBind();
            
        }
        else
        {
            chk_All.Enabled = false;
        }
    }



    private void LoadDepartMentData()
    {
        BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfo_GetDepartmentTableAdapter adpt = new BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfo_GetDepartmentTableAdapter();

        BigOA.Data.User_BasicInfo.User_BasicInfo_GetDepartmentDataTable table = adpt.GetDepartMentNameGetData();
        adpt.Dispose();

        grv_DepartMent.DataSource = table;
        grv_DepartMent.DataBind();

        dlst_DepartMent.DataSource = table;
        dlst_DepartMent.DataBind();
    }

    private void LoadUserData(int DepartmentID, GridView grv)
    {
        BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfoSimpleTableAdapter adpt = new BigOA.Data.User_BasicInfoTableAdapters.User_BasicInfoSimpleTableAdapter();
        BigOA.Data.User_BasicInfo.User_BasicInfoSimpleDataTable table = adpt.GetDataByDepartmentID(DepartmentID);

        grv.DataSource = table;
        grv.DataBind();        
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SetList();
    }
    protected void btn_Submit_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow grvRow in dgv_SchoolDepartment.Rows)
        {

            CheckBox chk = (CheckBox)grvRow.FindControl("chk_Select");
            if (chk.Checked)
            {

            }
        }
    }
    protected void chk_All_CheckedChanged(object sender, EventArgs e)
    {
        bool flag = chk_All.Checked;
        foreach (GridViewRow grvRow in dgv_SchoolDepartment.Rows)
        {

            CheckBox chk = (CheckBox)grvRow.FindControl("chk_Select");
            chk.Checked = flag;
        }
        foreach (GridViewRow grvDeptRow in grv_DepartMent.Rows)
        {

            CheckBox chk = (CheckBox)grvDeptRow.FindControl("chk_SelectDepartment");
            chk.Checked = flag;

            GridView grv_User = (GridView)grvDeptRow.FindControl("grv_User");
            foreach (GridViewRow grvUserRow in grv_User.Rows)
            {
                CheckBox chk_user = (CheckBox)grvUserRow.FindControl("chk_User");
                chk_user.Checked = flag;
            }
        }
    }

    protected void grv_DepartMent_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //获取gridview主键
            DataKey key = grv_DepartMent.DataKeys[e.Row.RowIndex];
            //获取gridview一行中的数据
            DataRowView _view = (DataRowView)e.Row.DataItem;

            string DepartmentID2 = _view["DepartmentID"].ToString();
            int DepartmentID = Convert.ToInt32(key.Value);

            GridView grv = (GridView)e.Row.FindControl("grv_User");
            LoadUserData(DepartmentID, grv);

            //gridview鼠标经过改变行背景色
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='ivory'");

            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='white' ");



        }
    }
    protected void grv_DepartMent_RowCommand(object sender, GridViewCommandEventArgs e)
    {

    }
    protected void chk_SelectDepartment_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chk = (CheckBox)sender;
        bool flag = chk.Checked;
        GridViewRow row = (GridViewRow)chk.NamingContainer;
        GridViewRow curRow = (GridViewRow)chk.Parent.Parent;
        DataKey key = grv_DepartMent.DataKeys[row.RowIndex];
        GridView grv = (GridView)row.FindControl("grv_User");
        foreach (GridViewRow grvrow in grv.Rows)
        {
            CheckBox chk_user = (CheckBox)grvrow.FindControl("chk_User");
            chk_user.Checked = flag;
        }
    }
    protected void dlst_DepartMent_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item)
        {
            object key = dlst_DepartMent.DataKeys[e.Item.ItemIndex];
            int DepartmentID = Convert.ToInt32(key);

            GridView grv = (GridView)e.Item.FindControl("grv_UserView");
            LoadUserData(DepartmentID, grv);
        }
    }
    protected void chk_SelectAll_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chk_SelectAll = (CheckBox)sender;
        bool flag = chk_SelectAll.Checked;
        foreach (DataListItem item in dlst_DepartMent.Items)
        {
            CheckBox chk_DepartMent = (CheckBox)item.FindControl("chk_DepartMent");
            chk_DepartMent.Checked = flag;

            GridView grv_UserView=(GridView)item.FindControl("grv_UserView");
            foreach (GridViewRow row in grv_UserView.Rows)
            {
                CheckBox chk_SUser =(CheckBox) row.FindControl("chk_SUser");
                chk_SUser.Checked = flag;
            }

        }
    }
    protected void chk_DepartMent_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chk_DepartMent = (CheckBox)sender;
        bool flag = chk_DepartMent.Checked;
        DataLi
simpleblue88
关注
GridControl中嵌套GridView的使用
09-19
GridControl GridView 嵌套
gridview嵌套gridview案例说明
04-18
高手做的，顺手上传分享。gridview嵌套gridview案例说明
C#中的GridView 嵌套
programmestudent的专栏
05-31 1271
前言：在Windows开发和Web开发中，经常需要使用父子网格控件，即用父子两个网格显示相关联的信息，点击父网格即在子网格中显示与之有关的信息。使用父子网格控件，既可以合理显示信息，又可以简化操作。下面笔者以一个显示物料和物料下每个包装的案例介绍父子网格控件的使用。一、   本案例需求本案例是一个仓库物料盘点小模块。仓库中的物料按箱包装，每箱都有个唯一性的批号（相当于公民身份证）。开始时每箱的数量
DEV GridView嵌套
tatagg的专栏
08-26 6170
最近DEV搞的多，想把程序做得看起来专业点，所以稍微研究了一下。 本篇只记录如何实现在列表里面点击某一行可以打开这一行关联的子表内容。
GridView嵌套GridView 级联删除(1.纯代码删除版本)
amandag的专栏
05-31 4281
GridView嵌套GridView,对子GridView及父GridView级联删除的问题本例未考虑异常处理,提示信息及事务处理,有兴趣的朋友可自己添加修改aspx GridViewNesting
GridView嵌套实现
weixin_34221773的博客
04-09 274
  GridView嵌套实现 效果图： 技术实现： 前台： &lt;%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional
GridView使用集合
lovegonghui的专栏
11-11 1314
一、表头表尾 1、自定义多行表头，列合并，行合并 关键代码： /// /// 在 GridView 控件中创建新行时发生，此事件通常用于在创建某个行时修改该行的布局或外观 /// /// /// protected void GridView1_RowCreated(object sender, GridViewRowEventAr
GridView的用法
ht_gaogao的专栏
10-27 437
1：在Gridview中无须编写后台代码，直接实现增除删改  2：在Gridview中添加新记录 3：在Gridview中实现编辑和更新操作 4：在Gridview中实现一次性更新所有记录 5：在Gridview中固定表头的实现 6：在Gridview中合并单元格的实现 7：在Gridview中将数据操作结果显示在Footer中
Asp.net教程：Gridview用法总结
-流星雨-的专栏
06-04 1597
Gridview用法大总结啦！精彩效果截图加详细源代码注释，需要的朋友赶紧过来看看吧；走过路过，千万不要错过哦！由于篇幅限制，代码就不贴啦，要下载源码的请点击这里；希望朋友们能给出一些好的建议，本人将尽力不断完善本文！ 来点掌声吧，o(∩_∩)o...哈哈 1：在Gridview中无须编写后台代码，直接实现增除删改 2：在Gridview中添加新记录 3：在Gridview中实现编辑和更新操作 4
Gridview用法大总结（牛年珍藏版）
gxj022的专栏
11-11 756
<br />http://www.cnblogs.com/huangjianhuakarl/archive/2009/02/03/1381710.html<br /> <br /> <br />Gridview用法大总结啦！精彩效果截图加详细源代码注释，需要的朋友赶紧过来看看吧；走过路过，千万不要错过哦！<br />     由于篇幅限制，代码就不贴啦，要下载源码的请点击这里；希望朋友们能给出一些好的建议，本人将尽力不断完善本文！ 来点掌声吧，o(∩_∩)o...哈哈<br /><br />1：在Gridv
双层嵌套GridView
huhuyong2的专栏
08-09 1454
<br />展开前效果图：<br /> <br /><br /> <br /> <br />展开后效果图：<br /> <br /><br /> <br /> <br /> <br /> <br />JS(此部分最重要):<br /> <script type="text/javascript" language="javascript"><br />         var gridViewList = new Array();<br />        var objDiv;<br />       
GridView内嵌套使用GridView
09-10
在VS2005下实现GridView内嵌套使用GridView
(ASP.NET C#)Gridview中嵌套另一个Gridview源代码
03-16
许多情况下我们需要在grid中嵌套显示另外一个grid，本代码演示了如何实现这一功能。 关键字：Gridview
GridView嵌套应用实例GridView嵌套应用实例
06-08
GridView嵌套应用实例GridView嵌套应用实例GridView嵌套应用实例GridView嵌套应用实例GridView嵌套应用实例GridView嵌套应用实例
ASP.NET 开发，GridView嵌套
12-23
ASP.NET 开发，GridView嵌套上课代码，简单的描述了两个GridView的嵌套使用。
gridview嵌套gridview
№悟◇
11-29 818
OnRowDataBound事件,与1.x中的ItemDataBound有一腿.                  　       　                                                                    　                 　                 　                          
GridView嵌套GridView
weixin_30825581的博客
07-06 1766
GridView嵌套可以显示当前选定的父记录组织同时显示所有子记录。例如，你可以用它创建一个完整的按类别组织的产品列表。下一个示例演示如何在单个网格中显示一个完整的分组产品列表，如下图所示：使用的基本技术是为附表创建一个GridView，它的每行又嵌入一个GridView，这些子GridView使用TemplateField来插入到父GridView中。唯一需要...
C# ASP.NET GridView中新增一行，嵌套一个GridView
katarina_OK的博客
02-22 1325
//Parent GridView DataTable dt_Parent = new DataTable (); GridView gv_Parent = new GridView (); gv_Parent.DataSource = dt_Parent ; gv_Parent.DataBind(); //Child GridView DataTable dt_Child = new DataTable (); GridView gv_Child = new GridView (); gv_Child.D
C#.net使用Gridview1嵌套Gridview2,在Gridview2中使用Dropdownlist问题?
chengaite的专栏
07-22 746
前台代码：http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" >    Editable Nested Grid View        function expandcollapse(obj,row)    {        var div = document.
GridView中嵌套GridView
fisea的专栏
06-09 694
一：//delete   Demo   ,   use   pubs //aspx         GridViewNesting                                                                                                                    
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值