public List <Model.ViewObject.SupplyStackSumpowerpq_VO> SupplyStackSumPowerpq(DateTime currtime, DateTime begtime)
{
var res = dal.QueryWhere(f => f.DateTime >= begtime && f.DateTime <= currtime).Select(f => new
{
time = f.DateTime,
mustnum = Math.Round((double)f.ProduceFlowCentrifuge / 15000 * 1.1, 1),
runnum = f.RUN_NUM,
flow = Math.Round(f.ProduceFlowStation.Value / 1000, 2),
press = f.PipelinePressure,
sumpower = f.SumPower
}).ToList();
DateTime StartTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1, 0, 0, 0, 0));
long timezone = StartTime.Ticks;
List <Model.ViewObject.SupplyStackSumpowerpq_VO> alllist = new List <Model.ViewObject.SupplyStackSumpowerpq_VO>();
foreach (var item in res)
{
//转换成时间戳到秒
var trantimezone = (DateTime.Parse("" + item.time).AddHours(8).Ticks - timezone) / 10000;
Model.ViewObject.SupplyStackSumpowerpq_VO list = new Model.ViewObject.SupplyStackSumpowerpq_VO()
{
time = trantimezone,
dtime = item.time.ToString(),
Mustnum = Math.Round((decimal)item.mustnum, 2),
Runnum = Convert.ToInt32(item.runnum),
Power = Convert.ToInt32(item.sumpower),
ProduceStation = Convert.ToInt32(item.flow),
Press = (decimal)item.press
};
alllist.Add(list);
}
return(alllist);
}
public Model.ViewObject.SupplyStackSumpowerpq_VO SupplySer(DateTime currtime, DateTime begtime)
{
var res = dal.QueryWhere(f => f.DateTime >= begtime && f.DateTime <= currtime).OrderByDescending(o => o.Id).Select(f => new
{
time = f.DateTime,
mustnum = f.ProduceFlowCentrifuge / 15000,
runnum = f.RUN_NUM,
}).FirstOrDefault();
DateTime StartTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1, 0, 0, 0, 0));
long timezone = StartTime.Ticks;
var trantimezone = (DateTime.Parse("" + res.time).AddHours(8).Ticks - timezone) / 10000;
Model.ViewObject.SupplyStackSumpowerpq_VO list = new Model.ViewObject.SupplyStackSumpowerpq_VO()
{
time = trantimezone,
dtime = res.time.ToString(),
Mustnum = Math.Round((decimal)res.mustnum, 2),
Runnum = Convert.ToInt32(res.runnum),
};
return(list);
}
public Model.ViewObject.SupplyStackSumpowerpq_VO StackProEpq(DateTime currtime, DateTime begtime)
{
DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1, 0, 0, 0, 0));
var res = dal.QueryWhere(f => f.DateTime >= begtime && f.DateTime <= currtime).OrderByDescending(o => o.Id).Select(f => new
{
time = f.DateTime,
flow = f.ProduceFlowStation,
press = f.PipelinePressure,
sumpower = f.SumPower
}).FirstOrDefault();
var timezone = startTime.Ticks;
var trantimezone = (DateTime.Parse("" + res.time).AddHours(8).Ticks - timezone) / 10000;
Model.ViewObject.SupplyStackSumpowerpq_VO list = new Model.ViewObject.SupplyStackSumpowerpq_VO()
{
time = trantimezone,
Power = Convert.ToInt32(res.sumpower),
Press = (decimal)res.press,
ProduceStation = Convert.ToInt32(res.flow)
};
return(list);
}
