protected override ListViewItem GetNewNivelItem(NivelRule.NivelDocumentalListItem item)
{
ListViewItem lvItem = base.GetNewNivelItem(item);
if (this.lstVwPaginated.Columns.Contains(this.colRequisitado))
{
lvItem.SubItems[this.colRequisitado.Index].Text = item.Requisitado;
}
if (this.lstVwPaginated.Columns.Contains(this.colAgrupador))
{
lvItem.SubItems[this.colAgrupador.Index].Text = item.Agrupador;
}
return(lvItem);
}
public override List<NivelRule.NivelDocumentalListItem> GetSubDocumentos(long IDNivel, IDbConnection conn)
{
var res = new List<NivelRule.NivelDocumentalListItem>();
using (var command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
{
command.Parameters.AddWithValue("@IDNivel", IDNivel);
command.Parameters.AddWithValue("@IDTipoFRDBase1", 1);
command.Parameters.AddWithValue("@IDTipoNivelRelacionado10", 10);
command.CommandText = @"
SELECT rh.ID, nd.Designacao, dp.InicioAno, dp.InicioMes, dp.InicioDia, dp.InicioAtribuida, dp.FimAno, dp.FimMes, dp.FimDia, dp.FimAtribuida, rh.IDTipoNivelRelacionado
FROM RelacaoHierarquica rh
INNER JOIN NivelDesignado nd ON nd.ID = rh.ID AND nd.isDeleted = @isDeleted
INNER JOIN FRDBase frd ON frd.IDNivel = rh.ID AND frd.IDTipoFRDBase = @IDTipoFRDBase1 AND frd.isDeleted = @isDeleted
INNER JOIN SFRDDatasProducao dp ON dp.IDFRDBase = frd.ID AND dp.isDeleted = @isDeleted
WHERE rh.IDUpper = @IDNivel AND rh.IDTipoNivelRelacionado = @IDTipoNivelRelacionado10 AND rh.isDeleted = @isDeleted
ORDER BY rh.ID";
var reader = command.ExecuteReader();
var sdoc = new NivelRule.NivelDocumentalListItem();
while (reader.Read())
{
sdoc = new NivelRule.NivelDocumentalListItem();
sdoc.IDNivel = reader.GetInt64(0);
sdoc.Designacao = reader.GetString(1);
sdoc.InicioAno = reader.GetValue(2).ToString();
sdoc.InicioMes = reader.GetValue(3).ToString();
sdoc.InicioDia = reader.GetValue(4).ToString();
sdoc.InicioAtribuida = reader.GetBoolean(5);
sdoc.FimAno = reader.GetValue(6).ToString();
sdoc.FimMes = reader.GetValue(7).ToString();
sdoc.FimDia = reader.GetValue(8).ToString();
sdoc.FimAtribuida = reader.GetBoolean(9);
sdoc.IDTipoNivelRelacionado = reader.GetInt64(10);
res.Add(sdoc);
}
reader.Close();
}
return res;
}