Backup/Discuz.Data/DataProvider/Debates.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Text;
using System.Data;

using Discuz.Entity;
using Discuz.Common;
using Discuz.Common.Generic;

namespace Discuz.Data
{
    public class Debates
    {
        /// <summary>
        /// 增加辩论主题扩展信息
        /// </summary>
        /// <param name="debatetopic"></param>
        public static void CreateDebateTopic(DebateInfo debateInfo)
        {
            //debatetopic = ReviseDebateTopicColor(debatetopic);
            DatabaseProvider.GetInstance().CreateDebateTopic(debateInfo);
        }

        /// <summary>
        /// 获取帖子观点
        /// </summary>
        /// <param name="tid">主题ID</param>
        /// <returns>Dictionary泛型</returns>
        public static Dictionary<int, int> GetPostDebateList(int tid)
        {            
            IDataReader reader = DatabaseProvider.GetInstance().GetPostDebate(tid);
            Dictionary<int, int> debateList = new Dictionary<int, int>();

            while (reader.Read())
            {
                debateList.Add(TypeConverter.ObjectToInt(reader["pid"], 0), TypeConverter.ObjectToInt(reader["opinion"], 0));
            }
            reader.Close();
            return debateList;
        }


        /// <summary>
        /// 获取辩论的扩展信息
        /// </summary>
        /// <param name="tid">主题ID</param>
        /// <returns>辩论主题扩展信息</returns>
        public static DebateInfo GetDebateTopic(int tid)
        {            
            IDataReader debatetopic = DatabaseProvider.GetInstance().GetDebateTopic(tid);
            DebateInfo topicexpand = new DebateInfo();
            if (debatetopic.Read())
            {
                topicexpand.Positiveopinion = debatetopic["positiveopinion"].ToString();
                topicexpand.Negativeopinion = debatetopic["negativeopinion"].ToString();
                topicexpand.Terminaltime = DateTime.Parse(debatetopic["terminaltime"].ToString());
                topicexpand.Positivediggs = TypeConverter.ObjectToInt(debatetopic["positivediggs"]);
                topicexpand.Negativediggs = TypeConverter.ObjectToInt(debatetopic["negativediggs"]);
                topicexpand.Tid = tid;
            }
            debatetopic.Close();