62,046
社区成员
发帖
与我相关
我的任务
分享
DateTime.Now;
DateTime beginDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime endDate = beginDate.AddMonths(1).AddDays(-1);
int week = (int)DateTime.Today.DayOfWeek;
if (week == 0) week = 7;
DateTime beginDate = DateTime.Today.AddDays(-(week - 1));
DateTime endDate = beginDate.AddDays(6);
protected void Button1_Click(object sender, EventArgs e)
{
string beginTime="",endTime="";
switch (RadioButtonList1.SelectedValue)
{
//本日时间是从当天00:00:00到23:59:59;
case "本日":
beginTime = DateTime.Now.ToString("d") + " 00:00:00";
endTime = DateTime.Now.ToString("d")+" 23:59:59";
break;
//获取本周时间段,嵌套一个switch语句块,得到本周星期一0点到星期天23点的时间段;
case "本周":
switch (DateTime.Now.DayOfWeek) //
{ /*星期一*/
case DayOfWeek.Monday:
beginTime = DateTime.Now.ToString("d") + " 00:00:00";
endTime = DateTime.Now.AddDays(6).ToString("d") + " 23:59:59";
break;
/*星期二*/
case DayOfWeek.Tuesday:
beginTime = DateTime.Now.AddDays(-1).ToString("d") + " 00:00:00";
endTime = DateTime.Now.AddDays(5).ToString("d") + " 23:59:59";
break;
/*星期三*/
case DayOfWeek.Wednesday:
beginTime = DateTime.Now.AddDays(-2).ToString("d") + " 00:00:00";
endTime = DateTime.Now.AddDays(4).ToString("d") + " 23:59:59";
break;
//后面周4到周日根据上面计算即可
} break;
//获取本月时间段,开始时间是本月1号,而下个月1号减去1天就是本月最后一天;
case "本月":
beginTime = DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00";
endTime = DateTime.Parse(DateTime.Now.AddMonths(1).ToString("yyyy-MM") + "-01 00:00:00").AddDays(-1).ToString("d")+" 23:59:59";
break;
} Response.Write("选择的时间段是:" + beginTime + "至" + endTime);//此时beginTime和endTime还是string类型,转换成DateTime类型传值到数据库即可;
}
DateTime dt = DateTime.Now; //当前时间
int dayOfWeek = Convert.ToInt32(dt.DayOfWeek.ToString("d"));
DateTime startWeek = dt.AddDays(1-((dayOfWeek == 0)?7:dayOfWeek)); //本周周一
DateTime endWeek = startWeek.AddDays(6); //本周周日
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末