Jqgrid datefield根据时区选择日期和时间 [英] Jqgrid datefield chnaging the date and time as per timezone

问题描述

你好，



我正在使用jqgrid来显示我的记录。下面是我跟踪实现的链接。

Hi there ,

I am using jqgrid to display my records.Below is link from which I have followed the implemnetation.

Jqgrid documentation version link 
http://versions.gijgo.com/0_4/Documentation/Grid

但现在的问题是，根据时区，我的日期和时间显示不同。我希望用户在我保存的时间显示确切的值。



我尝试过的事情：

But now the problem is that , as per timezone my date and timings are getting displayed differntly . I want user to display exact value at what time I have save.

What I have tried:

function ReportedCallLoadData() {
    grid = $("#grid").grid({
        dataKey: "ID",
        uiLibrary: "bootstrap",
        columns: [
            { field: "ClientName", title: "Client Name", sortable: true },
            { field: "StartTime", title: "Start Time", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' },
            { field: "EndTime", title: "End Time", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' },
            { field: "ActualDate", title: "Actual Date", sortable: true, type: 'date', format: 'dd/mm/yyyy' },
            { field: "CreatedOn", title: "Created On", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' },
            { title: "", field: "Edit", width: 34, type: "icon", icon: "glyphicon-pencil", tooltip: "Edit", events: { "click": Edit } },
            { title: "", field: "Delete", width: 34, type: "icon", icon: "glyphicon-remove", tooltip: "Delete", events: { "click": DisplayDeleteCommentsBox } }
        ],
        pager: { enable: true, limit: 5, sizes: [2, 5, 10, 20] }
    });
}

[HttpGet]
       [Authorize]
       public JsonResult GetCallDetails(int? page, int? limit, string sortBy, string direction,
           string mrID, string date, string isChemist, string searchString = null)
       {
           date = string.IsNullOrEmpty(date) ? DateTime.Now.Date.ToString("dd/MM/yyyy") : date;
           var actualFilterDate = DateTime.ParseExact(date, "dd/MM/yyyy", null);

           FilterBO objFilter = new FilterBO()
           {
               Page = page,
               Limit = limit,
               SortBY = sortBy,
               Direction = direction,
               SearchString = searchString,
               UserId = !string.IsNullOrEmpty(mrID) ? Convert.ToInt32(mrID) : 0,
               IsChemist = Convert.ToBoolean(isChemist),
               ActualDate = actualFilterDate,
           };

           int total = 0;

           if (objFilter.IsChemist)
           {
               objChemistCalls = new ChemistCallRepository();
               var records = objChemistCalls.GetCallDetails(objFilter, out total);
               ViewBag.Header = "Reported Call Details";
               return Json(new { records, total }, JsonRequestBehavior.AllowGet);
           }
           else
           {
               objCalls = new CallsRepository();
               var records = objCalls.GetCallDetails(objFilter, out total);
               ViewBag.Header = "Reported Chemist Call Details";
               return Json(new { records, total }, JsonRequestBehavior.AllowGet);
           };
       }

推荐答案

（＃grid）。grid（{
dataKey：ID，
uiLibrary：bootstrap，
列：[
{字段：ClientName，标题：客户名称，可排序：true}，
{字段：StartTime， title：Start Time，sortable：true，type：'date'，format：'dd / mm / yyyy hh：MM TT'}，
{field：EndTime，title：End Time， sortable：true，type：'date'，format：'dd / mm / yyyy hh：MM TT'}，
{field：ActualDate，title：Actual Date，sortable：true，type：' date'，format：'dd / mm / yyyy'}，
{field：CreatedOn，title：Created On，sortable：true，type：'date'，format：'dd / mm / yyyy hh：MM TT'}，
{title：，字段：编辑，宽度：34，类型：icon，图标：glyphicon-pencil，工具提示：编辑，事件：{ click：Edit}}，
{title：，field：Delete，width：34，type：icon，icon：glyphico n-remove，工具提示：删除，事件：{点击：DisplayDeleteCommentsBox}}
]，
pager：{enable：true，limit：5，sizes：[2,5,10 ，20]}
}）;
}

("#grid").grid({ dataKey: "ID", uiLibrary: "bootstrap", columns: [ { field: "ClientName", title: "Client Name", sortable: true }, { field: "StartTime", title: "Start Time", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' }, { field: "EndTime", title: "End Time", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' }, { field: "ActualDate", title: "Actual Date", sortable: true, type: 'date', format: 'dd/mm/yyyy' }, { field: "CreatedOn", title: "Created On", sortable: true, type: 'date', format: 'dd/mm/yyyy hh:MM TT' }, { title: "", field: "Edit", width: 34, type: "icon", icon: "glyphicon-pencil", tooltip: "Edit", events: { "click": Edit } }, { title: "", field: "Delete", width: 34, type: "icon", icon: "glyphicon-remove", tooltip: "Delete", events: { "click": DisplayDeleteCommentsBox } } ], pager: { enable: true, limit: 5, sizes: [2, 5, 10, 20] } }); }

[HttpGet]
       [Authorize]
       public JsonResult GetCallDetails(int? page, int? limit, string sortBy, string direction,
           string mrID, string date, string isChemist, string searchString = null)
       {
           date = string.IsNullOrEmpty(date) ? DateTime.Now.Date.ToString("dd/MM/yyyy") : date;
           var actualFilterDate = DateTime.ParseExact(date, "dd/MM/yyyy", null);

           FilterBO objFilter = new FilterBO()
           {
               Page = page,
               Limit = limit,
               SortBY = sortBy,
               Direction = direction,
               SearchString = searchString,
               UserId = !string.IsNullOrEmpty(mrID) ? Convert.ToInt32(mrID) : 0,
               IsChemist = Convert.ToBoolean(isChemist),
               ActualDate = actualFilterDate,
           };

           int total = 0;

           if (objFilter.IsChemist)
           {
               objChemistCalls = new ChemistCallRepository();
               var records = objChemistCalls.GetCallDetails(objFilter, out total);
               ViewBag.Header = "Reported Call Details";
               return Json(new { records, total }, JsonRequestBehavior.AllowGet);
           }
           else
           {
               objCalls = new CallsRepository();
               var records = objCalls.GetCallDetails(objFilter, out total);
               ViewBag.Header = "Reported Chemist Call Details";
               return Json(new { records, total }, JsonRequestBehavior.AllowGet);
           };
       }

这篇关于Jqgrid datefield根据时区选择日期和时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！