ASP.NET 网格视图更新事件不更新十进制值

本文关键字:更新 十进制 事件 ASP 网格 视图 NET | 更新日期: 2023-09-27 18:33:49

我有一个 ASP.NET 4.5 网格视图控件,其中包含用于更新/插入/显示 3 列表中的值的模板字段。 因此,有一个 onUpdate 事件连接来处理更新。

我的问题是,当我输入 0、0.0 或其他 0 排列时,十进制列不会更新。 使用正值或负值工作正常,另一个可见列确实会更新。 此外,在小数点字段上插入带有 0 的新行似乎没有问题。

我该如何解决这个问题?

    <asp:GridView ID="PriceGroupGv" runat="server" AllowPaging="true" AllowSorting="true" DataSourceID="PriceGroupEds" DataKeyNames="Id" AutoGenerateColumns="false"
         ShowHeader="true" ShowHeaderWhenEmpty="false" ShowFooter="true" ItemType="Infrastructure.PricingGroup"
         CssClass="table table-bordered table-condensed table-striped" AlternatingRowStyle-BackColor="GhostWhite" OnRowUpdating="PriceGroupGv_RowUpdating">
        <EmptyDataTemplate>
            <table class="table table-bordered table-condensed table-striped">
                <tr>
                    <th>Name</th>
                    <th>Markup</th>
                    <th></th>
                </tr>
                <tr>
                    <td>
                        <asp:TextBox ID="NameTxt" runat="server" />
                        <asp:RequiredFieldValidator ID="NameRfv" runat="server" ControlToValidate="NameTxt" ValidationGroup="NewRowVg" ForeColor="Red">
                            *</asp:RequiredFieldValidator>
                    </td>
                    <td>
                        <asp:TextBox ID="MarkupTxt" runat="server"/>
                        <asp:RegularExpressionValidator ID="MarkupRxv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="NewRowVg" ValidationExpression="^(-)?'d+('.'d'd)?$" ForeColor="Red">
                            #.#</asp:RegularExpressionValidator>
                        <asp:RequiredFieldValidator ID="MarkupRfv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="NewRowVg" ForeColor="Red">
                            *</asp:RequiredFieldValidator>
                    </td>
                    <td>
                        <asp:LinkButton ID="AddBtn" runat="server" Text="Add New" OnClick="AddBtn_Click" CommandArgument="EmptyData" CausesValidation="true"
                             ValidationGroup="NewRowVg"/>
                    </td>
                </tr>
            </table>
        </EmptyDataTemplate>
        <Columns>
            <asp:BoundField DataField="Id" Visible="false" />
            <asp:TemplateField HeaderText="Name">
                <ItemTemplate>
                    <asp:Label ID="NameLbl" runat="server" Text="<%# Item.Name %>" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="NameTxt" runat="server" Text="<%# Item.Name %>" />
                    <asp:RequiredFieldValidator ID="NameRfv" runat="server" ControlToValidate="NameTxt" ValidationGroup="EditRowVg" ForeColor="Red">
                        *</asp:RequiredFieldValidator>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="NameTxt" runat="server" />
                    <asp:RequiredFieldValidator ID="NameRfv" runat="server" ControlToValidate="NameTxt" ValidationGroup="NewRowVg" ForeColor="Red">
                        *</asp:RequiredFieldValidator>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Markup">
                <ItemTemplate>
                    <asp:Label ID="MarkupLbl" runat="server" Text="<%# Item.Markup %>" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="MarkupTxt" runat="server" Text="<%# Item.Markup %>"/>
                    <%--<asp:RangeValidator ID="MarkupRngv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="EditRowVg" Type="Double"
                        MaximumValue="999.9999" MinimumValue="-999.9999" ForeColor="Red">
                        #.##</asp:RangeValidator>
                    <asp:RegularExpressionValidator ID="MarkupRxv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="EditRowVg" ValidationExpression="^(-)?'d+('.'d'd)?$" ForeColor="Red">
                        #.#</asp:RegularExpressionValidator>--%>
                    <asp:RequiredFieldValidator ID="MarkupRfv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="EditRowVg" ForeColor="Red">
                        *</asp:RequiredFieldValidator>
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:TextBox ID="MarkupTxt" runat="server"/>
                    <asp:RangeValidator ID="MarkupRngv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="NewRowVg"  Type="Double"
                        MaximumValue="999.9999" MinimumValue="-999.9999" ForeColor="Red">
                        #.##</asp:RangeValidator>
                    <%-- <asp:RegularExpressionValidator ID="MarkupRxv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="NewRowVg" 
                        ValidationExpression="^(-)?'d+('.'d'd)?$" ForeColor="Red">
                        #.#</asp:RegularExpressionValidator>--%>
                    <asp:RequiredFieldValidator ID="MarkupRfv" runat="server" ControlToValidate="MarkupTxt" ValidationGroup="NewRowVg" ForeColor="Red">
                        *</asp:RequiredFieldValidator>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:LinkButton ID="EditBtn" runat="server" CommandName="Edit" Text="Edit" />
                    <asp:LinkButton ID="DeleteBtn" runat="server" CommandName="Delete" Text="Delete" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:LinkButton ID="UpdateBtn" runat="server" CommandName="Update" Text="Update" CausesValidation="true" ValidationGroup="EditRowVg" />
                    <asp:LinkButton ID="CancelBtn" runat="server" CommandName="Cancel" Text="Cancel" />
                </EditItemTemplate>
                <FooterTemplate>
                    <asp:LinkButton id="AddBtn" runat="server" Text="Add New" OnClick="AddBtn_Click" CommandArgument="NotEmpty" CausesValidation="true" ValidationGroup="NewRowVg" />
                </FooterTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:EntityDataSource ID="PriceGroupEds" runat="server" EnableInsert="true" EnableDelete="true" EnableFlattening="false" EnableUpdate="true" EntitySetName="PricingGroups"
        ConnectionString="name=Entities" DefaultContainerName="Entities" />

代码隐藏:

    protected void PriceGroupGv_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow gvr = (sender as GridView).Rows[e.RowIndex];
        e.NewValues["Name"] = (gvr.FindControl("NameTxt") as TextBox).Text;
        e.NewValues["Markup"] = Decimal.Parse((gvr.FindControl("MarkupTxt") as TextBox).Text);
        PriceGroupGv.DataBind();
    }// end event

ASP.NET 网格视图更新事件不更新十进制值

已解决 - 使标记列在数据库和模型中可为空。我还在 db 中将类型更改为 Float,在模型中将类型更改为 Double,但最终让它工作的是具有可为空的属性。

如果其他人有更好的解决方案,我将欢迎任何其他答案。