获取时间段内的工作日时间(除去周末)

   /// <summary>
        /// Get business day which exclude weekend
        /// </summary>
        /// <param name="beginDay"></param>
        /// <param name="endDay"></param>
        /// <returns></returns>
        public string GetWorkDayCount(DateTime beginDay, DateTime endDay)
        {
            //set creat day and end day as business day.
            if (beginDay.DayOfWeek == DayOfWeek.Saturday)
                beginDay = beginDay.AddDays(2);
            if (beginDay.DayOfWeek == DayOfWeek.Sunday)
                beginDay = beginDay.AddDays(1);
            if (endDay.DayOfWeek == DayOfWeek.Saturday)
                endDay = endDay.AddDays(2);
            if (endDay.DayOfWeek == DayOfWeek.Sunday)
                endDay = endDay.AddDays(1);

            //get days between create day and end day
            var allDays = Convert.ToDecimal(ExecDateDiff(beginDay, endDay, 1)) + 1;

            //get weekend days between create day and end day
            var weekendDays = Convert.ToDecimal(ExecDateDiff(GetFirstDayOfWeek(beginDay), GetFirstDayOfWeek(endDay), 1)) / 7 * 2;

            //get work day
            var workDay = allDays - weekendDays;

            return workDay.ToString();
        }

        /// <summary>
        /// Calculate the time span
        /// </summary>
        /// <param name="dateBegin"></param>
        /// <param name="dateEnd"></param>
        /// <returns></returns>
        public string ExecDateDiff(DateTime dateBegin, DateTime dateEnd, int timeType)
        {
            TimeSpan ts1 = new TimeSpan(dateBegin.Ticks);
            TimeSpan ts2 = new TimeSpan(dateEnd.Ticks);
            TimeSpan ts3 = ts1.Subtract(ts2).Duration();
            string result = string.Empty;
            switch (timeType)
            {
                case 1:
                    result = ts3.TotalDays.ToString();
                    break;
                case 2:
                    result = ts3.TotalHours.ToString();
                    break;
                case 3:
                    result = ts3.TotalMinutes.ToString();
                    break;
                case 4:
                    result = ts3.TotalSeconds.ToString();
                    break;
            }
            return result;
        }

        /// <summary>
        /// Get first day of the week
        /// </summary>
        /// <param name="time"></param>
        /// <returns></returns>
        public DateTime GetFirstDayOfWeek(DateTime time)
        {
            int i = time.DayOfWeek - DayOfWeek.Monday;
            if (i == -1) i = 6;
            TimeSpan ts = new TimeSpan(i, 0, 0, 0);
            return time.Subtract(ts);
        }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值