asp.net – 在实体框架中使用PersianCalendar作为表列的正确方法

您的模型应将出生日期存储为正常的DateTime,然后您可以使用PersianCalendar来操作它.简单(但有点难看)的方法是使用DateTime字段和单独的公共字符串属性来获取和设置由波斯日历格式化的日期：

public class Person
{
    PersianCalendar p = new PersianCalendar();
    public Person()
    {

    }
    public Person(string firstName,DateTime birthDate)
    {
        FirstName = firstName;
        LastName = lastName;
        DateOfBirth = birthDate;
    }
    public Person(string firstName,string birthDateString)
    {
        FirstName = firstName;
        LastName = lastName;
        DateOfBirthString = birthDateString;
    }

    public int PersonId { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }

    public DateTime DateOfBirth;
    public string DateOfBirthString
    {
        get
        {
            return string.Format("{0}/{1}/{2}",p.GetYear(DateOfBirth),p.GetMonth(DateOfBirth),p.GetDayOfMonth(DateOfBirth));
        }
        set
        {
            var parts = value.Split('/');
            DateOfBirth = p.ToDateTime(int.Parse(parts[0]),int.Parse(parts[1]),int.Parse(parts[2]),0);
        }
    }
}

请记住,DateTime代表一般特定时刻.它没有任何唯一正确的字符串表示形式.但是如果你使用上面的内容,那么你就可以决定对你的应用程序唯一正确的字符串表示是一个波斯日期,格式为yyyy / MM / dd.

编辑：您还可以创建自定义JSON JsonConverter并在模型中使用它.您的POCO模型可能如下所示：

public class Person
{
    public Person() { }
    public Person(string firstName,DateTime birthDate)
    {
        FirstName = firstName;
        LastName = lastName;
        DateOfBirth = birthDate;
    }
    public int PersonId { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }

    [JsonConverter(typeof(PersianDateConverter))]
    public DateTime DateOfBirth;
}

PersianDateConverter类看起来像这样：

public class PersianDateConverter : JsonConverter
{
    PersianCalendar pc = new PersianCalendar();
    public PersianDateConverter()
    {

    }
    public override object ReadJson(JsonReader reader,Type objectType,object existingValue,JsonSerializer serializer)
    {
        string persianDateString = reader.Value as string;
        if (persianDateString == null)
            throw new ArgumentException("Error in PersionDateConverter.ReadJson: Got null string");

        var parts = persianDateString.Split('/');
        return pc.ToDateTime(int.Parse(parts[0]),0);
    }
    public override void WriteJson(JsonWriter writer,object value,JsonSerializer serializer)
    {
        DateTime d = (DateTime)value;
        string output = string.Format("{0}/{1}/{2}",pc.GetYear(d),pc.GetMonth(d),pc.GetDayOfMonth(d));
        writer.WriteValue(output);
    }
    public override bool CanConvert(Type objectType)
    {
        if (objectType.Name == "DateTime")
            return true;
        return false;
    }
}

注意：此PersianDateConverter未针对边缘情况进行良好测试.只要它操作的数据有效,似乎工作正常.