public List <RW_PRIMARY_FLUID> getDataSource()
        {
            List <RW_PRIMARY_FLUID> list = new List <RW_PRIMARY_FLUID>();
            RW_PRIMARY_FLUID        obj  = null;
            SqlConnection           conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]  " +
                         "SELECT [ID]" +
                         ",[FluidName]" +
                         ",[NBP]" +
                         ",[MW]" +
                         ",[Density]" +
                         ",[ChemicalFactor]" +
                         ",[HealthDegree]" +
                         ",[Flammability]" +
                         ",[Reactivity]" +
                         "  FROM [rbi].[dbo].[RW_PRIMARY_FLUID]" +
                         " ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj    = new RW_PRIMARY_FLUID();
                            obj.ID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.FluidName = reader.GetString(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.NBP = reader.GetFloat(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.MW = reader.GetFloat(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.Density = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.ChemicalFactor = reader.GetInt32(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.HealthDegree = reader.GetInt32(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.Flammability = reader.GetInt32(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.Reactivity = reader.GetInt32(8);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!", "ERROR!");
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }
Esempio n. 2
0
        public List <RW_ASSESSMENT> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <RW_ASSESSMENT> list = new List <RW_ASSESSMENT>();
            RW_ASSESSMENT        obj  = null;
            String sql = " Use [rbi] Select [ID]" +
                         ",[EquipmentID]" +
                         ",[ComponentID]" +
                         ",[AssessmentDate]" +
                         ",[AssessmentMethod]" +
                         ",[RiskAnalysisPeriod]" +
                         ",[IsEquipmentLinked]" +
                         ",[RecordType]" +
                         ",[ProposalNo]" +
                         ",[RevisionNo]" +
                         ",[IsRecommend]" +
                         ",[ProposalOrRevision]" +
                         ",[AdoptedBy]" +
                         ",[AdoptedDate]" +
                         ",[RecommendedBy]" +
                         ",[RecommendedDate]" +
                         ",[ProposalName]" +
                         "From [dbo].[RW_ASSESSMENT]  ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj             = new RW_ASSESSMENT();
                            obj.ID          = reader.GetInt32(0);
                            obj.EquipmentID = reader.GetInt32(1);
                            obj.ComponentID = reader.GetInt32(2);
                            if (!reader.IsDBNull(3))
                            {
                                obj.AssessmentDate = reader.GetDateTime(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.AssessmentMethod = reader.GetInt32(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.RiskAnalysisPeriod = reader.GetInt32(5);
                            }
                            obj.IsEquipmentLinked = reader.GetOrdinal("IsEquipmentLinked");
                            if (!reader.IsDBNull(7))
                            {
                                obj.RecordType = reader.GetString(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.ProposalNo = reader.GetInt32(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.RevisionNo = reader.GetInt32(9);
                            }
                            obj.IsRecommend = reader.GetOrdinal("IsRecommend");
                            if (!reader.IsDBNull(11))
                            {
                                obj.ProposalOrRevision = reader.GetString(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.AdoptedBy = reader.GetString(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.AdoptedDate = reader.GetDateTime(13);
                            }
                            if (!reader.IsDBNull(14))
                            {
                                obj.RecommendedBy = reader.GetString(14);
                            }
                            if (!reader.IsDBNull(15))
                            {
                                obj.RecommendedDate = reader.GetDateTime(15);
                            }
                            if (!reader.IsDBNull(16))
                            {
                                obj.ProposalName = reader.GetString(16);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
        public RW_INPUT_CA_LEVEL_1 GetData(int ID)
        {
            RW_INPUT_CA_LEVEL_1 obj  = new RW_INPUT_CA_LEVEL_1();
            SqlConnection       conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] SELECT [API_FLUID]" +
                         ",[SYSTEM]" +
                         ",[Release_Duration]" +
                         ",[Detection_Type]" +
                         ",[Isulation_Type]" +
                         ",[Mitigation_System]" +
                         ",[Equipment_Cost]" +
                         ",[Injure_Cost]" +
                         ",[Evironment_Cost]" +
                         ",[Toxic_Percent]" +
                         ",[Personal_Density]" +
                         ",[Material_Cost]" +
                         ",[Production_Cost]" +
                         ",[Mass_Inventory]" +
                         ",[Mass_Component]" +
                         ",[Stored_Pressure]" +
                         ",[Stored_Temp]" +
                         "  FROM [rbi].[dbo].[RW_INPUT_CA_LEVEL1] 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;
                            try
                            {
                                obj.API_FLUID = reader.GetString(0);
                            }
                            catch
                            {
                                obj.API_FLUID = "";
                            }
                            try
                            {
                                obj.SYSTEM = reader.GetString(1);
                            }
                            catch
                            {
                                obj.SYSTEM = "Liquid";
                            }
                            try
                            {
                                obj.Release_Duration = reader.GetString(2);
                            }
                            catch
                            {
                                obj.Release_Duration = "";
                            }
                            try
                            {
                                obj.Detection_Type = reader.GetString(3);
                            }
                            catch
                            {
                                obj.Detection_Type = "";
                            }
                            try
                            {
                                obj.Isulation_Type = reader.GetString(4);
                            }
                            catch
                            {
                                obj.Isulation_Type = "";
                            }
                            try
                            {
                                obj.Mitigation_System = reader.GetString(5);
                            }
                            catch
                            {
                                obj.Mitigation_System = "";
                            }
                            try
                            {
                                obj.Equipment_Cost = (float)reader.GetDouble(6);
                            }
                            catch
                            {
                                obj.Equipment_Cost = 0;
                            }
                            try
                            {
                                obj.Injure_Cost = (float)reader.GetDouble(7);
                            }
                            catch
                            {
                                obj.Injure_Cost = 0;
                            }
                            try
                            {
                                obj.Environment_Cost = (float)reader.GetDouble(8);
                            }
                            catch
                            {
                                obj.Environment_Cost = 0;
                            }
                            try
                            {
                                obj.Toxic_Percent = (float)reader.GetDouble(9);
                            }
                            catch
                            {
                                obj.Toxic_Percent = 0;
                            }
                            try
                            {
                                obj.Personal_Density = (float)reader.GetDouble(10);
                            }
                            catch
                            {
                                obj.Personal_Density = 0;
                            }
                            try
                            {
                                obj.Material_Cost = (float)reader.GetDouble(11);
                            }
                            catch
                            {
                                obj.Material_Cost = 0;
                            }
                            try
                            {
                                obj.Production_Cost = (float)reader.GetDouble(12);
                            }
                            catch
                            {
                                obj.Production_Cost = 0;
                            }
                            try
                            {
                                obj.Mass_Inventory = (float)reader.GetDouble(13);
                            }
                            catch
                            {
                                obj.Mass_Inventory = 0;
                            }
                            try
                            {
                                obj.Mass_Component = (float)reader.GetDouble(14);
                            }
                            catch
                            {
                                obj.Mass_Component = 0;
                            }
                            try
                            {
                                obj.Stored_Pressure = (float)reader.GetDouble(15);
                            }
                            catch
                            {
                                obj.Stored_Pressure = 0;
                            }
                            try
                            {
                                obj.Stored_Temp = (float)reader.GetDouble(16);
                            }
                            catch
                            {
                                obj.Stored_Temp = 0;
                            }
                        }
                    }
                }
            }
            catch
            {
                obj.ID = 0;
                //MessageBox.Show("GET DATA FAIL!" + ex.ToString(), "ERROR!");
            }
            finally
            {
                conn.Close();
            }
            return(obj);
        }
Esempio n. 4
0
        public List <RW_MATERIAL> getDataSource()
        {
            List <RW_MATERIAL> list = new List <RW_MATERIAL>();
            RW_MATERIAL        obj  = null;
            SqlConnection      conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]  SELECT [ID]" +
                         ",[MaterialName]" +
                         ",[DesignPressure]" +
                         ",[DesignTemperature]" +
                         ",[MinDesignTemperature]" +
                         ",[BrittleFractureThickness]" +
                         ",[CorrosionAllowance]" +
                         ",[SigmaPhase]" +
                         ",[SulfurContent]" +
                         ",[HeatTreatment]" +
                         ",[SteelProductForm]" +
                         ",[ReferenceTemperature]" +
                         ",[PTAMaterialCode]" +
                         ",[HTHAMaterialCode]" +
                         ",[IsPTA]" +
                         ",[IsHTHA]" +
                         ",[Austenitic]" +
                         ",[Temper]" +
                         ",[CarbonLowAlloy]" +
                         ",[NickelBased]" +
                         ",[ChromeMoreEqual12]" +
                         ",[YieldStrength]" +
                         ",[TensileStrength]" +
                         ",[CostFactor]" +
                         "FROM [dbo].[RW_MATERIAL] ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj    = new RW_MATERIAL();
                            obj.ID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.MaterialName = reader.GetString(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.DesignPressure = reader.GetFloat(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.DesignTemperature = reader.GetFloat(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.MinDesignTemperature = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.BrittleFractureThickness = reader.GetFloat(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.CorrosionAllowance = reader.GetFloat(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.SigmaPhase = reader.GetFloat(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.SulfurContent = reader.GetString(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.HeatTreatment = reader.GetString(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.SteelProductForm = reader.GetString(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.ReferenceTemperature = reader.GetFloat(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.PTAMaterialCode = reader.GetString(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.HTHAMaterialCode = reader.GetString(13);
                            }
                            obj.IsPTA             = reader.GetInt32(14);
                            obj.IsHTHA            = reader.GetInt32(15);
                            obj.Austenitic        = reader.GetInt32(16);
                            obj.Temper            = reader.GetInt32(17);
                            obj.CarbonLowAlloy    = reader.GetInt32(18);
                            obj.NickelBased       = reader.GetInt32(19);
                            obj.ChromeMoreEqual12 = reader.GetInt32(20);
                            if (!reader.IsDBNull(21))
                            {
                                obj.YieldStrength = reader.GetFloat(21);
                            }
                            if (!reader.IsDBNull(22))
                            {
                                obj.TensileStrength = reader.GetFloat(22);
                            }
                            obj.CostFactor = reader.GetFloat(23);
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!", "ERROR!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
        public List <GENERIC_FLUID> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <GENERIC_FLUID> list = new List <GENERIC_FLUID>();
            GENERIC_FLUID        obj  = null;
            String sql = " Use [rbi] Select [GenericFluidID]" +
                         ",[GenericFluid]" +
                         ",[ExamplesOfApplicable]" +
                         ",[FluidType]" +
                         ",[NBP]" +
                         ",[MW]" +
                         ",[Density]" +
                         ",[AmbientState]" +
                         ",[AutoIgnitionTemperature]" +
                         ",[ChemicalFactor]" +
                         ",[HealthDegree]" +
                         ",[Flammability]" +
                         ",[Reactivity]" +
                         "From [dbo].[GENERIC_FLUID]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj = new GENERIC_FLUID();
                            obj.GenericFluidID = reader.GetInt32(0);
                            obj.GenericFluid   = reader.GetString(1);
                            if (!reader.IsDBNull(2))
                            {
                                obj.ExamplesOfApplicable = reader.GetString(2);
                            }
                            obj.FluidType = reader.GetInt32(3);
                            if (!reader.IsDBNull(4))
                            {
                                obj.NBP = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.MW = reader.GetFloat(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.Density = reader.GetFloat(6);
                            }
                            obj.AmbientState = reader.GetInt32(7);
                            if (!reader.IsDBNull(8))
                            {
                                obj.AutoIgnitionTemperature = reader.GetInt32(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.ChemicalFactor = reader.GetInt32(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.HealthDegree = reader.GetInt32(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.Flammability = reader.GetInt32(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.Reactivity = reader.GetInt32(12);
                            }


                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
        public RW_CA_LEVEL_1 getData(int ID)
        {
            RW_CA_LEVEL_1 obj  = new RW_CA_LEVEL_1();
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] " +
                         "SELECT [Release_Phase]" +
                         ",[fact_di]" +
                         ",[fact_mit]" +
                         ",[fact_ait]" +
                         ",[CA_cmd]" +
                         ",[CA_inj_flame]" +
                         ",[CA_inj_toxic]" +
                         ",[CA_inj_ntnf]" +
                         ",[FC_cmd]" +
                         ",[FC_affa]" +
                         ",[FC_prod]" +
                         ",[FC_inj]" +
                         ",[FC_envi]" +
                         ",[FC_total]" +
                         ",[FCOF_Category]" +
                         " FROM [rbi].[dbo].[RW_CA_LEVEL1] 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.Release_Phase = reader.GetString(0);
                            obj.fact_di       = (float)reader.GetDouble(1);
                            obj.fact_mit      = (float)reader.GetDouble(2);
                            obj.fact_ait      = (float)reader.GetDouble(3);
                            obj.CA_cmd        = (float)reader.GetDouble(4);
                            obj.CA_inj_flame  = (float)reader.GetDouble(5);
                            obj.CA_inj_toxic  = (float)reader.GetDouble(6);
                            obj.CA_inj_ntnf   = (float)reader.GetDouble(7);
                            obj.FC_cmd        = (float)reader.GetDouble(8);
                            obj.FC_affa       = (float)reader.GetDouble(9);
                            obj.FC_prod       = (float)reader.GetDouble(10);
                            obj.FC_inj        = (float)reader.GetDouble(11);
                            obj.FC_envi       = (float)reader.GetDouble(12);
                            obj.FC_total      = (float)reader.GetDouble(13);
                            obj.FCOF_Category = reader.GetString(14);
                        }
                    }
                }
            }
            catch
            {
                obj.ID = 0;
                //MessageBox.Show("GET DATA FAIL!", "ERROR!");
            }
            finally
            {
                conn.Close();
            }
            return(obj);
        }
Esempio n. 7
0
        public List <FACILITY_RISK_TARGET> getDataSource()
        {
            List <FACILITY_RISK_TARGET> list = new List <FACILITY_RISK_TARGET>();
            FACILITY_RISK_TARGET        obj  = null;
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "SELECT [FacilityID]" +
                         ",[RiskTarget_A]" +
                         ",[RiskTarget_B]" +
                         ",[RiskTarget_C]" +
                         ",[RiskTarget_D]" +
                         ",[RiskTarget_E]" +
                         ",[RiskTarget_CA]" +
                         ",[RiskTarget_FC]" +
                         "  FROM [rbi].[dbo].[FACILITY_RISK_TARGET]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj            = new FACILITY_RISK_TARGET();
                            obj.FacilityID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.RiskTarget_A = reader.GetFloat(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.RiskTarget_B = reader.GetFloat(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.RiskTarget_C = reader.GetFloat(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.RiskTarget_D = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.RiskTarget_E = reader.GetFloat(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.RiskTarget_CA = reader.GetFloat(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.RiskTarget_FC = reader.GetFloat(7);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }
Esempio n. 8
0
        public RW_FULL_POF getData(int ID)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            RW_FULL_POF obj = new RW_FULL_POF();
            String      sql = "Use [rbi] Select [ID]" +
                              ",[ThinningAP1]" +
                              ",[ThinningAP2]" +
                              ",[ThinningAP3]" +
                              ",[SCCAP1]" +
                              ",[SCCAP2]" +
                              ",[SCCAP3]" +
                              ",[ExternalAP1]" +
                              ",[ExternalAP2]" +
                              ",[ExternalAP3]" +
                              ",[BrittleAP1]" +
                              ",[BrittleAP2]" +
                              ",[BrittleAP3]" +
                              ",[HTHA_AP1]" +
                              ",[HTHA_AP2]" +
                              ",[HTHA_AP3]" +
                              ",[FatigueAP1]" +
                              ",[FatigueAP2]" +
                              ",[FatigueAP3]" +
                              ",[FMS]" +
                              ",[ThinningType]" +
                              ",[GFFTotal]" +
                              ",[ThinningLocalAP1]" +
                              ",[ThinningLocalAP2]" +
                              ",[ThinningLocalAP3]" +
                              ",[ThinningGeneralAP1]" +
                              ",[ThinningGeneralAP2]" +
                              ",[ThinningGeneralAP3]" +
                              ",[TotalDFAP1]" +
                              ",[TotalDFAP2]" +
                              ",[TotalDFAP3]" +
                              ",[PoFAP1]" +
                              ",[PoFAP2]" +
                              ",[PoFAP3]" +
                              ",[MatrixPoFAP1]" +
                              ",[MatrixPoFAP2]" +
                              ",[MatrixPoFAP3]" +
                              ",[RLI]" +
                              ",[SemiAP1]" +
                              ",[SemiAP2]" +
                              ",[SemiAP3]" +
                              ",[PoFAP1Category]" +
                              ",[PoFAP2Category]" +
                              ",[PoFAP3Category]" +
                              ",[CoFValue]" +
                              ",[CoFCategory]" +
                              ",[CoFMatrixValue]" +
                              "From [dbo].[RW_FULL_POF] 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 = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.ThinningAP1 = (float)reader.GetDouble(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.ThinningAP2 = (float)reader.GetDouble(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.ThinningAP3 = (float)reader.GetDouble(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.SCCAP1 = (float)reader.GetDouble(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.SCCAP2 = (float)reader.GetDouble(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.SCCAP3 = (float)reader.GetDouble(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.ExternalAP1 = (float)reader.GetDouble(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.ExternalAP2 = (float)reader.GetDouble(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.ExternalAP3 = (float)reader.GetDouble(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.BrittleAP1 = (float)reader.GetDouble(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.BrittleAP2 = (float)reader.GetDouble(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.BrittleAP3 = (float)reader.GetDouble(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.HTHA_AP1 = (float)reader.GetDouble(13);
                            }
                            if (!reader.IsDBNull(14))
                            {
                                obj.HTHA_AP2 = (float)reader.GetDouble(14);
                            }
                            if (!reader.IsDBNull(15))
                            {
                                obj.HTHA_AP3 = (float)reader.GetDouble(15);
                            }
                            if (!reader.IsDBNull(16))
                            {
                                obj.FatigueAP1 = (float)reader.GetDouble(16);
                            }
                            if (!reader.IsDBNull(17))
                            {
                                obj.FatigueAP2 = (float)reader.GetDouble(17);
                            }
                            if (!reader.IsDBNull(18))
                            {
                                obj.FatigueAP3 = (float)reader.GetDouble(18);
                            }
                            if (!reader.IsDBNull(19))
                            {
                                obj.FMS = (float)reader.GetDouble(19);
                            }
                            if (!reader.IsDBNull(20))
                            {
                                obj.ThinningType = reader.GetString(20);
                            }
                            if (!reader.IsDBNull(21))
                            {
                                obj.GFFTotal = (float)reader.GetDouble(21);
                            }
                            if (!reader.IsDBNull(22))
                            {
                                obj.ThinningLocalAP1 = (float)reader.GetDouble(22);
                            }
                            if (!reader.IsDBNull(23))
                            {
                                obj.ThinningLocalAP2 = (float)reader.GetDouble(23);
                            }
                            if (!reader.IsDBNull(24))
                            {
                                obj.ThinningLocalAP3 = (float)reader.GetDouble(24);
                            }
                            if (!reader.IsDBNull(25))
                            {
                                obj.ThinningGeneralAP1 = (float)reader.GetDouble(25);
                            }
                            if (!reader.IsDBNull(26))
                            {
                                obj.ThinningGeneralAP2 = (float)reader.GetDouble(26);
                            }
                            if (!reader.IsDBNull(27))
                            {
                                obj.ThinningGeneralAP3 = (float)reader.GetDouble(27);
                            }
                            if (!reader.IsDBNull(28))
                            {
                                obj.TotalDFAP1 = (float)reader.GetDouble(28);
                            }
                            if (!reader.IsDBNull(29))
                            {
                                obj.TotalDFAP2 = (float)reader.GetDouble(29);
                            }
                            if (!reader.IsDBNull(30))
                            {
                                obj.TotalDFAP3 = (float)reader.GetDouble(30);
                            }
                            if (!reader.IsDBNull(31))
                            {
                                obj.PoFAP1 = (float)reader.GetDouble(31);
                            }
                            if (!reader.IsDBNull(32))
                            {
                                obj.PoFAP2 = (float)reader.GetDouble(32);
                            }
                            if (!reader.IsDBNull(33))
                            {
                                obj.PoFAP3 = (float)reader.GetDouble(33);
                            }
                            if (!reader.IsDBNull(34))
                            {
                                obj.MatrixPoFAP1 = (float)reader.GetDouble(34);
                            }
                            if (!reader.IsDBNull(35))
                            {
                                obj.MatrixPoFAP2 = (float)reader.GetDouble(35);
                            }
                            if (!reader.IsDBNull(36))
                            {
                                obj.MatrixPoFAP3 = (float)reader.GetDouble(36);
                            }
                            if (!reader.IsDBNull(37))
                            {
                                obj.RLI = (float)reader.GetDouble(37);
                            }
                            if (!reader.IsDBNull(38))
                            {
                                obj.SemiAP1 = (float)reader.GetDouble(38);
                            }
                            if (!reader.IsDBNull(39))
                            {
                                obj.SemiAP2 = (float)reader.GetDouble(39);
                            }
                            if (!reader.IsDBNull(40))
                            {
                                obj.SemiAP3 = (float)reader.GetDouble(40);
                            }
                            if (!reader.IsDBNull(41))
                            {
                                obj.PoFAP1Category = reader.GetString(41);
                            }
                            if (!reader.IsDBNull(42))
                            {
                                obj.PoFAP2Category = reader.GetString(42);
                            }
                            if (!reader.IsDBNull(43))
                            {
                                obj.PoFAP3Category = reader.GetString(43);
                            }
                            if (!reader.IsDBNull(44))
                            {
                                obj.CoFValue = (float)reader.GetDouble(44);
                            }
                            if (!reader.IsDBNull(45))
                            {
                                obj.CoFCategory = reader.GetString(45);
                            }
                            if (!reader.IsDBNull(46))
                            {
                                obj.CoFMatrixValue = (float)reader.GetDouble(46);
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL !");
            }
            finally
            {
                conn.Close();
            }
            return(obj);
        }
Esempio n. 9
0
        public void add(int ID, DateTime CommissionDate, int AdminUpsetManagement, int ContainsDeadlegs, int CyclicOperation, int HighlyDeadlegInsp, int DowntimeProtectionUsed, String ExternalEnvironment, int HeatTraced, int InterfaceSoilWater, int LinerOnlineMonitoring, int MaterialExposedToClExt, double MinReqTemperaturePressurisation, String OnlineMonitoring, int PresenceSulphidesO2, int PresenceSulphidesO2Shutdown, int PressurisationControlled, int PWHT, int SteamOutWaterFlush, double ManagementFactor, String ThermalHistory, int YearLowestExpTemp, double Volume, String TypeOfSoil, String EnvironmentSensitivity, double DistanceToGroundWater, String AdjustmentSettle, int ComponentIsWelded, int TankIsMaintained)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         " " +
                         "INSERT INTO [dbo].[RW_EQUIPMENT]" +
                         "([ID]" +
                         ",[CommissionDate]" +
                         ",[AdminUpsetManagement]" +
                         ",[ContainsDeadlegs]" +
                         ",[CyclicOperation]" +
                         ",[HighlyDeadlegInsp]" +
                         ",[DowntimeProtectionUsed]" +
                         ",[ExternalEnvironment]" +
                         ",[HeatTraced]" +
                         ",[InterfaceSoilWater]" +
                         ",[LinerOnlineMonitoring]" +
                         ",[MaterialExposedToClExt]" +
                         ",[MinReqTemperaturePressurisation]" +
                         ",[OnlineMonitoring]" +
                         ",[PresenceSulphidesO2]" +
                         ",[PresenceSulphidesO2Shutdown]" +
                         ",[PressurisationControlled]" +
                         ",[PWHT]" +
                         ",[SteamOutWaterFlush]" +
                         ",[ManagementFactor]" +
                         ",[ThermalHistory]" +
                         ",[YearLowestExpTemp]" +
                         ",[Volume]" +
                         ",[TypeOfSoil]" +
                         ",[EnvironmentSensitivity]" +
                         ",[DistanceToGroundWater]" +
                         ",[AdjustmentSettle]" +
                         ",[ComponentIsWelded]" +
                         ",[TankIsMaintained])" +
                         "VALUES" +
                         "('" + ID + "'" +
                         ",'" + CommissionDate + "'" +
                         ",'" + AdminUpsetManagement + "'" +
                         ",'" + ContainsDeadlegs + "'" +
                         ",'" + CyclicOperation + "'" +
                         ",'" + HighlyDeadlegInsp + "'" +
                         ",'" + DowntimeProtectionUsed + "'" +
                         ",'" + ExternalEnvironment + "'" +
                         ",'" + HeatTraced + "'" +
                         ",'" + InterfaceSoilWater + "'" +
                         ",'" + LinerOnlineMonitoring + "'" +
                         ",'" + MaterialExposedToClExt + "'" +
                         ",'" + MinReqTemperaturePressurisation + "'" +
                         ",'" + OnlineMonitoring + "'" +
                         ",'" + PresenceSulphidesO2 + "'" +
                         ",'" + PresenceSulphidesO2Shutdown + "'" +
                         ",'" + PressurisationControlled + "'" +
                         ",'" + PWHT + "'" +
                         ",'" + SteamOutWaterFlush + "'" +
                         ",'" + ManagementFactor + "'" +
                         ",'" + ThermalHistory + "'" +
                         ",'" + YearLowestExpTemp + "'" +
                         ",'" + Volume + "'" +
                         ",'" + TypeOfSoil + "'" +
                         ",'" + EnvironmentSensitivity + "'" +
                         ",'" + DistanceToGroundWater + "'" +
                         ",'" + AdjustmentSettle + "'" +
                         ",'" + ComponentIsWelded + "'" +
                         ",'" + TankIsMaintained + "')" +
                         " ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "ADD FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
Esempio n. 10
0
        // get datasource
        public List <RW_FULL_COF_FLUID> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <RW_FULL_COF_FLUID> list = new List <RW_FULL_COF_FLUID>();
            RW_FULL_COF_FLUID        obj  = null;
            String sql = "Use[rbi] Select[ID]" +
                         ",[Cp]" +
                         ",[k]" +
                         ",[GFFTotal]" +
                         ",[Kv_n]" +
                         ",[ReleasePhase]" +
                         ",[Cd]" +
                         ",[Ptrans]" +
                         ",[NBP]" +
                         ",[Density]" +
                         ",[MW]" +
                         ",[R]" +
                         ",[Ps]" +
                         ",[Ts]" +
                         ",[Patm]" +
                         ",[fact_di]" +
                         ",[fact_mit]" +
                         ",[fact_AIT]" +
                         ",[g]" +
                         ",[h]" +
                         "From [dbo].[RW_FULL_COF_FLUID]  ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj    = new RW_FULL_COF_FLUID();
                            obj.ID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.Cp = reader.GetFloat(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.k = reader.GetFloat(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.GFFTotal = reader.GetFloat(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.Kv_n = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.ReleasePhase = reader.GetString(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.Cd = reader.GetFloat(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.Ptrans = reader.GetFloat(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.NBP = reader.GetFloat(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.Density = reader.GetFloat(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.MW = reader.GetFloat(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.R = reader.GetFloat(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.Ps = reader.GetFloat(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.Ts = reader.GetFloat(13);
                            }
                            if (!reader.IsDBNull(14))
                            {
                                obj.Patm = reader.GetFloat(14);
                            }
                            if (!reader.IsDBNull(15))
                            {
                                obj.fact_di = reader.GetFloat(15);
                            }
                            if (!reader.IsDBNull(16))
                            {
                                obj.fact_mit = reader.GetFloat(16);
                            }
                            if (!reader.IsDBNull(17))
                            {
                                obj.fact_AIT = reader.GetFloat(17);
                            }
                            if (!reader.IsDBNull(18))
                            {
                                obj.g = reader.GetFloat(18);
                            }
                            if (!reader.IsDBNull(19))
                            {
                                obj.h = reader.GetFloat(19);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
Esempio n. 11
0
        public void add(int ID, float ThinningAP1, float ThinningAP2, float ThinningAP3, float SCCAP1, float SCCAP2, float SCCAP3, float ExternalAP1, float ExternalAP2, float ExternalAP3, float BrittleAP1, float BrittleAP2, float BrittleAP3, float HTHA_AP1, float HTHA_AP2, float HTHA_AP3, float FatigueAP1, float FatigueAP2, String FatigueAP3, float FMS, String ThinningType, float GFFTotal, float ThinningLocalAP1, float ThinningLocalAP2, float ThinningLocalAP3, float ThinningGeneralAP1, float ThinningGeneralAP2, float ThinningGeneralAP3, float TotalDFAP1, float TotalDFAP2, float TotalDFAP3, float PoFAP1, float PoFAP2, float PoFAP3, float MatrixPoFAP1, float MatrixPoFAP2, float MatrixPoFAP3, float RLI, float SemiAP1, float SemiAP2, float SemiAP3, String PoFAP1Category, String PoFAP2Category, String PoFAP3Category, float CoFValue, String CoFCategory, float CoFMatrixValue)

        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "INSERT INTO [dbo].[RW_FULL_POF]" +
                         "([ID]" +
                         ",[ThinningAP1]" +
                         ",[ThinningAP2]" +
                         ",[ThinningAP3]" +
                         ",[SCCAP1]" +
                         ",[SCCAP2]" +
                         ",[SCCAP3]" +
                         ",[ExternalAP1]" +
                         ",[ExternalAP2]" +
                         ",[ExternalAP3]" +
                         ",[BrittleAP1]" +
                         ",[BrittleAP2]" +
                         ",[BrittleAP3]" +
                         ",[HTHA_AP1]" +
                         ",[HTHA_AP2]" +
                         ",[HTHA_AP3]" +
                         ",[FatigueAP1]" +
                         ",[FatigueAP2]" +
                         ",[FatigueAP3]" +
                         ",[FMS]" +
                         ",[ThinningType]" +
                         ",[GFFTotal]" +
                         ",[ThinningLocalAP1]" +
                         ",[ThinningLocalAP2]" +
                         ",[ThinningLocalAP3]" +
                         ",[ThinningGeneralAP1]" +
                         ",[ThinningGeneralAP2]" +
                         ",[ThinningGeneralAP3]" +
                         ",[TotalDFAP1]" +
                         ",[TotalDFAP2]" +
                         ",[TotalDFAP3]" +
                         ",[PoFAP1]" +
                         ",[PoFAP2]" +
                         ",[PoFAP3]" +
                         ",[MatrixPoFAP1]" +
                         ",[MatrixPoFAP2]" +
                         ",[MatrixPoFAP3]" +
                         ",[RLI]" +
                         ",[SemiAP1]" +
                         ",[SemiAP2]" +
                         ",[SemiAP3]" +
                         ",[PoFAP1Category]" +
                         ",[PoFAP2Category]" +
                         ",[PoFAP3Category]" +
                         ",[CoFValue]" +
                         ",[CoFCategory]" +
                         ",[CoFMatrixValue])" +
                         " VALUES" +
                         "(  '" + ID + "'" +
                         ", '" + ThinningAP1 + "'" +
                         ",'" + ThinningAP2 + "'" +
                         "," + ThinningAP3 + "" +
                         ", '" + SCCAP1 + "'" +
                         ", '" + SCCAP2 + "'" +
                         ", '" + SCCAP3 + "'" +
                         ", '" + ExternalAP1 + "'" +
                         ", '" + ExternalAP2 + "'" +
                         ", '" + ExternalAP3 + "'" +
                         ", '" + BrittleAP1 + "'" +
                         ",'" + BrittleAP2 + "'" +
                         ", '" + BrittleAP3 + "'" +
                         ", '" + HTHA_AP1 + "'" +
                         ",'" + HTHA_AP2 + "'" +
                         "," + HTHA_AP3 + "" +
                         ", '" + FatigueAP1 + "'" +
                         ", '" + FatigueAP2 + "'" +
                         ", '" + FatigueAP3 + "'" +
                         ", '" + FMS + "'" +
                         ", '" + ThinningType + "'" +
                         ",'" + GFFTotal + "'" +
                         ", '" + ThinningLocalAP1 + "'" +
                         ",'" + ThinningLocalAP2 + "'" +
                         "," + ThinningLocalAP3 + "" +
                         ", '" + ThinningGeneralAP1 + "'" +
                         ", '" + ThinningGeneralAP2 + "'" +
                         ", '" + ThinningGeneralAP3 + "'" +
                         ", '" + TotalDFAP1 + "'" +
                         ", '" + TotalDFAP2 + "'" +
                         ", '" + TotalDFAP3 + "'" +
                         ", '" + PoFAP1 + "'" +
                         ",'" + PoFAP2 + "'" +
                         ", '" + PoFAP3 + "'" +
                         ", '" + MatrixPoFAP1 + "'" +
                         ",'" + MatrixPoFAP2 + "'" +
                         "," + MatrixPoFAP3 + "" +
                         ", '" + RLI + "'" +
                         ", '" + SemiAP1 + "'" +
                         ", '" + SemiAP2 + "'" +
                         ", '" + SemiAP3 + "'" +
                         ", '" + PoFAP1Category + "'" +
                         ",'" + PoFAP2Category + "'" +
                         ", '" + PoFAP3Category + "'" +
                         ", '" + CoFValue + "'" +
                         ", '" + CoFCategory + "'" +
                         ", '" + CoFMatrixValue + "')";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "ADD FAIL!");
            }
            finally
            {
                conn.Close();
            }
        }
Esempio n. 12
0
        public void add(int ID, double Cp, double k, double GFFTotal, double Kv_n, String ReleasePhase, double Cd, double Ptrans, double NBP, double Density, double MW, double R, double Ps, double Ts, double Patm, double fact_di, double fact_mit, double fact_AIT, double g, double h)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         " " +
                         "INSERT INTO [dbo].[RW_FULL_COF_FLUID]" +
                         "([ID]" +
                         ",[Cp]" +
                         ",[k]" +
                         ",[GFFTotal]" +
                         ",[Kv_n]" +
                         ",[ReleasePhase]" +
                         ",[Cd]" +
                         ",[Ptrans]" +
                         ",[NBP]" +
                         ",[Density]" +
                         ",[MW]" +
                         ",[R]" +
                         ",[Ps]" +
                         ",[Ts]" +
                         ",[Patm]" +
                         ",[fact_di]" +
                         ",[fact_mit]" +
                         ",[fact_AIT]" +
                         ",[g]" +
                         ",[h])" +
                         "VALUES" +
                         "('" + ID + "'" +
                         ",'" + Cp + "'" +
                         ",'" + k + "'" +
                         ",'" + GFFTotal + "'" +
                         ",'" + Kv_n + "'" +
                         ",'" + ReleasePhase + "'" +
                         ",'" + Cd + "'" +
                         ",'" + Ptrans + "'" +
                         ",'" + NBP + "'" +
                         ",'" + Density + "'" +
                         ",'" + MW + "'" +
                         ",'" + R + "'" +
                         ",'" + Ps + "'" +
                         ",'" + Ts + "'" +
                         ",'" + Patm + "'" +
                         ",'" + fact_di + "'" +
                         ",'" + fact_mit + "'" +
                         ",'" + fact_AIT + "'" +
                         ",'" + g + "'" +
                         ",'" + h + "')" +
                         " ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "ADD FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
Esempio n. 13
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);
        }
Esempio n. 14
0
        public void add(int ID, float Hydraulic_Water, float Hydraulic_Fluid, float Seepage_Velocity, float Flow_Rate_D1, float Flow_Rate_D2, float Flow_Rate_D3, float Flow_Rate_D4, float Leak_Duration_D1, float Leak_Duration_D2, float Leak_Duration_D3, float Leak_Duration_D4, float Release_Volume_Leak_D1, float Release_Volume_Leak_D2, float Release_Volume_Leak_D3, float Release_Volume_Leak_D4, float Release_Volume_Rupture, float Liquid_Height, float Volume_Fluid, float Time_Leak_Ground, float Volume_SubSoil_Leak_D1, float Volume_SubSoil_Leak_D4, float Volume_Ground_Water_Leak_D1, float Volume_Ground_Water_Leak_D4, float Barrel_Dike_Leak, float Barrel_Dike_Rupture, float Barrel_Onsite_Leak, float Barrel_Onsite_Rupture, float Barrel_Offsite_Leak, float Barrel_Offsite_Rupture, float Barrel_Water_Leak, float Barrel_Water_Rupture, float FC_Environ_Leak, float FC_Environ_Rupture, float FC_Environ, float Material_Factor, float Component_Damage_Cost, float Business_Cost, float Consequence, String ConsequenceCategory)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] " +
                         "INSERT INTO [dbo].[RW_CA_TANK]" +
                         "([ID]" +
                         ",[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])" +
                         " VALUES " +
                         "('" + ID + "'" +
                         ",'" + 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 + "')";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("ADD DATA FAIL!" + ex.ToString(), "ERROR!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
Esempio n. 15
0
        public RW_STREAM getData(int ID)
        {
            RW_STREAM     obj  = new RW_STREAM();
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "" +
                         "SELECT [ID]" +
                         ",[AmineSolution]" +
                         ",[AqueousOperation]" +
                         ",[AqueousShutdown]" +
                         ",[ToxicConstituent]" +
                         ",[Caustic]" +
                         ",[Chloride]" +
                         ",[CO3Concentration]" +
                         ",[Cyanide]" +
                         ",[ExposedToGasAmine]" +
                         ",[ExposedToSulphur]" +
                         ",[ExposureToAmine]" +
                         ",[FlammableFluidID]" +
                         ",[FlowRate]" +
                         ",[H2S]" +
                         ",[H2SInWater]" +
                         ",[Hydrogen]" +
                         ",[H2SPartialPressure]" +
                         ",[Hydrofluoric]" +
                         ",[MaterialExposedToClInt]" +
                         ",[MaxOperatingPressure]" +
                         ",[MaxOperatingTemperature]" +
                         ",[MinOperatingPressure]" +
                         ",[MinOperatingTemperature]" +
                         ",[CriticalExposureTemperature]" +
                         ",[ModelFluidID]" +
                         ",[NaOHConcentration]" +
                         ",[NonFlameToxicFluidID]" +
                         ",[ReleaseFluidPercentToxic]" +
                         ",[StoragePhase]" +
                         ",[ToxicFluidID]" +
                         ",[WaterpH]" +
                         ",[TankFluidName]" +
                         ",[FluidHeight]" +
                         ",[FluidLeaveDikePercent]" +
                         ",[FluidLeaveDikeRemainOnSitePercent]" +
                         ",[FluidGoOffSitePercent]" +
                         "  FROM [rbi].[dbo].[RW_STREAM] 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 = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.AmineSolution = reader.GetString(1);
                            }
                            obj.AqueousOperation = Convert.ToInt32(reader.GetBoolean(2));
                            obj.AqueousShutdown  = Convert.ToInt32(reader.GetBoolean(3));
                            obj.ToxicConstituent = Convert.ToInt32(reader.GetBoolean(4));
                            obj.Caustic          = Convert.ToInt32(reader.GetBoolean(5));
                            if (!reader.IsDBNull(6))
                            {
                                obj.Chloride = (float)reader.GetDouble(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.CO3Concentration = (float)reader.GetDouble(7);
                            }
                            obj.Cyanide           = Convert.ToInt32(reader.GetBoolean(8));
                            obj.ExposedToGasAmine = Convert.ToInt32(reader.GetBoolean(9));
                            obj.ExposedToSulphur  = Convert.ToInt32(reader.GetBoolean(10));
                            if (!reader.IsDBNull(11))
                            {
                                obj.ExposureToAmine = reader.GetString(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.FlammableFluidID = reader.GetInt32(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.FlowRate = (float)reader.GetDouble(13);
                            }
                            obj.H2S = Convert.ToInt32(reader.GetBoolean(14));
                            if (!reader.IsDBNull(15))
                            {
                                obj.H2SInWater = (float)reader.GetDouble(15);
                            }
                            obj.Hydrogen = Convert.ToInt32(reader.GetBoolean(16));
                            if (!reader.IsDBNull(17))
                            {
                                obj.H2SPartialPressure = (float)reader.GetDouble(17);
                            }

                            obj.Hydrofluoric           = Convert.ToInt32(reader.GetBoolean(18));
                            obj.MaterialExposedToClInt = Convert.ToInt32(reader.GetBoolean(19));
                            if (!reader.IsDBNull(20))
                            {
                                obj.MaxOperatingPressure = (float)reader.GetDouble(20);
                            }
                            if (!reader.IsDBNull(21))
                            {
                                obj.MaxOperatingTemperature = (float)reader.GetDouble(21);
                            }
                            if (!reader.IsDBNull(22))
                            {
                                obj.MinOperatingPressure = (float)reader.GetDouble(22);
                            }
                            if (!reader.IsDBNull(23))
                            {
                                obj.MinOperatingTemperature = (float)reader.GetDouble(23);
                            }
                            if (!reader.IsDBNull(24))
                            {
                                obj.CriticalExposureTemperature = (float)reader.GetDouble(24);
                            }
                            if (!reader.IsDBNull(25))
                            {
                                obj.ModelFluidID = reader.GetInt32(25);
                            }

                            if (!reader.IsDBNull(26))
                            {
                                obj.NaOHConcentration = (float)reader.GetDouble(26);
                            }
                            if (!reader.IsDBNull(27))
                            {
                                obj.NonFlameToxicFluidID = reader.GetInt32(27);
                            }
                            if (!reader.IsDBNull(28))
                            {
                                obj.ReleaseFluidPercentToxic = (float)reader.GetDouble(28);
                            }
                            if (!reader.IsDBNull(29))
                            {
                                obj.StoragePhase = reader.GetString(29);
                            }
                            if (!reader.IsDBNull(30))
                            {
                                obj.ToxicFluidID = reader.GetInt32(30);
                            }
                            if (!reader.IsDBNull(31))
                            {
                                obj.WaterpH = (float)reader.GetDouble(31);
                            }
                            if (!reader.IsDBNull(32))
                            {
                                obj.TankFluidName = reader.GetString(32);
                            }
                            if (!reader.IsDBNull(33))
                            {
                                obj.FluidHeight = (float)reader.GetDouble(33);
                            }
                            if (!reader.IsDBNull(34))
                            {
                                obj.FluidLeaveDikePercent = (float)reader.GetDouble(34);
                            }
                            if (!reader.IsDBNull(35))
                            {
                                obj.FluidLeaveDikeRemainOnSitePercent = (float)reader.GetDouble(35);
                            }
                            if (!reader.IsDBNull(36))
                            {
                                obj.FluidGoOffSitePercent = (float)reader.GetDouble(36);
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(obj);
        }
Esempio n. 16
0
        public RW_EQUIPMENT getdata(int ID)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            RW_EQUIPMENT obj = new RW_EQUIPMENT();
            String       sql = "Use[rbi] Select[ID]" +
                               ",[CommissionDate]" +
                               ",[AdminUpsetManagement]" +
                               ",[ContainsDeadlegs]" +
                               ",[CyclicOperation]" +
                               ",[HighlyDeadlegInsp]" +
                               ",[DowntimeProtectionUsed]" +
                               ",[ExternalEnvironment]" +
                               ",[HeatTraced]" +
                               ",[InterfaceSoilWater]" +
                               ",[LinerOnlineMonitoring]" +
                               ",[MaterialExposedToClExt]" +
                               ",[MinReqTemperaturePressurisation]" +
                               ",[OnlineMonitoring]" +
                               ",[PresenceSulphidesO2]" +
                               ",[PresenceSulphidesO2Shutdown]" +
                               ",[PressurisationControlled]" +
                               ",[PWHT]" +
                               ",[SteamOutWaterFlush]" +
                               ",[ManagementFactor]" +
                               ",[ThermalHistory]" +
                               ",[YearLowestExpTemp]" +
                               ",[Volume]" +
                               ",[TypeOfSoil]" +
                               ",[EnvironmentSensitivity]" +
                               ",[DistanceToGroundWater]" +
                               ",[AdjustmentSettle]" +
                               ",[ComponentIsWelded]" +
                               ",[TankIsMaintained]" +
                               "From [dbo].[RW_EQUIPMENT] 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                     = reader.GetInt32(0);
                            obj.CommissionDate         = reader.GetDateTime(1);
                            obj.AdminUpsetManagement   = Convert.ToInt32(reader.GetBoolean(2));
                            obj.ContainsDeadlegs       = Convert.ToInt32(reader.GetBoolean(3));
                            obj.CyclicOperation        = Convert.ToInt32(reader.GetBoolean(4));
                            obj.HighlyDeadlegInsp      = Convert.ToInt32(reader.GetBoolean(5));
                            obj.DowntimeProtectionUsed = Convert.ToInt32(reader.GetBoolean(6));
                            if (!reader.IsDBNull(7))
                            {
                                obj.ExternalEnvironment = reader.GetString(7);
                            }
                            obj.HeatTraced             = Convert.ToInt32(reader.GetBoolean(8));
                            obj.InterfaceSoilWater     = Convert.ToInt32(reader.GetBoolean(9));
                            obj.LinerOnlineMonitoring  = Convert.ToInt32(reader.GetBoolean(10));
                            obj.MaterialExposedToClExt = Convert.ToInt32(reader.GetBoolean(11));
                            if (!reader.IsDBNull(12))
                            {
                                obj.MinReqTemperaturePressurisation = (float)reader.GetDouble(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.OnlineMonitoring = reader.GetString(13);
                            }
                            obj.PresenceSulphidesO2         = Convert.ToInt32(reader.GetBoolean(14));
                            obj.PresenceSulphidesO2Shutdown = Convert.ToInt32(reader.GetBoolean(15));
                            obj.PressurisationControlled    = Convert.ToInt32(reader.GetBoolean(16));
                            obj.PWHT = Convert.ToInt32(reader.GetBoolean(17));
                            obj.SteamOutWaterFlush = Convert.ToInt32(reader.GetBoolean(18));
                            if (!reader.IsDBNull(19))
                            {
                                obj.ManagementFactor = (float)reader.GetDouble(19);
                            }
                            if (!reader.IsDBNull(20))
                            {
                                obj.ThermalHistory = reader.GetString(20);
                            }
                            obj.YearLowestExpTemp = Convert.ToInt32(reader.GetBoolean(21));
                            if (!reader.IsDBNull(22))
                            {
                                obj.Volume = (float)reader.GetDouble(22);
                            }
                            if (!reader.IsDBNull(23))
                            {
                                obj.TypeOfSoil = reader.GetString(23);
                            }
                            if (!reader.IsDBNull(24))
                            {
                                obj.EnvironmentSensitivity = reader.GetString(24);
                            }
                            if (!reader.IsDBNull(25))
                            {
                                obj.DistanceToGroundWater = (float)reader.GetDouble(25);
                            }
                            if (!reader.IsDBNull(26))
                            {
                                obj.AdjustmentSettle = reader.GetString(26);
                            }
                            obj.ComponentIsWelded = Convert.ToInt32(reader.GetBoolean(27));
                            obj.TankIsMaintained  = Convert.ToInt32(reader.GetBoolean(28));
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(obj);
        }
Esempio n. 17
0
        public List <EQUIPMENT_REVISION_INSPECTION> getDataSource()
        {
            List <EQUIPMENT_REVISION_INSPECTION> list = new List <EQUIPMENT_REVISION_INSPECTION>();
            EQUIPMENT_REVISION_INSPECTION        obj  = null;
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE[rbi]" +
                         "SELECT [RevisionID]" +
                         ",[CoverageDetailID]" +
                         ",[ComponentNumber]" +
                         ",[CoverageID]" +
                         ",[DMItemID]" +
                         ",[IMTypeID]" +
                         ",[InspectionDate]" +
                         ",[EffectivenessCode]" +
                         ",[CarriedOut]" +
                         ",[CarriedOutDate]" +
                         "FROM [rbi].[dbo].[EQUIPMENT_REVISION_INSPECTION]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj                   = new EQUIPMENT_REVISION_INSPECTION();
                            obj.RevisionID        = reader.GetInt32(0);
                            obj.CoverageDetailID  = reader.GetInt32(1);
                            obj.ComponentNumber   = reader.GetString(2);
                            obj.CoverageID        = reader.GetInt32(3);
                            obj.DMItemID          = reader.GetInt32(4);
                            obj.IMTypeID          = reader.GetInt32(5);
                            obj.InspectionDate    = reader.GetDateTime(6);
                            obj.EffectivenessCode = reader.GetString(7);
                            obj.CarriedOut        = reader.GetInt32(8);
                            if (!reader.IsDBNull(9))
                            {
                                obj.CarriedOutDate = reader.GetDateTime(9);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
        public List <FILE_FACILITY> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <FILE_FACILITY> list = new List <FILE_FACILITY>();
            FILE_FACILITY        obj  = null;
            String sql = " Use [rbi] Select [FileID]" +
                         ",[FacilityID]" +
                         ",[FileDocName]" +
                         ",[FileType]" +
                         ",[FileDescription]" +
                         ",[OriFileName]" +
                         ",[FileBinary]" +
                         ",[FileSize]" +
                         ",[FileExt]" +
                         ",[DateUploaded]" +
                         "From [dbo].[FILE_FACILITY]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj             = new FILE_FACILITY();
                            obj.FileID      = reader.GetInt32(0);
                            obj.FacilityID  = reader.GetInt32(1);
                            obj.FileDocName = reader.GetString(2);
                            obj.FileType    = reader.GetInt32(3);
                            if (!reader.IsDBNull(4))
                            {
                                obj.FileDescription = reader.GetString(4);
                            }
                            obj.OriFileName  = reader.GetString(5);
                            obj.FileBinary   = (byte[])reader[6];
                            obj.FileSize     = reader.GetString(7);
                            obj.FileExt      = reader.GetString(8);
                            obj.DateUploaded = reader.GetDateTime(9);

                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
Esempio n. 19
0
        public List <EQUIPMENT_REVISION> getDataSource()
        {
            List <EQUIPMENT_REVISION> list = new List <EQUIPMENT_REVISION>();
            EQUIPMENT_REVISION        obj  = null;
            SqlConnection             conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] " +
                         "SELECT [RevisionID]" +
                         ",[EquipmentID]" +
                         ",[RevisionXML]" +
                         ",[RevisionNo]" +
                         ",[IssuedBy]" +
                         ",[IssuedDate]" +
                         ",[ReviewedBy]" +
                         ",[ReviewedDate]" +
                         ",[IsReviewed]" +
                         ",[ApprovedBy]" +
                         ",[ApprovedDate]" +
                         ",[IsApproved]" +
                         ",[EndorsedBy]" +
                         ",[EndorsedDate]" +
                         "FROM [rbi].[dbo].[EQUIPMENT_REVISION]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj             = new EQUIPMENT_REVISION();
                            obj.RevisionID  = reader.GetInt32(0);
                            obj.EquipmentID = reader.GetInt32(1);
                            obj.RevisionXML = reader.GetString(2);
                            obj.RevisionNo  = reader.GetInt32(3);
                            if (!reader.IsDBNull(4))
                            {
                                obj.IssuedBy = reader.GetString(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.IssuedDate = reader.GetDateTime(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.ReviewedBy = reader.GetString(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.ReviewedDate = reader.GetDateTime(7);
                            }
                            obj.IsReviewed = reader.GetInt32(8);
                            if (!reader.IsDBNull(9))
                            {
                                obj.ApprovedBy = reader.GetString(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.ApprovedDate = reader.GetDateTime(10);
                            }
                            obj.IsApproved = reader.GetInt32(11);
                            if (!reader.IsDBNull(12))
                            {
                                obj.EndorsedBy = reader.GetString(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.EndorsedDate = reader.GetDateTime(13);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
Esempio n. 20
0
        public void edit(int EquipmentID, String ObjectField001, String ObjectField002, String ObjectField003, String ObjectField004, String ObjectField005,
                         String ObjectField006, String ObjectField007, String ObjectField008, String ObjectField009, String ObjectField010, String ObjectField011,
                         String ObjectField012, String ObjectField013, String ObjectField014, String ObjectField015, String ObjectField016, String ObjectField017,
                         String ObjectField018, String ObjectField019, String ObjectField020, String ObjectField021, String ObjectField022, String ObjectField023,
                         String ObjectField024, String ObjectField025, String ObjectField026, String ObjectField027, String ObjectField028, String ObjectField029,
                         String ObjectField030, String ObjectField031, String ObjectField032, String ObjectField033, String ObjectField034, String ObjectField035,
                         String ObjectField036, String ObjectField037, String ObjectField038, String ObjectField039, String ObjectField040, String ObjectField041,
                         String ObjectField042, String ObjectField043, String ObjectField044, String ObjectField045, String ObjectField046, String ObjectField047,
                         String ObjectField048, String ObjectField049, String ObjectField050)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         " UPDATE[dbo].[EQUIPMENT_EXTRA_FIELDS]" +
                         "SET[EquipmentID] ='" + EquipmentID + "'" +
                         ",[ObjectField001] = '" + ObjectField001 + "'" +
                         ",[ObjectField002] = '" + ObjectField002 + "'" +
                         ",[ObjectField003] = '" + ObjectField003 + "'" +
                         ",[ObjectField004] = '" + ObjectField004 + "'" +
                         ",[ObjectField005] = '" + ObjectField005 + "'" +
                         ",[ObjectField006] = '" + ObjectField006 + "'" +
                         ",[ObjectField007] = '" + ObjectField008 + "'" +
                         ",[ObjectField009] = '" + ObjectField009 + "'" +
                         ",[ObjectField010] = '" + ObjectField010 + "'" +
                         ",[ObjectField011] = '" + ObjectField011 + "'" +
                         ",[ObjectField012] = '" + ObjectField012 + "'" +
                         ",[ObjectField013] = '" + ObjectField013 + "'" +
                         ",[ObjectField014] = '" + ObjectField014 + "'" +
                         ",[ObjectField015] = '" + ObjectField015 + "'" +
                         ",[ObjectField016] = '" + ObjectField016 + "'" +
                         ",[ObjectField017] = '" + ObjectField017 + "'" +
                         ",[ObjectField018] = '" + ObjectField018 + "'" +
                         ",[ObjectField020] = '" + ObjectField020 + "'" +
                         ",[ObjectField021] = '" + ObjectField021 + "'" +
                         ",[ObjectField022] = '" + ObjectField022 + "'" +
                         ",[ObjectField023] = '" + ObjectField023 + "'" +
                         ",[ObjectField024] = '" + ObjectField024 + "'" +
                         ",[ObjectField025] = '" + ObjectField025 + "'" +
                         ",[ObjectField026] = '" + ObjectField026 + "'" +
                         ",[ObjectField027] = '" + ObjectField027 + "'" +
                         ",[ObjectField028] = '" + ObjectField028 + "'" +
                         ",[ObjectField029] = '" + ObjectField029 + "'" +
                         ",[ObjectField030] = '" + ObjectField030 + "'" +
                         ",[ObjectField031] = '" + ObjectField031 + "'" +
                         ",[ObjectField032] = '" + ObjectField032 + "'" +
                         ",[ObjectField033] = '" + ObjectField033 + "'" +
                         ",[ObjectField034] = '" + ObjectField034 + "'" +
                         ",[ObjectField035] = '" + ObjectField035 + "'" +
                         ",[ObjectField036] = '" + ObjectField036 + "'" +
                         ",[ObjectField037] = '" + ObjectField037 + "'" +
                         ",[ObjectField038] = '" + ObjectField038 + "'" +
                         ",[ObjectField039] = '" + ObjectField039 + "'" +
                         ",[ObjectField040] = '" + ObjectField040 + "'" +
                         ",[ObjectField041] = '" + ObjectField041 + "'" +
                         ",[ObjectField042] = '" + ObjectField042 + "'" +
                         ",[ObjectField043] = '" + ObjectField043 + "'" +
                         ",[ObjectField044] = '" + ObjectField044 + "'" +
                         ",[ObjectField045] = '" + ObjectField045 + "'" +
                         ",[ObjectField046] = '" + ObjectField046 + "'" +
                         ",[ObjectField047] = '" + ObjectField047 + "'" +
                         ",[ObjectField048] = '" + ObjectField048 + "'" +
                         ",[ObjectField049] = '" + ObjectField049 + "'" +
                         ",[ObjectField050] = '" + ObjectField050 + "'" +
                         "WHERE [EquipmentID] ='" + EquipmentID + "'";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "EDIT FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
Esempio n. 21
0
        public void add(int ID, String MaterialName, float DesignPressure, float DesignTemperature, float MinDesignTemperature, float BrittleFractureThickness, float CorrosionAllowance, float SigmaPhase, String SulfurContent, String HeatTreatment, String SteelProductForm, float ReferenceTemperature, String PTAMaterialCode, String HTHAMaterialCode, int IsPTA, int IsHTHA, int Austenitic, int Temper, int CarbonLowAlloy, int NickelBased, int ChromeMoreEqual12, float YieldStrength, float TensileStrength, float CostFactor)

        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "INSERT INTO [dbo].[RW_MATERIAL]" +
                         "([ID]" +
                         ",[MaterialName]" +
                         ",[DesignPressure]" +
                         ",[DesignTemperature]" +
                         ",[MinDesignTemperature]" +
                         ",[BrittleFractureThickness]" +
                         ",[CorrosionAllowance]" +
                         ",[SigmaPhase]" +
                         ",[SulfurContent]" +
                         ",[HeatTreatment]" +
                         ",[SteelProductForm]" +
                         ",[ReferenceTemperature]" +
                         ",[PTAMaterialCode]" +
                         ",[HTHAMaterialCode]" +
                         ",[IsPTA]" +
                         ",[IsHTHA]" +
                         ",[Austenitic]" +
                         ",[Temper]" +
                         ",[CarbonLowAlloy]" +
                         ",[NickelBased]" +
                         ",[ChromeMoreEqual12]" +
                         ",[YieldStrength]" +
                         ",[TensileStrength]" +
                         ",[CostFactor])" +
                         " VALUES" +
                         "(  '" + ID + "'" +
                         ", '" + MaterialName + "'" +
                         ", '" + DesignPressure + "'" +
                         ", '" + DesignTemperature + "'" +
                         ", '" + MinDesignTemperature + "'" +
                         ", '" + BrittleFractureThickness + "'" +
                         ", '" + CorrosionAllowance + "'" +
                         ", '" + SigmaPhase + "'" +
                         ", '" + SulfurContent + "'" +
                         ", '" + HeatTreatment + "'" +
                         ", '" + SteelProductForm + "'" +
                         ", '" + ReferenceTemperature + "'" +
                         ", '" + PTAMaterialCode + "'" +
                         ", '" + HTHAMaterialCode + "'" +
                         ", '" + IsPTA + "'" +
                         ", '" + IsHTHA + "'" +
                         ", '" + Austenitic + "'" +
                         ", '" + Temper + "'" +
                         ", '" + CarbonLowAlloy + "'" +
                         ", '" + NickelBased + "'" +
                         ", '" + ChromeMoreEqual12 + "'" +
                         ", '" + YieldStrength + "'" +
                         ", '" + TensileStrength + "'" +
                         ", '" + CostFactor + "')";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "ADD FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
Esempio n. 22
0
        public List <EQUIPMENT_REVISION_INSPECTION_COVERAGE> getDataSource()
        {
            List <EQUIPMENT_REVISION_INSPECTION_COVERAGE> list = new List <EQUIPMENT_REVISION_INSPECTION_COVERAGE>();
            EQUIPMENT_REVISION_INSPECTION_COVERAGE        obj  = null;
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE[rbi]" +
                         "SELECT [RevisionID]" +
                         ",[CoverageID]" +
                         ",[InspPlanName]" +
                         ",[InspPlanDate]" +
                         ",[CoverageName]" +
                         ",[CoverageDate]" +
                         ",[Remarks]" +
                         ",[Findings]" +
                         ",[FindingRTF]" +
                         "FROM [rbi].[dbo].[EQUIPMENT_REVISION_INSPECTION_COVERAGE]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj              = new EQUIPMENT_REVISION_INSPECTION_COVERAGE();
                            obj.RevisionID   = reader.GetInt32(0);
                            obj.CoverageID   = reader.GetInt32(1);
                            obj.InspPlanName = reader.GetString(2);
                            if (!reader.IsDBNull(3))
                            {
                                obj.InspPlanDate = reader.GetDateTime(3);
                            }
                            obj.CoverageName = reader.GetString(4);
                            if (!reader.IsDBNull(5))
                            {
                                obj.CoverageDate = reader.GetDateTime(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.Remarks = reader.GetString(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.Findings = reader.GetString(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.FindingRTF = reader.GetString(8);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
Esempio n. 23
0
        public RW_MATERIAL getData(int id)
        {
            RW_MATERIAL   obj  = new RW_MATERIAL();
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]  SELECT [ID]" +
                         ",[MaterialName]" +
                         ",[DesignPressure]" +
                         ",[DesignTemperature]" +
                         ",[MinDesignTemperature]" +
                         ",[BrittleFractureThickness]" +
                         ",[CorrosionAllowance]" +
                         ",[SigmaPhase]" +
                         ",[SulfurContent]" +
                         ",[HeatTreatment]" +
                         ",[SteelProductForm]" +
                         ",[ReferenceTemperature]" +
                         ",[PTAMaterialCode]" +
                         ",[HTHAMaterialCode]" +
                         ",[IsPTA]" +
                         ",[IsHTHA]" +
                         ",[Austenitic]" +
                         ",[Temper]" +
                         ",[CarbonLowAlloy]" +
                         ",[NickelBased]" +
                         ",[ChromeMoreEqual12]" +
                         ",[YieldStrength]" +
                         ",[TensileStrength]" +
                         ",[CostFactor]" +
                         "FROM [dbo].[RW_MATERIAL] 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 = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.MaterialName = reader.GetString(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.DesignPressure = (float)reader.GetDouble(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.DesignTemperature = (float)reader.GetDouble(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.MinDesignTemperature = (float)reader.GetDouble(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.BrittleFractureThickness = (float)reader.GetDouble(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.CorrosionAllowance = (float)reader.GetDouble(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.SigmaPhase = (float)reader.GetDouble(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.SulfurContent = reader.GetString(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.HeatTreatment = reader.GetString(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.SteelProductForm = reader.GetString(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.ReferenceTemperature = (float)reader.GetDouble(11);
                            }
                            if (!reader.IsDBNull(12))
                            {
                                obj.PTAMaterialCode = reader.GetString(12);
                            }
                            if (!reader.IsDBNull(13))
                            {
                                obj.HTHAMaterialCode = reader.GetString(13);
                            }
                            obj.IsPTA             = Convert.ToInt32(reader.GetBoolean(14));
                            obj.IsHTHA            = Convert.ToInt32(reader.GetBoolean(15));
                            obj.Austenitic        = Convert.ToInt32(reader.GetBoolean(16));
                            obj.Temper            = Convert.ToInt32(reader.GetBoolean(17));
                            obj.CarbonLowAlloy    = Convert.ToInt32(reader.GetBoolean(18));
                            obj.NickelBased       = Convert.ToInt32(reader.GetBoolean(19));
                            obj.ChromeMoreEqual12 = Convert.ToInt32(reader.GetBoolean(20));
                            if (!reader.IsDBNull(21))
                            {
                                obj.YieldStrength = (float)reader.GetDouble(21);
                            }
                            if (!reader.IsDBNull(22))
                            {
                                obj.TensileStrength = (float)reader.GetDouble(22);
                            }
                            obj.CostFactor = (float)reader.GetDouble(23);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("GET DATA SOURCE FAIL!" + ex.ToString(), "ERROR!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(obj);
        }
        // dung file get data
        // dung file get list( data source)
        public List <RW_LF_MASTER> getDataSource()
        {
            List <RW_LF_MASTER> list = new List <RW_LF_MASTER>();
            RW_LF_MASTER        obj  = null;
            SqlConnection       conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "SELECT [ID]" +
                         ",[LF1Factor]" +
                         ",[LF4Factor]" +
                         ",[LF5Factor]" +
                         ",[LF6Factor]" +
                         ",[LF7Factor]" +
                         ",[LF1]" +
                         ",[LF4]" +
                         ",[LF5]" +
                         ",[LF6]" +
                         ",[LF7]" +
                         "  FROM [rbi].[dbo].[RW_LF_MASTER]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj    = new RW_LF_MASTER();
                            obj.ID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.LF1Factor = reader.GetFloat(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.LF4Factor = reader.GetFloat(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.LF5Factor = reader.GetFloat(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.LF6Factor = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.LF7Factor = reader.GetFloat(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.LF1 = reader.GetFloat(6);
                            }
                            if (!reader.IsDBNull(7))
                            {
                                obj.LF4 = reader.GetFloat(7);
                            }
                            if (!reader.IsDBNull(8))
                            {
                                obj.LF5 = reader.GetFloat(8);
                            }
                            if (!reader.IsDBNull(9))
                            {
                                obj.LF6 = reader.GetFloat(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.LF7 = reader.GetFloat(10);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }
Esempio n. 25
0
        public List <EQUIPMENT_MASTER> getDataSource()
        {
            List <EQUIPMENT_MASTER> list = new List <EQUIPMENT_MASTER>();
            EQUIPMENT_MASTER        obj  = null;
            SqlConnection           conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = " Use [rbi] Select [EquipmentID]" +
                         ",[EquipmentNumber]" +
                         ",[EquipmentTypeID]" +
                         ",[EquipmentName]" +
                         ",[CommissionDate]" +
                         ",[DesignCodeID]" +
                         ",[SiteID]" +
                         ",[FacilityID]" +
                         ",[ManufacturerID]" +
                         ",[PFDNo]" +
                         ",[ProcessDescription]" +
                         ",[EquipmentDesc]" +
                         ",[IsArchived]" +
                         ",[Archived]" +
                         ",[ArchivedBy]" +
                         "From [rbi].[dbo].[EQUIPMENT_MASTER]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj                 = new EQUIPMENT_MASTER();
                            obj.EquipmentID     = reader.GetInt32(0);
                            obj.EquipmentNumber = reader.GetString(1);
                            obj.EquipmentTypeID = reader.GetInt32(2);
                            obj.EquipmentName   = reader.GetString(3);
                            obj.CommissionDate  = reader.GetDateTime(4);
                            obj.DesignCodeID    = reader.GetInt32(5);
                            obj.SiteID          = reader.GetInt32(6);
                            obj.FacilityID      = reader.GetInt32(7);
                            obj.ManufacturerID  = reader.GetInt32(8);
                            if (!reader.IsDBNull(9))
                            {
                                obj.PFDNo = reader.GetString(9);
                            }
                            if (!reader.IsDBNull(10))
                            {
                                obj.ProcessDescription = reader.GetString(10);
                            }
                            if (!reader.IsDBNull(11))
                            {
                                obj.EquipmentDesc = reader.GetString(11);
                            }
                            obj.IsArchived = reader.GetOrdinal("IsArchived");
                            if (!reader.IsDBNull(13))
                            {
                                obj.Archived = reader.GetDateTime(13);
                            }
                            if (!reader.IsDBNull(14))
                            {
                                obj.ArchivedBy = reader.GetString(14);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }
        ///get datasource
        ///
        public List <RW_FULL_COF_INPUT> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <RW_FULL_COF_INPUT> list = new List <RW_FULL_COF_INPUT>();
            RW_FULL_COF_INPUT        obj  = null;
            String sql = " Use[rbi] Select[ID]" +
                         ",[Mitigation]" +
                         ",[DetectionType]" +
                         ",[IsolationType]" +
                         ",[mass_comp]" +
                         ",[mass_inv]" +
                         "From [dbo].[RW_FULL_COF_INPUT]  ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj    = new RW_FULL_COF_INPUT();
                            obj.ID = reader.GetInt32(0);
                            if (!reader.IsDBNull(1))
                            {
                                obj.Mitigation = reader.GetString(1);
                            }
                            if (!reader.IsDBNull(2))
                            {
                                obj.DetectionType = reader.GetString(2);
                            }
                            if (!reader.IsDBNull(3))
                            {
                                obj.IsolationType = reader.GetString(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.mass_comp = reader.GetFloat(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.mass_inv = reader.GetFloat(5);
                            }
                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL");
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }
        public void Add(int ID, String API_FLUID, String SYSTEM, String Release_Duration, String Detection_Type, String Isulation_Type, String Mitigation_System, float Equipment_Cost, float Injure_Cost, float Evironment_Cost, float Toxic_Percent, float Personal_Density, float Material_Cost, float Production_Cost, float Mass_Inventory, float Mass_Component, float Stored_Pressure, float Stored_Temp)
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi] " +
                         "INSERT INTO [dbo].[RW_INPUT_CA_LEVEL1] " +
                         "([ID]" +
                         ",[API_FLUID] " +
                         ",[SYSTEM] " +
                         ",[Release_Duration] " +
                         ",[Detection_Type] " +
                         ",[Isulation_Type] " +
                         ",[Mitigation_System] " +
                         ",[Equipment_Cost] " +
                         ",[Injure_Cost] " +
                         ",[Evironment_Cost] " +
                         ",[Toxic_Percent] " +
                         ",[Personal_Density] " +
                         ",[Material_Cost] " +
                         ",[Production_Cost] " +
                         ",[Mass_Inventory] " +
                         ",[Mass_Component] " +
                         ",[Stored_Pressure] " +
                         ",[Stored_Temp]) " +
                         "VALUES " +
                         "('" + ID + "' " +
                         ",'" + API_FLUID + "' " +
                         ",'" + SYSTEM + "' " +
                         ",'" + Release_Duration + "' " +
                         ",'" + Detection_Type + "' " +
                         ",'" + Isulation_Type + "' " +
                         ",'" + Mitigation_System + "'" +
                         ",'" + Equipment_Cost + "'" +
                         ",'" + Injure_Cost + "'" +
                         ",'" + Evironment_Cost + "'" +
                         ",'" + Toxic_Percent + "'" +
                         ",'" + Personal_Density + "'" +
                         ",'" + Material_Cost + "'" +
                         ",'" + Production_Cost + "'" +
                         ",'" + Mass_Inventory + "'" +
                         ",'" + Mass_Component + "'" +
                         ",'" + Stored_Pressure + "'" +
                         ",'" + Stored_Temp + "') ";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "ERROR!");
            }
            finally
            {
                conn.Close();
            }
        }
Esempio n. 28
0
        public void add(int ID, String AmineSolution, int AqueousOperation, int AqueousShutdown, int ToxicConstituent, int Caustic, float Chloride, float CO3Concentration, int Cyanide, int ExposedToGasAmine, int ExposedToSulphur, String ExposureToAmine, int FlammableFluidID, float FlowRate, int H2S, float H2SInWater, int Hydrogen, float H2SPartialPressure, int Hydrofluoric, int MaterialExposedToClInt, float MaxOperatingPressure, float MaxOperatingTemperature, float MinOperatingPressure, float MinOperatingTemperature, float CriticalExposureTemperature, int ModelFluidID, float NaOHConcentration, int NonFlameToxicFluidID, float ReleaseFluidPercentToxic, String StoragePhase, int ToxicFluidID, float WaterpH, String TankFluidName, float FluidHeight, float FluidLeaveDikePercent, float FluidLeaveDikeRemainOnSitePercent, float FluidGoOffSitePercent
                        )
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "INSERT INTO [dbo].[RW_STREAM]" +
                         "([ID]" +
                         ",[AmineSolution]" +
                         ",[AqueousOperation]" +
                         ",[AqueousShutdown]" +
                         ",[ToxicConstituent]" +
                         ",[Caustic]" +
                         ",[Chloride]" +
                         ",[CO3Concentration]" +
                         ",[Cyanide]" +
                         ",[ExposedToGasAmine]" +
                         ",[ExposedToSulphur]" +
                         ",[ExposureToAmine]" +
                         ",[FlammableFluidID]" +
                         ",[FlowRate]" +
                         ",[H2S]" +
                         ",[H2SInWater]" +
                         ",[Hydrogen]" +
                         ",[H2SPartialPressure]" +
                         ",[Hydrofluoric]" +
                         ",[MaterialExposedToClInt]" +
                         ",[MaxOperatingPressure]" +
                         ",[MaxOperatingTemperature]" +
                         ",[MinOperatingPressure]" +
                         ",[MinOperatingTemperature]" +
                         ",[CriticalExposureTemperature]" +
                         ",[ModelFluidID]" +
                         ",[NaOHConcentration]" +
                         ",[NonFlameToxicFluidID ]" +
                         ",[ReleaseFluidPercentToxic]" +
                         ",[StoragePhase]" +
                         ",[ToxicFluidID]" +
                         ",[WaterpH]" +
                         ",[TankFluidName]" +
                         ",[FluidHeight]" +
                         ",[FluidLeaveDikePercent]" +
                         ",[FluidLeaveDikeRemainOnSitePercent]" +
                         ",[FluidGoOffSitePercent])" +
                         " VALUES" +
                         "(  '" + ID + "'" +
                         ", '" + AmineSolution + "'" +
                         ", '" + AqueousOperation + "'" +
                         ", '" + AqueousShutdown + "'" +
                         ", '" + ToxicConstituent + "'" +
                         ", '" + Caustic + "'" +
                         ", '" + Chloride + "'" +
                         ", '" + CO3Concentration + "'" +
                         ", '" + Cyanide + "'" +
                         ", '" + ExposedToGasAmine + "'" +
                         ", '" + ExposedToSulphur + "'" +
                         ", '" + ExposureToAmine + "'" +
                         ", '" + FlammableFluidID + "'" +
                         ", '" + FlowRate + "'" +
                         ", '" + H2S + "'" +
                         ", '" + H2SInWater + "'" +
                         ", '" + Hydrogen + "'" +
                         ", '" + H2SPartialPressure + "'" +
                         ", '" + Hydrofluoric + "'" +
                         ", '" + MaterialExposedToClInt + "'" +
                         ", '" + MaxOperatingPressure + "'" +
                         ", '" + MaxOperatingTemperature + "'" +
                         ", '" + MinOperatingPressure + "'" +
                         ", '" + MinOperatingTemperature + "'" +
                         ", '" + CriticalExposureTemperature + "'" +
                         ", '" + ModelFluidID + "'" +
                         ", '" + NaOHConcentration + "'" +
                         ", '" + NonFlameToxicFluidID + "'" +
                         ", '" + ReleaseFluidPercentToxic + "'" +
                         ", '" + StoragePhase + "'" +
                         ", '" + ToxicFluidID + "'" +
                         ", '" + WaterpH + "'" +
                         ", '" + TankFluidName + "'" +
                         ", '" + FluidHeight + "'" +
                         ", '" + FluidLeaveDikePercent + "'" +
                         ", '" + FluidLeaveDikeRemainOnSitePercent + "'" +
                         ", '" + FluidGoOffSitePercent + "')";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "ADD FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
        public List <API_COMPONENT_TYPE> getDataSource()
        {
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            List <API_COMPONENT_TYPE> list = new List <API_COMPONENT_TYPE>();
            API_COMPONENT_TYPE        obj  = null;
            String sql = " Use [rbi] Select [APIComponentTypeID]" +
                         ",[APIComponentTypeName]" +
                         ",[GFFSmall]" +
                         ",[GFFMedium]" +
                         ",[GFFLarge]" +
                         ",[GFFRupture]" +
                         ",[GFFTotal]" +
                         ",[HoleCostSmall]" +
                         ",[HoleCostMedium]" +
                         ",[HoleCostLarge]" +
                         ",[HoleCostRupture]" +
                         ",[OutageSmall]" +
                         ",[OutageMedium]" +
                         ",[OutageLarge]" +
                         ",[OutageRupture]" +
                         "From [dbo].[API_COMPONENT_TYPE]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj = new API_COMPONENT_TYPE();
                            obj.APIComponentTypeID   = reader.GetInt32(0);
                            obj.APIComponentTypeName = reader.GetString(1);
                            obj.GFFSmall             = (float)reader.GetDouble(2);
                            obj.GFFMedium            = (float)reader.GetDouble(3);
                            obj.GFFLarge             = (float)reader.GetDouble(4);
                            obj.GFFRupture           = (float)reader.GetDouble(5);
                            obj.GFFTotal             = (float)reader.GetDouble(6);
                            obj.HoleCostSmall        = (float)reader.GetDouble(7);
                            obj.HoleCostMedium       = (float)reader.GetDouble(8);
                            obj.HoleCostLarge        = (float)reader.GetDouble(9);
                            obj.HoleCostRupture      = (float)reader.GetDouble(10);
                            obj.OutageSmall          = (float)reader.GetDouble(11);
                            obj.OutageMedium         = (float)reader.GetDouble(12);
                            obj.OutageLarge          = (float)reader.GetDouble(13);
                            obj.OutageRupture        = (float)reader.GetDouble(14);
                            list.Add(obj);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "GET DATA FAIL!");
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }
Esempio n. 30
0
        // dung file get data
        // dung file get list( data source)
        public List <USER_PERMISSION_LIST> getDataSource()
        {
            List <USER_PERMISSION_LIST> list = new List <USER_PERMISSION_LIST>();
            USER_PERMISSION_LIST        obj  = null;
            SqlConnection conn = MSSQLDBUtils.GetDBConnection();

            conn.Open();
            String sql = "USE [rbi]" +
                         "SELECT [PermissionID]" +
                         ",[Category]" +
                         ",[Permission]" +
                         ",[Container]" +
                         ",[Object]" +
                         ",[ObjectType]" +
                         ",[Action]" +
                         ",[Active]" +
                         ",[SortOrder]" +
                         "  FROM [rbi].[dbo].[USER_PERMISSION_LIST]";

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        if (reader.HasRows)
                        {
                            obj = new USER_PERMISSION_LIST();
                            obj.PermissionID = reader.GetInt32(0);
                            obj.Category     = reader.GetString(1);
                            obj.Permission   = reader.GetString(2);
                            if (!reader.IsDBNull(3))
                            {
                                obj.Container = reader.GetString(3);
                            }
                            if (!reader.IsDBNull(4))
                            {
                                obj.Object = reader.GetString(4);
                            }
                            if (!reader.IsDBNull(5))
                            {
                                obj.ObjectType = reader.GetString(5);
                            }
                            if (!reader.IsDBNull(6))
                            {
                                obj.Action = reader.GetString(6);
                            }
                            obj.Active    = reader.GetInt32(7);
                            obj.SortOrder = reader.GetInt32(8);
                            list.Add(obj);
                        }
                    }
                }
            }
            catch
            {
                MessageBox.Show("GET DATA SOURCE FAIL!");
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
            return(list);
        }