/// <summary> /// 必要实际开启台数实时刷新数据 /// </summary> /// <param name="currtime"></param> /// <param name="begtime"></param> /// <returns></returns> public Model.ViewObject.SupplyStackSumpowerpq_VO SupplySer(DateTime currtime, DateTime begtime) { var res = dal.QueryWhereDesc(f => f.DateTime >= begtime && f.DateTime <= currtime, or => or.OrderByDescending(o => o.DateTime)).Select(f => new { time = f.DateTime, mustnum = Math.Round((double)f.ProduceFlowCentrifuge / 15000 * 1.1, 1), 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); }
/// <summary> /// 大数据界面压力功率流量数据 /// </summary> /// <param name="currtime">当前时间</param> /// <param name="begtime">之前时间</param> /// <returns></returns> 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 = f.ProduceFlowCentrifuge / 15000, runnum = f.RUN_NUM, flow = f.ProduceFlowStation, 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); }
/// <summary> /// 大数据界面功率流量压力实时刷新数据 /// </summary> /// <param name="currtime"></param> /// <param name="begtime"></param> /// <returns></returns> 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.QueryWhereDesc(f => f.DateTime >= begtime && f.DateTime <= currtime, or => or.OrderByDescending(o => o.DateTime)).Select(f => new { time = f.DateTime, flow = f.ProduceFlowStation / 1000,//单位转换 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); }