public IndexVM PowerQueryCurrentLine(HttpContext context) { var vm = new IndexVM(); vm.hasError = false; try { var Line = context.Request.Params["Line"]; var list = DataAnalyLoader.PowerQueryCurrentLine(Line); var cats = list.Select(a => a.CTime).Distinct().ToList(); vm.data1 = JsonSerializeHelper.SerializeObject(cats); var liste = new List <VM_ENERGY>(); var l1 = new VM_ENERGY(); l1.name = Line; l1.data_vm = list.Select(b => new { b.CTime, b.CollectValue }).ToArray(); liste.Add(l1); vm.data = JsonSerializeHelper.SerializeObject(liste); } catch (Exception ex) { vm.hasError = true; vm.error = string.Format("获取图表数据遇到异常{0}", ex.Message); } return(vm); }
public IndexVM PowerAnalyzeDay(HttpContext context) { var vm = new IndexVM(); try { var Position = context.Request.Params["Position"]; var CollectDateFrom = context.Request.Params["CollectDateFrom"]; var CollectDateTo = context.Request.Params["CollectDateTo"]; var list = DataAnalyLoader.PowerAnalyzeDay(Position, CollectDateFrom, CollectDateTo); var liste = new List <VM_ENERGY>(); var cats = list.Select(a => a.CollectDate).Distinct().ToList(); vm.data1 = JsonSerializeHelper.SerializeObject(cats); var names = new string[3] { "高峰", "平谷", "低谷" }; for (int i = 0; i < 3; i++) { var l1 = new VM_ENERGY(); l1.name = names[i]; //l1.data = new decimal[cats.Count]; l1.data_vm = list.Where(a => a.PeriodName == l1.name).Select(b => new { b.CollectDate, b.CollectValue }).ToArray(); liste.Add(l1); } vm.hasError = false; vm.data = JsonSerializeHelper.SerializeObject(liste); } catch (Exception ex) { vm.hasError = true; vm.error = string.Format("获取图表数据遇到异常{0}", ex.Message); } return(vm); }
public IndexVM PowerAnalyzeYearLineSummary(HttpContext context) { var vm = new IndexVM(); try { var Line = context.Request.Params["Line"]; var CollectYearFrom = context.Request.Params["CollectYearFrom"]; var CollectYearTo = context.Request.Params["CollectYearTo"]; var list = DataAnalyLoader.PowerAnalyzeYearLineSummary(Line, CollectYearFrom, CollectYearTo); var liste = new List <VM_ENERGY>(); var cats = list.Select(a => a.CollectDate).Distinct().ToList(); vm.data2 = JsonSerializeHelper.SerializeObject(cats); var names = list.Select(a => a.Line).Distinct().ToList(); for (int i = 0; i < names.Count; i++) { var l1 = new VM_ENERGY(); l1.name = names[i]; //l1.data = new decimal[cats.Count]; //l1.data = list.Where(a => a.Line == l1.name).Select(b => Convert.ToDecimal(b.CollectValue)).ToArray(); l1.data_vm = list.Where(a => a.Line == l1.name).Select(b => new { b.CollectDate, b.CollectValue }).ToArray(); liste.Add(l1); } vm.hasError = false; vm.data = JsonSerializeHelper.SerializeObject(liste); vm.data1 = JsonSerializeHelper.SerializeObject(names); } catch (Exception ex) { vm.hasError = true; vm.error = string.Format("获取图表数据遇到异常{0}", ex.Message); } return(vm); }
public ResultVM GetZhengQi(HttpContext context) { var vm = new ResultVM(); vm.hasError = false; var Line = context.Request.Params["Line"]; var list = new List <VM_ENERGY_COLLECT>(); list = KanbanEnergyLoader.GettZhengQiData(Line, ""); var data = new List <VM_ENERGY>(); var dates = list.Select(a => a.CollectDate).Distinct().ToList(); foreach (var d in dates) { var item = data.Where(a => a.name == d).FirstOrDefault(); if (item == null) { item = new VM_ENERGY(); item.name = d; var dlist = list.Where(a => a.CollectDate == d).OrderBy(b => b.Line).ToList(); item.data = new Decimal[dlist.Count]; for (int i = 0; i < dlist.Count; i++) { item.data[i] = dlist[i].DataValue; } data.Add(item); } else { } } vm.data = JsonSerializeHelper.SerializeObject(data); return(vm); }
public IndexVM EnergyQueryOnly4(HttpContext context) { var vm = new IndexVM(); vm.hasError = false; var QueryType = context.Request.Params["QueryType"]; var Category = context.Request.Params["Category"]; if (string.IsNullOrWhiteSpace(QueryType) || QueryType == "DAY") { var CollectDateFrom = context.Request.Params["CollectDateFrom"]; var CollectDateTo = context.Request.Params["CollectDateTo"]; var list = DataAnalyLoader.QueryEnergy4ByDay(CollectDateFrom, CollectDateTo, Category); //vm.data = JsonSerializeHelper.SerializeObject(list); var cats = list.Select(a => a.CollectDate).Distinct().ToList(); vm.data1 = JsonSerializeHelper.SerializeObject(cats); var liste = new List <VM_ENERGY>(); if (Category == "TIANRANQI" || Category == "ZHENGQI") { var l1 = new VM_ENERGY(); l1.name = "L01"; l1.data = new decimal[cats.Count]; //l1.data = list.Where(a => a.Line == "L01").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l1.data_vm = list.Where(a => a.Line == "L01").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l1); var l2 = new VM_ENERGY(); l2.name = "L02"; l2.data = new decimal[cats.Count]; //l2.data = list.Where(a => a.Line == "L02").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l2.data_vm = list.Where(a => a.Line == "L02").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l2); var l3 = new VM_ENERGY(); l3.name = "L03"; //l3.data = new decimal[cats.Count]; //l3.data = list.Where(a => a.Line == "L03").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l3.data_vm = list.Where(a => a.Line == "L03").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l3); var l4 = new VM_ENERGY(); l4.name = "L04"; //l4.data = new decimal[cats.Count]; //l4.data = list.Where(a => a.Line == "L04").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l4.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l4); } else { var i = 0; vm.data1 = JsonSerializeHelper.SerializeObject(cats); var l = new VM_ENERGY(); l.name = "L04"; l.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); i = i = 1; liste.Add(l); } vm.data = JsonSerializeHelper.SerializeObject(liste); } else if (QueryType == "MONTH") { var CollectMonthFrom = context.Request.Params["CollectMonthFrom"]; var CollectMonthTo = context.Request.Params["CollectMonthTo"]; var list = DataAnalyLoader.QueryEnergy4ByMonth(CollectMonthFrom, CollectMonthTo, Category); var cats = list.Select(a => a.CollectDate).Distinct().ToList(); vm.data1 = JsonSerializeHelper.SerializeObject(cats); var liste = new List <VM_ENERGY>(); if (Category == "TIANRANQI" || Category == "ZHENGQI") { var l1 = new VM_ENERGY(); l1.name = "L01"; //l1.data = new decimal[cats.Count]; //l1.data = list.Where(a => a.Line == "L01").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l1.data_vm = list.Where(a => a.Line == "L01").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l1); var l2 = new VM_ENERGY(); l2.name = "L02"; //l2.data = new decimal[cats.Count]; //l2.data = list.Where(a => a.Line == "L02").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l2.data_vm = list.Where(a => a.Line == "L02").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l2); var l3 = new VM_ENERGY(); l3.name = "L03"; //l3.data = new decimal[cats.Count]; //l3.data = list.Where(a => a.Line == "L03").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l3.data_vm = list.Where(a => a.Line == "L03").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l3); var l4 = new VM_ENERGY(); l4.name = "L04"; //l4.data = new decimal[cats.Count]; //l4.data = list.Where(a => a.Line == "L04").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l4.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l4); } else { var i = 0; vm.data1 = JsonSerializeHelper.SerializeObject(cats); var l = new VM_ENERGY(); l.name = "L04"; l.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); i = i = 1; liste.Add(l); } vm.data = JsonSerializeHelper.SerializeObject(liste); } else if (QueryType == "YEAR") { var CollectYearFrom = context.Request.Params["CollectYearFrom"]; var CollectYearTo = context.Request.Params["CollectYearTo"]; var list = DataAnalyLoader.QueryEnergy4ByYear(CollectYearFrom, CollectYearTo, Category); //vm.data = JsonSerializeHelper.SerializeObject(list); var cats = list.Select(a => a.CollectDate).Distinct().ToList(); vm.data1 = JsonSerializeHelper.SerializeObject(cats); var liste = new List <VM_ENERGY>(); if (Category == "TIANRANQI" || Category == "ZHENGQI") { var l1 = new VM_ENERGY(); l1.name = "L01"; //l1.data = new decimal[cats.Count]; //l1.data = list.Where(a => a.Line == "L01").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l1.data_vm = list.Where(a => a.Line == "L01").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l1); var l2 = new VM_ENERGY(); l2.name = "L02"; //l2.data = new decimal[cats.Count]; //l2.data = list.Where(a => a.Line == "L02").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l2.data_vm = list.Where(a => a.Line == "L02").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l2); var l3 = new VM_ENERGY(); l3.name = "L03"; //l3.data = new decimal[cats.Count]; //l3.data = list.Where(a => a.Line == "L03").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l3.data_vm = list.Where(a => a.Line == "L03").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l3); var l4 = new VM_ENERGY(); l4.name = "L04"; //l4.data = new decimal[cats.Count]; //l4.data = list.Where(a => a.Line == "L04").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l4.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); liste.Add(l4); } else { var i = 0; vm.data1 = JsonSerializeHelper.SerializeObject(cats); var l = new VM_ENERGY(); l.name = "L04"; //l.data = new decimal[cats.Count]; //l.data = list.Where(a => a.Line == "L04").Select(b => Convert.ToDecimal(b.TotalValue)).ToArray(); l.data_vm = list.Where(a => a.Line == "L04").Select(b => new { b.CollectDate, b.TotalValue }).ToArray(); i = i = 1; liste.Add(l); } vm.data = JsonSerializeHelper.SerializeObject(liste); } //vm.data = JsonSerializeHelper.SerializeObject(list); return(vm); }