/// <summary> /// Verifica se as colunas existem /// </summary> /// <param name="dr"></param> /// <returns></returns> public MapaColunaCrgDetalhe CriaMapaColuna(DataRow dr) { DataColumnCollection dcc = dr.Table.Columns; MapaColunaCrgDetalhe mcCrgDet = new MapaColunaCrgDetalhe() { CodPrgCrg = -1, TpIdentif = -1, Identificacao = -1, Valor = -1, IdRegistro = -1 }; if (dcc.Contains("CodPrgCrg")) mcCrgDet.CodPrgCrg = dcc["CodPrgCrg"].Ordinal; if (dcc.Contains("TpIdentif")) mcCrgDet.TpIdentif = dcc["TpIdentif"].Ordinal; if (dcc.Contains("Identificacao")) mcCrgDet.Identificacao = dcc["Identificacao"].Ordinal; if (dcc.Contains("Valor")) mcCrgDet.Valor = dcc["Valor"].Ordinal; if(dcc.Contains("IdRegistro")) mcCrgDet.IdRegistro = dcc["IdRegistro"].Ordinal; return mcCrgDet; }
/// <summary> /// Verifica se as colunas existem /// </summary> /// <param name="dr"></param> /// <returns></returns> public MapaColunaCrgDetalhe CriaMapaColuna(DataRow dr) { DataColumnCollection dcc = dr.Table.Columns; MapaColunaCrgDetalhe mcCrgDet = new MapaColunaCrgDetalhe() { CodPrgCrg = -1, TpIdentif = -1, Identificacao = -1, Valor = -1, IdRegistro = -1 }; if (dcc.Contains("CodPrgCrg")) { mcCrgDet.CodPrgCrg = dcc["CodPrgCrg"].Ordinal; } if (dcc.Contains("TpIdentif")) { mcCrgDet.TpIdentif = dcc["TpIdentif"].Ordinal; } if (dcc.Contains("Identificacao")) { mcCrgDet.Identificacao = dcc["Identificacao"].Ordinal; } if (dcc.Contains("Valor")) { mcCrgDet.Valor = dcc["Valor"].Ordinal; } if (dcc.Contains("IdRegistro")) { mcCrgDet.IdRegistro = dcc["IdRegistro"].Ordinal; } return(mcCrgDet); }
/// <summary> /// Mapeia a partir da leitura Excel /// </summary> /// <param name="port"></param> /// <param name="dr"></param> public static List <ValidationResult> Mapeia(this ACSOPRGCRDetalheEN detCrgEn, DataRow dr, MapaColunaCrgDetalhe mapa) { List <ValidationResult> resultValid = new List <ValidationResult>(); try { //Obrigatórios //PanProxy if (mapa.TpIdentif > -1) { detCrgEn.TpPanProxy = (TipoPanProxy)Convert.ToByte(dr[mapa.TpIdentif].ToString()); } else { resultValid.Add(new ValidationResult("Tipo da Identificação deve ser preenchida.", new[] { "TpIdentif" })); } if (mapa.Identificacao > -1) { detCrgEn.Identificacao = dr[mapa.Identificacao].ToString(); } else { resultValid.Add(new ValidationResult("Identificação deve ser preenchida.", new[] { "Identificacao" })); } if (mapa.CodPrgCrg > -1) { detCrgEn.CodPrgCrg = dr[mapa.CodPrgCrg].ToString(); } else { resultValid.Add(new ValidationResult("Código do programa de carga.", new[] { "CodPrgCrg" })); } if (mapa.Identificacao > -1) { detCrgEn.PanProxy = dr[mapa.Identificacao].ToString(); } else { resultValid.Add(new ValidationResult("Pan/Proxy deve ser preenchida.", new[] { "Pan/Proxy" })); } if (mapa.Valor > -1) { detCrgEn.Valor = Convert.ToDecimal(dr[mapa.Valor].ToString()); } else { resultValid.Add(new ValidationResult("Valor da carga deve ser preenchido.", new[] { "Valor" })); } string idRegistro = dr["IdRegistro"].ToString(); detCrgEn.IdRegistro = (!String.IsNullOrEmpty(idRegistro)) ? idRegistro : null; detCrgEn.IdEntidade = dr["idEntidade"].ToString(); } catch (Exception e) { if (upSight.Consulta.Base.BD.Geral.TS.TraceError) { Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOPRGCR.PtrCN", e }); } throw; } return(resultValid); }
/// <summary> /// Mapeia a partir da leitura Excel /// </summary> /// <param name="port"></param> /// <param name="dr"></param> public static List<ValidationResult> Mapeia(this ACSOPRGCRDetalheEN detCrgEn, DataRow dr, MapaColunaCrgDetalhe mapa) { List<ValidationResult> resultValid = new List<ValidationResult>(); try { //Obrigatórios //PanProxy if (mapa.TpIdentif > -1) detCrgEn.TpPanProxy = (TipoPanProxy)Convert.ToByte(dr[mapa.TpIdentif].ToString()); else resultValid.Add(new ValidationResult("Tipo da Identificação deve ser preenchida.", new[] { "TpIdentif" })); if (mapa.Identificacao > -1) detCrgEn.Identificacao = dr[mapa.Identificacao].ToString(); else resultValid.Add(new ValidationResult("Identificação deve ser preenchida.", new[] { "Identificacao" })); if (mapa.CodPrgCrg > -1) detCrgEn.CodPrgCrg = dr[mapa.CodPrgCrg].ToString(); else resultValid.Add(new ValidationResult("Código do programa de carga.", new[] { "CodPrgCrg" })); if (mapa.Identificacao > -1) detCrgEn.PanProxy = dr[mapa.Identificacao].ToString(); else resultValid.Add(new ValidationResult("Pan/Proxy deve ser preenchida.", new[] { "Pan/Proxy" })); if (mapa.Valor > -1) detCrgEn.Valor = Convert.ToDecimal(dr[mapa.Valor].ToString()); else resultValid.Add(new ValidationResult("Valor da carga deve ser preenchido.", new[] { "Valor" })); string idRegistro = dr["IdRegistro"].ToString(); detCrgEn.IdRegistro = (!String.IsNullOrEmpty(idRegistro)) ? idRegistro : null; detCrgEn.IdEntidade = dr["idEntidade"].ToString(); } catch (Exception e) { if (upSight.Consulta.Base.BD.Geral.TS.TraceError) Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOPRGCR.PtrCN", e }); throw; } return resultValid; }