internal static MusicTitle GetMusicTitle(int musicId)
{
MusicTitle m = new MusicTitle(musicId);
if (musicId > 0)
{
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Music_GetMusicTitle",
delegate(IRecord record)
{
m.Title = record.GetStringOrEmpty(1);
m.Body = record.GetStringOrEmpty(2);
m.SImage = record.GetStringOrEmpty(3);
m.LImage = record.GetStringOrEmpty(4);
m.BandId = record.GetInt32OrDefault(5, 0);
m.PublishDate = record.GetDateTime(6);
m.PublishYear = record.GetInt32OrDefault(7, 0);
m.AddUserID = record.GetInt32OrDefault(8, 0);
m.AddDate = record.GetDateTime(9);
m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0));
},
musicId);
}
return m;
}
internal static void MapMusicTitleList(IRecord record, List<MusicTitle> list)
{
MusicTitle m = new MusicTitle();
m.MusicId = record.GetInt32OrDefault(0, 0);
m.Title = record.GetStringOrEmpty(1);
m.Body = record.GetStringOrEmpty(2);
m.SImage = record.GetStringOrEmpty(3);
m.LImage = record.GetStringOrEmpty(4);
m.BandId = record.GetInt32OrDefault(5, 0);
m.PublishDate = record.GetDateTime(6);
m.PublishYear = record.GetInt32OrDefault(7, 0);
m.AddUserID = record.GetInt32OrDefault(8, 0);
m.AddDate = record.GetDateTime(9);
m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0));
list.Add(m);
}
internal static int SetMusicTitle(MusicTitle m)
{
if (m == null) return -1;
SafeProcedure.ExecuteNonQuery(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Music_SetMusicTitle",
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@MusicId", m.MusicId);
parameters.AddWithValue("@Title", m.Title);
parameters.AddWithValue("@Body", m.Body);
parameters.AddWithValue("@SImage", m.SImage);
parameters.AddWithValue("@LImage", m.LImage);
parameters.AddWithValue("@BandId", m.BandId);
parameters.AddWithValue("@PublishDate", m.PublishDate);
parameters.AddWithValue("@PublishYear", m.PublishYear);
parameters.AddWithValue("@AddUserId", m.AddUserID);
parameters.AddWithValue("@Status", (int)(m.Status));
parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue);
},
delegate(IParameterSet outputParameters)
{
m.MusicId = Convert.ToInt32(outputParameters.GetValue("@RetVal"));
});
return m.MusicId;
}
public int SetMusicTitle(MusicTitle m)
{
if (m == null) return -1;
if (m.PublishYear <= 1900 && m.PublishDate != null)
m.PublishYear = m.PublishDate.Year;
return MusicDao.SetMusicTitle(m);
}
