/// <summary> /// /// </summary> /// <param name="qc"></param> /// <param name="retrieveTotalCount"></param> /// <returns></returns> public string GetQuerySql(QueryCondition qc, bool retrieveTotalCount) { string sql = ResourceHelper.LoadStringFromResource( Assembly.GetExecutingAssembly(), "MCS.Library.Data.Adapters.SplitPage.sql"); string orderBy = qc.OrderByClause; sql = string.Format( sql, qc.GetTopClause(), qc.SelectFields, qc.FromClause, string.IsNullOrEmpty(qc.WhereClause) ? string.Empty : " AND " + qc.WhereClause, qc.OrderByClause, qc.GroupBy.IsNotEmpty() ? "GROUP BY " + qc.GroupBy : string.Empty, qc.RowIndex + 1, qc.RowIndex + qc.PageSize); if (retrieveTotalCount) { sql += TSqlBuilder.Instance.DBStatementSeperator + GetTotalCountSql(qc); } return(sql); }
private static string GetNoSplitPageSqlWithoutOrderBy(QueryCondition qc) { string sql = string.Format("SELECT {0}{1} FROM {2} WHERE 1 = 1 {3} {4}", qc.GetTopClause(), qc.SelectFields, qc.FromClause, qc.WhereClause.IsNotEmpty() ? " AND " + qc.WhereClause : string.Empty, qc.GroupBy.IsNotEmpty() ? "GROUP BY " + qc.GroupBy : string.Empty); return(sql); }