public static void Refresh()
{
lock (olock)
{
instance = new ProvinceCityFacade();
}
}
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 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 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);
}
}
/// <summary>
/// 生成实例方法
/// </summary>
/// <returns></returns>
public static ProvinceCityFacade GetInstance()
{
if (instance == null)
{
//取得实例的时候先锁定对象,然后判定是否存在
lock (olock)
{
//如果实例没有被初始化则实例化变量
if (instance == null)
{
instance = new ProvinceCityFacade();
}
}
}
return(instance);
}
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);
}
