//360城市数据 protected void Button1_Click(object sender, EventArgs e) { string sMessage = PostByHttpRequest("", "http://tuan.360.cn/api/open_citys.php?format=json"); JsonData jd = JsonMapper.ToObject(sMessage); for (int i = 0; i < jd.Count; i++) { JsonData jdZM = jd[i]; for (int j = 0; j < jdZM.Count; j++) { JsonData jdItem = jdZM[j]; string cityName = Convert.ToString(jdItem["name"]); string cityCode = Convert.ToString(jdItem["code"]); string cityHotrank = Convert.ToString(jdItem["hotrank"]); //插入城市数据 Area_360Entity Ctae = new Area_360Entity(); Ctae.Code = cityCode; Ctae.CityName = cityName; Ctae.Hatrank = Convert.ToInt32(cityHotrank); Ctae.Status = 0; Ctae.LastUpdateTime = DateTime.Now; int CsysNo = new Area_360Dac().Add(Ctae); } } Response.Write("成功"); }
private void BindCity() { DataTable newDt = new DataTable(); DataColumn dcKey = new DataColumn("key"); DataColumn dcValue = new DataColumn("value"); newDt.Columns.Add(dcKey); newDt.Columns.Add(dcValue); Dictionary <int, Area_360Entity> dic = new Area_360Dac().GetAutoCityList(""); if (dic != null && dic.Count > 0) { for (int i = 0; i < dic.Count; i++) { DataRow drTemp = newDt.NewRow(); drTemp["key"] = dic.Values.ElementAt(i).SysNo.ToString(); drTemp["value"] = dic.Values.ElementAt(i).CityName.ToString(); newDt.Rows.Add(drTemp); } } StringBuilder jsonData = DataTableToJSON(newDt, true); string jsonDataFormat = jsonData.ToString(); hidArray.Value = jsonDataFormat; //ucArea360.DataSource = newDt; //ucArea360.DataBind(); }
private void BindAZone(int districtSysNo, int zoneSysNo) { ddlAZone.Enabled = Enable; Dictionary <int, Area_360Entity> dic = new Area_360Dac().GetAZonesByDistrictSysNo(districtSysNo); if (dic != null && dic.Count != 0) { for (int i = 0; i < dic.Count; i++) { ddlAZone.Items.Add(new ListItem(dic.Values.ElementAt(i).ZoneName, dic.Values.ElementAt(i).SysNo.ToString())); } } ddlAZone.SelectedValue = zoneSysNo.ToString(); hidAZoneSysNo.Value = zoneSysNo.ToString(); }
public ArrayList GetAZonesByDistrictSysNo(int disctrictSysNo) { Dictionary <int, Area_360Entity> dic = new Area_360Dac().GetAZonesByDistrictSysNo(disctrictSysNo); ArrayList reAL = new ArrayList(); if (dic != null && dic.Count > 0) { for (int i = 0; i < dic.Count; i++) { string[] itemArr = new string[2]; itemArr[0] = dic.Values.ElementAt(i).SysNo.ToString(); itemArr[1] = dic.Values.ElementAt(i).ZoneName.ToString(); reAL.Insert(i, itemArr); } } return(reAL); }
//360区县商圈 protected void Button2_Click(object sender, EventArgs e) { string sURL = "http://tuan.360.cn/api/open_locality.php?city=" + "nan_jing" + "&format=json"; string sMessage = PostByHttpRequest("", sURL); JsonData jd = JsonMapper.ToObject(sMessage); for (int i = 0; i < jd.Count; i++) { JsonData jdItem = jd[i]; string districtClassid = Convert.ToString(jdItem["classid"]); string districtName = Convert.ToString(jdItem["name"]); //插入区县数据 Area_360Entity Dtae = new Area_360Entity(); Dtae.CitySysNo = 184; Dtae.Code = "nan_jing"; Dtae.CityName = "南京"; Dtae.DistrictName = districtName; Dtae.Classid = Convert.ToInt32(districtClassid); Dtae.Status = 0; Dtae.LastUpdateTime = DateTime.Now; int DSysNo = new Area_360Dac().Add(Dtae); JsonData jdSons = jdItem[2]; for (int j = 0; j < jdSons.Count; j++) { JsonData jdSon = jdSons[j]; string zoneClassid = Convert.ToString(jdSon["classid"]); string zoneName = Convert.ToString(jdSon["name"]); //插入商圈数据 Area_360Entity Ztae = new Area_360Entity(); Ztae.CitySysNo = 184; Ztae.DistrictSysNo = DSysNo; Ztae.Code = "nan_jing"; Ztae.CityName = "南京"; Ztae.DistrictName = districtName; Ztae.ZoneName = zoneName; Ztae.Classid = Convert.ToInt32(zoneClassid); Ztae.Status = 0; Ztae.LastUpdateTime = DateTime.Now; int ZSysNo = new Area_360Dac().Add(Ztae); } } Response.Write("成功"); }
//360区域数据整体导入 protected void Button4_Click(object sender, EventArgs e) { string sMessageC = PostByHttpRequest("", "http://tuan.360.cn/api/open_citys.php?format=json"); JsonData jdC = JsonMapper.ToObject(sMessageC); DateTime lasthUpdateTime = DateTime.Now; for (int i = 0; i < jdC.Count; i++) { JsonData jdCZM = jdC[i]; for (int j = 0; j < jdCZM.Count; j++) { JsonData jdCItem = jdCZM[j]; string cityName = Convert.ToString(jdCItem["name"]); string cityCode = Convert.ToString(jdCItem["code"]); string cityHotrank = Convert.ToString(jdCItem["hotrank"]); //插入城市数据 Area_360Entity Ctae = new Area_360Entity(); Ctae.Code = cityCode; Ctae.CityName = cityName; Ctae.Hatrank = Convert.ToInt32(cityHotrank); Ctae.Status = 0; Ctae.LastUpdateTime = lasthUpdateTime; int CsysNo = new Area_360Dac().Add(Ctae); //下面是区县商圈数据 string sURL = ""; string sMessageD = ""; try { sURL = "http://tuan.360.cn/api/open_locality.php?city=" + cityCode + "&format=json"; sMessageD = PostByHttpRequest("", sURL); } catch (Exception ex) { sURL = "http://tuan.360.cn/api/open_locality.php?city=" + cityCode + "&format=json"; sMessageD = PostByHttpRequest("", sURL); } if (sMessageD.Trim() == "false") { continue; } JsonData jdD = JsonMapper.ToObject(sMessageD); for (int M = 0; M < jdD.Count; M++) { JsonData jdDItem = jdD[M]; int DCount = jdDItem.Count; int DSysNo = AppConst.IntNull; string districtClassid = AppConst.StringNull; string districtName = AppConst.StringNull; if (DCount >= 2) { districtClassid = Convert.ToString(jdDItem["classid"]); districtName = Convert.ToString(jdDItem["name"]); //插入区县数据 Area_360Entity Dtae = new Area_360Entity(); Dtae.CitySysNo = CsysNo; Dtae.Code = cityCode; Dtae.CityName = cityName; Dtae.DistrictName = districtName; Dtae.Classid = Convert.ToInt32(districtClassid); Dtae.Status = 0; Dtae.LastUpdateTime = lasthUpdateTime; DSysNo = new Area_360Dac().Add(Dtae); if (DCount == 2) { continue; } } if (jdDItem.Count <= DCount - 1) { continue; } JsonData jdZSons = jdDItem[DCount - 1]; for (int N = 0; N < jdZSons.Count; N++) { JsonData jdZSon = jdZSons[N]; string zoneClassid = Convert.ToString(jdZSon["classid"]); string zoneName = Convert.ToString(jdZSon["name"]); //插入商圈数据 Area_360Entity Ztae = new Area_360Entity(); Ztae.CitySysNo = CsysNo; Ztae.DistrictSysNo = DSysNo; Ztae.Code = cityCode; Ztae.CityName = cityName; Ztae.DistrictName = districtName; Ztae.ZoneName = zoneName; Ztae.Classid = Convert.ToInt32(zoneClassid); Ztae.Status = 0; Ztae.LastUpdateTime = lasthUpdateTime; int ZSysNo = new Area_360Dac().Add(Ztae); } } } } Response.Write("成功"); }
//360区域数据导入 private void button2_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; string sMessageC = PostByHttpRequest("", ConfigurationManager.AppSettings["APICity"]); JsonData jdC = JsonMapper.ToObject(sMessageC); DateTime lasthUpdateTime = DateTime.Now; for (int i = 0; i < jdC.Count; i++) { JsonData jdCZM = jdC[i]; for (int j = 0; j < jdCZM.Count; j++) { JsonData jdCItem = jdCZM[j]; string cityName = Convert.ToString(jdCItem["name"]); string cityCode = Convert.ToString(jdCItem["code"]); string cityHotrank = Convert.ToString(jdCItem["hotrank"]); //插入城市数据 Area_360Entity Ctae = new Area_360Entity(); Ctae.Code = cityCode; Ctae.CityName = cityName; Ctae.Hatrank = Convert.ToInt32(cityHotrank); Ctae.Status = 0; Ctae.LastUpdateTime = lasthUpdateTime; int CsysNo = new Area_360Dac().AddNew(Ctae); //下面是区县商圈数据 string sURL = ""; string sMessageD = ""; try { // sURL = string.Format(ConfigurationManager.AppSettings["APIQXSQ"].Replace('#', '&'), cityCode);//"http://tuan.360.cn/api/open_locality.php?city=" + cityCode + "&format=json" sMessageD = PostByHttpRequest("", sURL); } catch (Exception ex) { sURL = string.Format(ConfigurationManager.AppSettings["APIQXSQ"].Replace('#', '&'), cityCode);//"http://tuan.360.cn/api/open_locality.php?city=" + cityCode + "&format=json" sMessageD = PostByHttpRequest("", sURL); } if (sMessageD.Trim() == "false") { continue; } JsonData jdD = JsonMapper.ToObject(sMessageD); for (int M = 0; M < jdD.Count; M++) { JsonData jdDItem = jdD[M]; int DCount = jdDItem.Count; int DSysNo = AppConst.IntNull; string districtClassid = AppConst.StringNull; string districtName = AppConst.StringNull; if (DCount >= 2) { districtClassid = Convert.ToString(jdDItem["classid"]); districtName = Convert.ToString(jdDItem["name"]); //插入区县数据 Area_360Entity Dtae = new Area_360Entity(); Dtae.CitySysNo = CsysNo; Dtae.Code = cityCode; Dtae.CityName = cityName; Dtae.DistrictName = districtName; Dtae.Classid = Convert.ToInt32(districtClassid); Dtae.Status = 0; Dtae.LastUpdateTime = lasthUpdateTime; DSysNo = new Area_360Dac().AddNew(Dtae); if (DCount == 2) { continue; } } if (jdDItem.Count <= DCount - 1) { continue; } JsonData jdZSons = jdDItem[DCount - 1]; for (int N = 0; N < jdZSons.Count; N++) { JsonData jdZSon = jdZSons[N]; string zoneClassid = Convert.ToString(jdZSon["classid"]); string zoneName = Convert.ToString(jdZSon["name"]); //插入商圈数据 Area_360Entity Ztae = new Area_360Entity(); Ztae.CitySysNo = CsysNo; Ztae.DistrictSysNo = DSysNo; Ztae.Code = cityCode; Ztae.CityName = cityName; Ztae.DistrictName = districtName; Ztae.ZoneName = zoneName; Ztae.Classid = Convert.ToInt32(zoneClassid); Ztae.Status = 0; Ztae.LastUpdateTime = lasthUpdateTime; int ZSysNo = new Area_360Dac().AddNew(Ztae); } } } } Cursor.Current = Cursors.Default; MessageBox.Show("导入成功!"); }