public List <Model.ViewObject.Supply_View> TrendReal(DateTime currtime, DateTime begtime)
{
var starttime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1, 0, 0, 0, 0)).Ticks;
var res = dal.QuerySplitPage(d => d.DateTime >= begtime && d.DateTime <= currtime, or => or.OrderByDescending(o => o.DateTime), 200, 1).Select(s => new
{
time = s.DateTime,
epower = s.SumPower,
upi = s.UPI,
pp = s.PipelinePressure
}).OrderBy(oo => oo.time).ToList();
List <Model.ViewObject.Supply_View> alllist = new List <Model.ViewObject.Supply_View>();
foreach (var item in res)
{
var timetick = (DateTime.Parse("" + item.time).AddHours(8).Ticks - starttime) / 10000;
Model.ViewObject.Supply_View list = new Model.ViewObject.Supply_View()
{
time = timetick,
usef = item.epower, //电量
main = item.upi, //单耗
dtime = item.time.ToString()
};
alllist.Add(list);
}
return(alllist);
}
public List <List <Model.ViewObject.Supply_View> > StaTrendReal(DateTime currtime, DateTime begtime)
{
var starttime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1, 0, 0, 0, 0)).Ticks;
var res = dal.QuerySplitPage(d => d.DateTime >= begtime && d.DateTime <= currtime, or => or.OrderByDescending(o => o.Id), 200, 1).Select(s => new {
time = s.DateTime,
epower = s.ePower,
upi = s.UPI,
staid = s.StationID
}).GroupBy(g => g.staid).ToList();
List <List <Model.ViewObject.Supply_View> > allmodel = new List <List <Model.ViewObject.Supply_View> >();
foreach (var item in res)
{
List <Model.ViewObject.Supply_View> model = new List <Model.ViewObject.Supply_View>();
foreach (var it in item.OrderBy(o => o.time))
{
var timetick = (DateTime.Parse("" + it.time).AddHours(8).Ticks - starttime) / 10000;
Model.ViewObject.Supply_View list = new Model.ViewObject.Supply_View()
{
time = timetick,
usef = it.epower, //电量
main = it.upi, //单耗
dtime = it.time.ToString()
};
model.Add(list);
}
allmodel.Add(model);
}
return(allmodel);
}
