ASP.NET DevExpress v19 GridView部门编码列仅支持数字搜索问题求助

问题现象 #

使用DevExpress v19版本的ASPxGridView时，对「部门编码（Dept Code）」列筛选出现异常：

• 输入数字（如101）能正常匹配到包含该数字的条目（如101HRE）
• 输入文本内容（如HRE）时返回空结果集

相关代码 #

ASPX页面代码 #

<%@ Page Title="" Language="C#" MasterPageFile="~/Main.Master" AutoEventWireup="true" CodeBehind="SickLeaveDashboard.aspx.cs" Inherits="UCHRADMIN.SickLeaveDashboard" %>

<%@ Register Assembly="DevExpress.Web.v19.1, Version=19.1.16.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
                    <dx:ASPxGridView ID="ASPxGridView1" Width="100%" runat="server" AutoGenerateColumns="False" SettingsExport-FileName="Leave Type DashBoard" DataSourceID="SqlDataSource1" KeyFieldName="ID" ClientInstanceName="grid"  Theme="PlasticBlue" >
                        <SettingsPager PageSize="10">
                        </SettingsPager>

                        <SettingsExport EnableClientSideExportAPI="true"/>
                        <SettingsEditing EditFormColumnCount="1" Mode="PopupEditForm">
                        </SettingsEditing>
                        <Settings ShowFilterRow="True"  ShowGroupPanel="True" />
                        <SettingsPopup>
                            <EditForm Modal="True" ShowShadow="True" VerticalAlign="WindowCenter" HorizontalAlign="WindowCenter">
                            </EditForm>
                        </SettingsPopup>
                          <Toolbars>
            <dx:GridViewToolbar>
                <SettingsAdaptivity Enabled="True" EnableCollapseRootItemsToIcons="True" />
                <Items>
                    <dx:GridViewToolbarItem Command="ExportToXls" />
                </Items>
            </dx:GridViewToolbar>
        </Toolbars>
                        <Columns>

                            <dx:GridViewDataTextColumn FieldName="Emp No" Visible="True" ReadOnly="True" VisibleIndex="1">
                                <EditFormSettings Visible="False" />
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="Emp Name"  VisibleIndex="2" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>
                             <dx:GridViewDataTextColumn  FieldName="Dept Code" VisibleIndex="3" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="Dept Name" VisibleIndex="4" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>
                             <dx:GridViewDataTextColumn FieldName="With Attachment" VisibleIndex="5" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>
                             <dx:GridViewDataTextColumn FieldName="Without Attachment"  VisibleIndex="6" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>

                             <dx:GridViewDataTextColumn FieldName="Year"  VisibleIndex="7" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
                            </dx:GridViewDataTextColumn>

                        </Columns>
                    </dx:ASPxGridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                        OldValuesParameterFormatString="original_{0}"
                        SelectCommand="SELECT
    r.EmpNo AS [Emp No],
    EmpName AS [Emp Name],
    cast(REPLACE(REPLACE(m.DEPT, ' ', ''), CHAR(13)+CHAR(10), '')  as varchar(100)) AS [Dept Code],
    cast(b.MCDL01  as nvarchar(200)) AS [Dept Name],
    SUM(CASE WHEN (r.AttachmentFileName IS NOT NULL) THEN 1 ELSE 0 END) AS [With Attachment],
    SUM(CASE WHEN (r.AttachmentFileName = '' or r.AttachmentFileName IS NULL ) THEN 1 ELSE 0 END) AS [Without Attachment],
    YEAR(r.FromDate) AS [Year]
    into #y
FROM
    [dbo].[tblRequest] r
INNER JOIN
    [dbo].[vEmployeeMaster] m ON m.EMPNO = r.EmpNo
INNER JOIN
    [dbo].[vBusinessUnitMaster] b ON MCMCU = m.DEPT
WHERE
    r.RequestType IN ('SLP', 'SLH', 'SLU') --and m.DEPT like '%101%'
GROUP BY
    r.EmpNo, EmpName, m.DEPT, YEAR(r.FromDate), b.MCDL01
ORDER BY r.EmpNo, EmpName

select * from #y" >

                    </asp:SqlDataSource>
                </div>
            </div>
        </div>
    </div>
</asp:Content>

问题截图 #

原因分析 #

1. 默认筛选模式限制：DevExpress GridView的FilterRow默认采用StartsWith（前缀匹配）逻辑，输入HRE时只会匹配以HRE开头的部门编码，而你的数据是101HRE，不符合前缀匹配规则，因此无结果；输入101时刚好是前缀，所以能命中。
2. 字段类型潜在影响：虽然SQL中将部门编码转为varchar(100)，但若GridView自动识别字段类型时误判为数值型，也会导致文本筛选失效，不过从当前现象看，核心原因还是筛选模式问题。

解决方案 #

修改部门编码列的筛选模式为Contains（包含匹配），以下两种方式任选其一：

方式1：ASPX代码直接配置 #

修改「Dept Code」列的节点，添加筛选相关设置：

<dx:GridViewDataTextColumn FieldName="Dept Code" VisibleIndex="3" PropertiesTextEdit-ValidationSettings-RequiredField-IsRequired="true">
    <Settings FilterMode="DisplayText" />
    <SettingsAutoFilter Operator="Contains" />
</dx:GridViewDataTextColumn>

• Settings-FilterMode="DisplayText"：确保基于显示文本筛选，避免字段类型识别偏差
• SettingsAutoFilter-Operator="Contains"：设置自动筛选行的默认操作符为“包含”

方式2：后台代码动态设置 #

在页面加载事件中添加代码：

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        var deptCodeColumn = ASPxGridView1.Columns["Dept Code"] as GridViewDataTextColumn;
        if (deptCodeColumn != null)
        {
            deptCodeColumn.Settings.FilterMode = ColumnFilterMode.DisplayText;
            deptCodeColumn.SettingsAutoFilter.Operator = AutoFilterCondition.Contains;
        }
    }
}

验证步骤 #

先在SQL中执行以下语句，确认数据本身包含目标文本：

SELECT * FROM #y WHERE [Dept Code] LIKE '%HRE%'

若能返回结果，说明数据正常，只需调整GridView筛选设置即可解决问题。

内容的提问来源于stack exchange，提问作者ahmed abdelaziz