src/SSCMS.Core/StlParser/StlElement/StlQuery.Where.cs

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

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

using System.Linq;
using SqlKata;
using SSCMS.Core.StlParser.Models;
using SSCMS.Utils;

namespace SSCMS.Core.StlParser.StlElement
{
    public static partial class StlQuery
    {
        private static void Where(Query query, QueryInfo queryInfo)
        {
            if (!string.IsNullOrEmpty(queryInfo.Column))
            {
                var value = GetValue(queryInfo.DataType, queryInfo.Value);
                if (!string.IsNullOrEmpty(queryInfo.Op))
                {
                    query.Where(queryInfo.Column, queryInfo.Op, value);
                }
                else
                {
                    query.Where(queryInfo.Column, value);
                }
            }
            else if (queryInfo.Queries != null && queryInfo.Queries.Count > 0)
            {
                query.Where(q =>
                {
                    foreach (var info in queryInfo.Queries)
                    {
                        q.AddQuery(info);
                    }
                    return q;
                });
            }
        }

        private static void WhereNot(Query query, QueryInfo queryInfo)
        {
            if (!string.IsNullOrEmpty(queryInfo.Column))
            {
                var value = GetValue(queryInfo.DataType, queryInfo.Value);
                if (!string.IsNullOrEmpty(queryInfo.Op))
                {
                    query.WhereNot(queryInfo.Column, queryInfo.Op, value);
                }
                else
                {
                    query.WhereNot(queryInfo.Column, value);
                }
            }
            else if (queryInfo.Queries != null && queryInfo.Queries.Count > 0)
            {
                query.WhereNot(q =>
                {
                    foreach (var info in queryInfo.Queries)
                    {
                        q.AddQuery(info);
                    }
                    return q;
                });