批量通过

.aspx页面:

<script type="text/javascript">
        function clickCheckbox(obj) {
            $(".check").attr("checked", $(obj).attr("checked"));
        }

</script>

<asp:Repeater ID="_rptMain" runat="server" onitemcommand="_rptMain_ItemCommand">
       <ItemTemplate>

     <input type="checkbox" id="ChkCheck" runat="server" class="check" value='<%#((IMDMSP.MODEL.B_Record_WebStructure)Container.DataItem).RecordID %>' />

      </ItemTemplate>
</asp:Repeater>

<input type="checkbox" onclick="clickCheckbox(this);" />

<asp:LinkButton ID="_lbtnPassAll" runat="server" Text="批量通过" onclick="_lbtnPassAll_Click" ></asp:LinkButton>

.aspx.cs页面:

using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
        protected void _lbtnPassAll_Click(object sender, EventArgs e)
        {
            string ids = "";
            foreach (RepeaterItem item in _rptMain.Items)
            {
                var checkbox = (HtmlInputCheckBox)item.FindControl("ChkCheck");
                if(checkbox.Checked)
                {
                    ids+=","+checkbox.Value;
                }
            }
            if (ids.Length > 0)
            {
                var bRecordWebStructureManage = new IMDMSP.BLL.B_Record_WebStructureManage();
                if (bRecordWebStructureManage.PassAll(ids.Substring(1)))
                {
                    Response.Redirect(Request.Url.ToString());
                }
            }
        }

sql语句:UPDATE B_Record_WebStructure SET CorfirmType='0' WHERE RecordID in (" + recordId + ")

原文地址:https://www.cnblogs.com/whlhaikuotiankong/p/2026731.html