【玩转GridView】之让GridView动起来(二)

曾经终败给现在 2022-08-08 15:59 239阅读 0赞

# 前言： #

上篇博客，我们介绍了通过使用Template和Gridview属性结合使用的方式，让gridview变活了。这篇博客接着上次的话题，在之后的项目中发现了gridview给我们的更多好东西，这次就给大家展示一下他们的强大

## 界面展示： ##

图一：是正常显示下的效果，可以看到没列后都有两行操作列

![Center][]

图二：是在编辑状态下的效果，一列都变成了文本框显示数据，并且不可修改的字段都是置灰的。

![Center 1][]

说明：上述两种效果是用Template的两种模板EditItemTemplate和ItemTemplate之间的相互切换实现的

## 前台代码： ##

<asp:AdvGridView ID="gdvProjectlist" runat="server" AutoGenerateColumns="False" Width="100%"
               AllowSorting="true" OnSorting="gdvProjectlist_Sorting" BorderWidth="0px" OnRowCancelingEdit="gdvProjectlist_RowCancelingEdit"
               OnRowUpdating="gdvProjectlist_RowUpdating" CssClass="QueryList" OnRowDeleting="gdvProjectlist_RowDeleting"
               OnRowEditing="gdvProjectlist_RowEditing" OnRowDataBound="gdvProjectlist_RowDataBound" DataKeyNames="S_PROJ_CODE">
                    <HeaderStyle CssClass="QueryTop" />
                     <RowStyle CssClass="QueryList" />
             <Columns>
                <asp:TemplateField HeaderText="年月" SortExpression="t.S_YEAR_MONTH">
                      <EditItemTemplate>
                         <asp:TextBox ID="tbSyearMonth" runat="server" Text='<%# Bind("S_YEAR_MONTH") %>'Enabled="false" Width="100px"></asp:TextBox>
                      </EditItemTemplate>
                      <ItemTemplate>
                          <asp:Label ID="lbelSyearMonth" runat="server" Text='<%# Bind("S_YEAR_MONTH") %>'></asp:Label>
                      </ItemTemplate>
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="计划工作量">
                      <EditItemTemplate>
                         <asp:TextBox ID="tbPlan" runat="server" MaxLength="10" Text='<%# Bind("N_PLAN_WORKLOAD") %>' Width="100px"></asp:TextBox>
                      </EditItemTemplate>
                      <ItemTemplate>
                          <asp:Label ID="lbelplan" runat="server" Text='<%# Bind("N_PLAN_WORKLOAD") %>'></asp:Label>
                      </ItemTemplate>
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="完成工作量">
                       <EditItemTemplate>
                         <asp:TextBox ID="tbComplete" runat="server" MaxLength="10" Text='<%# Bind("N_ACTUAL_WORKLOAD") %>' Width="100px"></asp:TextBox>
                       </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lbelComplete" runat="server" Text='<%# Bind("N_ACTUAL_WORKLOAD") %>'></asp:Label>
                       </ItemTemplate>
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="操作员" SortExpression="t.S_USER_NAME">
                       <EditItemTemplate>
                           <asp:TextBox ID="tbOper" runat="server" Text='<%# Bind("S_USER_NAME") %>' Width="100px" Enabled="false"></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                           <asp:HiddenField ID="tbWorkID" runat="server" Value='<%#Eval("S_WORDLOAD_ID") %>'></asp:HiddenField>
                           <asp:Label ID="lbelOper" runat="server" Text='<%# Bind("S_USER_NAME") %>'></asp:Label>
                        </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="录入日期" SortExpression="t.D_CREATE_DATE">
                      <EditItemTemplate>
                        <asp:TextBox ID="tbPerdatte" Width="100px" runat="server" Text='<%# Bind("D_CREATE_DATE"　, "{0:yyyy-MM-dd}") %>' Enabled="false"></asp:TextBox>
                      </EditItemTemplate>
                       <ItemTemplate>
                         <asp:Label ID="lbelPerdate" runat="server" Text='<%# Bind("D_CREATE_DATE", "{0:yyyy-MM-dd}") %>'></asp:Label>
                       </ItemTemplate>
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="备注">
                      <EditItemTemplate>
                          <asp:TextBox ID="tbComment" Width="150px" runat="server" Text='<%# Bind("S_COMMENTS") %>'></asp:TextBox>
                     </EditItemTemplate>
                      <ItemTemplate>
                          <asp:Label ID="lbelComment" runat="server" Text='<%# Bind("S_COMMENTS") %>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
                 <asp:CommandField ShowEditButton="True" UpdateText="保存"><HeaderStyle Width="60px" /></asp:CommandField>
                 <asp:TemplateField>
                      <ItemTemplate>
                         <asp:LinkButton ID="delete" runat="server" CommandName="Delete">删除</asp:LinkButton>
                     </ItemTemplate>
                     <HeaderStyle Width="60px" />
                 </asp:TemplateField>
             </Columns>
             <AlternatingRowStyle BackColor="WhiteSmoke" />
          </asp:AdvGridView>

