Пример #1
0
        /// <summary>
        /// 获取指定主题的给分记录
        /// </summary>
        /// <param name="tid">主题Id</param>
        /// <returns></returns>
        public static Dictionary <int, BonusLogInfo> GetLogsForEachPost(int tid)
        {
            IDataReader reader = DatabaseProvider.GetInstance().GetTopicBonusLogsByPost(tid);
            Dictionary <int, BonusLogInfo> blis = new Dictionary <int, BonusLogInfo>();

            while (reader.Read())
            {
                BonusLogInfo bli = new BonusLogInfo();
                bli.Pid       = Utils.StrToInt(reader["pid"], 0);
                bli.Bonus     = Utils.StrToInt(reader["bonus"], 0);
                bli.Isbest    = Utils.StrToInt(reader["isbest"], 0);
                bli.Extid     = (byte)reader["extid"];
                blis[bli.Pid] = bli;
            }
            reader.Close();
            return(blis);
        }
Пример #2
0
        /// <summary>
        /// 获取指定主题的给分记录
        /// </summary>
        /// <param name="tid">主题ID</param>
        /// <returns>悬赏日志集合</returns>
        public static List <BonusLogInfo> GetLogs(int tid)
        {
            IDataReader         reader = DatabaseProvider.GetInstance().GetTopicBonusLogs(tid);
            List <BonusLogInfo> blis   = new List <BonusLogInfo>();

            while (reader.Read())
            {
                BonusLogInfo bli = new BonusLogInfo();
                bli.Tid        = TypeConverter.ObjectToInt(reader["tid"], 0);
                bli.Answerid   = TypeConverter.ObjectToInt(reader["answerid"], 0);
                bli.Authorid   = TypeConverter.ObjectToInt(reader["authorid"], 0);
                bli.Answername = reader["answername"].ToString();
                bli.Bonus      = TypeConverter.ObjectToInt(reader["bonus"], 0);
                bli.Extid      = Convert.ToByte(reader["extid"]);
                blis.Add(bli);
            }
            reader.Close();
            return(blis);
        }