private DataTable GetHourData(DateTime stime, DateTime etime, List <string> pointItems)
{
DataTable dt = new DataTable();
try
{
IJc_HourRepository repository = ServiceFactory.Create <IJc_HourRepository>();
if (stime.Month == etime.Month)
{
dt = repository.GetJC_HourDataByTimer(stime, etime, pointItems);
}
else
{
DateTime endTime = new DateTime(etime.Year, etime.Month, 1, 23, 59, 59).AddDays(-1);
DateTime startTime = new DateTime(etime.Year, etime.Month, 1, 0, 0, 0);
DataTable dt1 = repository.GetJC_HourDataByTimer(stime, endTime, pointItems);
DataTable dt2 = repository.GetJC_HourDataByTimer(startTime, etime, pointItems);
//添加DataTable1的数据
object[] obj = new object[dt1.Columns.Count];
dt = dt1.Clone();
if (dt1 != null)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
dt1.Rows[i].ItemArray.CopyTo(obj, 0);
dt.Rows.Add(obj);
}
}
if (dt2 != null)
{
//添加DataTable2的数据
for (int i = 0; i < dt2.Rows.Count; i++)
{
dt2.Rows[i].ItemArray.CopyTo(obj, 0);
dt.Rows.Add(obj);
}
}
}
}
catch (Exception ex)
{
LogHelper.Error("RatioAlarmProcHandle GetHourData Error" + ex.Message);
}
return(dt);
}
public Jc_HourService(IJc_HourRepository _Repository)
{
this._Repository = _Repository;
}
