public ActionResult Report_L_By_Department_BDX(int pageIndex, int pageSize, string filter = "", string startdate2 = "", string enddate2 = "") { var db = new ReportLDAL(); ViewBag.pageIndex = pageIndex; ViewBag.pageSize = pageSize; int?total = 0; TableColumnsTotal totalColumns = new TableColumnsTotal(); var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, PageIndex = pageIndex, PageSize = pageSize, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var result = db.Report_L_By_Department_BDX(baseListParam, startdate2, enddate2, out total, out totalColumns); return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = totalColumns, userid = baseListParam.UserId }))); }
public ActionResult Report_L_By_Department_BDXExportExcel(int pageIndex, int pageSize, string filter = "", string startdate2 = "", string enddate2 = "") { DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[23] { new DataColumn(AppRes.DeptName), new DataColumn(AppRes.L0_1), new DataColumn(AppRes.L0_2), new DataColumn(AppRes.L0_3), new DataColumn(AppRes.L0_4), new DataColumn(AppRes.L1_1), new DataColumn(AppRes.L1_2), new DataColumn(AppRes.L1_3), new DataColumn(AppRes.L1_4), new DataColumn(AppRes.L2_1), new DataColumn(AppRes.L2_2), new DataColumn(AppRes.L2_3), new DataColumn(AppRes.L2_4), new DataColumn(AppRes.L3_1), new DataColumn(AppRes.L3_2), new DataColumn(AppRes.L3_3), new DataColumn(AppRes.L3_4), new DataColumn(AppRes.L4_1), new DataColumn(AppRes.L4_2), new DataColumn(AppRes.L5), new DataColumn(AppRes.L6_1), new DataColumn(AppRes.L6_2), new DataColumn(AppRes.Total) }); dt.Columns[0].DataType = typeof(string); dt.Columns[1].DataType = typeof(double); dt.Columns[2].DataType = typeof(double); dt.Columns[3].DataType = typeof(double); dt.Columns[4].DataType = typeof(double); dt.Columns[5].DataType = typeof(double); dt.Columns[6].DataType = typeof(double); dt.Columns[7].DataType = typeof(double); dt.Columns[8].DataType = typeof(double); dt.Columns[9].DataType = typeof(double); dt.Columns[10].DataType = typeof(double); dt.Columns[11].DataType = typeof(double); dt.Columns[12].DataType = typeof(double); dt.Columns[13].DataType = typeof(double); dt.Columns[14].DataType = typeof(double); dt.Columns[15].DataType = typeof(double); dt.Columns[16].DataType = typeof(double); dt.Columns[17].DataType = typeof(double); dt.Columns[18].DataType = typeof(double); dt.Columns[19].DataType = typeof(double); dt.Columns[20].DataType = typeof(double); dt.Columns[21].DataType = typeof(double); dt.Columns[22].DataType = typeof(double); var db = new ReportLDAL(); int?total = 0; TableColumnsTotal totalColumns = new TableColumnsTotal(); var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", PageIndex = pageIndex, PageSize = 50000, UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var lstData = db.Report_L_By_Department_BDX(baseListParam, startdate2, enddate2, out total, out totalColumns); foreach (var item in lstData) { dt.Rows.Add( item.department == null ? "" : item.department, item.L0_1 = item.L0_1, item.L0_2 = item.L0_2, item.L0_3 = item.L0_3, item.L0_4 = item.L0_4, item.L1_1 = item.L1_1, item.L1_2 = item.L1_2, item.L1_3 = item.L1_3, item.L1_4 = item.L1_4, item.L2_1 = item.L2_1, item.L2_2 = item.L2_2, item.L2_3 = item.L2_3, item.L2_4 = item.L2_4, item.L3_1 = item.L3_1, item.L3_2 = item.L3_2, item.L3_3 = item.L3_3, item.L3_4 = item.L3_4, item.L4_1 = item.L4_1, item.L4_2 = item.L4_2, item.L5 = item.L5, item.L6_1 = item.L6_1, item.L6_2 = item.L6_2, item.Total = item.Total ); } var wb = new XLWorkbook(); wb.Worksheets.Add(dt); byte[] data = null; using (var stream = new MemoryStream()) { wb.SaveAs(stream); data = stream.ToArray(); } var excelName = "Report_L_By_Department_BDX.xlsx"; return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName)); }