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); }