LambdaToSql/EntityModel/SqLite/QueryEntity.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.Text;

namespace LambdaToSql.EntityModel.SqLite
{
    [Serializable]
    [DataContract]
    internal class QueryEntity<T> : LambdaToSql.EntityModel.QueryEntity<T> where T : class, new()
    {
        public QueryEntity(LambdaToSql.EntityModel.DbContext context) : base(context)
        {

        }

        #region GetStr

        /// <summary>
        /// 最终查询字符串 只读
        /// </summary>
        [DataMember]
        public override string SqlStr
        {
            get
            {
                var sql = "";
                if (!string.IsNullOrEmpty(this.GroupByStr))
                {
                    sql = string.Format(SqlTemplate, this.FieldsStr, this.TableName + " " + this.WhereStr + " " + this.GroupByStr + " " + this.TopStr);
                }
                else
                {
                    sql = string.Format(SqlTemplate, this.FieldsStr, this.TableName + " " + this.WhereStr + " " + this.OrderByStr + " " + this.TopStr);
                }
                return sql;
            }
        }

        /// <summary>
        /// 函数最终查询字符串 只读
        /// </summary>
        [DataMember]
        public override string SqlFunStr
        {
            get
            {
                var sql = string.Format(SqlTemplate, this.FieldsStr, this.TableName + " " + this.WhereStr);
                if (!string.IsNullOrEmpty(this.TopStr))
                {
                    sql = string.Format(SqlTemplate, this.FieldsStr, this.TableName + " " + this.WhereStr + " " + this.OrderByStr + " " + this.TopStr);
                }
                return sql;
            }
        }
        #endregion

        #region Sql Template