Beispiel #1
0
        public void ShowDataTank(int ID)
        {
            groupBox4.Hide();
            RW_CA_TANK_BUS busTank = new RW_CA_TANK_BUS();
            RW_CA_TANK     ca      = busTank.getData(ID);

            txtFC.Text = (ca.FC_Environ + ca.FC_Environ_Leak + ca.FC_Environ_Rupture).ToString();
            txtCA.Text = ca.ConsequenceCategory;
        }
Beispiel #2
0
        private void initData_Shell(int ID)
        {
            RW_CA_TANK_BUS busCA_Tank = new RW_CA_TANK_BUS();
            RW_CA_TANK     caTank     = busCA_Tank.getData(ID);

            tbFlowRateShellD1.Text = caTank.Flow_Rate_D1.ToString();
            tbFlowRateShellD2.Text = caTank.Flow_Rate_D2.ToString();
            tbFlowRateShellD3.Text = caTank.Flow_Rate_D3.ToString();
            tbFlowRateShellD4.Text = caTank.Flow_Rate_D4.ToString();

            tbLeakDurationShellD1.Text = caTank.Leak_Duration_D1.ToString();
            tbLeakDurationShellD2.Text = caTank.Leak_Duration_D2.ToString();
            tbLeakDurationShellD3.Text = caTank.Leak_Duration_D3.ToString();
            tbLeakDurationShellD4.Text = caTank.Leak_Duration_D4.ToString();

            tbReleaseVolumeLeakageShellD1.Text = caTank.Release_Volume_Leak_D1.ToString();
            tbReleaseVolumeLeakageShellD2.Text = caTank.Release_Volume_Leak_D2.ToString();
            tbReleaseVolumeLeakageShellD3.Text = caTank.Release_Volume_Leak_D3.ToString();
            tbReleaseVolumeLeakageShellD4.Text = caTank.Release_Volume_Leak_D4.ToString();

            tbReleaseVolumeRuptureShell.Text   = caTank.Release_Volume_Rupture.ToString();
            tbTimeLeakageGroundWaterShell.Text = caTank.Time_Leak_Ground.ToString();
            tbVolumeSubsoilShellD1.Text        = caTank.Volume_SubSoil_Leak_D1.ToString();
            tbVolumeSubsoilShellD4.Text        = caTank.Volume_SubSoil_Leak_D4.ToString();
            tbVolumeGroundWaterShellD1.Text    = caTank.Volume_Ground_Water_Leak_D1.ToString();
            tbVolumeGroundWaterShellD4.Text    = caTank.Volume_Ground_Water_Leak_D4.ToString();
            tbDikeRuptureShell.Text            = caTank.Barrel_Dike_Rupture.ToString();
            tbOn_siteShell.Text           = caTank.Barrel_Onsite_Rupture.ToString();
            tbIn_siteShell.Text           = caTank.Barrel_Offsite_Rupture.ToString();
            tbReachWaterRuptureShell.Text = caTank.Barrel_Water_Rupture.ToString();
            tbFCleakageShell.Text         = caTank.FC_Environ_Leak.ToString();
            tbFCruptureShell.Text         = caTank.FC_Environ_Rupture.ToString();

            tbTotalF_Shell.Text                   = caTank.FC_Environ.ToString();
            tbComponentDamageCost.Text            = caTank.Component_Damage_Cost.ToString();
            tbCostBussinessInterruptionShell.Text = caTank.Business_Cost.ToString();

            tbTotalConsequenceShell.Text    = caTank.Consequence.ToString();
            tbConsequenceCategoryShell.Text = caTank.ConsequenceCategory;
        }
