Exemplo n.º 1
0
        private void CheckingEdition_Load(object sender, EventArgs e)
        {
            // Fill dep and machine check DB combo box with prefered user dep
            DBComboxDep.FillList(mDataBaseManager_O, "TypeDep", "TypeDepID", "TypeDepLib");
            DBComboxHall1.FillList(mDataBaseManager_O, "Hall", "HallID", "HallName");
            DBComboxHall2.FillList(mDataBaseManager_O, "Hall", "HallID", "HallName");
            DBComboxHall3.FillList(mDataBaseManager_O, "Hall", "HallID", "HallName");
            DBComboxHall4.FillList(mDataBaseManager_O, "Hall", "HallID", "HallName");

            // Get user prefered dep and hall
            UInt32 PrefDep_UL  = 0;
            UInt32 PrefHall_UL = 0;

            UInt32.TryParse(mDataBaseManager_O.GetTableField("Pers", "PrefDepID", "PersID=" + mPersID_UL), out PrefDep_UL);
            UInt32.TryParse(mDataBaseManager_O.GetTableField("Pers", "PrefHallID", "PersID=" + mPersID_UL), out PrefHall_UL);

            // If prefered dep and hall found, select it in dep combo box
            if (PrefDep_UL > 0)
            {
                DBComboxDep.SelectItemByID(PrefDep_UL);
            }
            if (PrefHall_UL > 0)
            {
                DBComboxHall1.SelectItemByID(PrefHall_UL);
                DBComboxHall2.SelectItemByID(PrefHall_UL);
                DBComboxHall3.SelectItemByID(PrefHall_UL);
                DBComboxHall4.SelectItemByID(PrefHall_UL);
            }

            // Update Task combo box
            UpdateTaskDBComboBox(PrefDep_UL);
            UpdateMachineDBCombox(DBComboxMachine1, PrefHall_UL);
            UpdateMachineDBCombox(DBComboxMachine2, PrefHall_UL);
            UpdateMachineDBCombox(DBComboxMachine3, PrefHall_UL);
            UpdateMachineDBCombox(DBComboxMachine4, PrefHall_UL);

            if (mMode_e == CheckingEditionMode.Edit)
            {
                LoadChecking();
            }

            if (mDataBaseManager_O.mConnected_b)
            {
                LblSumHours.Text = mDataBaseManager_O.mFunctionManager_O.SCFNC_CountPersHourInJob(mComJobID_UL, mPersID_UL).ToString();
            }
        }
Exemplo n.º 2
0
        public void LoadChecking()
        {
            String        SQLRequest_ST;
            SqlDataReader SqlDataReader_O;
            UInt32        PointageMachine_UL = 1;
            UInt32        TaskID_UL          = 0;
            UInt32        MachineID_UL       = 0;
            UInt32        HallID_UL          = 0;
            UInt32        DepID_UL           = 0;

            if (mDataBaseManager_O != null && mDataBaseManager_O.mConnected_b)
            {
                // Fill pointage info
                SQLRequest_ST   = "SELECT * FROM Pointage WHERE ComJobEtapeID=" + mComJobEtapeID_UL;
                SqlDataReader_O = mDataBaseManager_O.Select(SQLRequest_ST);

                while (SqlDataReader_O.Read())
                {
                    // Select Task
                    if (UInt32.TryParse(mDataBaseManager_O.GetTableField("ComJobEtape", "TypeTacheID", "ComJobEtapeID=" + mComJobEtapeID_UL), out TaskID_UL))
                    {
                        if (UInt32.TryParse(mDataBaseManager_O.GetTableField("TypeTache", "TypeDepID", "TypeTacheID=" + TaskID_UL), out DepID_UL))
                        {
                            DBComboxDep.SelectItemByID(DepID_UL);
                            DBComboxTask.SelectItemByID(TaskID_UL);
                        }
                    }
                    // Fill NbrH field
                    TxtNbrH.Text = SqlDataReader_O["NbrH"].ToString();
                    // Fill Rem field
                    TxtRem.Text = SqlDataReader_O["Rem"].ToString();
                }

                SqlDataReader_O.Close();

                // Fill pointage machine info
                SQLRequest_ST   = "SELECT * FROM PointageMachine WHERE ComJobEtapeID=" + mComJobEtapeID_UL;
                SqlDataReader_O = mDataBaseManager_O.Select(SQLRequest_ST);

                while (SqlDataReader_O.Read())
                {
                    if (PointageMachine_UL >= 1 && PointageMachine_UL <= 4)
                    {
                        UInt32.TryParse(SqlDataReader_O["PointageMachinelID"].ToString(), out mPointageMachineID_O[PointageMachine_UL - 1]);
                    }

                    if (PointageMachine_UL == 1)
                    {
                        if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL))
                        {
                            if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL))
                            {
                                DBComboxHall1.SelectItemByID(HallID_UL);
                                DBComboxMachine1.SelectItemByID(MachineID_UL);
                            }
                        }
                        TxtNbrhMach1.Text = SqlDataReader_O["NbrHMachine"].ToString();
                    }
                    else if (PointageMachine_UL == 2)
                    {
                        if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL))
                        {
                            if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL))
                            {
                                DBComboxHall2.SelectItemByID(HallID_UL);
                                DBComboxMachine2.SelectItemByID(MachineID_UL);
                            }
                        }
                        TxtNbrhMach2.Text = SqlDataReader_O["NbrHMachine"].ToString();
                    }
                    else if (PointageMachine_UL == 3)
                    {
                        if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL))
                        {
                            if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL))
                            {
                                DBComboxHall3.SelectItemByID(HallID_UL);
                                DBComboxMachine3.SelectItemByID(MachineID_UL);
                            }
                        }
                        TxtNbrhMach3.Text = SqlDataReader_O["NbrHMachine"].ToString();
                    }
                    else if (PointageMachine_UL == 4)
                    {
                        if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL))
                        {
                            if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL))
                            {
                                DBComboxHall4.SelectItemByID(HallID_UL);
                                DBComboxMachine4.SelectItemByID(MachineID_UL);
                            }
                        }
                        TxtNbrhMach4.Text = SqlDataReader_O["NbrHMachine"].ToString();
                    }

                    PointageMachine_UL++;
                }

                SqlDataReader_O.Close();
            }
        }