/// <summary>
/// 获得城市
/// </summary>
/// <returns></returns>
public List <ZhongLi.Model.sys_City> GetListCity(string Code)
{
List <ZhongLi.Model.sys_City> list = new List <ZhongLi.Model.sys_City>();
string sql = string.Format(" select * from sys_City where LEN(Code)=4 and Code like '{0}%'", Code);
DataTable dt = DbHelperSQL.GetDataTable(sql);
foreach (DataRow row in dt.Rows)
{
ZhongLi.Model.sys_City city = new Model.sys_City();
city.Code = row["Code"].ToString();
city.City = row["City"].ToString();
list.Add(city);
}
return(list);
}
/// <summary>
/// 获得省份
/// </summary>
public List <ZhongLi.Model.sys_City> GetListProvince()
{
List <ZhongLi.Model.sys_City> list = new List <ZhongLi.Model.sys_City>();
string sql = "select Code,Province from sys_City where LEN(Code)=2";
DataTable dt = DbHelperSQL.GetDataTable(sql);
foreach (DataRow row in dt.Rows)
{
ZhongLi.Model.sys_City city = new Model.sys_City();
city.Code = row["Code"].ToString();
city.Province = row["Province"].ToString();
list.Add(city);
}
return(list);
}
