private string GetSQLRowsCount() { StringBuilder sbSql = new StringBuilder(); sbSql.Append("Select cast(count(*) as int) count from Aplikacija_view "); sbSql.Append(" where ").Append(ReflectPropertyInfo.GetSearchFields(new DAplikacija())).Append(" like @searchParam "); return(sbSql.ToString()); }
private string GetSQL(string sortKey, string asceding) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("Select * from Aplikacija_view "); sbSql.Append(" where ").Append(ReflectPropertyInfo.GetSearchFields(new DAplikacija())).Append(" like @searchParam "); //sbSql.Append(" ORDER BY "); //sbSql.Append(sortKey.Equals("null") ? " Datum " : sortKey + (asceding.Equals("true") ? " ASC " : " DESC ")); //sbSql.Append(" OFFSET @pageSize*(@pageIndex-1) ROWS FETCH NEXT @pageSize ROWS ONLY;"); return(sbSql.ToString()); }