62,040
社区成员
发帖
与我相关
我的任务
分享
DateTime d1 = DateTime.Parse("2008-01-03");
DateTime d2 = DateTime.Parse("2008-01-04");
TimeSpan ts = d2 - d1;
for(int i = 0; i < ts.TotalSeconds; i++) {
ts = new TimeSpan(0, 0, 0, i);
d2 = d1 + ts;
string time = d2.ToString("HHmm");
if((time >= "0000" && time <= "0800") || (time >= "0900" && time <= "1600") || (time >= "1700" && time <= "2359")) {
Console.WriteLine(time + " 处于时间段内");
}
}
if (this.calPublishDateStart.Text.Trim() != "")
{//大于或等于出版时间
strCondition += " and (a.PublishDate='' or Convert(varchar(10),PublishDate,120) >='" + calPublishDateStart.Text.Trim() + "') ";
}
if (this.calPublishDateEnd.Text.Trim() != "")
{//小于或等于出版时间
strCondition += " and (a.PublishDate='' or Convert(varchar(10),PublishDate,120) <='" + calPublishDateEnd.Text.Trim() + "') ";
}