public Common.Gastos getGastos(int idCliente=0)
{
var dataSetGastos = new Common.Gastos();
using (MySqlConnection MidbConexion = new MySqlConnection(this.dbPath))
{
MidbConexion.Open();
MySqlCommand miComando = new MySqlCommand()
{
Connection=MidbConexion
};
if (idCliente>0)
{
miComando.CommandText = "SELECT*FROM total_gasto WHERE ID_CLIENTE=?id_cliente ORDER BY CLV_ORDEN ASC";
miComando.Parameters.AddWithValue("?id_cliente", idCliente);
}
else
{
miComando.CommandText = "SELECT*FROM total_gasto ORDER BY CLV_ORDEN ASC";
}
miAdaptador.SelectCommand = miComando;
miAdaptador.Fill(dataSetGastos,"total_gasto");
return dataSetGastos;
}
}
public Common.Gastos getTicket(int clvOrden)
{
var dataSetGastos = new Common.Gastos();
using (MySqlConnection MidbConexion = new MySqlConnection(this.dbPath))
{
MidbConexion.Open();
MySqlCommand miComando = new MySqlCommand()
{
Connection = MidbConexion
};
miComando.CommandText = "SELECT*FROM total_gasto WHERE clv_orden=?clv";
miComando.Parameters.AddWithValue("?clv", clvOrden);
miAdaptador.SelectCommand = miComando;
miAdaptador.Fill(dataSetGastos, "total_gasto");
return dataSetGastos;
}
}
