public ActionResult GetReportTraineeJoinCoursePass([DataSourceRequest] DataSourceRequest request, Tra_ReportTraineeJoinCourseModel model) { string status = string.Empty; Tra_ReportServices service = new Tra_ReportServices(); Cat_PayrollGroupServices payrollGroupServices = new Cat_PayrollGroupServices(); ActionService service1 = new ActionService(UserLogin); var hrService = new Hre_ProfileServices(); Guid[] _RankIDs = null; if (model.RankID != null) _RankIDs = model.RankID.Split(',').Select(s => Guid.Parse(s)).ToArray(); Guid[] _CourseIDs = null; if (model.CourseID != null) _CourseIDs = model.CourseID.Split(',').Select(s => Guid.Parse(s)).ToArray(); Guid[] _RequirementTrainIDs = null; if (model.RequirementTrainID != null) { _RequirementTrainIDs = model.RequirementTrainID.Split(',').Select(s => Guid.Parse(s)).ToArray(); } //List<object> strOrgIDs = new List<object>(); //strOrgIDs.AddRange(new object[3]); //strOrgIDs[0] = (object)model.OrgStructureID; //List<Guid> lstProfileIDs = hrService.GetData<Hre_ProfileIdEntity>(strOrgIDs, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList(); DataTable result = service.GetReportTraineeJoinCoursePass(_CourseIDs, model.OrgStructureID, model.IsCreateTemplate, _RequirementTrainIDs, UserLogin); //HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom }; //HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo }; //List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; #region Xử lý cách export mới var isDataTable = false; DataTable obj = null; if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Tra_ReportTraineeJoinCourseEntity", OutPutPath = path, // HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #endregion if (model.ExportId != Guid.Empty) { var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportTraineeJoinCourse([DataSourceRequest] DataSourceRequest request, Tra_ReportTraineeJoinCourseModel model) { string status = string.Empty; Tra_ReportServices service = new Tra_ReportServices(); Cat_PayrollGroupServices payrollGroupServices = new Cat_PayrollGroupServices(); ActionService service1 = new ActionService(UserLogin); var hrService = new Hre_ProfileServices(); Guid[] _RankIDs = null; if (model.RankID != null) _RankIDs = model.RankID.Split(',').Select(s => Guid.Parse(s)).ToArray(); string[] _CourseIDs = null; if (model.CourseID != null) _CourseIDs = model.CourseID.Split(',').ToArray(); List<object> strOrgIDs = new List<object>(); strOrgIDs.AddRange(new object[3]); strOrgIDs[0] = (object)model.OrgStructureID; // List<Guid> lstProfileIDs = hrService.GetData<Hre_ProfileIdEntity>(strOrgIDs, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList(); DataTable result = service.GetReportTraineeJoinCourse(_RankIDs, _CourseIDs, model.OrgStructureID, model.IsCreateTemplate, model.DateSeniory, UserLogin); #region Xử lý cách export mới var isDataTable = false; DataTable obj = null; if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Tra_ReportTraineeJoinCourseEntity", OutPutPath = path, // HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #endregion if (model.ExportId != Guid.Empty) { var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } if (model.IsAllPage) { string strCodeEmp = ""; foreach (DataRow item in result.Rows) { strCodeEmp += item[Tra_ReportTraineeJoinCourseEntity.FieldNames.CodeEmp] + ","; } return Json(strCodeEmp, JsonRequestBehavior.AllowGet); //ViewBag.checkAll = strCodeEmp; } return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = Int32.MaxValue, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; // return Json(result.ToDataSourceResult(request)); }