示例#1
0
        public static List <Proveedor> ConsultaProveedoresProductos()
        {
            List <Proveedor> proveedores = new List <Proveedor>();
            QueryResult      result      = executor.ExecuteQuery("SELECT * FROM proveedor");

            if (result.Status != ExecutorStatus.ERROR_DURING_PROCESS)
            {
                for (int r = 0; r < result.RowCount; r++)
                {
                    Proveedor prov = new Proveedor();
                    for (int c = 0; c < result.ColumnCount; c++)
                    {
                        prov.AgregaCampo(result.Columns[c].Name, new QueryResultData(result[r][result.Columns[c].Name].Value));
                    }
                    proveedores.Add(prov);
                }
                return(proveedores);
            }
            throw result.Exception;
        }