示例#1
0
 internal static Album GetAlbum(int albumId)
 {
     Album m = new Album(albumId);
     if (albumId > 0)
     {
         SafeProcedure.ExecuteAndMapRecords(
                 Database.GetDatabase(D4DDefine.DBInstanceName),
              "dbo.Album_Get",
              delegate(IRecord record)
              {
                  m.Title = record.GetStringOrEmpty(1);
                  m.BandId = record.GetInt32OrDefault(2,0);
                  m.PublishDate = record.GetDateTime(3);
                  m.PublishYear = record.GetInt32OrDefault(4,0);
                  m.PublishMonth = record.GetInt32OrDefault(5, 0);
                  m.AddUserID= record.GetInt32OrDefault(6,0);
                  m.AddDate = record.GetDateTime(7);
                  m.Status = (PublishStatus)(record.GetInt32OrDefault(8, 0));
                  m.TotalCount = record.GetInt32OrDefault(9,0);
                  m.SImage = record.GetStringOrEmpty(10);
                  m.LImage = record.GetStringOrEmpty(11);
              },
              albumId);
     }
     return m;
 }
示例#2
0
        public int SetAlbum(Album album)
        {
            if (album == null) return -1;

            if (album.PublishDate != null)
            {
                if (album.PublishYear <= 1900)
                    album.PublishYear = album.PublishDate.Year;

                if (album.PublishMonth <= 0 || album.PublishMonth > 12)
                    album.PublishMonth = album.PublishDate.Month;
            }

            if (album.PublishMonth <= 0) album.PublishMonth = 1;

            return AlbumDao.SetAlbum(album);
        }
示例#3
0
        internal static int SetAlbum(Album album)
        {
            if (album == null) return -1;

            SafeProcedure.ExecuteNonQuery(
             Database.GetDatabase(D4DDefine.DBInstanceName),
             "dbo.Album_Set",
             delegate(IParameterSet parameters)
             {
                 parameters.AddWithValue("@AlbumId", album.AlbumId);
                 parameters.AddWithValue("@Title", album.Title);
                 parameters.AddWithValue("@SImage", album.SImage);
                 parameters.AddWithValue("@LImage", album.LImage);
                 parameters.AddWithValue("@BandId", album.BandId);
                 parameters.AddWithValue("@PublishDate", album.PublishDate);
                 parameters.AddWithValue("@PublishYear", album.PublishYear);
                 parameters.AddWithValue("@PublishMonth", album.PublishMonth);
                 parameters.AddWithValue("@AddUserId", album.AddUserID);
                 parameters.AddWithValue("@Status", (int)(album.Status));
                 parameters.AddWithValue("@TotalCount", album.TotalCount);
                 parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue);

             },
             delegate(IParameterSet outputParameters)
             {
                 album.AlbumId = Convert.ToInt32(outputParameters.GetValue("@RetVal"));
             });

            return album.AlbumId;
        }
示例#4
0
        internal static void MapAlbumList(IRecord record, List<Album> list)
        {
            Album m = new Album();
            m.AlbumId = record.GetInt32OrDefault(0, 0);
            m.Title = record.GetStringOrEmpty(1);
            m.BandId = record.GetInt32OrDefault(2, 0);
            m.PublishDate = record.GetDateTime(3);
            m.PublishYear = record.GetInt32OrDefault(4, 0);
            m.PublishMonth = record.GetInt32OrDefault(5, 0);
            m.AddUserID = record.GetInt32OrDefault(6, 0);
            m.AddDate = record.GetDateTime(7);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(8, 0));
            m.TotalCount = record.GetInt32OrDefault(9, 0);
            m.SImage = record.GetStringOrEmpty(10);
            m.LImage = record.GetStringOrEmpty(11);

            list.Add(m);
        }