예제 #1
0
파일: Db.cs 프로젝트: gefakra/Ascon-Lodsman
        /// <summary> Получить список всех задач </summary>
        /// <param name="Object"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public List <Storage> GetTaskList(IPluginCall Object)
        {
            List <Storage> DataList = new List <Storage>();

            DataProvider.DataSet dateSet = new DataProvider.DataSet();

            dateSet.DATA = Object.RunMethod("GetInfoAboutVersion", new object[] { "", "", "", Object.IdVersion, 3 });

            for (dateSet.First(); !dateSet.Eof; dateSet.Next())
            {
                if (dateSet.get_FieldValue("_NAME") == "Список идентификаторов")
                {
                    string Temp = (dateSet.get_FieldValue("_VALUE")).Trim(';');
                    _Atr = Temp.Split(new char[] { ';' }).Select(i => Convert.ToInt32(i)).ToArray();
                }
            }
            dateSet.DATA = Object.RunMethod("SuGetTasks", new object[] { _Atr, 2, DBNull.Value });

            for (dateSet.First(); !dateSet.Eof; dateSet.Next())
            {
                var     a       = dateSet.get_FieldValue("_DURATION");
                Storage storage = new Storage()
                {
                    id               = dateSet.get_FieldValue("_ID_TASK"),
                    Name             = dateSet.get_FieldValue("_TOPIC"),
                    parent           = dateSet.get_FieldValue("_ID_PARENT"),
                    Initiator_N      = dateSet.get_FieldValue("_AUTHOR_NAME"),
                    Initiator_F      = dateSet.get_FieldValue("_AUTHOR_FULLNAME"),
                    Executor_N       = dateSet?.get_FieldValue("_WORKER_NAME"),
                    ExExecutor_F     = dateSet.get_FieldValue("_WORKER_FULLNAME"),
                    StartTask        = dateSet.get_FieldValue("_PLAN_START"),
                    EndTask          = dateSet.get_FieldValue("_PLAN_FINISH"),
                    Duration_P       = dateSet.get_FieldValue("_PLAN_DURATION"),
                    Deadline         = dateSet.get_FieldValue("_DEADLINE").ToString(),
                    NotificationNumb = GetInfo(Object),
                };
                var art = dateSet.get_FieldValue("_DEADLINE");
                if (!(dateSet.get_FieldValue("_START") is System.DBNull))
                {
                    storage.StartTaskFact = Convert.ToString(dateSet.get_FieldValue("_START"));
                }
                else
                {
                    storage.StartTaskFact = "".ToString();
                }
                if (!(dateSet.get_FieldValue("_FINISH") is System.DBNull))
                {
                    storage.EndTaskFact = Convert.ToString(dateSet.get_FieldValue("_FINISH"));
                }
                else
                {
                    storage.EndTaskFact = "".ToString();
                }
                int st = dateSet.get_FieldValue("_STATE");
                storage._state = (State)st;
                DataList.Add(storage);
                // var ter = GetInfo(Object);
            }
            return(DataList);
        }