步步为盈
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

713 lines
26 KiB

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
{
/// <summary>
/// 各维度各业务线调用测试
/// </summary>
/// <param name="client"></param>
/// <param name="token"></param>
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();
}
/// <summary>
/// SKU维度-京速推业务线-指定pin请求报表
/// </summary>
/// <param name="client"></param>
/// <param name="token"></param>
/// <param name="accessPin"></param>
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<JObject>(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<decimal>("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));
}
/// <summary>
/// SKU维度-京速推业务线-指定pin请求报表
/// </summary>
/// <param name="client"></param>
/// <param name="token"></param>
/// <param name="accessPin"></param>
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<JObject>(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<decimal>("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<string>("skuId"),
// ProductId = s.Value<string>("wareId"),
// Price = s.Value<decimal>("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<string>("logo")}",
// State = s.Value<int>("status"),
// CreateTime = s.Value<long>("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));
}
}
}