using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;

namespace Ant.ORM
{
    public interface SqlQuery
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="colume"></param>
        /// <returns></returns>
        SqlQuery Select(MakeShowFields colume);

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        SqlQuery Select();
        /// <summary>
        /// 
        /// </summary>
        /// <param name="num"></param>
        /// <returns></returns>
        SqlQuery Top(int num);

        /// <summary>
        /// 
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="strasname"></param>
        /// <returns></returns>
        SqlQuery From<T>(string strasname);

        /// <summary>
        /// 
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        SqlQuery Join(MakeJoinTable where);


        /// <summary>
        /// 
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        SqlQuery Where(MakeQueryWhere where);

        /// <summary>
        /// 
        /// </summary>
        /// <param name="strlist"></param>
        /// <returns></returns>
        SqlQuery Group(params string[] strlist);

        /// <summary>
        /// 
        /// </summary>
        /// <param name="columns"></param>
        /// <returns></returns>
        SqlQuery OrderDesc<T>(params string[] columns);

        /// <summary>
        /// 
        /// </summary>
        /// <param name="columns"></param>
        /// <returns></returns>
        SqlQuery OrderAsc<T>(params string[] columns);


        /// <summary>
        /// 
        /// </summary>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        SqlQuery OrderBy(MakeOrderBy orderBy);

        /// <summary>
        /// 
        /// </summary>
        /// <param name="db"></param>
        /// <returns></returns>
       // ResponseModel GetDtList(SqlNote sqlNote, DataAccess db = null);

        /// <summary>
        /// 
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="db"></param>
        /// <returns></returns>
        //ResponseModel GetEnSingle<T>(SqlNote sqlNote, DataAccess db = null);
        /// <summary>
        /// 
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="db"></param>
        /// <returns></returns>
       // ResponseModel GetEnList<T>(SqlNote sqlNote, DataAccess db = null);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="pageno"></param>
        /// <param name="pagesize"></param>
        /// <param name="db"></param>
        /// <returns></returns>
       // ResponseModel GetPageSite(int pageno, int pagesize, SqlNote sqlNote, DataAccess db = null);
    }
}