コード例 #1
0
ファイル: PeriodFactory.cs プロジェクト: hoti1012/IBSYS-II
        public static int getCurrent()
        {
            DatabaseManager manager;
            string where = null;
            Period pObj = null;
            List<Object> objects = null;
            int max = 1;
            int tmp = 0;

            manager = new DatabaseManager();
            try
            {
                where = "";
                objects = manager.select(typeof(Period),where);
                foreach (Object o in objects)
                {
                    pObj = o as Period;
                    tmp = Convert.ToInt32(pObj.period);
                    if (tmp > max)
                    {
                        max = tmp;
                    }

                }
            }
            finally
            {
                manager.release();
            }
            return max + 1;
        }
コード例 #2
0
        /// <summary>
        /// Sucht nach einem Object in der Datenbank
        /// </summary>
        /// <param name="type">Typ des gesuchten objects</param>
        /// <param name="head">nummer des Kopfobjects</param>
        /// <returns>Das gesuchte Object</returns>
        public static PlanningObject search(Type type, string head)
        {
            DatabaseManager manager;
            string where;
            PlanningObject obj = null;
            List<Object> res;

            manager = new DatabaseManager();
            try
            {
                where = "WHERE " + type.Name + " = \"" + head + "\"";

                res = manager.select(type, where);

                if (res != null && res.Count > 0)
                {
                    obj = res[0] as PlanningObject;
                }
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #3
0
        /// <summary>
        /// Erzeugt ein Object
        /// </summary>
        /// <param name="type">Type des Objects</param>
        /// <param name="head">Nummer des Objects</param>
        /// <returns>Das erzeugte Object</returns>
        public static PlanningObject create(Type type, string head)
        {
            DatabaseManager manager;
            PlanningObject obj = null;
            PropertyInfo[] props;

            manager = new DatabaseManager();
            try
            {
                //Prüfen ob es die Objectposition bereits gibt
                obj = search(type, head);
                if (obj != null)
                {
                    return null;
                }

                obj = Activator.CreateInstance(type) as PlanningObject;
                props = obj.GetType().GetProperties();
                foreach (PropertyInfo p in props)
                {
                    if (p.Name.Equals(type.Name, StringComparison.CurrentCultureIgnoreCase))
                    {
                        p.SetValue(obj, head);
                        break;
                    }
                }
                manager.insert(obj);
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #4
0
ファイル: StockFactory.cs プロジェクト: hoti1012/IBSYS-II
        /// <summary>
        /// Liefert alle Lagerplätze
        /// </summary>
        /// <returns></returns>
        public static List<Stock> getAll()
        {
            List<Stock> stock = null;
            List<Object> objects = null;
            DatabaseManager manager;

            manager = new DatabaseManager();
            try
            {
                objects = manager.select(typeof(Stock), "");
                stock = new List<Stock>();
                foreach (Object o in objects)
                {
                    stock.Add(o as Stock);
                }
            }
            finally
            {
                manager.release();
            }
            return stock;
        }
コード例 #5
0
        internal static PlanningObject getHead(PlanningPosObject obj,Type headType)
        {
            PlanningObject head = null;
            DatabaseManager manager;
            string where;
            List<Object> res;
            Type type = obj.GetType();
            PropertyInfo[] props = type.GetProperties();
            string table = type.Name.Remove(type.Name.Length - 3);
            string value = null;

            manager = new DatabaseManager();
            try
            {
                foreach (PropertyInfo p in props)
                {
                    if (p.Name.Equals(table, StringComparison.CurrentCultureIgnoreCase))
                    {
                        value = p.GetValue(obj).ToString();
                    }
                }
                where = "WHERE " + table + " = \"" + value + "\"";
                res = manager.select(headType, where);
                if (res != null && res.Count > 0)
                    head = res[0] as PlanningObject;
            }
            finally
            {
                manager.release();
            }
            return head;
        }
コード例 #6
0
 /// <summary>
 /// Speichert die änderungen an einer Objectposition in der Datenbank
 /// </summary>
 /// <param name="obj">Objectposition</param>
 public static void update(PlanningPosObject obj)
 {
     DatabaseManager manager;
     manager = new DatabaseManager();
     try
     {
         manager.update(obj);
     }
     finally
     {
         manager.release();
     }
 }
コード例 #7
0
        /// <summary>
        /// Sucht nach einem Object in der Datenbank
        /// </summary>
        /// <param name="type">Typ des gesuchten objects</param>
        /// <param name="sql">nummer des Kopfobjects</param>
        /// <returns>Das gesuchte Object</returns>
        public static List<PlanningPosObject> select(Type type, string sql)
        {
            DatabaseManager manager;
            List<Object> res;
            List<PlanningPosObject> obj = new List<PlanningPosObject>();

            manager = new DatabaseManager();
            try
            {

                res = manager.freeSelect(type, sql);

                foreach (Object o in res)
                {
                    obj.Add(o as PlanningPosObject);
                }
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #8
0
        /// <summary>
        /// Sucht alle Objectposition welche eine die gesuchte Pos beinhalten
        /// </summary>
        /// <param name="type">Typ des gesuchten objects</param>
        /// <param name="head">nummer des Kopfobjects</param>
        /// <returns></returns>
        public static List<PlanningPosObject> searchAllWithPos(Type type, string pos)
        {
            DatabaseManager manager;
            string where;
            List<Object> res;
            List<PlanningPosObject> obj = new List<PlanningPosObject>();

            manager = new DatabaseManager();
            try
            {
                where = "WHERE " + type.Name + " = \"" + pos + "\"";

                res = manager.select(type, where);

                foreach (Object o in res)
                {
                    obj.Add(o as PlanningPosObject);
                }
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #9
0
        /// <summary>
        /// Sucht nach Positionen mit abhäigkeiten
        /// </summary>
        /// <param name="type"></param>
        /// <param name="head"></param>
        /// <param name="pos"></param>
        /// <returns>Die gesuchte Position</returns>
        public static PlanningPosObject search(Type type, string head, string pos, string dependence)
        {
            DatabaseManager manager;
            string where;
            PlanningPosObject obj = null;
            List<Object> res;

            manager = new DatabaseManager();
            try
            {
                where = "WHERE " + type.Name.Remove(type.Name.Length - 3) + " = \"" + head + "\""
                      + " AND " + type.Name + " = \"" + pos + "\""
                      + " AND dependence = \"" + dependence + "\"";

                res = manager.select(type, where);

                if (res != null && res.Count > 0)
                {
                    obj = res[0] as PlanningPosObject;
                }
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #10
0
        /// <summary>
        /// Sucht nach einem Object in der Datenbank
        /// </summary>
        /// <param name="type">Typ des gesuchten objects</param>
        /// <returns>Alle Objecte</returns>
        public static List<PlanningObject> searchAll(Type type)
        {
            DatabaseManager manager;
            string where;
            List<PlanningObject> obj = new List<PlanningObject>();
            List<Object> res;

            manager = new DatabaseManager();
            try
            {
                res = manager.select(type,null);

                foreach(Object o in res)
                {
                    obj.Add(o as PlanningObject);
                }
            }
            finally
            {
                manager.release();
            }
            return obj;
        }
コード例 #11
0
 /// <summary>
 /// Führt ein Datenbankupdate für das übergebene Object aus
 /// </summary>
 /// <param name="planningObject"></param>
 internal static void update(PlanningObject planningObject)
 {
     DatabaseManager manager;
     manager = new DatabaseManager();
     try
     {
         manager.update(planningObject);
     }
     finally
     {
         manager.release();
     }
 }