MyModels/ExtClass.cs

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

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

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.Linq;
using System.Data.SqlClient;
using System.Diagnostics;
using System.IO.Pipes;
using System.Linq;
using System.Net.Sockets;
using System.Runtime.CompilerServices;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.Configuration;
using ExeSql;
using MyModels.Db;
using Ex=Microsoft.Office.Interop.Excel;
using COMM;
namespace MyModels
{
    // liuyu 扩展
    public class GLO
    {
        public static string SqlSafeString(string sqlValue)
        {
            System.Text.RegularExpressions.Regex regex = new Regex("\x27+");
            System.Text.StringBuilder resultBuilder = new StringBuilder();
            bool b = regex.IsMatch(sqlValue);
            if (b)
            {
                MatchCollection mc = regex.Matches(sqlValue);
                GroupCollection gc = regex.Match(sqlValue).Groups;
                int start = 0;
                Match lastMatch = null;
                foreach (Match m in mc)
                {
                    lastMatch = m;
                    string captureValue = m.Value;
                    resultBuilder.Append(sqlValue.Substring(start, m.Index - start));
                    if (captureValue.Length % 2 == 0) resultBuilder.Append(captureValue);
                    else resultBuilder.Append(captureValue + "'");
                    start = m.Index + captureValue.Length;
                }
                if (lastMatch != null)
                {
                    if (lastMatch.Index + lastMatch.Value.Length < sqlValue.Length)
                    {
                        resultBuilder.Append(sqlValue.Substring(lastMatch.Index + lastMatch.Value.Length,
                            (sqlValue.Length - lastMatch.Index - lastMatch.Value.Length)));
                    }
                }
            }
            else return sqlValue;
            return resultBuilder.ToString();

        }
    }
    /// <summary>
    /// 商品类型