Пример #1
0
        /// <summary>
        /// 获取任务记录
        /// </summary>
        public List <TaskRecord> SelectTaskRecordBySql(string sql)
        {
            List <TaskRecord> taskRecordList = new List <TaskRecord>();

            try {
                lock (lockDB) {
                    dataReader = execQuery(sql);
                    while (dataReader.Read())
                    {
                        TaskRecord taskRecord = new TaskRecord();
                        taskRecord.taskRecordID = int.Parse(dataReader["taskRecordID"] + "");

                        taskRecord.taskRecordStat = (TASKSTAT_T)int.Parse(dataReader["taskRecordStat"] + "");
                        taskRecord.taskLevel      = int.Parse(dataReader["taskLevel"] + "");
                        try {
                            if (!String.IsNullOrEmpty(dataReader["forklift"].ToString()))
                            {
                                taskRecord.forkLiftWrapper = AGVCacheData.getForkLiftByID(int.Parse(dataReader["forklift"] + ""));
                            }
                        } catch (FormatException fx) {
                            Console.WriteLine("message = " + fx.Message);
                        }
                        taskRecord.singleTask     = SingleTaskDao.getDao().getSingleTaskByID(int.Parse(dataReader["singleTask"] + ""));
                        taskRecord.taskRecordName = taskRecord.singleTask.taskName;
                        taskRecord.updateTime     = (DateTime)(dataReader["taskRecordUpdateTime"]);

                        taskRecordList.Add(taskRecord);
                    }
                }
            } catch (Exception ex) {
                Console.WriteLine(ex.ToString());
            }
            return(taskRecordList);
        }
Пример #2
0
        public SingleTask getSingleTaskByTaskName(string taskName)
        {
            SingleTask singleTask = null;

            foreach (SingleTask st in AGVCacheData.getSingleTaskList())
            {
                if (st.taskName.StartsWith(taskName))
                {
                    singleTask = st;
                }
            }
            return(singleTask);
        }
Пример #3
0
        public SingleTask getSingleTaskByID(int singleTaskID)
        {
            SingleTask singleTask = null;

            foreach (SingleTask st in AGVCacheData.getSingleTaskList())
            {
                if (st.taskID == singleTaskID)
                {
                    singleTask = st;
                }
            }
            return(singleTask);
        }