datasource with some sql parameters in ()

最新推荐文章于 2024-12-25 09:31:14 发布

zexu82

最新推荐文章于 2024-12-25 09:31:14 发布

阅读量517

点赞数

分类专栏： Nettier

本文链接：https://blog.youkuaiyun.com/zexu82/article/details/9076743

版权

Nettier 专栏收录该内容

8 篇文章

订阅专栏

<data:VwUserPackageInfoDataSource runat="server" ID="UserPackageInfoDS" SelectMethod="GetPaged">
            <Parameters>
                <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false"   >
                    <Filters>
                        <data:VwUserPackageInfoExpressionBuilder BuilderExpression="AppendEquals" Column="PackageTypeId" ControlID="ddl_package"/>
                        <data:VwUserPackageInfoExpressionBuilder BuilderExpression="AppendEquals" Column="Validate" ControlID="ddl_status" />
                        <data:VwUserPackageInfoExpressionBuilder BuilderExpression="AppendContains" Column="FirstName" OnApplyFilter="Name_ApplyFilter"/>
                    </Filters>
                </data:SqlParameter>
            </Parameters>
        </data:VwUserPackageInfoDataSource>

backend code:

protected void Name_ApplyFilter(object sender, HRASP.Web.Data.SqlFilterEventArgs<HRASP.Entities.VwUserPackageInfoColumn> e)
    {
        if (!String.IsNullOrWhiteSpace(txtName.Text.Trim()))
        {
            if (e.FilterBuilder.Length > 0)
            {
                e.FilterBuilder.BeginGroup();
                e.FilterBuilder.AppendContains("", HRASP.Entities.VwUserPackageInfoColumn.FirstName, txtName.Text);
                e.FilterBuilder.AppendContains("OR", HRASP.Entities.VwUserPackageInfoColumn.Surname, txtName.Text);
                e.FilterBuilder.AppendContains("OR", HRASP.Entities.VwUserPackageInfoColumn.Email, txtName.Text);
                e.FilterBuilder.EndGroup();
            }
            else
            {
                e.FilterBuilder.AppendContains(HRASP.Entities.VwUserPackageInfoColumn.FirstName, txtName.Text);
                e.FilterBuilder.AppendContains("OR", HRASP.Entities.VwUserPackageInfoColumn.Surname, txtName.Text);
                e.FilterBuilder.AppendContains("OR", HRASP.Entities.VwUserPackageInfoColumn.Email, txtName.Text);
            }
        }
    }

when use (), there are must some select parameter out side brackets, if there are no parameters out side, will cause error. so check e.filterBuilder. length > 0 or not.