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));
}
