internal static News GetNews(int newsId ,int hits) { News m = new News(newsId); if (newsId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.News_Get", delegate(IRecord record) { m.Title = record.GetStringOrEmpty(1); m.Body = record.GetStringOrEmpty(2); m.Preview = record.GetStringOrEmpty(3); m.SImage = record.GetStringOrEmpty(4); m.LImage = record.GetStringOrEmpty(5); m.NewsType = record.GetInt32OrDefault(6, 0); m.Hits = record.GetInt32OrDefault(7, 0); m.PublishDate = record.GetDateTime(8); m.AddUserID = record.GetInt32OrDefault(9, 0); m.AddDate = record.GetDateTime(10); m.Status = (PublishStatus)(record.GetInt32OrDefault(11, 0)); m.Remark = record.GetStringOrEmpty(12); }, newsId,hits); } return m; }
internal static int SetNews(News m) { if (m == null) return -1; SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.News_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@NewsId", m.NewsId); parameters.AddWithValue("@Title", m.Title); parameters.AddWithValue("@Body", m.Body); parameters.AddWithValue("@Preview", m.Preview); parameters.AddWithValue("@SImage", m.SImage); parameters.AddWithValue("@LImage", m.LImage); parameters.AddWithValue("@NewsType", m.NewsType); parameters.AddWithValue("@Hits", m.Hits); parameters.AddWithValue("@PublishDate", m.PublishDate); parameters.AddWithValue("@AddUserId", m.AddUserID); parameters.AddWithValue("@Status", (int)(m.Status)); parameters.AddWithValue("@Remark", m.Remark); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { m.NewsId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return m.NewsId; }
internal static void MapList(IRecord record, List<News> list) { News m = new News(); m.NewsId = record.GetInt32OrDefault(0, 0); m.Title = record.GetStringOrEmpty(1); m.Body = record.GetStringOrEmpty(2); m.Preview = record.GetStringOrEmpty(3); m.SImage = record.GetStringOrEmpty(4); m.LImage = record.GetStringOrEmpty(5); m.NewsType = record.GetInt32OrDefault(6, 0); m.Hits = record.GetInt32OrDefault(7, 0); m.PublishDate = record.GetDateTime(8); m.AddUserID = record.GetInt32OrDefault(9, 0); m.AddDate = record.GetDateTime(10); m.Status = (PublishStatus)(record.GetInt32OrDefault(11, 0)); m.Remark = record.GetStringOrEmpty(12); list.Add(m); }
public int SetNews(News m) { return NewsDao.SetNews(m); }