public ActionResult GetAttendanceExportData3(string queryJson) { var user = OperatorProvider.Provider.Current(); var queryParam = queryJson.ToJObject(); var bll = new WorkmeetingBLL(); var deptid = string.Empty; var name = string.Empty; var nowTime = DateTime.Now; var start = new DateTime(nowTime.Year, nowTime.Month, 1); var end = start.AddMonths(1); //deptid if (!queryParam["deptid"].IsEmpty()) { string pdeptid = queryParam["deptid"].ToString(); var tree = new DepartmentBLL().GetSubDepartments(pdeptid, ""); deptid = string.Join(",", tree.Select(x => x.DepartmentId)); } //name deptname if (!queryParam["name"].IsEmpty()) { name = queryParam["name"].ToString(); } // start if (!queryParam["Start"].IsEmpty()) { start = Convert.ToDateTime(queryParam["Start"].ToString()); } //end if (!queryParam["End"].IsEmpty()) { end = Convert.ToDateTime(queryParam["End"].ToString()); } var isMenu = getMenu(); //取出数据源 int total = 0; DataTable exportTable = bll.GetAttendanceExportData3(name, deptid, start, end, isMenu); //设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); //excelconfig.Title = "违章信息"; //excelconfig.TitleFont = "微软雅黑"; //excelconfig.TitlePoint = 25; excelconfig.HeadHeight = 50; excelconfig.HeadPoint = 12; excelconfig.HeadFont = "宋体"; excelconfig.FileName = "考情统计导出.xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 List <ColumnEntity> listColumnEntity = new List <ColumnEntity>(); excelconfig.ColumnEntity = listColumnEntity; //ColumnEntity columnentity = new ColumnEntity(); //excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "jobcontent", ExcelColumn = "作业内容", Width = 12, Alignment = "fill" }); //excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "workquarters", ExcelColumn = "作业岗位", Width = 15 }); //调用导出方法 ExcelHelper.ExcelDownload(exportTable, excelconfig); return(Content(null)); }