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 Comment GetComment(int commentId) { Comment c = new Comment(); if (commentId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Comment_Get", delegate(IRecord record) { c.CommentId = record.GetInt32OrDefault(0, 0); c.ObjectId = record.GetInt32OrDefault(1, 0); c.ObjectType = (ObjectTypeDefine)(record.GetInt32OrDefault(2, 0)); c.UserId = record.GetInt32OrDefault(3, 0); c.UserName = record.GetStringOrEmpty(4); c.AddDate = record.GetDateTime(5); c.Body = record.GetStringOrEmpty(6); c.Remark = record.GetStringOrEmpty(7); c.Status = (PublishStatus)(record.GetInt32OrDefault(8, 0)); }, commentId); } return(c); }
internal static ShopItem GetShopItem(int id, int hits) { ShopItem m = new ShopItem(id); if (id > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_Get", delegate(IRecord record) { m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.Description = record.GetStringOrEmpty(2); m.Price = record.GetDouble(3); m.SImage = record.GetStringOrEmpty(4); m.LImage = record.GetStringOrEmpty(5); m.PublishDate = record.GetDateTimeOrEmpty(6); m.AddUserID = record.GetInt32OrDefault(7, 0); m.AddDate = record.GetDateTime(8); m.Status = (PublishStatus)(record.GetInt32OrDefault(9, 0)); m.Body = record.GetStringOrEmpty(10); m.Hits = record.GetInt32OrDefault(11, 0); m.BaseCountEachdeliver = record.GetInt32OrDefault(12, 5); m.Weight = record.GetDouble(13); }, id, hits); } return(m); }
internal static Dictionary <int, int> GetComments20(List <int> oIds, int objectType) { Dictionary <int, int> dic = new Dictionary <int, int>(); if (oIds != null && oIds.Count > 0) { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Comment_GetCmments20", delegate(IParameterSet parameters) { parameters.AddWithValue("@ObjectType", objectType); int maxCount = oIds.Count > 20 ? 20 : oIds.Count; for (int i = 0; i < maxCount; i++) { parameters.AddWithValue("@id" + (i + 1).ToString(), oIds[i]); } }, delegate(IRecord record) { int commentCount = record.GetInt32OrDefault(0, 0); int objectId = record.GetInt32OrDefault(1, 0); if (!dic.ContainsKey(objectId)) { dic.Add(objectId, commentCount); } } ); } return(dic); }
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 List <MusicTitle> GetPagedMusicTitlesByBandIdANDPublishYear(PagingContext pager, int bandId, int publishYear, int publishStatus) { List <MusicTitle> list = new List <MusicTitle>(pager.RecordsPerPage); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_GetPagedMusicTitleByBandIdANDPublishYear", delegate(IParameterSet parameters) { parameters.AddWithValue("@PublishYear", publishYear); parameters.AddWithValue("@BandId", bandId); parameters.AddWithValue("@PublishStatus", publishStatus); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapMusicTitleList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
internal static Dictionary <int, Tag> GetTags20(List <int> tagIds) { Dictionary <int, Tag> dic = new Dictionary <int, Tag>(); if (tagIds != null && tagIds.Count > 0) { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Tags_GetTags20", delegate(IParameterSet parameters) { int maxCount = tagIds.Count > 20 ? 20 : tagIds.Count; for (int i = 0; i < maxCount; i++) { parameters.AddWithValue("@tid" + (i + 1).ToString(), tagIds[i]); } }, delegate(IRecord record) { Tag tag = new Tag(); tag.TagId = record.GetInt32OrDefault(0, 0); tag.TagName = record.GetStringOrEmpty(1); tag.Hits = record.GetInt32OrDefault(2, 0); tag.AddUserID = record.GetInt32OrDefault(3, 0); tag.AddDate = record.GetDateTime(4); if (!dic.ContainsKey(tag.TagId)) { dic.Add(tag.TagId, tag); } } ); } return(dic); }
internal static List <Tag> GetPagedTags(PagingContext pager) { List <Tag> list = new List <Tag>(pager.RecordsPerPage); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.GetPagedTags", delegate(IParameterSet parameters) { parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { Tag tag = new Tag(); tag.TagId = record.GetInt32OrDefault(0, 0); tag.TagName = record.GetStringOrEmpty(1); tag.Hits = record.GetInt32OrDefault(2, 0); tag.AddUserID = record.GetInt32OrDefault(3, 0); tag.AddDate = record.GetDateTime(4); list.Add(tag); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
internal static List <SpamKeyword> GetPagedSpamKeywords(PagingContext pager) { List <SpamKeyword> list = new List <SpamKeyword>(pager.RecordsPerPage); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.SpamKeywords_GetPaged", delegate(IParameterSet parameters) { //parameters.AddWithValue("@PublishStatus", publishStatus); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
internal static List <ShopTradelist> GetPagedTradelist(PagingContext pager, int orderid) { List <ShopTradelist> list = new List <ShopTradelist>(pager.RecordsPerPage); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_tradelist_GetPaged", delegate(IParameterSet parameters) { parameters.AddWithValue("@orderid", orderid); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
internal static Album GetAlbum(int albumId) { Album m = new Album(albumId); if (albumId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Album_Get", delegate(IRecord record) { m.Title = record.GetStringOrEmpty(1); m.BandId = record.GetInt32OrDefault(2, 0); m.PublishDate = record.GetDateTime(3); m.PublishYear = record.GetInt32OrDefault(4, 0); m.PublishMonth = record.GetInt32OrDefault(5, 0); m.AddUserID = record.GetInt32OrDefault(6, 0); m.AddDate = record.GetDateTime(7); m.Status = (PublishStatus)(record.GetInt32OrDefault(8, 0)); m.TotalCount = record.GetInt32OrDefault(9, 0); m.SImage = record.GetStringOrEmpty(10); m.LImage = record.GetStringOrEmpty(11); }, albumId); } return(m); }
internal static List <ShopItem> GetPagedShopItemByPublishDate(PagingContext pager, int publishStatus, DateTime sTime, DateTime eTime) { List <ShopItem> list = new List <ShopItem>(pager.RecordsPerPage); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_GetPagedByPublishDate", delegate(IParameterSet parameters) { parameters.AddWithValue("@STime", sTime); parameters.AddWithValue("@ETime", eTime); parameters.AddWithValue("@PublishStatus", publishStatus); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
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); }
internal static ShopOrder GetShopOrder(int id) { ShopOrder m = new ShopOrder(id); if (id > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_orders_Get", delegate(IRecord record) { m.Id = record.GetInt32OrDefault(0, 0); m.UserId = record.GetInt32OrDefault(1, 0); m.AddDate = record.GetDateTimeOrEmpty(2); m.Ordertype = (OrderType)(record.GetInt32OrDefault(3, 0)); m.Address = record.GetStringOrEmpty(4); m.Email = record.GetStringOrEmpty(5); m.Mobile = record.GetStringOrEmpty(6); m.Paymoney = record.GetDouble(7); m.Paytype = (PayType)(record.GetInt32OrDefault(8, 0)); m.Payresult = (PayResult)(record.GetInt32OrDefault(9, 0)); m.Payremark = record.GetStringOrEmpty(10); m.Paythirdnum = record.GetStringOrEmpty(11); m.Paydate = record.GetDateTime(12); m.ZipCode = record.GetStringOrEmpty(13); m.UserName = record.GetStringOrEmpty(14); m.RegionId = record.GetInt32OrDefault(15, 0); m.Freight = record.GetDouble(16); m.RegionStr = record.GetStringOrEmpty(17); }, id); } return(m); }
internal static List <News> GetPagedNewsByTypeANDPublishDate(PagingContext pager, int newsType, DateTime sTime, DateTime eTime, int publishStatus, int newsRemarkType) { List <News> list = new List <News>(pager.RecordsPerPage); if (newsRemarkType == -1) { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.News_GetPagedByNewsTypeAndPublishDate", delegate(IParameterSet parameters) { parameters.AddWithValue("@NewsType", newsType); parameters.AddWithValue("@STime", sTime); parameters.AddWithValue("@ETime", eTime); parameters.AddWithValue("@PublishStatus", publishStatus); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); } else { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.News_GetPagedByNewsTypeAndPublishDateV2", delegate(IParameterSet parameters) { parameters.AddWithValue("@RemarkType", newsRemarkType); parameters.AddWithValue("@NewsType", newsType); parameters.AddWithValue("@STime", sTime); parameters.AddWithValue("@ETime", eTime); parameters.AddWithValue("@PublishStatus", publishStatus); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapList(record, list); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); } return(list); }
internal static List <SearchResult> GetPagedSearch(PagingContext pager, string searchText, ObjectTypeDefine objectType) { List <SearchResult> list = new List <SearchResult>(pager.RecordsPerPage); string SearchSp = string.Empty; switch (objectType) { case ObjectTypeDefine.Show: SearchSp = "dbo.Search_GetPagedShow"; break; case ObjectTypeDefine.MusicTitle: case ObjectTypeDefine.Song: SearchSp = "dbo.Search_GetPagedMusic"; break; case ObjectTypeDefine.Album: case ObjectTypeDefine.Image: SearchSp = "dbo.Search_GetPagedAlbum"; break; case ObjectTypeDefine.Video: SearchSp = "dbo.Search_GetPagedVideoNews"; break; case ObjectTypeDefine.News: SearchSp = "dbo.Search_GetPagedNews"; break; default: return(list); } SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), SearchSp, delegate(IParameterSet parameters) { parameters.AddWithValue("@SearchTxt", searchText); parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber); parameters.AddWithValue("@PageSize", pager.RecordsPerPage); parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output); }, delegate(IRecord record) { MapSeachResultList(record, list, objectType); }, delegate(IParameterSet outputParameters) { pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount"); } ); return(list); }
static void Main(string[] args) { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase("MyTest"), "dbo.GetMyTest", delegate(IRecord record) { Trace.WriteLine(record.GetStringOrEmpty(0)); Trace.WriteLine(record.GetInt32(1)); Trace.WriteLine(record.GetStringOrEmpty(2)); Trace.WriteLine("---------------record-----------------"); }, "test");//Copy conn.config to build path }
internal static List <Show> GetShowTagRelation(int currentId, int maxCount) { List <Show> list = new List <Show>(maxCount); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Show_GetTagRelation", delegate(IRecord record) { MapList(record, list); }, currentId, maxCount ); return(list); }
internal static List <Show> GetShowPreviousNext(int currentId) { List <Show> list = new List <Show>(2); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Show_GetPreviousNext", delegate(IRecord record) { MapList(record, list); }, currentId ); return(list); }
/// <summary> /// 获取tag的top列表 /// </summary> /// <param name="maxCount"></param> /// <returns></returns> internal static List <SpamKeyword> GetAllSpamKeywords() { List <SpamKeyword> list = new List <SpamKeyword>(); SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.SpamKeywords_GetAll", delegate(IRecord record) { MapList(record, list); }, null); return(list); }
/* * USE [newbbs] * GO * SET ANSI_NULLS ON * GO * SET QUOTED_IDENTIFIER ON * GO * * CREATE PROCEDURE [newbbs].[dnt_getuidbyusername] * @username nchar(20) * AS * SELECT TOP 1 [uid] FROM [dnt_users] WHERE [username]=@username */ internal static int GetUserIdByUserName(string username) { int uid = -1; SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.JaneBBSDBInstanceName), "newbbs.dnt_getuidbyusername", delegate(IRecord record) { uid = record.GetInt32OrDefault(0, 0); }, username); return(uid); }
internal static List <BandInfo> GetAllBandInfo(int minIndex) { List <BandInfo> list = new List <BandInfo>(); SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.BandInfo_GetAll", delegate(IRecord record) { MapImageList(record, list); }, minIndex); return(list); }
internal static List <Image> GetImagesByAlbumId(int albumId, int publishStatus) { List <Image> list = new List <Image>(); if (albumId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Image_GetByAlbumId", delegate(IRecord record) { MapImageList(record, list); }, publishStatus, albumId); } return(list); }
internal static List <ShopTradelist> GetShopTradelistByOrderId(int orderid) { List <ShopTradelist> list = new List <ShopTradelist>(); if (orderid > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_tradelist_Getbyorderid", delegate(IRecord record) { MapList(record, list); }, orderid); } return(list); }
internal static List <MusicSongList> GetMusicSongListByMusicId(int musicId, int publishStatus) { List <MusicSongList> list = new List <MusicSongList>(); if (musicId > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_GetMusicSongListByMusicId", delegate(IRecord record) { MapMusicSongList(record, list); }, publishStatus, musicId); } return(list); }
internal static List <ShopRegion> GetShopRegionsByParentId(int parentId) { List <ShopRegion> list = new List <ShopRegion>(); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_region_GetByParentId", delegate(IParameterSet parameters) { parameters.AddWithValue("@ParentId", parentId); }, delegate(IRecord record) { MapList(record, list); } ); return(list); }
/// <summary> /// 获取已发布商品根据最大点击数倒序排列的商品信息 /// </summary> /// <param name="maxCount"></param> /// <returns></returns> internal static List <ShopItem> GetTopPublishedShopItemsOrderByHits(int maxCount) { List <ShopItem> list = new List <ShopItem>(maxCount); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_GetTopPublishedShopItemsOrderByHits", delegate(IParameterSet parameters) { parameters.AddWithValue("@MaxCount", maxCount); }, delegate(IRecord record) { MapList(record, list); } ); return(list); }
internal static List <BandInfo> GetAllBandInfos(int minIndex) { List <BandInfo> list = new List <BandInfo>(); SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.BandInfo_GetAll", delegate(IParameterSet parameters) { parameters.AddWithValue("@MinIndex", minIndex); }, delegate(IRecord record) { MapBandInfoList(record, list); } ); return(list); }
internal static DiscuzPasswordAuthInfo GetPasswordAuthInfo(string username, string password, bool originalpassword) { DiscuzPasswordAuthInfo p = new DiscuzPasswordAuthInfo(); SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.JaneBBSDBInstanceName), "newbbs.dnt_checkpasswordbyusername", delegate(IRecord record) { p.Uid = record.GetInt32OrDefault(0, 0); p.Groupid = record.GetInt16OrDefault(1, 0); p.Adminid = record.GetInt32OrDefault(2, 0); }, username, originalpassword ? Utils.MD5(password) : password); return(p); }
internal static DiscuzUserInfo GetUserInfo(int uid) { DiscuzUserInfo m = new DiscuzUserInfo(); if (uid > 0) { m.Uid = uid; SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(D4DDefine.JaneBBSDBInstanceName), "newbbs.dnt_getuserinfo", delegate(IRecord record) { MapUserInfo(record, m); }, uid); } return(m); }