Exemple #1
0
        /// <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);
        }
Exemple #2
0
        /// <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);
        }