dataHelper.cs 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035
  1. using BizCom;
  2. using Castle.ActiveRecord.Framework.Internal;
  3. using Newtonsoft.Json;
  4. using Newtonsoft.Json.Linq;
  5. using NHibernate.Mapping;
  6. using NPOI.POIFS.Properties;
  7. using NPOI.SS.Formula.Functions;
  8. using NPOI.SS.UserModel;
  9. using SiteCore.Handler;
  10. using SiteCore.Redis;
  11. using SiteCore.taobao;
  12. using SiteCore.taoObj;
  13. using SQLData;
  14. using System;
  15. using System.Collections;
  16. using System.Collections.Generic;
  17. using System.Collections.Specialized;
  18. using System.Data;
  19. using System.Diagnostics;
  20. using System.Linq;
  21. using System.Net;
  22. using System.Net.Http;
  23. using System.Net.Http.Headers;
  24. using System.Reflection;
  25. using System.Runtime.Remoting.Messaging;
  26. using System.Runtime.Remoting.Metadata.W3cXsd2001;
  27. using System.Security.Cryptography;
  28. using System.Security.Policy;
  29. using System.Security.Principal;
  30. using System.Text;
  31. using System.Threading.Tasks;
  32. using System.Web;
  33. using System.Web.Routing;
  34. using Utils.Serialization;
  35. using static SiteCore.taoObj.dataShopResponseVo;
  36. using static SiteCore.taoObj.dataSpuInfoResponseVo;
  37. using static SiteCore.taoObj.work_core_vo;
  38. namespace SiteCore.Handler
  39. {
  40. public class dataHelper : BaseHandler, IHttpHandler
  41. {
  42. public void ProcessRequest(HttpContext context)
  43. {
  44. if (UrlParmsCheck("t"))
  45. {
  46. String tname = GetString("t");
  47. MethodInfo method;
  48. Type type = this.GetType();
  49. method = type.GetMethod(tname);
  50. con = context;
  51. if (method == null)
  52. {
  53. conError("找不到对应方法,服务器返回错误");
  54. return;
  55. }
  56. successFlag = false;
  57. context.Response.ContentType = "application/json";
  58. context.Response.Headers.Set("Access-Control-Allow-Origin", "*");
  59. try
  60. {
  61. method.Invoke(this, null);
  62. }
  63. catch (Exception ex)
  64. {
  65. conError("处理接口错误,服务器返回错误");
  66. }
  67. finally
  68. {
  69. }
  70. }
  71. }
  72. public static string GetMD5Hash(string input)
  73. {
  74. // 创建一个MD5对象
  75. using (MD5 md5 = MD5.Create())
  76. {
  77. // 将输入字符串转换为字节数组
  78. byte[] inputBytes = Encoding.UTF8.GetBytes(input);
  79. // 计算输入字节数组的哈希值
  80. byte[] hashBytes = md5.ComputeHash(inputBytes);
  81. // 将字节数组转换为字符串
  82. StringBuilder hashString = new StringBuilder();
  83. foreach (byte b in hashBytes)
  84. {
  85. hashString.AppendFormat("{0:x2}", b);
  86. }
  87. return hashString.ToString();
  88. }
  89. }
  90. Dictionary<string, string> keysMap = new Dictionary<string, string>()
  91. {
  92. {"UzJwXAhiD9","GFyIeZLRIATXMJYnsc5nZPAwK9" },
  93. };
  94. public void productInfo()
  95. {
  96. bool result = checkParams();
  97. if (!result)
  98. {
  99. return;
  100. }
  101. string productName = GetPostString("productName");
  102. string id = GetPostString("id");
  103. if (string.IsNullOrEmpty(productName))
  104. {
  105. returnErrorMsg("参数没有产品名称");
  106. return;
  107. }
  108. if (string.IsNullOrEmpty(id))
  109. {
  110. returnErrorMsg("参数没有产品id");
  111. return;
  112. }
  113. CeErpProduct ceErpProduct = CeErpProduct.GetByName(id);
  114. bool isCreate = false;
  115. if (ceErpProduct == null)
  116. {
  117. ceErpProduct = new CeErpProduct();
  118. isCreate = true;
  119. }
  120. ceErpProduct.uuid = id;
  121. ceErpProduct.PType = productName;
  122. ceErpProduct.UpdateTime = DateTime.Now;
  123. ceErpProduct.UpdateUserName = "朱义义";
  124. if (!isCreate)
  125. {
  126. ceErpProduct.Update();
  127. }
  128. else
  129. {
  130. ceErpProduct.CreateTime = ceErpProduct.UpdateTime;
  131. ceErpProduct.CreateUserName = ceErpProduct.UpdateUserName;
  132. ceErpProduct.Create();
  133. }
  134. returnSuccessMsg("创建成功!");
  135. }
  136. public bool checkParams()
  137. {
  138. string appKey = GetPostString("appKey");
  139. string appSecret = "";
  140. if (!keysMap.ContainsKey(appKey))
  141. {
  142. returnErrorMsg("appKey不存在");
  143. return false;
  144. }
  145. keysMap.TryGetValue(appKey, out appSecret);
  146. if (appSecret == "")
  147. {
  148. returnErrorMsg("appSecret不存在");
  149. return false;
  150. }
  151. double timestamp = GetPostDouble("timestamp");//秒级时间戳
  152. if (timestamp == 0)
  153. {
  154. returnErrorMsg("时间戳不存在");
  155. return false;
  156. }
  157. DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
  158. dtDateTime = dtDateTime.AddSeconds(timestamp).ToLocalTime();
  159. if (dtDateTime != null && dtDateTime.CompareTo(DateTime.Now.AddMinutes(-5)) < 0)
  160. {
  161. returnErrorMsg("请求失效");
  162. return false;
  163. }
  164. string sign = GetPostString("sign");
  165. if (string.IsNullOrEmpty(sign))
  166. {
  167. returnErrorMsg("签名不存在");
  168. return false;
  169. }
  170. string param = appKey + timestamp + appSecret;
  171. string localSign = GetMD5Hash(param);
  172. if (!localSign.Equals(sign))
  173. {
  174. returnErrorMsg("签名错误");
  175. return false;
  176. }
  177. return true;
  178. }
  179. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=get_order_info post请求参数(参数放body中):string tid(淘宝订单号)
  180. public void get_order_info()
  181. {
  182. bool result = checkParams();
  183. if (!result)
  184. {
  185. return;
  186. }
  187. string code = GetPostString("code");
  188. if (string.IsNullOrEmpty(code))
  189. {
  190. returnErrorMsg("参数错误");
  191. return;
  192. }
  193. CeErpTradeCell ceErpTradeCell = CeErpTradeCell.GetByCode(code);
  194. if (ceErpTradeCell == null)
  195. {
  196. returnErrorMsg("查无订单");
  197. return;
  198. }
  199. CeErpTrade ceErpTrade = CeErpTrade.Get(ceErpTradeCell.tid);
  200. Dictionary<string, object> data = new Dictionary<string, object>();
  201. data.Add("ctid", ceErpTradeCell.ctid);
  202. if (ceErpTrade != null)
  203. {
  204. data.Add("province", ceErpTrade.receiver_state);
  205. }
  206. ReturnSuccess(JsonConvert.SerializeObject(data));
  207. return;
  208. }
  209. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=get_cell_info post请求参数(参数放body中):string tid(淘宝订单号)
  210. public void get_shop_code()
  211. {
  212. bool result = checkParams();
  213. if (!result)
  214. {
  215. return;
  216. }
  217. string name = GetPostString("name");
  218. if (string.IsNullOrEmpty(name))
  219. {
  220. returnErrorMsg("参数错误");
  221. return;
  222. }
  223. string code = "";
  224. string key = "shopName_code_" + name;
  225. if (RedisHelper.HasKey(key))
  226. {
  227. code = RedisHelper.StringGet(key).ToString();
  228. }
  229. if (code == "")
  230. {
  231. CeErpShop shop = CeErpShop.GetShopIdByName(name);
  232. if (shop == null)
  233. {
  234. returnErrorMsg("无店铺");
  235. return;
  236. }
  237. code = shop.SName;
  238. RedisHelper.StringSet(key, code);
  239. }
  240. Dictionary<string, object> data = new Dictionary<string, object>();
  241. data.Add("code", code);
  242. ReturnSuccess(JsonConvert.SerializeObject(data));
  243. return;
  244. }
  245. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=get_cell_info post请求参数(参数放body中):string tid(淘宝订单号)
  246. public void get_cell_info()
  247. {
  248. string tid = GetPostString("tid");
  249. string name = GetPostString("nickName");
  250. string where = "";
  251. List<string> rows = new List<string>();
  252. if (!string.IsNullOrEmpty(tid))
  253. {
  254. rows.Add(string.Format(" tid = '{0}' ", tid));
  255. }
  256. if (!string.IsNullOrEmpty(name))
  257. {
  258. rows.Add(string.Format(" buyer_nick = '{0}' ", name));
  259. }
  260. where = string.Join("and", rows);
  261. if (where == "")
  262. {
  263. returnErrorMsg("缺少必要参数");
  264. return;
  265. }
  266. string sql = string.Format("SELECT tid,ctid,payment,ProductName,OrderState,Material,Craft,ProductSize,ProductCount,posCode,seller_nick,buyer_nick,buyer_id,FinishDesignTime FROM [dbo].[view_ErpTradeCell] WHERE {0}", where);
  267. DataTable dataTable = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
  268. List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
  269. if (dataTable != null && dataTable.Rows.Count > 0)
  270. {
  271. Dictionary<string, object> data = new Dictionary<string, object>();
  272. foreach (DataRow row in dataTable.Rows)
  273. {
  274. int OrderState = Convert.ToInt32(row["OrderState"]);
  275. string state = "";
  276. if (OrderState < 7)
  277. {
  278. state = "待发货";
  279. }
  280. else if (OrderState == 7)
  281. {
  282. state = "已发货";
  283. }
  284. else if (OrderState == 8)
  285. {
  286. state = "交易完成";
  287. }
  288. else if (OrderState == 9)
  289. {
  290. state = "交易关闭";
  291. }
  292. data = new Dictionary<string, object>();
  293. data.Add("tid", row["tid"]);
  294. data.Add("OrderState", state);
  295. data.Add("state", OrderState);
  296. data.Add("shopCode", row["posCode"]);
  297. data.Add("buyerNick", row["buyer_nick"]);
  298. data.Add("buyerId", row["buyer_id"]);
  299. data.Add("shopName", row["seller_nick"]);
  300. data.Add("ctid", row["ctid"]);
  301. data.Add("payment", row["payment"]);
  302. data.Add("Material", row["Material"]);
  303. data.Add("Craft", row["Craft"]);
  304. data.Add("ProductSize", row["ProductSize"]);
  305. data.Add("ProductCount", row["ProductCount"]);
  306. data.Add("ProductName", row["ProductName"]);
  307. data.Add("FinishDesignTime", row["FinishDesignTime"]);
  308. list.Add(data);
  309. }
  310. }
  311. ReturnSuccess(JsonConvert.SerializeObject(list));
  312. return;
  313. }
  314. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=update_spu_info post请求参数(参数放body中):string spuId(淘宝订单号)
  315. public void update_spu_info()
  316. {
  317. string spuId = GetPostString("spuId");
  318. string category = GetPostString("category");
  319. string serialNumber = GetPostString("serialNumber");
  320. string operate = GetPostString("operate");
  321. string designer = GetPostString("designer");
  322. string atta = GetPostString("atta");
  323. string upTime = GetPostString("upTime");
  324. int shopId = GetPostInt("shopId");
  325. if (!string.IsNullOrEmpty(spuId))
  326. {
  327. CeErpTradeSpu spu = CeErpTradeSpu.GetBySpuId(spuId);
  328. if (spu == null)
  329. {
  330. returnErrorMsg("找不到对应id");
  331. return;
  332. }
  333. spu.category = category;
  334. spu.serialNumber = serialNumber;
  335. spu.operate = operate;
  336. spu.designer = designer;
  337. spu.atta = atta;
  338. spu.shopId = shopId;
  339. spu.upTime = DateTime.Parse(upTime);
  340. spu.Update();
  341. returnSuccess("修改成功!");
  342. return;
  343. }
  344. returnErrorMsg("缺少必要参数");
  345. }
  346. static string pUrl = "http://36.140.138.139:688/api/";
  347. static string CLIENT_Id = "xclient";
  348. static string CLIENT_SECRET = "0a417ecce58c31b32364ce19ca8fcd15";
  349. static string USER_ID = "ca2d316357fa4e09b9c2aa9f7b2ca3d9";
  350. public static string getSaleOrderSn()
  351. {
  352. string orderSn = "";
  353. string post_url = "http://api.presales.lingtao8.com/open/order/generateSplitOrderUniqueNos/1";
  354. try
  355. {
  356. string remoteInfo = httpSaleContent(HttpMethod.Get, post_url, new Dictionary<string, string>());
  357. saleOrderResponse dataTokenBean = JsonConvert.DeserializeObject<saleOrderResponse>(remoteInfo);
  358. if ("200".Equals(dataTokenBean.code))
  359. {
  360. orderSn = dataTokenBean.data[0];
  361. }
  362. }
  363. catch (Exception ex)
  364. {
  365. }
  366. return orderSn;
  367. }
  368. public static void api_orderBack(string orderNumber, string state, string content)
  369. {
  370. string post_url = "http://api.presales.lingtao8.com/open/order/orderProcessReturn";
  371. //string post_url = "http://admin.lingtao.zmht888.com/prod-api/open/order/orderProcessReturn";
  372. string remoteInfo = "";
  373. string param = JsonConvert.SerializeObject(new
  374. {
  375. orderSplitNo = orderNumber,
  376. errorStatus = state,
  377. reason = content
  378. });
  379. Dictionary<string, string> map = new Dictionary<string, string>();
  380. map.Add("orderSplitNo", orderNumber);
  381. map.Add("errorStatus", state);
  382. map.Add("reason", content);
  383. try
  384. {
  385. remoteInfo = httpSaleContent(HttpMethod.Post, post_url, map);
  386. }
  387. catch (Exception ex)
  388. {
  389. XLog.SaveLog(0, "api_orderBack:" + ex.Message);
  390. }
  391. }
  392. public static string getToken()
  393. {
  394. //return "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYXBpIl0sInNjb3BlIjpbInJlYWQiLCJ3cml0ZSJdLCJleHAiOjE3MzU5NjU0ODAsImF1dGhvcml0aWVzIjpbIm9wZW5hcGkiXSwianRpIjoiYjY4NTRhZjctZjNmMy00OTU0LTk4ZmUtZDRlZTE4ZDllNzQyIiwiY2xpZW50X2lkIjoieGNsaWVudCJ9.E6U0NVMZPcUypl4P7L5718J1X8UxSJg9R7vZX_oMkuEJ-yelNXuYwu7-eAi1JTgIJ0GuuviQu-KEAH-W7sHb7t-JJJc-wLPMsLKmpwQDG2EpiRK5hW5ZmyUgL8rPuTUawKVP5k8SGrN60sVyXA2zKm4ztEQ39EGudXnam1Lld2w";
  395. string token = "";
  396. if (RedisHelper.HasKey("xclient_token"))
  397. {
  398. token = RedisHelper.StringGet("xclient_token").ToString();
  399. return token;
  400. }
  401. string post_url = pUrl + "oauth/token";
  402. WebClient wc = new WebClient();
  403. wc.Encoding = Encoding.GetEncoding("utf-8");
  404. List<string> headers = new List<string>();
  405. headers.Add("grant_type=client_credentials");
  406. headers.Add("client_id=" + CLIENT_Id);
  407. headers.Add("client_secret=" + CLIENT_SECRET);
  408. post_url += "?" + string.Join("&", headers);
  409. NameValueCollection PostVars = new NameValueCollection();
  410. string remoteInfo = "";
  411. try
  412. {
  413. byte[] ret = wc.UploadValues(post_url, "POST", PostVars);
  414. remoteInfo = Encoding.GetEncoding("utf-8").GetString(ret);
  415. //remoteInfo = "{\"access_token\":\"eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYXBpIl0sInNjb3BlIjpbInJlYWQiLCJ3cml0ZSJdLCJleHAiOjE3MjM3OTk0MTUsImF1dGhvcml0aWVzIjpbIm9wZW5hcGkiXSwianRpIjoiZjdhOGVjNmMtOWUyMS00MDZhLWEzNzktYjI0MTU3OTE0ODJmIiwiY2xpZW50X2lkIjoieGNsaWVudCJ9.EL-El6M9AVXvH_hp9E4wqM17sHwynyJBDcZJHYw4AYdJrYAWHEu78-Gn3Hj4FyfDaIkqNk641XSAfVpTiH_sFeTSl8-glSJEeD7OFKSkoJjrj0_Ft7kFZZs0XAhbgo4m5rI3Qbeq_87_0K5wKqRcygjUee82MFcIDueTcUg3p9c\",\"token_type\":\"bearer\",\"expires_in\":2052,\"scope\":\"read write\",\"jti\":\"f7a8ec6c-9e21-406a-a379-b2415791482f\",\"aud\":[\"api\"],\"exp\":1723799415,\"authorities\":[\"openapi\"],\"client_id\":\"xclient\"}";
  416. dataTokenBean dataTokenBean = JsonConvert.DeserializeObject<dataTokenBean>(remoteInfo);
  417. token = dataTokenBean.access_token;
  418. RedisHelper.StringSet("xclient_token", token, new TimeSpan(0, 15, 0));
  419. }
  420. catch (Exception ex)
  421. {
  422. }
  423. return token;
  424. }
  425. /// <summary>
  426. /// 获取店铺信息
  427. /// </summary>
  428. /// <param name="shopId"></param>
  429. /// <returns></returns>
  430. public static shopInfo getShopDataInfo(string shopId)
  431. {
  432. try
  433. {
  434. string post_url = pUrl + "openapi/v3/bo/list";
  435. string param = JsonConvert.SerializeObject(new
  436. {
  437. schemaCode = "Store_01",
  438. userId = USER_ID,
  439. queryCondition = new
  440. {
  441. operatorType = 1,
  442. propertyCode = "ErpshopId",
  443. propertyValue = shopId
  444. }
  445. });
  446. string data = httpContent(post_url, param);
  447. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  448. if ("0".Equals(dataResponseVos.errcode))
  449. {
  450. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  451. {
  452. return dataResponseVos.data.bizObjectPage.content[0].data;
  453. }
  454. }
  455. }
  456. catch (Exception ex)
  457. {
  458. }
  459. return null;
  460. }
  461. /// <summary>
  462. /// 获取spu信息
  463. /// </summary>
  464. /// <param name="spuId"></param>
  465. /// <returns></returns>
  466. public static spuInfo getSpuInfo(string spuId)
  467. {
  468. try
  469. {
  470. string post_url = pUrl + "openapi/v3/bo/list";
  471. string param = JsonConvert.SerializeObject(new
  472. {
  473. schemaCode = "lianjieku_01_01",
  474. userId = USER_ID,
  475. queryCondition = new
  476. {
  477. operatorType = 1,
  478. propertyCode = "ShortText1728890649488",
  479. propertyValue = spuId
  480. }
  481. });
  482. string data = httpContent(post_url, param);
  483. dataSpuInfoResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataSpuInfoResponseVo>(data);
  484. if ("0".Equals(dataResponseVos.errcode))
  485. {
  486. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  487. {
  488. return dataResponseVos.data.bizObjectPage.content[0].data;
  489. }
  490. }
  491. }
  492. catch (Exception ex)
  493. {
  494. }
  495. return null;
  496. }
  497. /// <summary>
  498. /// 订单发货是否存在
  499. /// </summary>
  500. /// <param name="dataSendOrderBean"></param>
  501. /// <returns></returns>
  502. public static string checkOrderAlready(dataSendOrderBean dataSendOrderBean)
  503. {
  504. try
  505. {
  506. string post_url = pUrl + "openapi/v3/bo/list";
  507. string param = JsonConvert.SerializeObject(new
  508. {
  509. schemaCode = "dingdanfahuo_01",
  510. userId = USER_ID,
  511. queryCondition = new
  512. {
  513. operatorType = 1,
  514. propertyCode = "ShortText1723707899761",
  515. propertyValue = dataSendOrderBean.ShortText1723707899761
  516. }
  517. });
  518. string data = httpContent(post_url, param);
  519. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  520. if ("0".Equals(dataResponseVos.errcode))
  521. {
  522. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  523. {
  524. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  525. }
  526. return "";
  527. }
  528. }
  529. catch (Exception ex)
  530. {
  531. }
  532. return "";
  533. }
  534. /// <summary>
  535. /// 车间id获取信息
  536. /// </summary>
  537. /// <param name="supplerId"></param>
  538. /// <returns></returns>
  539. public static string getSupplerDataInfo(string supplerId)
  540. {
  541. try
  542. {
  543. string post_url = pUrl + "openapi/v3/bo/list";
  544. string param = JsonConvert.SerializeObject(new
  545. {
  546. schemaCode = "gongyingshang_01",
  547. userId = USER_ID,
  548. queryCondition = new
  549. {
  550. operatorType = 1,
  551. propertyCode = "ErpSupplierId",
  552. propertyValue = supplerId
  553. }
  554. });
  555. string data = httpContent(post_url, param);
  556. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  557. if ("0".Equals(dataResponseVos.errcode))
  558. {
  559. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  560. {
  561. return dataResponseVos.data.bizObjectPage.content[0].data.id;
  562. }
  563. }
  564. }
  565. catch (Exception ex)
  566. {
  567. }
  568. return "";
  569. }
  570. /// <summary>
  571. /// 推送发货信息
  572. /// </summary>
  573. /// <param name="dataSendOrderBean"></param>
  574. /// <returns></returns>
  575. public static dataResponseVo CreateBoFahuo(dataSendOrderBean dataSendOrderBean)
  576. {
  577. string post_url = pUrl + "openapi/v3/bo/create";
  578. shopInfo shop = getShopDataInfo(dataSendOrderBean.RelevanceForm1723191239149);
  579. if (shop != null)
  580. {
  581. dataSendOrderBean.RelevanceForm1723191239149 = shop.id;
  582. }
  583. dataSendOrderBean.RelevanceForm1723191634028 = getSupplerDataInfo(dataSendOrderBean.RelevanceForm1723191634028);
  584. string bizObjectId = checkOrderAlready(dataSendOrderBean);
  585. if (!string.IsNullOrEmpty(bizObjectId))
  586. {
  587. post_url = pUrl + "openapi/v3/bo/update";
  588. dataSendOrderBean.id = bizObjectId;
  589. }
  590. string param = JsonConvert.SerializeObject(new
  591. {
  592. schemaCode = "dingdanfahuo_01",
  593. userId = USER_ID,
  594. data = dataSendOrderBean
  595. });
  596. dataResponseVo dataResponseVos = null;
  597. try
  598. {
  599. string data = httpContent(post_url, param);
  600. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  601. return dataResponseVos;
  602. }
  603. catch (Exception ex)
  604. {
  605. dataResponseVos = new dataResponseVo();
  606. dataResponseVos.errcode = "1";
  607. dataResponseVos.errmsg = ex.Message;
  608. }
  609. return dataResponseVos;
  610. }
  611. /// <summary>
  612. /// 推送spu信息
  613. /// </summary>
  614. /// <param name="bean"></param>
  615. /// <returns></returns>
  616. public static dataResponseVo sendSpuInfo(dataSendSpuBean bean)
  617. {
  618. string post_url = pUrl + "openapi/v3/bo/create";
  619. shopInfo shop = getShopDataInfo(bean.shopId);
  620. if (shop != null)
  621. {
  622. bean.RelevanceForm1728891053364 = shop.id;
  623. bean.operation = shop.operation;
  624. }
  625. spuInfo info = getSpuInfo(bean.ShortText1728890649488);
  626. if (info != null)
  627. {
  628. bean.StaffSingle1728891078584 = info.StaffSingle1728891078584;
  629. bean.Date1728891021647 = info.Date1728891021647;
  630. bean.ShortText1729677042659 = info.ShortText1729677067460;
  631. bean.ShortText1728891031267 = info.ShortText1728891031267;
  632. }
  633. string param = JsonConvert.SerializeObject(new
  634. {
  635. schemaCode = "lianjieku_01",
  636. userId = USER_ID,
  637. data = bean
  638. });
  639. dataResponseVo dataResponseVos = null;
  640. try
  641. {
  642. string data = httpContent(post_url, param);
  643. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  644. return dataResponseVos;
  645. }
  646. catch (Exception ex)
  647. {
  648. dataResponseVos = new dataResponseVo();
  649. dataResponseVos.errcode = "1";
  650. dataResponseVos.errmsg = ex.Message;
  651. }
  652. return dataResponseVos;
  653. }
  654. /// <summary>
  655. /// 主订单数据
  656. /// </summary>
  657. /// <param name="bean"></param>
  658. /// <returns></returns>
  659. public static dataResponseVo sendErpTradeInfo(dataSendTradeBean bean)
  660. {
  661. string post_url = pUrl + "openapi/v3/bo/create";
  662. string bizObjectId = checkErpTradeAlready(bean);
  663. if (!string.IsNullOrEmpty(bizObjectId))
  664. {
  665. post_url = pUrl + "openapi/v3/bo/update";
  666. bean.id = bizObjectId;
  667. }
  668. string param = JsonConvert.SerializeObject(new
  669. {
  670. schemaCode = "zhudingdan_01",
  671. userId = USER_ID,
  672. data = bean
  673. });
  674. dataResponseVo dataResponseVos = null;
  675. try
  676. {
  677. string data = httpContent(post_url, param);
  678. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  679. return dataResponseVos;
  680. }
  681. catch (Exception ex)
  682. {
  683. dataResponseVos = new dataResponseVo();
  684. dataResponseVos.errcode = "1";
  685. dataResponseVos.errmsg = ex.Message;
  686. }
  687. return dataResponseVos;
  688. }
  689. /// <summary>
  690. /// 校验主订单是否存在
  691. /// </summary>
  692. /// <param name="dataSendOrderBean"></param>
  693. /// <returns></returns>
  694. public static string checkErpTradeAlready(dataSendTradeBean dataSendOrderBean)
  695. {
  696. try
  697. {
  698. string post_url = pUrl + "openapi/v3/bo/list";
  699. string param = JsonConvert.SerializeObject(new
  700. {
  701. schemaCode = "zhudingdan_01",
  702. userId = USER_ID,
  703. queryCondition = new
  704. {
  705. operatorType = 1,
  706. propertyCode = "ShortText1724739958776",
  707. propertyValue = dataSendOrderBean.ShortText1724739958776
  708. }
  709. });
  710. string data = httpContent(post_url, param);
  711. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  712. if ("0".Equals(dataResponseVos.errcode))
  713. {
  714. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  715. {
  716. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  717. }
  718. return "";
  719. }
  720. }
  721. catch (Exception ex)
  722. {
  723. }
  724. return "";
  725. }
  726. /// <summary>
  727. /// 拆订单数据
  728. /// </summary>
  729. /// <param name="bean"></param>
  730. /// <returns></returns>
  731. public static dataResponseVo sendErpTradeCellInfo(dataSendTradeCellBean bean)
  732. {
  733. string post_url = pUrl + "openapi/v3/bo/create";
  734. string bizObjectId = checkErpTradeCellAlready(bean);
  735. if (!string.IsNullOrEmpty(bizObjectId))
  736. {
  737. post_url = pUrl + "openapi/v3/bo/update";
  738. bean.id = bizObjectId;
  739. }
  740. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.tid));
  741. if (!string.IsNullOrEmpty(tid_id))
  742. {
  743. bean.RelevanceForm1724834153527 = tid_id;
  744. }
  745. shopInfo shop = getShopDataInfo(bean.shopId);
  746. if (shop != null)
  747. {
  748. bean.RelevanceForm1717742363336 = shop.id;
  749. }
  750. string param = JsonConvert.SerializeObject(new
  751. {
  752. schemaCode = "orders_01",
  753. userId = USER_ID,
  754. data = bean
  755. });
  756. dataResponseVo dataResponseVos = null;
  757. try
  758. {
  759. string data = httpContent(post_url, param);
  760. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  761. return dataResponseVos;
  762. }
  763. catch (Exception ex)
  764. {
  765. dataResponseVos = new dataResponseVo();
  766. dataResponseVos.errcode = "1";
  767. dataResponseVos.errmsg = ex.Message;
  768. }
  769. return dataResponseVos;
  770. }
  771. /// <summary>
  772. /// 校验拆订单是否存在
  773. /// </summary>
  774. /// <param name="dataSendOrderBean"></param>
  775. /// <returns></returns>
  776. public static string checkErpTradeCellAlready(dataSendTradeCellBean dataSendOrderBean)
  777. {
  778. try
  779. {
  780. string post_url = pUrl + "openapi/v3/bo/list";
  781. string param = JsonConvert.SerializeObject(new
  782. {
  783. schemaCode = "orders_01",
  784. userId = USER_ID,
  785. queryCondition = new
  786. {
  787. operatorType = 1,
  788. propertyCode = "ShortText1717720509648",
  789. propertyValue = dataSendOrderBean.ShortText1717720509648
  790. }
  791. });
  792. string data = httpContent(post_url, param);
  793. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  794. if ("0".Equals(dataResponseVos.errcode))
  795. {
  796. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  797. {
  798. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  799. }
  800. return "";
  801. }
  802. }
  803. catch (Exception ex)
  804. {
  805. }
  806. return "";
  807. }
  808. /// <summary>
  809. /// 更新数据
  810. /// </summary>
  811. /// <param name="map"></param>
  812. /// <param name="ctid"></param>
  813. /// <returns></returns>
  814. public static dataResponseVo updateErpTradeCell(Dictionary<string, string> map, string ctid)
  815. {
  816. return null;
  817. string post_url = pUrl + "openapi/v3/bo/update";
  818. dataResponseVo dataResponseVos = null;
  819. dataSendTradeCellBean bean = new dataSendTradeCellBean();
  820. if (string.IsNullOrEmpty(ctid))
  821. {
  822. dataResponseVos = new dataResponseVo();
  823. dataResponseVos.errcode = "1";
  824. dataResponseVos.errmsg = "未找到订单";
  825. return dataResponseVos;
  826. }
  827. bean.ShortText1717720509648 = ctid;
  828. string bizObjectId = checkErpTradeCellAlready(bean);
  829. if (string.IsNullOrEmpty(bizObjectId))
  830. {
  831. dataResponseVos = new dataResponseVo();
  832. dataResponseVos.errcode = "1";
  833. dataResponseVos.errmsg = "未找到订单";
  834. return dataResponseVos;
  835. }
  836. map.Add("id", bizObjectId);
  837. string param = JsonConvert.SerializeObject(new
  838. {
  839. schemaCode = "orders_01",
  840. userId = USER_ID,
  841. data = map
  842. });
  843. try
  844. {
  845. string data = httpContent(post_url, param);
  846. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  847. return dataResponseVos;
  848. }
  849. catch (Exception ex)
  850. {
  851. dataResponseVos = new dataResponseVo();
  852. dataResponseVos.errcode = "1";
  853. dataResponseVos.errmsg = ex.Message;
  854. }
  855. return dataResponseVos;
  856. }
  857. /// <summary>
  858. /// 子订单数据
  859. /// </summary>
  860. /// <param name="bean"></param>
  861. /// <returns></returns>
  862. public static dataResponseVo sendErpTradeOrderInfo(dataSendTradeOrderBean bean)
  863. {
  864. string post_url = pUrl + "openapi/v3/bo/create";
  865. string bizObjectId = checkErpTradeOrderAlready(bean);
  866. if (!string.IsNullOrEmpty(bizObjectId))
  867. {
  868. post_url = pUrl + "openapi/v3/bo/update";
  869. bean.id = bizObjectId;
  870. }
  871. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.ShortText1724898549414));
  872. if (!string.IsNullOrEmpty(tid_id))
  873. {
  874. bean.RelevanceForm1724898561483 = tid_id;
  875. }
  876. string param = JsonConvert.SerializeObject(new
  877. {
  878. schemaCode = "zidingdan_01",
  879. userId = USER_ID,
  880. data = bean
  881. });
  882. dataResponseVo dataResponseVos = null;
  883. try
  884. {
  885. string data = httpContent(post_url, param);
  886. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  887. return dataResponseVos;
  888. }
  889. catch (Exception ex)
  890. {
  891. dataResponseVos = new dataResponseVo();
  892. dataResponseVos.errcode = "1";
  893. dataResponseVos.errmsg = ex.Message;
  894. }
  895. return dataResponseVos;
  896. }
  897. /// <summary>
  898. /// 校验子订单是否存在
  899. /// </summary>
  900. /// <param name="dataSendOrderBean"></param>
  901. /// <returns></returns>
  902. public static string checkErpTradeOrderAlready(dataSendTradeOrderBean dataSendOrderBean)
  903. {
  904. try
  905. {
  906. string post_url = pUrl + "openapi/v3/bo/list";
  907. string param = JsonConvert.SerializeObject(new
  908. {
  909. schemaCode = "zidingdan_01",
  910. userId = USER_ID,
  911. queryCondition = new
  912. {
  913. operatorType = 1,
  914. propertyCode = "ShortText1724898595268",
  915. propertyValue = dataSendOrderBean.ShortText1724898595268
  916. }
  917. });
  918. string data = httpContent(post_url, param);
  919. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  920. if ("0".Equals(dataResponseVos.errcode))
  921. {
  922. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  923. {
  924. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  925. }
  926. return "";
  927. }
  928. }
  929. catch (Exception ex)
  930. {
  931. }
  932. return "";
  933. }
  934. static HttpClient client = new HttpClient();
  935. private static string httpSaleContent(HttpMethod httpMethod, string post_url, Dictionary<string, string> map)
  936. {
  937. var request = new HttpRequestMessage
  938. {
  939. Method = httpMethod,
  940. RequestUri = new Uri(post_url),
  941. Headers =
  942. {
  943. { "token", "Zk2ncXqH8hFyA6Rj"},
  944. }
  945. };
  946. if (map.Keys.Count > 0)
  947. {
  948. request.Content = new FormUrlEncodedContent(map);
  949. }
  950. var task = Task.Run(() =>
  951. {
  952. var response = client.SendAsync(request).Result;
  953. response.EnsureSuccessStatusCode();
  954. return response.Content.ReadAsStringAsync().Result;
  955. });
  956. return task.Result;
  957. }
  958. private static string httpContent(string post_url, string content)
  959. {
  960. string token = getToken();
  961. var request = new HttpRequestMessage
  962. {
  963. Method = HttpMethod.Post,
  964. RequestUri = new Uri(post_url),
  965. Headers =
  966. {
  967. { "Authorization", "Bearer " + token },
  968. },
  969. Content = new StringContent(content)
  970. {
  971. Headers =
  972. {
  973. ContentType = new MediaTypeHeaderValue("application/json")
  974. }
  975. }
  976. };
  977. var task = Task.Run(() =>
  978. {
  979. var response = client.SendAsync(request).Result;
  980. response.EnsureSuccessStatusCode();
  981. return response.Content.ReadAsStringAsync().Result;
  982. });
  983. return task.Result;
  984. }
  985. }
  986. }