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