private void vGeraPersonalizavel() { System.Text.StringBuilder strbPersonalizavel = new System.Text.StringBuilder(); System.Collections.SortedList sortLstDSEPE = new System.Collections.SortedList(new mdlComponentesColecoes.clsComparerNumbersTexts()); // Ordenando for (int i = 0; i < m_typDatSetResPes.tbREsPEs.Rows.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)m_typDatSetResPes.tbREsPEs.Rows[i]; if ((dtrwREPE.RowState != System.Data.DataRowState.Deleted) && (dtrwREPE.nIdExportador == m_nIdExportador) && (dtrwREPE.strIdPE == m_strIdPe)) { sortLstDSEPE.Add(GetRENumero(dtrwREPE.nIdRe), dtrwREPE); } } // Inserindo for (int i = 0; i < sortLstDSEPE.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)sortLstDSEPE.GetByIndex(i); if (strbPersonalizavel.ToString() != "") { strbPersonalizavel.Append(" , "); } strbPersonalizavel.Append(GetName(GetRE(dtrwREPE.nIdRe))); } m_strPersonalizavel = strbPersonalizavel.ToString(); if (m_typDatSetPes.tbPEs.Rows.Count > 0) { mdlDataBaseAccess.Tabelas.XsdTbPes.tbPEsRow dtrwPE = (mdlDataBaseAccess.Tabelas.XsdTbPes.tbPEsRow)m_typDatSetPes.tbPEs.Rows[0]; dtrwPE.mstrRE = m_strPersonalizavel; dtrwPE.SetmstrSDNull(); } }
private bool bReVinculado(string strIdPE) { for (int i = 0; i < m_typDatSetREsPEs.tbREsPEs.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwVinculo = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)m_typDatSetREsPEs.tbREsPEs[i]; if ((dtrwVinculo.RowState != System.Data.DataRowState.Deleted) && (dtrwVinculo.strIdPE == strIdPE)) { return(true); } } return(false); }
private bool formFVincular_eCallREVincular(Formularios.frmFREVincular sender, int nIdRe) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwVincular = m_typDatSetResPes.tbREsPEs.NewtbREsPEsRow(); dtrwVincular.nIdExportador = m_nIdExportador; dtrwVincular.strIdPE = m_strIdPe; dtrwVincular.nIdRe = nIdRe; m_typDatSetResPes.tbREsPEs.AddtbREsPEsRow(dtrwVincular); vGeraPersonalizavel(); sender.Personalizavel = this.Personalizavel; sender.Editavel = (bReVinculado(m_strIdPe)) && (!bDSEVinculado(m_strIdPe)); return(true); }
private bool formFVincular_eCallREDesvincular(Formularios.frmFREVincular sender, int nIdRe) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwDesvincular = m_typDatSetResPes.tbREsPEs.FindBynIdExportadornIdRestrIdPE(m_nIdExportador, nIdRe, m_strIdPe); if ((dtrwDesvincular == null) || (dtrwDesvincular.RowState == System.Data.DataRowState.Deleted)) { return(false); } dtrwDesvincular.Delete(); vGeraPersonalizavel(); sender.Personalizavel = this.Personalizavel; sender.Editavel = (bReVinculado(m_strIdPe)) && (!bDSEVinculado(m_strIdPe)); return(true); }
private int GetREImportador(int nIdRE) { int nRetorno = -1; for (int i = 0; i < m_typDatSetResPes.tbREsPEs.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)m_typDatSetResPes.tbREsPEs[i]; if ((dtrwREPE.RowState != System.Data.DataRowState.Deleted) && (dtrwREPE.nIdRe == nIdRE)) { mdlDataBaseAccess.Tabelas.XsdTbFaturasComerciais.tbFaturasComerciaisRow dtrwFaturaComercial = GetRowFaturaComercial(dtrwREPE.strIdPE); if ((dtrwFaturaComercial != null) && (!dtrwFaturaComercial.IsidImportadorNull())) { return(dtrwFaturaComercial.idImportador); } return(-1); } } return(nRetorno); }
protected override string CarregaDataMultiplaDefault() { mdlDataBaseAccess.Tabelas.XsdTbREs typDatSetREs = GetTbREs(); mdlDataBaseAccess.Tabelas.XsdTbREsPEs typDatSetREsPEs = GetTbREsPEs(); mdlDataBaseAccess.Tabelas.XsdTbSDs typDatSetSDs = GetTbSDs(); System.Text.StringBuilder strbDefault = new System.Text.StringBuilder(); // Ordernando System.Collections.SortedList srtlstSD = new System.Collections.SortedList(new mdlComponentesColecoes.clsComparerNumbersTexts()); for (int i = 0; i < typDatSetREsPEs.tbREsPEs.Rows.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)typDatSetREsPEs.tbREsPEs.Rows[i]; if ((dtrwREPE.nIdExportador == m_nIdExportador) && (dtrwREPE.strIdPE == m_strIdPE)) { mdlDataBaseAccess.Tabelas.XsdTbREs.tbREsRow dtrwRE = typDatSetREs.tbREs.FindBynIdExportadornIdRe(m_nIdExportador, dtrwREPE.nIdRe); if ((dtrwRE != null) && (!dtrwRE.IsnIdSDNull())) { mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow dtrwSD = typDatSetSDs.tbSDs.FindBynIdExportadornIdSD(m_nIdExportador, dtrwRE.nIdSD); if ((dtrwSD != null) && (!srtlstSD.Contains(dtrwSD.mstrNumero))) { srtlstSD.Add(dtrwSD.mstrNumero, dtrwSD); } } } } // Inserindo for (int i = 0; i < srtlstSD.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow dtrwSD = (mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow)srtlstSD.GetByIndex(i); if (strbDefault.ToString() != "") { strbDefault.Append(" - "); } if (!dtrwSD.IsdtEmissaoNull()) { strbDefault.Append(dtrwSD.dtEmissao.ToString(this.Formato)); } else { strbDefault.Append(" "); } } return(strbDefault.ToString()); }
private string GetPersonalizavel() { System.Text.StringBuilder strbPersonalizavel = new System.Text.StringBuilder(); System.Collections.SortedList sortLstSD = new System.Collections.SortedList(new mdlComponentesColecoes.clsComparerNumbersTexts()); // Ordenando for (int i = 0; i < m_typDatSetREsPEs.tbREsPEs.Rows.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)m_typDatSetREsPEs.tbREsPEs.Rows[i]; if ((dtrwREPE.RowState != System.Data.DataRowState.Deleted) && (dtrwREPE.strIdPE == m_strIdPE)) { mdlDataBaseAccess.Tabelas.XsdTbREs.tbREsRow dtrwRE = m_typDatSetREs.tbREs.FindBynIdExportadornIdRe(m_nIdExportador, dtrwREPE.nIdRe); if ((dtrwRE != null) && (dtrwRE.RowState != System.Data.DataRowState.Deleted) && (!dtrwRE.IsnIdSDNull())) { mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow dtrwSD = m_typDatSetSDs.tbSDs.FindBynIdExportadornIdSD(m_nIdExportador, dtrwRE.nIdSD); if ((dtrwSD != null) && (dtrwSD.RowState != System.Data.DataRowState.Deleted) && (!sortLstSD.Contains(dtrwSD.mstrNumero))) { sortLstSD.Add(dtrwSD.mstrNumero, dtrwSD); } } } } if (sortLstSD.Count == 0) { return(null); } // Inserindo for (int i = 0; i < sortLstSD.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow dtrwSD = (mdlDataBaseAccess.Tabelas.XsdTbSDs.tbSDsRow)sortLstSD.GetByIndex(i); if (strbPersonalizavel.ToString() != "") { strbPersonalizavel.Append(" , "); } strbPersonalizavel.Append(dtrwSD.mstrNumero); } return(strbPersonalizavel.ToString()); }
private void vRefreshPEsVinculados(int nIdRe, ref mdlComponentesGraficos.ListView lvPEsVinculados) { lvPEsVinculados.Items.Clear(); System.Collections.SortedList sortLstREPE = new System.Collections.SortedList(new mdlComponentesColecoes.clsComparerNumbersTexts()); // Ordenando for (int i = 0; i < m_typDatSetResPes.tbREsPEs.Rows.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)m_typDatSetResPes.tbREsPEs.Rows[i]; if ((dtrwREPE.RowState != System.Data.DataRowState.Deleted) && (dtrwREPE.nIdExportador == m_nIdExportador) && (dtrwREPE.nIdRe == nIdRe)) { sortLstREPE.Add(dtrwREPE.strIdPE, dtrwREPE); } } // Inserindo System.Windows.Forms.ListViewItem lviInserir; for (int i = 0; i < sortLstREPE.Count; i++) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwREPE = (mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow)sortLstREPE.GetByIndex(i); lviInserir = lvPEsVinculados.Items.Add(sortLstREPE.GetKey(i).ToString()); lviInserir.Tag = dtrwREPE.strIdPE; } }
private bool bReVinculado(int nIdRE, string strIdPe) { mdlDataBaseAccess.Tabelas.XsdTbREsPEs.tbREsPEsRow dtrwVinculo = m_typDatSetResPes.tbREsPEs.FindBynIdExportadornIdRestrIdPE(m_nIdExportador, nIdRE, strIdPe); return((dtrwVinculo != null) && (dtrwVinculo.RowState != System.Data.DataRowState.Deleted)); }