public ActionResult GetNotice(FilterForAlarmEdit filter) { using (ANDONEntities entities = new ANDONEntities()) { var result = entities.Notice.FirstOrDefault(); return(Json(new { aaData = result } , JsonRequestBehavior.AllowGet)); } }
public ActionResult GetAlarmEditList(FilterForAlarmEdit 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_class) && !(filter.Alarm_class == "全部") && !(filter.Alarm_class == "非拉动停线")) { alarm_edits = alarm_edits.Where(t => t.Alarm_class == filter.Alarm_class); } if (filter.Alarm_class == "非拉动停线") { alarm_edits = alarm_edits.Where(t => t.Alarm_class != "拉动停线"); } if (!String.IsNullOrEmpty(filter.Alarm_area) && !(filter.Alarm_area == "全部")) { alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area); } int totalCount = alarm_edits.Count(); alarm_edits = alarm_edits.OrderByDescending(t => t.Start_time).Skip(filter.PageSize * (filter.PageIndex - 1)).Take(filter.PageSize); var result = from a in alarm_edits select new ALarmEditViewModel { ID = a.ID, Start_time = a.Start_time, End_time = a.End_time, Station = a.Station, Alarm_area = a.Alarm_area, Alarm_class = a.Alarm_class, Division_of_respon = a.Division_of_respon, Position = a.Position, Reason = a.Reason, Responsible = a.Responsible, Duration = a.Duration }; ; return(Json(new { iTotalDisplayRecords = totalCount, aaData = result.ToList() } , JsonRequestBehavior.AllowGet)); } }
public FileResult AlarmEditExoprt(FilterForAlarmEdit 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); } //var s = alarm_edits.ToList(); if (!String.IsNullOrEmpty(filter.Alarm_class) && !(filter.Alarm_class == "全部")) { alarm_edits = alarm_edits.Where(t => t.Alarm_class == filter.Alarm_class); } if (!String.IsNullOrEmpty(filter.Alarm_area) && !(filter.Alarm_area == "全部")) { alarm_edits = alarm_edits.Where(t => t.Alarm_area == filter.Alarm_area); } alarm_edits = alarm_edits.OrderByDescending(t => t.Start_time); var result = (from a in alarm_edits select new ALarmEditViewModel { ID = a.ID, Start_time = a.Start_time, End_time = a.End_time, Station = a.Station, Alarm_area = a.Alarm_area, Alarm_class = a.Alarm_class, Division_of_respon = a.Division_of_respon, Position = a.Position, Reason = a.Reason, Responsible = a.Responsible, Duration = a.Duration }).ToList(); List <AlarmEidtExport> exportList = (from r in result select new AlarmEidtExport { 开始时间 = r.Start_time, 结束时间 = r.End_time, 持续时间 = r.DurationStr, 呼叫类型 = r.Alarm_class, 停线工位 = r.Station, 停线区域 = r.Alarm_area, 停线原因 = r.Reason, 位置信息 = r.Position, 责任部门 = r.Responsible, 责任类型 = r.Division_of_respon }).ToList(); DataTable dt = Untils.ToDataTable <AlarmEidtExport>(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")); } }