Beispiel #3
0
        private void initData_Tank(int ID)
        {
            RW_CA_TANK_BUS busCA_Tank = new RW_CA_TANK_BUS();
            RW_CA_TANK     caTank     = busCA_Tank.getData(ID);

            tbHdraulicFluid.Text               = caTank.Hydraulic_Fluid.ToString();
            tbHdraulicWater.Text               = caTank.Hydraulic_Water.ToString();
            tbSeepageVelocity.Text             = caTank.Seepage_Velocity.ToString();
            tbFlowRateD1.Text                  = caTank.Flow_Rate_D1.ToString();
            tbFlowRateD4.Text                  = caTank.Flow_Rate_D4.ToString();
            tbLeakDurationD1.Text              = caTank.Leak_Duration_D1.ToString();
            tbLeakDurationD4.Text              = caTank.Leak_Duration_D4.ToString();
            tbRealeaseVolumeFromLeakageD1.Text = caTank.Release_Volume_Leak_D1.ToString();
            //MessageBox.Show(caTank.Release_Volume_Leak_D1.ToString());
            // MessageBox.Show(caTank.FC_Environ_Rupture.ToString());
            tbRealeaseVolumeFromLeakageD4.Text = caTank.Release_Volume_Leak_D4.ToString();
            tbReleaseVolumeFromRuptureD1.Text  = caTank.Release_Volume_Rupture_D1.ToString();
            tbReleaseVolumeFromRuptureD4.Text  = caTank.Release_Volume_Rupture_D4.ToString();
            tbTimeToInitiate.Text = caTank.Time_Leak_Ground.ToString();
            // MessageBox.Show(caTank.Time_Leak_Ground.ToString());
            tbVolumeSubsoilFromLeakageD1.Text     = caTank.Volume_SubSoil_Leak_D1.ToString();
            tbVolumeSubsoilFromLeakageD4.Text     = caTank.Volume_SubSoil_Leak_D4.ToString();
            tbVolumeGroundWaterFromLeakageD1.Text = caTank.Volume_Ground_Water_Leak_D1.ToString();
            tbVolumeGroundWaterFromLeakageD4.Text = caTank.Volume_Ground_Water_Leak_D4.ToString();
            tbWithinTheDike.Text              = caTank.Barrel_Dike_Rupture.ToString();
            tbWithinTheDike.Text              = caTank.Barrel_Dike_Rupture.ToString();
            tbOnsiteRupture.Text              = caTank.Barrel_Onsite_Rupture.ToString();
            tbOffsiteRupture.Text             = caTank.Barrel_Offsite_Rupture.ToString();
            tbReachWater.Text                 = caTank.Barrel_Water_Rupture.ToString();
            tbFC_Env_Leakage.Text             = caTank.FC_Environ_Leak.ToString();
            tbFC_Env_Rupture.Text             = caTank.FC_Environ_Rupture.ToString();
            tbMaterialFactor.Text             = caTank.Material_Factor.ToString();
            tbTotalCost.Text                  = caTank.FC_Environ.ToString();
            tbComponentDamageCost.Text        = caTank.Component_Damage_Cost.ToString();
            tbCostOfBusinessInterruption.Text = caTank.Business_Cost.ToString();
            tbTotalConsequence.Text           = caTank.Consequence.ToString();
            tbConsequenceCategory.Text        = caTank.ConsequenceCategory;
        }
 public void delete(RW_CA_TANK obj)
 {
     DAL.delete(obj.ID);
 }
 public void edit(RW_CA_TANK obj)
 {
     DAL.edit(obj.ID, obj.Hydraulic_Water, obj.Hydraulic_Fluid, obj.Seepage_Velocity, obj.Flow_Rate_D1, obj.Flow_Rate_D2, obj.Flow_Rate_D3, obj.Flow_Rate_D4, obj.Leak_Duration_D1, obj.Leak_Duration_D2, obj.Leak_Duration_D3, obj.Leak_Duration_D4, obj.Release_Volume_Leak_D1, obj.Release_Volume_Leak_D2, obj.Release_Volume_Leak_D3, obj.Release_Volume_Leak_D4, obj.Release_Volume_Rupture, obj.Liquid_Height, obj.Volume_Fluid, obj.Time_Leak_Ground, obj.Volume_SubSoil_Leak_D1, obj.Volume_SubSoil_Leak_D4, obj.Volume_Ground_Water_Leak_D1, obj.Volume_Ground_Water_Leak_D4, obj.Barrel_Dike_Leak, obj.Barrel_Dike_Rupture, obj.Barrel_Onsite_Leak, obj.Barrel_Onsite_Rupture, obj.Barrel_Offsite_Leak, obj.Barrel_Offsite_Rupture, obj.Barrel_Water_Leak, obj.Barrel_Water_Rupture, obj.FC_Environ_Leak, obj.FC_Environ_Rupture, obj.FC_Environ, obj.Material_Factor, obj.Component_Damage_Cost, obj.Business_Cost, obj.Consequence, obj.ConsequenceCategory);
 }
