C#后端111

1.计算有关工作日的方法

//判断是不是工作日
        //<params dataTable>对应日历的子表</params>
        //<params date>日期</params>
        public bool IsWorkingDate(DataTable dtFindCan, DateTime date)
        {
            int dateTime= Convert.ToInt32(date.ToString("yyyyMMdd"));
            string week = date.ToString("dddd", CultureInfo.InvariantCulture);



            DataRow[] drFindCan = dtFindCan.Select("wrkhr_date = '"+dateTime+"'");

            bool flag;

            if (drFindCan.Length > 0)
            {
                if (drFindCan[0]["wrkhr_hour"].ToString() == "65280")
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            else
            {
                if(week== "Saturday" || week == "Sunday")
                {
                    flag = false;
                }
                else
                {
                    flag = true;
                }
            }

            return flag;
        }
        //获取工作日的结束日期
        //<params dataTable>对应日历的子表</params>
        //<params star>开始时间</params>
        //<params workingDays>工作日天数</params>
        public DateTime GetFinish(DataTable dataTable, DateTime start, int workingDays)
        {
            bool flag = workingDays <= 0;
            DateTime result;
            if (flag)
            {
                result = new DateTime(start.Ticks);
            }
            else
            {
                DateTime date = new DateTime(start.Year, start.Month, start.Day);
                while (workingDays > 0)
                {
                    bool flag2 = this.IsWorkingDate(dataTable,date);
                    if (flag2)
                    {
                        workingDays--;
                        bool flag3 = workingDays == 0;
                        if (flag3)
                        {
                            break;
                        }
                    }
                    date = date.AddDays(1.0);
                }
                result = new DateTime(date.Year, date.Month, date.Day, 23, 23, 59);
            }
            return result;
        }

        //获取工作日的开始日期
        //<params dataTable>对应日历的子表</params>
        //<params finish>结束时间</params>
        //<params workingDays>工作日天数</params>
        public DateTime GetStart(DataTable dataTable,DateTime finish, int workingDays)
        {
            bool flag = workingDays <= 0;
            DateTime result;
            if (flag)
            {
                result = new DateTime(finish.Ticks);
            }
            else
            {
                DateTime dateTime = new DateTime(finish.Year, finish.Month, finish.Day);
                while (workingDays > 0)
                {
                    bool flag2 = this.IsWorkingDate(dataTable,dateTime);
                    if (flag2)
                    {
                        workingDays--;
                        bool flag3 = workingDays == 0;
                        if (flag3)
                        {
                            return dateTime;
                        }
                    }
                    dateTime = dateTime.AddDays(-1.0);
                }
                result = dateTime;
            }
            return result;
        }

日历的设置格式

 

2.cron表达式

 *  *     *   *   *    ?      *
秒 分种 小时  日 月份 周(星期) 年

例如：0 0,30 1,8 * 7,8 3,4,5 *
表示 7，8月份的周三周四周五的1点和8点的0分和30分的0秒