GridView手动减行

最新推荐文章于 2019-06-26 19:06:53 发布

lutaotony

最新推荐文章于 2019-06-26 19:06:53 发布

阅读量563

点赞数

分类专栏： C# 文章标签： asp ASP object Object server Server sql SQL string String

本文链接：https://blog.csdn.net/lutaotony/article/details/7334761

版权

C# 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

其实就是在ViewState保存临时表。然后对临时表进行操作。

问题阐述：

页面两个按钮一个是枚举类型一个是减行

和一个gridview1控件默认有5个空行。

点击枚举类型--弹出div1这个gridview2。选择gridview2里面的数据后，把数据绑定到gridview中。

因为gridview减行都是要根据id来减的，所以要在gridview中生成一个id，根据id移除。

前台代码：

  <div id="div1" runat="server" visible="false" style="width: 800px; left: 50%; margin: -100px 0 0 -370px; position: absolute;
        top: 20%;">
        <table width ="800px" style="background:#e1ecfc">
               <tr>
                <td width="800px">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="false">
                        <Columns>
                            <asp:TemplateField>
                                <ItemTemplate>
                                    <asp:CheckBox ID="ck" runat="server" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField Visible="False" DataField="strEnumID" HeaderText="枚举">
                                                          </asp:BoundField>
                            <asp:BoundField Visible="False" DataField="strEnumTypeName" HeaderText="枚举名称">
                                                          </asp:BoundField>
                            <asp:BoundField Visible="False" DataField="lngEnumTypeID" HeaderText="类型ID">
                               </asp:BoundField>
                             </Columns>
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td align="center">
                    <asp:LinkButton ID="lnkbtnOK" runat="server" OnClick="lnkbtnOK_Click">
						                    </asp:LinkButton>    
                    <asp:LinkButton ID="lnkbtnCancel" runat="server" OnClick="lnkbtnCancel_Click">
							                    </asp:LinkButton>
               </td>
            </tr>
        </table>
    </div>

后台代码如下：

namespace PM
{
    public partial class frmPm_ShowGatheringBase : PMBasePage
    {

       
       
        #region 将临时表保存
        private DataTable GridViewDataTable
        {
            get
            {
                object obj = this.ViewState["GridViewDataTable"];
                return (obj == null) ? null : (DataTable)obj;
            }
            set
            {
                this.ViewState["GridViewDataTable"] = value;
            }
        }
        #endregion


        #region 绑定数据
        protected void GridViewBind(string keyID)
        {
            string sql = string.Empty;
            DataTable dt = new DataTable();           
            if (keyID == string.Empty)
                keyID = "' '";
            else
                keyID = keyID.Substring(0, keyID.Length - 1);
            if (keyID.Contains("Remove") == false)
            {
                if (keyID.Contains("ID") != false)
                    keyID = keyID.Substring(2);
                sql = sql+ keyID.ToString() ;
               
                dt = GetDataTable(sql);
                if (dt == null)
                    return;
                int count = 0;
                GridViewDataTable = dt;
                if (dt.Rows.Count < 5)
                {
                    count = dt.Rows.Count;
                    for (int i = 0; i < 5 - count; i++)
                    {
                        dt.Rows.Add(dt.NewRow());
                    }
                    GridView1.DataBind(dt);
                }
                else
                    GridView1.DataBind(dt);
            }
            else
            {
                keyID = keyID.Substring(6);
                string[] strkey = keyID.Split(',');
                int count = 0;
                for (int i = 0; i < strkey.Length; i++)
                {
                    int key = int.Parse(strkey[i].ToString());
                    if (i == 0)
                    {
                        GridViewDataTable.Rows.RemoveAt(key - 1);
                        count++;
                    }
                    else
                    {
                        GridViewDataTable.Rows.RemoveAt(key - 1 - count);
                        count++;
                    }
                }
                GridView1.DataBind(GridViewDataTable);
            }
        }
        #endregion


        protected void lnkbtnOK_Click(object sender, EventArgs e)
        {
            string businesstypeID = "ID";
            for (int i = 0; i < GridView2.Rows.Count; i++)
            {
                CheckBox cbox = (CheckBox)GridView2.Rows[i].FindControl("ck");
                if (cbox.Checked == true)
                    businesstypeID += GridView2.Rows[i].Cells[5].Text.ToString() + ",";
            }
            if (businesstypeID == "ID")
            {
                this.MsgBox("请枚举类型!");
                return;
            }
            GridViewBind(businesstypeID);
            div1.Visible = false;
        }

        protected void btnSelEqu_Click(object sender, EventArgs e)
        {
            this.div1.Visible = true;         
            string sql = string.Empty;
            sql = sal语句;
            
            DataTable dt =GetDataTable(sql);
            this.GridView2.DataBind(dt);
        }

        protected void lnkbtnCancel_Click(object sender, EventArgs e)
        {
            div1.Visible = false;           
        }


        protected void btnDetailRemove_Click(object sender, System.EventArgs e)
        {
            string businessTypeid = "Remove";
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox");
                if (cbox.Checked == true)
                    businessTypeid += GridView1.Rows[i].Cells[1].Text.ToString() + ",";
            }
            if (businessTypeid == "Remove")
            {
                this.MsgBox("请选择要移除的行");
                return;
            }
            GridViewBind(businessTypeid);
        }

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowIndex != -1)
            {
                int id = e.Row.RowIndex + 1;
                e.Row.Cells[1].Text = id.ToString();
            }
        }
    }
}