Backup/Discuz.Data.SqlServer/GlobalManage.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 System.Text.RegularExpressions;
using SQLDMO;
using System.Collections.Generic;

namespace Discuz.Data.SqlServer
{
    public partial class DataProvider : IDataProvider
    {
        private string GetSqlstringByPostDatetime(string commandText, DateTime postdatetimeStart, DateTime postdatetimeEnd)
        {
            //日期需要改成参数，以后需要重构！需要先修改后台传递参数方式
            if (!Utils.StrIsNullOrEmpty(postdatetimeStart.ToString()))
                commandText += string.Format(" AND [postdatetime]>='{0}'", postdatetimeStart.ToString("yyyy-MM-dd HH:mm:ss"));

            if (!Utils.StrIsNullOrEmpty(postdatetimeEnd.ToString()))
                commandText += string.Format(" AND [postdatetime]<='{0}'", postdatetimeEnd.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss"));

            return commandText;
        }


        public DataTable GetAdsTable()
        {
            string commandText = string.Format("SELECT [advid], [type], [displayorder], [targets], [parameters], [code] FROM [{0}advertisements] WHERE [available]=1 AND [starttime] <='{1}' AND [endtime] >='{1}' ORDER BY [displayorder], [advid] DESC",
                                                BaseConfigs.GetTablePrefix,
                                                DateTime.Now.ToString("yyyy-MM-dd"));
            return DbHelper.ExecuteDatasetInMasterDB(CommandType.Text, commandText).Tables[0];
        }

        /// <summary>
        /// 获得全部指定时间段内的前n条公告列表
        /// </summary>
        /// <param name="maxCount">最大记录数,小于0返回全部</param>
        /// <returns>公告列表</returns>
        public DataTable GetAnnouncementList(int maxCount)
        {
            DbParameter param = DbHelper.MakeInParam("@now", (DbType)SqlDbType.DateTime, 8, DateTime.Now);
            string commandText = string.Format("SELECT {0} {1} FROM [{2}announcements] WHERE [starttime] <=@now AND [endtime] >=@now ORDER BY [displayorder], [id] DESC",
                                              maxCount < 0 ? "" : " TOP " + maxCount,
                                              DbFields.ANNOUNCEMENTS,
                                              BaseConfigs.GetTablePrefix);
            return DbHelper.ExecuteDatasetInMasterDB(CommandType.Text, commandText, param).Tables[0];
        }


        public int CreateAnnouncement(AnnouncementInfo announcementInfo)
        {
            DbParameter[] parms = {
                                        DbHelper.MakeInParam("@poster", (DbType)SqlDbType.NVarChar, 20, announcementInfo.Poster),