示例#1
0
        }//list



        internal InnerComponentExposed retrieve(int id_abstract, string id_inner_container, string id_inner_rename)
        {
            InnerComponentExposed ice = null ;
            IDbConnection dbcon = Connector.DBcon;
            IDbCommand dbcmd = dbcon.CreateCommand();
            string sql =
                "SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
                "FROM innercomponentexposed " +
                "WHERE id_abstract=" + id_abstract + " AND " +
                      "id_inner_rename like '" + id_inner_rename + "' AND " +
                      "id_inner_owner like '" + id_inner_container + "'";
            dbcmd.CommandText = sql;
            IDataReader reader = dbcmd.ExecuteReader();
            if (reader.Read())
            {
                ice = new InnerComponentExposed();
                ice.Id_abstract = (int)reader["id_abstract"];
                ice.Id_inner_rename = (string)reader["id_inner_rename"];
                ice.Id_inner_owner = (string)reader["id_inner_owner"];
                ice.Id_inner = (string)reader["id_inner"];
            }//while
            // clean up
            reader.Close();
            reader = null;
            dbcmd.Dispose();
            dbcmd = null;

            return ice;
        }
示例#2
0
        }//list

        public IList<InnerComponentExposed> listOwnerOfExposedInner(int id_abstract, string id_inner_rename)
        {

            IList<InnerComponentExposed> list = new List<InnerComponentExposed>();
            IDbConnection dbcon = Connector.DBcon;
            IDbCommand dbcmd = dbcon.CreateCommand();
            string sql =
                "SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
                "FROM innercomponentexposed  " +
                "WHERE id_abstract=" + id_abstract + " AND " +
                "id_inner_rename like '" + id_inner_rename + "'";
            dbcmd.CommandText = sql;
            IDataReader reader = dbcmd.ExecuteReader();
			Console.WriteLine ("listOwnerOfExposedInner: " + sql);
            while (reader.Read())
            {
                InnerComponentExposed ic = new InnerComponentExposed();
                ic.Id_abstract = (int)reader["id_abstract"];
                ic.Id_inner_rename = (string)reader["id_inner_rename"];
                ic.Id_inner_owner = (string)reader["id_inner_owner"];
                ic.Id_inner = (string)reader["id_inner"];
                list.Add(ic);
            }//while
            // clean up
            reader.Close();
            reader = null;
            dbcmd.Dispose();
            dbcmd = null;
            return list;

        }//list
示例#3
0
        public void insert(InnerComponentExposed ac)
        {
            String sql =
                "INSERT INTO innercomponentexposed (id_abstract, id_inner_rename, id_inner_owner, id_inner)" +
                " VALUES (" + ac.Id_abstract + ",'" + ac.Id_inner_rename + "','" + ac.Id_inner_owner + "','" + ac.Id_inner + "')";

		    Console.WriteLine("InnerComponentExposedDAO.cs: TRY INSERT PUBLIC INNER COMPONENT :" + sql);
			
            Connector.performSQLUpdate(sql);
        }
示例#4
0
		internal IList<InnerComponentExposed> retrieveContainerList(int id_abstract_start, string id_inner_owner, string id_inner)
		{
			int id_abstract = id_abstract_start;
			IList<InnerComponentExposed> iceList = new List<InnerComponentExposed>();
            InnerComponentExposed ice = null;

			while (id_abstract > 0)
			{
				IDbConnection dbcon = Connector.DBcon;
				IDbCommand dbcmd = dbcon.CreateCommand();
				string sql =
					"SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
					"FROM innercomponentexposed " +
					"WHERE id_abstract=" + id_abstract + " AND " +
						  "id_inner like '" + id_inner + "' AND " +
						  "id_inner_owner like '" + id_inner_owner + "'";
				Console.WriteLine("retrieveContainer: " + sql);
				dbcmd.CommandText = sql;
				IDataReader reader = dbcmd.ExecuteReader();
				while (reader.Read())
				{
					ice = new InnerComponentExposed();
					ice.Id_abstract = (int)reader["id_abstract"];
					ice.Id_inner_rename = (string)reader["id_inner_rename"];
					ice.Id_inner_owner = (string)reader["id_inner_owner"];
					ice.Id_inner = (string)reader["id_inner"];
                    iceList.Add(ice);
				}//while
				 // clean up
				reader.Close();
				reader = null;
				dbcmd.Dispose();
				dbcmd = null;

				if (ice == null)
				{
					AbstractComponentFunctor acf = br.ufc.pargo.hpe.backend.DGAC.BackEnd.acfdao.retrieve(id_abstract);
					if (acf.Id_functor_app_supertype > 0)
					{
						AbstractComponentFunctorApplication acfa = br.ufc.pargo.hpe.backend.DGAC.BackEnd.acfadao.retrieve(acf.Id_functor_app_supertype);
						id_abstract = acfa.Id_abstract;
					}
					else
						id_abstract = -1;
				}
				else
					id_abstract = -1;
			}

			return iceList;
		}