public RRemenanente InfoRemanente(int iAnio)
{
RRemenanente remanente = null;
//SqlConnection _sqlConnection = new SqlConnection(Properties.Settings.Default.LXSOConnectionString);
SqlConnection _sqlConnection = new SqlConnection(ConnectionString.DbMPYOpera);
SqlCommand _SqlCommand = new SqlCommand("LSOSPS_Reporte_Remanente", _sqlConnection)
{
CommandType = CommandType.StoredProcedure
};
_SqlCommand.Parameters.Add("@Anio", SqlDbType.BigInt).Value = iAnio;
try
{
_sqlConnection.Open();
SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
if (_SqlDataReader.HasRows)
{
while (_SqlDataReader.Read())
{
remanente = new RRemenanente()
{
dBono = decimal.Parse(_SqlDataReader["Bono"].ToString()),
dComision = decimal.Parse(_SqlDataReader["Comision"].ToString()),
dBonoComision = decimal.Parse(_SqlDataReader["Bono + Comision"].ToString()),
dImporte = decimal.Parse(_SqlDataReader["Importe"].ToString()),
dRemanente = decimal.Parse(_SqlDataReader["Remanente"].ToString())
};
}
}
}
catch (Exception)
{
remanente = null;
}
finally
{
_sqlConnection.Close();
}
return(remanente);
}
public List <RRemenanente> lRemanente(int iAnio)
{
List <RRemenanente> lista = new List <RRemenanente>();
//SqlConnection _SqlConnection = new SqlConnection(Properties.Settings.Default.LXSOConnectionString);
SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPYOpera);
SqlCommand _SqlCommand = new SqlCommand("LSOSPS_Reporte_RemanenteRegistros", _SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
_SqlCommand.Parameters.Add("@Anio", SqlDbType.BigInt).Value = iAnio;
try
{
_SqlConnection.Open();
SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
if (_SqlDataReader.HasRows)
{
while (_SqlDataReader.Read())
{
RRemenanente comision = new RRemenanente()
{
iIdOperacionComisionista = int.Parse(_SqlDataReader["IdOperacionComisionista"].ToString()),
sVendedor = _SqlDataReader["Vendedor"].ToString(),
sTipo = _SqlDataReader["Tipo"].ToString(),
dImporteR = decimal.Parse(_SqlDataReader["Importe"].ToString())
};
lista.Add(comision);
}
}
}
catch (Exception)
{
lista = null;
}
finally
{
_SqlConnection.Close();
}
return(lista);
}