public List<HistoryData> GetBBZCHistoryDataList(string sensorIDList, DateTime beginTime, DateTime endTime)
{
try
{
StringBuilder sb = new StringBuilder();
List<HistoryData> list = new List<HistoryData>();
sb.Append(" and it.SensorID in {" + sensorIDList + "}");
sb.Append(" and it.HDDT>=datetime'" + beginTime.ToString("yyyy-MM-dd HH:mm:ss") + "'");
sb.Append(" and it.HDDT<=datetime'" + endTime.ToString("yyyy-MM-dd HH:mm:ss") + "'");
list=db.HistoryDatas.Include("Sensor").Where(sb.ToString().Substring(4)).ToList();
return list;
}
catch (Exception ex)
{
MyTool.WriteErrLog(ex);
throw;
}
}
{
try
{
StringBuilder sb = new StringBuilder();
List<HistoryData> list = new List<HistoryData>();
sb.Append(" and it.SensorID in {" + sensorIDList + "}");
sb.Append(" and it.HDDT>=datetime'" + beginTime.ToString("yyyy-MM-dd HH:mm:ss") + "'");
sb.Append(" and it.HDDT<=datetime'" + endTime.ToString("yyyy-MM-dd HH:mm:ss") + "'");
list=db.HistoryDatas.Include("Sensor").Where(sb.ToString().Substring(4)).ToList();
return list;
}
catch (Exception ex)
{
MyTool.WriteErrLog(ex);
throw;
}
}
#endregion
备注:一定要加ToString("yyyy-MM-dd HH:mm:ss")否则会报datetime 文本值“2015/4/1 0:00:00”无效