Data/DataUtils.cs

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

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

/*
 * Author: Kishore Reddy
 * Url: http://commonlibrarynet.codeplex.com/
 * Title: CommonLibrary.NET
 * Copyright: � 2009 Kishore Reddy
 * License: LGPL License
 * LicenseUrl: http://commonlibrarynet.codeplex.com/license
 * Description: A C# based .NET 3.5 Open-Source collection of reusable components.
 * Usage: Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Reflection;
using System.Collections.Specialized;
using System.Collections;


namespace ComLib.Data
{
    /// <summary>
    /// Database / table related utility functions.
    /// </summary>
    public class DataUtils
    {
        /// <summary>
        /// Encode the text for single quotes.
        /// </summary>
        /// <param name="text"></param>
        /// <returns></returns>
        public static string Encode(string text)
        {
            if (string.IsNullOrEmpty(text)) return text;

            return text.Replace("'", "''");
        }


        /// <summary>
        /// Builds a column name excluding potentially unsafe characters.
        /// </summary>
        /// <param name="column"></param>
        /// <returns></returns>
        public static string BuildSafeColumn(string column)
        {
            if (string.IsNullOrEmpty(column))
                return column;

            string finalname = "";
            for (int ndx = 0; ndx < column.Length; ndx++)
                if (Char.IsLetterOrDigit(column[ndx]))
                    finalname += column[ndx];

            return finalname;
        }