时区问题在Asp中。NetMVC-C#-TimeZoneIssueinAsp.NetMVC

I am facing an issue in timezone. Right now I am saving time zone from client side and stored all DateTime in UTC. It's working properly but when I am trying to convert DateTime for UTC behind time zones like CST, EST, EDT it showing wrong data.

我正面临着一个时区问题。现在我从客户端保存时区，并将所有DateTime存储在UTC中。它工作正常，但是当我试图在CST、EST和EDT等时区之后转换UTC的DateTime时，它会显示错误的数据。

Issue - Let's assume if I did any task at 10 PM EDT and it would be saved in DB as 2 AM(as per UTC) but when I am trying to fetch data for a day and passing current UTC date.

让我们假设如果我在10 PM EDT上执行任何任务，它将在DB中被保存为2 AM(与UTC一样)，但是当我试图获取一天的数据并通过当前UTC日期时。

My question is If am trying to fetch data for a day like 11 midnight( from EST) to the current time, but my conversion from UTC to EST is wrong due to UTC 12midnight is yesterday's 8 PM(as EDT 4hr behind from UTC). (From Date[UTC convert to EDT] - 06/07/2017 08:00pm) and To Date - 06/07/2017 11:00 pm) Due to this conversion I am getting data from 8 pm to 11 pm only <- I am expecting from date is 06/07/2017 04:00 AM as per UTC.

我的问题是，我是否试图获取一天的数据，比如从东部时间午夜11点(从东部时间)到现在的时间，但是我从东部时间12点转换到东部时间是错误的，因为东部时间是昨天晚上8点(东部时间4小时)。(从日期[UTC转换为EDT] - 06/07/2017 08:00pm)到日期- 06/07/2017 11:00 pm)由于此转换，我只收到从晚上8点到晚上11点的数据<-我预计从日期开始的日期是:06/07/2017 04:00 am。

Code - Below is the code for conversion. In from date I have taken utcnow.date only and from a date

代码-下面是转换的代码。从现在开始，我一直在使用utc。只有日期和日期

Javascript code -

Javascript代码,

function setTimezoneCOOKIE() {
            try {
                var timezone_COOKIE = "timezoneoffset";
                var timeZOneName= "timezonename"

                var tz = jstz.determine();
                var aa = tz.name();
                // if the timezone COOKIE not exists create one.

                if (!$.COOKIE(timezone_COOKIE)) {
                    // create a new COOKIE
                    $.COOKIE(timezone_COOKIE, new Date().getTimezoneOffset());
                    $.COOKIE(timeZoneName, aa);
                }
                else {
                    var storedOffset = parseInt($.COOKIE(timezone_COOKIE));
                    var currentOffset = new Date().getTimezoneOffset();
                    if (storedOffset !== currentOffset) {
                        $.COOKIE(timezone_COOKIE, new Date().getTimezoneOffset());
                        $.COOKIE(timeZoneName, aa);
                        location.reload();
                    }
                    else {
                        $.COOKIE(timeZoneName, aa);
                    }
                }
            }

c# code -

c#代码,

 fromDate =Convert.ToDateTime(fromDate).ToClientTimeZoneinDateTime().ToString();  
                toDate = Convert.ToDateTime(toDate).ToClientTimeZoneinDateTime().ToString();

                ObjectParameter totalRecords = new ObjectParameter("TotalRecords", typeof(int));
                var DetailsList = objDetailsList.GetDetails(loginUserId,locationId, userId, taskType, pageIndex, numberOfRows, sortColumnName, sortOrderBy, textSearch, totalRecords, fromDate, toDate);
                if (DetailsList.Count() > 0)
                {
                    string output = BuildJQGridResults(DetailsList, numberOfRows, pageIndex, Convert.ToInt32(totalRecords.Value));
                    response.Write(output);
                }
                else
                {
                    JQGridResults result = new JQGridResults();
                    List rows = new List();
                    result.rows = rows.ToArray();
                    result.page = 0;
                    result.total = 0;
                    result.records = 0;
                    response.Write(new JavascriptSerializer().Serialize(result));
                }

Below is the method of converting UTC time to client timezone

下面是将UTC时间转换为客户端时区的方法

public static DateTime ToClientTimeZoneinDateTime(this DateTime dt)
{
    try {               
        if (System.Web.HttpContext.Current.Request.COOKIEs["timezoneoffset"] != null || System.Web.HttpContext.Current.Request.COOKIEs["timezonename"] != null)
        {                  
            var timezOnename= System.Web.HttpContext.Current.Request.COOKIEs["timezonename"].Value;
            timezOnename= timezonename.Replace("%2F", "/");
            var timezoneLocal1 = FindTimezoneName(timezonename);
            TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(timezoneLocal1);
            bool isCurrentlyDaylightSavings = tzi.IsDaylightSavingTime(dt);
            if (isCurrentlyDaylightSavings == true)
                dt.AddHours(1);

            var timeOffSet = System.Web.HttpContext.Current.Request.COOKIEs["timezoneoffset"].Value;

            var offset = int.Parse(timeOffSet.ToString());
            dt = dt.AddMinutes(-1 * offset);                  
            return dt;
        }             
        return dt.ToLocalTime();
    }
    catch (Exception)
    {
        return DateTime.UtcNow;
    }
}

No doubt as Timezone handled properly but facing an issue for behind timezone from UTC if end user trying to fetch data after 8 PM EDT. I have attached screenshot as well.

毫无疑问，时区处理得很好，但是如果最终用户试图在东部时间晚上8点以后获取数据，那么就会面临来自UTC的时区后面的问题。我也附上了截图。

Below img of before conversion -

低于img之前的转换-

Above img of after conversion -

以上img的后转换-

How do I need to handle this situation?

我该如何处理这种情况?

1 个解决方案

public static DateTime FromTimeZoneToUtc(this DateTime dt, string timeZone)
{
    var windowsId = TimeZoneConverter.TZConvert.IanaToWindows(timeZone);
    var tzi = TimeZoneInfo.FindSystemTimeZoneById(windowsId);
    return TimeZoneInfo.ConvertTimeFromUtc(dt, tzi);
}

public static DateTime FromTimeZoneToUtc(this DateTime dt, string timeZone)
{
    var tz = DateTimeZoneProviders.Tzdb[timeZone];
    var local = LocalDateTime.FromDateTime(dt);
    return local.InZoneLeniently(tz).ToDateTimeUtc();
}