using Jd.Api; using Jd.Api.Request; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading; using BBWY.Common.Extensions; namespace BBWY.Test { public class JDBaoBiaoAPITest { /// /// 各维度各业务线调用测试 /// /// /// public void Test(IJdClient client, string token) { Console.WriteLine("----------------------计划维度 快车---------------------------"); var req1 = new AdsIbgUniversalJosServiceCampaignQueryRequest(); req1.startDay = "2022-10-16"; req1.endDay = "2022-10-16"; req1.businessType = "2"; //req5.accessPin = "腾奇666"; req1.clickOrOrderDay = "0"; req1.giftFlag = "0"; req1.clickOrOrderCaliber = "1"; req1.isDaily = "true"; req1.pageSize = "100"; req1.page = "1"; var res1 = client.Execute(req1, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res1)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------计划维度 京速推---------------------------"); var req2 = new AdsIbgUniversalJosServiceCampaignQueryRequest(); req2.startDay = "2022-10-16"; req2.endDay = "2022-10-16"; req2.businessType = "134217728"; //req6.accessPin = "腾奇666"; req2.clickOrOrderDay = "0"; req2.giftFlag = "0"; req2.clickOrOrderCaliber = "1"; req2.pageSize = "100"; req2.isDaily = "true"; var res2 = client.Execute(req2, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res2)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------计划维度 海投---------------------------"); var req3 = new AdsIbgUniversalJosServiceCampaignQueryRequest(); req3.startDay = "2022-10-05"; req3.endDay = "2022-10-05"; req3.businessType = "524288"; //reqjihuahaitouq6.accessPin = "腾奇666"; req3.clickOrOrderDay = "0"; req3.giftFlag = "0"; req3.clickOrOrderCaliber = "1"; req3.pageSize = "10"; req3.isDaily = "true"; var res3 = client.Execute(req3, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res3)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------单元维度 快车---------------------------"); var req4 = new AdsIbgUniversalJosServiceGroupQueryRequest(); req4.startDay = "2022-10-06"; req4.endDay = "2022-10-06"; req4.businessType = "2"; req4.clickOrOrderDay = "0"; req4.giftFlag = "0"; req4.clickOrOrderCaliber = "1"; req4.pageSize = "100"; req4.isDaily = "true"; var res4 = client.Execute(req4, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res4)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------单元维度 海投---------------------------"); var req5 = new AdsIbgUniversalJosServiceGroupQueryRequest(); req5.startDay = "2022-10-06"; req5.endDay = "2022-10-06"; req5.businessType = "524288"; req5.clickOrOrderDay = "0"; req5.giftFlag = "0"; req5.clickOrOrderCaliber = "1"; req5.pageSize = "50"; req5.isDaily = "true"; var res5 = client.Execute(req5, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res5)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------单元维度 京速推---------------------------"); var req6 = new AdsIbgUniversalJosServiceGroupQueryRequest(); req6.startDay = "2022-10-06"; req6.endDay = "2022-10-06"; req6.businessType = "134217728"; req6.clickOrOrderDay = "0"; req6.giftFlag = "0"; req6.clickOrOrderCaliber = "1"; req6.pageSize = "100"; req6.isDaily = "true"; var res6 = client.Execute(req6, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res6)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------创意维度 快车---------------------------"); var req7 = new AdsIbgUniversalJosServiceAdQueryRequest(); req7.businessType = "2"; req7.isDaily = "true"; req7.clickOrOrderDay = "0"; req7.clickOrOrderCaliber = "1"; req7.pageSize = "100"; req7.startDay = "2022-10-06"; req7.endDay = "2022-10-06"; req7.giftFlag = "0"; var res7 = client.Execute(req7, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res7)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------创意维度 海投---------------------------"); var req8 = new AdsIbgUniversalJosServiceAdQueryRequest(); req8.businessType = "524288"; req8.isDaily = "true"; req8.clickOrOrderDay = "0"; req8.clickOrOrderCaliber = "1"; req8.pageSize = "100"; req8.startDay = "2022-10-06"; req8.endDay = "2022-10-06"; req8.giftFlag = "0"; var res8 = client.Execute(req8, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res8)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------创意维度 京速推---------------------------"); var req9 = new AdsIbgUniversalJosServiceAdQueryRequest(); req9.businessType = "134217728"; req9.isDaily = "true"; req9.clickOrOrderDay = "0"; req9.clickOrOrderCaliber = "1"; req9.pageSize = "100"; req9.startDay = "2022-10-06"; req9.endDay = "2022-10-06"; req9.giftFlag = "0"; var res9 = client.Execute(req9, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res9)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------SKU维度 快车---------------------------"); var req10 = new AdsIbgUniversalJosServiceSkuQueryRequest(); req10.businessType = "2"; req10.isDaily = "true"; req10.clickOrOrderDay = "0"; req10.pageSize = "100"; req10.clickOrOrderCaliber = "1"; req10.startDay = "2022-10-16"; req10.endDay = "2022-10-16"; req10.giftFlag = "0"; var res10 = client.Execute(req10, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res10)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------SKU维度 海投---------------------------"); var req11 = new AdsIbgUniversalJosServiceSkuQueryRequest(); req11.businessType = "524288"; req11.isDaily = "true"; req11.clickOrOrderDay = "0"; req11.pageSize = "100"; req11.clickOrOrderCaliber = "1"; req11.startDay = "2022-10-16"; req11.endDay = "2022-10-16"; req11.giftFlag = "0"; var res11 = client.Execute(req11, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res11)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------SKU维度 京速推---------------------------"); var req12 = new AdsIbgUniversalJosServiceSkuQueryRequest(); req12.businessType = "134217728"; req12.isDaily = "true"; req12.clickOrOrderDay = "0"; req12.pageSize = "100"; req12.clickOrOrderCaliber = "1"; req12.startDay = "2022-10-16"; req12.endDay = "2022-10-16"; req12.giftFlag = "0"; req12.page = "1"; var res12 = client.Execute(req12, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res12)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------订单维度 快车---------------------------"); var req13 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req13.businessType = "2"; //req13.isDaily = "true"; req13.clickOrOrderDay = "0"; req13.pageSize = "100"; req13.clickOrOrderCaliber = "1"; req13.orderStartDay = "2022-10-06"; req13.orderEndDay = "2022-10-06"; req13.clickStartDay = "2022-10-06"; req13.clickEndDay = "2022-10-06"; req13.giftFlag = "0"; req13.orderStatus = "4"; req13.myself = "1,3"; //直接订单 var res13 = client.Execute(req13, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res13)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------订单维度 海投---------------------------"); var req14 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req14.businessType = "524288"; //req14.isDaily = "true"; req14.clickOrOrderDay = "0"; req14.pageSize = "100"; req14.clickOrOrderCaliber = "1"; req14.orderStartDay = "2022-10-16"; req14.orderEndDay = "2022-10-16"; req14.clickStartDay = "2022-10-16"; req14.clickEndDay = "2022-10-16"; req14.giftFlag = "0"; req14.orderStatus = "4"; req14.myself = "1,3"; //直接订单 var res14 = client.Execute(req14, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res14)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("----------------------订单维度 京速推---------------------------"); var req15 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req15.businessType = "134217728"; //req15.isDaily = "true"; req15.clickOrOrderDay = "0"; req15.pageSize = "100"; req15.clickOrOrderCaliber = "1"; req15.orderStartDay = "2022-10-16"; req15.orderEndDay = "2022-10-16"; req15.clickStartDay = "2022-10-16"; req15.clickEndDay = "2022-10-16"; req15.giftFlag = "0"; req15.myself = "1,3"; //直接订单 req15.orderStatus = "4"; var res15 = client.Execute(req15, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res15)); Console.WriteLine(); Console.WriteLine(); } /// /// SKU维度-京速推业务线-指定pin请求报表 /// /// /// /// public void Test1(IJdClient client, string token) { var pageIndex = 1; while (true) { SyncShopPopularizeReportFormSkuLevel(client, token, pageIndex, out int count); if (count < 100) break; pageIndex++; Thread.Sleep(2000); } } private void SyncShopPopularizeReportFormSkuLevel(IJdClient client, string token, int pageIndex, out int currentCount) { currentCount = 0; var req12 = new AdsIbgUniversalJosServiceSkuQueryRequest(); req12.businessType = "134217728"; req12.isDaily = "true"; req12.clickOrOrderDay = "0"; req12.pageSize = "100"; req12.clickOrOrderCaliber = "1"; req12.startDay = "2022-10-16"; req12.endDay = "2022-10-16"; req12.giftFlag = "0"; req12.page = pageIndex.ToString(); req12.accessPin = "布莱特采苓"; var res12 = client.Execute(req12, token, DateTime.Now.ToLocalTime()); if (res12.Json == null) res12.Json = JsonConvert.DeserializeObject(res12.Body); //Console.WriteLine($"----page {pageIndex}----"); //Console.WriteLine(res12.Body); var j = (JArray)res12.Json["jingdong_ads_ibg_UniversalJosService_sku_query_responce"]["returnType"]["data"]["datas"]; currentCount = j.Count(); var sum = j.Select(j => new { Cost = j.Value("cost"), }).Sum(x => x.Cost); Console.WriteLine($"page {pageIndex} sum {sum}"); } public void Test2(IJdClient client, string token) { var req13 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req13.businessType = "2"; //req13.isDaily = "true"; req13.clickOrOrderDay = "0"; req13.pageSize = "100"; req13.clickOrOrderCaliber = "1"; req13.orderStartDay = "2022-10-16"; req13.orderEndDay = "2022-10-16"; req13.clickStartDay = "2022-10-16"; req13.clickEndDay = "2022-10-16"; req13.giftFlag = "0"; req13.orderStatus = "4"; req13.orderType = "1"; req13.myself = "1,3"; var res13 = client.Execute(req13, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res13)); //Console.WriteLine(); //Console.WriteLine(); var req14 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req14.businessType = "134217728"; //req13.isDaily = "true"; req14.clickOrOrderDay = "0"; req14.pageSize = "100"; req14.clickOrOrderCaliber = "1"; req14.orderStartDay = "2022-10-16"; req14.orderEndDay = "2022-10-16"; req14.clickStartDay = "2022-10-16"; req14.clickEndDay = "2022-10-16"; req14.giftFlag = "0"; req14.orderStatus = "4"; req14.orderType = "1"; req14.myself = "1,3"; var res14 = client.Execute(req14, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res14)); } /// /// SKU维度-京速推业务线-指定pin请求报表 /// /// /// /// public void TestJihua_JST(IJdClient client, string token, string accessPin) { var pageIndex = 1; while (true) { SyncShopPopularizeReportFormJHJSTLevel(client, token, accessPin, pageIndex, out int count); if (count < 100) break; pageIndex++; Thread.Sleep(2000); } } private void SyncShopPopularizeReportFormJHJSTLevel(IJdClient client, string token, string accessPin, int pageIndex, out int currentCount) { currentCount = 0; var req12 = new AdsIbgUniversalJosServiceCampaignQueryRequest(); req12.businessType = "134217728"; req12.isDaily = "true"; req12.clickOrOrderDay = "0"; req12.pageSize = "100"; req12.clickOrOrderCaliber = "1"; req12.startDay = "2022-10-16"; req12.endDay = "2022-10-16"; req12.giftFlag = "0"; req12.page = pageIndex.ToString(); req12.accessPin = accessPin; var res12 = client.Execute(req12, token, DateTime.Now.ToLocalTime()); if (res12.Json == null) res12.Json = JsonConvert.DeserializeObject(res12.Body); var j = (JArray)res12.Json["jingdong_ads_ibg_UniversalJosService_campaign_query_responce"]["returnType"]["data"]["datas"]; currentCount = j.Count(); var sum = j.Select(j => new { Cost = j.Value("cost"), }).Sum(x => x.Cost); Console.WriteLine($"{accessPin} page {pageIndex} sum {sum}"); } public void Test3(IJdClient client, string token) { var req_skuList = new SkuReadSearchSkuListRequest() { pageSize = 50,//50 field = "logo,saleAttrs,status,created,stockNum" }; req_skuList.wareId = "10020608258057"; req_skuList.skuId = "10025684228553"; //else if (!string.IsNullOrEmpty(searchProductSkuRequest.Sku)) // req_skuList.skuId = searchProductSkuRequest.Sku; var res = client.Execute(req_skuList, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); //return ((JArray)rep_skuList.Json["jingdong_sku_read_searchSkuList_responce"]["page"]["data"]).Select(s => new ProductSkuResponse() //{ // Id = s.Value("skuId"), // ProductId = s.Value("wareId"), // Price = s.Value("jdPrice"), // Title = s["saleAttrs"] != null ? string.Join("-", s["saleAttrs"].Select(a => a["attrValueAlias"][0].ToString())) : string.Empty, // Logo = $"https://img13.360buyimg.com/n9/s80x80_{s.Value("logo")}", // State = s.Value("status"), // CreateTime = s.Value("created").StampToDateTime() //}).ToList(); } public void Test4(IJdClient client, string token) { StockReadFindSkuStockRequest req = new StockReadFindSkuStockRequest(); req.skuId = 10025684228553; //req.field = ""; var response = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(response)); } public void Test_获取仓库(IJdClient client, string token) { Console.WriteLine("获取仓库信息"); var req1 = new EclpMasterQueryWarehouseRequest(); req1.deptNo = "EBU4418054732484"; //req1.warehouseNos = ""; req1.status = "1,2"; var res = client.Execute(req1, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); Console.WriteLine(); Console.WriteLine("查询仓库信息"); var req2 = new StoreFindPartitionWhByIdAndStatusRequest(); req2.status = "2"; var res2 = client.Execute(req2, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res2)); } public void Test_仓库实物库存查询(IJdClient client, string token) { EclpStockQueryStockRequest req = new EclpStockQueryStockRequest(); req.deptNo = "EBU4418054732484"; req.warehouseNo = "110008199"; //0,10001,110007548,110007637,110008199 //req.stockStatus = ; //req.stockType = ; //req.goodsNo = ; req.currentPage = 1; //req.pageSize = 100; //req.returnZeroStock = ; //req.returnIsvLotattrs = ; //req.goodsLevel = ; //req.isvSku = ; //req.sellerGoodsSign = ; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_店铺库存查询(IJdClient client, string token) { var req = new EclpStockSearchShopStockRequest(); req.requestId = Guid.NewGuid().ToString(); req.deptNo = "EBU4418054732484"; //req.shopNo = ; //req.warehouseNo = ; // //req.goodsNo = ; req.pageSize = "100"; req.pageNumber = "1"; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_获取sku库存信息(IJdClient client, string token) { StockReadFindSkuStockRequest req = new StockReadFindSkuStockRequest(); req.skuId = 10045325302420; //req.field = "abc,def,hgj"; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_创意维度(IJdClient client, string token,string startDay, string endDay) { var req = new AdsIbgUniversalJosServiceAdQueryRequest(); req.businessType = "2"; req.isDaily = "true"; req.clickOrOrderDay = "0"; req.pageSize = "100"; req.page = "1"; req.clickOrOrderCaliber = "1"; req.startDay = startDay; req.endDay = endDay; req.giftFlag = "0"; req.orderStatusCategory = "1"; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_订单维度_快车(IJdClient client, string token, int page = 1) { Console.WriteLine($"订单维度_快车 page {page}"); var req13 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req13.businessType = "2"; //req13.isDaily = "true"; req13.clickOrOrderDay = "15"; req13.pageSize = "100"; req13.clickOrOrderCaliber = "1"; req13.orderStartDay = "2022-10-01"; req13.orderEndDay = "2022-10-31"; req13.clickStartDay = "2022-10-01"; req13.clickEndDay = "2022-10-31"; req13.giftFlag = "0"; //req13.orderStatus = "4"; req13.myself = "1,3"; //直接订单 req13.page = page.ToString(); var res13 = client.Execute(req13, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res13)); Console.WriteLine(); Console.WriteLine(); } public void Test_订单维度_京速推(IJdClient client, string token) { var req13 = new AdsIbgUniversalJosServiceOrderQueryRequest(); req13.businessType = "134217728"; //req13.isDaily = "true"; req13.clickOrOrderDay = "0"; req13.pageSize = "100"; req13.clickOrOrderCaliber = "1"; req13.orderStartDay = "2022-10-01"; req13.orderEndDay = "2022-10-30"; req13.clickStartDay = "2022-10-01"; req13.clickEndDay = "2022-10-30"; req13.giftFlag = "0"; //req13.orderStatus = "4"; req13.myself = "1,3"; //直接订单 var res4 = client.Execute(req13, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res4)); Console.WriteLine(); Console.WriteLine(); } public void Test_获取订单优惠明细(IJdClient client, string token) { var req = new PopOrderCoupondetailRequest(); req.orderId = 256709823974; var response = client.Execute(req, token, DateTime.Now.ToLocalTime()); var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_FindSku(IJdClient client, string token) { StockReadFindSkuStockRequest req = new StockReadFindSkuStockRequest(); req.skuId = 10042760172349;// 10036238533172; //京仓sku //req.field = "abc,def,hgj"; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_获取事业部编码(IJdClient client, string token) { EclpMasterQueryDeptRequest req = new EclpMasterQueryDeptRequest(); // req.deptNos = ; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_查询仓库(IJdClient client, string token) { StoreFindPartitionWhByIdAndStatusRequest req = new StoreFindPartitionWhByIdAndStatusRequest(); req.status = "2"; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } public void Test_查询京仓库存(IJdClient client, string token) { EclpStockQueryStockRequest req = new EclpStockQueryStockRequest(); req.deptNo = "EBU4418054732484"; req.warehouseNo = "110029845"; //成都亚一公共平台仓1号库 //req.stockStatus = ; //req.stockType = ; //req.goodsNo = ; req.currentPage =1 ; //req.pageSize = "100"; //req.returnZeroStock = ; //req.returnIsvLotattrs = ; //req.goodsLevel = ; //req.isvSku = ; //req.sellerGoodsSign = ; var res = client.Execute(req, token, DateTime.Now.ToLocalTime()); Console.WriteLine(JsonConvert.SerializeObject(res)); } } }