C#根据当前时间确定日期范围(本周、本月、本季度、本年度及常见日期方法荟萃
DateTime dt = DateTime.Now; //当前时间
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一
DateTime endWeek = startWeek.AddDays(6); //本周周日
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-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); //本年年末
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一
DateTime endWeek = startWeek.AddDays(6); //本周周日
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-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); //本年年末
昨天、明天、上周、上月、上季度、上年度等等,只要AddDays()、AddMonths()、AddYears()这几种方法组合
一.如何获得当月有多少天
int m=System.DateTime.DaysInMonth(System.DateTime.Now.Year,System.DateTime.Now.Month);
二.日期型格式处理通用方法1.在webconfig中配置如下
<add key="ShortDatePattern" value="MM-dd-yyyy" />
<add key="LongDatePattern" value="dddd-MMMM dd-yyyy" />
<add key="ShortTimePattern" value="hh:mm tt" />
<add key="LongTimePattern" value="hh:mm tt" />
2.在global.asax中<add key="LongDatePattern" value="dddd-MMMM dd-yyyy" />
<add key="ShortTimePattern" value="hh:mm tt" />
<add key="LongTimePattern" value="hh:mm tt" />
protected void Application_BeginRequest(Object sender, EventArgs e)
{
Thread currentThread = Thread.CurrentThread;
CultureInfo cul = currentThread.CurrentCulture.Clone() as CultureInfo;
cul.DateTimeFormat.ShortDatePattern= BLLFacade.Common.GetShortDatePattern();
cul.DateTimeFormat.LongDatePattern= BLLFacade.Common.GetLongDatePattern();
cul.DateTimeFormat.ShortTimePattern= BLLFacade.Common.GetShortTimePattern();
cul.DateTimeFormat.LongTimePattern= BLLFacade.Common.GetLongTimePattern();
currentThread.CurrentCulture = cul;
}
3.在业务逻辑层中{
Thread currentThread = Thread.CurrentThread;
CultureInfo cul = currentThread.CurrentCulture.Clone() as CultureInfo;
cul.DateTimeFormat.ShortDatePattern= BLLFacade.Common.GetShortDatePattern();
cul.DateTimeFormat.LongDatePattern= BLLFacade.Common.GetLongDatePattern();
cul.DateTimeFormat.ShortTimePattern= BLLFacade.Common.GetShortTimePattern();
cul.DateTimeFormat.LongTimePattern= BLLFacade.Common.GetLongTimePattern();
currentThread.CurrentCulture = cul;
}
public static string GetShortDatePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["ShortDatePattern"];
}
public static string GetLongDatePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["LongDatePattern"];
}
public static string GetShortTimePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["ShortTimePattern"];
}
public static string GetLongTimePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["LongTimePattern"];
}
4.然后在其他地方正常调用就可以了,如果需要修改格式只需要修改webconfig中的,且可以保证整个系统中的所有格式都是一致的 {
return System.Configuration.ConfigurationSettings.AppSettings["ShortDatePattern"];
}
public static string GetLongDatePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["LongDatePattern"];
}
public static string GetShortTimePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["ShortTimePattern"];
}
public static string GetLongTimePattern()
{
return System.Configuration.ConfigurationSettings.AppSettings["LongTimePattern"];
}
三.在asp.net中怎么样计算两个日期相差的年、月份、日期、小时、分钟 、妙等
#region 在asp.net中怎么样计算两个日期相差的年、月份、日期、小时、分钟 、妙等
// 调用
// DateTime a=Convert.ToDateTime("2005-09-03 20:15");
// DateTime b=Convert.ToDateTime("2005-09-04 09:09 ");
// double d=Bll.Common.DateDiff(Bll.Common.EnumDateCompare.day,a,b);
// Response.Write(d.ToString("f0"));//四舍五入
public enum EnumDateCompare
{
year =1,
month =2,
day =3,
hour =4,
minute =5,
second =6
}
public static double DateDiff(EnumDateCompare howtocompare, System.DateTime startDate, System.DateTime endDate)
{
double diff=0;
System.TimeSpan TS = new System.TimeSpan(endDate.Ticks-startDate.Ticks);
switch (howtocompare)
{
case EnumDateCompare.year:
diff = Convert.ToDouble(TS.TotalDays/365);
break;
case EnumDateCompare.month:
diff = Convert.ToDouble((TS.TotalDays/365)*12);
break;
case EnumDateCompare.day:
diff = Convert.ToDouble(TS.TotalDays);
break;
case EnumDateCompare.hour:
diff = Convert.ToDouble(TS.TotalHours);
break;
case EnumDateCompare.minute:
diff = Convert.ToDouble(TS.TotalMinutes);
break;
case EnumDateCompare.second:
diff = Convert.ToDouble(TS.TotalSeconds);
break;
}
return diff;
}
#endregion
四.获取某月的实际工作日(即不包括周六日)// 调用
// DateTime a=Convert.ToDateTime("2005-09-03 20:15");
// DateTime b=Convert.ToDateTime("2005-09-04 09:09 ");
// double d=Bll.Common.DateDiff(Bll.Common.EnumDateCompare.day,a,b);
// Response.Write(d.ToString("f0"));//四舍五入
public enum EnumDateCompare
{
year =1,
month =2,
day =3,
hour =4,
minute =5,
second =6
}
public static double DateDiff(EnumDateCompare howtocompare, System.DateTime startDate, System.DateTime endDate)
{
double diff=0;
System.TimeSpan TS = new System.TimeSpan(endDate.Ticks-startDate.Ticks);
switch (howtocompare)
{
case EnumDateCompare.year:
diff = Convert.ToDouble(TS.TotalDays/365);
break;
case EnumDateCompare.month:
diff = Convert.ToDouble((TS.TotalDays/365)*12);
break;
case EnumDateCompare.day:
diff = Convert.ToDouble(TS.TotalDays);
break;
case EnumDateCompare.hour:
diff = Convert.ToDouble(TS.TotalHours);
break;
case EnumDateCompare.minute:
diff = Convert.ToDouble(TS.TotalMinutes);
break;
case EnumDateCompare.second:
diff = Convert.ToDouble(TS.TotalSeconds);
break;
}
return diff;
}
#endregion
//调用
//int days =getDays(System.DateTime.Now));
private int getDays(System.DateTime date1)
{
int m=System.DateTime.DaysInMonth(date1.Year,date1.Month);
int mm=0;
for(int i=1;i<=m;i++)
{
System.DateTime date=Convert.ToDateTime(date1.Year+"-"+date1.Month+"-"+i);
switch (date.DayOfWeek)
{
case System.DayOfWeek.Monday:
case System.DayOfWeek.Thursday:
case System.DayOfWeek.Tuesday:
case System.DayOfWeek.Wednesday:
case System.DayOfWeek.Friday:
mm=mm+1;
break;
}
}
return mm;
}
五.获得任意两日期之间的有效工作日(不包括周六日)
//int days =getDays(System.DateTime.Now));
private int getDays(System.DateTime date1)
{
int m=System.DateTime.DaysInMonth(date1.Year,date1.Month);
int mm=0;
for(int i=1;i<=m;i++)
{
System.DateTime date=Convert.ToDateTime(date1.Year+"-"+date1.Month+"-"+i);
switch (date.DayOfWeek)
{
case System.DayOfWeek.Monday:
case System.DayOfWeek.Thursday:
case System.DayOfWeek.Tuesday:
case System.DayOfWeek.Wednesday:
case System.DayOfWeek.Friday:
mm=mm+1;
break;
}
}
return mm;
}
获得任意两日期之间的有效工作日(不包括周六日)
六.格式输出格式输出
七.获得本周的周六和周日#region ConvertDateToWeek
public static void ConvertDateToWeek(DateTime date,out DateTime firstdate,out DateTime lastdate)
{
DateTime first=System.DateTime.Now;
DateTime last=System.DateTime.Now;
switch (date.DayOfWeek)
{
case System.DayOfWeek.Monday:
first=date.AddDays(-1);
last=date.AddDays(5);
break;
case System.DayOfWeek.Tuesday:
first=date.AddDays(-2);
last=date.AddDays(4);
break;
case System.DayOfWeek.Wednesday:
first=date.AddDays(-3);
last=date.AddDays(3);
break;
case System.DayOfWeek.Thursday:
first=date.AddDays(-4);
last=date.AddDays(2);
break;
case System.DayOfWeek.Friday:
first=date.AddDays(-5);
last=date.AddDays(1);
break;
case System.DayOfWeek.Saturday:
first=date.AddDays(-6);
last=date;
break;
case System.DayOfWeek.Sunday:
first=date;
last=date.AddDays(6);
break;
}
firstdate=first;
lastdate=last;
}
#endregion
//调用
DateTime firstdate=System.DateTime.Now;
DateTime lastdate=System.DateTime.Now;
ConvertDateToWeek(date,out firstdate,out lastdate);
八获得当前日期是该年度的第几周public static void ConvertDateToWeek(DateTime date,out DateTime firstdate,out DateTime lastdate)
{
DateTime first=System.DateTime.Now;
DateTime last=System.DateTime.Now;
switch (date.DayOfWeek)
{
case System.DayOfWeek.Monday:
first=date.AddDays(-1);
last=date.AddDays(5);
break;
case System.DayOfWeek.Tuesday:
first=date.AddDays(-2);
last=date.AddDays(4);
break;
case System.DayOfWeek.Wednesday:
first=date.AddDays(-3);
last=date.AddDays(3);
break;
case System.DayOfWeek.Thursday:
first=date.AddDays(-4);
last=date.AddDays(2);
break;
case System.DayOfWeek.Friday:
first=date.AddDays(-5);
last=date.AddDays(1);
break;
case System.DayOfWeek.Saturday:
first=date.AddDays(-6);
last=date;
break;
case System.DayOfWeek.Sunday:
first=date;
last=date.AddDays(6);
break;
}
firstdate=first;
lastdate=last;
}
#endregion
//调用
DateTime firstdate=System.DateTime.Now;
DateTime lastdate=System.DateTime.Now;
ConvertDateToWeek(date,out firstdate,out lastdate);
DateTime dt = Convert.ToDateTime("2006-05-01");
int weeks = dt.DayOfYear / 7 + 1;
int weeks = dt.DayOfYear / 7 + 1;