/// <summary> /// Get surroget key of the mobile business object /// </summary> public YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _pk() { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _key = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _key.RemoteId = (RemoteId); _key.BatchId = (BatchId); return(_key); }
/// <summary> /// Get the mobile business object by surrogate key. /// </summary> /// <param name="id">surrogate key</param> /// <returns>the mobile business object for the surroget key</returns> /// <exception cref="ObjectNotFoundException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static YPF.Comercial.RRCC.SUP.LocalKeyGenerator Load(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK id) { YPF.Comercial.RRCC.SUP.LocalKeyGenerator _ent = Find(id); if (_ent == null) { throw new Sybase.Persistence.ObjectNotFoundException(); } return(_ent); }
/// <summary> /// Sybase internal use only. /// <summary> public static com.sybase.afx.json.JsonObject __toJSON(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object, bool _includeBigAttribute) { if (_includeBigAttribute) { return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSON(_object)); } else { return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSONWithoutBigAttribute(_object)); } }
internal static com.sybase.afx.json.JsonObject ToJSON(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object, bool __buildGraph, bool _includeBigAttribute, bool _includeUserAttributes) { if ((_object == null)) { return(null); } else { return(_object._toJSON(__buildGraph, _includeBigAttribute, _includeUserAttributes)); } }
internal static YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK FromJSON(object _json) { if (_json == null) { return(null); } else { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _obj = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _obj._fromJSON((com.sybase.afx.json.JsonObject)_json); return(_obj); } }
/// <summary> /// override method /// </summary> public override int GetHashCode() { try { return(_pk().GetHashCode()); } catch (System.Exception) { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _key = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _key.RemoteId = (RemoteId); _key.BatchId = (BatchId); return(_key.GetHashCode()); } }
/// <summary> /// override method /// </summary> public override bool Equals(object that) { YPF.Comercial.RRCC.SUP.LocalKeyGenerator that_1 = that as YPF.Comercial.RRCC.SUP.LocalKeyGenerator; if (that_1 == null) { return(false); } YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK id_2 = this._pk(); YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK id_3 = that_1._pk(); if ((id_2 == null) || (id_3 == null)) { return(false); } return(id_2.Equals(id_3)); }
/// <summary> /// Sybase internal use only. /// <summary> public void NextBatch() { //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction _tran_1 = _conn.BeginTransaction(); YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _pk_2 = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _pk_2.RemoteId = ("*"); _pk_2.BatchId = (1); YPF.Comercial.RRCC.SUP.LocalKeyGenerator _batch_3 = YPF.Comercial.RRCC.SUP.LocalKeyGenerator.Find(_pk_2); if (_batch_3 == null) { _batch_3 = new YPF.Comercial.RRCC.SUP.LocalKeyGenerator(); _batch_3.RemoteId = (_pk_2.RemoteId); _batch_3.BatchId = (_pk_2.BatchId); _batch_3.FirstId = (1); _batch_3.NextId = (1 + 100000); // _batch_3.LastId =(9223372036854775807); _batch_3.LastId = (2147483647); _batch_3.Save(); this.RemoteId = ("*"); this.BatchId = (1); this.FirstId = (1); this.NextId = (1); this.LastId = (100000); } else { long _next_4 = _batch_3.NextId; long _next_5 = _next_4 + 100000; _batch_3.NextId = (_next_5); _batch_3.Save(); this.FirstId = (_next_4); this.NextId = (_next_4); this.LastId = (_next_5 - 1); } _tran_1.Commit(); //} }
private static YPF.Comercial.RRCC.SUP.LocalKeyGenerator _find(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK 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.LocalKeyGenerator _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "remoteId", id.RemoteId); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "batchId", id.BatchId); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.LocalKeyGenerator(); _rt.Bind(profile, _rs); count++; } 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(); } }
internal static YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK FromJSON(object _json) { if (_json == null) { return null; } else { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _obj = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _obj._fromJSON((com.sybase.afx.json.JsonObject)_json); return _obj; } }
/// <summary> /// override method /// </summary> public override int GetHashCode() { try { return _pk().GetHashCode(); } catch(System.Exception) { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _key = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _key.RemoteId =(RemoteId); _key.BatchId =(BatchId); return _key.GetHashCode(); } }
internal static com.sybase.afx.json.JsonObject ToJSON(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object, bool __buildGraph, bool _includeBigAttribute) { return(ToJSON(_object, __buildGraph, _includeBigAttribute, true)); }
internal static com.sybase.afx.json.JsonObject ToJSON(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object) { return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSON(_object, false, true, true)); }
internal static com.sybase.afx.json.JsonObject ToJSONWithoutUserAttributes(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object) { return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSON(_object, false, false, false)); }
/// <summary> /// Sybase internal use only. /// <summary> public void NextBatch() { //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction _tran_1 = _conn.BeginTransaction(); YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _pk_2 = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _pk_2.RemoteId =("*"); _pk_2.BatchId =(1); YPF.Comercial.RRCC.SUP.LocalKeyGenerator _batch_3 = YPF.Comercial.RRCC.SUP.LocalKeyGenerator.Find(_pk_2); if (_batch_3 == null) { _batch_3 = new YPF.Comercial.RRCC.SUP.LocalKeyGenerator(); _batch_3.RemoteId =(_pk_2.RemoteId); _batch_3.BatchId =(_pk_2.BatchId); _batch_3.FirstId =(1); _batch_3.NextId =(1 + 100000); // _batch_3.LastId =(9223372036854775807); _batch_3.LastId =(2147483647); _batch_3.Save(); this.RemoteId =("*"); this.BatchId =(1); this.FirstId =(1); this.NextId =(1); this.LastId =(100000); } else { long _next_4 = _batch_3.NextId; long _next_5 = _next_4 + 100000; _batch_3.NextId =(_next_5); _batch_3.Save(); this.FirstId =(_next_4); this.NextId =(_next_4); this.LastId =(_next_5 - 1); } _tran_1.Commit(); //} }
/// <summary> /// Sybase internal use only. /// <summary> public static com.sybase.afx.json.JsonObject __toJSON(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _object) { return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSON(_object)); }
/// <summary> /// Get surroget key of the mobile business object /// </summary> public YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _pk() { YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _key = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _key.RemoteId =(RemoteId); _key.BatchId =(BatchId); return _key; }
/// <summary> /// Search mobile business object using surrogateKey /// </summary> /// <param name="id">surrogateKey</param> /// <returns>mobile business object</returns> /// <remarks> </remarks> public static YPF.Comercial.RRCC.SUP.LocalKeyGenerator Find(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK id) { return(_find(id, "select \"first_id\",\"last_id\",\"next_id\",\"remote_id\",\"batch_id\" from co_crmmobiledesa_1_0_localkeygenerator where \"remote_id\"=? and \"batch_id\"=?", false, false)); }