Example #1
0
        public EditScheduleForm(Schedule schedule)
        {
            InitializeComponent();
            try
            {
                DS_Schedule.DataSource = this.schedule;
                this.schedule          = schedule;
                buildingQuery          = new BuildingQuery(_SERVER.ServerName.Database);
                sequenceQuery          = new SequenceQuery(_SERVER.ServerName.Database);
                ScheduleQuery          = new ScheduleQuery(_SERVER.ServerName.Database);

                ScheduleLine = PoLine = buildingQuery.GetProductionLines();

                DS_Schedule.DataSource       = this.schedule;
                DS_Line.DataSource           = ScheduleLine;
                DS_OriginalPoLine.DataSource = PoLine;

                var temp1 = buildingQuery.GetProductionLine(schedule.ProductionLine_Id);
                if (temp1 != null)
                {
                    comboBox1.SelectedItem = ScheduleLine.Where(i => i.id == temp1.id).First();
                }
                var pos = sequenceQuery.GetOriginalPos(schedule);

                if (pos != null)
                {
                    DS_OriginalPo.DataSource = pos;
                }
            }
            catch { }
        }
Example #2
0
        private void EKanbanHistories_Load(object sender, EventArgs e)
        {
            try
            {
                var buildings = BuildingQuery.GetBuildings();
                int i = 0, k = 0;

                foreach (var b in buildings)
                {
                    treeView1.Nodes.Add(b.Name, $"Building: {b.Name}");

                    var lines = BuildingQuery.GetProductionLines(b.id);

                    foreach (var l in lines)
                    {
                        treeView1.Nodes[b.Name].Nodes.Add(l.LineName, $"Line: {l.LineName}");

                        var ekanbans = EKanbanTaskQuery.GetEKanbanDevicesByProductionLine(l.id);

                        foreach (var ekb in ekanbans)
                        {
                            treeView1.Nodes[b.Name].Nodes[l.LineName].Nodes.Add(ekb.Name, ekb.Name);
                        }
                        k++;
                    }
                    i++;
                }
            }
            catch { }
        }
Example #3
0
        string[] GetScheduleModelName(Building buildind, ScheduleClass cls)
        {
            var             productionLines = BuildingQuery.GetProductionLines(buildind.id);
            List <Schedule> schedules       = new List <Schedule>();

            foreach (var line in productionLines)
            {
                using (ScheduleContext db = new ScheduleContext(_SERVER.ServerName.Database))
                {
                    var schs = db.Schedules.Where(i => i.ScheduleClass_Id == cls.id && i.ProductionLine_Id == line.id);
                    if (schs.Count() > 0)
                    {
                        schedules.AddRange(schs.ToList());
                    }
                }
            }

            IEnumerable <IGrouping <string, Schedule> > group = schedules.GroupBy(i => i.ModelName).ToList();

            List <string> modelName = new List <string>();

            foreach (var item in group)
            {
                modelName.Add(item.Key);
            }
            return(modelName.ToArray());
        }