public v_Districts GetDistric(string fullKey, int year)
{
DALDistrict district = new DALDistrict();
string masked = FullKeyUtils.DistrictFullKey(fullKey);
v_Districts ds = district.GetDistrict(masked, year);
return(ds);
}
public v_Districts GetDistrict(string fullKey, int year)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("select * from v_districts where fullkey like '{0}'", fullKey);
sql.AppendFormat(" AND year = {0}", year);
v_Districts ds = new v_Districts();
base.GetDS(ds, sql.ToString(), ds._v_Districts.TableName);
return(ds);
}
public string GetDistrictName(string fullKey, int year)
{
string retval = string.Empty;
v_Districts ds = GetDistric(fullKey, year);
if (ds._v_Districts.Rows.Count == 1)
{
retval = ds._v_Districts[0].Name.Trim();
}
return(retval);
}
