/// <summary> /// Builds a DocumentoList from IList<!--<Documento>--> and retrieve DocumentoInfo Childs from DB /// </summary> /// <param name="list"></param> /// <returns>DocumentoList</returns> public static DocumentoList GetChildList(IList <Documento> list) { DocumentoList flist = new DocumentoList(); if (list != null) { int sessionCode = Documento.OpenSession(); CriteriaEx criteria = null; flist.IsReadOnly = false; foreach (Documento item in list) { criteria = AgenteDocumento.GetCriteria(sessionCode); criteria.AddEq("OidDocumento", item.Oid); criteria.AddOrder("Codigo", true); item.AgenteDocumentos = AgenteDocumentos.GetChildList(criteria.List <AgenteDocumento>()); flist.Add(item.GetInfo()); } flist.IsReadOnly = true; Documento.CloseSession(sessionCode); } return(flist); }
/// <summary> /// Builds a PuertoList from IList<!--<Puerto>--> and retrieve PuertoInfo Childs from DB /// </summary> /// <param name="list"></param> /// <returns>PuertoList</returns> public static PuertoList GetChildList(IList <Puerto> list) { PuertoList flist = new PuertoList(); if (list != null) { int sessionCode = Puerto.OpenSession(); CriteriaEx criteria = null; flist.IsReadOnly = false; foreach (Puerto item in list) { criteria = PuertoDespachante.GetCriteria(sessionCode); criteria.AddEq("OidPuerto", item.Oid); criteria.AddOrder("Codigo", true); item.PuertoDespachantes = PuertoDespachantes.GetChildList(criteria.List <PuertoDespachante>()); flist.AddItem(item.GetInfo()); } flist.IsReadOnly = true; Puerto.CloseSession(sessionCode); } return(flist); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>VariableList</returns> public static ApplicationSettingList GetList() { CriteriaEx criteria = ApplicationSetting.GetCriteria(ApplicationSetting.OpenSession()); criteria.AddOrder("Name", true); //No criteria. Retrieve all de List ApplicationSettingList list = DataPortal.Fetch <ApplicationSettingList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static Familias GetList() { CriteriaEx criteria = Familia.GetCriteria(Familia.OpenSession()); if (nHManager.Instance.UseDirectSQL) { criteria.Query = Familias.SELECT(); } else { criteria.AddOrder("Identificador", true); } Familia.BeginTransaction(criteria.SessionCode); //No criteria. Retrieve all de List return(DataPortal.Fetch <Familias>(criteria)); }
private void Fetch(RevisionMaterial source) { try { SessionCode = source.SessionCode; _base.CopyValues(source); CriteriaEx criteria = Material_Plan.GetCriteria(Session()); criteria.AddEq("OidRevision", this.Oid); criteria.AddOrder("Fecha", true); _materiales = Material_Plans.GetChildList(criteria.List <Material_Plan>()); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }