public ActionResult ExportProfileSuspenseListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_SuspenseSearchModel model) { #region Tao template HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom == null ? DateTime.Now : model.DateFrom }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo == null ? DateTime.Now : model.DateTo }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_StopWorkingModel(), FileName = "Hre_StopWorking", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #endregion string status = string.Empty; // var isDataTable = false; object obj = new Hre_ProfileModel(); var actionService = new ActionService(UserLogin); var lstObj = new List<object>(); lstObj.Add(model.ProfileName); lstObj.Add(model.CodeEmp); lstObj.Add(model.JobTitleID); lstObj.Add(model.PositionID); lstObj.Add(model.OrgStructureID); lstObj.Add(model.DateFrom); lstObj.Add(model.DateTo); lstObj.Add(model.TypeSuspense); lstObj.Add(model.Status); lstObj.Add(model.StatusComeBack); lstObj.Add(model.RequestDateComebackFrom); lstObj.Add(model.RequestDateComebackTo); lstObj.Add(model.DateComebackFrom); lstObj.Add(model.DateComebackTo); lstObj.Add(model.RankID); lstObj.Add(model.IsCreateTemplate); lstObj.Add(model.ExportId); lstObj.Add(model.ExportType); lstObj.Add(1); lstObj.Add(int.MaxValue - 1); var lisObjClas = new List<object>(); lisObjClas.AddRange(new object[3]); lisObjClas[1] = 1; lisObjClas[2] = int.MaxValue - 1; var lisObjRank = new List<object>(); lisObjRank.AddRange(new object[4]); lisObjRank[2] = 1; lisObjRank[3] = int.MaxValue - 1; var listResult = actionService.GetData<Hre_StopWorkingEntity>(lstObj, ConstantSql.hrm_hr_sp_get_ProfileSuspense, ref status).Translate<Hre_StopWorkingModel>(); var lisClass = actionService.GetData<Cat_SalaryClassEntity>(lisObjClas,ConstantSql.hrm_cat_sp_get_SalaryClass, ref status); var lisRank = actionService.GetData<Cat_SalaryRankEntity>(lisObjRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status); foreach (var item in listResult) { var lisClassbyproid = lisClass.Where(s => s.ID == item.SalaryClassID).FirstOrDefault(); var lisRankbyclassid = lisRank.Where(s => lisClassbyproid !=null && s.SalaryClassID == lisClassbyproid.ID).FirstOrDefault(); item.SalaryRankName = lisRankbyclassid != null ? lisRankbyclassid.SalaryRankName : string.Empty; } var profileServices = new Hre_ProfileServices(); if (model.ExportId != Guid.Empty) { var fullPath = ExportService.Export(model.ExportId, listResult, listHeaderInfo, model.ExportType); return Json(fullPath); } return Json(listResult.ToDataSourceResult(request)); }
public ActionResult GetProfileSuspenseList([DataSourceRequest] DataSourceRequest request, Hre_SuspenseSearchModel model) { return GetListDataAndReturn<Hre_StopWorkingModel, Hre_StopWorkingEntity, Hre_SuspenseSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileSuspense); }