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); } }