SX-SJCL/SqlSugar/Json2Sql/Utils/Json2SqlHelper.cs

using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Text;
using System.Text.RegularExpressions;
using System.Linq;
namespace SqlSugar
{
    internal class Json2SqlHelper
    {
        public  static bool IsSqlValue(string valueString)
        {
            return Regex.IsMatch(valueString, @"^\{\w{1,10}\}\:");
        }
        public static string GetType(string valueString)
        {
            return Regex.Match(valueString, @"^\{(\w+)\}\:").Groups[1].Value;
        }
        public static string GetValue(string valueString)
        {
            return Regex.Replace(valueString, @"^\{\w{1,10}\}\:", "");
        }

        public static List<string> GetTableNames(string json)
        {
            List<string> result = new List<string>();
            var mainTable = JObject.Parse(json).AsJEnumerable().Where(it =>
              it.Path.ToLower().IsIn(
                  JsonProviderConfig.KeyInsertable.Get().ToLower(),
                  JsonProviderConfig.KeyUpdateable.Get().ToLower(),
                  JsonProviderConfig.KeyDeleteable.Get().ToLower(),
                  JsonProviderConfig.KeyQueryable.Get().ToLower()
              )).FirstOrDefault();
            if (mainTable != null)
                result.Add(mainTable.First().ToString());
            return result;
        }
    }
}