private Planillas SelectOnePlanillas(Int16 EMPR_Codigo, String PLAN_Tipo, String PLAN_Codigo)
{
try
{
Planillas item = new Planillas();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_PLANSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrPLAN_Tipo", PLAN_Tipo, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchPLAN_Codigo", PLAN_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
LoaderPlanillas = new BusinessEntityLoader <Planillas>();
LoaderPlanillas.EntityType = item.GetType();
LoaderPlanillas.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception)
{ throw; }
}
public BLPlanillas(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <Planillas>();
Planillas Item = new Planillas();
Loader.EntityType = Item.GetType();
}
