public abstract void FillTableInGetLinhasConcorrentes(DataSet ds, DataTable table, string query, DBAbstractDataLayer.DataAccessRules.Syntax.DataDeletionStatus status, IDbTransaction tran);
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;
}
}
