public static GeneratedQuery GenerateQuery(IList <ParmInfo> ParmInfoList, GeneratedQuery query) { generated = new GeneratedQuery(); GenerateWhereScript(ParmInfoList); generated.QueryScript.Append(generated); return(generated); }
public static GeneratedQuery GeneratedPagingQuery(string TableName, int PageNumber, int RowsPerPage, IList <ParmInfo> ParmInfoList) { generated = new GeneratedQuery(); generated.SelectClause.AppendFormat("SELECT *, TotalRowCount = COUNT(*) OVER() FROM {0} ", TableName); GenerateWhereScript(ParmInfoList); generated.SelectClause.Append(generated.WhereClause); generated.SelectClause.AppendFormat(" ORDER BY Id OFFSET({0} - 1) * {1} ROWS FETCH NEXT {1} ROWS ONLY", PageNumber, RowsPerPage); return(generated); }
public static GeneratedQuery GenerateQuery(IList <ParmInfo> ParmInfoList, string TableName) { generated = new GeneratedQuery(); GenerateSelectForSingle(); GenerateFromForSingle(TableName); GenerateWhereScript(ParmInfoList); generated.QueryScript.Append(generated.SelectClause); generated.QueryScript.Append(generated.FromClause); generated.QueryScript.Append(generated.WhereClause); return(generated); }
public static GeneratedQuery GenerateQuery(string TableName, ParmInfo _ParmInfo = null) { var list = new List <ParmInfo>(); if (_ParmInfo != null) { list.Add(_ParmInfo); GenerateWhereScript(list); } generated = new GeneratedQuery(); GenerateSelectForSingle(); GenerateFromForSingle(TableName); generated.QueryScript.Append(generated.SelectClause); generated.QueryScript.Append(generated.FromClause); generated.QueryScript.Append(generated.WhereClause); return(generated); }