private static ActivityListing GenerateListing(StdBELista queryResult) { return(new ActivityListing { Tipo = TypeReference(queryResult), DataFim = TypeParser.Date(queryResult.Valor("DataFim")), Resumo = TypeParser.String(queryResult.Valor("Resumo")), Estado = TypeParser.Integer(queryResult.Valor("Estado")), Identificador = TypeParser.String(queryResult.Valor("Id")), DataInicio = TypeParser.Date(queryResult.Valor("DataInicio")), Prioridade = TypeParser.Integer(queryResult.Valor("Prioridade")), DataModificacao = TypeParser.Date(queryResult.Valor("DataUltAct")) }); }
public static List <CategoryListing> List() { if (PrimaveraEngine.InitializeCompany() == false) { throw new DatabaseConnectionException(); } var categoryList = new List <CategoryListing>(); var categoryInfo = PrimaveraEngine.Consulta(new SqlBuilder() .FromTable("FAMILIAS") .Columns(sqlColumnsFull) .InnerJoin("ARTIGO", "Familia", Comparison.Equals, "FAMILIAS", "Familia") .GroupBy(new string[] { "FAMILIAS.Familia", "FAMILIAS.Descricao" })); if (categoryInfo == null || categoryInfo.Vazia()) { return(categoryList); } while (!categoryInfo.NoFim()) { categoryList.Add(new CategoryListing() { Identificador = TypeParser.String(categoryInfo.Valor("Familia")), Descricao = TypeParser.String(categoryInfo.Valor("Descricao")), NumeroProdutos = TypeParser.Integer(categoryInfo.Valor("Count")) }); categoryInfo.Seguinte(); } categoryList.Sort(delegate(CategoryListing lhs, CategoryListing rhs) { if (lhs.Identificador == null || rhs.Identificador == null) { return(-1); } return(lhs.Descricao.CompareTo(rhs.Descricao)); }); return(categoryList); }
public static List<QuoteListing> List() { if (PrimaveraEngine.InitializeCompany() == false) { throw new DatabaseConnectionException(); } var query = new SqlBuilder() .FromTable("CabecDoc") .Columns(sqlQuoteListing) .Where("TipoDoc", Comparison.Equals, "ECL") .Where("Serie", Comparison.Equals, QuotesConstants.serie); query.AddOrderBy("NumDoc", Sorting.Descending); var queryObject = PrimaveraEngine.Consulta(query); if (queryObject == null || queryObject.Vazia()) { return null; } var queryResult = new List<QuoteListing>(); while (!queryObject.NoFim()) { queryResult.Add(new QuoteListing { NumEncomenda = TypeParser.Integer(queryObject.Valor("NumDoc")), Cliente = TypeParser.String(queryObject.Valor("Entidade")), NomeCliente = TypeParser.String(queryObject.Valor("Nome")), TotalDocumento = TypeParser.Double(queryObject.Valor("TotalDocumento")), Data = TypeParser.Date(queryObject.Valor("Data")) }); queryObject.Seguinte(); } return queryResult; }
public static QuoteInfo View(string sessionId, string quoteId) { if (PrimaveraEngine.InitializeCompany() == false) { throw new DatabaseConnectionException(); } var quoteInfo = PrimaveraEngine.Consulta(new SqlBuilder() .FromTable("CabecDoc") .Columns(sqlQuoteColumns) .Where("TipoDoc", Comparison.Equals, QuotesConstants.tipoDoc) .Where("NumDoc", Comparison.Equals, quoteId) .Where("Serie", Comparison.Equals, QuotesConstants.serie)); if (quoteInfo == null || quoteInfo.Vazia()) { throw new NotFoundException("encomenda", true); } if (TypeParser.String(quoteInfo.Valor("Responsavel")) != sessionId) { return null; } List<OrderInfo> quoteProducts = new List<OrderInfo>(); var productsInfo = PrimaveraEngine.Consulta(new SqlBuilder() .FromTable("LinhasDoc") .Columns(sqlProductsColumns) .Where("IdCabecDoc", Comparison.Equals, quoteInfo.Valor("Id"))); while (!productsInfo.NoFim()) { quoteProducts.Add(new OrderInfo { Quantidade = TypeParser.Integer(productsInfo.Valor("Quantidade")), Preco = TypeParser.Double(productsInfo.Valor("PrecUnit")), Desconto = TypeParser.Double(productsInfo.Valor("Desconto1")), Iva = TypeParser.Double(productsInfo.Valor("TaxaIva")), Unidade = TypeParser.String(productsInfo.Valor("Unidade")), Produto = new Reference(TypeParser.String(productsInfo.Valor("Artigo")), TypeParser.String(productsInfo.Valor("Descricao"))) }); productsInfo.Seguinte(); } return new QuoteInfo { NumEncomenda = TypeParser.Integer(quoteInfo.Valor("NumDoc")), Cliente = TypeParser.String(quoteInfo.Valor("Entidade")), NomeCliente = TypeParser.String(quoteInfo.Valor("Nome")), EnderecoEntrega = new Address { Morada = TypeParser.String(quoteInfo.Valor("Morada")), CodigoPostal = TypeParser.String(quoteInfo.Valor("CodPostal")), Localidade = TypeParser.String(quoteInfo.Valor("Localidade")), Distrito = LocationIntegration.DistritoReference(TypeParser.String(quoteInfo.Valor("Distrito"))), Pais = TypeParser.String(quoteInfo.Valor("Pais")) }, Data = TypeParser.Date(quoteInfo.Valor("Data")), IdOportunidade = TypeParser.String(quoteInfo.Valor("IdOportunidade")), TotalDesc = TypeParser.Double(quoteInfo.Valor("TotalDesc")), TotalIva = TypeParser.Double(quoteInfo.Valor("TotalIva")), TotalMerc = TypeParser.Double(quoteInfo.Valor("TotalMerc")), TotalDocumento = TypeParser.Double(quoteInfo.Valor("TotalDocumento")), NumContribuinte = TypeParser.String(quoteInfo.Valor("NumContribuinte")), Produtos = quoteProducts }; }