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