public IList<CY.UME.Core.Business.PictureExtend> GetActivityPicture(long accountId, string activityId,string activityPicId)
{
IList<Core.Business.PictureExtend> pictureExtendlist = new List<Core.Business.PictureExtend>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@AccountId", SqlDbType.BigInt, accountId);
sql.AddParameter("@ActivityId", SqlDbType.NVarChar, activityId);
sql.AddParameter("@ActivityPicId", SqlDbType.NVarChar, activityPicId);
SqlDataReader reader = sql.ExecuteSPReader("USP_PictureExtend_Select_By_AccountId_And_ActivityId_And_ActivityPicId");
if (reader != null)
{
while (reader.Read())
{
Core.Business.PictureExtend pictureExtend = new Core.Business.PictureExtend();
long Id = 0;
if (!reader.IsDBNull(0)) Id = reader.GetInt64(0);
pictureExtend = CY.UME.Core.Business.PictureExtend.Load(Id);
pictureExtend.MarkOld();
pictureExtendlist.Add(pictureExtend);
}
reader.Close();
}
return pictureExtendlist;
}
public IList<Core.Business.PictureExtend> GetAllPictureExtend()
{
IList<Core.Business.PictureExtend> pictureExtendlist = new List<Core.Business.PictureExtend>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_PictureExtend_SelectAll");
if(reader != null)
{
while(reader.Read())
{
Core.Business.PictureExtend pictureExtend = new Core.Business.PictureExtend();
long Id = 0;
if (!reader.IsDBNull(0)) Id = reader.GetInt64(0);
pictureExtend = CY.UME.Core.Business.PictureExtend.Load(Id);
pictureExtend.MarkOld();
pictureExtendlist.Add(pictureExtend);
}
reader.Close();
}
return pictureExtendlist;
}