///<summary> /// This method builds the SQL statment to delete the instance in database ///</summary> ///<param name = instance> ///This parameter represents the instance to be deleted in the database ///</param> public override void UpdateDeleted(ONInstance instance) { PasajeroInstance lInstance = instance as PasajeroInstance; ONSqlDelete lOnSql = new ONSqlDelete(); lOnSql.AddFrom(CtesBD.TBL_PASAJERO); lOnSql.AddWhere(CtesBD.FLD_PASAJERO_ID_PASAJERO, lInstance.Oid.Id_PasajeroAttr); Execute(lOnSql); }
///<summary> /// This method builds the SQL statment to delete the instance in database ///</summary> ///<param name = instance> ///This parameter represents the instance to be deleted in the database ///</param> public override void UpdateDeleted(ONInstance instance) { AdministradorInstance lInstance = instance as AdministradorInstance; ONSqlDelete lOnSql = new ONSqlDelete(); lOnSql.AddFrom(CtesBD.TBL_ADMINISTRADOR); lOnSql.AddWhere(CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR, lInstance.Oid.Id_AdministradorAttr); Execute(lOnSql); }
///<summary> /// This method builds the SQL statment to delete the instance in database ///</summary> ///<param name = instance> ///This parameter represents the instance to be deleted in the database ///</param> public override void UpdateDeleted(ONInstance instance) { NaveNodrizaInstance lInstance = instance as NaveNodrizaInstance; ONSqlDelete lOnSql = new ONSqlDelete(); lOnSql.AddFrom(CtesBD.TBL_NAVENODRIZA); lOnSql.AddWhere(CtesBD.FLD_NAVENODRIZA_ID_NAVENODRIZA, lInstance.Oid.Id_NaveNodrizaAttr); Execute(lOnSql); }
///<summary> /// This method builds the SQL statment to delete the instance in database ///</summary> ///<param name = instance> ///This parameter represents the instance to be deleted in the database ///</param> public override void UpdateDeleted(ONInstance instance) { RevisionInstance lInstance = instance as RevisionInstance; ONSqlDelete lOnSql = new ONSqlDelete(); lOnSql.AddFrom(CtesBD.TBL_REVISION); lOnSql.AddWhere(CtesBD.FLD_REVISION_ID_REVISARAERONAVE, lInstance.Oid.Id_RevisarAeronaveAttr); Execute(lOnSql); }
public void LoadRelated(ONContext onContext, ONDisplaySet displaySet, object[] columns, int index, ONInstance instance) { // Related attributes for (; index < displaySet.ElementsInData; index++) { ONDisplaySetItem lDSItem = displaySet[index]; string lTypeName = ONInstance.GetTypeOfAttribute(instance.GetType(), new ONPath(lDSItem.Path)); instance.RelatedValues.Add(lDSItem.Path, ONDBData.GetBasicTypeFromDB(lTypeName, columns[index])); } }
/// <summary> /// Makes the memory checks /// </summary> /// <param name="instances">Instance to check</param> /// <returns>if the instance check all the filters</returns> public bool FilterInMemory(ONInstance instances) { foreach (ONFilter lOnFilter in Values) { if (!lOnFilter.FilterInMemory(instances)) { return(false); } } return(true); }
/// <summary>This method builds the SQL statement to insert the instance in database</summary> /// <param name="instance">This parameter represents the instance to be inserted in the database</param> public override void UpdateAdded(ONInstance instance) { NaveNodrizaInstance lInstance = instance as NaveNodrizaInstance; ONSqlInsert lOnSql = new ONSqlInsert(); lOnSql.AddInto(CtesBD.TBL_NAVENODRIZA); // Field 'id_NaveNodriza' lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_ID_NAVENODRIZA, lInstance.Oid.Id_NaveNodrizaAttr); lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_ESTADOOBJ, lInstance.StateObj); lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_FUM, new ONDateTime(DateTime.Now)); // Field 'Nombre_NaveNodriza' lOnSql.AddValue(CtesBD.FLD_NAVENODRIZA_NOMBRE_NAVENODRIZA, lInstance.Nombre_NaveNodrizaAttr); Execute(lOnSql); }
public Dictionary <ONOid, ONInstance> CopyInstances(object[] ActualValues) { Dictionary <ONOid, ONInstance> AntValues = new Dictionary <ONOid, ONInstance>(); foreach (ONInstance lInstance in ActualValues) { if ((lInstance != null) && (!AntValues.ContainsKey(lInstance.Oid))) { ONInstance lCopyInstance = ONContext.GetComponent_Instance(lInstance.ClassName, OnContext); lCopyInstance.Copy(lInstance); AntValues.Add(lCopyInstance.Oid, lCopyInstance); } } return(AntValues); }
/// <summary>This method builds the SQL statement to insert the instance in database</summary> /// <param name="instance">This parameter represents the instance to be inserted in the database</param> public override void UpdateAdded(ONInstance instance) { PasajeroInstance lInstance = instance as PasajeroInstance; ONSqlInsert lOnSql = new ONSqlInsert(); lOnSql.AddInto(CtesBD.TBL_PASAJERO); // Field 'id_Pasajero' lOnSql.AddValue(CtesBD.FLD_PASAJERO_ID_PASAJERO, lInstance.Oid.Id_PasajeroAttr); lOnSql.AddValue(CtesBD.FLD_PASAJERO_ESTADOOBJ, lInstance.StateObj); lOnSql.AddValue(CtesBD.FLD_PASAJERO_FUM, new ONDateTime(DateTime.Now)); // Field 'Nombre' lOnSql.AddValue(CtesBD.FLD_PASAJERO_NOMBRE, lInstance.NombreAttr); Execute(lOnSql); }
/// <summary>This method builds the SQL statement to insert the instance in database</summary> /// <param name="instance">This parameter represents the instance to be inserted in the database</param> public override void UpdateAdded(ONInstance instance) { AdministradorInstance lInstance = instance as AdministradorInstance; ONSqlInsert lOnSql = new ONSqlInsert(); lOnSql.AddInto(CtesBD.TBL_ADMINISTRADOR); // Field 'id_Administrador' lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR, lInstance.Oid.Id_AdministradorAttr); // Field 'PassWord' lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_PASSWORD, lInstance.PassWordAttr); lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ, lInstance.StateObj); lOnSql.AddValue(CtesBD.FLD_ADMINISTRADOR_FUM, new ONDateTime(DateTime.Now)); Execute(lOnSql); }
public override bool FilterInMemory(ONInstance instance) { if (!InMemory) { return(true); } #region Horizontal visibility for agent 'Administrador' if (instance.OnContext.LeafActiveAgentFacets.Contains("Administrador")) { return(true); } #endregion Horizontal visibility for agent 'Administrador' return(false); }
/// <summary>This method builds the SQL statement to insert the instance in database</summary> /// <param name="instance">This parameter represents the instance to be inserted in the database</param> public override void UpdateAdded(ONInstance instance) { RevisionInstance lInstance = instance as RevisionInstance; ONSqlInsert lOnSql = new ONSqlInsert(); lOnSql.AddInto(CtesBD.TBL_REVISION); // Field 'id_RevisarAeronave' lOnSql.AddValue(CtesBD.FLD_REVISION_ID_REVISARAERONAVE, lInstance.Oid.Id_RevisarAeronaveAttr); lOnSql.AddValue(CtesBD.FLD_REVISION_ESTADOOBJ, lInstance.StateObj); lOnSql.AddValue(CtesBD.FLD_REVISION_FUM, new ONDateTime(DateTime.Now)); // Field 'NombreRevisor' lOnSql.AddValue(CtesBD.FLD_REVISION_NOMBREREVISOR, lInstance.NombreRevisorAttr); // Field 'FechaRevision' lOnSql.AddValue(CtesBD.FLD_REVISION_FECHAREVISION, lInstance.FechaRevisionAttr); // Field 'Id_Aeronave' lOnSql.AddValue(CtesBD.FLD_REVISION_ID_AERONAVE, lInstance.Id_AeronaveAttr); Execute(lOnSql); }
/// <summary>This method builds the SQL statement to edit the instance in database</summary> /// <param name="instance">This parameter represents the instance to be modified in the database</param> public override void UpdateEdited(ONInstance instance) { NaveNodrizaInstance lInstance = instance as NaveNodrizaInstance; ONSqlUpdate lOnSql = new ONSqlUpdate(); lOnSql.AddUpdate(CtesBD.TBL_NAVENODRIZA); // Field 'id_NaveNodriza' // Update not needed (OID) lOnSql.AddSet(CtesBD.FLD_NAVENODRIZA_ESTADOOBJ, lInstance.StateObj); lOnSql.AddSet(CtesBD.FLD_NAVENODRIZA_FUM, new ONDateTime(DateTime.Now)); // Field 'Nombre_NaveNodriza' if (lInstance.Nombre_NaveNodrizaAttrModified) { lOnSql.AddSet(CtesBD.FLD_NAVENODRIZA_NOMBRE_NAVENODRIZA, lInstance.Nombre_NaveNodrizaAttr); } lOnSql.AddWhere(CtesBD.FLD_NAVENODRIZA_ID_NAVENODRIZA, lInstance.Oid.Id_NaveNodrizaAttr); Execute(lOnSql); }
/// <summary> /// This method recovers an instance with the OID /// </summary> /// <param name="onContext">Recovers the context of the execution of the service</param> /// <param name="linkedTo">List to reach the class to retrieve the related instance</param> /// <param name="comparer">Order Criteria that must be followed</param> /// <param name="${startRowOid}">OID frontier</param> /// <param name="blockSize">Number of instances to be returned</param> /// <returns>The instance</returns> public override ONCollection FilterInLegacy(ONContext onContext, ONLinkedToList linkedTo, ONOrderCriteria comparer, ONOid startRowOID, int blockSize) { if (InData) { return(null); } // Add parameters object[] lParameters = new object[2]; lParameters[0] = onContext; lParameters[1] = mOid; ONCollection lCollection = ONContext.GetComponent_Collection(mOid.ClassName, onContext); ONInstance lInstance = ONContext.InvoqueMethod(ONContext.GetType_LV(mOid.ClassName), "QueryByOid", lParameters) as ONInstance; if (lInstance != null) { lCollection.Add(lInstance); } return(lCollection); }
/// <summary>This method builds the SQL statement to edit the instance in database</summary> /// <param name="instance">This parameter represents the instance to be modified in the database</param> public override void UpdateEdited(ONInstance instance) { PasajeroInstance lInstance = instance as PasajeroInstance; ONSqlUpdate lOnSql = new ONSqlUpdate(); lOnSql.AddUpdate(CtesBD.TBL_PASAJERO); // Field 'id_Pasajero' // Update not needed (OID) lOnSql.AddSet(CtesBD.FLD_PASAJERO_ESTADOOBJ, lInstance.StateObj); lOnSql.AddSet(CtesBD.FLD_PASAJERO_FUM, new ONDateTime(DateTime.Now)); // Field 'Nombre' if (lInstance.NombreAttrModified) { lOnSql.AddSet(CtesBD.FLD_PASAJERO_NOMBRE, lInstance.NombreAttr); } lOnSql.AddWhere(CtesBD.FLD_PASAJERO_ID_PASAJERO, lInstance.Oid.Id_PasajeroAttr); Execute(lOnSql); }
/// <summary>This method builds the SQL statement to edit the instance in database</summary> /// <param name="instance">This parameter represents the instance to be modified in the database</param> public override void UpdateEdited(ONInstance instance) { AdministradorInstance lInstance = instance as AdministradorInstance; ONSqlUpdate lOnSql = new ONSqlUpdate(); lOnSql.AddUpdate(CtesBD.TBL_ADMINISTRADOR); // Field 'id_Administrador' // Update not needed (OID) // Field 'PassWord' if (lInstance.PassWordAttrModified) { lOnSql.AddSet(CtesBD.FLD_ADMINISTRADOR_PASSWORD, lInstance.PassWordAttr); } lOnSql.AddSet(CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ, lInstance.StateObj); lOnSql.AddSet(CtesBD.FLD_ADMINISTRADOR_FUM, new ONDateTime(DateTime.Now)); lOnSql.AddWhere(CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR, lInstance.Oid.Id_AdministradorAttr); Execute(lOnSql); }
/// <summary>This method builds the SQL statement to insert the instance in database</summary> /// <param name="instance">This parameter represents the instance to be inserted in the database</param> public override void UpdateAdded(ONInstance instance) { AeronaveInstance lInstance = instance as AeronaveInstance; ONSqlInsert lOnSql = new ONSqlInsert(); lOnSql.AddInto(CtesBD.TBL_AERONAVE); // Field 'id_Aeronave' lOnSql.AddValue(CtesBD.FLD_AERONAVE_ID_AERONAVE, lInstance.Oid.Id_AeronaveAttr); lOnSql.AddValue(CtesBD.FLD_AERONAVE_ESTADOOBJ, lInstance.StateObj); lOnSql.AddValue(CtesBD.FLD_AERONAVE_FUM, new ONDateTime(DateTime.Now)); // Field 'Nombre' lOnSql.AddValue(CtesBD.FLD_AERONAVE_NOMBRE, lInstance.NombreAttr); // Field 'MaximoPasajeros' lOnSql.AddValue(CtesBD.FLD_AERONAVE_MAXIMOPASAJEROS, lInstance.MaximoPasajerosAttr); // Field 'Origen' lOnSql.AddValue(CtesBD.FLD_AERONAVE_ORIGEN, lInstance.OrigenAttr); // Field 'Destino' lOnSql.AddValue(CtesBD.FLD_AERONAVE_DESTINO, lInstance.DestinoAttr); Execute(lOnSql); }
/// <summary> /// Throws the triggers that has been accepted /// </summary> public void ThrowAcceptedTriggers() { List <ONTrigger> lAcceptedTriggers = AcceptedTriggers; AcceptedTriggers = new List <ONTrigger>(); foreach (ONTrigger lOnTrigger in lAcceptedTriggers) { try { object[] lParameters = new object[lOnTrigger.InputParameters.Count + lOnTrigger.OutputParameters.Count]; int i = 0; ONInstance lThis = null; foreach (DictionaryEntry lDictionaryEntry in lOnTrigger.InputParameters) { lParameters[i++] = lDictionaryEntry.Value; if (string.Compare((lDictionaryEntry.Key as string), lOnTrigger.ArgumentThisName, true) == 0) { lThis = (lDictionaryEntry.Value as ONOid).GetInstance(this); } } foreach (DictionaryEntry lDictionaryEntry in lOnTrigger.OutputParameters) { lParameters[i++] = lDictionaryEntry.Value; } ONServiceContext lContext = new ONServiceContext(); lContext.OidAgent = OidAgent; ONServer lComponent = ONContext.GetComponent_Server(lOnTrigger.ClassName, this, lThis); ONContext.InvoqueMethod(lComponent, typeof(ONServiceAttribute), "<Class>" + lOnTrigger.ClassName + "</Class><Service>" + lOnTrigger.ServiceName + "</Service>", lParameters); } catch {} } }
public ONInstance LocalSearch(ONInstance instance) { ONSqlSelect onSql = new ONSqlSelect(); // Create select and first table InhRetrieveInstances(onSql, null, null, OnContext); // Fix instance InhFixInstance(onSql, null, null, instance.Oid); // Execute ONCollection lCollection = ExecuteQuery(onSql, instance); if (lCollection.Count > 0) { return(lCollection[0]); } else { return(null); } }
/// <summary> /// Fix related instance /// </summary> /// <param name="onSql">Sentence SQL to be executed</param> /// <param name="linkedTo">List to reach the class to retrieve the related instance</param> protected bool AddLinkedTo(ONSqlSelect onSql, ONLinkedToList linkedTo) { // Fix related instance foreach (KeyValuePair <ONPath, ONOid> lDictionaryEntry in linkedTo) { ONPath lPath = lDictionaryEntry.Key as ONPath; ONOid lOID = lDictionaryEntry.Value as ONOid; string lAliasRelated = InhAddPath(onSql, lOID.ClassName, lPath, "", true); // Check Visibility if (!ONInstance.IsVisibleInv(ONContext.GetType_Instance(ClassName), lPath, OnContext)) { return(false); } ONDBData lData = ONContext.GetComponent_Data(lOID.ClassName, OnContext) as ONDBData; lData.InhFixInstance(onSql, null, lPath, lOID, true); } return(true); }
/// <summary> /// Controls the triggers of the model object /// </summary> public void CheckTriggers() { foreach (KeyValuePair <ONOid, ONAction> lDictionaryEntry in ModifiedClass) { ONAction lAction = lDictionaryEntry.Value; ONActionCacheItem lActionCacheItem = ONActionCacheItem.Get("Action", lAction.ClassName); lActionCacheItem.InvoqueTriggers(lAction, new object[] { lDictionaryEntry.Key }); ONInstance lInstance = (lDictionaryEntry.Key as ONOid).GetInstance(lAction.OnContext); foreach (ONInstance lNetInstance in lInstance.GetFacets()) { if (((object)lNetInstance != null) && (lNetInstance.ClassName != lAction.Instance.ClassName)) { // Create action class ONAction lNetAction = ONContext.GetComponent_Action(lNetInstance.ClassName, lNetInstance.OnContext); lNetAction.Instance = lNetInstance; ONActionCacheItem lNetActionCacheItem = ONActionCacheItem.Get("Action", lNetInstance.ClassName); lNetActionCacheItem.InvoqueTriggers(lNetAction, new object[] { lNetInstance.Oid }); } } } }
public static string RetrieveInstances(ONSqlSelect onSql, ONDisplaySet displaySet, ONPath onPath, ONContext onContext) { string lAlias = onSql.CreateAlias(CtesBD.TBL_AERONAVE, onPath, "Aeronave"); ONDisplaySet lSourceDS = null; if (displaySet != null) { lSourceDS = new ONDisplaySet(displaySet); displaySet.Clear(); } if (displaySet == null) { onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_ID_AERONAVE + ", " + lAlias + "." + CtesBD.FLD_AERONAVE_ESTADOOBJ + ", " + lAlias + "." + CtesBD.FLD_AERONAVE_FUM + ", " + lAlias + "." + CtesBD.FLD_AERONAVE_MAXIMOPASAJEROS); } else { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_ID_AERONAVE)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_ID_AERONAVE); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_ESTADOOBJ)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_ESTADOOBJ); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_FUM)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_FUM); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_MAXIMOPASAJEROS)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_MAXIMOPASAJEROS); if (lSourceDS.Contains(CtesBD.FLD_AERONAVE_NOMBRE)) { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_NOMBRE)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_NOMBRE); } if (lSourceDS.Contains(CtesBD.FLD_AERONAVE_ORIGEN)) { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_ORIGEN)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_ORIGEN); } if (lSourceDS.Contains(CtesBD.FLD_AERONAVE_DESTINO)) { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_AERONAVE_DESTINO)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_AERONAVE_DESTINO); } } // Related attributes if (displaySet != null) { foreach (ONDisplaySetItem lDisplaySetItem in lSourceDS) { if ((lDisplaySetItem.Path.IndexOf(".") > 0) && (lDisplaySetItem.InData) && (!lDisplaySetItem.HasHV)) { displaySet.Add(lDisplaySetItem); string lPath = lDisplaySetItem.Path.Substring(0, lDisplaySetItem.Path.LastIndexOf(".")); string lFacetName = AeronaveInstance.GetTargetClass(onContext, typeof(AeronaveInstance), new ONPath(lDisplaySetItem.Path)); onSql.AddSelect(AddPath(onSql, JoinType.LeftJoin, lFacetName, new ONPath(lPath), onPath, "", false) + "." + ONInstance.GetFieldNameOfAttribute(typeof(AeronaveInstance), new ONPath(lDisplaySetItem.Path))); } } } return(lAlias); }
/// <summary> /// Converts the instances returned by a query in XML format in order to put it in XML message response /// </summary> /// <param name="agentOid">OID with the agent connected to the system</param> /// <param name="xmlWriter">This parameter has the response message XML</param> /// <param name="val">Instances that fullfils with the query request</param> /// <param name="startRowOID">OID necessary to start the search</param> /// <param name="blockSize">Represents the number of instances to be returned</param> /// <param name="displaySet">Attributes to be returned in the response</param> /// <param name="dtdVersion">Version of DTD that follows the XML message</param> public override void ONQuery2XML(ONOid agentOid, XmlWriter xmlWriter, ONCollection val, ONOid startRowOID, int blockSize, ONDisplaySet displaySet, double dtdVersion) { xmlWriter.WriteStartElement("Head"); xmlWriter.WriteStartElement("Head.OID"); xmlWriter.WriteAttributeString("Class", "Pasajero"); xmlWriter.WriteStartElement("Head.OID.Field"); xmlWriter.WriteAttributeString("Name", "id_Pasajero"); xmlWriter.WriteAttributeString("Type", "autonumeric"); xmlWriter.WriteEndElement(); // Head.OID.Field xmlWriter.WriteEndElement(); // Head.OID xmlWriter.WriteStartElement("Head.Cols"); foreach (ONDisplaySetItem lDisplaySetItem in displaySet) { xmlWriter.WriteStartElement("Head.Col"); xmlWriter.WriteAttributeString("Name", lDisplaySetItem.Path); string lType = ONInstance.GetTypeOfAttribute(typeof(PasajeroInstance), new ONPath(lDisplaySetItem.Path)); if (lType == "") { lType = "string"; } xmlWriter.WriteAttributeString("Type", lType); xmlWriter.WriteEndElement(); // Head.Col } xmlWriter.WriteEndElement(); // Head.Cols xmlWriter.WriteEndElement(); // Head // Search StartRow int i = 0; if (startRowOID != null) { i = val.IndexOf(startRowOID) + 1; } // Instance count int lInstances = 0; int lNumInstances = 0; string lLastBlock = "True"; if (i >= 0) { lNumInstances = val.Count - i; if ((blockSize > 0) && (lNumInstances > blockSize)) { lNumInstances = blockSize; lLastBlock = "False"; } } xmlWriter.WriteStartElement("Data"); xmlWriter.WriteAttributeString("Rows", lNumInstances.ToString()); xmlWriter.WriteAttributeString("LastBlock", lLastBlock); xmlWriter.WriteAttributeString("TotalRows", val.totalNumInstances.ToString()); while ((lInstances++ < lNumInstances) && (i < val.Count)) { PasajeroInstance lInstance = val[i++] as PasajeroInstance; xmlWriter.WriteStartElement("R"); ONXmlAutonumeric.ON2XML(xmlWriter, lInstance.Oid.Id_PasajeroAttr, dtdVersion, ONXml.XMLTAG_O); foreach (ONDisplaySetItem lDisplaySetItem in displaySet) { if (lDisplaySetItem.Visibility == VisibilityState.NotChecked) { if (ONInstance.IsVisible(lInstance.GetType(), lDisplaySetItem.Path, lInstance.OnContext)) { lDisplaySetItem.Visibility = VisibilityState.Visible; } else { lDisplaySetItem.Visibility = VisibilityState.NotVisible; } } if (lDisplaySetItem.Visibility == VisibilityState.NotVisible) // No Visibility { xmlWriter.WriteElementString("V", null); } else { ONSimpleType lAttribute; if (lDisplaySetItem.HasHV) { lAttribute = lInstance.DisplaysetItemValue(lDisplaySetItem.Path); } else { lAttribute = lInstance[lDisplaySetItem.Path] as ONSimpleType; } if (lAttribute is ONInt) { ONXmlInt.ON2XML(xmlWriter, lAttribute as ONInt, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONString) { ONXmlString.ON2XML(xmlWriter, lAttribute as ONString, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONBlob) { ONXmlBlob.ON2XML(xmlWriter, lAttribute as ONBlob, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONBool) { ONXmlBool.ON2XML(xmlWriter, lAttribute as ONBool, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONReal) { ONXmlReal.ON2XML(xmlWriter, lAttribute as ONReal, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONInt) { ONXmlAutonumeric.ON2XML(xmlWriter, lAttribute as ONInt, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONDate) { ONXmlDate.ON2XML(xmlWriter, lAttribute as ONDate, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONDateTime) { ONXmlDateTime.ON2XML(xmlWriter, lAttribute as ONDateTime, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONTime) { ONXmlTime.ON2XML(xmlWriter, lAttribute as ONTime, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONNat) { ONXmlNat.ON2XML(xmlWriter, lAttribute as ONNat, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONText) { ONXmlText.ON2XML(xmlWriter, lAttribute as ONText, dtdVersion, ONXml.XMLTAG_V); } else if (lAttribute is ONString) { ONXmlPassword.ON2XML(xmlWriter, lAttribute as ONString, dtdVersion, ONXml.XMLTAG_V); } } } xmlWriter.WriteEndElement(); // R } xmlWriter.WriteEndElement(); // Data }
public override void UpdateDeleted(ONInstance instance) { }
public override void UpdateAdded(ONInstance instance) { }
public static string RetrieveInstances(ONSqlSelect onSql, ONDisplaySet displaySet, ONPath onPath, ONContext onContext) { string lAlias = onSql.CreateAlias(CtesBD.TBL_REVISION, onPath, "Revision"); ONDisplaySet lSourceDS = null; if (displaySet != null) { lSourceDS = new ONDisplaySet(displaySet); displaySet.Clear(); } if (displaySet == null) { onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_ID_REVISARAERONAVE + ", " + lAlias + "." + CtesBD.FLD_REVISION_ESTADOOBJ + ", " + lAlias + "." + CtesBD.FLD_REVISION_FUM + ", " + lAlias + "." + CtesBD.FLD_REVISION_NOMBREREVISOR + ", " + lAlias + "." + CtesBD.FLD_REVISION_FECHAREVISION + ", " + lAlias + "." + CtesBD.FLD_REVISION_ID_AERONAVE); } else { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_ID_REVISARAERONAVE)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_ID_REVISARAERONAVE); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_ESTADOOBJ)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_ESTADOOBJ); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_FUM)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_FUM); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_NOMBREREVISOR)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_NOMBREREVISOR); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_FECHAREVISION)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_FECHAREVISION); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_REVISION_ID_AERONAVE)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_REVISION_ID_AERONAVE); } // Related attributes if (displaySet != null) { foreach (ONDisplaySetItem lDisplaySetItem in lSourceDS) { if ((lDisplaySetItem.Path.IndexOf(".") > 0) && (lDisplaySetItem.InData) && (!lDisplaySetItem.HasHV)) { displaySet.Add(lDisplaySetItem); string lPath = lDisplaySetItem.Path.Substring(0, lDisplaySetItem.Path.LastIndexOf(".")); string lFacetName = RevisionInstance.GetTargetClass(onContext, typeof(RevisionInstance), new ONPath(lDisplaySetItem.Path)); onSql.AddSelect(AddPath(onSql, JoinType.LeftJoin, lFacetName, new ONPath(lPath), onPath, "", false) + "." + ONInstance.GetFieldNameOfAttribute(typeof(RevisionInstance), new ONPath(lDisplaySetItem.Path))); } } } return(lAlias); }
public override void UpdateEdited(ONInstance instance) { }
public static string RetrieveInstances(ONSqlSelect onSql, ONDisplaySet displaySet, ONPath onPath, ONContext onContext) { string lAlias = onSql.CreateAlias(CtesBD.TBL_ADMINISTRADOR, onPath, "Administrador"); ONDisplaySet lSourceDS = null; if (displaySet != null) { lSourceDS = new ONDisplaySet(displaySet); displaySet.Clear(); } if (displaySet == null) { onSql.AddSelect(lAlias + "." + CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR + ", " + lAlias + "." + CtesBD.FLD_ADMINISTRADOR_PASSWORD + ", " + lAlias + "." + CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ + ", " + lAlias + "." + CtesBD.FLD_ADMINISTRADOR_FUM); } else { displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_ADMINISTRADOR_PASSWORD)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_ADMINISTRADOR_PASSWORD); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_ADMINISTRADOR_ESTADOOBJ); displaySet.Add(new ONDisplaySetItem(CtesBD.FLD_ADMINISTRADOR_FUM)); onSql.AddSelect(lAlias + "." + CtesBD.FLD_ADMINISTRADOR_FUM); } // Related attributes if (displaySet != null) { foreach (ONDisplaySetItem lDisplaySetItem in lSourceDS) { if ((lDisplaySetItem.Path.IndexOf(".") > 0) && (lDisplaySetItem.InData) && (!lDisplaySetItem.HasHV)) { displaySet.Add(lDisplaySetItem); string lPath = lDisplaySetItem.Path.Substring(0, lDisplaySetItem.Path.LastIndexOf(".")); string lFacetName = AdministradorInstance.GetTargetClass(onContext, typeof(AdministradorInstance), new ONPath(lDisplaySetItem.Path)); onSql.AddSelect(AddPath(onSql, JoinType.LeftJoin, lFacetName, new ONPath(lPath), onPath, "", false) + "." + ONInstance.GetFieldNameOfAttribute(typeof(AdministradorInstance), new ONPath(lDisplaySetItem.Path))); } } } return(lAlias); }
/// <summary> /// Constructor /// </summary> /// <param name="onContext">Context of the execution of the request</param> /// <param name="instance">THIS Instance</param> /// <param name="className">Name of the class that has the services</param> public ONServer(ONServiceContext onContext, ONInstance instance, string className) { ClassName = className; OnContext = onContext; Instance = instance; }
/// <summary> /// Makes the memory checks /// </summary> /// <param name="instance">Instance to check</param> /// <returns>if the instance it check the filter</returns> public virtual bool FilterInMemory(ONInstance instance) { return(true); }