//关于时间的条件转化
DateTime dt = DateTime.Now; //当前时间
DateTime startToday = dt.AddHours(-dt.Hour).AddMinutes(-dt.Minute).AddSeconds(-dt.Second).AddMilliseconds(-dt.Millisecond); //今天开始
DateTime endToday = startToday.AddHours(23).AddMinutes(59).AddSeconds(59);//今天结束。
DateTime startYestody = startToday.AddDays(-1);//昨天开始
DateTime endYestoday = endToday.AddDays(-1);//昨天结束.
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一
startWeek = startWeek.AddHours(-startWeek.Hour);
startWeek = startWeek.AddMinutes(-startWeek.Minute);
startWeek = startWeek.AddSeconds(-startWeek.Second);
DateTime endWeek = startWeek.AddDays(6); //本周周日
endWeek = endWeek.AddHours(23);
endWeek = endWeek.AddMinutes(59);
endWeek = endWeek.AddSeconds(59);
DateTime ShangZhouStarWeek = startWeek.AddDays(-7);//上周周一
DateTime ShangZhouEndWeek = endWeek.AddDays(-7);//上周周日
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
startMonth = startMonth.AddHours(-startMonth.Hour);
startMonth = startMonth.AddMinutes(-startMonth.Minute);
startMonth = startMonth.AddSeconds(-startMonth.Second);
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末
endMonth = endMonth.AddHours(23);
endMonth = endMonth.AddMinutes(59);
endMonth = endMonth.AddSeconds(59);
DateTime ShangYueStarMonth = startMonth.AddMonths(-1); //上月月初
DateTime ShangYueEndMonth = endMonth.AddMonths(-1);//上月月初
//DateTime endMonth = startMonth.AddDays((dt.AddMonths(1) - dt).Days - 1); //本月月末
//DateTime startQuarter = dt.AddMonths(0 - (dt.Month - 1) % 3).AddDays(1 - dt.Day); //本季度初
//DateTime endQuarter = startQuarter.AddMonths(3).AddDays(-1); //本季度末
// DateTime startYear = new DateTime(dt.Year, 1, 1); //本年年初
// DateTime endYear = new DateTime(dt.Year, 12, 31); //本年年末