Backup/Discuz.Data.SqlServer/UserManage.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;

using Discuz.Data;
using Discuz.Config;
using Discuz.Common;
using Discuz.Entity;
using Discuz.Common.Generic;

namespace Discuz.Data.SqlServer
{
    public partial class DataProvider : IDataProvider
    {
        private static int _lastRemoveTimeout;
        private static Dictionary<TrendType, int> stat = new Dictionary<TrendType, int>();
        private static DateTime lastTrendUpdateTime = DateTime.Now;

        static DataProvider()
        {
            Initial();
        }

        private static void Initial()
        {
            stat.Clear();
            stat.Add(TrendType.Login, 0);
            stat.Add(TrendType.Register, 0);
            stat.Add(TrendType.Topic, 0);
            stat.Add(TrendType.Poll, 0);
            stat.Add(TrendType.Bonus, 0);
            stat.Add(TrendType.Debate, 0);
            stat.Add(TrendType.Post, 0);
        }

        public DataTable GetUsers(string idList)
        {
            if (!Utils.IsNumericList(idList))
                return new DataTable();

            string commandText = string.Format("SELECT [uid],[username] FROM [{0}users] WHERE [groupid] IN ({1})",
                                                BaseConfigs.GetTablePrefix,
                                                idList);
            return DbHelper.ExecuteDatasetInMasterDB(CommandType.Text, commandText).Tables[0];
        }

        public DataTable GetUserGroupInfoByGroupid(int groupId)
        {
            string commandText = string.Format("SELECT TOP 1 {0} FROM  [{1}usergroups] WHERE [groupid]={2}",
                                                DbFields.USER_GROUPS,
                                                BaseConfigs.GetTablePrefix,
                                                groupId);
            return DbHelper.ExecuteDataset(CommandType.Text, commandText).Tables[0];
        }

        public DataTable GetMedal()
        {
            return DbHelper.ExecuteDataset(CommandType.Text, GetMedalSql()).Tables[0];