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