JS实现DataGrid的全选

最新推荐文章于 2017-12-28 09:25:10 发布

tiz198183

最新推荐文章于 2017-12-28 09:25:10 发布

阅读量904

点赞数

分类专栏： WebForms 文章标签： datagrid asp textbox server button function

本文链接：https://blog.csdn.net/litao2/article/details/7656340

版权

WebForms 专栏收录该内容

58 篇文章 0 订阅

订阅专栏

    <form id="form1" runat="server">
    <div>
        <table cellpadding="0" cellspacing="0" border="0" style="width: 100%">
            <tr>
                <td colspan="2" style="padding-left: 0px">
                    <table cellpadding="0" cellspacing="0" border="1px" style="width: 100%" bordercolor="#CCCCCC">
                        <tr>
                            <td align="right" style="width:100px;">
                                时间开始范围：
                            </td>
                            <td style="width:200px;">
                                <asp:TextBox ID="txtStartTime" runat="server" onClick="WdatePicker()"></asp:TextBox>
                            </td>
                            <td align="right" style="width:100px;">
                                时间结束范围：
                            </td>
                            <td style="width:200px;">
                                <asp:TextBox ID="txtEndTime" runat="server" onClick="WdatePicker()"></asp:TextBox>
                            </td>
                            <td>
                                发布人：<asp:TextBox ID="txtFBR" runat="server"></asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td align="right">
                                发出地：
                            </td>
                            <td>
                                <asp:DropDownList ID="droprscadd1" runat="server" Width="100px" AutoPostBack="true"
                                    OnSelectedIndexChanged="droprscadd1SelectedIndexChanged">
                                </asp:DropDownList>
                                <asp:DropDownList ID="droprscadd2" runat="server" Width="83px">
                                </asp:DropDownList>
                            </td>
                            <td align="right">
                                到达地：
                            </td>
                            <td>
                            <asp:DropDownList ID="dropdestadd1" runat="server" Width="100px" AutoPostBack="true"
                                    OnSelectedIndexChanged="dropdestadd1SelectedIndexChanged">
                                </asp:DropDownList>
                                <asp:DropDownList ID="dropdestadd2" runat="server" Width="80px">
                                </asp:DropDownList>
                            </td>
                            <td>
                                <asp:Button ID="btnCheck" runat="server" Text="查 询"  OnClick="btnCheck_Click"/>
                                <asp:Button ID="btnSz" runat="server" Text="重新设置LED显示条件" οnclick="btnSz_Click" />
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td colspan="2" style="padding-top:5px;">
                    <asp:DataGrid ID="datagrid" runat="server" Width="100%" DataKeyField="id" AutoGenerateColumns="false">
                        <Columns>
                            <asp:TemplateColumn>
                                <HeaderTemplate>
                                    <input id="chkall" type="checkbox" οnclick="CheckAll(this.form)" />全选
                                </HeaderTemplate>
                                <ItemTemplate>
                                <input id="SelectID" name="SelectID" style="border: 0" type="checkbox" value='<%#Eval("id") %>' />
                                </ItemTemplate>
                                <ItemStyle Width="50px" />
                            </asp:TemplateColumn>
                            <asp:BoundColumn DataField="pubdate" HeaderText="发布日期">
                                <ItemStyle Width="120px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="rscadd" HeaderText="起运地">
                                <ItemStyle Width="63px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="destadd" HeaderText="目的地">
                                <ItemStyle Width="80px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="thingstype" HeaderText="货物名称">
                                <ItemStyle Width="80px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="trucktype" HeaderText="所求车型">
                                <ItemStyle Width="140px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="dt" HeaderText="吨位">
                                <ItemStyle Width="70px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="publisher" HeaderText="发布人">
                                <ItemStyle Width="60px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="address" HeaderText="门牌号">
                                <ItemStyle Width="100px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="telephone" HeaderText="联系电话">
                                <ItemStyle Width="159px" />
                            </asp:BoundColumn>
                            <asp:BoundColumn DataField="id" HeaderText="标识号">
                                <ItemStyle Width="50px" />
                            </asp:BoundColumn>
                        </Columns>
                        <HeaderStyle BackColor="#E3ECFB" Font-Bold="True" />
                    </asp:DataGrid>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Button ID="btnSetTop" runat="server" Text="设为置顶" OnClick="btnSetTop_Click" />
                    <asp:Button ID="btnCancelTop" runat="server" Text="取消置顶"  OnClick="btnCancelTop_Click"/>
                    <asp:Button ID="btnDeleteAll" runat="server" Text="删除数据" OnClick="btnDeleteAll_Click"/>
                    <asp:Button ID="btnSetOut" runat="server" Text="设为过期"   οnclick="btnSetOut_Click" />
                    <asp:Button ID="btnDeleteOut" runat="server" Text="删除过期信息"  οnclick="btnDeleteOut_Click" />
                </td>
                <td align="right">
                    <uc:Pagination ID="Pager" runat="server"></uc:Pagination>
                </td>
            </tr>
        </table>
    </div>
    </form>
    <script type="text/javascript">

        //全选、反选
        function CheckAll(form) {
            for (var i = 0; i < form.elements.length; i++) {
                var e = form.elements[i];
                if (e.name != 'chkall')
                    e.checked = form.chkall.checked;
            }
        }

        //判断是否选中
        function YesNoSelect() {
            var checked = false;
            var ids = document.getElementsByName("SelectID");
            for (var i = 0; i < ids.length; i++) {
                if (ids[i].checked) {
                    checked = true;
                }
            }
            if (!checked) {
                alert("请选择要操作的数据");
                return false;
            }
        }

        //确定是否删除
        function YesDel() {
            if (confirm("确定要删除过去信息吗？删除后不能恢复了") == true) {
                return true;
            } else {
               return false;
            }
       }

       //确定是否删除
       function YesNOSet() {
           if (confirm("确定要重新设置LED显示条件吗？") == true) {
               return true;
           } else {
               return false;
           }
       }
    </script>

批量删除

protected void Button1_Click(object sender, EventArgs e)
{
string Id_str = Request.Form["SelectID"];

         Page newpage = new Page();
         string Path_db = ConfigurationSettings.AppSettings["YXPath"];
         string Path_conn = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" +

newpage.Server.MapPath("~") + "\\" + Path_db;
         OleDbConnection conn = new OleDbConnection(Path_conn);
         string sql = "delete from CountNews where ID in (" + Id_str + ")";
         OleDbCommand cmd = new OleDbCommand(sql,conn);
         try
         {
             conn.Open();
             cmd.ExecuteNonQuery();
             conn.Close();
         }
         catch (Exception ex)
         {
             Response.Write("<script>alert('操作失败！')</script>");
         }
         this.dg1.DataSource = GetData();
         this.dg1.DataBind();
     }