判断日期是否是工作日(sqlserver),判断一个月中有多少工作日(C#)
判断日期是否是工作日(sqlserver),判断一个月中有多少工作日(C#)
print (datepart(weekday, '2017-04-24') + 5) % 7
print (datepart(weekday, '2017-04-26') + 5) % 7
print (datepart(weekday, '2017-04-30') + 5) % 7
--周一到周日 0-6
public static int GetWeekdayNum(DateTime dt) {
dt = new DateTime(dt.Year, dt.Month, 1);
var monthDays = dt.Subtract(dt.AddMonths(1));
int num = 0;
for(int i = 1; i <= Math.Abs(monthDays.TotalDays) - 28; i++) {
var dtTemp = new DateTime(dt.Year, dt.Month, 28 + i);
if(dtTemp.DayOfWeek != DayOfWeek.Saturday && dtTemp.DayOfWeek != DayOfWeek.Sunday) {
num++;
}
}
return 20 + num;
}
Updated: 2020-12-20 11:17
Created: 2017-04-26 01:33