Beispiel #6
0
        public RW_CA_TANK getData(int ID)
        {
            RW_CA_TANK    obj  = new RW_CA_TANK();
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] " +
                         "SELECT [Hydraulic_Water] " +
                         ",[Hydraulic_Fluid] " +
                         ",[Seepage_Velocity] " +
                         ",[Flow_Rate_D1] " +
                         ",[Flow_Rate_D2] " +
                         ",[Flow_Rate_D3] " +
                         ",[Flow_Rate_D4] " +
                         ",[Leak_Duration_D1] " +
                         ",[Leak_Duration_D2] " +
                         ",[Leak_Duration_D3] " +
                         ",[Leak_Duration_D4] " +
                         ",[Release_Volume_Leak_D1] " +
                         ",[Release_Volume_Leak_D2] " +
                         ",[Release_Volume_Leak_D3] " +
                         ",[Release_Volume_Leak_D4] " +
                         ",[Release_Volume_Rupture] " +
                         ",[Liquid_Height] " +
                         ",[Volume_Fluid] " +
                         ",[Time_Leak_Ground] " +
                         ",[Volume_SubSoil_Leak_D1] " +
                         ",[Volume_SubSoil_Leak_D4] " +
                         ",[Volume_Ground_Water_Leak_D1] " +
                         ",[Volume_Ground_Water_Leak_D4] " +
                         ",[Barrel_Dike_Leak] " +
                         ",[Barrel_Dike_Rupture] " +
                         ",[Barrel_Onsite_Leak] " +
                         ",[Barrel_Onsite_Rupture] " +
                         ",[Barrel_Offsite_Leak] " +
                         ",[Barrel_Offsite_Rupture] " +
                         ",[Barrel_Water_Leak] " +
                         ",[Barrel_Water_Rupture] " +
                         ",[FC_Environ_Leak] " +
                         ",[FC_Environ_Rupture] " +
                         ",[FC_Environ] " +
                         ",[Material_Factor] " +
                         ",[Component_Damage_Cost] " +
                         ",[Business_Cost] " +
                         ",[Consequence] " +
                         ",[ConsequenceCategory] " +
                         " FROM [rbi].[dbo].[RW_CA_TANK] WHERE [ID] ='" + ID + "'";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj.ID = ID;
                            obj.Hydraulic_Water             = (float)reader.GetDouble(0);
                            obj.Hydraulic_Fluid             = (float)reader.GetDouble(1);
                            obj.Seepage_Velocity            = (float)reader.GetDouble(2);
                            obj.Flow_Rate_D1                = (float)reader.GetDouble(3);
                            obj.Flow_Rate_D2                = (float)reader.GetDouble(4);
                            obj.Flow_Rate_D3                = (float)reader.GetDouble(5);
                            obj.Flow_Rate_D4                = (float)reader.GetDouble(6);
                            obj.Leak_Duration_D1            = (float)reader.GetDouble(7);
                            obj.Leak_Duration_D2            = (float)reader.GetDouble(8);
                            obj.Leak_Duration_D3            = (float)reader.GetDouble(9);
                            obj.Leak_Duration_D4            = (float)reader.GetDouble(10);
                            obj.Release_Volume_Leak_D1      = (float)reader.GetDouble(11);
                            obj.Release_Volume_Leak_D2      = (float)reader.GetDouble(12);
                            obj.Release_Volume_Leak_D3      = (float)reader.GetDouble(13);
                            obj.Release_Volume_Leak_D4      = (float)reader.GetDouble(14);
                            obj.Release_Volume_Rupture      = (float)reader.GetDouble(15);
                            obj.Liquid_Height               = (float)reader.GetDouble(16);
                            obj.Volume_Fluid                = (float)reader.GetDouble(17);
                            obj.Time_Leak_Ground            = (float)reader.GetDouble(18);
                            obj.Volume_SubSoil_Leak_D1      = (float)reader.GetDouble(19);
                            obj.Volume_SubSoil_Leak_D4      = (float)reader.GetDouble(20);
                            obj.Volume_Ground_Water_Leak_D1 = (float)reader.GetDouble(21);
                            obj.Volume_Ground_Water_Leak_D4 = (float)reader.GetDouble(22);
                            obj.Barrel_Dike_Leak            = (float)reader.GetDouble(23);
                            obj.Barrel_Dike_Rupture         = (float)reader.GetDouble(24);
                            obj.Barrel_Onsite_Leak          = (float)reader.GetDouble(25);
                            obj.Barrel_Onsite_Rupture       = (float)reader.GetDouble(26);
                            obj.Barrel_Offsite_Leak         = (float)reader.GetDouble(27);
                            obj.Barrel_Offsite_Rupture      = (float)reader.GetDouble(28);
                            obj.Barrel_Water_Leak           = (float)reader.GetDouble(29);
                            obj.Barrel_Water_Rupture        = (float)reader.GetDouble(30);
                            obj.FC_Environ_Leak             = (float)reader.GetDouble(31);
                            obj.FC_Environ_Rupture          = (float)reader.GetDouble(32);
                            obj.FC_Environ            = (float)reader.GetDouble(33);
                            obj.Material_Factor       = (float)reader.GetDouble(34);
                            obj.Component_Damage_Cost = (float)reader.GetDouble(35);
                            obj.Business_Cost         = (float)reader.GetDouble(36);
                            obj.Consequence           = (float)reader.GetDouble(37);
                            obj.ConsequenceCategory   = reader.GetString(38);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA FAIL!", "ERROR!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(obj);
        }
