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