HYTOS

        public static bool CheckFluidCode(string value, out string code)

        {

            bool bResult = false;

            code = "";

            DBInformation dbInfo = DBInformation.GetInstance();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT CODELIST_INDEX FROM {0}.CODELISTS WHERE CODELIST_NUMBER = 19 AND CODELIST_TEXT = '{1}'", dbInfo.PlantPIDDic, value);

                                using (OracleDataReader reader = cmd.ExecuteReader())

                                {

                                    while (reader.Read())

                                    {

                                        code = reader["CODELIST_INDEX"].ToString();

                                        bResult = true;

                                        break;

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return bResult;

        }