public override void LoadDataModuloPermissoes(DataSet CurrentDataSet, Int16 IDTipoFunctionGroup, Int16 IdxTipoFunction, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@IDTipoFunctionGroup", IDTipoFunctionGroup);
command.Parameters.AddWithValue("@IdxTipoFunction", IdxTipoFunction);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Trustee"]);
da.Fill(CurrentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeUser"]);
da.Fill(CurrentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeGroup"]);
da.Fill(CurrentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["UserGroups"]);
da.Fill(CurrentDataSet, "UserGroups");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteePrivilege"],
" WHERE TrusteePrivilege.IDTipoFunctionGroup=@IDTipoFunctionGroup AND TrusteePrivilege.IdxTipoFunction=@IdxTipoFunction");
da.Fill(CurrentDataSet, "TrusteePrivilege");
}
}
public override void LoadUFControloDescricaoData(DataSet currentDataSet, DataSet newDataSet, long CurrentFRDBaseID, IDbConnection conn)
{
string WhereQueryFilter = "WHERE IDFRDBase=@CurrentFRDBaseID";
string WhereUserQueryFilter = "WHERE ID IN " +
"(SELECT IDTrusteeOperator FROM FRDBaseDataDeDescricao " +
WhereQueryFilter + " UNION " +
"SELECT IDTrusteeAuthority FROM FRDBaseDataDeDescricao " +
WhereQueryFilter + ")";
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@CurrentFRDBaseID", CurrentFRDBaseID);
command.Parameters.AddWithValue("@IsAuthority", 1);
// Load Trustee.IsAuthority=1
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"], "WHERE ID IN (SELECT ID FROM TrusteeUser WHERE IsAuthority=@IsAuthority)");
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"], "WHERE IsAuthority=@IsAuthority");
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"], WhereUserQueryFilter);
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"], WhereUserQueryFilter);
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBaseDataDeDescricao"], WhereQueryFilter);
da.Fill(currentDataSet, "FRDBaseDataDeDescricao");
}
}
public override ArrayList Entidade_GetItems(DataSet currentDataSet, int pageNr, int itemsPerPage, string FiltroTermoLike, IDbConnection conn)
{
ArrayList rows = new ArrayList();
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["MovimentoEntidade"]);
da.Fill(currentDataSet, "MovimentoEntidade");
command.CommandText = "SELECT * FROM #OrderedItems WHERE seq_id >= @seq_id1 AND seq_id <= @seq_id2 ORDER BY Entidade";
command.Parameters.AddWithValue("@seq_id1", (pageNr - 1) * itemsPerPage + 1);
command.Parameters.AddWithValue("@seq_id2", pageNr * itemsPerPage);
SqlDataReader reader = command.ExecuteReader();
DataRow[] nRows;
while (reader.Read())
{
nRows = currentDataSet.Tables["MovimentoEntidade"].Select(String.Format("ID = {0} ", reader.GetValue(1)));
if (nRows.Length > 0)
{
rows.Add(nRows[0]);
}
}
reader.Close();
}
return(rows);
}
public override HashSet <UFRule.UnidadeFisicaInfo> LoadDepIdentificacaoData(DataSet currentDataSet, long depositoID, IDbConnection conn)
{
LoadDepositoData(currentDataSet, depositoID, conn);
var result = GetUFsInfo("AND NivelUnidadeFisicaDeposito.IDDeposito = " + depositoID.ToString(), conn);
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@depositoID", depositoID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Deposito"],
"WHERE Deposito.ID = @depositoID");
da.Fill(currentDataSet, "Deposito");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisica"],
"INNER JOIN NivelUnidadeFisicaDeposito nufd ON nufd.IDNivelUnidadeFisica = NivelUnidadeFisica.ID " +
"WHERE nufd.IDDeposito = @depositoID");
da.Fill(currentDataSet, "NivelUnidadeFisica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisicaDeposito"],
"WHERE NivelUnidadeFisicaDeposito.IDDeposito = @depositoID");
da.Fill(currentDataSet, "NivelUnidadeFisicaDeposito");
}
return(result);
}
public override void LoadSFRDImagemFedora(DataSet currentDataSet, long docID, long IDTipoNivelRelacionado, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@docID", docID);
command.Parameters.AddWithValue("@IDTipoNivelRelacionado", IDTipoNivelRelacionado);
command.Parameters.AddWithValue("@SFRDImagemTipo", "Fedora");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemVolume"]);
da.Fill(currentDataSet, "SFRDImagemVolume");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagem"],
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@docID AND SFRDImagem.Tipo=@SFRDImagemTipo");
da.Fill(currentDataSet, "SFRDImagem");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigital"],
"INNER JOIN SFRDImagemObjetoDigital ON SFRDImagemObjetoDigital.IDObjetoDigital = ObjetoDigital.ID " +
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@docID AND SFRDImagem.Tipo=@SFRDImagemTipo");
da.Fill(currentDataSet, "ObjetoDigital");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemObjetoDigital"],
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@docID AND SFRDImagem.Tipo=@SFRDImagemTipo");
da.Fill(currentDataSet, "SFRDImagemObjetoDigital");
}
}
public override void LoadAutosEliminacao(DataSet currentDataSet, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["AutoEliminacao"]);
da.Fill(currentDataSet, "AutoEliminacao");
}
}
public override void LoadTitulos(DataSet currentDataSet, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigitalTitulo"]);
da.Fill(currentDataSet, "ObjetoDigitalTitulo");
}
}
public override void LoadAutoEliminacao(DataSet currentDataSet, long aeID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@aeID", aeID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["AutoEliminacao"],
"WHERE ID=@aeID");
da.Fill(currentDataSet, "AutoEliminacao");
}
}
public override void LoadUFConteudoEstruturaData(DataSet currentDataSet, long CurrentFRDBaseID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@CurrentFRDBaseID", CurrentFRDBaseID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDConteudoEEstrutura"],
"WHERE IDFRDBase=@CurrentFRDBaseID");
da.Fill(currentDataSet, "SFRDConteudoEEstrutura");
}
}
public override void LoadMovimento(long movID, DataSet currentDataSet, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@movID", movID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Movimento"],
"WHERE ID = @movID");
da.Fill(currentDataSet, "Movimento");
}
}
// o argumento isParentOptional indica se deverão ser devolvidas apenas as rows
// cuja FK é nullable ou se deverão ser devolvidas apenas aquelas em que a FK é
// não nullable
public override ConcorrenciaRule.ChildRelationRows getChildRowsFromDB(DataSet data, DataTable table, ArrayList parentRows, IDbTransaction tran)
{
ChildRelationRows result = new ChildRelationRows(new ArrayList(), new ArrayList());
DataTable childTable;
StringBuilder genericChildsFilter = new StringBuilder();
string childsFilter = string.Empty;
foreach (DataRelation childRelation in table.ChildRelations)
{
DataColumn[] parentColumns;
DataColumn[] childColumns;
parentColumns = childRelation.ChildKeyConstraint.RelatedColumns;
childColumns = childRelation.ChildKeyConstraint.Columns;
for (int i = 0; i <= childColumns.Length - 1; i++)
{
if (genericChildsFilter.Length > 0)
{
genericChildsFilter.Append(" AND ");
}
genericChildsFilter.AppendFormat("{0}={1}", childColumns[i].ColumnName, "{" + i.ToString() + "}");
}
foreach (DataRow parentRow in parentRows)
{
ArrayList relationParentValues = new ArrayList();
for (int i = 0; i <= parentColumns.Length - 1; i++)
{
DataColumn parentColumn = parentColumns[i];
// as parentRow podem pertencer ao dataset de trabalho ou aos dados que estamos agora a recolher da BD. Apenas no 1º caso o rowstate será deleted.
if (parentRow.RowState == DataRowState.Deleted)
{
relationParentValues.Add(parentRow[parentColumn.ColumnName, DataRowVersion.Original]);
}
else
{
relationParentValues.Add(parentRow[parentColumn.ColumnName]);
}
}
childsFilter = string.Format("WHERE " + genericChildsFilter.ToString(), relationParentValues.ToArray());
childTable = new DataTable(childRelation.ChildTable.TableName);
using (var command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlTransaction)tran))
using (var da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(childRelation.ChildTable, childsFilter);
da.Fill(childTable);
}
result.tables.Add(childTable);
result.relationColumns.Add(childColumns);
}
genericChildsFilter = new StringBuilder();
childsFilter = string.Empty;
}
return(result);
}
public override void LoadObjDigitalPermissoes(DataSet currentDataSet, long nRowID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@nRowID", nRowID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"]);
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"]);
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeGroup"]);
da.Fill(currentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["UserGroups"]);
da.Fill(currentDataSet, "UserGroups");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"],
"WHERE FRDBase.IDNivel=" + nRowID.ToString());
da.Fill(currentDataSet, "FRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemVolume"]);
da.Fill(currentDataSet, "SFRDImagemVolume");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagem"],
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@nRowID");
da.Fill(currentDataSet, "SFRDImagem");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigital"],
"INNER JOIN SFRDImagemObjetoDigital ON SFRDImagemObjetoDigital.IDObjetoDigital = ObjetoDigital.ID " +
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@nRowID");
da.Fill(currentDataSet, "ObjetoDigital");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemObjetoDigital"],
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@nRowID");
da.Fill(currentDataSet, "SFRDImagemObjetoDigital");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeObjetoDigitalPrivilege"],
"INNER JOIN ObjetoDigital ON ObjetoDigital.ID = TrusteeObjetoDigitalPrivilege.IDObjetoDigital " +
"INNER JOIN SFRDImagemObjetoDigital ON SFRDImagemObjetoDigital.IDObjetoDigital = ObjetoDigital.ID " +
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"WHERE FRDBase.IDNivel=@nRowID");
da.Fill(currentDataSet, "TrusteeObjetoDigitalPrivilege");
}
}
public override void ReloadNivelUFCodigo(DataSet currentDataSet, long idNivel, decimal ano, IDbTransaction tran)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlTransaction)tran))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@idNivel", idNivel);
command.Parameters.AddWithValue("@ano", ano);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisicaCodigo"],
"WHERE ID=@idNivel AND Ano=@ano");
da.Fill(currentDataSet, "NivelUnidadeFisicaCodigo");
}
}
public override void LoadUtilizadores(DataSet CurrentDataSet, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Trustee"]);
da.Fill(CurrentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeGroup"]);
da.Fill(CurrentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeUser"]);
da.Fill(CurrentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["UserGroups"]);
da.Fill(CurrentDataSet, "UserGroups");
}
}
public override int CalculateODGroupPermissions(long IDTrustee, long IDObjetoDigital, long IDOperation, IDbConnection conn)
{
using (var command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
{
command.Parameters.AddWithValue("@IDTrustee", IDTrustee);
command.Parameters.AddWithValue("@IDObjetoDigital", IDObjetoDigital);
command.Parameters.AddWithValue("@IDOperation", IDOperation);
command.CommandText = @"
select MIN(CONVERT(tinyint, todp.IsGrant))
from TrusteeObjetoDigitalPrivilege todp
inner join ObjetoDigitalTipoOperation odtp on odtp.IDTipoOperation = todp.IDTipoOperation and odtp.isDeleted = @isDeleted
inner join UserGroups ug on ug.IDGroup = todp.IDTrustee and ug.isDeleted = @isDeleted
where todp.IDObjetoDigital = @IDObjetoDigital and ug.IDUser = @IDTrustee and todp.IDTipoOperation = @IDOperation and todp.isDeleted = @isDeleted";
var res = command.ExecuteScalar();
return(res == DBNull.Value ? -1 : System.Convert.ToInt32(res));
}
}
public override void FixRow(DataSet ds, DataRow dr, IDbConnection conn)
{
foreach (DataRelation rel in dr.Table.ParentRelations)
{
if (!(dr.IsNull(rel.ChildColumns[0])))
{
string str = "WHERE " + GetJoinExpression(rel, dr);
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(ds.Tables[rel.ParentTable.TableName],
str);
da.Fill(ds, rel.ParentTable.TableName);
}
}
}
dr.ClearErrors();
}
public override void LoadUFIdentificacao2Data(DataSet currentDataSet, long CurrentFRDBaseID, IDbConnection conn)
{
string WhereQueryFilter = "WHERE IDFRDBase=" + CurrentFRDBaseID.ToString();
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@CurrentFRDBaseID", CurrentFRDBaseID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDDatasProducao"], WhereQueryFilter);
da.Fill(currentDataSet, "SFRDDatasProducao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFCota"], WhereQueryFilter);
da.Fill(currentDataSet, "SFRDUFCota");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFDescricaoFisica"], WhereQueryFilter);
da.Fill(currentDataSet, "SFRDUFDescricaoFisica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDConteudoEEstrutura"], WhereQueryFilter);
da.Fill(currentDataSet, "SFRDConteudoEEstrutura");
}
}
public override void LoadUFData(DataSet currentDataSet, long nivelID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@nivelID", nivelID);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"],
"WHERE ID=@nivelID");
da.Fill(currentDataSet, "NivelDesignado");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisica"],
"WHERE ID=@nivelID");
da.Fill(currentDataSet, "NivelUnidadeFisica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"],
"WHERE ID=@nivelID");
da.Fill(currentDataSet, "RelacaoHierarquica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"],
"WHERE IDNivel=@nivelID");
da.Fill(currentDataSet, "FRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFCota"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDUFCota.IDFRDBase " +
"WHERE frd.IDNivel=@nivelID");
da.Fill(currentDataSet, "SFRDUFCota");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFDescricaoFisica"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDUFDescricaoFisica.IDFRDBase " +
"WHERE frd.IDNivel=@nivelID");
da.Fill(currentDataSet, "SFRDUFDescricaoFisica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDDatasProducao"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDDatasProducao.IDFRDBase " +
"WHERE frd.IDNivel=@nivelID");
da.Fill(currentDataSet, "SFRDDatasProducao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TipoAcondicionamento"]);
da.Fill(currentDataSet, "TipoAcondicionamento");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TipoMedida"]);
da.Fill(currentDataSet, "TipoMedida");
}
}
public override void LoadDataCIPermissoes(DataSet CurrentDataSet, long IDNivel, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@IDNivel", IDNivel);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Trustee"]);
da.Fill(CurrentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeUser"]);
da.Fill(CurrentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeGroup"]);
da.Fill(CurrentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeNivelPrivilege"],
"WHERE TrusteeNivelPrivilege.IDNivel = @IDNivel");
da.Fill(CurrentDataSet, "TrusteeNivelPrivilege");
}
}
public override void LoadDataCIPermissoes(DataSet CurrentDataSet, List <long> lstIDNivel, IDbConnection conn)
{
GisaDataSetHelperRule.ImportIDs(lstIDNivel.ToArray(), conn);
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Trustee"]);
da.Fill(CurrentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeUser"]);
da.Fill(CurrentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeGroup"]);
da.Fill(CurrentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeNivelPrivilege"],
"INNER JOIN #temp T ON T.ID = TrusteeNivelPrivilege.IDNivel ");
da.Fill(CurrentDataSet, "TrusteeNivelPrivilege");
}
}
public override void FillTableInGetLinhasConcorrentes(DataSet ds, DataTable table, string query, DBAbstractDataLayer.DataAccessRules.Syntax.DataDeletionStatus status, IDbTransaction tran)
{
try
{
if (ds.Tables[table.TableName] == null)
{
ds.Tables.Add(table.Clone());
}
using (var command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlTransaction)tran))
using (var da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(table, " WITH (UPDLOCK) " + query, status);
da.Fill(ds, table.TableName);
}
}
catch (Exception e)
{
Trace.WriteLine(table + ": " + e.Message);
throw e;
}
}
public override void LoadDepositosPermissionsData(DataSet currentDataSet, long trusteeID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"]);
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"]);
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeGroup"]);
da.Fill(currentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["UserGroups"]);
da.Fill(currentDataSet, "UserGroups");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Deposito"]);
da.Fill(currentDataSet, "Deposito");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeDepositoPrivilege"]);
da.Fill(currentDataSet, "TrusteeDepositoPrivilege");
}
}
public override void LoadStaticDataTables(DataSet CurrentDataSet, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
try
{
// Normas de países, línguas, caligrafia...
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Iso15924"]);
da.Fill(CurrentDataSet, "Iso15924");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Iso3166"]);
da.Fill(CurrentDataSet, "Iso3166");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Iso639"]);
da.Fill(CurrentDataSet, "Iso639");
//Configuracoes
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["GlobalConfig"]);
da.Fill(CurrentDataSet, "GlobalConfig");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["ConfigAlfabeto"]);
da.Fill(CurrentDataSet, "ConfigAlfabeto");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["ConfigLingua"]);
da.Fill(CurrentDataSet, "ConfigLingua");
//Conjunto de Privilégios da Aplicação
//Identificam acesso a Módulos da aplicação ou funcionalidades dentro destes, não a dados.
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoFunctionGroup"]);
da.Fill(CurrentDataSet, "TipoFunctionGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoFunction"]);
da.Fill(CurrentDataSet, "TipoFunction");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoOperation"]);
da.Fill(CurrentDataSet, "TipoOperation");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["NivelTipoOperation"]);
da.Fill(CurrentDataSet, "NivelTipoOperation");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["DepositoTipoOperation"]);
da.Fill(CurrentDataSet, "DepositoTipoOperation");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["ObjetoDigitalTipoOperation"]);
da.Fill(CurrentDataSet, "ObjetoDigitalTipoOperation");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["FunctionOperation"]);
da.Fill(CurrentDataSet, "FunctionOperation");
//Tipos de producto existentes e funcionalidades proprias de cada um
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoServer"]);
da.Fill(CurrentDataSet, "TipoServer");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Modules"]);
da.Fill(CurrentDataSet, "Modules");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["ProductFunction"]);
da.Fill(CurrentDataSet, "ProductFunction");
//Enumerados utilizados em foreign keys
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoControloAutForma"]);
da.Fill(CurrentDataSet, "TipoControloAutForma");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoControloAutRel"]);
da.Fill(CurrentDataSet, "TipoControloAutRel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoDensidade"]);
da.Fill(CurrentDataSet, "TipoDensidade");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoEntidadeProdutora"]);
da.Fill(CurrentDataSet, "TipoEntidadeProdutora");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoEstadoDeConservacao"]);
da.Fill(CurrentDataSet, "TipoEstadoDeConservacao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoFormaSuporteAcond"]);
da.Fill(CurrentDataSet, "TipoFormaSuporteAcond");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoFRDBase"]);
da.Fill(CurrentDataSet, "TipoFRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoMaterialDeSuporte"]);
da.Fill(CurrentDataSet, "TipoMaterialDeSuporte");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoMedida"]);
da.Fill(CurrentDataSet, "TipoMedida");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoNivel"]);
da.Fill(CurrentDataSet, "TipoNivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoNivelRelacionado"]);
da.Fill(CurrentDataSet, "TipoNivelRelacionado");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoNivelRelacionadoCodigo"]);
da.Fill(CurrentDataSet, "TipoNivelRelacionadoCodigo");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["RelacaoTipoNivelRelacionado"]);
da.Fill(CurrentDataSet, "RelacaoTipoNivelRelacionado");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoNoticiaAut"]);
da.Fill(CurrentDataSet, "TipoNoticiaAut");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoNoticiaATipoControloAForma"]);
da.Fill(CurrentDataSet, "TipoNoticiaATipoControloAForma");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoOrdenacao"]);
da.Fill(CurrentDataSet, "TipoOrdenacao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoPertinencia"]);
da.Fill(CurrentDataSet, "TipoPertinencia");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoSuporte"]);
da.Fill(CurrentDataSet, "TipoSuporte");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoAcondicionamento"]);
da.Fill(CurrentDataSet, "TipoAcondicionamento");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoTecnicaRegisto"]);
da.Fill(CurrentDataSet, "TipoTecnicaRegisto");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoEstadoConservacao"]);
da.Fill(CurrentDataSet, "TipoEstadoConservacao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoSubDensidade"]);
da.Fill(CurrentDataSet, "TipoSubDensidade");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoTecnicasDeRegisto"]);
da.Fill(CurrentDataSet, "TipoTecnicasDeRegisto");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoTradicaoDocumental"]);
da.Fill(CurrentDataSet, "TipoTradicaoDocumental");
//Autos de eliminação
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["AutoEliminacao"]);
da.Fill(CurrentDataSet, "AutoEliminacao");
//Tipos de entrega
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoEntrega"]);
da.Fill(CurrentDataSet, "TipoEntrega");
//Integracao
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Integ_Sistema"]);
da.Fill(CurrentDataSet, "Integ_Sistema");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Integ_TipoEntidade"]);
da.Fill(CurrentDataSet, "Integ_TipoEntidade");
// TipoTipologias:
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TipoTipologias"]);
da.Fill(CurrentDataSet, "TipoTipologias");
}
catch (Exception)
{
throw;
}
}
}
public override void LoadUF(DataSet currentDataSet, long idNivel, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@idNivel", idNivel);
// nuvem nível
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"WHERE ID=@idNivel");
da.Fill(currentDataSet, "Nivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"],
"WHERE ID=@idNivel");
da.Fill(currentDataSet, "NivelDesignado");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["LocalConsulta"]);
da.Fill(currentDataSet, "LocalConsulta");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisica"],
"WHERE ID=@idNivel");
da.Fill(currentDataSet, "NivelUnidadeFisica");
// entidade detentora
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"],
"WHERE ID=@idNivel");
da.Fill(currentDataSet, "RelacaoHierarquica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"INNER JOIN RelacaoHierarquica rh ON rh.ID = Nivel.ID " +
"INNER JOIN Nivel nED ON nED.ID = rh.IDUpper " +
"WHERE Nivel.ID=@idNivel");
da.Fill(currentDataSet, "Nivel");
// nuvem frdbase
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"],
"WHERE FRDBase.IDNivel=@idNivel");
da.Fill(currentDataSet, "FRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDDatasProducao"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDDatasProducao.IDFRDBase " +
"WHERE frd.IDNivel=@idNivel");
da.Fill(currentDataSet, "SFRDDatasProducao");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFCota"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDUFCota.IDFRDBase " +
"WHERE frd.IDNivel=@idNivel");
da.Fill(currentDataSet, "SFRDUFCota");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDConteudoEEstrutura"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDConteudoEEstrutura.IDFRDBase " +
"WHERE frd.IDNivel=@idNivel");
da.Fill(currentDataSet, "SFRDConteudoEEstrutura");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUFDescricaoFisica"],
"INNER JOIN FRDBase frd ON frd.ID = SFRDUFDescricaoFisica.IDFRDBase " +
"WHERE frd.IDNivel=@idNivel");
da.Fill(currentDataSet, "SFRDUFDescricaoFisica");
// unidades informacionais associadas
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"INNER JOIN FRDBase ON FRDBase.IDNivel = Nivel.ID " +
"INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " +
"WHERE SFRDUnidadeFisica.IDNivel=@idNivel");
da.Fill(currentDataSet, "Nivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"],
"INNER JOIN FRDBase ON FRDBase.IDNivel = RelacaoHierarquica.ID " +
"INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " +
"WHERE SFRDUnidadeFisica.IDNivel=@idNivel");
da.Fill(currentDataSet, "RelacaoHierarquica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"INNER JOIN RelacaoHierarquica ON RelacaoHierarquica.IDUpper = Nivel.ID " +
"INNER JOIN FRDBase ON FRDBase.IDNivel = RelacaoHierarquica.ID " +
"INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " +
"WHERE SFRDUnidadeFisica.IDNivel=@idNivel");
da.Fill(currentDataSet, "Nivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"],
"INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " +
"WHERE SFRDUnidadeFisica.IDNivel=@idNivel");
da.Fill(currentDataSet, "FRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUnidadeFisica"],
"WHERE IDNivel=@idNivel");
da.Fill(currentDataSet, "SFRDUnidadeFisica");
}
}
private void LoadDataRows(DataSet currentDataSet, long docID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@SFRDImagemTipo", "Fedora");
// carregar toda a informação referente aos objectos digitais do documento actual e seus subdocumentos
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemVolume"],
"INNER JOIN ( " +
"SELECT DISTINCT IDSFDImagemVolume " +
"FROM SFRDImagem " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"INNER JOIN #niveisTemp ON #niveisTemp.ID = FRDBase.IDNivel " +
"WHERE SFRDImagem.Tipo = @SFRDImagemTipo" +
") img ON img.IDSFDImagemVolume = SFRDImagemVolume.ID");
da.Fill(currentDataSet, "SFRDImagemVolume");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagem"],
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"INNER JOIN #niveisTemp ON #niveisTemp.ID = FRDBase.IDNivel " +
"WHERE SFRDImagem.Tipo = @SFRDImagemTipo");
da.Fill(currentDataSet, "SFRDImagem");
command.CommandText = @"
INSERT INTO #odsTemp
SELECT IDObjetoDigital
FROM SFRDImagemObjetoDigital
INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx AND SFRDImagem.isDeleted = @isDeleted
INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase AND FRDBase.isDeleted = @isDeleted
INNER JOIN #niveisTemp ON #niveisTemp.ID = FRDBase.IDNivel
WHERE SFRDImagem.Tipo = 'Fedora' AND SFRDImagemObjetoDigital.isDeleted = @isDeleted";
command.ExecuteNonQuery();
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigital"],
"INNER JOIN #odsTemp ON #odsTemp.ID = ObjetoDigital.ID");
da.Fill(currentDataSet, "ObjetoDigital");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDImagemObjetoDigital"],
"INNER JOIN SFRDImagem ON SFRDImagem.IDFRDBase = SFRDImagemObjetoDigital.IDFRDBase AND SFRDImagem.idx = SFRDImagemObjetoDigital.idx " +
"INNER JOIN FRDBase ON FRDBase.ID = SFRDImagem.IDFRDBase " +
"INNER JOIN #niveisTemp ON #niveisTemp.ID = FRDBase.IDNivel " +
"WHERE SFRDImagem.Tipo = @SFRDImagemTipo");
da.Fill(currentDataSet, "SFRDImagemObjetoDigital");
// carregar permissões
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeObjetoDigitalPrivilege"],
"INNER JOIN #odsTemp ON #odsTemp.ID = TrusteeObjetoDigitalPrivilege.IDObjetoDigital");
da.Fill(currentDataSet, "TrusteeObjetoDigitalPrivilege");
// carregar ODs e respetivas permissões sem um nivel documental correspondente
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigital"],
"INNER JOIN ObjetoDigitalRelacaoHierarquica ON ObjetoDigitalRelacaoHierarquica.ID = ObjetoDigital.ID " +
"INNER JOIN #odsTemp ON #odsTemp.ID = ObjetoDigitalRelacaoHierarquica.IDUpper ");
da.Fill(currentDataSet, "ObjetoDigital");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ObjetoDigitalRelacaoHierarquica"],
"INNER JOIN #odsTemp ON #odsTemp.ID = ObjetoDigitalRelacaoHierarquica.IDUpper");
da.Fill(currentDataSet, "ObjetoDigitalRelacaoHierarquica");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeObjetoDigitalPrivilege"],
"INNER JOIN ObjetoDigitalRelacaoHierarquica ON ObjetoDigitalRelacaoHierarquica.ID = TrusteeObjetoDigitalPrivilege.IDObjetoDigital " +
"INNER JOIN #odsTemp ON #odsTemp.ID = ObjetoDigitalRelacaoHierarquica.IDUpper ");
da.Fill(currentDataSet, "TrusteeObjetoDigitalPrivilege");
}
}
public override List <AutoEliminacao_UFsEliminadas> LoadUnidadesFisicasAvaliadas(DataSet currentDataSet, long aeID, IDbConnection conn)
{
this.LoadAutoEliminacaoUFsID(currentDataSet, aeID, (SqlConnection)conn);
List <AutoEliminacao_UFsEliminadas> rows = new List <AutoEliminacao_UFsEliminadas>();
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"INNER JOIN #NiveisTemp ON #NiveisTemp.IDNivel = Nivel.ID ");
da.Fill(currentDataSet, "Nivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"],
"INNER JOIN #NiveisTemp ON #NiveisTemp.IDNivel = NivelDesignado.ID ");
da.Fill(currentDataSet, "NivelDesignado");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["LocalConsulta"]);
da.Fill(currentDataSet, "LocalConsulta");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisica"],
"INNER JOIN #NiveisTemp ON #NiveisTemp.IDNivel = NivelUnidadeFisica.ID ");
da.Fill(currentDataSet, "NivelUnidadeFisica");
command.CommandText =
"SELECT temp.IDNivel, nEDs.Codigo + '/' + nUFs.Codigo Codigo, ndUFs.Designacao, COALESCE(nuf.Eliminado, 0), df.MedidaAltura, df.MedidaLargura, df.MedidaProfundidade, tp.Designacao " +
"FROM #NiveisTemp temp " +
"INNER JOIN Nivel nUFs ON nUFs.ID = temp.IDNivel AND nUFs.isDeleted = @isDeleted " +
"INNER JOIN NivelDesignado ndUFs ON ndUFs.ID = temp.IDNivel AND ndUFs.isDeleted = @isDeleted " +
"INNER JOIN RelacaoHierarquica rh ON rh.ID = temp.IDNivel AND rh.isDeleted = @isDeleted " +
"INNER JOIN Nivel nEDs ON nEDs.ID = rh.IDUpper AND nEDs.isDeleted = @isDeleted " +
"LEFT JOIN NivelUnidadeFisica nuf ON nuf.ID = temp.IDNivel AND nuf.isDeleted = @isDeleted " +
"LEFT JOIN FRDBase frd ON frd.IDNivel = nUFs.ID AND frd.isDeleted = @isDeleted " +
"LEFT JOIN SFRDUFDescricaoFisica df ON df.IDFRDBase = frd.ID AND df.isDeleted = @isDeleted " +
"LEFT JOIN TipoMedida tp ON tp.ID = df.IDTipoMedida AND tp.isDeleted = @isDeleted";
SqlDataReader reader = command.ExecuteReader();
AutoEliminacao_UFsEliminadas ae;
while (reader.Read())
{
ae = new AutoEliminacao_UFsEliminadas();
ae.IDNivel = reader.GetInt64(0); // IDNivel
ae.codigo = reader.GetString(1); // Codigo
ae.designacao = reader.GetString(2); // Designacao
ae.paraEliminar = Convert.ToBoolean(reader.GetValue(3)); // Eliminar
if (reader.GetValue(4) != DBNull.Value)
{
ae.altura = System.Convert.ToDecimal(reader.GetValue(4)); // Altura
}
if (reader.GetValue(5) != DBNull.Value)
{
ae.largura = System.Convert.ToDecimal(reader.GetValue(5)); // Largura
}
if (reader.GetValue(6) != DBNull.Value)
{
ae.profundidade = System.Convert.ToDecimal(reader.GetValue(6)); // Profundidade
}
ae.tipoMedida = reader.GetValue(7).ToString(); // TipoMedida
rows.Add(ae);
}
reader.Close();
command.CommandText = "DROP TABLE #NiveisTemp; ";
command.ExecuteNonQuery();
}
return(rows);
}
