40 lines
1.3 KiB
C#
40 lines
1.3 KiB
C#
|
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;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|