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
        public PoInfo(IDbName _database, Schedule _schedule)
        {
            BuildingQuery buildingQuery = new BuildingQuery(_database);

            id        = _schedule.id;
            PoNumber  = _schedule.PoNumber;
            Model     = _schedule.Model;
            Article   = _schedule.Article;
            ModelName = _schedule.ModelName;
            Quantity  = _schedule.Quantity != null ? (int)_schedule.Quantity : 0;
            Line      = buildingQuery.GetProductionLine(ShareFuncs.GetInt(_schedule.ProductionLine_Id)).LineName;
        }
Example #3
0
        private void GetSelectedSchedule()
        {
            if (lbSchedule.SelectedItem == null)
            {
                return;
            }

            SelectedSchedule       = lbSchedule.SelectedItem as Schedule;
            SelectedProductionLine = BuildingQuery.GetProductionLine(ShareFuncs.GetInt(SelectedSchedule.ProductionLine_Id));
            txtProductionLine.Text = SelectedProductionLine.LineName;

            UpdateOgiginalSequence();
        }
Example #4
0
        public SequenceCtrl(Schedule _schedule, bool _displayHeader)
        {
            InitializeComponent();
            header   = _displayHeader;
            Schedule = new Schedule();

            if (Schedule != null)
            {
                Schedule = ScheduleQuery.GetSchedule(_schedule.id);
                ds_schedule.DataSource = Schedule;
                var ProductionLine = BuildingQuery.GetProductionLine(ShareFuncs.GetInt(Schedule.ProductionLine_Id));
                txProductionLine.Text = ProductionLine.LineName;
                txtUpdateTime.Text    = Schedule.ScheduleClass.LastModified.ToString("hh::mm: tt, dd/MM/yyyy");
            }

            OriginalPo = new OriginalPO();
            Draw();
        }
Example #5
0
        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (listBox1.SelectedItem == null)
                {
                    return;
                }
                var currentPo = listBox1.SelectedItem as OriginalPO;

                var temp1 = buildingQuery.GetProductionLine(currentPo.ProductionLine_Id);
                if (temp1 != null)
                {
                    comboBox2.SelectedItem = PoLine.Where(i => i.id == temp1.id).First();
                }
            }
            catch { }
        }
Example #6
0
        public BeamInterface(BeamCutInterface BInterface, int place)
        {
            InitializeComponent();
            try
            {
                lbStartTime.Text = BInterface.StartCutTime.ToString();
                lbStopTime.Text  = BInterface.StopCutTime.ToString();
                BeamCutQuery  beamCutQuery  = new BeamCutQuery(_SERVER.ServerName.Database);
                ScheduleQuery scheduleQuery = new ScheduleQuery(_SERVER.ServerName.Database);
                SequenceQuery sequenceQuery = new SequenceQuery(_SERVER.ServerName.Database);
                BuildingQuery buildingQuery = new BuildingQuery(_SERVER.ServerName.Database);

                var clone_po = beamCutQuery.GetBeamCutPo(BInterface.BeamCutPo_Id);
                lbTotalPoCutQty.Text = clone_po.CuttingQuantity.ToString();
                lbComponent.Text     = clone_po.ComponentRef;

                var po       = sequenceQuery.GetOriginalPo(ShareFuncs.GetInt(BInterface.OriginalPo_Id));
                var schedule = scheduleQuery.GetSchedule(ShareFuncs.GetInt(BInterface.Schedule_Id));
                if (schedule == null)
                {
                    if (po != null)
                    {
                        schedule = scheduleQuery.GetSchedule(po);
                    }

                    if (schedule == null)
                    {
                        this.Hide();
                        Error = true;
                        return;
                    }
                }
                lbPlace.Text            = place.ToString();
                DS_Interface.DataSource = BInterface;
                DS_Po.DataSource        = schedule;
                lbLine.Text             = buildingQuery.GetProductionLine(ShareFuncs.GetInt(schedule.ProductionLine_Id)).LineName;
            }
            catch
            {
                this.Hide();
                Error = true;
                return;
            }
        }
Example #7
0
        private void UpdateSelectedSchedule()
        {
            SelectedOriginalPo     = new OriginalPO();
            SelectedSchedule       = new Schedule();
            SelectedSequence       = new OriginalPOsequence();
            SelectedScheduleLine   = string.Empty;
            txtProductionLine.Text = string.Empty;
            if (lbSchedule.SelectedItem == null)
            {
                return;
            }


            SelectedSchedule = ScheduleQuery.GetSchedule((lbSchedule.SelectedItem as Schedule).id);

            SelectedProductionLine = BuildingQuery.GetProductionLine(ShareFuncs.GetInt(SelectedSchedule.ProductionLine_Id));

            txtProductionLine.Text = SelectedScheduleLine = SelectedProductionLine.LineName;

            UpdateModelComponent();

            UpdateOgiginalSequence();
        }