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));
}