//360分类数据 protected void Button3_Click(object sender, EventArgs e) { string sMessage = PostByHttpRequest("", "http://api.tuan.360.cn/open_category.php?format=json"); JsonData jd = JsonMapper.ToObject(sMessage); int status = 0; DateTime lasthUpdateTime = DateTime.Now; for (int i = 0; i < jd.Count; i++) { JsonData jdItem = jd[i]; if (Convert.ToString(jdItem["name"]) == "网上购物") { continue; } //string C1cateid = Convert.ToString(jdItem["cateid"]); //string C1name = Convert.ToString(jdItem["name"]); //string C1alias = Convert.ToString(jdItem["alias"]); //string C1isred = Convert.ToString(jdItem["isred"]); //string C1isnew = Convert.ToString(jdItem["isnew"]); //string C1minihot = Convert.ToString(jdItem["minihot"]); //string C1minired = Convert.ToString(jdItem["minired"]); Category_360Entity tceC1 = ReturnCategory(jdItem, 1); tceC1.Status = status; tceC1.LastUpdateTime = lasthUpdateTime; //插入一级类别 int C1SysNo = new Category_360Dac().Add(tceC1); if (jdItem.Count > 7) { JsonData jdSons = jdItem[7]; for (int j = 0; j < jdSons.Count; j++) { JsonData jdSon = jdSons[j]; //string C2cateid = Convert.ToString(jdSon["cateid"]); //string C2name = Convert.ToString(jdSon["name"]); //string C2alias = Convert.ToString(jdSon["alias"]); //string C2isred = Convert.ToString(jdSon["isred"]); //string C2isnew = Convert.ToString(jdSon["isnew"]); //string C2minihot = Convert.ToString(jdSon["minihot"]); //string C2minired = Convert.ToString(jdSon["minired"]); Category_360Entity tceC2 = ReturnCategory(jdSon, 2); tceC2.C1SysNo = C1SysNo; tceC2.C1Name = tceC1.C1Name; tceC2.APIName = tceC1.APIName; tceC2.Status = status; tceC2.LastUpdateTime = lasthUpdateTime; //插入二级类别 int C2SysNo = new Category_360Dac().Add(tceC2); if (jdSon.Count > 7) { JsonData jdSonSons = jdSon[7]; for (int k = 0; k < jdSonSons.Count; k++) { JsonData jdSonSonsSon = jdSonSons[k]; //string C3cateid = Convert.ToString(jdSonSonsSon["cateid"]); //string C3name = Convert.ToString(jdSonSonsSon["name"]); //string C3alias = Convert.ToString(jdSonSonsSon["alias"]); //string C3isred = Convert.ToString(jdSonSonsSon["isred"]); //string C3isnew = Convert.ToString(jdSonSonsSon["isnew"]); //string C3minihot = Convert.ToString(jdSonSonsSon["minihot"]); //string C3minired = Convert.ToString(jdSonSonsSon["minired"]); Category_360Entity tceC3 = ReturnCategory(jdSonSonsSon, 3); tceC3.C1SysNo = C1SysNo; tceC3.C1Name = tceC1.C1Name; tceC3.APIName = tceC1.APIName; tceC3.C2SysNo = C2SysNo; tceC3.C2Name = tceC2.C2Name; tceC3.Status = 0; tceC3.LastUpdateTime = lasthUpdateTime; //插入三级类别 int C3SysNo = new Category_360Dac().Add(tceC3); //if (jdSonSonsSon.Count > 7)//不要购物 不要四级 //{ // JsonData jdSonSonsSonSons = jdSonSonsSon[7]; // for (int z = 0; z < jdSonSonsSonSons.Count; z++) // { // JsonData jdSonSonsSonSonsSon = jdSonSonsSonSons[z]; // Category_360Entity tceC4 = ReturnCategory(jdSonSonsSonSonsSon, 4); // tceC4.C1SysNo = C1SysNo; // tceC4.C1Name = tceC1.C1Name; // tceC4.APIName = tceC1.APIName; // tceC4.C2SysNo = C2SysNo; // tceC4.C2Name = tceC2.C2Name; // tceC4.C3SysNo = C3SysNo; // tceC4.C3Name = tceC3.C3Name; // //插入四级类别 // int C4SysNo = new Category_360Dac().Add(tceC4); // } //} } } } } } Response.Write("成功"); }
//360分类数据导入 private void button1_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; string sMessage = PostByHttpRequest("", ConfigurationManager.AppSettings["APICategory"]);// ConfigurationManager.AppSettings["APICategory"]; JsonData jd = JsonMapper.ToObject(sMessage); int status = 0; DateTime lasthUpdateTime = DateTime.Now; for (int i = 0; i < jd.Count; i++) { JsonData jdItem = jd[i]; if (Convert.ToString(jdItem["name"]) == "网上购物") { continue; } //string C1cateid = Convert.ToString(jdItem["cateid"]); //string C1name = Convert.ToString(jdItem["name"]); //string C1alias = Convert.ToString(jdItem["alias"]); //string C1isred = Convert.ToString(jdItem["isred"]); //string C1isnew = Convert.ToString(jdItem["isnew"]); //string C1minihot = Convert.ToString(jdItem["minihot"]); //string C1minired = Convert.ToString(jdItem["minired"]); Category_360Entity tceC1 = ReturnCategory(jdItem, 1); tceC1.Status = status; tceC1.LastUpdateTime = lasthUpdateTime; //插入一级类别 int C1SysNo = new Category_360Dac().AddNew(tceC1); if (jdItem.Count > 7) { JsonData jdSons = jdItem[7]; for (int j = 0; j < jdSons.Count; j++) { JsonData jdSon = jdSons[j]; //string C2cateid = Convert.ToString(jdSon["cateid"]); //string C2name = Convert.ToString(jdSon["name"]); //string C2alias = Convert.ToString(jdSon["alias"]); //string C2isred = Convert.ToString(jdSon["isred"]); //string C2isnew = Convert.ToString(jdSon["isnew"]); //string C2minihot = Convert.ToString(jdSon["minihot"]); //string C2minired = Convert.ToString(jdSon["minired"]); Category_360Entity tceC2 = ReturnCategory(jdSon, 2); tceC2.C1SysNo = C1SysNo; tceC2.C1Name = tceC1.C1Name; tceC2.APIName = tceC1.APIName; tceC2.Status = status; tceC2.LastUpdateTime = lasthUpdateTime; //插入二级类别 int C2SysNo = new Category_360Dac().AddNew(tceC2); if (jdSon.Count > 7) { JsonData jdSonSons = jdSon[7]; for (int k = 0; k < jdSonSons.Count; k++) { JsonData jdSonSonsSon = jdSonSons[k]; //string C3cateid = Convert.ToString(jdSonSonsSon["cateid"]); //string C3name = Convert.ToString(jdSonSonsSon["name"]); //string C3alias = Convert.ToString(jdSonSonsSon["alias"]); //string C3isred = Convert.ToString(jdSonSonsSon["isred"]); //string C3isnew = Convert.ToString(jdSonSonsSon["isnew"]); //string C3minihot = Convert.ToString(jdSonSonsSon["minihot"]); //string C3minired = Convert.ToString(jdSonSonsSon["minired"]); Category_360Entity tceC3 = ReturnCategory(jdSonSonsSon, 3); tceC3.C1SysNo = C1SysNo; tceC3.C1Name = tceC1.C1Name; tceC3.APIName = tceC1.APIName; tceC3.C2SysNo = C2SysNo; tceC3.C2Name = tceC2.C2Name; tceC3.Status = 0; tceC3.LastUpdateTime = lasthUpdateTime; //插入三级类别 int C3SysNo = new Category_360Dac().AddNew(tceC3); //if (jdSonSonsSon.Count > 7)//不要购物 不要四级 //{ // JsonData jdSonSonsSonSons = jdSonSonsSon[7]; // for (int z = 0; z < jdSonSonsSonSons.Count; z++) // { // JsonData jdSonSonsSonSonsSon = jdSonSonsSonSons[z]; // Category_360Entity tceC4 = ReturnCategory(jdSonSonsSonSonsSon, 4); // tceC4.C1SysNo = C1SysNo; // tceC4.C1Name = tceC1.C1Name; // tceC4.APIName = tceC1.APIName; // tceC4.C2SysNo = C2SysNo; // tceC4.C2Name = tceC2.C2Name; // tceC4.C3SysNo = C3SysNo; // tceC4.C3Name = tceC3.C3Name; // //插入四级类别 // int C4SysNo = new Category_360Dac().Add(tceC4); // } //} } } } } } Cursor.Current = Cursors.Default; MessageBox.Show("导入成功!"); }