问题描述:
在《C#判断判断某一时刻属于什么时间段》中提到的订单处理系统中,有这么一个需求,就是根据用户选择的两个日期,去mdb中查询在这连个日期之间的每一天的相关信息,故需要用每一天的日期字符串来拼接sql语句。
解决方法:
string dtpTime1="2018-01-01";
string dtpTime1="2018-10-01";
string[] sTimeArray = getTimeArray();
public static string[] getTimeArray(string time1, string time2)
{
string[] strArray = new string[365];
DateTime oldDate = new DateTime();
DateTime newDate = new DateTime();
try
{
oldDate = Convert.ToDateTime(time1);
newDate = Convert.ToDateTime(time2);
}
catch
{
}
TimeSpan ts = newDate - oldDate;
int differenceInDays = ts.Days;
DateTime tempTime = oldDate;
string tempStr = "";
for (int i = 0; i <= differenceInDays; i++)
{
if (i < strArray.Length)
{
tempStr = tempTime.ToString("yyyy-MM-dd");
strArray[i] = tempStr;
tempTime = tempTime.AddDays(1);
}
}
return strArray;
}