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;
}
}