Beispiel #7
0
        private void initData_Shell(int ID)
        {
            RW_CA_TANK_BUS busCA_Tank = new RW_CA_TANK_BUS();
            RW_CA_TANK     caTank     = busCA_Tank.getData(ID);

            #region consequences area
            tbFlowRateShellD1.Text = caTank.Flow_Rate_D1.ToString();
            tbFlowRateShellD2.Text = caTank.Flow_Rate_D2.ToString();
            tbFlowRateShellD3.Text = caTank.Flow_Rate_D3.ToString();
            tbFlowRateShellD4.Text = caTank.Flow_Rate_D4.ToString();

            tbLeakDurationShellD1.Text = caTank.Leak_Duration_D1.ToString();
            tbLeakDurationShellD2.Text = caTank.Leak_Duration_D2.ToString();
            tbLeakDurationShellD3.Text = caTank.Leak_Duration_D3.ToString();
            tbLeakDurationShellD4.Text = caTank.Leak_Duration_D4.ToString();

            tbReleaseVolumeLeakageShellD1.Text = caTank.Release_Volume_Leak_D1.ToString();
            tbReleaseVolumeLeakageShellD2.Text = caTank.Release_Volume_Leak_D2.ToString();
            tbReleaseVolumeLeakageShellD3.Text = caTank.Release_Volume_Leak_D3.ToString();
            tbReleaseVolumeLeakageShellD4.Text = caTank.Release_Volume_Leak_D4.ToString();

            tbReleaseVolumeLeakageShellD1.Text = caTank.Release_Volume_Leak_D1.ToString();
            tbReleaseVolumeLeakageShellD2.Text = caTank.Release_Volume_Leak_D2.ToString();
            tbReleaseVolumeLeakageShellD3.Text = caTank.Release_Volume_Leak_D3.ToString();
            tbReleaseVolumeLeakageShellD4.Text = caTank.Release_Volume_Leak_D4.ToString();
            tbTimeLeakageGroundWaterShell.Text = caTank.Time_Leak_Ground.ToString();
            tbVolumeSubsoilShellD1.Text        = caTank.Volume_SubSoil_Leak_D1.ToString();
            tbVolumeSubsoilShellD4.Text        = caTank.Volume_SubSoil_Leak_D4.ToString();
            tbVolumeGroundWaterShellD1.Text    = caTank.Volume_Ground_Water_Leak_D1.ToString();
            tbVolumeGroundWaterShellD4.Text    = caTank.Volume_Ground_Water_Leak_D4.ToString();
            tbDikeRuptureShell.Text            = caTank.Barrel_Dike_Rupture.ToString();
            tbOn_siteShell.Text           = caTank.Barrel_Onsite_Rupture.ToString();
            tbIn_siteShell.Text           = caTank.Barrel_Offsite_Rupture.ToString();
            tbReachWaterRuptureShell.Text = caTank.Barrel_Water_Rupture.ToString();
            tbFCleakageShell.Text         = caTank.FC_Environ_Leak.ToString();
            tbFCruptureShell.Text         = caTank.FC_Environ_Rupture.ToString();

            tbTotalF_Shell.Text                   = caTank.FC_Environ.ToString();
            tbComponentDamageCost.Text            = caTank.Component_Damage_Cost.ToString();
            tbCostBussinessInterruptionShell.Text = caTank.Business_Cost.ToString();

            tbTotalConsequenceShell.Text    = caTank.Consequence.ToString();
            tbConsequenceCategoryShell.Text = caTank.ConsequenceCategory;
            #endregion

            #region Tab COF Financial for Shell

            tbWithinDikeLeakageShell.Text   = caTank.Barrel_Dike_Leak.ToString();
            tbWithinDikeRuptureShell.Text   = caTank.Barrel_Dike_Rupture.ToString();
            tbOn_siteLeakageShell.Text      = caTank.Barrel_Onsite_Leak.ToString();
            tbOn_siteRuptureShell.Text      = caTank.Barrel_Onsite_Rupture.ToString();
            tbOff_siteLeakageShell.Text     = caTank.Barrel_Offsite_Leak.ToString();
            tbOff_siteRupureShell.Text      = caTank.Barrel_Offsite_Rupture.ToString();
            txtReachWaterLeakageShell.Text  = caTank.Barrel_Water_Leak.ToString();
            txtReachWaterRuptureShell.Text  = caTank.Barrel_Water_Rupture.ToString();
            tbFCenvLeakageShell.Text        = caTank.FC_Environ_Leak.ToString();
            tbFCenvRuptureShell.Text        = caTank.FC_Environ_Rupture.ToString();
            tbTotalFCenvShell.Text          = caTank.FC_Environ.ToString();
            tbComponentDamageCostShell.Text = caTank.Component_Damage_Cost.ToString();
            //tbDamageSurroundEquipmentShell.Text = caTank.
            tbCostOfBusinessInterruptionShell.Text = caTank.Business_Cost.ToString();
            //tbCostAssociatedPersonInjury.Text =

            #endregion
        }