MESProductionWeb/AntORM/Ant.ORM/MoreSql/SqlEntity.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using Ant.Data;

namespace Ant.ORM
{
    public class SqlEntity
    {
        public SqlEntity()
        {
            Parameters = new QueryParameterCollection();
        }
        private static object lockHelper = new object();
        private static volatile MakeJoinTable instance = null;
        public string StrSelect
        {
            get;
            set;
        }
        public int StrTop
        {
            get;
            set;
        }
        /// <summary>
        /// 页数
        /// </summary>
        public int PageNo { get; set; }

        /// <summary>
        /// 页面
        /// </summary>
        public int PageSize { get; set; }

        /// <summary>
        /// 不带参数的Where查询条件
        /// </summary>
        public string StrWhere
        {
            get;
            set;
        }
        /// <summary>
        /// 带参数的Where查询条件
        /// </summary>
        public string StrParmWhere
        {
            get;
            set;
        }

        /// <summary>
        /// 查询主表
        /// </summary>
        public string StrFrom
        {
            get;
            set;
        }
        /// <summary>
        /// 查询主表别名
        /// </summary>
        public string StrAsName
        {
            get;
            set;
        }
        /// <summary>
        /// 查询SQL排序
        /// </summary>
        public string StrOrderBy
        {
            get;
            set;
        }
        /// <summary>
        /// 查询关联表
        /// </summary>
        public string StrJoin
        {
            get;
            set;
        }
        /// <summary>
        /// 关联表条件
        /// </summary>
        public string StrOn
        {
            get;
            set;
        }

       
        /// <summary>
        /// 命令参数集合
        /// </summary>
        public QueryParameterCollection Parameters
        {
            get;
            set;
        }

        /// <summary>
        /// 多表关联显示的表字段
        /// </summary>
        public MakeShowFields FieldColumns
        {
            get;
            set;
        }

        /// <summary>
        /// 关联表
        /// </summary>
        public MakeJoinTable JoinTable
        {
            get
            {
                if (instance == null)
                {
                    lock (lockHelper)
                    {
                        if (instance == null)
                        {
                            instance = new MakeJoinTable();
                        }
                    }
                }
                return instance;
            }
            set { instance = value; }
        }

        /// <summary>
        /// 查询条件
        /// </summary>
        public MakeQueryWhere QueryWhere
        {
            get;
            set;
        }
        /// <summary>
        /// 排序
        /// </summary>
        public MakeOrderBy OrderBy { get; set; }

    }








    



    
}