/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "21093339", "c1c22ba85fb91bd20279213ef7b9ee80"); //记录店铺基本信息 ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop; try { shop = client.ShopGet(request); } catch { Response.Write("没有店铺的淘宝会员不可使用该应用,如果您想继续使用,请先去淘宝网开个属于您自己的店铺!<br> <a href='http://www.taobao.com/'>返回</a>"); Response.End(); return; } string ip = Request.UserHostAddress; //记录到本地数据库 string sql = "INSERT INTO TopTaobaoShop (" + "sid, " + "cid, " + "title, " + "nick, " + "[desc], " + "bulletin, " + "pic_path, " + "created, " + "modified, " + "shop_score, " + "ip, " + "session, " + "remain_count,refreshToken" + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Cid + "', " + " '" + shop.Title + "', " + " '" + shop.Nick + "', " + " '" + shop.Desc + "', " + " '" + shop.Bulletin + "', " + " '" + shop.PicPath + "', " + " '" + shop.Created + "', " + " '" + shop.Modified + "', " + " '" + shop.ShopScore + "', " + " '" + ip + "', " + " '" + top_session + "', " + " '" + shop.RemainCount + "','" + refreshToken + "'" + ") "; utils.ExecuteNonQuery(sql); }
protected void Page_Load(object sender, EventArgs e) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.tbsandbox.com/router/rest", "test", "test"); //UserGetRequest request = new UserGetRequest(); //request.Fields = "buyer_credit"; //request.Nick = "golddonkey"; //Taobao.Top.Api.Domain.User user = client.UserGet(request); //Response.Write(user.BuyerCredit.Score); //ProductsGetRequest request = new ProductsGetRequest(); //request.Fields = "product_id,name,pic_url,shop_price"; //request.Nick = "golddonkey"; //PageList<Product> product = client.ProductsGet(request); //Response.Write(product.Content.Count); //test.DataSource = product.Content; //test.DataBind(); ShopGetRequest request = new ShopGetRequest(); request.Fields = "title"; request.Nick = "golddonkey"; Shop shop = client.ShopGet(request); Response.Write(shop.Title); }
/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12287381", "d3486dac8198ef01000e7bd4504601a4"); //记录店铺基本信息 ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop = client.ShopGet(request); //记录到本地数据库 string sql = "INSERT INTO TopTaobaoShop (" + "sid, " + "cid, " + "title, " + "nick, " + "[desc], " + "bulletin, " + "pic_path, " + "created, " + "modified, " + "shop_score, " + "remain_count " + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Cid + "', " + " '" + shop.Title + "', " + " '" + shop.Nick + "', " + " '" + shop.Desc + "', " + " '" + shop.Bulletin + "', " + " '" + shop.PicPath + "', " + " '" + shop.Created + "', " + " '" + shop.Modified + "', " + " '" + shop.ShopScore + "', " + " '" + shop.RemainCount + "' " + ") "; utils.ExecuteNonQuery(sql); //记录店铺分类信息 SellercatsListGetRequest request1 = new SellercatsListGetRequest(); request1.Fields = "cid,parent_cid,name,is_parent"; request1.Nick = nick; PageList <SellerCat> cat = client.SellercatsListGet(request1); for (int i = 0; i < cat.Content.Count; i++) { sql = "INSERT INTO TopTaobaoShopCat (" + "cid, " + "parent_cid, " + "name, " + "pic_url, " + "sort_order, " + "created, " + "nick, " + "modified " + " ) VALUES ( " + " '" + cat.Content[i].Cid + "', " + " '" + cat.Content[i].ParentCid + "', " + " '" + cat.Content[i].Name + "', " + " '" + cat.Content[i].PicUrl + "', " + " '" + cat.Content[i].SortOrder + "', " + " '" + cat.Content[i].Created + "', " + " '" + nick + "', " + " '" + cat.Content[i].Modified + "' " + ") "; utils.ExecuteNonQuery(sql); } //记录店铺所有商品信息-暂不记录 }
/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", top_appkey, app_secret); //记录店铺基本信息 string ip = Request.UserHostAddress; ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop; try { shop = client.ShopGet(request); } catch { Response.Write("没有店铺的淘宝会员不可使用该应用,如果您想继续使用,请先去淘宝网开个属于您自己的店铺!<br> <a href='http://www.taobao.com/'>返回</a>"); Response.End(); return; } //获取版本号 string version = "9"; //IDictionary<string, string> param = new Dictionary<string, string>(); //param.Add("article_code", "service-0-22904"); //param.Add("nick", nick); //string result = PostJson("http://gw.api.taobao.com/router/rest", top_appkey, app_secret, "taobao.vas.subscribe.get", top_session, param); //if (result.IndexOf("\"article_user_subscribes\":{}") == -1) //{ // Regex reg = new Regex(@"""item_code"":""([^""]*)""", RegexOptions.IgnoreCase); // //更新店铺的版本号 // MatchCollection match = reg.Matches(result); // for (int j = 0; j < match.Count; j++) // { // version = match[j].Groups[1].ToString().Replace("service-0-22904-", ""); // if (version == "9") // { // version = "3"; // } // if (int.Parse(version) <= 3) // { // break; // } // } //} //记录到本地数据库 string sql = "INSERT INTO TCS_ShopSession (" + "sid, " + "nick, " + "typ, " + "version, " + "session" + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Nick + "', " + " 'taobao', " + " '" + version + "', " + " '" + top_session + "' " + ") "; utils.ExecuteNonQuery(sql); }
/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12159997", "614e40bfdb96e9063031d1a9e56fbed5"); //记录店铺基本信息 ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop; try { shop = client.ShopGet(request); } catch { Response.Write("没有店铺的淘宝会员不可使用该应用,如果您想继续使用,请先去淘宝网开个属于您自己的店铺!<br> <a href='http://www.taobao.com/'>返回</a>"); Response.End(); return; } //记录到本地数据库 string sql = "INSERT INTO TopTaobaoShop (" + "sid, " + "cid, " + "title, " + "nick, " + "[desc], " + "bulletin, " + "pic_path, " + "created, " + "modified, " + "shop_score, " + "versionNo, " + "remain_count " + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Cid + "', " + " '" + shop.Title + "', " + " '" + shop.Nick + "', " + " '" + shop.Desc + "', " + " '" + shop.Bulletin + "', " + " '" + shop.PicPath + "', " + " '" + shop.Created + "', " + " '" + shop.Modified + "', " + " '" + shop.ShopScore + "', " + " '" + versionNo + "', " + " '" + shop.RemainCount + "' " + ") "; utils.ExecuteNonQuery(sql); //记录店铺分类信息 SellercatsListGetRequest request1 = new SellercatsListGetRequest(); request1.Fields = "cid,parent_cid,name,is_parent"; request1.Nick = nick; PageList <SellerCat> cat = client.SellercatsListGet(request1); for (int i = 0; i < cat.Content.Count; i++) { sql = "INSERT INTO TopTaobaoShopCat (" + "cid, " + "parent_cid, " + "name, " + "pic_url, " + "sort_order, " + "created, " + "nick, " + "modified " + " ) VALUES ( " + " '" + cat.Content[i].Cid + "', " + " '" + cat.Content[i].ParentCid + "', " + " '" + cat.Content[i].Name + "', " + " '" + cat.Content[i].PicUrl + "', " + " '" + cat.Content[i].SortOrder + "', " + " '" + cat.Content[i].Created + "', " + " '" + nick + "', " + " '" + cat.Content[i].Modified + "' " + ") "; utils.ExecuteNonQuery(sql); } //记录店铺所有商品信息-暂不记录 }
/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12159997", "614e40bfdb96e9063031d1a9e56fbed5"); //记录店铺基本信息 string ip = Request.UserHostAddress; ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop; try { shop = client.ShopGet(request); } catch { Response.Write("没有店铺的淘宝会员不可使用该应用,如果您想继续使用,请先去淘宝网开个属于您自己的店铺!<br> <a href='http://www.taobao.com/'>返回</a>"); Response.End(); return; } //获取版本号 string appkey = "12159997"; string secret = "614e40bfdb96e9063031d1a9e56fbed5"; string version = "9"; IDictionary <string, string> param = new Dictionary <string, string>(); param.Add("article_code", "service-0-22904"); param.Add("nick", nick); Common.Cookie cookie = new Common.Cookie(); string result = PostJson("http://gw.api.taobao.com/router/rest", appkey, secret, "taobao.vas.subscribe.get", top_session, param); if (result.IndexOf("\"article_user_subscribes\":{}") == -1) { Regex reg = new Regex(@"""item_code"":""([^""]*)""", RegexOptions.IgnoreCase); //更新店铺的版本号 MatchCollection match = reg.Matches(result); for (int j = 0; j < match.Count; j++) { version = match[j].Groups[1].ToString().Replace("service-0-22904-", ""); if (version == "9") { version = "3"; } if (int.Parse(version) <= 3) { break; } } } string plus = string.Empty; if (version == "1") { version = "2"; } if (version == "2") { plus = "freecard"; } if (version == "3") { plus = "crm|freecard"; } string tuiguang = cookie.getCookie("tuiguang"); string istui = "0"; if (tuiguang != null && tuiguang != "") { istui = "1"; } //记录到本地数据库 string sql = "INSERT INTO TCS_ShopSession (" + "sid, " + "nick, " + "typ, " + "version, " + "plus, " + "token, " + "ip, " + "istui, " + "session" + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Nick + "', " + " 'taobao', " + " '" + version + "', " + " '" + plus + "', " + " '" + refreshToken + "', " + " '" + ip + "', " + " '" + istui + "', " + " '" + top_session + "' " + ") "; utils.ExecuteNonQuery(sql); //如果是好友推荐来的,记录到推荐数据库 string tuijianid = cookie.getCookie("tuijianid"); if (tuijianid != null && tuijianid != "") { Rijndael_ encode = new Rijndael_("tetesoft"); string nickFrom = encode.Decrypt(tuijianid); sql = "SELECT COUNT(*) FROM TCS_Tuijian WHERE nickfrom = '" + nickFrom + "' AND nickto = '" + shop.Nick + "'"; string count = utils.ExecuteString(sql); if (count != "0") { return; } sql = "INSERT INTO TCS_Tuijian (" + "nickfrom, " + "nickto " + " ) VALUES ( " + " '" + nickFrom + "', " + " '" + shop.Nick + "' " + ") "; utils.ExecuteNonQuery(sql); string giftMsg = "80"; //插入充值记录并更新短信条数 sql = "INSERT INTO TCS_PayLog (" + "typ, " + "enddate, " + "nick, " + "count " + " ) VALUES ( " + " '推荐好友【" + shop.Nick + "】赠送80条短信', " + " GETDATE(), " + " '" + nickFrom + "', " + " '" + giftMsg + "' " + ") "; utils.ExecuteNonQuery(sql); sql = "UPDATE TCS_ShopConfig SET total = total + " + giftMsg + " WHERE nick = '" + nickFrom + "'"; utils.ExecuteNonQuery(sql); } }
/// <summary> /// 记录该会员的店铺信息 /// </summary> private void InsertUserInfo(string nick) { TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12223169", "ff3d3442ab809930d187623ffad8e91e"); //记录店铺基本信息 string ip = Request.UserHostAddress; ShopGetRequest request = new ShopGetRequest(); request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; request.Nick = nick; Shop shop; try { shop = client.ShopGet(request); } catch { Response.Write("没有店铺的淘宝会员不可使用该应用,如果您想继续使用,请先去淘宝网开个属于您自己的店铺!<br> <a href='http://www.taobao.com/'>返回</a>"); Response.End(); return; } //记录到本地数据库 string sql = "INSERT INTO TopTaobaoShop (" + "sid, " + "cid, " + "title, " + "nick, " + "[desc], " + "bulletin, " + "pic_path, " + "created, " + "modified, " + "shop_score, " + "versionNo, " + "sessionblog, " + "ip, " + "remain_count " + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Cid + "', " + " '" + shop.Title + "', " + " '" + shop.Nick + "', " + " '" + shop.Desc + "', " + " '" + shop.Bulletin + "', " + " '" + shop.PicPath + "', " + " '" + shop.Created + "', " + " '" + shop.Modified + "', " + " '" + shop.ShopScore + "', " + " '" + versionNo + "', " + " '" + top_session + "', " + " '" + ip + "', " + " '" + shop.RemainCount + "' " + ") "; sql = "INSERT INTO TCS_ShopSession (" + "sid, " + "nick, " + "typ, " + "version, " + "session" + " ) VALUES ( " + " '" + shop.Sid + "', " + " '" + shop.Nick + "', " + " 'taobao', " + " '" + versionNo + "', " + " '" + top_session + "' " + ") "; utils.ExecuteNonQuery(sql); //记录店铺分类信息 /*SellercatsListGetRequest request1 = new SellercatsListGetRequest(); * request1.Fields = "cid,parent_cid,name,is_parent"; * request1.Nick = nick; * PageList<SellerCat> cat = client.SellercatsListGet(request1); * * for (int i = 0; i < cat.Content.Count; i++) * { * sql = "INSERT INTO TopTaobaoShopCat (" + * "cid, " + * "parent_cid, " + * "name, " + * "pic_url, " + * "sort_order, " + * "created, " + * "nick, " + * "modified " + * " ) VALUES ( " + * " '" + cat.Content[i].Cid + "', " + * " '" + cat.Content[i].ParentCid + "', " + * " '" + cat.Content[i].Name + "', " + * " '" + cat.Content[i].PicUrl + "', " + * " '" + cat.Content[i].SortOrder + "', " + * " '" + cat.Content[i].Created + "', " + * " '" + nick + "', " + * " '" + cat.Content[i].Modified + "' " + * ") "; * utils.ExecuteNonQuery(sql); * } */ //记录店铺所有商品信息-暂不记录 }