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; }
public Core.Business.PictureExtend Select(Int64 id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.BigInt, id); SqlDataReader reader = sql.ExecuteSPReader("USP_PictureExtend_Select_By_Id"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.PictureExtend pictureExtend = new Core.Business.PictureExtend(); if (!reader.IsDBNull(0)) pictureExtend.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) pictureExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) pictureExtend.ActivityId = reader.GetString(2); reader.Close(); return pictureExtend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }