コード例 #1
0
        public void ShowDatatoControl(int id)
        {
            RW_MATERIAL_BUS BUS = new RW_MATERIAL_BUS();
            RW_MATERIAL     obj = BUS.getData(id);

            txtMaterial.Text             = obj.MaterialName;
            txtDesignPressure.Text       = obj.DesignPressure.ToString();
            txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString();
            txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString();
            txtBrittleFracture.Text      = obj.BrittleFractureThickness.ToString();
            txtCorrosionAllowance.Text   = obj.CorrosionAllowance.ToString();
            txtSigmaPhase.Text           = obj.SigmaPhase.ToString();
            for (int i = 0; i < itemsSulfurContent.Length; i++)
            {
                if (obj.SulfurContent == itemsSulfurContent[i])
                {
                    cbSulfurContent.SelectedIndex = i + 1;
                    break;
                }
            }
            for (int i = 0; i < itemsHeatTreatment.Length; i++)
            {
                if (obj.HeatTreatment == itemsHeatTreatment[i])
                {
                    cbHeatTreatment.SelectedIndex = i + 1;
                    break;
                }
            }
            txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString();
            for (int i = 0; i < itemsPTAMterial.Length; i++)
            {
                if (obj.PTAMaterialCode == itemsPTAMterial[i])
                {
                    cbPTAMaterialGrade.SelectedIndex = i + 1;
                    break;
                }
            }
            for (int i = 0; i < itemsHTHAMaterial.Length; i++)
            {
                if (obj.HTHAMaterialCode == itemsHTHAMaterial[i])
                {
                    cbHTHAMaterial.SelectedIndex = i + 1;
                    break;
                }
            }
            chkIsPTASeverity.Checked       = Convert.ToBoolean(obj.IsPTA);
            chkIsHTHASeverity.Checked      = Convert.ToBoolean(obj.IsHTHA);
            chkAusteniticSteel.Checked     = Convert.ToBoolean(obj.Austenitic);
            chkSusceptibleTemper.Checked   = Convert.ToBoolean(obj.Temper);
            chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy);
            chkNickelAlloy.Checked         = Convert.ToBoolean(obj.NickelBased);
            chkChromium.Checked            = Convert.ToBoolean(obj.ChromeMoreEqual12);
            txtAllowableStress.Text        = obj.AllowableStress.ToString();
            txtMaterialCostFactor.Text     = obj.CostFactor.ToString();
        }
コード例 #2
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            SplashScreenManager.ShowForm(typeof(WaitForm2));
            // data from file
            SITES_BUS                 busSite         = new SITES_BUS();
            FACILITY_BUS              busFacility     = new FACILITY_BUS();
            MANUFACTURER_BUS          busManufacture  = new MANUFACTURER_BUS();
            DESIGN_CODE_BUS           busDesign       = new DESIGN_CODE_BUS();
            EQUIPMENT_MASTER_BUS      busEqMaster     = new EQUIPMENT_MASTER_BUS();
            COMPONENT_MASTER_BUS      busComMaster    = new COMPONENT_MASTER_BUS();
            RW_ASSESSMENT_BUS         busAss          = new RW_ASSESSMENT_BUS();
            RW_EQUIPMENT_BUS          busEq           = new RW_EQUIPMENT_BUS();
            RW_COMPONENT_BUS          buscom          = new RW_COMPONENT_BUS();
            RW_EXTCOR_TEMPERATURE_BUS busExcort       = new RW_EXTCOR_TEMPERATURE_BUS();
            RW_STREAM_BUS             busStream       = new RW_STREAM_BUS();
            RW_MATERIAL_BUS           busMaterial     = new RW_MATERIAL_BUS();
            RW_COATING_BUS            busCoat         = new RW_COATING_BUS();
            RW_INPUT_CA_LEVEL_1_BUS   busInputCA      = new RW_INPUT_CA_LEVEL_1_BUS();
            FACILITY_RISK_TARGET_BUS  busRiskTarget   = new FACILITY_RISK_TARGET_BUS();
            Bus_PLANT_PROCESS_Excel   busExcelProcess = new Bus_PLANT_PROCESS_Excel();

            busExcelProcess.path = txtPathFileExcel.Text;
            List <SITES> listSite = busExcelProcess.getAllSite();

            foreach (SITES s in listSite)
            {
                if (!busSite.checkExist(s.SiteName))
                {
                    busSite.add(s);
                }
                else
                {
                    busSite.edit(s);
                }
            }

            List <FACILITY> listFacility = busExcelProcess.getFacility();

            foreach (FACILITY f in listFacility)
            {
                if (busFacility.checkExist(f.FacilityName))
                {
                    busFacility.edit(f);
                }
                else
                {
                    busFacility.add(f);
                    int FaciID = busFacility.getLastFacilityID();
                    FACILITY_RISK_TARGET riskTarget = new FACILITY_RISK_TARGET();
                    riskTarget.FacilityID = FaciID;
                    busRiskTarget.add(riskTarget);
                }
            }

            List <string> manufacture = busExcelProcess.getAllManufacture();

            for (int i = 0; i < manufacture.Count; i++)
            {
                MANUFACTURER manu = new MANUFACTURER();
                manu.ManufacturerID   = busManufacture.getIDbyName(manufacture[i]);
                manu.ManufacturerName = manufacture[i];
                if (busManufacture.getIDbyName(manufacture[i]) == 0)
                {
                    busManufacture.add(manu);
                }
                else
                {
                    busManufacture.edit(manu);
                }
            }

            List <String> designcode = busExcelProcess.getAllDesigncode();

            for (int i = 0; i < designcode.Count; i++)
            {
                DESIGN_CODE design = new DESIGN_CODE();
                design.DesignCodeID  = busDesign.getIDbyName(designcode[i]);
                design.DesignCode    = designcode[i];
                design.DesignCodeApp = "";
                if (design.DesignCodeID == 0)
                {
                    busDesign.add(design);
                }
                else
                {
                    busDesign.edit(design);
                }
            }

            List <EQUIPMENT_MASTER> listEpMaster = busExcelProcess.getEquipmentMaster();

            foreach (EQUIPMENT_MASTER eqM in listEpMaster)
            {
                if (busEqMaster.check(eqM.EquipmentNumber))
                {
                    busEqMaster.edit(eqM);
                }
                else
                {
                    busEqMaster.add(eqM);
                }
            }

            List <COMPONENT_MASTER> listComMaster = busExcelProcess.getComponentMaster();

            foreach (COMPONENT_MASTER comM in listComMaster)
            {
                if (busComMaster.checkExist(comM.ComponentNumber))
                {
                    busComMaster.edit(comM);
                }
                else
                {
                    busComMaster.add(comM);
                }
            }

            List <RW_ASSESSMENT> listRW_Assessment = busExcelProcess.getAssessment();
            List <int>           editExcel         = new List <int>();
            List <int>           addExcel          = new List <int>();

            foreach (RW_ASSESSMENT rwAss in listRW_Assessment)
            {
                //kiem tra xem Proposal add bang file Excel hay add bang tay
                List <int[]> ID_checkAddbyExcel = busAss.getCheckAddExcel_ID(rwAss.ComponentID, rwAss.EquipmentID);
                if (ID_checkAddbyExcel.Count != 0)
                {
                    for (int i = 0; i < ID_checkAddbyExcel.Count; i++)
                    {
                        if (ID_checkAddbyExcel[i][0] != 0) //kiem tra xem co phai Assessment nay duoc them tu file Excel ko, !=0 la them tu file Excel
                        {
                            rwAss.ID = ID_checkAddbyExcel[i][1];
                            editExcel.Add(rwAss.ID);
                            busAss.edit(rwAss);
                        }
                    }
                }
                else
                {
                    rwAss.AddByExcel = 1;
                    busAss.add(rwAss);
                    int assID = busAss.getLastID();
                    addExcel.Add(assID);
                    RW_INPUT_CA_LEVEL_1 inputCA = new RW_INPUT_CA_LEVEL_1();
                    inputCA.ID = assID;
                    busInputCA.add(inputCA);
                }
            }

            List <RW_EQUIPMENT> listRw_eq = busExcelProcess.getRwEquipment();

            for (int i = 0; i < listRw_eq.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_eq[i].ID == editExcel[j])
                        {
                            busEq.edit(listRw_eq[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_eq[i].ID == addExcel[j])
                        {
                            busEq.add(listRw_eq[i]);
                        }
                    }
                }
            }

            List <RW_COMPONENT> listRw_com = busExcelProcess.getRwComponent();

            for (int i = 0; i < listRw_com.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_com[i].ID == editExcel[j])
                        {
                            buscom.edit(listRw_com[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_com[i].ID == addExcel[j])
                        {
                            buscom.add(listRw_com[i]);
                        }
                    }
                }
            }

            List <RW_EXTCOR_TEMPERATURE> listRw_extcor = busExcelProcess.getRwExtTemp();

            //MessageBox.Show(listRw_extcor.Count.ToString());
            for (int i = 0; i < listRw_extcor.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_extcor[i].ID == editExcel[j])
                        {
                            //MessageBox.Show("add file excel");
                            busExcort.edit(listRw_extcor[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_extcor[i].ID == addExcel[j])
                        {
                            //MessageBox.Show("add file excel");
                            busExcort.add(listRw_extcor[i]);
                        }
                    }
                }
            }

            List <RW_STREAM> listRw_stream = busExcelProcess.getRwStream();

            for (int i = 0; i < listRw_stream.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_stream[i].ID == editExcel[j])
                        {
                            busStream.edit(listRw_stream[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_stream[i].ID == addExcel[j])
                        {
                            busStream.add(listRw_stream[i]);
                        }
                    }
                }
            }

            List <RW_MATERIAL> listRw_material = busExcelProcess.getRwMaterial();

            for (int i = 0; i < listRw_material.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_material[i].ID == editExcel[j])
                        {
                            busMaterial.edit(listRw_material[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_material[i].ID == addExcel[j])
                        {
                            busMaterial.add(listRw_material[i]);
                        }
                    }
                }
            }

            List <RW_COATING> listRw_coat = busExcelProcess.getRwCoating();

            for (int i = 0; i < listRw_coat.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (listRw_coat[i].ID == editExcel[j])
                        {
                            busCoat.edit(listRw_coat[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (listRw_coat[i].ID == addExcel[j])
                        {
                            busCoat.add(listRw_coat[i]);
                        }
                    }
                }
            }
            ButtonOKClicked = true;
            SplashScreenManager.CloseForm();
            MessageBox.Show("All data have been saved! You need to add Risk Target in Facility!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            this.Close();
        }
コード例 #3
0
        public void ShowDataToControl(int ID, string temUnit, string pressureUnit, string stressUnit, string thicknessUnit, string corrosionUnit)
        {
            RW_MATERIAL_BUS      BUS      = new RW_MATERIAL_BUS();
            RW_MATERIAL          obj      = BUS.getData(ID);
            RW_INPUT_CA_TANK_BUS busTank  = new RW_INPUT_CA_TANK_BUS();
            BUS_UNITS            convUnit = new BUS_UNITS();
            float tank = busTank.getProductionCost(ID);

            switch (temUnit)
            {
            case "DEG_C":
                txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString();
                txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString();
                txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString();
                break;

            case "DEG_F":
                txtMaxDesignTemperature.Text = (convUnit.CelToFah(obj.DesignTemperature)).ToString();
                txtMinDesignTemperature.Text = (convUnit.CelToFah(obj.MinDesignTemperature)).ToString();
                txtReferenceTemperature.Text = (convUnit.CelToFah(obj.ReferenceTemperature)).ToString();
                break;

            case "K":
                txtMaxDesignTemperature.Text = (convUnit.CelToKenvin(obj.DesignTemperature)).ToString();
                txtMinDesignTemperature.Text = (convUnit.CelToKenvin(obj.MinDesignTemperature)).ToString();
                txtReferenceTemperature.Text = (convUnit.CelToKenvin(obj.ReferenceTemperature)).ToString();
                break;
            }

            switch (pressureUnit)
            {
            case "psi":
                txtDesignPressure.Text = obj.DesignPressure.ToString();
                break;

            case "KSI":
                txtDesignPressure.Text = (obj.DesignPressure / convUnit.ksi).ToString();
                break;

            case "bar":
                txtDesignPressure.Text = (obj.DesignPressure / convUnit.bar).ToString();
                break;

            case "MPa":
                txtDesignPressure.Text = (obj.DesignPressure / convUnit.MPa).ToString();
                break;

            case "N/m2":
                txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpM2).ToString();
                break;

            case "N/cm2":
                txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpCM2).ToString();
                break;
            }

            switch (thicknessUnit)
            {
            case "mm":
                txtBrittleFracture.Text = obj.BrittleFractureThickness.ToString();
                break;

            case "in":
                txtBrittleFracture.Text = (obj.BrittleFractureThickness / convUnit.inch).ToString();
                break;

            case "m":
                txtBrittleFracture.Text = (obj.BrittleFractureThickness / convUnit.meter).ToString();
                break;
            }

            switch (corrosionUnit)
            {
            case "mm":
                txtCorrosionAllowance.Text = obj.CorrosionAllowance.ToString();
                break;

            case "mil":
                txtCorrosionAllowance.Text = (obj.CorrosionAllowance / convUnit.mil).ToString();
                break;
            }

            switch (stressUnit)
            {
            case "psi":
                txtAllowableStress.Text = obj.AllowableStress.ToString();
                break;

            case "KSI":
                txtAllowableStress.Text = (obj.AllowableStress / convUnit.ksi).ToString();
                break;

            case "bar":
                txtAllowableStress.Text = (obj.AllowableStress / convUnit.bar).ToString();
                break;

            case "MPa":
                txtAllowableStress.Text = (obj.AllowableStress / convUnit.MPa).ToString();
                break;

            case "N/m2":
                txtAllowableStress.Text = (obj.AllowableStress / convUnit.NpM2).ToString();
                break;

            case "N/cm2":
                txtAllowableStress.Text = (obj.AllowableStress / convUnit.NpCM2).ToString();
                break;
            }
            txtMaterial.Text = obj.MaterialName;
            for (int i = 0; i < itemsSulfurContent.Length; i++)
            {
                if (obj.SulfurContent == itemsSulfurContent[i])
                {
                    cbSulfurContent.SelectedIndex = i + 1;
                    break;
                }
            }
            for (int i = 0; i < itemsHeatTreatment.Length; i++)
            {
                if (obj.HeatTreatment == itemsHeatTreatment[i])
                {
                    cbHeatTreatment.SelectedIndex = i + 1;
                    break;
                }
            }

            for (int i = 0; i < itemsPTAMterial.Length; i++)
            {
                if (obj.PTAMaterialCode == itemsPTAMterial[i])
                {
                    cbPTAMaterialGrade.SelectedIndex = i + 1;
                    break;
                }
            }
            chkIsPTASeverity.Checked       = Convert.ToBoolean(obj.IsPTA);
            chkAusteniticSteel.Checked     = Convert.ToBoolean(obj.Austenitic);
            chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy);
            chkNickelAlloy.Checked         = Convert.ToBoolean(obj.NickelBased);
            chkChromium.Checked            = Convert.ToBoolean(obj.ChromeMoreEqual12);
            txtMaterialCostFactor.Text     = obj.CostFactor.ToString();
            txtProductionCost.Text         = tank.ToString();
        }
