public v_Schools GetSchool(string fullKey, int year)
{
fullKey = fullKey;
DALSchools school = new DALSchools();
v_Schools ds = school.GetSchool(fullKey, year);
return(ds);
}
public v_Schools GetSchool(string fullKey, int year)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("select * from v_Schools where fullkey like '{0}'", fullKey);
sql.AppendFormat(" AND year = {0}", year);
v_Schools ds = new v_Schools();
base.GetDS(ds, sql.ToString(), ds._v_Schools.TableName);
return(ds);
}
public string GetSchoolName(string fullKey, int year)
{
string retval = string.Empty;
v_Schools ds = GetSchool(fullKey, year);
if (ds._v_Schools.Rows.Count == 1)
{
retval = ds._v_Schools[0].Name.Trim();
}
return(retval);
}