C#插件、Python两种方式计算日期是当年第几周

C#插件、Python两种方式计算日期是当年第几周原创

湖南吴双得

28人赞赏了该文章 427次浏览编辑于2023年11月01日 11:39:31

借助系统日历计算指定日期是当年第几周

C#插件

private void CalcCurWeek()
        {
            DateTime curDate = Convert.ToDateTime(this.View.Model.GetValue("FWeekBDate"));

            if (curDate != null)
            {
                System.Globalization.GregorianCalendar gc = new System.Globalization.GregorianCalendar();

                int weekOfYear = gc.GetWeekOfYear(curDate, System.Globalization.CalendarWeekRule.FirstDay, DayOfWeek.Monday);

                this.View.Model.SetValue("FCurWeek", weekOfYear);
            }
        }

Python代码（亲测有效）

import clr
clr.AddReference('System')
clr.AddReference('System.Globalization')
from System import *
from System.Globalization import *

def DataChanged(e):
    key = e.Field.Key.upper();
    if(key == "FWEEKBDATE"):
        curDate = this.View.Model.GetValue("FWeekBDate");
        if (curDate <> None):
            gc = GregorianCalendar();
            weekOfYear = gc.GetWeekOfYear(curDate, CalendarWeekRule.FirstDay, DayOfWeek.Monday);
            this.View.Model.SetValue("FCurWeek",weekOfYear);