首页 文章

使用自定义文化存储dateTime

提问于
浏览
1

我在asp.net MVC中有一个页面,它在波斯语中获取日期时间并将其存储在圣诞节datetime中的数据库中 . 我将我的文化改为波斯语以便用波斯语显示日期和时间,一切正常,我可以存储日期时间与DateTime.Now在数据库中,但是当我想从文本框中的用户获取日期时间(用户输入带有波斯日期时间)并存储它时,我得到一个超出范围的错误说

将datetime2数据类型转换为日期时间数据类型会导致超出范围的值

我试图从FormCollection对象获取datetime值并将其转换为datetime但我没有运气,

这是我的观点:

<form action="/Accounting/TempDocument/Insert" method="post" id="insert-form">
    <div class="modal-body">
        <div class="row">
        <div class="form-body">
            @Html.AntiForgeryToken()
            <div class="form-group form-md-line-input">
                @Html.LabelFor(m => m.Description, new { @class = "col-md-2 control-label" })
                <div class="col-md-10">
                    @Html.TextAreaFor(m => m.Description, new { @class = "form-control", @placeholder = "Description" })
                    <div class="form-control-focus"> </div>
                    @Html.ValidationMessageFor(m => m.Description, "", new { @class = "help-block" })
                </div>
            </div>
            <div class="form-group form-md-line-input">
                @Html.LabelFor(m => m.DocumentDate, new { @class = "col-md-2 control-label" })

<!-- this block is for document date-->
                <div class="col-md-10">
                    @Html.TextBoxFor(m => m.DocumentDate, new { @class = "form-control date-mask", @placeholder = "Document Date" })
                    <div class="form-control-focus"> </div>
                    @Html.ValidationMessageFor(m => m.DocumentDate, "", new { @class = "help-block" })
                </div>
            </div>
        </div>
<!-- my form continues -->

这是我的行动:

[Route("Insert")]
    [HttpPost]
    public async Task<ActionResult> InsertAsync(AccountingDocument model, FormCollection collection)
    {
        try
        {

          // much code here
            await _service.EntInsertAsync(model);
            if (await _service.CommitAsync())
                await SetResultMessageAsync("");
        }
        catch
        {

        }
        return RedirectToAction("RenderTop");
    }

我的global.asax类:

protected void Application_BeginRequest()
    {

        var persianCulture = new PersianCulture();
        Thread.CurrentThread.CurrentCulture = persianCulture;
        Thread.CurrentThread.CurrentUICulture = persianCulture;

    }

最后我的persianCulture类:

public class PersianCulture : CultureInfo
{
    private readonly Calendar cal;
    private readonly Calendar[] optionals;


    public PersianCulture()
        : this("fa-IR", true)
    {
    }

    public PersianCulture(string cultureName, bool useUserOverride)
        : base(cultureName, useUserOverride)
    {
        //Temporary Value for cal.
        cal = base.OptionalCalendars[0];

        //populating new list of optional calendars.
        var optionalCalendars = new List<Calendar>();
        optionalCalendars.AddRange(base.OptionalCalendars);
        optionalCalendars.Insert(0, new PersianCalendar());


        Type formatType = typeof(DateTimeFormatInfo);
        Type calendarType = typeof(Calendar);


        PropertyInfo idProperty = calendarType.GetProperty("ID", BindingFlags.Instance | BindingFlags.NonPublic);
        FieldInfo optionalCalendarfield = formatType.GetField("optionalCalendars",
                                                              BindingFlags.Instance | BindingFlags.NonPublic);

        //populating new list of optional calendar ids
        var newOptionalCalendarIDs = new Int32[optionalCalendars.Count];
        for (int i = 0; i < newOptionalCalendarIDs.Length; i++)
            newOptionalCalendarIDs[i] = (Int32)idProperty.GetValue(optionalCalendars[i], null);

        optionalCalendarfield.SetValue(DateTimeFormat, newOptionalCalendarIDs);

        optionals = optionalCalendars.ToArray();
        cal = optionals[0];
        DateTimeFormat.Calendar = optionals[0];

        DateTimeFormat.MonthNames = new[] { "فروردین", "اردیبهشت", "خرداد", "تیر", "مرداد", "شهریور", "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "" };
        DateTimeFormat.MonthGenitiveNames = new[] { "فروردین", "اردیبهشت", "خرداد", "تیر", "مرداد", "شهریور", "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "" };
        DateTimeFormat.AbbreviatedMonthNames = new[] { "فروردین", "اردیبهشت", "خرداد", "تیر", "مرداد", "شهریور", "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "" };
        DateTimeFormat.AbbreviatedMonthGenitiveNames = new[] { "فروردین", "اردیبهشت", "خرداد", "تیر", "مرداد", "شهریور", "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "" };


        DateTimeFormat.AbbreviatedDayNames = new string[] { "ی", "د", "س", "چ", "پ", "ج", "ش" };
        DateTimeFormat.ShortestDayNames = new string[] { "ی", "د", "س", "چ", "پ", "ج", "ش" };
        DateTimeFormat.DayNames = new string[] { "یکشنبه", "دوشنبه", "ﺳﻪشنبه", "چهارشنبه", "پنجشنبه", "جمعه", "شنبه" };

        DateTimeFormat.AMDesignator = "ق.ظ";
        DateTimeFormat.PMDesignator = "ب.ظ";
    }

    public override Calendar Calendar
    {
        get { return cal; }
    }

    public override Calendar[] OptionalCalendars
    {
        get { return optionals; }
    }
}

2 回答

  • 0

    我假设用户进入伊斯兰时代的年份(当年是1438 AH) .

    然后在数据库上发生错误 The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value ,因为您的datetime列使用 datetime 类型而不是 datetime2 .

    datetime T-SQL数据类型仅支持1753-01-01到9999-12-31范围内的日期 .

    将数据库上的数据类型更改为 datetime2 ,它支持日期0001-01-01 00:00:00.0000000至9999-12-31 23:59:59.9999999 .

  • 0

    由于用户可能在Hijri日历中输入日期,因此它的年份值可能小于SQL datetime 支持(1753-01-01) . 请注意,默认情况下,无论是否设置了文化,Gregorian系统都会在 datetimedatetime2 数据类型中使用 .

    有一些可能的解决方案:

    • 将数据库中映射列 DocumentDate 的数据类型更改为datetime2,它支持 DateTime.MinValue 的最小值 .

    • 如果您将 SqlCommand 与参数化查询一起使用,则可以在 Parameters.AddParameters.AddWithValue 中将 SqlDbType.DateTime2 定义为DB数据类型 .

    • 如果您在EDMX中使用EF,则可以通过将相应的列映射更新为 DateTime2 来定义属性 DocumentDate .

相关问题