/// <summary> /// Устанавливает список элементов /// </summary> public void SetItems(ref TVariantNamedList self, TVariantNamed.TVariantNamed [] items, OracleConnection con) { using (OracleCommand cmd = new OracleCommand("T_VARIANT_NAMED_LIST.SET_ITEMS", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.BindByName = true; OracleParameter pSelf = new OracleParameter("self", OracleDbType.Object, ParameterDirection.InputOutput) { UdtTypeName = "PUBLIC.T_VARIANT_NAMED_LIST", Value = self }; OracleParameter pItems = new OracleParameter("pItems", OracleDbType.Array, ParameterDirection.Input) { UdtTypeName = "PUBLIC.T_VARIANT_NAMED_TABLE", Size = items.Length, Value = items }; cmd.Parameters.AddRange(new [] { pSelf, pItems }); cmd.ExecuteNonQuery(); self = pSelf.Value as TVariantNamedList; } }
public static TVariantNamedList Create(OracleConnection con, TVariantNamed.TVariantNamed[] items) { var obj = new TVariantNamedList(); obj.SetItems(ref obj, items, con); return(obj); }
public IOracleCustomType CreateObject() { return(TVariantNamedList.Create()); }