예제 #1
0
        public FaltanteStock calcularFaltanteStock(int sucursal_id, string anio)
        {
            SqlParameter param_prod = new SqlParameter("@out_prod", System.Data.SqlDbType.Int);
            SqlParameter param_dias = new SqlParameter("@out_dias", System.Data.SqlDbType.Int);

            param_prod.Direction = System.Data.ParameterDirection.Output;
            param_dias.Direction = System.Data.ParameterDirection.Output;
            param_prod.Value     = 0;

            List <SqlParameter> param_set = new List <SqlParameter>()
            {
                new SqlParameter("@suc", sucursal_id),
                new SqlParameter("@anio", anio),
                param_prod,
                param_dias
            };

            connection.procedure(TABLERO_FALTANTE_STOCK, param_set);

            return((int)param_prod.Value == 0 ? new NullFaltanteStock() : new FaltanteStock((int)param_prod.Value, (int)param_dias.Value));
        }