public IList<CY.UME.Core.Business.WishingExtend> GetWishesByActivityIdAndAccountId(long? accountId, string activityId, int count) { IList<Core.Business.WishingExtend> wishingExtendlist = new List<Core.Business.WishingExtend>(); SqlServerUtility sql = new SqlServerUtility(SqlConnection); if (accountId == null) { accountId = 0; } //sql.AddParameter("@AccountId", SqlDbType.BigInt, accountId); sql.AddParameter("@ActivityId", SqlDbType.NVarChar, activityId); sql.AddParameter("@Count", SqlDbType.Int, count); SqlDataReader reader = sql.ExecuteSPReader("USP_WishingExtend_Select_By_ActivityId_And_AccountId"); if (reader != null) { while (reader.Read()) { Core.Business.WishingExtend wishingExtend = new Core.Business.WishingExtend(); long id = 0; if (!reader.IsDBNull(0)) id = reader.GetInt64(0); wishingExtend = CY.UME.Core.Business.WishingExtend.Load(id); wishingExtend.MarkOld(); wishingExtendlist.Add(wishingExtend); } reader.Close(); } return wishingExtendlist; }
public IList<Core.Business.WishingExtend> GetAllWishingExtend() { IList<Core.Business.WishingExtend> wishingExtendlist = new List<Core.Business.WishingExtend>(); SqlServerUtility sql = new SqlServerUtility(SqlConnection); SqlDataReader reader = sql.ExecuteSPReader("USP_WishingExtend_SelectAll"); if(reader != null) { while(reader.Read()) { Core.Business.WishingExtend wishingExtend = new Core.Business.WishingExtend(); if (!reader.IsDBNull(0)) wishingExtend.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) wishingExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) wishingExtend.ActivityId = reader.GetString(2); wishingExtend.MarkOld(); wishingExtendlist.Add(wishingExtend); } reader.Close(); } return wishingExtendlist; }
public Core.Business.WishingExtend Select(Int64 id) { SqlServerUtility sql = new SqlServerUtility(SqlConnection); sql.AddParameter("@Id", SqlDbType.BigInt, id); SqlDataReader reader = sql.ExecuteSPReader("USP_WishingExtend_Select_By_Id"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.WishingExtend wishingExtend = new Core.Business.WishingExtend(); if (!reader.IsDBNull(0)) wishingExtend.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) wishingExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) wishingExtend.ActivityId = reader.GetString(2); reader.Close(); return wishingExtend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }