public ActionResult upchartandgrid(string select, string title, string t, string m)
{
#region 统计数据
if (select.EndsWith(","))
{
select = select.Substring(0, select.Length - 1);
}
string[] getsel = select.Split(',');
if (getsel.Length < 1)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
#region 读取
DateTime start;
DateTime end;
if (m == null || m == "")
{
start = DateTime.Now.Date.AddMonths(-1);
}
else
{
start = Convert.ToDateTime(m);
}
end = start.AddMonths(1);
var l = WebAccountHelper.ProcessStatistic(select, start, end, t);
#endregion
#endregion
#region 图表
FlexChart chart = new FlexChart();
chart = centerService.GetFlexChartBySelects(Masterpage.CurrUser.client_code, Masterpage.CurrUser.client_name, title, select);
chart.url = Utils.GetFlexAddress();
chart.title = title + "变化趋势";
chart.queryparms = t + "|" + m;
#endregion
var result = new { grid = l, chart = chart };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult chartfullscreen(string title, string s1, string s2, string t, string w, string h, string m)
{
dynamic data = new System.Dynamic.ExpandoObject();
string type = "";
if (s2 != "")
{
type = "line2";
}
else
{
type = "line1";
}
#region 图表
//var point = centerService.GetOneCustomerCollection(s1);
//var chart = centerService.GetParamsQueryFlexChart("C03");
//chart.charttype = type;
//chart.customercode = Masterpage.CurrUser.client_code;
//chart.customername = Masterpage.CurrUser.client_name;
//chart.height = int.Parse(h);
//chart.width = int.Parse(w);
//#region 上下限
//if (point.CustomerCollectionLowerLimit.HasValue)
//{
// chart.needlower = 1;
// chart.lowerlimit = point.CustomerCollectionLowerLimit.Value;
//}
//else chart.needlower = 0;
//if (point.CustomerCollectionLowLimit.HasValue)
//{
// chart.needlow = 1;
// chart.lowlimit = point.CustomerCollectionLowLimit.Value;
//}
//else chart.needlow = 0;
//if (point.CustomerCollectionUpLimit.HasValue)
//{
// chart.needup = 1;
// chart.uplimit = point.CustomerCollectionUpLimit.Value;
//}
//else chart.needup = 0;
//if (point.CustomerCollectionUpperLimit.HasValue)
//{
// chart.needuper = 1;
// chart.uperlimit = point.CustomerCollectionUpperLimit.Value;
//}
//else chart.needuper = 0;
//#endregion
//chart.processparms = s1 + (s2 != "" ? ("," + s2) : "");
//chart.title = title + "变化趋势";
//chart.queryparms = t;
#endregion
#region 图表
FlexChart chart = new FlexChart();
string select = s1 + (s2 != "" ? ("," + s2) : "");
chart = centerService.GetFlexChartBySelects(Masterpage.CurrUser.client_code, Masterpage.CurrUser.client_name, title, select);
chart.charttype = type;
chart.customercode = Masterpage.CurrUser.client_code;
chart.customername = Masterpage.CurrUser.client_name;
chart.height = int.Parse(h);
chart.width = int.Parse(w);
chart.title = title + "变化趋势";
chart.queryparms = t + "|" + m;
chart.url = Utils.GetFlexAddress();
#endregion
data.chart = JsonHelper.ToJson(chart);
LogHelper.Info(Masterpage.CurrUser.alias, "702011:客户," + Masterpage.CurrUser.client_code + ",查看全屏图表，采集点为：" + s1);
return(View("chartfullscreen", data));
}
/// <summary>
/// 工作台
/// </summary>
/// <returns></returns>
public ActionResult platform()
{
LogHelper.Info(Masterpage.CurrUser.alias, "101011:客户," + Masterpage.CurrUser.client_code + "打开工作台");
dynamic data = new System.Dynamic.ExpandoObject();
data.code = Masterpage.CurrUser.client_code;
var chartconfig = centerService.GetPlatFormThreeChartCode(Masterpage.CurrUser.client_code, Masterpage.CurrUser.config1);
#region 工艺三个小图表
var str1 = chartconfig.chart1_1 + (chartconfig.chart1_2 != "" ? "," + chartconfig.chart1_2 : "");
var str2 = chartconfig.chart2_1 + (chartconfig.chart2_2 != "" ? "," + chartconfig.chart2_2 : "");
var str3 = chartconfig.chart3_1 + (chartconfig.chart3_2 != "" ? "," + chartconfig.chart3_2 : "");
data.str1 = str1;
data.str2 = str2;
data.str3 = str3;
data.chart1_1 = chartconfig.chart1_1;
data.chart1_2 = chartconfig.chart1_2;
data.chart2_1 = chartconfig.chart2_1;
data.chart2_2 = chartconfig.chart2_2;
data.chart3_1 = chartconfig.chart3_1;
data.chart3_2 = chartconfig.chart3_2;
data.unitname1 = chartconfig.unitname1;
data.unitname2 = chartconfig.unitname2;
data.unitname3 = chartconfig.unitname3;
FlexChart chart1 = new FlexChart();
FlexChart chart2 = new FlexChart();
FlexChart chart3 = new FlexChart();
if (str1 != null && str1 != "")
{
chart1 = centerService.GetFlexChartBySelects(Masterpage.CurrUser.client_code, Masterpage.CurrUser.client_name, "", str1);
chart1.url = Utils.GetFlexAddress();
}
if (str2 != null && str2 != "")
{
chart2 = centerService.GetFlexChartBySelects(Masterpage.CurrUser.client_code, Masterpage.CurrUser.client_name, "", str2);
chart2.url = Utils.GetFlexAddress();
}
if (str3 != null && str3 != "")
{
chart3 = centerService.GetFlexChartBySelects(Masterpage.CurrUser.client_code, Masterpage.CurrUser.client_name, "", str3);
chart3.url = Utils.GetFlexAddress();
}
data.chart1 = JsonHelper.ToJson(chart1);
data.chart2 = JsonHelper.ToJson(chart2);
data.chart3 = JsonHelper.ToJson(chart3);
#endregion
#region 工艺三个图表的下拉单元
List <long> long1 = new List <long> {
7, 8, 9
};
List <long> long2 = new List <long> {
10, 11, 12, 13
};
List <long> long3 = new List <long> {
14, 15, 16
};
var units1 = centerService.GetThreeChartStandardProcessUnit(Masterpage.CurrUser.client_code, long1);
var units2 = centerService.GetThreeChartStandardProcessUnit(Masterpage.CurrUser.client_code, long2);
var units3 = centerService.GetThreeChartStandardProcessUnit(Masterpage.CurrUser.client_code, long3);
data.units1 = JsonHelper.ToJson(units1.Select(p => new { text = p, id = p }).ToList());
data.units2 = JsonHelper.ToJson(units2.Select(p => new { text = p, id = p }).ToList());
data.units3 = JsonHelper.ToJson(units3.Select(p => new { text = p, id = p }).ToList());
#endregion
#region 每四个图表的耗材
var hc = materialService.GetMaterialSpecification(Masterpage.CurrUser.client_code).Distinct().ToList();
data.material = hc;
#endregion
#region 进水监管链接的参数
int isic = -1;
if (chartconfig != null)
{
if (chartconfig.unitname1.Contains("厌氧"))
{
isic = 1;
}
else if (chartconfig.unitname1.Contains("好氧"))
{
isic = 2;
}
else
{
isic = 0;
}
}
data.isic = isic;
#endregion
#region 第四个小图表
var config3 = centerService.GetPlatFormFourthChart(Masterpage.CurrUser.client_code, Masterpage.CurrUser.config3);
FlexChart chart4 = new FlexChart();
string chart4_1 = "";
string chart4_2 = "";
string chart4name = "";
if (config3.number != null && config3.number != "")
{
chart4 = centerService.GetFlexChartByChartNumber(config3.number);
chart4.customercode = Masterpage.CurrUser.client_code;
chart4.customername = Masterpage.CurrUser.client_name;
chart4.processparms = config3.material + "|" + DateTime.Now.Year.ToString();
chart4.queryparms = config3.material;
chart4_1 = config3.material;
chart4_2 = config3.number;
chart4.url = Utils.GetFlexAddress();
if (config3.material != null && config3.material != "")
{
var m = materialService.GetOneMaterialSpecification(config3.material);
chart4name = m.MaterialSpecificationName;
}
}
data.chart4_1 = chart4_1;
data.chart4_2 = chart4_2;
data.chart4name = chart4name;
data.chart4 = JsonHelper.ToJson(chart4);
#endregion
#region 工艺报警
//var alarms = WebAccountHelper.GetCollectionAlarm(Masterpage.CurrUser.client_code);
var alarms = managementService.GetCustomerCollectionAlarmRes(Masterpage.CurrUser.client_code, "").Where(p => p.Status.HasValue && !p.Status.Value).ToList();
data.alarms = alarms;
#endregion
#region 操作建议
var option = centerService.GetSystemOptimization(Masterpage.CurrUser.client_code);
//var s2 = centerService.GetSystemDiagnostic(Masterpage.CurrUser.client_code);
//var s3 = centerService.GetLastOptimizationSuggestion(Masterpage.CurrUser.client_code, 1);
data.option = option;
//data.s2 = s2;
#endregion
#region 流程图采集点
//var vs = centerService.GetProcessCollectionValue(Masterpage.CurrUser.client_code).Select(p => new { code = p.CustomerCollectionCode.Replace("-", "$"), value = p.CustomerCollectionAvgValue });
var date = DateTime.Now.AddDays(-1);// DateTime.Parse("2013-07-04");//
var nalarms = alarms.Where(x => DateTime.Compare(x.CustomerAlaramHappenTime.Value.Date, date.Date) == 0).ToList();
var vs = centerService.GetProcessPlatCollection(Masterpage.CurrUser.client_code, date).Select(p => new ProcessPlatCollection {
code = p.code.Replace("-", "$"), value = p.value, low = p.low, up = p.up, alarm = 0
}).ToList();
foreach (var item in nalarms)
{
var ha = vs.FirstOrDefault(p => p.code == item.CustomerCollectionCode.Replace("-", "$"));
if (ha != null)
{
ha.alarm = 1;
}
}
data.list = JsonHelper.ToJson(vs);
#endregion
#region 流程图开关量
//var switchs = centerService.GetProcessSwitchValue(Masterpage.CurrUser.client_code).Select(p => new { code = p.CustomerCollectionCode.Replace("-", "$"), value = p.CustomerCollectionAvgValue.HasValue ? (int)p.CustomerCollectionAvgValue.Value : 0 });
data.switchs = "";// JsonHelper.ToJson(switchs);
#endregion
data.date = date;
return(View(data));
}
