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);
}