コード例 #4
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            SplashScreenManager.ShowForm(typeof(WaitForm2));
            SITES_BUS                 busSite        = new SITES_BUS();
            FACILITY_BUS              busFacility    = new FACILITY_BUS();
            MANUFACTURER_BUS          busManufacture = new MANUFACTURER_BUS();
            DESIGN_CODE_BUS           busDesignCode  = new DESIGN_CODE_BUS();
            FACILITY_RISK_TARGET_BUS  busRiskTarget  = new FACILITY_RISK_TARGET_BUS();
            EQUIPMENT_MASTER_BUS      busEquipMaster = new EQUIPMENT_MASTER_BUS();
            COMPONENT_MASTER_BUS      busCompMaster  = new COMPONENT_MASTER_BUS();
            RW_ASSESSMENT_BUS         busAss         = new RW_ASSESSMENT_BUS();
            RW_EQUIPMENT_BUS          busEquip       = new RW_EQUIPMENT_BUS();
            RW_COMPONENT_BUS          busCom         = new RW_COMPONENT_BUS();
            RW_EXTCOR_TEMPERATURE_BUS busExtcor      = new RW_EXTCOR_TEMPERATURE_BUS();
            RW_STREAM_BUS             busStream      = new RW_STREAM_BUS();
            RW_MATERIAL_BUS           busMaterial    = new RW_MATERIAL_BUS();
            RW_COATING_BUS            busCoating     = new RW_COATING_BUS();
            RW_INPUT_CA_TANK_BUS      busInputCATank = new RW_INPUT_CA_TANK_BUS();
            Bus_PLANT_PROCESS_Excel   busExcel       = new Bus_PLANT_PROCESS_Excel();

            busExcel.path = txtPathFileExcel.Text;
            //Sites
            List <SITES> lstSite = busExcel.getAllSite();

            foreach (SITES s in lstSite)
            {
                if (!busSite.checkExist(s.SiteName))
                {
                    busSite.add(s);
                }
                else
                {
                    busSite.edit(s);
                }
            }

            //Facility
            List <FACILITY> lstFacility = busExcel.getFacility();

            foreach (FACILITY f in lstFacility)
            {
                if (busFacility.checkExist(f.FacilityName))
                {
                    busFacility.edit(f);
                }
                else
                {
                    busFacility.add(f);
                    int FaciID = busFacility.getLastFacilityID();
                    FACILITY_RISK_TARGET riskTarget = new FACILITY_RISK_TARGET();
                    riskTarget.FacilityID = FaciID;
                    busRiskTarget.add(riskTarget);
                }
            }

            //Manufacture
            List <string> manufacture = busExcel.getAllManufacture();

            for (int i = 0; i < manufacture.Count; i++)
            {
                MANUFACTURER manu = new MANUFACTURER();
                manu.ManufacturerID   = busManufacture.getIDbyName(manufacture[i]);
                manu.ManufacturerName = manufacture[i];
                if (busManufacture.getIDbyName(manufacture[i]) == 0)
                {
                    busManufacture.add(manu);
                }
                else
                {
                    busManufacture.edit(manu);
                }
            }

            //Design Code
            List <string> designCode = busExcel.getAllDesigncode();

            for (int i = 0; i < designCode.Count; i++)
            {
                DESIGN_CODE design = new DESIGN_CODE();
                design.DesignCodeID  = busDesignCode.getIDbyName(designCode[i]);
                design.DesignCode    = designCode[i];
                design.DesignCodeApp = "";
                if (design.DesignCodeID == 0)
                {
                    busDesignCode.add(design);
                }
                else
                {
                    busDesignCode.edit(design);
                }
            }

            //Equipment Master
            List <EQUIPMENT_MASTER> lstEquipMaster = busExcel.getEquipmentMaster();

            foreach (EQUIPMENT_MASTER eq in lstEquipMaster)
            {
                if (busEquipMaster.check(eq.EquipmentNumber))
                {
                    busEquipMaster.edit(eq);
                }
                else
                {
                    busEquipMaster.add(eq);
                }
            }

            //Component Master
            List <COMPONENT_MASTER> lstCompMaster = busExcel.getComponentMaster();

            foreach (COMPONENT_MASTER com in lstCompMaster)
            {
                if (busCompMaster.checkExist(com.ComponentNumber))
                {
                    com.ComponentID = busCompMaster.getIDbyName(com.ComponentNumber);
                    busCompMaster.edit(com);
                }
                else
                {
                    busCompMaster.add(com);
                }
            }

            //Rw Assessment
            List <RW_ASSESSMENT> lstAssessment = busExcel.getAssessment();
            List <int>           editExcel     = new List <int>();
            List <int>           addExcel      = new List <int>();

            foreach (RW_ASSESSMENT ass in lstAssessment)
            {
                List <int[]> ID_checkAddbyExcel = busAss.getCheckAddExcel_ID(ass.ComponentID, ass.EquipmentID);
                if (ID_checkAddbyExcel.Count != 0)
                {
                    for (int i = 0; i < ID_checkAddbyExcel.Count; i++)
                    {
                        if (ID_checkAddbyExcel[i][0] != 0) //kiem tra xem co phai Assessment nay duoc them tu file Excel ko
                        {
                            ass.ID = ID_checkAddbyExcel[i][1];
                            editExcel.Add(ass.ID);
                            busAss.edit(ass);
                        }
                    }
                }
                else
                {
                    ass.AddByExcel = 1;
                    busAss.add(ass);
                    int assID = busAss.getLastID();
                    addExcel.Add(assID);
                    RW_INPUT_CA_TANK inputCATank = new RW_INPUT_CA_TANK();
                    inputCATank.ID = assID;
                    busInputCATank.add(inputCATank);
                }
            }

            //RW Equipment
            List <RW_EQUIPMENT> lstEquipment = busExcel.getRwEquipmentTank();

            for (int i = 0; i < lstEquipment.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstEquipment[i].ID == editExcel[j])
                        {
                            busEquip.edit(lstEquipment[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstEquipment[i].ID == addExcel[j])
                        {
                            busEquip.add(lstEquipment[i]);
                        }
                    }
                }
            }

            //RW Component
            List <RW_COMPONENT> lstComponent = busExcel.getRwComponentTank();

            for (int i = 0; i < lstComponent.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstComponent[i].ID == editExcel[j])
                        {
                            busCom.edit(lstComponent[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstComponent[i].ID == addExcel[j])
                        {
                            busCom.add(lstComponent[i]);
                        }
                    }
                }
            }

            //RW Extcor temperature
            List <RW_EXTCOR_TEMPERATURE> lstExtcor = busExcel.getRwExtTemp();

            for (int i = 0; i < lstExtcor.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstExtcor[i].ID == editExcel[j])
                        {
                            busExtcor.edit(lstExtcor[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstExtcor[i].ID == addExcel[j])
                        {
                            busExtcor.add(lstExtcor[i]);
                        }
                    }
                }
            }

            //RW Stream
            List <RW_STREAM> lstStream = busExcel.getRwStreamTank();

            for (int i = 0; i < lstStream.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstStream[i].ID == editExcel[j])
                        {
                            busStream.edit(lstStream[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstStream[i].ID == addExcel[j])
                        {
                            busStream.add(lstStream[i]);
                        }
                    }
                }
            }

            //RW Material
            List <RW_MATERIAL> lstMaterial = busExcel.getRwMaterialTank();

            for (int i = 0; i < lstMaterial.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstMaterial[i].ID == editExcel[j])
                        {
                            busMaterial.edit(lstMaterial[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstMaterial[i].ID == addExcel[j])
                        {
                            busMaterial.add(lstMaterial[i]);
                        }
                    }
                }
            }

            //RW Coating
            List <RW_COATING> lstCoating = busExcel.getRwCoating();

            for (int i = 0; i < lstCoating.Count; i++)
            {
                if (editExcel.Count != 0)
                {
                    for (int j = 0; j < editExcel.Count; j++)
                    {
                        if (lstCoating[i].ID == editExcel[j])
                        {
                            busCoating.edit(lstCoating[i]);
                        }
                    }
                }
                if (addExcel.Count != 0)
                {
                    for (int j = 0; j < addExcel.Count; j++)
                    {
                        if (lstCoating[i].ID == addExcel[j])
                        {
                            busCoating.add(lstCoating[i]);
                        }
                    }
                }
            }
            ButtonOKClicked = true;
            SplashScreenManager.CloseForm();
            MessageBox.Show("All data have been saved! You need to add Risk Target in Facility!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            this.Close();
        }
