public ActionResult GetAlarmDetailList(FilterForAlarmDetail filter)
{
using (ANDONEntities entities = new ANDONEntities())
{
var alarm_edits = entities.Alarm_edit.Where(t => t.Delete_flag == false);
if (filter.Start_time != null && filter.End_time != null)
{
DateTime startTime = Convert.ToDateTime(filter.Start_time);
DateTime endTime = Convert.ToDateTime(filter.End_time);
alarm_edits = alarm_edits.Where(t => t.Start_time >= startTime && t.End_time <= endTime);
}
if (!String.IsNullOrEmpty(filter.Alarm_area))
{
alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area);
}
if (!String.IsNullOrEmpty(filter.Division_of_respon))
{
alarm_edits = alarm_edits.Where(t => t.Division_of_respon == filter.Division_of_respon);
}
if (!String.IsNullOrEmpty(filter.Responsible))
{
alarm_edits = alarm_edits.Where(t => t.Responsible == filter.Responsible);
}
if (!String.IsNullOrEmpty(filter.Recorder))
{
alarm_edits = alarm_edits.Where(t => t.Recorder.Contains(filter.Recorder));
}
int totalCount = alarm_edits.Count();
alarm_edits = alarm_edits.OrderBy(t => t.Start_time).Skip(filter.PageSize * (filter.PageIndex - 1)).Take(filter.PageSize);
var result = from a in alarm_edits
select new AlarmDetailViewModel
{
Start_time = a.Start_time,
End_time = a.End_time,
Station = a.Station,
Reason = a.Reason,
Responsible = a.Responsible,
Duration = a.Duration,
Division_of_respon = a.Division_of_respon,
Position = a.Position,
Recorder = a.Recorder,
Alarm_class = a.Alarm_class
};
return(Json(new
{
iTotalDisplayRecords = totalCount,
aaData = result.ToList()
}
, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAlarmClassData(FilterForAlarmDetail filter)
{
List <string> BarLabels = new List <string>();
List <double> BarData = new List <double>();
List <PieChartModel> PieData = new List <PieChartModel>();
using (ANDONEntities entities = new ANDONEntities())
{
var alarm_edits = entities.Alarm_edit.Where(t => t.Delete_flag == false);
if (filter.Start_time != null && filter.End_time != null)
{
DateTime startTime = Convert.ToDateTime(filter.Start_time);
DateTime endTime = Convert.ToDateTime(filter.End_time);
alarm_edits = alarm_edits.Where(t => t.Start_time >= startTime && t.End_time <= endTime);
}
if (!String.IsNullOrEmpty(filter.Alarm_area) && !(filter.Alarm_area == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area);
}
if (!String.IsNullOrEmpty(filter.Division_of_respon) && !(filter.Division_of_respon == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Division_of_respon == filter.Division_of_respon);
}
if (!String.IsNullOrEmpty(filter.Responsible) && !(filter.Responsible == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Responsible == filter.Responsible);
}
if (!String.IsNullOrEmpty(filter.Recorder))
{
alarm_edits = alarm_edits.Where(t => t.Recorder.Contains(filter.Recorder));
}
int totalCount = alarm_edits.Count();
var responsibleGroup = alarm_edits.GroupBy(t => t.Responsible).OrderByDescending(t => t.Count());
int counter = 0;
//double totalRatio = 0;
int barOtherCount = 0;
foreach (IGrouping <string, Alarm_edit> item in responsibleGroup)
{
if (counter == 9)
{
break;
}
int count = item.Count();
if (string.IsNullOrEmpty(item.Key))
{
BarLabels.Add("空");
}
else
{
BarLabels.Add(item.Key);
}
//double ratio = ((double)a / (double)totalCount) * 100;
//totalRatio += ratio;
//ratio=Math.Round(ratio, 2);
barOtherCount = totalCount - barOtherCount;
BarData.Add(count);
counter++;
}
BarLabels.Add("其他");
//BarData.Add(Math.Round(100 - totalRatio, 2));
BarData.Add(totalCount - barOtherCount);
counter = 0;
int otherCount = 0;
var DGroup = alarm_edits.GroupBy(t => t.Division_of_respon).Select(t => (new { name = t.Key, count = t.Count() })).OrderByDescending(t => t.count);
foreach (var item in DGroup)
{
if (counter == 9)
{
break;
}
string name = "";
if (string.IsNullOrEmpty(item.name))
{
name = "空";
}
else
{
name = item.name;
}
PieChartModel model = new PieChartModel {
name = name, value = item.count
};
PieData.Add(model);
otherCount += item.count;
counter++;
}
PieChartModel pModel = new PieChartModel {
name = "其他", value = totalCount - otherCount
};
PieData.Add(pModel);
}
return(Json(new
{
BarLabels = BarLabels,
BarData = BarData,
PieData = PieData
}
, JsonRequestBehavior.AllowGet));
}
public ActionResult GetAlarmTimeData(FilterForAlarmDetail filter)
{
List <string> BarLabels = new List <string>();
List <double> BarData = new List <double>();
int totalCount = 0;
using (ANDONEntities entities = new ANDONEntities())
{
var alarm_edits = entities.Alarm_edit.Where(t => t.Delete_flag == false);
if (filter.Start_time != null && filter.End_time != null)
{
DateTime startTime = Convert.ToDateTime(filter.Start_time);
DateTime endTime = Convert.ToDateTime(filter.End_time);
alarm_edits = alarm_edits.Where(t => t.Start_time >= startTime && t.End_time <= endTime);
}
if (!String.IsNullOrEmpty(filter.Alarm_area) && !(filter.Alarm_area == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area);
}
if (!String.IsNullOrEmpty(filter.Division_of_respon) && !(filter.Division_of_respon == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Division_of_respon == filter.Division_of_respon);
}
if (!String.IsNullOrEmpty(filter.Responsible) && !(filter.Responsible == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Responsible == filter.Responsible);
}
if (!String.IsNullOrEmpty(filter.Recorder))
{
alarm_edits = alarm_edits.Where(t => t.Recorder.Contains(filter.Recorder));
}
//totalCount = alarm_edits.Count();
var Group = alarm_edits.GroupBy(t => t.Reason);
List <TimeReportReuslt> timeList = new List <TimeReportReuslt>();
//double totalRatio = 0;
foreach (IGrouping <string, Alarm_edit> item in Group)
{
TimeReportReuslt model = new TimeReportReuslt();
if (string.IsNullOrEmpty(item.Key))
{
model.Name = "空";
//BarLabels.Add("空");
}
else
{
model.Name = item.Key;
//BarLabels.Add(item.Key);
}
int timeCount = 0;
foreach (Alarm_edit e in item)
{
int seconds = string.IsNullOrEmpty(e.Duration) ? 0 : Convert.ToInt32(e.Duration);
timeCount += seconds;
}
totalCount += timeCount;
model.Secondes = timeCount;
//BarData.Add(timeCount);
timeList.Add(model);
}
foreach (var item in timeList.OrderByDescending(t => t.Secondes).Take(10))
{
BarLabels.Add(item.Name);
BarData.Add(item.Secondes);
}
//BarLabels.Add("其他");
//BarData.Add(Math.Round(100 - totalRatio, 2));
}
return(Json(new
{
totalCount = totalCount,
BarLabels = BarLabels,
BarData = BarData,
}
, JsonRequestBehavior.AllowGet));
}
public ActionResult AlarmDetailExoprt(FilterForAlarmDetail filter)
{
using (ANDONEntities entities = new ANDONEntities())
{
var alarm_edits = entities.Alarm_edit.Where(t => t.Delete_flag == false);
if (filter.Start_time != null && filter.End_time != null)
{
DateTime startTime = Convert.ToDateTime(filter.Start_time);
DateTime endTime = Convert.ToDateTime(filter.End_time);
alarm_edits = alarm_edits.Where(t => t.Start_time >= startTime && t.Start_time <= endTime);
}
if (!String.IsNullOrEmpty(filter.Alarm_area) && !(filter.Alarm_area == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area);
}
if (!String.IsNullOrEmpty(filter.Division_of_respon) && !(filter.Division_of_respon == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Division_of_respon == filter.Division_of_respon);
}
if (!String.IsNullOrEmpty(filter.Responsible) && !(filter.Responsible == "全部"))
{
alarm_edits = alarm_edits.Where(t => t.Responsible == filter.Responsible);
}
if (!String.IsNullOrEmpty(filter.Recorder))
{
alarm_edits = alarm_edits.Where(t => t.Recorder.Contains(filter.Recorder));
}
alarm_edits = alarm_edits.OrderByDescending(t => t.Start_time);
var result = (from a in alarm_edits
select new AlarmDetailViewModel
{
Start_time = a.Start_time,
End_time = a.End_time,
Station = a.Station,
Reason = a.Reason,
Responsible = a.Responsible,
Duration = a.Duration,
Division_of_respon = a.Division_of_respon,
Position = a.Position,
Recorder = a.Recorder,
Alarm_class = a.Alarm_class
}).ToList();
List <AlarmDetailExport> exportList = (from r in result
select new AlarmDetailExport
{
开始时间 = r.Start_time,
结束时间 = r.End_time,
持续时间 = r.DurationStr,
呼叫类型 = r.Alarm_class,
停线工位 = r.Station,
编辑人 = r.Recorder,
停线原因 = r.Reason,
位置信息 = r.Position,
责任部门 = r.Responsible,
责任类型 = r.Division_of_respon
}).ToList();
DataTable dt = Untils.ToDataTable <AlarmDetailExport>(exportList);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
//row1.RowStyle.FillBackgroundColor = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
row1.CreateCell(i).SetCellValue(dt.Columns[i].ColumnName);
}
//将数据逐步写入sheet1各个行
for (int i = 0; i < dt.Rows.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
for (int j = 0; j < dt.Columns.Count; j++)
{
rowtemp.CreateCell(j).SetCellValue(dt.Rows[i][j].ToString().Trim());
}
}
string strdate = DateTime.Now.ToString("yyyyMMddhhmmss");//获取当前时间
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", "AlarmDetail" + strdate + "Excel.xls"));
}
}