//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("导入成功！");
}
