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; } }