public ActionResult SeachEmergencyAlarm()
{
var model = new EmergencyAlarmSeachModel();
model.SearchPage = 1;
model.GPSStartTime = DateTime.Now.AddDays(-1).ToString("yyyy-M-dd 00:00:00");
model.GPSEndTime = DateTime.Now.AddDays(-1).ToString("yyyy-M-dd 23:59:59");
DataTable dt = new DataTable();
//dt.Columns.Add("StrucName", typeof(string));
//dt.Columns.Add("VehicleName", typeof(string));
//dt.Columns.Add("GPSStartTime", typeof(string));
//dt.Columns.Add("GPSEndTime", typeof(string));
//dt.Columns.Add("Time", typeof(string));
//dt.Columns.Add("DealUser", typeof(string));
//dt.Columns.Add("DealTime", typeof(string));
//dt.Columns.Add("DealInfo", typeof(string));
//DataRow dr = dt.NewRow();
//dr["StrucName"] = "南京亚士德";
//dr["VehicleName"] = "京TEX008";
//dr["GPSStartTime"] = "2016-10-10 15:04:20";
//dr["GPSEndTime"] = "2016-10-10 15:05:32";
//dr["Time"] = "1分12秒";
//dr["DealUser"] = "******";
//dr["DealTime"] = "2016-10-12 10:15:32";
//dr["DealInfo"] = "超速";
//dt.Rows.Add(dr);
//DataRow dr1 = dt.NewRow();
//dr1["StrucName"] = "南京亚士德";
//dr1["VehicleName"] = "亚A00001";
//dr1["GPSStartTime"] = "2016-10-10 17:06:52";
//dr1["GPSEndTime"] = "2016-10-10 17:08:01";
//dr1["Time"] = "1分12秒";
//dr1["DealUser"] = "******";
//dr1["DealTime"] = "2016-10-12 10:15:32";
//dr1["DealInfo"] = "滚筒停转";
//dt.Rows.Add(dr1);
//DataRow dr2 = dt.NewRow();
//dr2["StrucName"] = "南京亚士德";
//dr2["VehicleName"] = "京TEX201";
//dr2["GPSStartTime"] = "2016-10-10 17:06:52";
//dr2["GPSEndTime"] = "2016-10-10 17:08:01";
//dr2["Time"] = "1分09秒";
//dr2["DealUser"] = "******";
//dr2["DealTime"] = "2016-10-12 10:15:32";
//dr2["DealInfo"] = "超速";
//dt.Rows.Add(dr2);
//model.PagedDatas = ReportBLL.GetLostPagedSpeed(model, 1, this.PageSize, base.CurrentUserID);
List <EmergencyAlarmListModel> list = ConvertToList <EmergencyAlarmListModel> .Convert(dt);
model.PagedDatas = list.ToPagedList(1, 1, 1);
return(PartialView("_SeachEmergencyAlarm", model));
}
public ActionResult GetEmergencyAlarmInfo(EmergencyAlarmSeachModel model)
{
DataTable dt = new DataTable();
dt.Columns.Add("StrucName", typeof(string));
dt.Columns.Add("VehicleName", typeof(string));
dt.Columns.Add("GPSStartTime", typeof(string));
dt.Columns.Add("GPSEndTime", typeof(string));
dt.Columns.Add("Time", typeof(string));
dt.Columns.Add("DealUser", typeof(string));
dt.Columns.Add("DealTime", typeof(string));
dt.Columns.Add("DealInfo", typeof(string));
DataRow dr = dt.NewRow();
dr["StrucName"] = "南京亚士德";
dr["VehicleName"] = "京TEX008";
dr["GPSStartTime"] = "2016-10-10 15:04:20";
dr["GPSEndTime"] = "2016-10-10 15:05:32";
dr["Time"] = "1分12秒";
dr["DealUser"] = "******";
dr["DealTime"] = "2016-10-12 10:15:32";
dr["DealInfo"] = "超速";
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["StrucName"] = "南京亚士德";
dr1["VehicleName"] = "亚A00001";
dr1["GPSStartTime"] = "2016-10-10 17:06:52";
dr1["GPSEndTime"] = "2016-10-10 17:08:01";
dr1["Time"] = "1分09秒";
dr1["DealUser"] = "******";
dr1["DealTime"] = "2016-10-12 10:15:32";
dr1["DealInfo"] = "滚筒停转";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["StrucName"] = "南京亚士德";
dr2["VehicleName"] = "京TEX201";
dr2["GPSStartTime"] = "2016-10-10 17:06:52";
dr2["GPSEndTime"] = "2016-10-10 17:08:01";
dr2["Time"] = "1分09秒";
dr2["DealUser"] = "******";
dr2["DealTime"] = "2016-10-12 10:15:32";
dr2["DealInfo"] = "超速";
dt.Rows.Add(dr2);
DataRow dr3 = dt.NewRow();
dr3["StrucName"] = "南京亚士德";
dr3["VehicleName"] = "汇A00002";
dr3["GPSStartTime"] = "2016-10-10 15:04:20";
dr3["GPSEndTime"] = "2016-10-10 15:05:32";
dr3["Time"] = "1分12秒";
dr3["DealUser"] = "******";
dr3["DealTime"] = "2016-10-12 10:15:32";
dr3["DealInfo"] = "超速";
dt.Rows.Add(dr3);
List <EmergencyAlarmListModel> list = ConvertToList <EmergencyAlarmListModel> .Convert(dt);
model.PagedDatas = list.ToPagedList(1, 1, 1);
return(PartialView("_EmergencyAlarmGrid", model));
}
public ActionResult EmergencyAlarmToExcel(EmergencyAlarmSeachModel model)
{
//model.PagedDatas = ReportBLL.GetPagedSpeed(model, 1, Int32.MaxValue, base.CurrentUserID);
DataTable dt = new DataTable();
dt.Columns.Add("StrucName", typeof(string));
dt.Columns.Add("VehicleName", typeof(string));
dt.Columns.Add("GPSStartTime", typeof(string));
dt.Columns.Add("GPSEndTime", typeof(string));
dt.Columns.Add("Time", typeof(string));
dt.Columns.Add("DealUser", typeof(string));
dt.Columns.Add("DealTime", typeof(string));
dt.Columns.Add("DealInfo", typeof(string));
DataRow dr = dt.NewRow();
dr["StrucName"] = "南京亚士德";
dr["VehicleName"] = "京TEX008";
dr["GPSStartTime"] = "2016-10-10 15:04:20";
dr["GPSEndTime"] = "2016-10-10 15:05:32";
dr["Time"] = "1分12秒";
dr["DealUser"] = "******";
dr["DealTime"] = "2016-10-12 10:15:32";
dr["DealInfo"] = "超速";
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["StrucName"] = "南京亚士德";
dr1["VehicleName"] = "亚A00001";
dr1["GPSStartTime"] = "2016-10-10 17:06:52";
dr1["GPSEndTime"] = "2016-10-10 17:08:01";
dr1["Time"] = "1分09秒";
dr1["DealUser"] = "******";
dr1["DealTime"] = "2016-10-12 10:15:32";
dr1["DealInfo"] = "滚筒停转";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["StrucName"] = "南京亚士德";
dr2["VehicleName"] = "京TEX201";
dr2["GPSStartTime"] = "2016-10-10 17:06:52";
dr2["GPSEndTime"] = "2016-10-10 17:08:01";
dr2["Time"] = "1分09秒";
dr2["DealUser"] = "******";
dr2["DealTime"] = "2016-10-12 10:15:32";
dr2["DealInfo"] = "超速";
dt.Rows.Add(dr2);
DataRow dr3 = dt.NewRow();
dr3["StrucName"] = "南京亚士德";
dr3["VehicleName"] = "汇A00002";
dr3["GPSStartTime"] = "2016-10-10 15:04:20";
dr3["GPSEndTime"] = "2016-10-10 15:05:32";
dr3["Time"] = "1分12秒";
dr3["DealUser"] = "******";
dr3["DealTime"] = "2016-10-12 10:15:32";
dr3["DealInfo"] = "超速";
dt.Rows.Add(dr3);
List <EmergencyAlarmListModel> list = ConvertToList <EmergencyAlarmListModel> .Convert(dt);
model.PagedDatas = list.ToPagedList(1, 1, 1);
ViewBag.ExportFlag = true;
ViewData.Model = model;
string viewHtml = RenderPartialViewToString(this, "_EmergencyAlarmGrid");
var reportName = this.GetUIText(base.GetFunctionsInfo("ReportManage", "EmergencyAlarm", "SeachEmergencyAlarm").FunctionName); //功能名称
return(File(System.Text.Encoding.UTF8.GetBytes(viewHtml), "application/ms-excel", string.Format("{0}.xls", reportName + "(" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ")")));
}