Telerik raddatepicker根据所选日期和年份不过滤网格 [英] Telerik raddatepicker not filtering grid according to selected date and year

问题描述

我有Radgrid，其中我有一个名为'ModifiedOn'的名字，我正在使用两个Raddatepickers： - FromDate和ToDate。我需要根据从此列标题中选择的日期，月份和年份来过滤此RadGrid。每当我从FromDate或ToDate选择日期时，RadGrid tableView.filter（columnModifiedOn，fromDate ++ toDate，Between）;不会根据所选日期过滤网格，而是将这些选定日期视为字符串，并过滤网格直到日期和月份的基础，这不考虑年份（dd / MM不是dd / MM / yyyy）。



如果有人知道答案，请告诉我。



我尝试过：

I have Radgrid in which I've a cloumn name 'ModifiedOn' on which I'm using two Raddatepickers:- FromDate and ToDate. I need to filter this RadGrid on the basis of date, month and year selected from this column header. Whenever I select a date either from FromDate or ToDate, the RadGrid tableView.filter("columnModifiedOn", fromDate + " " + toDate, "Between"); doesn't filter the grid on the basis of selected dates, instead it treat these selected dates as strings and filter the grid til basic of date and month this was not consider the year (dd/MM not with dd/MM/yyyy).

Please let me know if anyone knows the answer.

What I have tried:

function FromDateSelected(sender, args) {
    var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
    var ToPicker = $find('<%# ((GridItem)Container).FindControl("ToOrderDatePicker").ClientID %>');

    var fromDate = FormatSelectedDate(sender);
    var toDate = FormatToSelectedDate(ToPicker);

    tableView.filter("columnModifiedOn", fromDate + " " + toDate, "Between");
}

function ToDateSelected(sender, args) {
    var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
    var FromPicker = $find('<%# ((GridItem)Container).FindControl("FromOrderDatePicker").ClientID %>');

    var fromDate = FormatSelectedDate(FromPicker);
    var toDate = FormatToSelectedDate(sender);

    tableView.filter("columnModifiedOn", fromDate + " " + toDate, "Between");
}

function FormatSelectedDate(picker) {
    var date = picker.get_selectedDate();
    var dateInput = picker.get_dateInput();
    var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());

    return formattedDate;
}

function FormatToSelectedDate(picker) {
    var date = picker.get_selectedDate();
    date.setDate(date.getDate() + 1);
    var dateInput = picker.get_dateInput();
    var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());

    return formattedDate;
}

推荐答案

find（ & lt;％＃（（GridItem）Container）.OwnerTableView.ClientID％>）;
var ToPicker =

find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); var ToPicker =

find（' < span class =code-string>& lt;％＃（（GridItem）Container）.FindControl（ToOrderDatePicker）。ClientID％>'）;

var fromDate = FormatSelectedDate（sender）;
var toDate = FormatToSelectedDate（ToPicker）;

tableView.filter（ columnModifiedOn，fromDate + + toDate， 之间）;
}

function ToDateSelected（sender，args）{
var tableView =

find('&lt;%# ((GridItem)Container).FindControl("ToOrderDatePicker").ClientID %>'); var fromDate = FormatSelectedDate(sender); var toDate = FormatToSelectedDate(ToPicker); tableView.filter("columnModifiedOn", fromDate + " " + toDate, "Between"); } function ToDateSelected(sender, args) { var tableView =

find（ & lt;％＃ （（GridItem）Container）.OwnerTableView.ClientID％>）;
var FromPicker =

find("&lt;%# ((GridItem)Container).OwnerTableView.ClientID %>"); var FromPicker =

这篇关于Telerik raddatepicker根据所选日期和年份不过滤网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！