Пример #1
0
        public static List <Model.Rota> ListaRotas()
        {
            StdBELista objList;

            Model.Rota        rota      = new Model.Rota();
            List <Model.Rota> listRotas = new List <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");

                while (!objList.NoFim())
                {
                    rota           = new Model.Rota();
                    rota.ID        = objList.Valor("ID");
                    rota.Rot       = objList.Valor("Rota");
                    rota.Descricao = objList.Valor("Descricao");
                    rota.ZonaID    = objList.Valor("Zona");



                    listRotas.Add(rota);
                    objList.Seguinte();
                }

                return(listRotas);
            }
            else
            {
                return(null);
            }
        }
Пример #2
0
        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);
            }
        }