/// <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());
}
