private int row_num = 20; //每页显示的数据行数
public ActionResult Index()
{
GuoLuModel[] data_list = null;
int page = Convert.ToInt16(Request["page"]);//显示第几页
page = page < 1 ? 1 : page;
int total_page = 0;
int total_count = 0;
using (var context = new gatewayEntities())
{
#region 获取数据
var allData = GetGuoLuModelData(context.BaseInfo, context.Data1);
total_count = allData.Count();
data_list = allData.OrderBy(i => i.ShiJian).Skip((page - 1) * row_num).Take(row_num).ToArray();
#endregion
}
total_page = total_count % row_num > 0 ? total_count / row_num + 1 : total_count / row_num;
page = page <= total_page ? page : total_page;
ViewData["action"] = "";
ViewData["page"] = page;
ViewData["last_page"] = (page + 10) >= total_page ? total_page : (page + 10);
ViewData["total_page"] = total_page;
ViewData["total_count"] = total_count;
return(View(data_list));
}
public void GetGuoLuList()
{
string param = Request["Zhan"] ?? "";
List <string> datas = null;
string result_str = "";
using (var context = new gatewayEntities())
{
datas = context.Data1.Where(i => i.Zhan == param).Select(i => i.GuoLu).Distinct().ToList();
}
foreach (var item in datas)
{
result_str += "<option>" + item + "</option>";
}
Response.Write(result_str);
}
public ActionResult Detail()
{
string shebei_code = Request["code"] ?? "";
ViewData["shebei_code"] = shebei_code;
var zqyl_day_list = new List <object>();
var zqwd_day_list = new List <object>();
var zqgd_day_list = new List <object>();
var yqhy_day_list = new List <object>();
var zqyl_week_list = new List <object>();
var zqwd_week_list = new List <object>();
var zqgd_week_list = new List <object>();
var yqhy_week_list = new List <object>();
//获取该锅炉的24小时数据
using (var context = new gatewayEntities())
{
var tempDate = DateTime.Now.AddHours(-24);
var day_list = context.Data1.Where(i => i.ShiJian > tempDate && i.SheBei == shebei_code).OrderBy(i => i.ShiJian).ToList();
foreach (var guolu in day_list)
{
string temp_str = ((DateTime)guolu.ShiJian).Day.ToString() + "日" + ((DateTime)guolu.ShiJian).Hour + "时";
zqyl_day_list.Add(new { x = temp_str, y = guolu.ZQYL02 });
zqwd_day_list.Add(new { x = temp_str, y = guolu.ZQWD01 });
zqgd_day_list.Add(new { x = temp_str, y = guolu.ZQGD17 });
yqhy_day_list.Add(new { x = temp_str, y = guolu.YQHY20 });
}
}
//获取该锅炉的一周数据
using (var context = new gatewayEntities())
{
var tempDate = DateTime.Now.AddDays(-7);
var week_list = context.Data1.Where(i => i.ShiJian > tempDate && i.SheBei == shebei_code).OrderBy(i => i.ShiJian).ToList();
foreach (var guolu in week_list)
{
string temp_str = ((DateTime)guolu.ShiJian).Month.ToString() + "月" + ((DateTime)guolu.ShiJian).Day + "日";
zqyl_week_list.Add(new { x = temp_str, y = guolu.ZQYL02 });
zqwd_week_list.Add(new { x = temp_str, y = guolu.ZQWD01 });
zqgd_week_list.Add(new { x = temp_str, y = guolu.ZQGD17 });
yqhy_week_list.Add(new { x = temp_str, y = guolu.YQHY20 });
}
}
var seri = new System.Web.Script.Serialization.JavaScriptSerializer();
var day_arr = new
{
xScale = "ordinal",
type = "line-dotted",
yScale = "linear",
main = new List <object>()
{
new { data = zqyl_day_list },
new { data = zqwd_day_list },
new { data = zqgd_day_list },
new { data = yqhy_day_list }
}
};
var week_arr = new
{
xScale = "ordinal",
type = "line-dotted",
yScale = "linear",
main = new List <object>()
{
new { data = zqyl_week_list },
new { data = zqwd_week_list },
new { data = zqgd_week_list },
new { data = yqhy_week_list }
}
};
ViewData["day_data"] = seri.Serialize(day_arr);
ViewData["week_data"] = seri.Serialize(week_arr);
ViewData["action"] = "detail_data";
return(View());
}
public ActionResult History()
{
string shebei_code = Request["code"] ?? "";
ViewData["shebei_code"] = shebei_code;
string start_time = Request["start_time"] ?? DateTime.Now.ToShortDateString();
string end_time = Request["end_time"] ?? DateTime.Now.AddDays(1).ToShortDateString();
string Chang = (Request["Chang"] ?? "").Trim();
string Zhan = (Request["Zhan"] ?? "").Trim();
string GuoLu = (Request["GuoLu"] ?? "").Trim();
string ShuXing = (Request["ShuXing"] ?? "").Trim();
var sx_list = new List <object>();
List <string> Chang_list = null;
List <string> Zhan_list = null;
List <string> GuoLu_list = null;
Dictionary <string, string> ShuXing_list = null;
//获取该锅炉的24小时数据
using (var context = new gatewayEntities())
{
System.Data.Objects.ObjectResult <ShuXingData> time_list = null;
if (!string.IsNullOrEmpty(ShuXing))
{
time_list = context.ExecuteStoreQuery <ShuXingData>("select " + ShuXing + " as ShuXing, ShiJian from Data1 where Chang={0} and Zhan={1} and GuoLu={2} and ShiJian>={3} and ShiJian<{4}", Chang, Zhan, GuoLu, start_time + " 00:00:00", end_time + " 00:00:00");
}
if (time_list != null)
{
var tempList = time_list.ToList();
foreach (var item in tempList)
{
string temp_str = ((DateTime)item.ShiJian).Day.ToString() + "日" + ((DateTime)item.ShiJian).Hour + "时";
sx_list.Add(new { x = temp_str, y = item.ShuXing });
}
}
GuoLu_list = context.Data1.Select(i => i.GuoLu.Trim()).Distinct().ToList();
Chang_list = context.Data1.Select(i => i.Chang.Trim()).Distinct().ToList();
Zhan_list = context.Data1.Select(i => i.Zhan.Trim()).Distinct().ToList();
GuoLu_list = context.Data1.Select(i => i.GuoLu.Trim()).Distinct().ToList();
ShuXing_list = new Dictionary <string, string>();
#region 属性配置
ShuXing_list.Add("ZQWD01", "蒸汽温度℃");
ShuXing_list.Add("YQHY20", "烟气含氧量%");
ShuXing_list.Add("ZQGD17", "蒸汽干度%");
ShuXing_list.Add("ZQYL02", "蒸汽压力Mpa");
ShuXing_list.Add("GSLL10", "给水流量t/h");
ShuXing_list.Add("FSWD09", "辐入温度℃");
ShuXing_list.Add("DRWD08", "对流入口温度℃");
ShuXing_list.Add("DCWD07", "对流出口温度℃");
ShuXing_list.Add("RYYL", "燃油压力Mpa");
ShuXing_list.Add("GBWD05", "管壁温度℃");
ShuXing_list.Add("WKWD04", "瓦口温度℃");
ShuXing_list.Add("PYWD03", "排烟温度℃");
ShuXing_list.Add("RQLJ", "燃气累计m3");
ShuXing_list.Add("RYLJ", "燃油累计t");
ShuXing_list.Add("SLLJQ", "水量累计t(燃气时)");
ShuXing_list.Add("SLLJY", "水量累计t(燃油时)");
ShuXing_list.Add("RQDH", "燃气单耗m3/t");
ShuXing_list.Add("RYDH", "燃油单耗m3/t");
ShuXing_list.Add("YDDH", "用电单耗 kw.h/t");
ShuXing_list.Add("YDLJ", "用电累计kw.h");
ShuXing_list.Add("GFPL14", "鼓风频率");
//ShuXing_list.Add("RYLJ", "燃油流量t/h");??????????????????????????????????
ShuXing_list.Add("RYLL16", "燃气流量m3/h");
#endregion
}
var seri = new System.Web.Script.Serialization.JavaScriptSerializer();
var day_arr = new
{
xScale = "ordinal",
type = "line-dotted",
yScale = "linear",
main = new List <object>()
{
new { data = sx_list }
}
};
ViewData["Chang"] = Chang;
ViewData["Zhan"] = Zhan;
ViewData["GuoLu"] = GuoLu;
ViewData["ShuXing"] = ShuXing;
ViewData["time_data"] = seri.Serialize(day_arr);
ViewData["action"] = "history_data";
ViewData["Chang_list"] = Chang_list;
ViewData["Zhan_list"] = Zhan_list;
ViewData["GuoLu_list"] = GuoLu_list;
ViewData["ShuXing_list"] = ShuXing_list;
ViewData["GuoLu"] = GuoLu;
ViewData["start_time"] = start_time;
ViewData["end_time"] = end_time;
return(View());
}
public void OutCsvFile()
{
string all_str = "全部";
string Chang = (Request["Chang"] ?? all_str).Trim();
string Zhan = (Request["Zhan"] ?? all_str).Trim();
string GuoLu = (Request["GuoLu"] ?? all_str).Trim();
string Yue = (Request["Yue"] ?? all_str).Trim();
string Ri = (Request["Ri"] ?? all_str).Trim();
IQueryable <Data1> temp_data_list = null;
IEnumerable <GuoLuModel> data_list = null;
//根据条件查询数据
using (var context = new gatewayEntities())
{
temp_data_list = Chang == all_str ? context.Data1 : context.Data1.Where(i => i.Chang == Chang);
temp_data_list = Zhan == all_str ? temp_data_list : temp_data_list.Where(i => i.Zhan == Zhan);
temp_data_list = GuoLu == all_str ? temp_data_list : temp_data_list.Where(i => i.GuoLu == GuoLu);
temp_data_list = Yue == all_str ? temp_data_list : temp_data_list.Where(i => i.Yue == Yue);
temp_data_list = Ri == all_str ? temp_data_list : temp_data_list.Where(i => i.Ri == Ri);
#region 数据转换
if (temp_data_list.Count() <= 0)
{
data_list = new GuoLuModel[0];
}
else
{
data_list = GetGuoLuModelData(context.BaseInfo, temp_data_list);
data_list.OrderBy(i => i.ShiJian);
}
#endregion
//转换成csv文件
System.Text.StringBuilder result_str = new System.Text.StringBuilder();
result_str.AppendLine("ID号,状态,设备编号,厂名,站名,锅炉,蒸汽温度℃,烟气含氧量%,蒸汽干度%,蒸汽压力Mpa,给水流量t/h,辐入温度℃,对流入口温度℃,对流出口温度℃,燃油压力Mpa,管壁温度℃,瓦口温度℃,排烟温度℃,燃气累计m3,燃油累计t,水量累计t(燃气时),水量累计t(燃油时),燃气单耗m3/t,燃油单耗m3/t,用电单耗 kw.h/t,用电累计kw.h,鼓风频率,燃油流量t/h,燃气流量m3/h,年,月,日,时间");
#region 平凑csv字符
foreach (var data in data_list)
{
result_str.Append(data.id + ",");
if (data.ZQYL02 < 5)
{
result_str.Append("停炉,");
}
else if (data.ZQYL02 > 5 && data.ZQYL02 < data.Max)
{
result_str.Append("起炉,");
}
else
{
result_str.Append("危险,");
}
result_str.Append(data.SheBei + ",");
result_str.Append(data.Chang + ",");
result_str.Append(data.Zhan + ",");
result_str.Append(data.GouLu + ",");
result_str.Append(data.ZQWD01 + ",");
result_str.Append(data.YQHY20 + ",");
result_str.Append(data.ZQGD17 + ",");
result_str.Append(data.ZQYL02 + ",");
result_str.Append(data.GSLL10 + ",");
result_str.Append(data.FSWD09 + ",");
result_str.Append(data.DRWD08 + ",");
result_str.Append(data.DCWD07 + ",");
result_str.Append(data.RYYL + ",");
result_str.Append(data.GBWD05 + ",");
result_str.Append(data.WKWD04 + ",");
result_str.Append(data.PYWD03 + ",");
result_str.Append(data.RQLJ + ",");
result_str.Append(data.RYLJ + ",");
result_str.Append(data.SLLJQ + ",");
result_str.Append(data.SLLJY + ",");
result_str.Append(data.RQDH + ",");
result_str.Append(data.RYDH + ",");
result_str.Append(data.YDDH + ",");
result_str.Append(data.YDLJ + ",");
result_str.Append(data.GFPL14 + ",");
result_str.Append(data.RYLL16 + ",");
result_str.Append(data.RQLJ + ",");
result_str.Append(data.Nian + ",");
result_str.Append(data.Yue + ",");
result_str.Append(data.Ri + ",");
result_str.Append(data.ShiJian + ",");
result_str.AppendLine();
}
#endregion
Response.AppendHeader("Content-Disposition", "attachment; filename=reports.csv");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); // Encoding.UTF8;//
Response.Write(result_str);
}
}
public ActionResult Reports()
{
string all_str = "全部";
string Chang = (Request["Chang"] ?? all_str).Trim();
string Zhan = (Request["Zhan"] ?? all_str).Trim();
string GuoLu = (Request["GuoLu"] ?? all_str).Trim();
string Yue = (Request["Yue"] ?? all_str).Trim();
string Ri = (Request["Ri"] ?? all_str).Trim();
int page = Convert.ToInt16(Request["page"]);//显示第几页
page = page < 1 ? 1 : page;
int total_page = 0;
int total_count = 0;
IQueryable <Data1> temp_data_list = null;
IEnumerable <GuoLuModel> data_list = null;
List <string> Chang_list = null;
List <string> Zhan_list = null;
List <string> GuoLu_list = null;
List <string> Yue_list = null;
List <string> Ri_list = null;
//根据条件查询数据
using (var context = new gatewayEntities())
{
temp_data_list = Chang == all_str ? context.Data1 : context.Data1.Where(i => i.Chang == Chang);
temp_data_list = Zhan == all_str ? temp_data_list : temp_data_list.Where(i => i.Zhan == Zhan);
temp_data_list = GuoLu == all_str ? temp_data_list : temp_data_list.Where(i => i.GuoLu == GuoLu);
temp_data_list = Yue == all_str ? temp_data_list : temp_data_list.Where(i => i.Yue == Yue);
temp_data_list = Ri == all_str ? temp_data_list : temp_data_list.Where(i => i.Ri == Ri);
//分页处理
total_count = temp_data_list.Count();
total_page = total_count % row_num > 0 ? total_count / row_num + 1 : total_count / row_num;
page = page <= total_page ? page : total_page;
temp_data_list = temp_data_list.OrderBy(i => i.ShiJian).Skip((page - 1) * row_num).Take(row_num);
#region 数据转换
if (total_count <= 0)
{
data_list = new GuoLuModel[0];
}
else
{
data_list = GetGuoLuModelData(context.BaseInfo, temp_data_list);
}
#endregion
//构造查询列表
Chang_list = context.Data1.Select(i => i.Chang.Trim()).Distinct().ToList();
Chang_list.Insert(0, all_str);
Zhan_list = context.Data1.Select(i => i.Zhan.Trim()).Distinct().ToList();
Zhan_list.Insert(0, all_str);
GuoLu_list = context.Data1.Select(i => i.GuoLu.Trim()).Distinct().ToList();
GuoLu_list.Insert(0, all_str);
Yue_list = context.Data1.Select(i => i.Yue.Trim()).Distinct().ToList();
Yue_list.Insert(0, all_str);
Ri_list = context.Data1.Select(i => i.Ri.Trim()).Distinct().ToList();
Ri_list.Insert(0, all_str);
}
ViewData["Chang"] = Chang;
ViewData["Zhan"] = Zhan;
ViewData["GuoLu"] = GuoLu;
ViewData["Yue"] = Yue;
ViewData["Ri"] = Ri;
ViewData["Chang_list"] = Chang_list;
ViewData["Zhan_list"] = Zhan_list;
ViewData["GuoLu_list"] = GuoLu_list;
ViewData["Yue_list"] = Yue_list;
ViewData["Ri_list"] = Ri_list;
ViewData["action"] = "reports_data";
ViewData["page"] = page;
ViewData["last_page"] = (page + 10) >= total_page ? total_page : (page + 10);
ViewData["total_page"] = total_page;
ViewData["total_count"] = total_count;
return(View(data_list.ToArray()));
}
