/// <summary> /// Sybase internal use only. /// <summary> public void RbsReplayInternal(YPF.Comercial.RRCC.SUP.Interaccion entity) { YPF.Comercial.RRCC.SUP.intrnl.OperationReplay _replay = new YPF.Comercial.RRCC.SUP.intrnl.OperationReplay(); _replay.RemoteId = ("."); _replay.Component = ("CRMMobileDesa.Interaccion_rs"); _replay.EntityKey = (entity.KeyToString()); _replay.Operation = (entity.LastOperation); bool _includeBig = !("delete").Equals(_replay.Operation); com.sybase.afx.json.JsonObject _parameters = new com.sybase.afx.json.JsonObject(); _parameters.Put("entity", YPF.Comercial.RRCC.SUP.Interaccion.__toJSON(entity, _includeBig)); //_replay.Parameters =(_parameters.ToString()); //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction _tran = null; try { _tran = _conn.BeginTransaction(); com.sybase.afx.json.JsonObject _json = new com.sybase.afx.json.JsonObject(); _replay.Attributes = (_json.ToString()); _replay.Save(); _replay.SaveParameter(_parameters); _tran.Commit(); } catch (Sybase.Persistence.PersistenceException pe) { _tran.Rollback(); throw pe; } catch (System.ApplicationException e) { _tran.Rollback(); throw e; } //} }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.FormularioTransporte entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__flota = entity.__flota; this.__empresasCliente = entity.__empresasCliente; this.__recorrido = entity.__recorrido; this.__SYMA = entity.__SYMA; this.__RAZ_SOC_2 = entity.__RAZ_SOC_2; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.FormularioPrecios entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__formularioPreciosZonaInspeccion_CodigoSAP = entity.__formularioPreciosZonaInspeccion_CodigoSAP; this.__zonaPrecios = entity.__zonaPrecios; this.__cluster = entity.__cluster; this.__formularioPreciosRed_CodigoSAP = entity.__formularioPreciosRed_CodigoSAP; this.__APIES = entity.__APIES; this.__formularioPreciosMercado_CodigoSAP = entity.__formularioPreciosMercado_CodigoSAP; this.__submercado = entity.__submercado; this.__tasaServicio = entity.__tasaServicio; this.__observacionesTasaServicio = entity.__observacionesTasaServicio; this.__tasaIncluida = entity.__tasaIncluida; this.__estrategica = entity.__estrategica; this.__camara = entity.__camara; this.__programaFidelizacion = entity.__programaFidelizacion; this.__otrosNegocios = entity.__otrosNegocios; this.__mediosPago = entity.__mediosPago; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.RelevamientoTransporte entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__interaccion_nroOperacionSAP = entity.__interaccion_nroOperacionSAP; this.__relevamientoTransporteCompetidor_CodigoSAP = entity.__relevamientoTransporteCompetidor_CodigoSAP; this.__relevamientoTransporteProducto_CodigoSAP = entity.__relevamientoTransporteProducto_CodigoSAP; this.__volumen = entity.__volumen; this.__volumenDireccionEntrega = entity.__volumenDireccionEntrega; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
internal static YPF.Comercial.RRCC.SUP.Interaccion FromJSON(object _json) { if (_json == null) { return null; } else { YPF.Comercial.RRCC.SUP.Interaccion _obj = new YPF.Comercial.RRCC.SUP.Interaccion(); _obj._fromJSON((com.sybase.afx.json.JsonObject)_json); return _obj; } }
/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.Interaccion /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> GetPendingObjects(char pendingChange, int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion>(); System.Data.IDataReader rs_4 = null; int count_5 = 0; Sybase.Persistence.ConnectionWrapper _conn = null; try { _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); string _selectSQL = " x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"bb\",x.\"bc\",x.\"bd\",x.\"be\",x.\"bf\",x.\"bg\",x.\"bh\",x.\"bi\",x.\"bj\",x.\"bl\",x.\"bm\",x.\"bn\",x.\"bo\",x.\"bp\",x.\"bq\",x.\"br\"," + "x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bs\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_interaccion\" x where x.\"_pc\" = ?"; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps_3, "pendingChange", pendingChange); rs_4 = ps_3.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4)) { YPF.Comercial.RRCC.SUP.Interaccion entity_6 = new YPF.Comercial.RRCC.SUP.Interaccion(); entity_6.Bind(profile, rs_4); count_5++; result_2.Add(entity_6); } if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5); if (ps_3 != null) ps_3.Dispose(); _selectSQL = null; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } return result_2; }
/// <summary> /// Clear the reference of relationships in memory. /// </summary> public void ClearRelationshipObjects() { __interaccionValid = false; __interaccion = null; }
/// <summary> /// Sybase internal use only. /// <summary> public void SetOriginalState(YPF.Comercial.RRCC.SUP.Interaccion orig) { __originalStateValid = true; __originalState = orig; }
private void Internal_Create() { bool ok = true; Sybase.Persistence.LocalTransaction localTransaction = null; try { localTransaction = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.BeginTransaction(); if(__surrogateKey == 0) __surrogateKey = (long)(YPF.Comercial.RRCC.SUP.KeyGenerator.GenerateId()); YPF.Comercial.RRCC.SUP.Interaccion os_1 = new YPF.Comercial.RRCC.SUP.Interaccion(); os_1.CopyAll(this); this.SetOriginalState(os_1); PendingChange = 'C'; SetReplayCounter(KeyGenerator.GenerateId()); SetReplayFailure(0); ReplayPending = 0; if(_isNew) { Create(true); } else { Update(true); } } catch(System.SystemException e) { ok = false; throw e; } finally { if(localTransaction != null) { localTransaction.EndTransaction(ok); } } }
protected override void Bind(Sybase.Persistence.ConnectionProfile profile, System.Data.IDataReader rs) { this.__idInteraccion = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"idInteraccion",0); this.__tipoInteraccion_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"tipoInteraccion_CodigoSAP",1); this.__titulo = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"titulo",2); this.__tipoInteraccion_CategoriaSAP = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"tipoInteraccion_CategoriaSAP",3); this.__GUID = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"GUID",4); this.__nroOperacionSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"nroOperacionSAP",5); this.__segmento_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"segmento_CodigoSAP",6); this.__negocio_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"negocio_CodigoSAP",7); this.__formulario_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"formulario_CodigoSAP",8); this.__puntaje = com.sybase.afx.db.ReaderUtil.GetNullableDecimal(profile,rs,"puntaje",9); this.__latitud = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"latitud",10); this.__longitud = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"longitud",11); this.__comentarios = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"comentarios",12); this.__notasPreparacion = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasPreparacion",13); this.__notasResultado = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultado",14); this.__notasResultadoAdministrativo = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultadoAdministrativo",15); this.__notasResultadoComercial = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultadoComercial",16); this.__notasResultadoOperativo = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultadoOperativo",17); this.__notasResultadoMercado = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultadoMercado",18); this.__notasResultadoAsesoramiento = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"notasResultadoAsesoramiento",19); this.__fechaInicioPlanificada = com.sybase.afx.db.ReaderUtil.GetNullableDate(profile,rs,"fechaInicioPlanificada",20); this.__horaInicioPlanificada = com.sybase.afx.db.ReaderUtil.GetNullableTime(profile,rs,"horaInicioPlanificada",21); this.__fechaFinPlanificada = com.sybase.afx.db.ReaderUtil.GetNullableDate(profile,rs,"fechaFinPlanificada",22); this.__horaFinPlanificada = com.sybase.afx.db.ReaderUtil.GetNullableTime(profile,rs,"horaFinPlanificada",23); this.__fechaInicioReal = com.sybase.afx.db.ReaderUtil.GetNullableDate(profile,rs,"fechaInicioReal",24); this.__horaInicioReal = com.sybase.afx.db.ReaderUtil.GetNullableTime(profile,rs,"horaInicioReal",25); this.__fechaFinReal = com.sybase.afx.db.ReaderUtil.GetNullableDate(profile,rs,"fechaFinReal",26); this.__horaFinReal = com.sybase.afx.db.ReaderUtil.GetNullableTime(profile,rs,"horaFinReal",27); this.__idDireccionEntrega = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"idDireccionEntrega",28); this.__direccionEntregaNombre = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"direccionEntregaNombre",29); this.__representanteComercial_CodigoInterlocutor = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"representanteComercial_CodigoInterlocutor",30); this.__representanteComercial_Nombre = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"representanteComercial_Nombre",31); this.__responsable_CodigoInterlocutor = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"responsable_CodigoInterlocutor",32); this.__responsableNombre = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"responsableNombre",33); this.__estadoInteraccion_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"estadoInteraccion_CodigoSAP",34); this.__motivo_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"motivo_CodigoSAP",35); this.__calle = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"calle",36); this.__direccionNro = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"direccionNro",37); this.__codigoPostal = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"codigoPostal",38); this.__ciudad = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"ciudad",39); this.__provincia_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"provincia_CodigoSAP",40); this.__pais_CodigoSAP = com.sybase.afx.db.ReaderUtil.GetNullableStringUL(profile,rs,"pais_CodigoSAP",41); RelevamientosTransporte =(null); RelevamientosProducto =(null); RelevamientosPrecio =(null); RelevamientosProveedor =(null); RespuestasInteraccionFormulario =(null); this.__pending = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"pending",42); this.__pendingChange = com.sybase.afx.db.ReaderUtil.GetChar(profile,rs,"pendingChange",43); this.__replayPending = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayPending",44); this.__replayFailure = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayFailure",45); this.__surrogateKey = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"surrogateKey",46); this.__replayCounter = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayCounter",47); this.__disableSubmit = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"disableSubmit",48); _isNew = false; _isDirty = false; if (this.IsPending) { this.SetOriginalState(null); this.__originalStateValid = false; } else { YPF.Comercial.RRCC.SUP.Interaccion os_1 = new YPF.Comercial.RRCC.SUP.Interaccion(); os_1.CopyAll(this); this.SetOriginalState(os_1); } }
/// <summary> /// Set current MBO attributes by specified MBO. /// </summary> public static YPF.Comercial.RRCC.SUP.Interaccion Merge(YPF.Comercial.RRCC.SUP.Interaccion entity) { YPF.Comercial.RRCC.SUP.Interaccion ent = Find(entity._pk()); if (ent == null) { ent = new YPF.Comercial.RRCC.SUP.Interaccion(); } ent.CopyAll(entity); ent.Save(); return ent; }
private static YPF.Comercial.RRCC.SUP.Interaccion _find(long id, String sql, bool findOs, bool findNonPending) { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); System.Data.IDataReader _rs = null; int count = 0; try { YPF.Comercial.RRCC.SUP.Interaccion _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", id); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.Interaccion(); _rt.Bind(profile, _rs); count++; if(findOs) { _rt.__isOsEntity = true; _rt.__pending = false; } if( !findNonPending ) { if(_rt.IsPending) { break; } } else { if( !_rt.IsPending ) { break; } else { _rt = null; } } } if (_rs != null) com.sybase.afx.db.ReaderUtil.Close(profile, _rs, count); if (ps != null) ps.Dispose(); return _rt; } catch(System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// Refresh the mobile business object from database. /// </summary> public void Refresh() { if (!_isNew && !__isOsEntity) { YPF.Comercial.RRCC.SUP.Interaccion ent = Load(_pk()); CopyAll(ent); if (this.IsPending) { this.SetOriginalState(null); this.__originalStateValid = false; } else { YPF.Comercial.RRCC.SUP.Interaccion os_1 = new YPF.Comercial.RRCC.SUP.Interaccion(); os_1.CopyAll(this); this.SetOriginalState(os_1); } _isNew = false; _isDirty = false; } }
public void Finish_rbsReplayInternal(Sybase.Persistence.IOperationReplay _call_tmp) { YPF.Comercial.RRCC.SUP.intrnl.OperationReplay _call = (YPF.Comercial.RRCC.SUP.intrnl.OperationReplay)_call_tmp; com.sybase.afx.json.JsonObject parameters = (com.sybase.afx.json.JsonObject)(com.sybase.afx.json.JsonReader .Parse(_call.Parameters)); string exception = _call.Exception; YPF.Comercial.RRCC.SUP.Interaccion entity = (YPF.Comercial.RRCC.SUP.Interaccion)(YPF.Comercial.RRCC.SUP.Interaccion.__fromJSON(parameters.Get("entity"))); //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction tran = null; try { tran = conn.BeginTransaction(); long ____id = entity.ReplayCounter; YPF.Comercial.RRCC.SUP.Interaccion _client = YPF.Comercial.RRCC.SUP.Interaccion.Find(entity._pk()); YPF.Comercial.RRCC.SUP.Interaccion _downloadState = null; if (_client != null) { _downloadState = _client.DownloadState; } if (exception == null) { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnReplaySuccess(_client == null ? entity : _client); YPF.Comercial.RRCC.SUP.Interaccion.GetCallbackHandler().OnReplaySuccess(_client == null ? entity : _client); if ((_client != null) && _client.IsPending) { long _rc = _client.ReplayPending; if (_rc == ____id) { if (_rc == _client.ReplayCounter) { _client._cancelPending2(false); } else { _client.ReplayPending = 0; _client.ReplayFailure = 0; _client.__update(true); } } } } else { _client.ReplayFailure = (_client.ReplayPending); _client._cascadeUpdateReplayCounterPending(false); if (_client != null && _client.ReplayPending == ____id) { _client.ReplayPending = (0); _client.ReplayCounter = (YPF.Comercial.RRCC.SUP.KeyGenerator.GenerateId()); _client.ReplayFailure = (____id); _client.__update(true); if (_downloadState != null) { _downloadState._update_os(); } } YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnReplayFailure(_client); YPF.Comercial.RRCC.SUP.Interaccion.GetCallbackHandler().OnReplayFailure(_client); } _call.Delete(); tran.Commit(); } catch (Sybase.Persistence.PersistenceException pe) { tran.Rollback(); throw pe; } catch (System.ApplicationException e) { tran.Rollback(); throw e; } //} }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.RelevamientoProducto entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__interaccion_nroOperacionSAP = entity.__interaccion_nroOperacionSAP; this.__relevamientoProductoProducto_CodigoSAP = entity.__relevamientoProductoProducto_CodigoSAP; this.__volumen = entity.__volumen; this.__stock = entity.__stock; this.__relevamientoProductoTipo_CodigoSAP = entity.__relevamientoProductoTipo_CodigoSAP; this.__critico = entity.__critico; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// Find a mobile business object YPF.Comercial.RRCC.SUP.Interaccion /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static YPF.Comercial.RRCC.SUP.Interaccion FindByPrimaryKey(string idInteraccion) { YPF.Comercial.RRCC.SUP.Interaccion result_2 = null; System.Data.IDataReader rs_4 = null; int count_5 = 0; Sybase.Persistence.ConnectionWrapper _conn = null; try { _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); string _selectSQL = "SELECT x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"bb\",x.\"bc\",x.\"bd\",x.\"be\",x.\"bf\",x.\"bg\",x.\"bh\",x.\"bi\",x.\"bj\",x.\"bl\",x.\"bm\",x.\"bn\",x.\"bo\",x.\"bp\",x.\"bq\",x" + ".\"br\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bs\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_interaccion\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"bs\" from \"crmmobiledesa_1_0_interaccion_os\" x_os where x_os.\"bs\" = x.\"bs\")))) and ( x.\"a\" = ?)"; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "idInteraccion", idInteraccion); rs_4 = ps_3.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4)) { YPF.Comercial.RRCC.SUP.Interaccion entity_6 = new YPF.Comercial.RRCC.SUP.Interaccion(); entity_6.Bind(profile, rs_4); count_5++; result_2 = entity_6; } if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5); if (ps_3 != null) ps_3.Dispose(); _selectSQL = null; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } return result_2; }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.RelevamientoProveedor entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__interaccion_nroOperacionSAP = entity.__interaccion_nroOperacionSAP; this.__idRelevamientoProveedor = entity.__idRelevamientoProveedor; this.__marca = entity.__marca; this.__relevamientoProveedorCanal_CodigoSAP = entity.__relevamientoProveedorCanal_CodigoSAP; this.__despacho = entity.__despacho; this.__relevamientoProveedorLogistica_CodigoSAP = entity.__relevamientoProveedorLogistica_CodigoSAP; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.Interaccion /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> FindVisitaRRCCByDate(System.DateTime fecha, string codigoInterlocutor, int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion>(); System.Data.IDataReader rs_4 = null; int count_5 = 0; Sybase.Persistence.ConnectionWrapper _conn = null; try { _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); string _selectSQL = " x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"bb\",x.\"bc\",x.\"bd\",x.\"be\",x.\"bf\",x.\"bg\",x.\"bh\",x.\"bi\",x.\"bj\",x.\"bl\",x.\"bm\",x.\"bn\",x.\"bo\",x.\"bp\",x.\"bq\",x.\"br\"," + "x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bs\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_interaccion\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"bs\" from \"crmmobiledesa_1_0_interaccion_os\" x_os where x_os.\"bs\" = x.\"bs\")))) and ( x.\"bd\" IS NOT NULL AND x.\"bd\" <> \'\' AND x.\"b\" = \'ZVRC\' AND x.\"d\" " + "= \'Z06\' AND DAY(x.\"v\") = DAY(?) AND MONTH(x.\"v\") = MONTH(?) And YEAR(x.\"v\") = YEAR(?) AND x.\"bf\" = ?)"; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); com.sybase.afx.db.CommandUtil.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha); com.sybase.afx.db.CommandUtil.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha); com.sybase.afx.db.CommandUtil.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "codigoInterlocutor", codigoInterlocutor); rs_4 = ps_3.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4)) { YPF.Comercial.RRCC.SUP.Interaccion entity_6 = new YPF.Comercial.RRCC.SUP.Interaccion(); entity_6.Bind(profile, rs_4); count_5++; result_2.Add(entity_6); } if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5); if (ps_3 != null) ps_3.Dispose(); _selectSQL = null; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } return result_2; }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__formulario_CodigoSAP = entity.__formulario_CodigoSAP; this.__pregunta_CodigoSAP = entity.__pregunta_CodigoSAP; this.__respuesta_CodigoSAP = entity.__respuesta_CodigoSAP; this.__observaciones = entity.__observaciones; this.__puntaje = entity.__puntaje; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.FormularioMercado entity) { this._isNew = entity._isNew; this.__idInteraccion = entity.__idInteraccion; this.__empresa = entity.__empresa; this.__formularioMercadoTamano_CodigoSAP = entity.__formularioMercadoTamano_CodigoSAP; this.__formularioMercadoSegmento_CodigoSAP = entity.__formularioMercadoSegmento_CodigoSAP; this.__formularioMercadoSubsegmento_CodigoSAP = entity.__formularioMercadoSubsegmento_CodigoSAP; this.__interaccion = entity.__interaccion; this.__interaccionValid = entity.__interaccionValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__interaccionFK = entity.__interaccionFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }