public List <Det_promotor> get_cantidades(int promotor, string Fecha1, string Fecha2) { string query = "select tbadetticket.descripcion, tbaproductos.codigo, tbadetticket.cantidad,sum(tbadetticket.total) as vendido from tbadetticket inner join tbaproductos on tbadetticket.id_producto=tbaproductos.id inner join tbatickets on tbadetticket.id_ticket=tbatickets.folio"; if (Fecha1 == Fecha2) { query = query + " where tbatickets.atendio='" + promotor + "' and DATE_FORMAT(tbatickets.fecha,'%Y-%m-%d')='" + Fecha1 + "' group by tbaproductos.codigo order by tbadetticket.cantidad"; } else { query = query + " where tbatickets.atendio='" + promotor + "' and DATE_FORMAT(tbatickets.fecha,'%Y-%m-%d') BETWEEN '" + Fecha1 + "' and '" + Fecha2 + "' group by tbaproductos.codigo order by tbadetticket.cantidad"; } MySqlDataReader data = runQuery(query); List <Det_promotor> result = new List <Det_promotor>(); if (data.HasRows) { while (data.Read()) { Det_promotor item = build_promotor(data); result.Add(item); } } return(result); }
private Det_promotor build_promotor(MySqlDataReader data) { Det_promotor item = new Det_promotor( data.GetString("codigo"), data.GetString("descripcion"), data.GetDouble("cantidad"), data.GetDouble("vendido") ); return(item); }