public string ExcelReport(DataSourceLoadOptions loadOptions, string test, bool?showSelected, string selectedRecord, bool?only_new, bool?show_classified, string ekk_guid_list) { int?event_id = null; PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); //List<UI_SELECT_GRID_SETTINGS2Result> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS2(au.id, "PRC_SELECT_ORDER_ITEMS_GKI").ToList(); APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user")); List <PRC_SELECT_ORDER_ITEMS_GKIResult> x = null; if (HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult") && HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified") && HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new") & JsonConvert.DeserializeObject <bool?>(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified")) == show_classified & JsonConvert.DeserializeObject <bool?>(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new")) == only_new) { x = JsonConvert.DeserializeObject <List <PRC_SELECT_ORDER_ITEMS_GKIResult> >(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult")); } else { event_id = portalDMTOS.SYS_START_EVENT(delegated_user.id, "PRC_SELECT_ORDER_ITEMS_GKI", Convert.ToString(show_classified) + "," + Convert.ToString(only_new) + "," + Convert.ToString(delegated_user.id)).FirstOrDefault().event_id; x = portalDMTOS.PRC_SELECT_ORDER_ITEMS_GKI(show_classified, only_new, ekk_guid_list, delegated_user.id, event_id).ToList(); HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult", JsonConvert.SerializeObject(x)); HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new", JsonConvert.SerializeObject(only_new)); HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified", JsonConvert.SerializeObject(show_classified)); } int[] selectedRecordMass = null; if (selectedRecord != null && selectedRecord != "") { selectedRecordMass = selectedRecord.Split(',').Select(Int32.Parse).ToArray(); } if (Convert.ToBoolean(showSelected)) { x = x.Join(selectedRecordMass, y => y.id, m => m, (y, m) => y).ToList(); } DevExtreme.AspNet.Data.ResponseModel.LoadResult loadrResults = DataSourceLoader.Load(x, loadOptions); string j = JsonConvert.SerializeObject(loadrResults.data); List <PRC_SELECT_ORDER_ITEMS_GKIResult> list = JsonConvert.DeserializeObject <List <PRC_SELECT_ORDER_ITEMS_GKIResult> >(j); string templatePath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\Templates\\ExcelTemplates", "PRC_SELECT_ORDER_ITEMS_GKI" + ".xlsx"); Guid guid = Guid.NewGuid(); string physicalPath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\Templates\\ExcelTemplates", guid + ".xlsx"); System.IO.File.Copy(templatePath, physicalPath); //ExcelReports<PRC_SELECT_ORDER_ITEMS_GKIResult> excel = // new ExcelReports<PRC_SELECT_ORDER_ITEMS_GKIResult>(x,1,1, grid_settings, physicalPath, "PRC_SELECT_ORDER_ITEMS_GKI", 0, null,()=> portalDMTOS.PRC_SELECT_ORDER_ITEMS_GKI(show_classified, only_new, delegated_user.id, event_id).ToList()); ExcelReports <PRC_SELECT_ORDER_ITEMS_GKIResult> excel = new ExcelReports <PRC_SELECT_ORDER_ITEMS_GKIResult>(x, 1, 1, delegated_user.id, physicalPath, "PRC_SELECT_ORDER_ITEMS_GKI", 0, null); excel.ExcelReport(); if (event_id != null) { portalDMTOS.SYS_FINISH_EVENT(event_id, physicalPath); } return(Convert.ToString(guid)); }
public string ExcelReport(DataSourceLoadOptions loadOptions, bool?showSelected, string selectedRecord) { PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user")); List <OMC_SELECT_SVRResult> x = null; int?event_id = null; if (HttpContext.Session.Keys.Contains("OMC_SELECT_SVR")) { x = JsonConvert.DeserializeObject <List <OMC_SELECT_SVRResult> >(HttpContext.Session.GetString("OMC_SELECT_SVR")); } else { event_id = portalDMTOS.SYS_START_EVENT(delegated_user.id, "OMC_SELECT_SVR", "").FirstOrDefault().event_id; x = portalDMTOS.OMC_SELECT_SVR(event_id, null, delegated_user.id, au.id).ToList(); HttpContext.Session.SetString("OMC_SELECT_SVRResult", JsonConvert.SerializeObject(x)); } int[] selectedRecordMass = null; if (selectedRecord != null && selectedRecord != "") { selectedRecordMass = selectedRecord.Split(',').Select(Int32.Parse).ToArray(); } if (Convert.ToBoolean(showSelected)) { x = x.Join(selectedRecordMass, y => y.id, m => m, (y, m) => y).ToList(); } DevExtreme.AspNet.Data.ResponseModel.LoadResult loadrResults = DataSourceLoader.Load(x, loadOptions); string j = JsonConvert.SerializeObject(loadrResults.data); List <OMC_SELECT_SVRResult> list = JsonConvert.DeserializeObject <List <OMC_SELECT_SVRResult> >(j); string templatePath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExcelTemplates", "EMPTY" + ".xlsx"); Guid guid = Guid.NewGuid(); string physicalPath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExportFiles", guid + ".xlsx"); System.IO.File.Copy(templatePath, physicalPath); ExcelReports <OMC_SELECT_SVRResult> excel = new ExcelReports <OMC_SELECT_SVRResult>(list, 1, 1, delegated_user.id, physicalPath, "OMC_SELECT_SVR", 0, null); excel.ExcelReport(); if (event_id != null) { portalDMTOS.SYS_FINISH_EVENT(event_id, physicalPath); } return(Convert.ToString("ExportFiles\\" + guid + ".xlsx")); }