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 IDataReader GetNoticiasAutoridadeRelaccionadas(DataSet currentDataSet, ArrayList IDs, IDbConnection conn) { string QueryIndex = string.Format("WHERE ID IN " + "(" + "(SELECT IDDicionario FROM ControloAutDicionario cad " + "INNER JOIN ControloAut ca ON cad.IDTipoControloAutForma=1 AND cad.IDControloAut=ca.ID " + "INNER JOIN ControloAutRel car ON car.IDControloAut=ca.ID AND car.IDControloAutAlias IN ({0}) " + "WHERE cad.isDeleted=0 AND ca.isDeleted=0 AND car.isDeleted=0 " + "UNION " + "SELECT IDDicionario FROM ControloAutDicionario cad " + "INNER JOIN ControloAut ca ON cad.IDTipoControloAutForma = 1 And cad.IDControloAut = ca.ID " + "INNER JOIN ControloAutRel car ON car.IDControloAut IN ({0}) AND car.IDControloAutAlias=ca.ID " + "WHERE cad.isDeleted=0 AND ca.isDeleted=0 AND car.isDeleted=0) " + " UNION " + "(SELECT IDDicionario FROM ControloAutDicionario cad " + "INNER JOIN ControloAut ca ON cad.IDTipoControloAutForma=1 AND cad.IDControloAut=ca.ID " + "INNER JOIN NivelControloAut nca ON nca.IDControloAut = ca.ID " + "INNER JOIN RelacaoHierarquica rhUpper ON rhUpper.ID = nca.ID " + "INNER JOIN NivelControloAut ncaUpper ON ncaUpper.ID = rhUpper.IDUpper AND ncaUpper.IDControloAut IN ({0}) " + "WHERE cad.isDeleted=0 AND ca.isDeleted=0 AND nca.isDeleted=0 AND rhUpper.isDeleted=0 AND ncaUpper.isDeleted=0) " + "UNION " + "(SELECT IDDicionario FROM ControloAutDicionario cad " + "INNER JOIN ControloAut ca ON cad.IDTipoControloAutForma=1 AND cad.IDControloAut=ca.ID " + "INNER JOIN NivelControloAut nca ON nca.IDControloAut = ca.ID " + "INNER JOIN RelacaoHierarquica rhChild ON rhChild.IDUpper = nca.ID " + "INNER JOIN NivelControloAut ncaChild ON ncaChild.ID = rhChild.ID AND ncaChild.IDControloAut IN ({0}) " + "WHERE cad.isDeleted=0 AND ca.isDeleted=0 AND nca.isDeleted=0 AND rhChild.isDeleted=0 AND ncaChild.isDeleted=0) " + ")", longCollectionToCommaDelimitedString(IDs)); string cmd = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Dicionario"], QueryIndex); SqlCommand command = new SqlCommand(cmd, (SqlConnection)conn); SqlDataReader reader = command.ExecuteReader(); return(reader); }
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 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 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 LoadObjDigitalData(DataSet currentDataSet, long docID, long IDTipoNivelRelacionado, IDbConnection conn) { using (SqlCommand command = new SqlCommand("", (SqlConnection)conn)) using (SqlDataAdapter da = new SqlDataAdapter(command)) { command.CommandText = "CREATE TABLE #niveisTemp(ID BIGINT); CREATE TABLE #odsTemp(ID BIGINT)"; command.ExecuteNonQuery(); if (IDTipoNivelRelacionado == 9) { // no caso do docID ser um documento/processo é necessário obter possíveis subdocumentos command.CommandText = @" INSERT INTO #niveisTemp SELECT ID FROM RelacaoHierarquica WHERE IDTipoNivelRelacionado = @IDTipoNivelRelacionado AND IDUpper = @docID AND isDeleted = @isDeleted"; command.Parameters.AddWithValue("@docID", docID); command.Parameters.AddWithValue("@IDTipoNivelRelacionado", 10); command.Parameters.AddWithValue("@isDeleted", 0); command.ExecuteNonQuery(); // carregar rows referentes só aos subdocumentos da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN #niveisTemp ON #niveisTemp.ID = Nivel.ID"); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"], "INNER JOIN #niveisTemp ON #niveisTemp.ID = NivelDesignado.ID"); da.Fill(currentDataSet, "NivelDesignado"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDocumentoSimples"], "INNER JOIN #niveisTemp ON #niveisTemp.ID = NivelDocumentoSimples.ID"); da.Fill(currentDataSet, "NivelDocumentoSimples"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"], "INNER JOIN #niveisTemp ON #niveisTemp.ID = RelacaoHierarquica.ID"); da.Fill(currentDataSet, "RelacaoHierarquica"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"], "INNER JOIN #niveisTemp ON #niveisTemp.ID = FRDBase.IDNivel"); da.Fill(currentDataSet, "FRDBase"); command.Parameters.Clear(); } command.CommandText = "INSERT INTO #niveisTemp (ID) VALUES (@docID)"; command.Parameters.AddWithValue("@docID", docID); command.ExecuteNonQuery(); LoadDataRows(currentDataSet, docID, conn); command.CommandText = "DROP TABLE #niveisTemp; DROP TABLE #odsTemp"; command.ExecuteNonQuery(); } }
public override ArrayList GetItems(DataSet currentDataSet, int pageNr, int itemsPerPage, System.Data.IDbConnection conn) { ArrayList rows = new ArrayList(); using (SqlCommand command = new SqlCommand("", (SqlConnection)conn)) { command.CommandText = "CREATE TABLE #ItemsID (ID BIGINT, Data DATETIME, Entidade NVARCHAR(444), Codigo NVARCHAR(25))"; command.ExecuteNonQuery(); command.CommandText = "INSERT INTO #ItemsID " + "SELECT mov.ID, mov.Data, me.Entidade, me.Codigo " + "FROM #OrderedItems oi " + "INNER JOIN Movimento mov ON mov.ID = oi.ID " + "INNER JOIN MovimentoEntidade me ON me.ID = mov.IDEntidade " + "WHERE seq_id >= @seq_id1 AND seq_id <= @seq_id2 " + "ORDER BY seq_id"; command.Parameters.AddWithValue("@seq_id1", (pageNr - 1) * itemsPerPage + 1); command.Parameters.AddWithValue("@seq_id2", pageNr * itemsPerPage); command.ExecuteNonQuery(); using (SqlDataAdapter da = new SqlDataAdapter(command)) { command.Parameters.AddWithValue("@isDeleted", 0); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Movimento"], "INNER JOIN #ItemsID ON #ItemsID.ID = Movimento.ID"); da.Fill(currentDataSet, "Movimento"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["MovimentoEntidade"], @"INNER JOIN ( SELECT DISTINCT m.IDEntidade FROM Movimento m INNER JOIN #ItemsID ON #ItemsID.ID = m.ID WHERE m.isDeleted = @isDeleted) Entidades ON Entidades.IDEntidade = MovimentoEntidade.ID "); da.Fill(currentDataSet, "MovimentoEntidade"); } command.Parameters.Clear(); command.CommandText = "SELECT * FROM #ItemsID;"; SqlDataReader reader = command.ExecuteReader(); ArrayList row; while (reader.Read()) { row = new ArrayList(); row.Add(reader.GetValue(0)); row.Add(reader.GetValue(1)); row.Add(reader.GetValue(2)); row.Add(reader.GetValue(3)); rows.Add(row); } reader.Close(); } return(rows); }
public override void LoadControloAuts(DataSet currentDataSet, string[] designacoes, IDbConnection conn) { GisaDataSetHelperRule.ImportDesignacoes(designacoes, conn); using (SqlCommand command = new SqlCommand(string.Empty, (SqlConnection)conn)) { command.CommandText = "CREATE TABLE #aux (ID BIGINT, Termo NVARCHAR(768));"; command.ExecuteNonQuery(); command.Parameters.AddWithValue("@isDeleted", 0); command.CommandText = "INSERT INTO #aux " + "SELECT ID, Termo " + "FROM Dicionario " + "INNER JOIN #temp ON #temp.Designacao COLLATE LATIN1_GENERAL_CS_AS LIKE Termo COLLATE LATIN1_GENERAL_CS_AS " + "WHERE isDeleted = @isDeleted"; command.ExecuteNonQuery(); using (SqlDataAdapter da = new SqlDataAdapter(command)) { da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Dicionario"], "INNER JOIN #aux ON #aux.ID = Dicionario.ID "); da.Fill(currentDataSet, "Dicionario"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAut"], "INNER JOIN ControloAutDicionario cad ON cad.IDControloAut = ControloAut.ID AND cad.isDeleted = @isDeleted " + "INNER JOIN Dicionario d ON d.ID = cad.IDDicionario AND d.isDeleted = @isDeleted " + "INNER JOIN #aux ON #aux.ID = d.ID "); da.Fill(currentDataSet, "ControloAut"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAutDicionario"], "INNER JOIN Dicionario d ON d.ID = ControloAutDicionario.IDDicionario AND d.isDeleted = @isDeleted " + "INNER JOIN #aux ON #aux.ID = d.ID "); da.Fill(currentDataSet, "ControloAutDicionario"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN NivelControloAut nca ON nca.ID = Nivel.ID AND nca.isDeleted = @isDeleted " + "INNER JOIN ControloAut ca ON ca.ID = nca.IDControloAut AND ca.isDeleted = @isDeleted " + "INNER JOIN ControloAutDicionario cad ON cad.IDControloAut = ca.ID AND cad.isDeleted = @isDeleted " + "INNER JOIN Dicionario d ON d.ID = cad.IDDicionario AND d.isDeleted = @isDeleted " + "INNER JOIN #aux ON #aux.ID = d.ID "); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelControloAut"], "INNER JOIN ControloAut ca ON ca.ID = NivelControloAut.IDControloAut AND ca.isDeleted = @isDeleted " + "INNER JOIN ControloAutDicionario cad ON cad.IDControloAut = ca.ID AND cad.isDeleted = @isDeleted " + "INNER JOIN Dicionario d ON d.ID = cad.IDDicionario AND d.isDeleted = @isDeleted " + "INNER JOIN #aux ON #aux.ID = d.ID "); da.Fill(currentDataSet, "NivelControloAut"); } command.CommandText = "DROP TABLE #aux"; command.ExecuteNonQuery(); } }
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"); } }
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 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 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 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"); } }
// 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 LoadObjDigitalSimples(DataSet currentDataSet, long docID, long IDTipoNivelRelacionado, IDbConnection conn) { if (IDTipoNivelRelacionado < 9) { return; } using (var command = new SqlCommand("", (SqlConnection)conn)) using (SqlDataAdapter da = new SqlDataAdapter(command)) { command.CommandText = "CREATE TABLE #temp(ID BIGINT)"; command.ExecuteNonQuery(); // obter possiveis subdocumentos no caso do nivel documental actual ser um documento/processo if (IDTipoNivelRelacionado == 9) { command.CommandText = @" INSERT INTO #temp SELECT ID FROM RelacaoHierarquica WHERE IDUpper = @docID"; command.Parameters.AddWithValue("@docID", docID); command.ExecuteNonQuery(); } command.Parameters.AddWithValue("@isDeleted", 0); // carregar rows referentes só aos subdocumentos da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN #temp ON #temp.ID = Nivel.ID"); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"], "INNER JOIN #temp ON #temp.ID = NivelDesignado.ID"); da.Fill(currentDataSet, "NivelDesignado"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDocumentoSimples"], "INNER JOIN #temp ON #temp.ID = NivelDocumentoSimples.ID"); da.Fill(currentDataSet, "NivelDocumentoSimples"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"], "INNER JOIN #temp ON #temp.ID = RelacaoHierarquica.ID"); da.Fill(currentDataSet, "RelacaoHierarquica"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"], "INNER JOIN #temp ON #temp.ID = FRDBase.IDNivel"); da.Fill(currentDataSet, "FRDBase"); command.CommandText = "DROP TABLE #temp"; command.ExecuteNonQuery(); } }
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 void LoadDepositodDataForUpdate(DataSet currentDataSet, long depositoID, IDbTransaction tran) { using (SqlCommand command = new SqlCommand("", (SqlConnection)tran.Connection, (SqlTransaction)tran)) using (SqlDataAdapter da = new SqlDataAdapter(command)) { command.Parameters.AddWithValue("@depositoID", depositoID); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Deposito"], " WITH (UPDLOCK) WHERE ID = @depositoID"); da.Fill(currentDataSet, "Deposito"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelUnidadeFisica"], " WITH (UPDLOCK) WHERE IDDeposito = @depositoID"); da.Fill(currentDataSet, "NivelUnidadeFisica"); } }
public override void LoadUnidadesFisicas(DataSet currentDataSet, string[] codigos, IDbConnection conn) { GisaDataSetHelperRule.ImportDesignacoes(codigos, conn); using (SqlCommand command = new SqlCommand(string.Empty, (SqlConnection)conn)) { command.CommandText = "CREATE TABLE #aux (ID BIGINT, Termo NVARCHAR(50))"; command.ExecuteNonQuery(); command.Parameters.AddWithValue("@isDeleted", 0); command.CommandText = @" INSERT INTO #aux SELECT n.ID, n.Codigo FROM Nivel n INNER JOIN #temp ON #temp.Designacao COLLATE LATIN1_GENERAL_CS_AS LIKE n.Codigo COLLATE LATIN1_GENERAL_CS_AS WHERE n.isDeleted = @isDeleted"; command.ExecuteNonQuery(); using (SqlDataAdapter da = new SqlDataAdapter(command)) { da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN #aux ON #aux.ID = Nivel.ID "); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"], "INNER JOIN #aux ON #aux.ID = NivelDesignado.ID "); da.Fill(currentDataSet, "NivelDesignado"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"], "INNER JOIN #aux ON #aux.ID = FRDBase.IDNivel "); da.Fill(currentDataSet, "FRDBase"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"], "INNER JOIN #aux ON #aux.ID = RelacaoHierarquica.ID "); da.Fill(currentDataSet, "RelacaoHierarquica"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN RelacaoHierarquica ON RelacaoHierarquica.IDUpper = Nivel.ID " + "INNER JOIN #aux ON #aux.ID = RelacaoHierarquica.ID "); da.Fill(currentDataSet, "Nivel"); } command.CommandText = "DROP TABLE #aux"; command.ExecuteNonQuery(); } }
public override void fillRowsToOtherDataset(System.Data.DataTable table, System.Collections.ArrayList rows, System.Data.DataSet data, System.Data.IDbTransaction tran) { int contador = 0; StringBuilder s = new StringBuilder(); data.Tables.Add(table.Clone()); string baseSelectCommand = SqlSyntax.CreateSelectCommandText(table, "WHERE {0}", DBAbstractDataLayer.DataAccessRules.Syntax.DataDeletionStatus.All); using (SqlDataAdapter da = new SqlDataAdapter(new SqlCommand("", (SqlConnection)tran.Connection, (SqlTransaction)tran))) { // por cada linha da tabela modified ou deleted (as marcadas como added nao estao sujeitas a conflitos de concorrencia foreach (DataRow dr in rows) { contador++; s.Append("("); s.Append(buildFilter(table, dr).ToString()); s.Append(")"); // impedir que na query entre 1 "or" a mais if (contador % 200 != 0 && contador < rows.Count) { s.Append(" OR "); } // se ja tiverem sido obtidos 200 IDs, completar a query e executa-la e na base de dados if (contador % 200 == 0 || contador == rows.Count) { // executar comando sql obtido try { //System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand("", (System.Data.SqlClient.SqlConnection) tran.Connection, (System.Data.SqlClient.SqlTransaction) tran)); //da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommand(table, string.Format("where {0}", s), DBAbstractDataLayer.DataAccessRules.SqlClient.SqlSyntax.DataDeletionStatus.All); da.SelectCommand.CommandText = string.Format(baseSelectCommand, s); da.Fill(data, table.TableName); // limpar filtro para o voltar a encher com os proximos 50 s = new System.Text.StringBuilder(); } catch (Exception ex) { Trace.WriteLine(string.Format("Erro ({0}): {1}", table.TableName, ex)); throw; } } } } }
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 LoadDocumentos(DataSet currentDataSet, string[] designacoes, IDbConnection conn) { GisaDataSetHelperRule.ImportDesignacoes(designacoes, conn); using (SqlCommand command = new SqlCommand(string.Empty, (SqlConnection)conn)) { command.CommandText = "CREATE TABLE #aux (ID BIGINT, Termo NVARCHAR(768))"; command.ExecuteNonQuery(); command.Parameters.AddWithValue("@isDeleted", 0); command.CommandText = @" INSERT INTO #aux SELECT n.ID, nd.Designacao FROM Nivel n INNER JOIN #temp ON #temp.Designacao = n.ID INNER JOIN NivelDesignado nd ON nd.ID = n.ID AND nd.isDeleted = @isDeleted WHERE n.isDeleted = @isDeleted"; command.ExecuteNonQuery(); using (SqlDataAdapter da = new SqlDataAdapter(command)) { da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN #aux ON #aux.ID = Nivel.ID "); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelDesignado"], "INNER JOIN #aux ON #aux.ID = NivelDesignado.ID "); da.Fill(currentDataSet, "NivelDesignado"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["RelacaoHierarquica"], "INNER JOIN #aux ON #aux.ID = RelacaoHierarquica.ID "); da.Fill(currentDataSet, "RelacaoHierarquica"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN RelacaoHierarquica ON RelacaoHierarquica.IDUpper = Nivel.ID " + "INNER JOIN #aux ON #aux.ID = RelacaoHierarquica.ID "); da.Fill(currentDataSet, "Nivel"); } command.CommandText = "DROP TABLE #aux"; command.ExecuteNonQuery(); } }
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 decimal LoadDescricaoFisicaAndGetSomatorioLargura(DataSet currentDataSet, long[] ufIDs, IDbConnection conn) { GisaDataSetHelperRule.ImportIDs(ufIDs, conn); decimal total = 0; var cmd = @" SELECT COUNT(df.MedidaLargura) FROM FRDBase frd INNER JOIN #temp ON #temp.ID = frd.IDNivel LEFT JOIN SFRDUFDescricaoFisica df ON df.IDFRDBase = frd.ID AND df.isDeleted = @isDeleted WHERE frd.isDeleted = @isDeleted"; using (var command = new SqlCommand(cmd, (SqlConnection)conn)) using (var da = new SqlDataAdapter(command)) { command.Parameters.AddWithValue("@isDeleted", 0); total = System.Convert.ToDecimal(command.ExecuteScalar()); // carregar informação dos niveis documentais associados às ufs da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN FRDBase ON FRDBase.IDNivel = Nivel.ID " + "INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " + "INNER JOIN #temp ON #temp.ID = SFRDUnidadeFisica.IDNivel"); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"], "INNER JOIN SFRDUnidadeFisica ON SFRDUnidadeFisica.IDFRDBase = FRDBase.ID " + "INNER JOIN #temp ON #temp.ID = SFRDUnidadeFisica.IDNivel"); da.Fill(currentDataSet, "FRDBase"); // carregar informação das ufs da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], "INNER JOIN #temp ON #temp.ID = Nivel.ID"); da.Fill(currentDataSet, "Nivel"); da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["SFRDUnidadeFisica"], "INNER JOIN #temp ON #temp.ID = SFRDUnidadeFisica.IDNivel"); da.Fill(currentDataSet, "SFRDUnidadeFisica"); } return(total); }
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 ICollection LoadNivelControloAut(DataSet currentDataSet, ArrayList IDs, IDbConnection conn) { foreach (long id in IDs) { DBAbstractDataLayer.DataAccessRules.NivelRule.Current.LoadControloAutChildren(id, currentDataSet, conn); DBAbstractDataLayer.DataAccessRules.NivelRule.Current.LoadNivelControloAutChildrenByCA(id, currentDataSet, conn); } ArrayList NivelIDs = new ArrayList(); string query = string.Format(" INNER JOIN NivelControloAut nca ON nca.ID = Nivel.ID WHERE nca.isDeleted=0 AND nca.IDControloAut IN ({0})", longCollectionToCommaDelimitedString(IDs)); string cmd = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"], query); SqlCommand command = new SqlCommand(cmd, (SqlConnection)conn); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { NivelIDs.Add(reader.GetValue(0)); } reader.Close(); return(NivelIDs); }