public ProductChange GetProductChange(string plot, int yCoordenates) { //ContractNumberDue or Funding? ProductChange e = ProductChanges.FirstOrDefault(x => plot.Substring(3, 12).Trim() == x.FundingNumber); if (e != null) { e.State = "AUTORIZADO"; ehllapi.SetCursorPos(yCoordenates + ",2"); EhllapiWrapper.Wait(); ehllapi.SendStr("X"); EhllapiWrapper.Wait(); ehllapi.SendStr("@E"); EhllapiWrapper.Wait(); ehllapi.SendStr("@1"); EhllapiWrapper.Wait(); ehllapi.SendStr("@E"); EhllapiWrapper.Wait(); } e.Plot = plot; return(e); }
public void GetProductChangeDataFromExcelConfig(string excelPath) { List <ProductChange> lstProductChangeData = null; try { using (var package = new ExcelPackage(new FileInfo(excelPath))) { var workbook = package.Workbook; var worksheet = workbook.Worksheets["APROBACIÓN"]; var totalRow = worksheet.Dimension.End.Row; //string patron = @"[^\d+]"; //Regex regex = new Regex(patron); lstProductChangeData = new List <ProductChange>(); for (int i = 2; i <= totalRow; i++) { //if (worksheet.Cells["B" + i].Value != null && worksheet.Cells["C" + i].Value != null && // worksheet.Cells["D" + i].Value != null && worksheet.Cells["E" + i].Value != null && // worksheet.Cells["F" + i].Value != null) if (!String.IsNullOrEmpty(Convert.ToString(worksheet.Cells["A" + i].Value).Trim()) && !String.IsNullOrEmpty(Convert.ToString(worksheet.Cells["C" + i].Value).Trim())) { if (Convert.ToString(worksheet.Cells["E" + i].Value).Trim() == "CARGADO") { ProductChange productChangeData = new ProductChange() { FundingNumber = (worksheet.Cells["A" + i].Value ?? "").ToString().Trim(), Product = (worksheet.Cells["C" + i].Value ?? "").ToString().Trim() }; lstProductChangeData.Add(productChangeData); } } else { ProductChange productChangeData = new ProductChange() { State = "ERROR" }; lstProductChangeData.Add(productChangeData); } } } } #pragma warning disable CS0168 // La variable 'e' se ha declarado pero nunca se usa catch (Exception e) #pragma warning restore CS0168 // La variable 'e' se ha declarado pero nunca se usa { //TODO: especificar error que no se ha leído correctamente el archivo de configuracón disbursement config //Methods.LogProceso(e.ToString()); } ProductChanges = lstProductChangeData; }