public ActionResult VideoExprt(string txtMac, string txtAPName, string txtLName, string txtBeginTime, string txtEndTime, string txtNETBAR_WACODE) { try { UserInfo user = (UserInfo)Session["userInfo"]; if (Convert.ToDateTime(txtBeginTime) > Convert.ToDateTime(txtEndTime)) { return(Content("<script>alert('开始时间不能大于结束时间');</script>")); } int[] userType = ChangeValue.GetUserType(); Dictionary <string, string> dic = new Dictionary <string, string>() { { "txtMac", txtMac }, { "txtNETBAR_WACODE", txtNETBAR_WACODE }, { "txtLName", txtLName }, { "txtAPName", txtAPName }, { "txtBeginTime", txtBeginTime }, { "txtEndTime", txtEndTime }, { "UserType", userType[0].ToString() }, { "AreaId", userType[1].ToString() } }; if (!string.IsNullOrEmpty(txtLName)) { log.What = "场所名称:" + txtLName; } if (!string.IsNullOrEmpty(txtAPName)) { log.What += "AP名称:" + txtAPName; } if (!string.IsNullOrEmpty(txtMac)) { log.What += "AP设备MAC地址:" + txtMac; } if (!string.IsNullOrEmpty(txtNETBAR_WACODE)) { log.What += "上网服务场所编码:" + txtNETBAR_WACODE; } if (!string.IsNullOrEmpty(txtBeginTime)) { log.What += "开始时间:" + txtBeginTime; } if (!string.IsNullOrEmpty(txtEndTime)) { log.What += "结束时间:" + txtEndTime; } if (!string.IsNullOrEmpty(log.What)) { log.What = "视频数据列表导出Excel" + log.What; new OPLogDAL().InsertLog(log); } DataTable dt = new Video3CDAL().GetVideoToTable(dic); int rowCount = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ExprotCout"]); if (dt == null || dt.Rows.Count == 0) { return(Content("{\"err\":\"对不起,没有要导出的数据\"}")); } else if (dt.Rows.Count > rowCount) { return(Content("{\"err\":\"为了保证导出数据的速度,数据源不能大于“" + rowCount + "”行\"}")); } else { Dictionary <string, string> Head_Dic = new Dictionary <string, string>(); if (!string.IsNullOrEmpty(txtLName)) { Head_Dic.Add("场所名称", txtLName); } if (!string.IsNullOrEmpty(txtAPName)) { Head_Dic.Add("AP名称", txtAPName); } if (!string.IsNullOrEmpty(txtMac)) { Head_Dic.Add("AP设备MAC地址", txtMac); } if (!string.IsNullOrEmpty(txtNETBAR_WACODE)) { Head_Dic.Add("上网服务场所编码", txtNETBAR_WACODE); } if (!string.IsNullOrEmpty(txtBeginTime)) { Head_Dic.Add("开始时间", txtBeginTime); } if (!string.IsNullOrEmpty(txtEndTime)) { Head_Dic.Add("结束时间", txtEndTime); } Dictionary <string, string> Title_Dic = new Dictionary <string, string>() { { "序号", "PageNum" }, { "场所名称", "LName" }, { "AP名称", "APName" }, { "文件名", "FileName" }, { "文件大小", "FileSize" }, { "开始时间", "BeginTime" }, { "结束时间", "EndTime" }, { "创建时间", "CreateTime" } }; NPOISheetModel sheet = new NPOISheetModel(); sheet.dt = dt; sheet.ExcelTitle = "视频数据查询"; sheet.TableTitle = Title_Dic; sheet.TableSearch = Head_Dic; string path = new ComNPOIExcel().Export(sheet, Server.MapPath("~/") + "UserData/EXP/Video/"); return(Content("{\"result\":\"" + path + "\"}")); } } catch (System.Data.SqlClient.SqlException) { return(Content("{\"err\":\"检索数据遇到错误,请联系管理员\"}")); } catch (Exception ex) { Logger.ErrorLog(ex, new Dictionary <string, string>() { { "Function", this.GetType().Name + ".VideoExprt()[HttpGet]" } }); return(Content("{\"err\":\"导出文件时出错,请联系管理员\"}")); } }