public List <TValue> CarregaCmbGrupos <TValue>(CreateInstanceBindingHandler <TValue> binding)
{
return(SqlHelperFactory.GetListCreateInstanceDB <TValue>(
SGSI.Settings.Settings.Default.InstanceDB,
"CarregaCmbGrupo",
binding));
}
public List <TValue> CarregaHistoricoProc <TValue>(CreateInstanceBindingHandler <TValue> binding, int procedimentoId)
{
return(SqlHelperFactory.GetListCreateInstanceDB <TValue>(
SGSI.Settings.Settings.Default.InstanceDB,
"CarregaHistoricoProcedimento",
binding,
new object[] {
procedimentoId
}));
}
public List <TValue> CarregarCmbFuncionarios <TValue>(CreateInstanceBindingHandler <TValue> binding, int dptoId)
{
return(SqlHelperFactory.GetListCreateInstanceDB <TValue>(
SGSI.Settings.Settings.Default.InstanceDB,
"CarregaCmbFuncionario",
binding,
new object[] {
dptoId
}));
}
public List <TValue> CarregaHistoricoNorma <TValue>(CreateInstanceBindingHandler <TValue> binding, int normaId)
{
return(SqlHelperFactory.GetListCreateInstanceDB <TValue>(
SGSI.Settings.Settings.Default.InstanceDB,
"CarregaHistoricoNormas",
binding,
new object[] {
normaId
}));
}
internal static TValue SqlDataReaderToObject <TValue>(IDataReader sdrReader, CreateInstanceBindingHandler <TValue> binding)
{
// GSB - 07032003 - Declara e inicializa objetos
TValue objEntidade = default(TValue);
// GSB - 07032003 - Varre os registros e converte o Data Reader em um Array de Entidades
if (sdrReader.Read())
{
objEntidade = binding(sdrReader);
}
sdrReader.Close();
return(objEntidade);
}
/// <summary>
///
/// </summary>
/// <typeparam name="TValue"></typeparam>
/// <param name="instanceDb"></param>
/// <param name="storedProcedureName"></param>
/// <param name="binding"></param>
/// <returns></returns>
public static List <TValue> GetListCreateInstanceDB <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding)
{
if (log.IsInfoEnabled)
{
log.InfoFormat("GetListCreateInstanceDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName);
}
SqlDatabase db = null;
DbCommand commandWrapper = null;
db = DatabaseFactory.CreateDatabase(instanceDb) as SqlDatabase;
List <TValue> returnValue = new List <TValue>();
using (commandWrapper = db.GetStoredProcCommand(storedProcedureName))
{
IDataReader sdrReader = db.ExecuteReader(commandWrapper);
while (sdrReader.Read())
{
returnValue.Add(binding(sdrReader));
}
sdrReader.Close();
}
return(returnValue);
}
public static List <TValue> GetListCreateInstanceDB <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding, object[] parameterValues)
{
return(GetListCreateInstanceDB(instanceDb, storedProcedureName, binding, parameterValues, null));
}
public static TValue SqlDataReaderToObject <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding, params object[] parameterValues)
{
Database db = null;
DbCommand commandWrapper = null;
db = DatabaseFactory.CreateDatabase(instanceDb);
TValue returnValue;
using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues))
{
returnValue = SqlHelperFactory.SqlDataReaderToObject <TValue>(db.ExecuteReader(commandWrapper), binding);
}
return(returnValue);
}
/// <summary>
///
/// </summary>
/// <typeparam name="TValue"></typeparam>
/// <param name="instanceDb"></param>
/// <param name="storedProcedureName"></param>
/// <param name="binding"></param>
/// <param name="parameterValues"></param>
/// <returns></returns>
public static TValue GetObjectDB <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding, params object[] parameterValues)
{
if (log.IsInfoEnabled)
{
log.InfoFormat("GetObjectDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName);
}
return(SqlHelperFactory.SqlDataReaderToObject <TValue>(instanceDb, storedProcedureName, binding, parameterValues));
}
