public override String BuildSQL(QueryMarshaller Marshaller)
{
StringBuilder sql = new StringBuilder();
String dbObject = "v_TruancySchoolDistState";
sql.Append(Marshaller.SelectListFromVisibleColumns(dbObject));
sql.Append(Marshaller.STYPClause(SQLHelper.WhereClauseJoiner.NONE, "SchoolType", dbObject));
////Adds " ... AND (SexCode in (1, 2)) ..."
sql.Append(SQLHelper.WhereClauseValuesInList(SQLHelper.WhereClauseJoiner.AND, "SexCode", Marshaller.sexCodes));
//Adds " ... AND (RaceCode in (1, 2, 3, 4, 5)) ..."
sql.Append(SQLHelper.WhereClauseValuesInList(SQLHelper.WhereClauseJoiner.AND, "RaceCode", Marshaller.raceCodes));
sql.Append(Marshaller.GradeCodesClause(SQLHelper.WhereClauseJoiner.AND, "GradeCode", dbObject));
//Adds " ... AND ((year >= 1997) AND (year <= 2007)) ..."
sql.Append(SQLHelper.WhereClauseSingleValueOrInclusiveRange(SQLHelper.WhereClauseJoiner.AND, "year", Marshaller.years));
sql.Append(Marshaller.FullkeyClause(SQLHelper.WhereClauseJoiner.AND, "FullKey"));
sql.AppendFormat(SQLHelper.GetOrderByClause(Marshaller.orderByList));
return(sql.ToString());
}
public override string BuildSQL(QueryMarshaller Marshaller)
{
StringBuilder sql = new StringBuilder();
String dbObject;
if (Marshaller.GlobalValues.Group.Key == SligoCS.Web.WI.WebSupportingClasses.WI.GroupKeys.EngLangProf)
{
dbObject = "v_LEPSchoolDistState ";
}
else if (Marshaller.GlobalValues.Group.Key == SligoCS.Web.WI.WebSupportingClasses.WI.GroupKeys.EconDisadv)
{
dbObject = "v_ErateRollups ";
}
else
{
dbObject = "v_Template_Keys_WWoDisEconELP_tblAgencyFull_Flat ";
}
sql.Append(Marshaller.SelectListFromVisibleColumns(dbObject));
//School Types
sql.Append(Marshaller.STYPClause(SQLHelper.WhereClauseJoiner.NONE, "SchoolType", dbObject));
//years
sql.Append(SQLHelper.WhereClauseSingleValueOrInclusiveRange(SQLHelper.WhereClauseJoiner.AND, "year", Marshaller.years));
sql.Append(Marshaller.FullkeyClause(SQLHelper.WhereClauseJoiner.AND, "FullKey"));
//order by clause
sql.AppendFormat(SQLHelper.GetOrderByClause(Marshaller.orderByList));
return(sql.ToString());
}