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); } }
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 <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); }
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); } }
/// <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 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 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)); }
// 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)); }
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 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")) }); }
public void lista_utilizador_permissoes(string user) { init(); StdBELista upList = _admBs.Consulta("SELECT * FROM Permissoes WHERE Utilizador='" + user + "'"); upList.Inicio(); while (!upList.NoFim()) { Console.WriteLine("Permissao: "); Console.WriteLine(" Perfil: " + upList.Valor("Perfil")); Console.WriteLine(" Empresa: " + upList.Valor("Empresa")); upList.Seguinte(); } return; }
private static ProductListing GenerateListing(StdBELista productInfo) { var productId = TypeParser.String(productInfo.Valor("Artigo")); var productUnit = TypeParser.String(productInfo.Valor("UnidadeVenda")); return(new ProductListing() { Unidade = productUnit, Identificador = productId, PrecoMedio = FindLowest(productId, productUnit), Stock = TypeParser.Double(productInfo.Valor("Stock")), IVA = TypeParser.Double(productInfo.Valor("Iva")), Descricao = TypeParser.String(productInfo.Valor("Descricao")) }); }
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 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 void lista_perfis() { init(); StdBELista pList = _admBs.Consulta("SELECT * FROM perfis"); pList.Inicio(); while (!pList.NoFim()) { Console.WriteLine("Perfil: " + pList.Valor("Codigo")); Console.WriteLine(" Codigo: " + pList.Valor("Codigo")); Console.WriteLine(" Nome: " + pList.Valor("Nome")); pList.Seguinte(); } return; }
public void info() { init(); ErpBS motor = new ErpBS(); bool _false = false; Console.WriteLine("License: " + !motor.Licenca.VersaoDemo); Console.WriteLine("Language: " + _admBs.Params.get_Idioma()); Console.WriteLine("Seguranca Activa: " + _admBs.Params.get_SegurancaActiva()); Console.WriteLine("Seguranca Pro Emp Activa: " + _admBs.Params.get_SegurancaPorEmpActiva()); Console.WriteLine("Modo Seguranca: " + _admBs.Params.get_SegurancaActiva()); //Console.WriteLine("N Postos: " + adm.Utilizadores.listPostos.ListaPostos(ref _false).NumItens); string backupsdir = Backupsdir; if (backupsdir == null) { backupsdir = _admBs.SQLServer.DirectoriaBackup(); } Console.WriteLine("DirectoriaBackup: " + backupsdir); StdBELista uList = _admBs.Consulta("SELECT * FROM utilizadores"); Console.WriteLine("N Utilizadores: " + uList.NumLinhas()); uList.Inicio(); while (!uList.NoFim()) { Console.WriteLine(" Utilizador: " + uList.Valor("Codigo") + ", " + uList.Valor("Nome")); uList.Seguinte(); } StdBELista eList = _admBs.Consulta("SELECT * FROM empresas"); Console.WriteLine("N Empresas: " + eList.NumLinhas()); eList.Inicio(); while (!eList.NoFim()) { Console.WriteLine(" Empresa: " + eList.Valor("Codigo") + ", " + eList.Valor("IDNome")); eList.Seguinte(); } return; }
public static List <Artigo> getRelacionados(string id, int tipo, double pvp1) { List <Artigo> relacionados = new List <Artigo>(); double precoMax = pvp1 * 1.25; string precoString = precoMax.ToString(); precoString = precoString.Replace(",", "."); StdBELista lst = new StdBELista(); lst = PriEngine.Engine.Consulta("IF(SELECT COUNT(DISTINCT Artigo) Total FROM LinhasDoc WHERE Data >= DATEADD(month,-3,GETDATE()) AND Artigo IN (SELECT Artigo FROM Artigo WHERE CDU_Tipo=" + tipo + ") AND LinhasDoc.PrecUnit <= " + precoString + ") >$4" + "BEGIN " + " SELECT Art.Artigo, Descricao, PVP1, IVA, Total " + " FROM " + " (SELECT Artigo.Artigo, Descricao, PVP1, IVA " + " FROM Artigo " + " JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo" + " WHERE CDU_Tipo="+ tipo + " AND PVP1 <= " + precoString + " AND Artigo.Artigo!='" + id + "' ) AS Art " + " JOIN (SELECT TOP 5 Artigo, COUNT(*) Total " + " FROM LinhasDoc " + " WHERE Data >= DATEADD(month,-3,GETDATE())" + " GROUP BY Artigo " + " HAVING COUNT(*) > 1" + " ORDER BY COUNT(*) DESC) AS Linhas ON Art.Artigo = Linhas.Artigo " + "END " + "ELSE " + "SELECT Artigo.Artigo, Descricao, PVP1, IVA " + "FROM Artigo JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo " + "WHERE CDU_Tipo=" + tipo + " AND Artigo.Artigo!='" + id + "' " + "ORDER BY NEWID() " + "SET ROWCOUNT 5"); Artigo art; while (!lst.NoFim()) { art = new Artigo(); art.CodArtigo = lst.Valor("artigo"); art.DescArtigo = lst.Valor("descricao"); art.Preco = Math.Round(lst.Valor("PVP1") * (1 + Convert.ToDouble(lst.Valor("IVA")) / 100.0), 2); relacionados.Add(art); lst.Seguinte(); } return(relacionados); }
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); }
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); }
// // 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)); }
public static List <Artigo> toArtigoList(StdBELista objList) { List <Model.Artigo> listArtigos = new List <Model.Artigo>(); while (!objList.NoFim()) { listArtigos.Add(new Model.Artigo { CodArtigo = objList.Valor("Artigo"), DescArtigo = objList.Valor("Descricao"), Stock = Convert.ToDouble(objList.Valor("STKActual")), Marca = objList.Valor("Marca"), Preco = Math.Round((Convert.ToDouble(objList.Valor("PVP1")) * (1 + Convert.ToDouble(objList.Valor("IVA")) / 100.0)), 2) }); objList.Seguinte(); } return(listArtigos); }
public static Lib_Primavera.Model.RespostaErro login(Model.Cliente cli) { Lib_Primavera.Model.RespostaErro erro = new Model.RespostaErro(); try { if (PriEngine.InitializeCompany(ElectroSinf.Properties.Settings.Default.Company.Trim(), ElectroSinf.Properties.Settings.Default.User.Trim(), ElectroSinf.Properties.Settings.Default.Password.Trim()) == true) { StdBELista cliente = PriEngine.Engine.Consulta("SELECT Cliente,CDU_Password from Clientes where CDU_Email='" + cli.Email + "';"); if (cliente.Vazia()) { erro.Erro = -1; erro.Descricao = "Email Errado"; } else { string inserida = PriEngine.Platform.Criptografia.Encripta(cli.Password, 50); if (inserida == cliente.Valor("CDU_Password")) { erro.Erro = 0; erro.Descricao = cliente.Valor("Cliente"); } else { erro.Erro = -1; erro.Descricao = "Password Errada"; } } 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 bool EditCabec(int number) { bool result = false; string sql = PSO.Sql.FormatSQL("SELECT * FROM TDU_CabecAnomalias WHERE CDU_Numero = @1@", number); StdBELista list = BSO.Consulta(sql); if (list != null) { if (list.NumLinhas() == 1) { result = true; numericUpDownNumber.Value = list.Valor("CDU_Numero"); dateTimePickerDate.Value = list.Valor("CDU_Data"); } } return(result); }
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 List <OvertimeHours> GetOvertimeHours(DateTime initialDate, DateTime finalDate) { // Create an empty list of absences: List <OvertimeHours> overtimeHours = new List <OvertimeHours>(); if (!InitializeCompany()) { return(overtimeHours); } // Get Data from Absence of the employee with ID=employeeId BD StdBELista list = PriEngine.Engine.Consulta( "SELECT CadastroHExtras.Funcionario, CadastroHExtras.Data, CadastroHExtras.Tempo, Funcionarios.Nome AS FuncionariosNome " + "FROM CadastroHExtras " + "INNER JOIN Funcionarios " + "ON CadastroHExtras.Funcionario = Funcionarios.Codigo " + "WHERE CadastroHExtras.Data >= '" + initialDate.ToString("yyyyMMdd") + "' AND CadastroHExtras.Data <= '" + finalDate.ToString("yyyyMMdd") + "' " + "ORDER BY CadastroHExtras.Data " ); // Get Data from Absence of the employee with ID=employeeId Not BD //StdBELista list = PriEngine.Engine.RecursosHumanos.CadastroHorasExtra.LstCadastroHorasExtra(); // TODO edit while (!list.NoFim()) { OvertimeHours overtimeHoursObj = new OvertimeHours(); overtimeHoursObj.EmployeeId = list.Valor("Funcionario"); overtimeHoursObj.EmployeeName = list.Valor("FuncionariosNome"); overtimeHoursObj.Date = list.Valor("Data"); overtimeHoursObj.Time = list.Valor("Tempo").ToString(); // Add absence to the list: overtimeHours.Add(overtimeHoursObj); // Next item: list.Seguinte(); } return(overtimeHours); }
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; }
// Human Resources related: public static List <Employee> GetEmployees(DateTime initialDate, DateTime finalDate) { // Create an empty list of employees: List <Employee> employees = new List <Employee>(); if (!InitializeCompany()) { return(employees); } StdBELista list = PriEngine.Engine.Consulta( "SELECT IdGDOC, Nome, Sexo, Vencimento, TipoMoeda, DataAdmissao, DataDemissao " + "FROM Funcionarios " + "WHERE DataAdmissao <= '" + finalDate.ToString("yyyyMMdd") + "' " + " AND (DataDemissao >= '" + initialDate.ToString("yyyyMMdd") + "' OR DataDemissao IS NULL) " + "ORDER BY DataAdmissao" ); while (!list.NoFim()) { Employee employee = new Employee(); // Set values employee.ID = list.Valor("IdGDOC"); employee.Name = list.Valor("Nome"); employee.Gender = list.Valor("Sexo") == "0" ? Employee.GenderType.Female : Employee.GenderType.Male; employee.Salary = new Money(list.Valor("Vencimento"), "Unspecified"); // No currency value employee.HiredOn = ParseDate(list, "DataAdmissao"); employee.FiredOn = ParseDate(list, "DataDemissao"); // Add employee to the list: employees.Add(employee); // Next item: list.Seguinte(); } return(employees); }
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); } }
} // Returns <male,female> format public static List <EmployeeMovement> GetEmployeesMovements(DateTime initialDate, DateTime finalDate) { // Create an empty list of employee movements: List <EmployeeMovement> employeeMovements = new List <EmployeeMovement>(); if (!InitializeCompany()) { return(employeeMovements); } // Get Data of movements: StdBELista list = PriEngine.Engine.Consulta( "SELECT TotalDeRemuneracoes, TotalEncargosEntPat, Funcionario, DataMov, NumProc " + "FROM MovimentosFuncionarios " + "WHERE MovimentosFuncionarios.DataMov >= '" + initialDate.ToString("yyyyMMdd") + "' AND MovimentosFuncionarios.DataMov <= '" + finalDate.ToString("yyyyMMdd") + "' " + "ORDER BY MovimentosFuncionarios.DataMov " ); while (!list.NoFim()) { EmployeeMovement employeeMovement = new EmployeeMovement(); employeeMovement.EmployeeId = list.Valor("Funcionario"); employeeMovement.MovementDate = list.Valor("DataMov"); employeeMovement.ProcessNo = list.Valor("NumProc"); employeeMovement.EmployeePayment = list.Valor("TotalDeRemuneracoes"); employeeMovement.EstateCharges = list.Valor("TotalEncargosEntPat"); // Add absence to the list: employeeMovements.Add(employeeMovement); // Next item: list.Seguinte(); } return(employeeMovements); }
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 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"); }