public static string GetSchoolNameById(string pid, string cid, string sid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetSchoolInfo(pid, cid);
DataRow[] dr = dt.Select("Id=" + sid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["SchoolName"]));
}
else
{
return(string.Empty);
}
}
public static string GetProvinceNameById(string pid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetProvince();
DataRow[] dr = dt.Select("provinceID=" + pid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["province"]));
}
else
{
return(string.Empty);
}
}
public static string GetAreaNameById(string aid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetAreaInfo("");
DataRow[] dr = dt.Select("areaId=" + aid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["area"]));
}
else
{
return(string.Empty);
}
}
public static string GetCityNameById(string cid)
{
string result = string.Empty;
DataTable dt = ProvinceCityFacade.GetInstance().GetCityInfo("");
DataRow[] dr = dt.Select("cityID=" + cid);
if (dr.Length > 0)
{
result = CommonMethodFacade.FinalString(dr[0]["city"]);
}
else
{
dr = dt.Select("father=" + cid);
if (dr.Length > 0)
{
result = CommonMethodFacade.FinalString(dr[0]["city"]);
}
}
return(result);
}