public void lista_utilizadores()
{
init();
StdBELista uList = _admBs.Consulta("SELECT * FROM utilizadores");
uList.Inicio();
while (!uList.NoFim())
{
CultureInfo idioma = CultureInfo.GetCultureInfo(uList.Valor("Idioma"));
Console.WriteLine("Utilizador: " + uList.Valor("Codigo"));
Console.WriteLine(" Codigo: " + uList.Valor("Codigo"));
Console.WriteLine(" Nome: " + uList.Valor("Nome"));
Console.WriteLine(" Email: " + uList.Valor("Email"));
Console.WriteLine(" Activo: " + uList.Valor("Activo"));
Console.WriteLine(" Administrador: " + uList.Valor("Administrador"));
Console.WriteLine(" PerfilSugerido: " + uList.Valor("PerfilSugerido"));
Console.WriteLine(" NaoPodeAlterarPwd: " + uList.Valor("NaoPodeAlterarPwd"));
Console.WriteLine(" Idioma: " + idioma);
Console.WriteLine(" LoginWindows: " + uList.Valor("LoginWindows"));
Console.WriteLine(" Telemovel: " + uList.Valor("Telemovel"));
Console.WriteLine(" Bloqueado: " + uList.Valor("Bloqueado"));
Console.WriteLine(" TentativasFalhadas: " + uList.Valor("TentativasFalhadas"));
Console.WriteLine(" AutenticacaoPersonalizada: " + uList.Valor("AutenticacaoPersonalizada"));
Console.WriteLine(" SuperAdministrador: " + uList.Valor("SuperAdministrador"));
Console.WriteLine(" Tecnico: " + uList.Valor("Tecnico"));
uList.Seguinte();
}
return;
}
public static Lib_Primavera.Model.Artigo GetArtigo(string codArtigo)
{
ErpBS objMotor = new ErpBS();
Model.Artigo myArtigo = new Model.Artigo();
if (PriEngine.InitializeCompany(ConfigurationConstants.NAME_COMPANY, ConfigurationConstants.USERNAME, ConfigurationConstants.PASSWORD) == true)
{
if (PriEngine.Engine.Comercial.Artigos.Existe(codArtigo) == true)
{
StdBELista objArtigo = PriEngine.Engine.Consulta("SELECT ARTIGO.Artigo AS Artigo, ARTIGO.Descricao AS Descricao, PVP1, Iva, FAMILIAS.Descricao AS Familia, STKActual, ANEXOS.Id AS Id, ANEXOS.FicheiroOrig AS FicheiroOrig, ANEXOS.Descricao AS AnexosDesc "
+ "FROM ARTIGO, ARTIGOMOEDA, FAMILIAS, ANEXOS "
+ "WHERE ARTIGO.Artigo = '" + codArtigo + "' AND ARTIGO.Artigo = ARTIGOMOEDA.Artigo AND FAMILIAS.Familia = ARTIGO.Familia AND ANEXOS.Chave = ARTIGO.Artigo");
myArtigo.CodArtigo = objArtigo.Valor("Artigo");
myArtigo.Descricao = objArtigo.Valor("Descricao");
myArtigo.Preco = objArtigo.Valor("PVP1");
myArtigo.IVA = objArtigo.Valor("Iva");
myArtigo.StkAtual = objArtigo.Valor("STKActual");
myArtigo.Familia = objArtigo.Valor("Familia");
myArtigo.Imagem = objArtigo.Valor("Id") + '.' + objArtigo.Valor("FicheiroOrig").Split('.')[1];
myArtigo.DescricaoImg = objArtigo.Valor("AnexosDesc");
return(myArtigo);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
bool isArtigoConjunto(String artigo)
{
StdBELista tblArtigo = new StdBELista();
bool rv = false;
try
{
tblArtigo = BSO.Consulta("select TipoComponente from Artigo where Artigo = '" + artigo + "'");
//alterar armazem dos artigos na linha
if (tblArtigo.Vazia() == false)
{
rv = tblArtigo.DaValor <int>("TipoComponente") == 1 ? true : false;
}
}
catch (Exception err)
{
PSO.Dialogos.MostraErro("[Consulta Artigo]: " + err.ToString());
rv = false;
}
return(rv);
}
public static List <Artigo> ListaArtigosbyTipo(int id)
{
List <Artigo> artigos = new List <Artigo>();
if (PriEngine.InitializeCompany(ElectroSinf.Properties.Settings.Default.Company.Trim(), ElectroSinf.Properties.Settings.Default.User.Trim(), ElectroSinf.Properties.Settings.Default.Password.Trim()) == true)
{
StdBELista lst = PriEngine.Engine.Consulta("SELECT Artigo.Artigo,STKActual,Descricao,IVA,PVP1 FROM Artigo JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo WHERE CDU_Tipo=" + id);
Artigo art;
while (!lst.NoFim())
{
art = new Artigo();
art.CodArtigo = lst.Valor("Artigo");
art.DescArtigo = lst.Valor("Descricao");
art.Stock = Convert.ToDouble(lst.Valor("STKActual"));
art.Preco = Math.Round(lst.Valor("PVP1") * (1 + Convert.ToDouble(lst.Valor("IVA")) / 100.0), 2);
artigos.Add(art);
lst.Seguinte();
}
return(artigos);
}
else
{
return(null);
}
}
public static List <Sale> GetSales(DateTime initialDate, DateTime finalDate)
{
// Create an empty list of sales
List <Sale> sales = new List <Sale>();
//Initialize company
if (!InitializeCompany())
{
return(sales);
}
//DataDescarga always null ?
StdBELista salesQuery = PriEngine.Engine.Consulta(
"SELECT CabecDoc.Id AS CabecDocId, CabecDoc.Nome AS CabecDocNome, CabecDoc.Entidade AS CabecDocEntidade, CabecDoc.Moeda AS CabecDocMoeda, CabecDoc.TipoDoc AS CabecDocTipoDoc, CabecDoc.Data AS CabecDocData, CabecDoc.DataVencimento AS CabecDocDataVencimento, CabecDoc.DataCarga AS CabecDocDataCarga, CabecDoc.DataDescarga AS CabecDocsDataDescarga, " +
"LinhasDoc.Id AS LinhasDocId, LinhasDoc.PrecoLiquido AS LinhasDocPrecoLiquido, " +
"Artigo.Artigo AS ArtigoId, Artigo.Marca AS ArtigoMarca, Artigo.Modelo AS ArtigoModelo, Artigo.Descricao AS ArticoDescricao, Artigo.TipoArtigo AS ArtigoTipoArtigo, " +
"Familias.Familia AS FamiliaId, Familias.Descricao AS FamiliaDescricao, " +
"Iva.Taxa AS IvaTaxa " +
"FROM CabecDoc " +
"INNER JOIN LinhasDoc ON LinhasDoc.IdCabecDoc = CabecDoc.Id " +
"INNER JOIN Artigo ON Artigo.Artigo = LinhasDoc.Artigo " +
"INNER JOIN Familias ON Artigo.Familia = Familias.Familia " +
"INNER JOIN Iva ON LinhasDoc.CodIva = Iva.Iva " +
"WHERE CabecDoc.Data >= '" + initialDate.ToString("yyyyMMdd") + "' AND CabecDoc.Data <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY CabecDoc.Data"
);
while (!salesQuery.NoFim())
{
Sale sale = new Sale();
sale.ID = salesQuery.Valor("LinhasDocId");
sale.DocumentDate = ParseDate(salesQuery, "CabecDocData");
sale.DocumentType = salesQuery.Valor("CabecDocTipoDoc");
sale.DueDate = ParseDate(salesQuery, "CabecDocDataVencimento");
sale.ReceptionDate = ParseDate(salesQuery, "CabecDocsDataDescarga");
sale.ClientId = salesQuery.Valor("CabecDocEntidade");
sale.ClientName = salesQuery.Valor("CabecDocNome");
sale.Value = new Money(salesQuery.Valor("LinhasDocPrecoLiquido"), salesQuery.Valor("CabecDocMoeda"));
sale.Iva = salesQuery.Valor("IvaTaxa") / 100.0;
Product product = new Product();
product.Id = salesQuery.Valor("ArtigoId");
product.Brand = salesQuery.Valor("ArtigoMarca");
product.Model = salesQuery.Valor("ArtigoModelo");
product.Description = salesQuery.Valor("ArticoDescricao");
product.FamilyId = salesQuery.Valor("FamiliaId");
product.FamilyDescription = salesQuery.Valor("FamiliaDescricao");
sale.Product = product;
sales.Add(sale);
// Next item:
salesQuery.Seguinte();
}
return(sales);
}
private static Opportunity GenerateListing(StdBELista opportunityInfo)
{
return(new Opportunity()
{
Entity = TypeParser.String(opportunityInfo.Valor("Entidade")),
Campaign = TypeParser.String(opportunityInfo.Valor("Campanha")),
SellCycle = TypeParser.String(opportunityInfo.Valor("CicloVenda")),
ExpirationDate = TypeParser.Date(opportunityInfo.Valor("DataExpiracao")),
RealDateOrdered = TypeParser.Date(opportunityInfo.Valor("DataRealEncomenda")),
Description = TypeParser.String(opportunityInfo.Valor("Descricao")),
MarginOV = TypeParser.Double(opportunityInfo.Valor("MargemOV")),
ProposedValueOV = TypeParser.Double(opportunityInfo.Valor("MargemPercOV")),
Origin = TypeParser.String(opportunityInfo.Valor("Origem")),
Seller = TypeParser.String(opportunityInfo.Valor("Vendedor")),
CreatedBy = TypeParser.String(opportunityInfo.Valor("CriadoPor")),
RealBillingDate = TypeParser.Date(opportunityInfo.Valor("DataRealFacturacao")),
ClosureDate = TypeParser.Date(opportunityInfo.Valor("DataFecho")),
LossMotive = TypeParser.String(opportunityInfo.Valor("MotivoPerda")),
OpportunityId = TypeParser.String(opportunityInfo.Valor("Oportunidade")),
Currency = TypeParser.String(opportunityInfo.Valor("Moeda")),
Identificador = TypeParser.String(opportunityInfo.Valor("ID")),
Brief = TypeParser.String(opportunityInfo.Valor("Resumo")),
Zone = TypeParser.String(opportunityInfo.Valor("Zona")),
Status = opportunityInfo.Valor("EstadoVenda"),
EntityType = TypeParser.String(opportunityInfo.Valor("TipoEntidade")),
TotalValueOV = TypeParser.Double(opportunityInfo.Valor("ValorTotalOV"))
});
}
public ActionResult Login(UserCheckOut objUser)
{
//StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao from FAMILIAS WHERE Familia LIKE 'COMP'");
StdBELista objList = PriEngine.Engine.Consulta("SELECT UserId from USERPROFILE WHERE UserName LIKE 'Jaquim' AND Password LIKE 'teste'");
System.Diagnostics.Debug.WriteLine("1 " + objList.Valor("UserId"));
if (ModelState.IsValid)
{
System.Diagnostics.Debug.WriteLine("2 " + objList.Valor("UserId"));
// System.Diagnostics.Debug.WriteLine("USER ID das " + objList.Valor("Descricao"));
// System.Diagnostics.Debug.WriteLine("USER ID "+objList.Valor("UserId"));
if (objList.Valor("UserId") != null)
{
/*UserCheckOut tempUser = Lib_Primavera.PriIntegration.GetUserProf(objUser.UserCod);
* Session["UserID"] = tempUser.UserCod.ToString();
* Session["UserName"] = tempUser.UserName.ToString();
* return RedirectToAction("UserDashBoard");*/
}
}
return(View(objUser));
}
internal static List <Armazem_stock> getStock_armazem(string CodArtigo)
{
List <Armazem_stock> stock_armazem = new List <Armazem_stock>();
StdBELista lst = new StdBELista();
lst = PriEngine.Engine.Consulta("SELECT ArtigoArmazem.Armazem,ArtigoArmazem.StkActual,Armazens.Descricao,Armazens.Morada,Armazens.Localidade,Armazens.Cp,Armazens.CpLocalidade FROM ArtigoArmazem JOIN Armazens ON ArtigoArmazem.Armazem = Armazens.Armazem WHERE Artigo ='" + CodArtigo + "'");
Armazem_stock arm_stc;
while (!lst.NoFim())
{
arm_stc = new Armazem_stock();
arm_stc.Armazem_id = lst.Valor("Armazem");
arm_stc.Stock_qtdd = lst.Valor("StkActual");
arm_stc.Descricao = lst.Valor("Descricao");
arm_stc.Morada = lst.Valor("Morada");
arm_stc.Localidade = lst.Valor("Localidade");
arm_stc.Cp = lst.Valor("Cp");
arm_stc.CpLocalidade = lst.Valor("CpLocalidade");
stock_armazem.Add(arm_stc);
lst.Seguinte();
}
return(stock_armazem);
}
private static List <Pending> GetPendingDocuments(DateTime initialDate, DateTime finalDate, bool receivables)
{
List <Pending> output = new List <Pending>();
if (!InitializeCompany())
{
return(output);
}
StdBELista pendingDocumentsQuery = PriEngine.Engine.Consulta(
"SELECT ValorPendente, Moeda, TipoDoc, Entidade, TipoEntidade, Estado, DataVenc, DataDoc " +
"FROM Pendentes " +
"WHERE TipoEntidade = " + (receivables ? "'C'" : "'F'") +
" AND DataDoc >= '" + initialDate.ToString("yyyyMMdd") + "' AND DataDoc <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY DataDoc"
);
while (!pendingDocumentsQuery.NoFim())
{
Pending pendingDocument = new Pending();
pendingDocument.PendingValue = new Money(pendingDocumentsQuery.Valor("ValorPendente"), pendingDocumentsQuery.Valor("Moeda"));
pendingDocument.DocumentDate = pendingDocumentsQuery.Valor("DataDoc");
pendingDocument.DocumentType = pendingDocumentsQuery.Valor("TipoDoc");
pendingDocument.DueDate = pendingDocumentsQuery.Valor("DataVenc");
pendingDocument.Entity = pendingDocumentsQuery.Valor("Entidade");
pendingDocument.EntityType = pendingDocumentsQuery.Valor("TipoEntidade");
pendingDocument.State = pendingDocumentsQuery.Valor("Estado");
output.Add(pendingDocument);
pendingDocumentsQuery.Seguinte();
}
return(output);
}
/// <summary>
/// Get the list of companies.
/// </summary>
/// <returns>A dictionary containing [string CompanyCode, string CompanyDescription]</returns>
public static Dictionary <string, string> GetGroupCompanies(ERPContext oERPContext)
{
Dictionary <string, string> Result = new Dictionary <string, string>();
StringBuilder sqlQry = new StringBuilder();
sqlQry.AppendLine("select e.Codigo, e.IDNome as Descricao, ce.Descricao as Categoria ");
sqlQry.AppendLine("from {0}..empresas e ");
sqlQry.AppendLine(" inner join {0}..categoriasempresas ce on e.categoria=ce.categoria ");
sqlQry.AppendLine(" inner join {0}..empresas ea on ea.Categoria = ce.Categoria ");
sqlQry.AppendFormat("where ea.codigo = '{0}' and e.TipoExercicio <> 'CONSO'", oERPContext.BSO.Contexto.CodEmp);
string sqlQRYRun = string.Format(sqlQry.ToString(), Properties.Settings.Default.PRIEMPRE_DBNAME);
StdBELista compList = oERPContext.BSO.Consulta(sqlQRYRun.ToString());
if (!compList.Vazia())
{
while (!compList.NoFim())
{
Result.Add(compList.Valor("Codigo"), compList.Valor("Descricao"));
compList.Seguinte();
}
}
return(Result);
}
public ScriptResponse Execute(ContextDataObject context, string query)
{
ErpBS bsERP = new ErpBS();
if (!context.Parameters.ContainsKey("TipoPlataforma"))
{
throw new Exception("TipoPlataforma inválido");
}
EnumTipoPlataforma tipoPlataforma;
if (!Enum.TryParse <EnumTipoPlataforma>((string)context.Parameters["TipoPlataforma"], out tipoPlataforma))
{
throw new Exception("TipoPlataforma inválido");
}
try
{
bsERP.AbreEmpresaTrabalho(tipoPlataforma, context.Company, context.Username, context.Password);
}
catch (Exception e)
{
throw new Exception("Erro a abrir a empresa no ERP: " + e.Message);
}
StdBELista queryResults = bsERP.Consulta(query);
int numLinhas = queryResults.NumLinhas();
int numColunas = queryResults.NumColunas();
string[] headers = new string[numColunas];
for (short i = 0; i < numColunas; i++)
{
headers[i] = queryResults.Nome(i);
}
object[,] data = new object[numLinhas, numColunas];
for (short i = 0; i < numLinhas; i++)
{
for (short j = 0; j < numColunas; j++)
{
var nome = headers[j];
data[i, j] = queryResults.Valor(nome);
}
queryResults.Seguinte();
}
QueryResult response = new QueryResult()
{
Headers = headers,
Data = data
};
bsERP.FechaEmpresaTrabalho();
return(new ScriptResponse
{
Object = response
});
}
public static Lib_Primavera.Model.TipoTarefa GetTipoTarefa(string cod)
{
StdBELista objList = new StdBELista();
Model.TipoTarefa act = new Model.TipoTarefa();
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
objList = PriEngine.Engine.Consulta(
"SELECT TiposTarefa.ID AS ID, TiposTarefa.Descricao AS Descricao FROM TiposTarefa WHERE ID ='" + cod + "'");
if (objList.NumLinhas().Equals(0))
{
return(null);
}
else
{
act = new Model.TipoTarefa();
act.ID = objList.Valor("ID");
act.Descricao = objList.Valor("Descricao");
return(act);
}
}
else
{
return(null);
}
}
public static Lib_Primavera.Model.Rota GetRota(string codrota)
{
StdBELista objList = new StdBELista();
Model.Rota rota = new Model.Rota();
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
objList = PriEngine.Engine.Consulta(
"SELECT * FROM STP_Rotas STP_Rotas.id = '" + codrota + "'");
if (PriEngine.Engine.CRM.Actividades.Existe(codrota) == false)
{
return(null);
}
else
{
rota = new Model.Rota();
rota.ID = objList.Valor("ID");
rota.Rot = objList.Valor("Rota");
rota.Descricao = objList.Valor("Descricao");
rota.ZonaID = objList.Valor("Zona");
return(rota);
}
}
else
{
return(null);
}
}
public static GenderCounter GetGenderCount(DateTime initialDate, DateTime finalDate)
{
if (!InitializeCompany())
{
return(new GenderCounter(-1, -1, DateTime.MinValue, DateTime.MinValue));
}
StdBELista list = PriEngine.Engine.Consulta(
"SELECT Sexo " +
"FROM Funcionarios " +
"WHERE DataAdmissao <= '" + finalDate.ToString("yyyyMMdd") + "' " +
" AND (DataDemissao >= '" + initialDate.ToString("yyyyMMdd") + "' OR DataDemissao IS NULL) "
);
int males = 0;
int females = 0;
while (!list.NoFim())
{
if (list.Valor("Sexo") == "1")
{
females++;
}
else
{
males++;
}
list.Seguinte();
}
return(new GenderCounter(males, females, initialDate, finalDate));
} // Returns <male,female> format
public static List <Absence> GetAbsences(DateTime initialDate, DateTime finalDate) // Returns a List of all absences of all employees
{
// Create an empty list of absences:
List <Absence> absences = new List <Absence>();
if (!InitializeCompany())
{
return(absences);
}
// Get Data from Absence of the employee with ID=employeeId
StdBELista list = PriEngine.Engine.Consulta(
"SELECT CadastroFaltas.Funcionario AS CadastroFaltasFuncionario, CadastroFaltas.Data AS CadastroFaltasData, Funcionarios.Nome AS FuncionariosNome " +
"FROM CadastroFaltas " +
"INNER JOIN Funcionarios ON CadastroFaltas.Funcionario = Funcionarios.Codigo " +
"WHERE CadastroFaltas.Data >= '" + initialDate.ToString("yyyyMMdd") + "' AND CadastroFaltas.Data <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY CadastroFaltas.Data"
);
while (!list.NoFim())
{
Absence absence = new Absence();
absence.EmployeeId = list.Valor("CadastroFaltasFuncionario");
absence.EmployeeName = list.Valor("FuncionariosNome");
absence.Date = list.Valor("CadastroFaltasData");
// Add absence to the list:
absences.Add(absence);
// Next item:
list.Seguinte();
}
return(absences);
}
// Purchases & Sales:
public static List <Purchase> GetPurchases(DateTime initialDate, DateTime finalDate)
{
// Create an empty list of purchases:
List <Purchase> purchases = new List <Purchase>();
if (!InitializeCompany())
{
return(purchases);
}
StdBELista purchasesQuery = PriEngine.Engine.Consulta(
"SELECT CabecCompras.Id AS CabecComprasId, CabecCompras.Nome AS CabecComprasNome, CabecCompras.Entidade AS CabecComprasEntidade, CabecCompras.Moeda AS CabecComprasMoeda, CabecCompras.DataDoc AS CabecComprasDataDoc, CabecCompras.TipoDoc AS CabecComprasTipoDoc, CabecCompras.DataVencimento AS CabecComprasDataVencimento, CabecCompras.DataDescarga AS CabecComprasDataDescarga, " +
"LinhasCompras.Id AS LinhasComprasId, LinhasCompras.PrecoLiquido AS LinhasComprasPrecoLiquido, " +
"Artigo.Artigo AS ArtigoId, Artigo.Marca AS ArtigoMarca, Artigo.Modelo AS ArtigoModelo, Artigo.Descricao AS ArticoDescricao, Artigo.TipoArtigo AS ArtigoTipoArtigo, " +
"Familias.Familia AS FamiliaId, Familias.Descricao AS FamiliaDescricao, " +
"Iva.Taxa AS IvaTaxa " +
"FROM CabecCompras " +
"INNER JOIN LinhasCompras ON LinhasCompras.IdCabecCompras=CabecCompras.Id " +
"INNER JOIN Artigo ON Artigo.Artigo=LinhasCompras.Artigo " +
"INNER JOIN Familias ON Artigo.Familia=Familias.Familia " +
"INNER JOIN Iva ON LinhasCompras.CodIva = Iva.Iva " +
"WHERE CabecCompras.DataDoc >= '" + initialDate.ToString("yyyyMMdd") + "' AND CabecCompras.DataDoc <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY CabecCompras.DataDoc"
);
while (!purchasesQuery.NoFim())
{
Purchase purchase = new Purchase();
// Set values:
purchase.ID = purchasesQuery.Valor("LinhasComprasId");
purchase.DocumentDate = ParseDate(purchasesQuery, "CabecComprasDataDoc");
purchase.DocumentType = purchasesQuery.Valor("CabecComprasTipoDoc");
purchase.DueDate = ParseDate(purchasesQuery, "CabecComprasDataVencimento");
purchase.ReceptionDate = ParseDate(purchasesQuery, "CabecComprasDataDescarga");
purchase.SupplierId = purchasesQuery.Valor("CabecComprasEntidade");
purchase.SupplierName = purchasesQuery.Valor("CabecComprasNome");
purchase.Value = new Money(purchasesQuery.Valor("LinhasComprasPrecoLiquido"), purchasesQuery.Valor("CabecComprasMoeda"));
purchase.Iva = purchasesQuery.Valor("IvaTaxa") / 100.0;
Product product = new Product();
product.Id = purchasesQuery.Valor("ArtigoId");
product.Brand = purchasesQuery.Valor("ArtigoMarca");
product.Model = purchasesQuery.Valor("ArtigoModelo");
product.Description = purchasesQuery.Valor("ArticoDescricao");
product.FamilyId = purchasesQuery.Valor("FamiliaId");
product.FamilyDescription = purchasesQuery.Valor("FamiliaDescricao");
purchase.Product = product;
// Add purchase to the list:
purchases.Add(purchase);
// Next line in the purchase document:
purchasesQuery.Seguinte();
}
return(purchases);
}
private static EntityReference GenerateReference(StdBELista queryObject)
{
return(new EntityReference
{
Tipo = EntityType.Lead.ToDescriptionString(),
Identificador = TypeParser.String(queryObject.Valor("Entidade")),
Descricao = TypeParser.String(queryObject.Valor("Nome"))
});
}
private void grdDocuments_ActualizaDados(object Sender, EventArgs e)
{
lstDocuments = CrossCompany.BusinessProcesses.GetDocumentsToImport(ERPContext);
if (lstDocuments != null && !lstDocuments.Vazia())
{
grdDocuments.DataBind(lstDocuments);
}
}
private void grdMainGrid_ActualizaDados(object Sender, EventArgs e)
{
StdBELista lstGlobalPosition = CrossCompany.PayablesReceivables.GetGlobalPosition(ERPContext, ctlEntity.TipoEntidadeCombo, ctlEntity.ValorRestricao, ctlEntity.EntidadesAssociadas);
if (!lstGlobalPosition.Vazia())
{
grdMainGrid.DataBind(lstGlobalPosition);
}
}
// GET api/<controller>
public ActionResult Index(string id)
{
StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao, STKActual, PCMEDIO, Familia FROM ARTIGO WHERE Artigo LIKE '" + id + "'");
Artigo art = new Artigo {
CodArtigo = id, DescArtigo = objList.Valor("Descricao"), STKAtual = objList.Valor("STKActual"), Familia = objList.Valor("Familia"), Price = objList.Valor("PCMEDIO")
};
return(View(art));
}
//
// GET: /CategoryPage/
public ActionResult Category(string id)
{
StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao from FAMILIAS WHERE Familia LIKE '" + id + "'");
Familias fam = new Familias {
Familia = id, Descricao = objList.Valor("Descricao")
};
return(View(fam));
}
internal static Dictionary <String, int> CheckPendingDocuments(ERPContext oERPContext)
{
Dictionary <String, int> result = new Dictionary <string, int>();
Dictionary <String, String> groupCompanies = CrossCompany.Platform.GetGroupCompanies(oERPContext);
//Exit if no companies where found
if (groupCompanies.Count == 0)
{
return(result);
}
result.Add("Purchases", 0);
result.Add("Sales", 0);
//Load the documents to import from all the group companies
groupCompanies.Remove(oERPContext.BSO.Contexto.CodEmp);
foreach (string groupCompany in groupCompanies.Keys)
{
ErpBS oCompany = new ErpBS();
oCompany.AbreEmpresaTrabalho(
StdBE100.StdBETipos.EnumTipoPlataforma.tpEmpresarial,
groupCompany,
Properties.Settings.Default.User,
Properties.Settings.Default.Password);
String strSQL = String.Format(
"select sum(pur) Purchases, sum(sls) Sales " +
"from(" +
" select count(*) pur, 0 sls from cabecdoc cd inner join CabecDocStatus cds on cds.IdCabecDoc=cd.Id left join documentosvenda dv on cd.tipodoc = dv.documento " +
" where dv.cdu_exportagrupo = 1 AND cd.cdu_exportado = 0 AND cds.Anulado=0 AND cd.entidade = '{0}' " +
" UNION ALL " +
" select 0 pur, count(*) pur from cabeccompras cc inner join CabecComprasStatus ccs on ccs.IdCabecCompras=cc.Id left join documentoscompra dc on cc.tipodoc = dc.documento " +
" where dc.cdu_exportagrupo = 1 AND isnull(cc.cdu_exportado, 0) = 0 AND ccs.Anulado=0 AND cc.entidade = '{0}' " +
" ) as tmp"
, oERPContext.BSO.Contexto.CodEmp);
StdBELista lstPendDocs = oCompany.Consulta(strSQL);
if (!lstPendDocs.Vazia())
{
if (lstPendDocs.DaValor <int>("Purchases") > 0)
{
result["Purchases"] += lstPendDocs.DaValor <int>("Purchases");
}
if (lstPendDocs.DaValor <int>("Sales") > 0)
{
result["Sales"] += lstPendDocs.DaValor <int>("Sales");
}
}
}
return(result);
}
public static void processLine(StdBELista balanceSheetQuery, ClassLine line)
{
line.conta = balanceSheetQuery.Valor("Conta");
line.moeda = balanceSheetQuery.Valor("Moeda");
//line.values.Add(d);
line.values.Add((double)balanceSheetQuery.Valor("Mes00CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes00DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12OR"));
line.tipoLancamento = balanceSheetQuery.Valor("TipoLancamento");
line.naturezaOR = balanceSheetQuery.Valor("NaturezaOR");
}
/// <summary>
/// Returns the global position of a specified company (and, optionally, its related companies) all over the group companies.
/// </summary>
/// <param name="ERPContext"></param>
/// <param name="EntityType"></param>
/// <param name="EntityCode"></param>
/// <param name="IncludeRelatedEntities"></param>
/// <returns>A StdBELista containing the information.</returns>
internal static StdBELista GetGlobalPosition(ERPContext ERPContext, String EntityType, String EntityCode, Boolean IncludeRelatedEntities)
{
StringBuilder sqlQRY = new StringBuilder();
Dictionary <String, String> GroupCompanies = CrossCompany.Platform.GetGroupCompanies(ERPContext);
StdBELista retValue = new StdBELista();
try
{
//Prepare the quary template to be used in each company
sqlQRY.Append("select Grp1= '', Empresa = '{0}', E.TipoEntidade , E.Entidade ");
sqlQRY.Append(" ,Orcamentos = isnull((select sum(totalmerc - totaldesc + totaloutros) from {1}..cabecdoc cd left join {1}..cabecdocstatus cds on cd.id = cds.idcabecdoc where cd.tipodoc = 'ORC' and cds.estado = 'G' and cd.entidade = E.CodEntidade and E.TipoEntidade IN('C', 'D')), 0) ");
sqlQRY.Append(" +isnull((select - sum(totalmerc - totaldesc + totaloutros) from {1}..cabeccompras cc left join {1}..cabeccomprasstatus ccs on cc.id = ccs.idcabeccompras where cc.tipodoc = 'PCO' and ccs.estado = 'G' and cc.entidade = E.CodEntidade and E.TipoEntidade IN('F', 'R')),0) ");
sqlQRY.Append(" ,Encomendas = isnull((select EncomendasPendentes from {1}..Clientes where Cliente = E.CodEntidade and E.TipoEntidade IN('C', 'D')),0) ");
sqlQRY.Append(" +isnull((select - EncomendasPendentes from {1}..fornecedores where fornecedor = E.CodEntidade and E.TipoEntidade IN('F', 'R')),0)");
sqlQRY.Append(" ,TotalVencido = isnull((select sum(valorpendente) from {1}..pendentes where entidade = E.CodEntidade and E.TipoEntidade IN('C', 'D') and datavenc < getdate() and tipoconta = 'CCC' group by entidade),0) ");
sqlQRY.Append(" +isnull((select sum(valorpendente) from {1}..pendentes where entidade = E.CodEntidade and E.TipoEntidade IN('F', 'R') and datavenc < getdate() and tipoconta = 'CCF' group by entidade),0) ");
sqlQRY.Append(" ,TotalDebito = isnull((select totaldeb from {1}..clientes where cliente = E.CodEntidade and E.TipoEntidade IN('C', 'D')),0) ");
sqlQRY.Append(" +isnull((select - totaldeb from {1}..fornecedores where fornecedor = E.CodEntidade and E.TipoEntidade IN('F', 'R')),0)");
sqlQRY.Append("from( ");
sqlQRY.Append(" select '{2}' as TipoEntidade, Cliente as CodEntidade, Nome as Entidade, '0' as Associada from {1}..Clientes where Cliente = '{3}' and '{2}' = 'C' ");
sqlQRY.Append(" UNION ALL ");
sqlQRY.Append(" select '{2}' as TipoEntidade, Fornecedor as CodEntidade, Nome as Entidade, '0' as Associada from {1}..Fornecedores where Fornecedor = '{3}' and '{2}' = 'F' ");
sqlQRY.Append(" UNION ALL ");
sqlQRY.Append(" select '{2}' as TipoEntidade, Terceiro as CodEntidade, Nome as Entidade, '0' as Associada from {1}..OutrosTerceiros where Terceiro = '{3}' and TipoEntidade = '{2}' ");
sqlQRY.Append(" UNION ALL ");
sqlQRY.Append(" select TipoEntidadeAssociada as TipoEntidade, EntidadeAssociada as CodEntidade, coalesce(C.Nome, F.Nome, T.Nome) as Entidade, 1 as Associada ");
sqlQRY.Append(" from {1}..EntidadesAssociadas EA ");
sqlQRY.Append(" left join {1}..Clientes C on C.Cliente = EA.EntidadeAssociada and EA.TipoEntidadeAssociada = 'C' ");
sqlQRY.Append(" left join {1}..Fornecedores F on F.Fornecedor = EA.EntidadeAssociada and EA.TipoEntidadeAssociada = 'F' ");
sqlQRY.Append(" left join {1}..OutrosTerceiros T on T.Terceiro = EA.EntidadeAssociada and T.TipoTerceiro = EA.TipoEntidadeAssociada ");
sqlQRY.Append(" where Entidade = '{3}' and EA.TipoEntidade = '{2}' ");
sqlQRY.Append(" ) as E ");
sqlQRY.Append("Where Associada = 0 or Associada = {4}");
//Prepare de final query (having all companies)
StringBuilder sqlQRYtoRun = new StringBuilder();
String strUnion = string.Empty;
foreach (String Company in GroupCompanies.Keys)
{
sqlQRYtoRun.Append(strUnion);
sqlQRYtoRun.AppendFormat(sqlQRY.ToString(), Company, string.Format("PRI{0}", Company), EntityType, EntityCode, IncludeRelatedEntities ? 1 : 0);
strUnion = "UNION ALL ";
}
//Execute the query to retrieve the information
retValue = ERPContext.BSO.Consulta(sqlQRYtoRun.ToString());
}
catch
{
//DO NOTHING
}
return(retValue);
}
private static Address GetAddress(StdBELista warehouseInfo)
{
return(new Address
{
Pais = TypeParser.String(warehouseInfo.Valor("Pais")),
Morada = TypeParser.String(warehouseInfo.Valor("Morada")),
CodigoPostal = TypeParser.String(warehouseInfo.Valor("Cp")),
Distrito = TypeParser.String(warehouseInfo.Valor("Distrito")),
Localidade = TypeParser.String(warehouseInfo.Valor("Localidade"))
});
}
private void EditRows(int number)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT linhas.*, DescArtigo = art.Descricao, ent.Nome");
sql.AppendLine("FROM TDU_LinhasAnomalias linhas");
sql.AppendLine("INNER JOIN Artigo art ON linhas.CDU_Artigo = art.Artigo");
sql.AppendLine("LEFT JOIN (");
sql.AppendLine(" SELECT TipoEntidade = 'C', Entidade = Cliente, Nome FROM Clientes");
sql.AppendLine(" UNION SELECT TipoEntidade = 'F', Entidade = Fornecedor, Nome FROM Fornecedores");
sql.AppendLine(" UNION SELECT TipoEntidade = 'O', Entidade = Terceiro, Nome FROM OutrosTerceiros");
sql.AppendLine(" ) ent ON linhas.CDU_TipoEntidade = ent.TipoEntidade AND linhas.CDU_Entidade = ent.Entidade");
sql.AppendLine(PSO.Sql.FormatSQL("WHERE linhas.CDU_Numero = @1@", number));
StdBELista list = BSO.Consulta(sql.ToString());
if (list != null)
{
int row = 1;
while (!list.NoFim())
{
// Grupo Artigo
priGrelha1.SetGRID_SetValorCelula(row, colArtigo, list.Valor("CDU_Artigo"));
priGrelha1.SetGRID_SetValorCelula(row, colDescArtigo, list.Valor("DescArtigo"));
priGrelha1.SetGRID_SetValorCelula(row, colLote, list.Valor("CDU_Lote"));
priGrelha1.SetGRID_SetValorCelula(row, colNumSerie, list.Valor("CDU_NumSerie"));
// Grupo Entidade
string tipoEntidade = list.Valor("CDU_TipoEntidade");
SetValorComboboxGrelha(colTipoEntidade, row, GetDescTipoEntidade(tipoEntidade));
priGrelha1.SetGRID_SetValorCelula(row, colEntidade, list.Valor("CDU_Entidade"));
priGrelha1.SetGRID_SetValorCelula(row, colNomeEntidade, list.Valor("Nome"));
// Grupo Anomalia
int tipoAnomalia = list.Valor("CDU_TipoAnomalia");
priGrelha1.SetGRID_SetValorCelula(row, colTipoAnomalia, GetDescTipoAnomalia(tipoAnomalia));
priGrelha1.SetGRID_SetValorCelula(row, colDescricao, list.Valor("CDU_Descricao"));
priGrelha1.SetGRID_SetValorCelula(row, colQuantidade, list.Valor("CDU_Quantidade"));
priGrelha1.SetGRID_SetValorCelula(row, colUnidade, list.Valor("CDU_Unidade"));
// Grupo Localização
priGrelha1.SetGRID_SetValorCelula(row, colArmazem, list.Valor("CDU_Armazem"));
priGrelha1.SetGRID_SetValorCelula(row, colLocalizacao, list.Valor("CDU_Localizacao"));
priGrelha1.SetGRID_SetValorCelula(row, colEstado, list.Valor("CDU_Estado"));
list.Seguinte();
row++;
}
}
}
public void lista_utilizador_aplicacoes(string user)
{
init();
StdBELista uaList = _admBs.Consulta("SELECT * FROM UtilizadoresAplicacoes WHERE Utilizador='" + user + "'");
uaList.Inicio();
while (!uaList.NoFim())
{
Console.WriteLine("Aplicacao: " + uaList.Valor("Apl"));
uaList.Seguinte();
}
return;
}
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"))
});
}
private static LeadListing GenerateListing(StdBELista queryObject)
{
return(new LeadListing()
{
Identificador = TypeParser.String(queryObject.Valor("Entidade")),
Nome = TypeParser.String(queryObject.Valor("Nome")),
Email = TypeParser.String(queryObject.Valor("Email")),
Activo = TypeParser.Boolean(queryObject.Valor("Activo")),
TipoTerceiro = TypeParser.String(queryObject.Valor("TipoTerceiro")),
DataCriacao = TypeParser.Date(queryObject.Valor("DataCriacao")),
DataModificacao = TypeParser.Date(queryObject.Valor("DataUltAct")),
Telefone = TypeParser.String(queryObject.Valor("Telemovel"))
});
}
public static RespostaErro CreateProposta(Oportunidade oportunidade)
{
Lib_Primavera.Model.RespostaErro erro = new Model.RespostaErro();
StdBELista props = PriEngine.Engine.Consulta(@"SELECT Count(*) AS N FROM PropostasOPV
WHERE IdOportunidade = '" + oportunidade.ID + "' ;");
int n = props.Valor("N");
//maximo 4 propostas
if (n >= 4)
{
erro.Erro = 1;
erro.Descricao = "The maximum of proposals is four.";
return(erro);
}
CrmBEPropostaOPV prop = new CrmBEPropostaOPV();
try
{
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
prop.set_IdOportunidade(oportunidade.ID);
prop.set_IdCabecOrigem(oportunidade.ID);
short x = (short)n;
x++;
prop.set_NumProposta(x);
prop.set_Valor(0);
//var opp = PriEngine.Engine.CRM.OportunidadesVenda.EditaID(oportunidade.ID);
PriEngine.Engine.CRM.PropostasOPV.Actualiza(prop);
erro.Erro = 0;
erro.Descricao = "Sucesso";
return(erro);
}
else
{
erro.Erro = 1;
erro.Descricao = "Erro ao abrir empresa";
return(erro);
}
}
catch (Exception ex)
{
erro.Erro = 1;
erro.Descricao = ex.Message;
return(erro);
}
}
private static Factura parseFacturaObj(StdBELista obj)
{
Factura factura = new Factura();
factura.entidade = obj.Valor("Entidade");
factura.tipoDocumento = obj.Valor("Tipodoc");
factura.numDocumento = obj.Valor("NumDoc");
//Console.WriteLine("objecto: " + obj.Valor("DataDoc"));
if (obj.Valor("DataDoc") != null)
factura.dataDocumento = obj.Valor("DataDoc");
if (obj.Valor("DataVenc") != null)
factura.dataVencimento = obj.Valor("DataVenc");
// if (obj.Valor("DataLiq") != null)
// factura.dataLiquidacao = obj.Valor("DataLiq");
factura.valorTotal = obj.Valor("ValorTotal");
// if (obj.Valor("ValorDesconto") != null)
// factura.valorDesconto = obj.Valor("ValorDesconto");
factura.modoPagamento = obj.Valor("ModoPag");
factura.condPagamento = obj.Valor("CondPag");
factura.moeda = obj.Valor("Moeda");
factura.totalIva = obj.Valor("TotalIva");
return factura;
}
private static DateTime ParseDate(StdBELista list, String key)
{
var value = list.Valor(key);
Type type = value.GetType();
if (type != typeof (DateTime))
{
if(type != typeof(String))
return DateTime.MinValue;
DateTime output;
if(!DateTime.TryParse(value, out output))
return DateTime.MinValue;
return output;
}
return value;
}
public static void processLine(StdBELista balanceSheetQuery, ClassLine line)
{
line.conta = balanceSheetQuery.Valor("Conta");
line.moeda = balanceSheetQuery.Valor("Moeda");
//line.values.Add(d);
line.values.Add((double)balanceSheetQuery.Valor("Mes00CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes00DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12OR"));
line.tipoLancamento = balanceSheetQuery.Valor("TipoLancamento");
line.naturezaOR = balanceSheetQuery.Valor("NaturezaOR");
}
