public ActionResult GetReportKaizenAccumulate([DataSourceRequest] DataSourceRequest request, Kai_ReportKaizenDetailModel model) { string status = string.Empty; var service = new Hre_ReportServices(); var actionService = new ActionService(UserLogin); #region Validate 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 }; string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Kai_ReportKaizenDetailModel>(model, "Kai_ReportKaizenDetail", ref message); if (!checkValidate) { var ls = new object[] { "error", message }; return Json(ls); } #endregion List<object> listObj = new List<object>(); listObj.Add(model.OrgStructureID); listObj.Add(model.DateFrom); listObj.Add(model.DateTo); List<Kai_ReportKaizenDetailEntity> lstKaizenDetailEntity = actionService.GetData<Kai_ReportKaizenDetailEntity>(listObj, ConstantSql.hrm_sal_sp_get_RptKaizenDataAccumulate, ref status); var result = service.GetReportKaizenAccumulate(lstKaizenDetailEntity, model.DateFrom, model.DateTo, model.RateDetail, model.IsCreateTemplate); var isDataTable = false; object obj = new DataTable(); if (model.IsCreateTemplateForDynamicGrid) { var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); 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 = "Kai_ReportKaizenDetailEntity", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable, HeaderInfo = listHeaderInfo, }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType); return Json(fullPath); } return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = int.MaxValue }; }
public ActionResult GetReportKaizenMonthly([DataSourceRequest] DataSourceRequest request, Kai_ReportKaizenDetailModel Model) { string status = string.Empty; var actionService = new ActionService(UserLogin); var isDataTable = false; object obj = new Kai_ReportKaizenDetailModel(); #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Kai_ReportKaizenDetailModel>(Model, "Kai_ReportCTKaizenDataMonthly", ref message); if (!checkValidate) { return Json(message); } #endregion List<object> listObj = new List<object>(); listObj.Add(Model.OrgStructureID); listObj.Add(null); listObj.Add(null); listObj.Add(null); listObj.Add(null); var result = actionService.GetData<Kai_ReportKaizenDetailEntity>(listObj, ConstantSql.hrm_sal_sp_get_RptKaizenDataDetail, ref status).Where(s => s.MonthReport != null && s.YearReport != null && s.MonthReport == Model.DateFrom.Value.Month && s.YearReport == Model.DateFrom.Value.Year && (s.IsPaymentOut == false || s.IsPaymentOut == null)).ToList().Translate<Kai_ReportKaizenDetailModel>(); 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 }; if (Model != null && 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 = new Kai_ReportKaizenDetailModel(), FileName = "Kai_ReportKaizenDetail", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }