/// <summary> /// 获取省份 /// </summary> /// <param name="context"></param> public void ProvinceLoad(HttpContext context) { System.Data.DataSet ds = new System.Data.DataSet(); ds = new ZhongLi.Bll.sys_City().GetList(" LEN(Code)=2 ", "Code,Province"); if (ds != null && ds.Tables[0].Rows.Count > 0) { strResult = ZhongLi.Common.EasyUIJsonHelper.TableToJson(ds.Tables[0]); strResult = strResult.Insert(1, "{\"Code\":\"0\",\"Province\":\"省份\"},"); } }
/// <summary> /// 获取县区 /// </summary> /// <param name="context"></param> public void CountyLoad(HttpContext context) { string code = context.Request["code"]; System.Data.DataSet ds = new System.Data.DataSet(); ds = new ZhongLi.Bll.sys_City().GetList(" LEN(Code)=7 and Code like '" + code + "%'", "Code,county"); if (ds != null && ds.Tables[0].Rows.Count > 0) { strResult = ZhongLi.Common.EasyUIJsonHelper.TableToJson(ds.Tables[0]); strResult = strResult.Insert(1, "{\"Code\":\"0\",\"county\":\"区县\"},"); } }
public static string GetCity(object files, object code) { string strResult = string.Empty; if (files != null && code != null) { DataSet ds = new ZhongLi.Bll.sys_City().GetList(" code='" + code + "'", files.ToString()); if (ds != null && ds.Tables[0].Rows.Count > 0) { strResult = ds.Tables[0].Rows[0][0].ToString(); } } return(strResult); }