批量删除代码

        /**//// <summary>
        /// 重新发布
        /// </summary>
        /// <param name="list"></param>
        /// <param name="time"></param>
        /// <returns></returns>
        public bool UpdateIssue(System.Collections.ArrayList list, string time)
        {
            System.Collections.ArrayList sql = new System.Collections.ArrayList();
            int num = list.Count;
            for (int i = 0; i < num; i++)
            {
                sql.Add("update ProcessInf set settime = '" + time + "' ,IsPass=0 where ID = '" + list[i].ToString() + "' ");
            }
            return DbHelperSQL.ExecuteSqlTran(sql);
        }

Html代码

<asp:datagrid id="DataGrid1" runat="server" Width="100%" CssClass="tabout" AutoGenerateColumns="False">
                                <AlternatingItemStyle Wrap="False" BackColor="White"></AlternatingItemStyle>
                                <HeaderStyle Font-Size="Larger" Font-Bold="True"></HeaderStyle>
                                <Columns>
                                <asp:TemplateColumn>
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                  <ItemTemplate>
                                    <INPUT id=ID type=hidden value='<%# DataBinder.Eval(Container.DataItem, "ID")%>' name=SelectedNewInID runat="server">
                                    <asp:CheckBox id="chkbExport" runat="server" Font-Size="XX-Small" Width="41" Height="23"></asp:CheckBox>
                                  </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:BoundColumn DataField="ID" HeaderText="ID号">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="pname" HeaderText="信息标题">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="typeid_2" HeaderText="所属类别">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="inftype_2" HeaderText="信息分类">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="settime" HeaderText="发布时间">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                <asp:BoundColumn DataField="IsState_2" HeaderText="发布状态">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                
                                <asp:BoundColumn DataField="IsPass_2" HeaderText="审核状态">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                </asp:BoundColumn>
                                
                                <asp:TemplateColumn HeaderText="编辑">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                  <ItemTemplate> 
               <a href='Editprocess.aspx?id=<%# DataBinder.Eval(Container.DataItem, "ID")%>&qx=<%=pass%>&index=<%=page%>'>编辑</a> </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn HeaderText="相关评论">
                                  <HeaderStyle Wrap="False" CssClass="tabtitle" HorizontalAlign="Center"></HeaderStyle>
                                  <ItemStyle Wrap="False" CssClass="tabborder" HorizontalAlign="Center"></ItemStyle>
                                  <ItemTemplate> 
                   <a href='processComment.aspx?id=<%# DataBinder.Eval(Container.DataItem, "ID")%>&qx=<%=pass%>&index=<%=page%>'>评论</a> </ItemTemplate>
                                </asp:TemplateColumn>
                                </Columns>
                              </asp:datagrid>

Cs代码

        protected void but_issue_Click(object sender, EventArgs e)
        {
            string time = DateTime.Now.ToString("yyyy-MM-dd");
            this.SetIssue(time);
        }

        private void SetIssue(string temp)
        {
            try
            {
                System.Web.UI.WebControls.CheckBox chkbExport;
                System.Collections.ArrayList list = new ArrayList();
                foreach (DataGridItem oDataGridItem in DataGrid1.Items)
                {
                    chkbExport = (CheckBox)oDataGridItem.FindControl("chkbExport");
                    if (chkbExport.Checked)
                    {
                        string id = ((HtmlInputHidden)oDataGridItem.FindControl("ID")).Value.ToString();
                        list.Add(id);
                    }
                }
                if (proc.UpdateIssue(list, temp))
                {
                    Page.RegisterStartupScript("start", "<script>alert('重新发布成功!')</script>");
                }
                else
                {
                    Page.RegisterStartupScript("start", "<script>alert('重新发布失败!')</script>");
                }
                Bind();
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
        }

Cs代码中调用的方法:

        /**//// <summary>
        /// 重新发布
        /// </summary>
        /// <param name="list"></param>
        /// <param name="time"></param>
        /// <returns></returns>
        public bool UpdateIssue(System.Collections.ArrayList list, string time)
        {
            System.Collections.ArrayList sql = new System.Collections.ArrayList();
            int num = list.Count;
            for (int i = 0; i < num; i++)
            {
                sql.Add("update ProcessInf set settime = '" + time + "' ,IsPass=0 where ID = '" + list[i].ToString() + "' ");
            }
            return DbHelperSQL.ExecuteSqlTran(sql);
        }