说明: 上述这段代码，主要是拼接的gridview页面，用模板代替了平常的gridview列，然后在模板中嵌入了编辑模板，也就是编辑状态下的效果；和普通的itemplate模板显示数据效果。

接下来再来看一下，后台中是如何实现编辑删除操作

## 后台代码： ##

#region 对gridview的删改操作--贺彩妍--2015-8-25 15:17:39
        /// <summary>
        /// 取消行编辑操作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void gdvProjectlist_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gdvProjectlist.EditIndex = -1;
            RefreshPage();
            if (gdvProjectlist.Rows.Count > 0)
            {
                export.Visible = true;
            }
        }
    
        /// <summary>
        /// gridview行删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void gdvProjectlist_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            modelRmcsqWorkload = new ModelRmcsqWorkload();
            //获取gridview中label的值
            Label lbpro = gdvProjectlist.Rows[e.RowIndex].FindControl("LbelProCode") as Label;//项目编号
            Label lbym = gdvProjectlist.Rows[e.RowIndex].FindControl("lbelSyearMonth") as Label;//年月
            try
            {
                //给model赋值
                modelRmcsqWorkload.SProjCode = lbpro.Text;
                modelRmcsqWorkload.SYearMonth = lbym.Text;
                modelRmcsqWorkload.SUnitCode = LoginUser.Current.Unitcode;
                modelRmcsqWorkload.SFlag = "1";
    
                查询要删除一行的主键Id
                modelRmcsqWorkload = _bllRmcsqWorkload.GetWorkID(modelRmcsqWorkload);
    
                //调用不带事务的删除方法
                int result = _bllRmcsqWorkload.DeleteRmcsqWorkload(modelRmcsqWorkload);
                if (result > 0)
                {
                    Alert("删除成功");
                    RefreshPage();  //刷新gridview
                }
                else
                {
                    Alert(" 删除失败！");
                }
            }
            catch
            {
                Alert(" 删除失败！");
            }
        }
    
        /// <summary>
        /// gridview行编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void gdvProjectlist_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gdvProjectlist.EditIndex = e.NewEditIndex;
            GridViewRow row = gdvProjectlist.Rows[e.NewEditIndex];
    
            export.Visible = false;
            RefreshPage();
        }
    
        /// <summary>
        /// gridview行更新
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void gdvProjectlist_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            modelRmcsqWorkload = new ModelRmcsqWorkload();
            string mesage = "";
            modelRmcsqWorkload.SUnitCode = LoginUser.Current.Unitcode;
            modelRmcsqWorkload.SUnitName = LoginUser.Current.Unitname;
            modelRmcsqWorkload.SFlag = "1";
    
            TextBox tboperate = gdvProjectlist.Rows[e.RowIndex].FindControl("tbOper") as TextBox;
            modelRmcsqWorkload.SUserName = tboperate.Text;//录入人姓名
            TextBox tbpro = gdvProjectlist.Rows[e.RowIndex].FindControl("tbProCode") as TextBox;
            modelRmcsqWorkload.SProjCode = tbpro.Text;//项目编号
            TextBox tbproname = gdvProjectlist.Rows[e.RowIndex].FindControl("tbProName") as TextBox;
            modelRmcsqWorkload.SProjName = tbproname.Text;//项目名称
            TextBox tbSyearMonth = gdvProjectlist.Rows[e.RowIndex].FindControl("tbSyearMonth") as TextBox;
            modelRmcsqWorkload.SYearMonth = tbSyearMonth.Text;//年月
            TextBox tbplan = gdvProjectlist.Rows[e.RowIndex].FindControl("tbPlan") as TextBox;
            Double plan = 1.0;
            Double.TryParse(tbplan.Text, out plan);
            if (plan < 0)
            {
                plan = 1;
                mesage += "计划工作量不能小于0或者输入非数字，系统自动赋值为1！\n";
            }
            modelRmcsqWorkload.NPlanWorkload = plan;//计划工作量
            TextBox tbcomp = gdvProjectlist.Rows[e.RowIndex].FindControl("tbComplete") as TextBox;
            Double complete = -0.0;
            Double.TryParse(tbcomp.Text, out complete);
            modelRmcsqWorkload.NActualWorkload = complete;//完成工作量
    
            TextBox tbComment = gdvProjectlist.Rows[e.RowIndex].FindControl("tbComment") as TextBox;
            modelRmcsqWorkload.SComments = tbComment.Text.Trim().Replace("'", "‘");
            ModelRmcsqWorkload rmcsqWorkload = new ModelRmcsqWorkload();
            //获取要更新的ID
            rmcsqWorkload = _bllRmcsqWorkload.GetWorkID(modelRmcsqWorkload);
            modelRmcsqWorkload.SWordloadId = rmcsqWorkload.SWordloadId;
            modelRmcsqWorkload.SYearMonth = rmcsqWorkload.SYearMonth;
            modelRmcsqWorkload.DCreateDate = rmcsqWorkload.DCreateDate;
            modelRmcsqWorkload.SUserCode = rmcsqWorkload.SUserCode;
            int result = _bllRmcsqWorkload.UpdateRmcsqWorkload(modelRmcsqWorkload);
            if (result > 0)
            {
                Alert("更新成功");
                gdvProjectlist.EditIndex = -1;
    
                RefreshPage();
                export.Visible = true;
            }
            else
            {
                Alert("更新失败");
            }
        }
    
        /// <summary>
        /// 排序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void gdvProjectlist_Sorting(object sender, GridViewSortEventArgs e)
        {
    
            if (ViewState["order"] != null)
            {
                if (ViewState["order"].ToString() != " order by " + e.SortExpression)
                    ViewState["order"] = " order by " + e.SortExpression;
                else
                    ViewState["order"] = " order by " + e.SortExpression + " desc";
            }
            else
            {
                ViewState["order"] = " order by " + e.SortExpression;
            }
            RefreshPage();
        }
        #endregion

说明：这里使用了小编上篇博客提到的gridview的属性方法。利用gridview的自带属性方法，实现了gridview直接编辑的效果。

## 适用环境： ##

这样直接对gridview的操作，小编觉得比较适用在数据量不是很大，同时每次修改的字段较固定，表中字段不是很多的情况。

如果数据量大的时候再用这种直接编辑的，一条一条的编辑就会让用户觉得操作过于繁琐了，这种情况反而适合使用上篇博客所写的方法。

## 总结： ##

开发软件的目的就在于为用户服务，用户的体验才是最重要的，所以在做项目的时候，该多考虑一下如何做才能让用户操作更简便，如何让用户喜欢上使用你的软件，而不是用过一次之后有种再也不想用的念头。

[Center]: /images/20220731/39c78e9fe8144c57a29ded2fe47b705e.png
[Center 1]: /images/20220731/7b810cc76aa84508ac973c02a5a84b2d.png