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);
}
