public static SAS.Common.Generic.List<PhotoInfo> GetPhotosWithSameTag(int tagid, int pageid, int pagesize) { IDataReader reader = Data.DbProvider.GetInstance().GetPhotosWithSameTag(tagid, pageid, pagesize); SAS.Common.Generic.List<PhotoInfo> photolist = new SAS.Common.Generic.List<PhotoInfo>(); while (reader.Read()) { photolist.Add(GetPhotoEntity(reader)); } reader.Close(); return photolist; }
/// <summary> /// 返回在线用户列表 /// </summary> /// <param name="forumid">版块id</param> /// <returns></returns> public static List<OnlineUserInfo> GetForumOnlineUserCollection(int forumid) { SAS.Common.Generic.List<OnlineUserInfo> coll = new SAS.Common.Generic.List<OnlineUserInfo>(); IDataReader reader = DatabaseProvider.GetInstance().GetForumOnlineUserList(forumid); while (reader.Read()) { OnlineUserInfo info = LoadSingleOnlineUser(reader); coll.Add(info); } reader.Close(); //返回当前版块的在线用户表 return coll; }
public static SAS.Common.Generic.List<PhotoInfo> GetSpacePhotosInfo(DataTable dt) { if (dt == null || dt.Rows.Count == 0) return new SAS.Common.Generic.List<PhotoInfo>(); SAS.Common.Generic.List<PhotoInfo> photosinfoarray = new SAS.Common.Generic.List<PhotoInfo>(); for (int i = 0; i < dt.Rows.Count; i++) { PhotoInfo photo = new PhotoInfo(); photo.Photoid = TypeConverter.ObjectToInt(dt.Rows[i]["photoid"]); photo.Filename = dt.Rows[i]["filename"].ToString(); photo.Attachment = dt.Rows[i]["attachment"].ToString(); photo.Filesize = TypeConverter.ObjectToInt(dt.Rows[i]["filesize"]); photo.Description = dt.Rows[i]["description"].ToString(); photo.Postdate = dt.Rows[i]["postdate"].ToString(); photo.Albumid = TypeConverter.ObjectToInt(dt.Rows[i]["albumid"]); photo.Userid = TypeConverter.ObjectToInt(dt.Rows[i]["userid"]); photo.Title = dt.Rows[i]["title"].ToString(); photo.Views = TypeConverter.ObjectToInt(dt.Rows[i]["views"]); photo.Commentstatus = (PhotoStatus)TypeConverter.ObjectToInt(dt.Rows[i]["commentstatus"]); photo.Tagstatus = (PhotoStatus)TypeConverter.ObjectToInt(dt.Rows[i]["tagstatus"]); photo.Comments = TypeConverter.ObjectToInt(dt.Rows[i]["comments"]); photosinfoarray.Add(photo); } dt.Dispose(); return photosinfoarray; }
/// <summary> /// 返回在线用户列表 /// </summary> public static List<OnlineUserInfo> GetOnlineUserCollection() { SAS.Common.Generic.List<OnlineUserInfo> coll = new SAS.Common.Generic.List<OnlineUserInfo>(); IDataReader reader = DatabaseProvider.GetInstance().GetOnlineUserList(); while (reader.Read()) { OnlineUserInfo onlineUserInfo = LoadSingleOnlineUser(reader); if (onlineUserInfo.Ol_ps_id > 0 || (onlineUserInfo.Ol_ps_id == -1 && GeneralConfigs.GetConfig().Whosonlinecontract == 0)) { onlineUserInfo.Ol_actionname = UserAction.GetActionDescriptionByID((int)(onlineUserInfo.Ol_action)); coll.Add(onlineUserInfo); } } reader.Close(); //返回当前版块的在线用户表 return coll; }