nettier datasource 1

来源：互联网发布：软件测试好吗编辑：程序博客网时间：2024/05/01 21:40

<data:TaxationAuthorityInfoDataSource runat="server" ID="SummaryDS"        SelectMethod="GetPaged">        <Parameters>            <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">                <Filters>                    <data:TaxationAuthorityInfoExpressionBuilder Column="DatePlaced" BuilderExpression="AppendRange">                        <Parameters>                            <asp:ControlParameter Name="From" ControlID="__Page" PropertyName="FilterDateFrom" DefaultValue="01/01/2200" />                            <asp:ControlParameter Name="To" ControlID="__Page" PropertyName="FilterDateTo" DefaultValue="01/01/1990" />                        </Parameters>                    </data:TaxationAuthorityInfoExpressionBuilder>                    <data:TaxationAuthorityInfoExpressionBuilder Column="CurrencyCode" ControlID="ddlCurrency"                        BuilderExpression="AppendLike" />                    <data:TaxationAuthorityInfoExpressionBuilder Column="TaxAuthorityId" ControlID="ddlTaxAuthority"                        BuilderExpression="AppendEquals" />                    <data:TaxationAuthorityInfoExpressionBuilder Column="TicketStateId" ControlID="ddl_State"                        BuilderExpression="AppendEquals" />                    </Filters>            </data:SqlParameter>        </Parameters>    </data:TaxationAuthorityInfoDataSource>

NOTE: property must return string, must give a format of date string.

public string FilterDateTo    {        get        {            if (dtmTo.SelectedDate.HasValue)            {                var d = dtmTo.SelectedDate.Value.AddDays(1).AddSeconds(-1).ToString("yyyyMMdd HH:mm:ss");                return d;            }            else                return DateTime.Now.AddMonths(1).ToString("yyyyMMdd HH:mm");        }    }    public string FilterDateFrom    {        get        {            if (dtmFrom.SelectedDate.HasValue)            {                var d = dtmFrom.SelectedDate.Value.ToString("yyyyMMdd HH:mm");                return d;            }            else                return DateTime.Now.AddMonths(-1000).ToString("yyyyMMdd HH:mm");        }    }