nettier datasouce-CSDN博客

本文链接：https://blog.csdn.net/zexu82/article/details/8506756

<data:LotteryDrawDataSource runat="server" ID="DrawDS" SelectMethod="GetPaged">
    <Parameters>
        <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false" DefaultValue="1=0">
            <Filters>
                <%--<data:LotteryDrawFilter Column="id" DefaultValue="2" />--%>
                <%--<data:LotteryDrawFilter Column="DrawDate" DefaultValue='<%= DateTime.Now.ToString() %>' />--%>
                <%--<data:LotteryDrawExpressionBuilder  BuilderExpression="AppendGreaterThan" Column="DrawDate" DefaultValue='<%= Eval(DateTime.Now) %>' />--%>

                <data:LotteryDrawFilter Column="DrawDate" OnApplyFilter="DrawDate_ApplyFilter" />
                <data:LotteryDrawFilter Column="LotteryId" PropertyName="Value" ControlID="hdnLotteryId" FilterType="Phrase" />

               <%-- <data:LotteryDrawFilter Column="LotteryId" OnApplyFilter="LotteryId_ApplyFilter"/>--%>
            </Filters>
        </data:SqlParameter>
        <data:CustomParameter Name="OrderBy" Value="draw_date asc" />
    </Parameters>
</data:LotteryDrawDataSource>

back end code for the event OnApplyFilter="DrawDate_ApplyFilter"

    protected void DrawDate_ApplyFilter(object sender, SqlFilterEventArgs<LotteryDrawColumn> e)
    {
        e.FilterBuilder.AppendGreaterThan(e.Column, SystemSettingsManager.GetNow().ToString(CultureInfo.CurrentUICulture));
    }