public List <VentaVO> GetVentaList(BaseGridVO filtro) { List <VentaVO> lista = new List <VentaVO>(); MySqlDataReader dr = null; try { string query = "sp_Ventas_select_lista"; MySqlCommand comando = this.Conexion.CreateCommand(); comando.CommandType = CommandType.StoredProcedure; comando.CommandText = query; comando.Parameters.Add("p_campobusqueda", MySqlDbType.VarChar).Value = filtro.campobusqueda ?? string.Empty; comando.Parameters.Add("p_valorbusqueda", MySqlDbType.VarChar).Value = filtro.valorbusqueda ?? string.Empty; comando.Parameters.Add("p_numeropagina", MySqlDbType.Int32).Value = filtro.pagina; comando.Parameters.Add("p_porpagina", MySqlDbType.Int32).Value = filtro.porpagina; comando.Parameters.Add("p_orderby", MySqlDbType.VarChar).Value = filtro.orderby; comando.Parameters.Add("p_ordertype", MySqlDbType.VarChar).Value = filtro.ordertype; // Se toma el valor devuelto dr = comando.ExecuteReader(); if (dr.HasRows) { VentaVO vo; while (dr.Read()) { vo = new VentaVO(); vo.Clave = dr.GetInt32(dr.GetOrdinal("Clave")); vo.Cliente = dr.GetInt32(dr.GetOrdinal("Cliente")); vo.ClienteNombre = dr["ClienteNombre"].ToString(); vo.Folio = dr["Folio"].ToString(); vo.TotalT = dr.GetDecimal(dr.GetOrdinal("TotalT")); var Fecha = Convert.ToDateTime(dr["Fecha"]); vo.Fecha = Fecha.ToString("yyyy-MM-dd"); //vo.RFC = dr["RFC"].ToString(); vo.total = Convert.ToInt32(dr["total"]); lista.Add(vo); } } } catch (Exception Ex) { throw Ex; } finally { if (dr != null && !dr.IsClosed) { dr.Close(); } dr = null; } return(lista); }
public List <ArticuloVO> GetArticuloList(BaseGridVO filtro) { List <ArticuloVO> lista = new List <ArticuloVO>(); MySqlDataReader dr = null; try { string query = "sp_Articulos_select_lista"; MySqlCommand comando = this.Conexion.CreateCommand(); comando.CommandType = CommandType.StoredProcedure; comando.CommandText = query; comando.Parameters.Add("p_campobusqueda", MySqlDbType.VarChar).Value = filtro.campobusqueda ?? string.Empty; comando.Parameters.Add("p_valorbusqueda", MySqlDbType.VarChar).Value = filtro.valorbusqueda ?? string.Empty; comando.Parameters.Add("p_numeropagina", MySqlDbType.Int32).Value = filtro.pagina; comando.Parameters.Add("p_porpagina", MySqlDbType.Int32).Value = filtro.porpagina; comando.Parameters.Add("p_orderby", MySqlDbType.VarChar).Value = filtro.orderby; comando.Parameters.Add("p_ordertype", MySqlDbType.VarChar).Value = filtro.ordertype; // Se toma el valor devuelto dr = comando.ExecuteReader(); if (dr.HasRows) { ArticuloVO vo; while (dr.Read()) { vo = new ArticuloVO(); vo.Clave = dr.GetInt32(dr.GetOrdinal("Clave")); vo.Descripcion = dr["Descripcion"].ToString(); vo.Modelo = dr["Modelo"].ToString(); vo.Precio = dr.GetDecimal(dr.GetOrdinal("Precio")); vo.Existencia = dr.GetInt32(dr.GetOrdinal("Existencia")); vo.total = Convert.ToInt32(dr["total"]); lista.Add(vo); } } } catch (Exception Ex) { throw Ex; } finally { if (dr != null && !dr.IsClosed) { dr.Close(); } dr = null; } return(lista); }
public List <ArticuloVO> GetArticuloList(BaseGridVO filtro) { try { return(this.Con.GetArticuloList(filtro)); } catch (CCExcepcion) { throw; } catch (Exception ex) { throw new CCExcepcion(ex); } }
public List <ClienteVO> GetClienteList(BaseGridVO filtro) { try { return(this.Con.GetClienteList(filtro)); } catch (CCExcepcion) { throw; } catch (Exception ex) { throw new CCExcepcion(ex); } }
public ActionResult GetVentaGrid(BaseGridVO filtro) { try { if (filtro.orderby == null || filtro.orderby == string.Empty) { filtro.orderby = "clave"; } if (filtro.ordertype == null || filtro.ordertype == string.Empty) { filtro.ordertype = "asc"; } filtro.porpagina = 10; filtro.realPath = Server.MapPath("~/XmlGrids/" + filtro.xmlgrid + ".xml"); VentasBS BS = new VentasBS(); List <VentaVO> dataSource = BS.GetVentaList(filtro); int total = 0; if (dataSource.Count > 0) { total = dataSource[0].total; } List <object> listaGrid = dataSource.ToList <object>(); listaGrid.Add(total); LazyLoadDatagrid lazyGrid = new LazyLoadDatagrid(); lazyGrid.regresaLazyLoadDatagrid(filtro.realPath, filtro.objJavascript, listaGrid); return(Content(lazyGrid.stbHtml.ToString())); } catch (Exception ex) { return(Json(ParseException(new CCExcepcion(ex)))); } }
public LazyLoadDatagrid(BaseGridVO f) { this.show = f.porpagina; }