//按照时间段拼接Sql语句 switch (strPeriod) { case "日": { #region 确定时间周期>日的时间范围 strStart = strToday.Substring(0, 4); strEnd = strToday; if (strUpPeriod == "年") { strStart += "-01-01"; } else if (strUpPeriod == "半年") { //计算当前日期为上半年还是下半年 if (Convert.ToInt32(strToday.Substring(5, 2)) > 6) { strStart += "-07-01"; } else { strStart += "-01-01"; } } else if (strUpPeriod == "季度") { if (Convert.ToInt32(strToday.Substring(5, 2)) > 9) strStart = strToday.Substring(0, 5) + "10-01"; else if (Convert.ToInt32(strToday.Substring(5, 2)) > 6) strStart = strToday.Substring(0, 5) + "07-01"; else if (Convert.ToInt32(strToday.Substring(5, 2)) > 3) strStart = strToday.Substring(0, 5) + "04-01"; else strStart = strToday.Substring(0, 5) + "01-01"; }