Beispiel #1
0
        public void Check()
        {
            using (Trubodetal189Entities local = new Trubodetal189Entities())
            {
                int LastID = local.ProductionTasks.Max(p => p.ID);



                using (ASUTPEntities asutp = new ASUTPEntities())
                {
                    IQueryable <Tasker.Task> query = from b in asutp.Tasks
                                                     where b.ID > LastID && (b.Status == "0" || b.Status == "1")
                                                     select b;

                    foreach (Task task in query)
                    {
                        task.Status = "1";
                        ProductionTaskExtended productionTask = new ProductionTaskExtended(task);
                        Log.logThis($"Считали идентификатор: {task.ID}");
                        local.ProductionTasks.Add(productionTask.Task);
                    }
                    asutp.SaveChanges();

                    IQueryable <ProductionTask> currentTasks = from b in local.ProductionTasks
                                                               where b.Status == "1"
                                                               select b;
                    foreach (ProductionTask productionTask in currentTasks)
                    {
                        try
                        {
                            Task task = asutp.Tasks.Single(t => t.ID == productionTask.ID);
                            if (task.Status != "1")
                            {
                                productionTask.Status = task.Status;
                            }
                        }
                        catch { }
                    }
                    local.SaveChanges();
                }
            }
        }
Beispiel #2
0
        public void UpdateTaskResult()
        {
            using (ASUTPEntities asutp = new ASUTPEntities())
            {
                using (Trubodetal189Entities local = new Trubodetal189Entities())
                {
                    IQueryable <Tasker.ProductionTask> query = from b in local.ProductionTasks
                                                               where b.Status == "f"
                                                               select b;
                    foreach (ProductionTask task in query)
                    {
                        try
                        {
                            Task targetTask = asutp.Tasks.Single(e => e.ID == task.ID);
                            targetTask.PiceAmount = task.PiceAmount;
                            targetTask.Status     = "s";
                            task.Status           = "s";
                            targetTask.StartDate  = task.StartDate;
                            targetTask.FinishDate = task.FinishDate;
                            targetTask.Operator   = task.Operator;
                        }
                        catch (InvalidOperationException)
                        {
                            task.Status = "s";
                            try
                            {
                                asutp.Tasks.Add(new NewAsutpTask(task).Task);
                            }   catch (Exception e)
                            {
                                Log.logThis(e.Message);
                            }
                        }
                    }

                    local.SaveChanges();
                }
                asutp.SaveChanges();
            }
        }