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