public void Populate_EXCEL_DesignTables(clsFiles Files_In, clsProject Project_In,
                                                clsOpCond OpCond_In, clsDB DB_In, string FilePath_In)
        //============================================================================================
        {
            CloseExcelFiles();

            //  RADIAL:
            //  -------
            Populate_tblMapping_Radial(Project_In, OpCond_In, DB_In);                   //....Software variable value field.
            Populate_EXCEL_Radial(Files_In, Project_In, DB_In, FilePath_In);            //....Design Table.

            //  BLANK Assy:
            //  -----------
            Populate_tblMapping_Blank(Project_In, DB_In);
            Populate_EXCEL_BlankAssy(Files_In, Project_In, DB_In, FilePath_In);

            //  SEAL:
            //  -----
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Seal ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Seal)
            {
                Populate_tblMapping_Seal(Project_In, DB_In);
                Populate_EXCEL_Seal(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  TL THRUST BEARING:
            //  ------------------
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
            {
                Populate_tblMapping_TL_TB(Project_In, DB_In);
                Populate_EXCEL_TL_TB(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  THRUST BEARING ASSY:
            //  --------------------
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
            {
                Populate_tblMapping_TB_Assy(Project_In, DB_In);
                Populate_EXCEL_TB_Assy(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  COMPLETE ASSY:
            //  --------------
            Populate_tblMapping_Complete(Project_In, OpCond_In, DB_In);
            Populate_EXCEL_CompleteAssy(Files_In, Project_In, DB_In, FilePath_In);


            //  Solid Works Files.
            //  ------------------
            CreateSWFiles(Project_In, Files_In, FilePath_In);
        }
        private string[] mDwg_Title_Suffix = new string[8];          //....1-based

        #endregion



        #region "CLASS METHODS:"
        //----------------------

        ////public void PopulateAndMove_SWFiles_ProjectFolder(clsFiles Files_In, clsProject Project_In,
        ////                                                  clsOpCond OpCond_In, clsDB DB_In, string FilePath_In)
        //////====================================================================================================
        ////{
        ////    //....SWFiles - Design tables, Model & Drawing files.
        ////    //
        ////    PopulateAndMove_DesignTables(Files_In, Project_In, OpCond_In, DB_In, FilePath_In);
        ////    CopyAndMove_SW_Model_Dwg_Files(Project_In, Files_In, FilePath_In);
        ////}



        #region "DESIGN TABLES POPULATION:"

        private void PopulateAndMove_DesignTables(clsFiles Files_In, clsProject Project_In,
                                                  clsOpCond OpCond_In, clsDB DB_In, string FilePath_In)
        //===============================================================================================
        {
            //....This routine copies the design table templates to the project design tables, populates them
            //........and places them in the given project folder.

            Close_DesignTables();

            //  RADIAL:
            //  -------
            Populate_tblMapping_Radial(Project_In, OpCond_In, DB_In);                       //....Software variable value field.
            PopulateAndMove_DT_Radial(Files_In, Project_In, DB_In, FilePath_In);            //....Design Table.

            //  BLANK Assy:
            //  -----------
            Populate_tblMapping_Blank(Project_In, DB_In);
            PopulateAndMove_DT_BlankAssy(Files_In, Project_In, DB_In, FilePath_In);

            //  SEAL:
            //  -----
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Seal ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Seal)
            {
                Populate_tblMapping_Seal(Project_In, DB_In);
                PopulateAndMove_DT_Seal(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  TL THRUST BEARING:
            //  ------------------
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
            {
                Populate_tblMapping_TL_TB(Project_In, DB_In);
                PopulateAndMove_DT_TL_TB(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  THRUST BEARING ASSY:
            //  --------------------
            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL ||
                Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
            {
                Populate_tblMapping_TB_Assy(Project_In, DB_In);
                PopulateAndMove_DT_TB_Assy(Files_In, Project_In, DB_In, FilePath_In);
            }

            //  COMPLETE ASSY:
            //  --------------
            Populate_tblMapping_Complete(Project_In, OpCond_In, DB_In);
            PopulateAndMove_DT_CompleteAssy(Files_In, Project_In, DB_In, FilePath_In);
        }
        private void Populate_tblMapping_Complete(clsProject Project_In, clsOpCond OpCond_In, clsDB DB_In)
        //================================================================================================
        {
            try
            {
                //....Set Mapping Value.
                StringCollection pCellColName      = new StringCollection();
                StringCollection pSoftware_VarName = new StringCollection();

                string pOrderBy = " ORDER BY fldItemNo ASC";

                DB_In.PopulateStringCol(pCellColName, "tblMapping_Complete", "fldCellColName",
                                        pOrderBy);
                DB_In.PopulateStringCol(pSoftware_VarName, "tblMapping_Complete", "fldSoftware_VarName",
                                        pOrderBy);

                String pUPDATE = "UPDATE tblMapping_Complete ";
                String pSET    = "SET fldSoftware_VarVal = ";
                String pVALUE  = null;
                String pWHERE  = null;
                String pSQL    = null;

                pSQL = pUPDATE + pSET + "NULL";
                DB_In.ExecuteCommand(pSQL);

                int pNo_Suffix = 1;
                if (Project_In.AssyDwg.No_Suffix != "")
                {
                    pNo_Suffix = Convert.ToInt32(Project_In.AssyDwg.No_Suffix);
                }

                for (int i = 0; i < pSoftware_VarName.Count; i++)
                {
                    pSQL   = null;
                    pWHERE = null;
                    pVALUE = null;

                    if (pSoftware_VarName[i] != "")
                    {
                        switch (pSoftware_VarName[i])
                        {
                        case "gProject.AssDwg.No-01":
                            //-----------------------       //Col. A
                            //....Set Project Number.
                            if (pNo_Suffix <= 9)
                            {
                                pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix).ToString() + "'";
                            }
                            else
                            {
                                pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix).ToString() + "'";
                            }
                            break;


                        case "gProject.AssDwg.No-02":
                            //-----------------------       //Col. C
                            if ((pNo_Suffix + 1) <= 9)
                            {
                                pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix + 1).ToString() + "'";
                            }
                            else
                            {
                                pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix + 1).ToString() + "'";
                            }
                            break;

                        case "gProject.Product.EndConfig[0].Type":
                            //-------------------------------------     //Col. D
                            if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Seal)
                            {
                                pVALUE = "'E'";
                            }
                            else if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                            {
                                pVALUE = "'T'";
                            }
                            break;

                        case "gProject.AssDwg.No-03_1":
                            //-------------------------         //Col. E
                            if ((pNo_Suffix + 2) <= 9)
                            {
                                if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Seal)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix + 2).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Seal)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix + 2).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            break;

                        case "gProject.AssDwg.No-03_2":
                            //-------------------------         //Col. F
                            if ((pNo_Suffix + 2) <= 9)
                            {
                                if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix + 2).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix + 2).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            break;


                        case "gProject.Product.EndConfig[1].Type":
                            //-------------------------------------     //Col. G
                            if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Seal)
                            {
                                pVALUE = "'E'";
                            }
                            else if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                            {
                                pVALUE = "'T'";
                            }
                            break;

                        case "gProject.AssDwg.No-04_1":
                            //--------------------------        //Col. H
                            if ((pNo_Suffix + 3) <= 9)
                            {
                                if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Seal)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix + 3).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Seal)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix + 3).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            break;

                        case "gProject.AssDwg.No-04_2":
                            //--------------------------        //Col. I
                            if ((pNo_Suffix + 3) <= 9)
                            {
                                if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-0" + (pNo_Suffix + 3).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                                {
                                    pVALUE = "'" + Project_In.AssyDwg.No + "-" + (pNo_Suffix + 3).ToString() + "'";
                                }
                                else
                                {
                                    pVALUE = "''";
                                }
                            }
                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Loc_Bearing_Vert":
                            //-------------------------------------------------------       //Col. J
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Loc_Casing_SL == clsBearing_Radial_FP.clsAntiRotPin.eLoc_Casing_SL.Center)
                            {
                                pVALUE = "'I'";
                            }
                            else
                            {
                                pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Loc_Bearing_Vert.ToString() + "'";
                            }
                            break;

                        case "gProject.Product.Bearing.Mount.Holes_GoThru":
                            //---------------------------------------------     //Col. K
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_GoThru)
                            {
                                pVALUE = "'Y'";
                            }
                            else
                            {
                                pVALUE = "'N'";
                            }

                            break;

                        case "gProject.Product.Bearing.Mount.Holes_Bolting":
                            //-----------------------------------------------       //Col. L
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_GoThru)
                            {
                                if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Front)
                                {
                                    pVALUE = "'F'";
                                }
                                else if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Back)
                                {
                                    pVALUE = "'B'";
                                }
                            }
                            else
                            {
                                pVALUE = "''";
                            }
                            break;

                        case "gProject.Product.EndConfig[0].MountHoles.Type":
                            //-----------------------------------------------       //Col. M
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_GoThru)
                            {
                                if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Front)
                                {
                                    if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.C)
                                    {
                                        pVALUE = "'C'";
                                    }
                                    else if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.H)
                                    {
                                        pVALUE = "'H'";
                                    }
                                    else if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.T)
                                    {
                                        pVALUE = "'T'";
                                    }
                                }
                                else if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Back)
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                // pVALUE = "''";
                                if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.C)
                                {
                                    pVALUE = "'C'";
                                }
                                else if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.H)
                                {
                                    pVALUE = "'H'";
                                }
                                else if (Project_In.Product.EndConfig[0].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.T)
                                {
                                    pVALUE = "'T'";
                                }
                            }
                            break;

                        case "gProject.Product.EndConfig[1].MountHoles.Type":
                            //------------------------------------------------      //Col. N
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_GoThru)
                            {
                                if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Back)
                                {
                                    if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.C)
                                    {
                                        pVALUE = "'C'";
                                    }
                                    else if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.H)
                                    {
                                        pVALUE = "'H'";
                                    }
                                    else if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.T)
                                    {
                                        pVALUE = "'T'";
                                    }
                                }
                                else if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Holes_Bolting == clsBearing_Radial_FP.eFaceID.Front)
                                {
                                    pVALUE = "''";
                                }
                            }
                            else
                            {
                                //pVALUE = "''";
                                if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.C)
                                {
                                    pVALUE = "'C'";
                                }
                                else if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.H)
                                {
                                    pVALUE = "'H'";
                                }
                                else if (Project_In.Product.EndConfig[1].MountHoles.Type == clsEndConfig.clsMountHoles.eMountHolesType.T)
                                {
                                    pVALUE = "'T'";
                                }
                            }
                            break;

                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.Type":
                            //------------------------------------------------------------      //Col. O
                            pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.Type + "'";
                            break;

                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.Unit.System":
                            //-------------------------------------------------------------------   //Col. P
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'I'";
                            }
                            else
                            {
                                pVALUE = "'M'";
                            }
                            break;


                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.D_Desig":
                            //--------------------------------------------------------------        //Col. Q
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D_Desig != null)                 //BG 31DEC12
                            {
                                if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D_Desig.Contains('M'))
                                {
                                    pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D_Desig.Replace('M', ' ').Trim() + "'";
                                }
                                else
                                {
                                    if (((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D_Desig.Contains('/'))
                                    {
                                        pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D + "'";
                                    }
                                    else
                                    {
                                        pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.D_Desig + "'";
                                    }
                                }
                            }

                            break;


                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.Pitch":
                            //-------------------------------------------------------------     //Col. R
                            pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.Pitch, "") + "'";
                            break;


                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.L":
                            //----------------------------------------------------------        //Col. S
                            pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.L, "") + "'";
                            break;


                        case "gProject.Product.Beraing.Mount.Fixture[0].Screw_Spec.Mat":
                            //----------------------------------------------------------        //Col. T
                            pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].Screw_Spec.Mat + "'";
                            break;

                        case "gProject.Product.Beraing.Mount.Fixture[0].HolesCount":
                            //------------------------------------------------------            //Col. U
                            pVALUE = "'" + modMain.ConvIntToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).Mount.Fixture[0].HolesCount) + "'";
                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Loc_Casing_SL ":
                            //----------------------------------------------------      //Col. W
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Loc_Casing_SL == clsBearing_Radial_FP.clsAntiRotPin.eLoc_Casing_SL.Center)
                            {
                                pVALUE = "'N'";
                            }
                            else if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Loc_Casing_SL == clsBearing_Radial_FP.clsAntiRotPin.eLoc_Casing_SL.Offset)
                            {
                                pVALUE = "'Y'";
                            }

                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Spec.Type ":
                            //------------------------------------------------      //Col. X
                            pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.Type + "'";
                            break;


                        case "gProject.Product.Beraing.AntiRotPin.Spec.Unit.System":
                            //------------------------------------------------------        //Col. Y
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'I'";
                            }
                            else
                            {
                                pVALUE = "'M'";
                            }
                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Spec.D_Desig":
                            //---------------------------------------------------       //Col. Z
                            if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.D_Desig.Contains('M'))
                            {
                                pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.D_Desig.Replace('M', ' ').Trim() + "'";
                            }
                            else
                            {
                                if (((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.D_Desig.Contains('/'))
                                {
                                    pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.D + "'";
                                }
                                else
                                {
                                    pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.D_Desig + "'";
                                }
                            }

                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Spec.L":
                            //---------------------------------------------     //Col. AA
                            pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.L, "") + "'";
                            break;

                        case "gProject.Product.Beraing.AntiRotPin.Spec.Mat":
                            //-----------------------------------------------       //Col. AB
                            pVALUE = "'" + ((clsBearing_Radial_FP)Project_In.Product.Bearing).AntiRotPin.Spec.Mat + "'";
                            break;

                        case "gOpCond.Speed()":           //....Shaft Speed
                            //----------------    //Col. AF
                            ////pVALUE = "'" + modMain.ConvIntToStr(OpCond_In.Speed()) + "'";
                            break;

                        case "gOpCond.OilSupply.Lube.Type":           //....Oil Type
                            //-----------------------------   //Col. AG
                            ////pVALUE = "'" + OpCond_In.OilSupply.Lube.Type + "'";
                            break;

                        case "gOpCond.OilSupply.Temp":           //....Inlet Temp
                            //-----------------------    //Col. AH
                            ////if (Project_In.Unit.System == clsUnit.eSystem.English)
                            ////{
                            ////    pVALUE = "'" + modMain.NInt(OpCond_In.OilSupply.Temp).ToString() + "'";
                            ////}
                            ////else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            ////{
                            ////    pVALUE = "'" + modMain.NInt(Project_In.Unit.CFac_Temp_EngToMet(OpCond_In.OilSupply.Temp)).ToString() + "'";
                            ////}

                            break;


                        case "gOpCond.OilSupply.Press":         //....Oil Pressure
                            //-----------------------   //Col. AI
                            ////if (Project_In.Unit.System == clsUnit.eSystem.English)
                            ////{
                            ////    //pVALUE = "'" + modMain.NInt(OpCond_In.OilSupply.Press).ToString() + "'";
                            ////    pVALUE = "'" + OpCond_In.OilSupply.Press.ToString("#0.0") + "'";
                            ////}
                            ////else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            ////{
                            ////    //pVALUE = "'" + Project_In.Unit.CFac_Press_EngToMet(modMain.NInt(OpCond_In.OilSupply.Press)).ToString("#0.00") + "'";
                            ////    pVALUE = "'" + Project_In.Unit.CFac_Press_EngToMet(OpCond_In.OilSupply.Press).ToString("#0.00") + "'";
                            ////}

                            break;


                        case  "gOpCond.Radial_Load()":                    // "gOpCond.Load()":      //....Radial Load
                            //------------------------      //Col. AJ
                            ////if (Project_In.Unit.System == clsUnit.eSystem.English)
                            ////{
                            ////    //pVALUE = "'" + modMain.NInt(OpCond_In.Load()).ToString() + "'";
                            ////    pVALUE = "'" + OpCond_In.Radial_Load().ToString("#0.0") + "'";
                            ////}
                            ////else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            ////{
                            ////    //pVALUE = "'" + modMain.NInt(Project_In.Unit.CFac_Load_EngToMet(OpCond_In.Load())).ToString() + "'";
                            ////    pVALUE = "'" + Project_In.Unit.CFac_Load_EngToMet(OpCond_In.Radial_Load()).ToString("#0.00") + "'";
                            ////}

                            break;


                        case "gProject.Product.Bearing.DShaft_Range[1]/ gProject.Product.Bearing.DShaft_Range[0]":           //....Shaft Dia(Max/Min)
                            //-----------------------------------------------------------------------------------    //Col. AK
                            if (Project_In.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).DShaft_Range[1], "#0.0000") + "/" +
                                         modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).DShaft_Range[0], "#0.0000") + "'";
                            }
                            else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(Project_In.Unit.CEng_Met(((clsBearing_Radial_FP)Project_In.Product.Bearing).DShaft_Range[1]), "#0.0000") + "/" +
                                         modMain.ConvDoubleToStr(Project_In.Unit.CEng_Met(((clsBearing_Radial_FP)Project_In.Product.Bearing).DShaft_Range[0]), "#0.0000") + "'";
                            }
                            break;


                        case "gProject.Product.Bearing.DSet_Range[0]/gProject.Product.Bearing.DSet_Range[1]":               //....Bore Dia(Min/Max)
                            //-------------------------------------------------------------------------------       //Col. AL
                            if (Project_In.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).DSet_Range[0], "#0.0000") + "/" +
                                         modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).DSet_Range[1], "#0.0000") + "'";
                            }
                            else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(Project_In.Unit.CEng_Met(((clsBearing_Radial_FP)Project_In.Product.Bearing).DSet_Range[0]), "#0.0000") + "/" +
                                         modMain.ConvDoubleToStr(Project_In.Unit.CEng_Met(((clsBearing_Radial_FP)Project_In.Product.Bearing).DSet_Range[1]), "#0.0000") + "'";
                            }
                            break;


                        case "gProject.Product.Bearing.Pad.Pivot.Offset":           //....Offset
                            //-------------------------------------------   //Col. AM
                            pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).Pad.Pivot.Offset / 100.0, "#0.00") + "'";
                            break;


                        case "gProject.Product.Bearing.PreLoad()":                //....Preload
                            //-----------------------------------         //Col. AN
                            pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).PreLoad(), "#0.000") + "'";
                            break;


                        case "gProject.Product.Bearing.PerformData.Power_HP":               //....Power loss
                            //-----------------------------------------------       //Col. AO
                            if (Project_In.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.Power_HP, "#0.0") + "'";
                            }
                            else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(Project_In.Product.Unit.CFac_Power_EngToMet(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.Power_HP), "#0.0") + "'";
                            }
                            break;


                        case "gProject.Product.Bearing.PerformData.FlowReqd_gpm":           //....Oil Flow
                            //---------------------------------------------------   //Col. AP
                            if (Project_In.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.FlowReqd_gpm, "#0.0") + "'";
                            }
                            else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(Project_In.Product.Unit.CFac_GPM_EngToMet(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.FlowReqd_gpm), "#0.0") + "'";
                            }
                            break;


                        case "gProject.Product.Bearing.PerformData.TempRise_F":             //....Temp. Rise
                            //-------------------------------------------------     //Col. AQ
                            if (Project_In.Unit.System == clsUnit.eSystem.English)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.TempRise_F, "#0.0") + "'";
                            }
                            else if (Project_In.Unit.System == clsUnit.eSystem.Metric)
                            {
                                pVALUE = "'" + modMain.ConvDoubleToStr(Project_In.Product.Unit.CFac_TRise_EngToMet(((clsBearing_Radial_FP)Project_In.Product.Bearing).PerformData.TempRise_F), "#0.0") + "'";
                            }
                            break;


                        case "gProject.Customer.PartNo":            //....Part No
                            //---------------------------   //Col. AR
                            pVALUE = "'" + Project_In.Customer.PartNo + "'";
                            break;


                        case "gProject.Customer.MachineDesc":
                            //-------------------------------       //Col. AS
                            pVALUE = "'" + Project_In.Customer.MachineDesc + "'";
                            break;

                        //BG 10JAN13
                        ////case "gOpCond.Thrust_Load_Front()":         //"gProject.Product.EndConfig[0].PerformData.PadMax_Load":
                        ////    //------------------------------       //Col. CE
                        ////    //double pMaxLoad = 0.0;
                        ////    //int pPadCount = 0;
                        ////    //if (Project_In.Product.EndConfig[0].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                        ////    //{
                        ////    //    pPadCount = ((clsBearing_Thrust_TL)Project_In.Product.EndConfig[0]).Pad_Count;
                        ////    //    pMaxLoad = ((clsBearing_Thrust_TL)Project_In.Product.EndConfig[0]).PerformData.PadMax.Load;

                        ////    //    pVALUE = "'" + modMain.ConvDoubleToStr(pMaxLoad * pPadCount, "") + "'";
                        ////    //}
                        ////    //else if (Project_In.Product.EndConfig[1].Type == clsEndConfig.eType.Thrust_Bearing_TL)
                        ////    //{
                        ////    //    pPadCount = ((clsBearing_Thrust_TL)Project_In.Product.EndConfig[1]).Pad_Count;
                        ////    //    pMaxLoad = ((clsBearing_Thrust_TL)Project_In.Product.EndConfig[1]).PerformData.PadMax.Load;
                        ////    //    pVALUE = "'" + modMain.ConvDoubleToStr(pMaxLoad * pPadCount, "") + "'";
                        ////    //}

                        ////    pVALUE = "'" + modMain.ConvDoubleToStr(OpCond_In.Thrust_Load_Front(), "#0.0") + "'";
                        ////    break;

                        ////case "gOpCond.Thrust_Load_Back()":
                        ////    //------------------------------       //Col. CF
                        ////    pVALUE = "'" + modMain.ConvDoubleToStr(OpCond_In.Thrust_Load_Back(), "#0.0") + "'";
                        ////    break;

                        case "gProject.Customer.Name":
                            //-------------------------     //Col. CG
                            pVALUE = "'" + Project_In.Customer.Name + "'";
                            break;
                        }

                        if (pVALUE != null)
                        {
                            pWHERE = " WHERE fldCellColName = '" + pCellColName[i] + "'";
                            pSQL   = pUPDATE + pSET + pVALUE + pWHERE;
                            DB_In.ExecuteCommand(pSQL);
                        }
                    }
                }
            }
            catch (Exception pEXP)
            {
                MessageBox.Show("Excel File Error - " + pEXP.Message);
            }
        }