Discuz.Data.SqlServer/PostManage.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;

namespace Discuz.Data.SqlServer
{
    public partial class DataProvider : IDataProvider
    {
        public string SearchTopicAudit(int fid, string poster, string title, string moderatorName, DateTime postDateTimeStart, DateTime postDateTimeEnd, DateTime delDateTimeStart, DateTime delDateTimeEnd)
        {
            StringBuilder sqlBuilder = new StringBuilder(" [displayorder]<0");

            if (fid != 0)
                sqlBuilder.AppendFormat(" AND [fid]={0}", fid);

            if (poster != "")
            {
                sqlBuilder.Append(" AND (");
                foreach (string postername in poster.Split(','))
                {
                    if (postername.Trim() != "")
                        sqlBuilder.AppendFormat(" [poster]='{0}'  OR", postername);
                }
                sqlBuilder = sqlBuilder.Remove(sqlBuilder.Length - 3, 3).Append(")");
            }

            if (title != "")
            {
                sqlBuilder.Append(" AND (");
                foreach (string titlename in title.Split(','))
                {
                    if (titlename.Trim() != "")
                        sqlBuilder.AppendFormat(" [title] LIKE '%{0}%' OR", RegEsc(titlename));
                }
                sqlBuilder = sqlBuilder.Remove(sqlBuilder.Length - 3, 3).Append(")");
            }

            if (moderatorName != "")
            {
                string logtidlist = "";
                DataTable dt = DatabaseProvider.GetInstance().GetModeratorLogByName(moderatorName);
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        logtidlist += dr["tid"].ToString() + ",";
                    }
                    sqlBuilder.AppendFormat(" AND tid IN ({0}) ", logtidlist.Substring(0, logtidlist.Length - 1));
                }
            }

            if (postDateTimeStart.ToString().IndexOf("1900") < 0)
                sqlBuilder.AppendFormat(" AND [postdatetime]>='{0}'", postDateTimeStart.ToString("yyyy-MM-dd HH:mm:ss"));