コード例 #5
0
        public void ShowDatatoControl(int id, string temperatureUnit, string pressureUnit, string corrosionUnit)
        {
            RW_MATERIAL_BUS BUS      = new RW_MATERIAL_BUS();
            RW_MATERIAL     obj      = BUS.getData(id);
            BUS_UNITS       convUnit = new BUS_UNITS();

            txtMaterial.Text = obj.MaterialName;
            switch (temperatureUnit)
            {
            case "DEG_C":
                txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString();
                txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString();
                txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString();
                break;

            case "DEG_F":
                txtMaxDesignTemperature.Text = (convUnit.CelToFah(obj.DesignTemperature)).ToString();
                txtMinDesignTemperature.Text = (convUnit.CelToFah(obj.MinDesignTemperature)).ToString();
                txtReferenceTemperature.Text = (convUnit.CelToFah(obj.ReferenceTemperature)).ToString();
                break;

            case "K":
                txtMaxDesignTemperature.Text = (convUnit.CelToKenvin(obj.DesignTemperature)).ToString();
                txtMinDesignTemperature.Text = (convUnit.CelToKenvin(obj.MinDesignTemperature)).ToString();
                txtReferenceTemperature.Text = (convUnit.CelToKenvin(obj.ReferenceTemperature)).ToString();
                break;
            }

            switch (pressureUnit)
            {
            case "PSI":
                txtDesignPressure.Text  = (obj.DesignPressure / convUnit.psi).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength / convUnit.psi).ToString();
                txtTensileStrength.Text = (obj.TensileStrength / convUnit.psi).ToString();
                break;

            case "KSI":
                txtDesignPressure.Text  = (obj.DesignPressure / convUnit.ksi).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength / convUnit.ksi).ToString();
                txtTensileStrength.Text = (obj.TensileStrength / convUnit.ksi).ToString();
                break;

            case "BAR":
                txtDesignPressure.Text  = (obj.DesignPressure / convUnit.bar).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength / convUnit.bar).ToString();
                txtTensileStrength.Text = (obj.TensileStrength / convUnit.bar).ToString();
                break;

            case "MPA":
                txtDesignPressure.Text  = (obj.DesignPressure).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength).ToString();
                txtTensileStrength.Text = (obj.TensileStrength).ToString();
                break;

            case "NM2":
                txtDesignPressure.Text  = (obj.DesignPressure / convUnit.NpM2).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength / convUnit.NpM2).ToString();
                txtTensileStrength.Text = (obj.TensileStrength / convUnit.NpM2).ToString();
                break;

            case "NCM2":
                txtDesignPressure.Text  = (obj.DesignPressure / convUnit.NpCM2).ToString();
                txtYieldStrength.Text   = (obj.YieldStrength / convUnit.NpCM2).ToString();
                txtTensileStrength.Text = (obj.TensileStrength / convUnit.NpCM2).ToString();
                break;
            }

            switch (corrosionUnit)
            {
            case "MM":
                txtCorrosionAllowance.Text = obj.CorrosionAllowance.ToString();
                break;

            case "MIL":
                txtCorrosionAllowance.Text = (obj.CorrosionAllowance / convUnit.mil).ToString();
                break;
            }
            txtSigmaPhase.Text = obj.SigmaPhase.ToString();
            for (int i = 0; i < itemsSulfurContent.Length; i++)
            {
                if (obj.SulfurContent == itemsSulfurContent[i])
                {
                    cbSulfurContent.SelectedIndex = i + 1;
                    break;
                }
            }
            for (int i = 0; i < itemsPTAMterial.Length; i++)
            {
                if (obj.PTAMaterialCode == itemsPTAMterial[i])
                {
                    cbPTAMaterialGrade.SelectedIndex = i + 1;
                    break;
                }
            }
            for (int i = 0; i < itemsHTHAMaterial.Length; i++)
            {
                if (obj.HTHAMaterialCode == itemsHTHAMaterial[i])
                {
                    cbHTHAMaterial.SelectedIndex = i + 1;
                    break;
                }
            }
            chkIsPTASeverity.Checked       = Convert.ToBoolean(obj.IsPTA);
            chkIsHTHASeverity.Checked      = Convert.ToBoolean(obj.IsHTHA);
            chkAusteniticSteel.Checked     = Convert.ToBoolean(obj.Austenitic);
            chkSusceptibleTemper.Checked   = Convert.ToBoolean(obj.Temper);
            chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy);
            chkNickelAlloy.Checked         = Convert.ToBoolean(obj.NickelBased);
            chkChromium.Checked            = Convert.ToBoolean(obj.ChromeMoreEqual12);
            txtTensileStrength.Text        = obj.TensileStrength.ToString();
            txtYieldStrength.Text          = obj.YieldStrength.ToString();
            txtMaterialCostFactor.Text     = obj.CostFactor.ToString();
        }