Discuz.Data.SqlServer/DataProvider.cs

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

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

#if NET1

using System;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using System.Data;
using System.Data.SqlClient;
using Discuz.Data;
using Discuz.Config;
using Discuz.Common;
using Discuz.Entity;
using SQLDMO;

namespace Discuz.Data.SqlServer
{
	/// <summary>
	/// DataProvider 的摘要说明。
	/// </summary>
	public class DataProvider: IDataProvider
	{
		
		#region ForumManage

		/// <summary>
		/// SQL SERVER SQL语句转义
		/// </summary>
		/// <param name="str">需要转义的关键字符串</param>
		/// <param name="pattern">需要转义的字符数组</param>
		/// <returns>转义后的字符串</returns>
		private static string RegEsc(string str)
		{
			string[] pattern ={ @"%", @"_", @"'" };
			foreach (string s in pattern)
			{
				//Regex rgx = new Regex(s);
				//keyword = rgx.Replace(keyword, "\\" + s);
				switch (s)
				{
					case "%":
						str = str.Replace(s, "[%]");
						break;
					case "_":
						str = str.Replace(s, "[_]");
						break;
					case "'":
						str = str.Replace(s, "['']");
						break;

				}

			}
			return str;
		}
		/// <summary>
		/// 添加友情链接
		/// </summary>
		/// <param name="displayorder">显示顺序</param>
		/// <param name="name">名称</param>
		/// <param name="url">链接地址</param>