public int SetShow(Show m) { return ShowDao.SetShow(m); }
internal static void MapList(IRecord record, List<Show> list) { Show m = new Show(); m.ShowId = 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.ShowDate = record.GetDateTime(6); m.ShowPlace = record.GetStringOrEmpty(7); m.AddUserID = record.GetInt32OrDefault(8, 0); m.AddDate = record.GetDateTime(9); m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0)); m.EndDate = record.GetDateTime(11); list.Add(m); }
internal static int SetShow(Show m) { if (m == null) return -1; SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Show_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@ShowId", m.ShowId); 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("@ShowDate", m.ShowDate); parameters.AddWithValue("@EndDate", m.EndDate); parameters.AddWithValue("@ShowPlace", m.ShowPlace); parameters.AddWithValue("@AddUserId", m.AddUserID); parameters.AddWithValue("@Status", (int)(m.Status)); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { m.ShowId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return m.ShowId; }
internal static Show GetShow(int showId) { Show m = new Show(showId); if (showId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Show_Get", 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.ShowDate = record.GetDateTime(6); m.ShowPlace = record.GetStringOrEmpty(7); m.AddUserID = record.GetInt32OrDefault(8, 0); m.AddDate = record.GetDateTime(9); m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0)); m.EndDate = record.GetDateTime(11); }, showId); } return m; }