public string SaveEvalutionData(int year, Guid? TimesGetDataID, string orgStructureID, DateTime? _dateStart, DateTime? _dateEnd,string userLogin) { using (var context = new VnrHrmDataContext()) { var evaServices = new Eva_ReportServices(); List<Eva_EvalutionDataEntity> lstEvalutionDataEntity = new List<Eva_EvalutionDataEntity>(); lstEvalutionDataEntity = evaServices.SummaryEvalutionData(year, TimesGetDataID, orgStructureID, _dateStart, _dateEnd,userLogin); var unitOfWork = (IUnitOfWork)new UnitOfWork(context); var repoEva_EvalutionData = new CustomBaseRepository<Eva_EvalutionData>(unitOfWork); List<Eva_EvalutionData> lstEvalutionData = new List<Eva_EvalutionData>(); lstEvalutionData = lstEvalutionDataEntity.Translate<Eva_EvalutionData>(); if (lstEvalutionData != null) { int _total = lstEvalutionData.Count; int _totalPage = _total / 200 + 1; int _pageSize = 200; for (int _page = 1; _page <= _totalPage; _page++) { int _skip = _pageSize * (_page - 1); var _listCurrenPage = lstEvalutionData.Skip(_skip).Take(_pageSize).ToList(); foreach (var item in _listCurrenPage) { repoEva_EvalutionData.Add(item); } unitOfWork.SaveChanges(); } } return "SaveSuccess"; // #endregion } }
public ActionResult GetReportHCSales([DataSourceRequest] DataSourceRequest request, Hre_ReportHCSalesModel model) { var service = new Hre_ReportServices(); var eva_Service = new Eva_ReportServices(); var hrService = new Hre_ProfileServices(); //List<object> listObj = new List<object>(); //listObj.Add(model.OrgStructureID); //listObj.Add(string.Empty); //listObj.Add(string.Empty); //string status = string.Empty; //var listEntity = hrService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList(); var result = eva_Service.GetReportHCSales(model.dateSearch, model.OrgStructureID, model.IsCreateTemplate, UserLogin); //var rs = result.Translate<Hre_ReportMonthlyHCModel>(); HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; object obj = new Hre_ReportHCSalesModel(); var isDataTable = false; 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 = "Hre_ReportHCSalesModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { //var row = result.Rows.Count; // result.Rows[row - 1].Delete(); var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType); return Json(fullPath); } //0string dataReturn = result.ConvertDataTabletoString(); return Json(result.ToDataSourceResult(request)); }