dataHelper.cs 39 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078
  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. data.Add("isSF", ceErpTradeCell.IsSF);
  203. if (ceErpTrade != null)
  204. {
  205. data.Add("province", ceErpTrade.receiver_state);
  206. }
  207. ReturnSuccess(JsonConvert.SerializeObject(data));
  208. return;
  209. }
  210. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=get_cell_info post请求参数(参数放body中):string tid(淘宝订单号)
  211. public void get_shop_code()
  212. {
  213. bool result = checkParams();
  214. if (!result)
  215. {
  216. return;
  217. }
  218. string name = GetPostString("name");
  219. if (string.IsNullOrEmpty(name))
  220. {
  221. returnErrorMsg("参数错误");
  222. return;
  223. }
  224. string code = "";
  225. string key = "shopName_code_" + name;
  226. if (RedisHelper.HasKey(key))
  227. {
  228. code = RedisHelper.StringGet(key).ToString();
  229. }
  230. if (code == "")
  231. {
  232. CeErpShop shop = CeErpShop.GetShopIdByName(name);
  233. if (shop == null)
  234. {
  235. returnErrorMsg("无店铺");
  236. return;
  237. }
  238. code = shop.SName;
  239. RedisHelper.StringSet(key, code);
  240. }
  241. Dictionary<string, object> data = new Dictionary<string, object>();
  242. data.Add("code", code);
  243. ReturnSuccess(JsonConvert.SerializeObject(data));
  244. return;
  245. }
  246. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=get_cell_info post请求参数(参数放body中):string tid(淘宝订单号)
  247. public void get_cell_info()
  248. {
  249. string tid = GetPostString("tid");
  250. string name = GetPostString("nickName");
  251. string where = "";
  252. List<string> rows = new List<string>();
  253. if (!string.IsNullOrEmpty(tid))
  254. {
  255. rows.Add(string.Format(" tid = '{0}' ", tid));
  256. }
  257. if (!string.IsNullOrEmpty(name))
  258. {
  259. rows.Add(string.Format(" buyer_nick = '{0}' ", name));
  260. }
  261. where = string.Join("and", rows);
  262. if (where == "")
  263. {
  264. returnErrorMsg("缺少必要参数");
  265. return;
  266. }
  267. 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);
  268. DataTable dataTable = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
  269. List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
  270. if (dataTable != null && dataTable.Rows.Count > 0)
  271. {
  272. Dictionary<string, object> data = new Dictionary<string, object>();
  273. foreach (DataRow row in dataTable.Rows)
  274. {
  275. int OrderState = Convert.ToInt32(row["OrderState"]);
  276. string state = "";
  277. if (OrderState < 7)
  278. {
  279. state = "待发货";
  280. }
  281. else if (OrderState == 7)
  282. {
  283. state = "已发货";
  284. }
  285. else if (OrderState == 8)
  286. {
  287. state = "交易完成";
  288. }
  289. else if (OrderState == 9)
  290. {
  291. state = "交易关闭";
  292. }
  293. data = new Dictionary<string, object>();
  294. data.Add("tid", row["tid"]);
  295. data.Add("OrderState", state);
  296. data.Add("state", OrderState);
  297. data.Add("shopCode", row["posCode"]);
  298. data.Add("buyerNick", row["buyer_nick"]);
  299. data.Add("buyerId", row["buyer_id"]);
  300. data.Add("shopName", row["seller_nick"]);
  301. data.Add("ctid", row["ctid"]);
  302. data.Add("payment", row["payment"]);
  303. data.Add("Material", row["Material"]);
  304. data.Add("Craft", row["Craft"]);
  305. data.Add("ProductSize", row["ProductSize"]);
  306. data.Add("ProductCount", row["ProductCount"]);
  307. data.Add("ProductName", row["ProductName"]);
  308. data.Add("FinishDesignTime", row["FinishDesignTime"]);
  309. list.Add(data);
  310. }
  311. }
  312. ReturnSuccess(JsonConvert.SerializeObject(list));
  313. return;
  314. }
  315. public void getOrderInvoiceInfo()
  316. {
  317. string tids = GetPostString("tids");
  318. List<string> list = tids.Split(',').ToList();
  319. return;
  320. }
  321. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=update_spu_info post请求参数(参数放body中):string spuId(淘宝订单号)
  322. public void update_spu_info()
  323. {
  324. string spuId = GetPostString("spuId");
  325. string category = GetPostString("category");
  326. string serialNumber = GetPostString("serialNumber");
  327. string operate = GetPostString("operate");
  328. string designer = GetPostString("designer");
  329. string atta = GetPostString("atta");
  330. string upTime = GetPostString("upTime");
  331. int shopId = GetPostInt("shopId");
  332. if (!string.IsNullOrEmpty(spuId))
  333. {
  334. CeErpTradeSpu spu = CeErpTradeSpu.GetBySpuId(spuId);
  335. if (spu == null)
  336. {
  337. returnErrorMsg("找不到对应id");
  338. return;
  339. }
  340. spu.category = category;
  341. spu.serialNumber = serialNumber;
  342. spu.operate = operate;
  343. spu.designer = designer;
  344. spu.atta = atta;
  345. spu.shopId = shopId;
  346. spu.upTime = DateTime.Parse(upTime);
  347. spu.Update();
  348. returnSuccess("修改成功!");
  349. return;
  350. }
  351. returnErrorMsg("缺少必要参数");
  352. }
  353. static string pUrl = "http://36.140.138.139:688/api/";
  354. static string CLIENT_Id = "xclient";
  355. static string CLIENT_SECRET = "0a417ecce58c31b32364ce19ca8fcd15";
  356. static string USER_ID = "ca2d316357fa4e09b9c2aa9f7b2ca3d9";
  357. public static string getSaleOrderSn()
  358. {
  359. string orderSn = "";
  360. string post_url = "http://api.presales.lingtao8.com/open/order/generateSplitOrderUniqueNos/1";
  361. try
  362. {
  363. string remoteInfo = httpSaleContent(HttpMethod.Get, post_url, new Dictionary<string, string>());
  364. saleOrderResponse dataTokenBean = JsonConvert.DeserializeObject<saleOrderResponse>(remoteInfo);
  365. if ("200".Equals(dataTokenBean.code))
  366. {
  367. orderSn = dataTokenBean.data[0];
  368. }
  369. }
  370. catch (Exception ex)
  371. {
  372. XLog.SaveLog(0, "getSaleOrderSn:" + ex.Message);
  373. }
  374. return orderSn;
  375. }
  376. public static void api_orderBack(string orderNumber, string state, string content)
  377. {
  378. string post_url = "http://api.presales.lingtao8.com/open/order/orderProcessReturn";
  379. //string post_url = "http://admin.lingtao.zmht888.com/prod-api/open/order/orderProcessReturn";
  380. string remoteInfo = "";
  381. string param = JsonConvert.SerializeObject(new
  382. {
  383. orderSplitNo = orderNumber,
  384. errorStatus = state,
  385. reason = content
  386. });
  387. Dictionary<string, string> map = new Dictionary<string, string>();
  388. map.Add("orderSplitNo", orderNumber);
  389. map.Add("errorStatus", state);
  390. map.Add("reason", content);
  391. try
  392. {
  393. remoteInfo = httpSaleContent(HttpMethod.Post, post_url, map);
  394. }
  395. catch (Exception ex)
  396. {
  397. XLog.SaveLog(0, "api_orderBack:" + ex.Message);
  398. }
  399. }
  400. public static long GetTimeStamp()
  401. {
  402. return DateTimeOffset.Now.ToUnixTimeSeconds();
  403. }
  404. public static string getToken()
  405. {
  406. //return "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYXBpIl0sInNjb3BlIjpbInJlYWQiLCJ3cml0ZSJdLCJleHAiOjE3MzU5NjU0ODAsImF1dGhvcml0aWVzIjpbIm9wZW5hcGkiXSwianRpIjoiYjY4NTRhZjctZjNmMy00OTU0LTk4ZmUtZDRlZTE4ZDllNzQyIiwiY2xpZW50X2lkIjoieGNsaWVudCJ9.E6U0NVMZPcUypl4P7L5718J1X8UxSJg9R7vZX_oMkuEJ-yelNXuYwu7-eAi1JTgIJ0GuuviQu-KEAH-W7sHb7t-JJJc-wLPMsLKmpwQDG2EpiRK5hW5ZmyUgL8rPuTUawKVP5k8SGrN60sVyXA2zKm4ztEQ39EGudXnam1Lld2w";
  407. string token = "";
  408. if (RedisHelper.HasKey("xclient_token"))
  409. {
  410. token = RedisHelper.StringGet("xclient_token").ToString();
  411. if (RedisHelper.HasKey("token_end"))
  412. {
  413. string token_end = RedisHelper.StringGet("token_end").ToString();
  414. long token_endtime = Convert.ToInt64(token_end);
  415. long currentTime = GetTimeStamp();
  416. if (currentTime <= token_endtime)
  417. {
  418. return token;
  419. }
  420. }
  421. }
  422. string post_url = pUrl + "oauth/token";
  423. WebClient wc = new WebClient();
  424. wc.Encoding = Encoding.GetEncoding("utf-8");
  425. List<string> headers = new List<string>();
  426. headers.Add("grant_type=client_credentials");
  427. headers.Add("client_id=" + CLIENT_Id);
  428. headers.Add("client_secret=" + CLIENT_SECRET);
  429. post_url += "?" + string.Join("&", headers);
  430. NameValueCollection PostVars = new NameValueCollection();
  431. string remoteInfo = "";
  432. try
  433. {
  434. byte[] ret = wc.UploadValues(post_url, "POST", PostVars);
  435. remoteInfo = Encoding.GetEncoding("utf-8").GetString(ret);
  436. //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\"}";
  437. dataTokenBean dataTokenBean = JsonConvert.DeserializeObject<dataTokenBean>(remoteInfo);
  438. token = dataTokenBean.access_token;
  439. string timeEnd = dataTokenBean.exp;
  440. RedisHelper.StringSet("xclient_token", token);
  441. RedisHelper.StringSet("token_end", timeEnd);
  442. }
  443. catch (Exception ex)
  444. {
  445. }
  446. return token;
  447. }
  448. /// <summary>
  449. /// 获取店铺信息
  450. /// </summary>
  451. /// <param name="shopId"></param>
  452. /// <returns></returns>
  453. public static shopInfo getShopDataInfo(string shopId)
  454. {
  455. try
  456. {
  457. string post_url = pUrl + "openapi/v3/bo/list";
  458. string param = JsonConvert.SerializeObject(new
  459. {
  460. schemaCode = "Store_01",
  461. userId = USER_ID,
  462. queryCondition = new
  463. {
  464. operatorType = 1,
  465. propertyCode = "ErpshopId",
  466. propertyValue = shopId
  467. }
  468. });
  469. string data = httpContent(post_url, param);
  470. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  471. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  472. {
  473. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  474. {
  475. return dataResponseVos.data.bizObjectPage.content[0].data;
  476. }
  477. }
  478. }
  479. catch (Exception ex)
  480. {
  481. }
  482. return null;
  483. }
  484. /// <summary>
  485. /// 获取spu信息
  486. /// </summary>
  487. /// <param name="spuId"></param>
  488. /// <returns></returns>
  489. public static spuInfo getSpuInfo(string spuId)
  490. {
  491. try
  492. {
  493. string post_url = pUrl + "openapi/v3/bo/list";
  494. string param = JsonConvert.SerializeObject(new
  495. {
  496. schemaCode = "lianjieku_01_01",
  497. userId = USER_ID,
  498. queryCondition = new
  499. {
  500. operatorType = 1,
  501. propertyCode = "ShortText1728890649488",
  502. propertyValue = spuId
  503. }
  504. });
  505. string data = httpContent(post_url, param);
  506. dataSpuInfoResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataSpuInfoResponseVo>(data);
  507. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  508. {
  509. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  510. {
  511. return dataResponseVos.data.bizObjectPage.content[0].data;
  512. }
  513. }
  514. }
  515. catch (Exception ex)
  516. {
  517. }
  518. return null;
  519. }
  520. /// <summary>
  521. /// 订单发货是否存在
  522. /// </summary>
  523. /// <param name="dataSendOrderBean"></param>
  524. /// <returns></returns>
  525. public static string checkOrderAlready(dataSendOrderBean dataSendOrderBean)
  526. {
  527. try
  528. {
  529. string post_url = pUrl + "openapi/v3/bo/list";
  530. string param = JsonConvert.SerializeObject(new
  531. {
  532. schemaCode = "dingdanfahuo_01",
  533. userId = USER_ID,
  534. queryCondition = new
  535. {
  536. operatorType = 1,
  537. propertyCode = "ShortText1723707899761",
  538. propertyValue = dataSendOrderBean.ShortText1723707899761
  539. }
  540. });
  541. string data = httpContent(post_url, param);
  542. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  543. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  544. {
  545. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  546. {
  547. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  548. }
  549. return "";
  550. }
  551. }
  552. catch (Exception ex)
  553. {
  554. }
  555. return "";
  556. }
  557. /// <summary>
  558. /// 车间id获取信息
  559. /// </summary>
  560. /// <param name="supplerId"></param>
  561. /// <returns></returns>
  562. public static string getSupplerDataInfo(string supplerId)
  563. {
  564. try
  565. {
  566. string post_url = pUrl + "openapi/v3/bo/list";
  567. string param = JsonConvert.SerializeObject(new
  568. {
  569. schemaCode = "gongyingshang_01",
  570. userId = USER_ID,
  571. queryCondition = new
  572. {
  573. operatorType = 1,
  574. propertyCode = "ErpSupplierId",
  575. propertyValue = supplerId
  576. }
  577. });
  578. string data = httpContent(post_url, param);
  579. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  580. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  581. {
  582. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  583. {
  584. return dataResponseVos.data.bizObjectPage.content[0].data.id;
  585. }
  586. }
  587. }
  588. catch (Exception ex)
  589. {
  590. }
  591. return "";
  592. }
  593. /// <summary>
  594. /// 推送发货信息
  595. /// </summary>
  596. /// <param name="dataSendOrderBean"></param>
  597. /// <returns></returns>
  598. public static dataResponseVo CreateBoFahuo(dataSendOrderBean dataSendOrderBean)
  599. {
  600. string post_url = pUrl + "openapi/v3/bo/create";
  601. shopInfo shop = getShopDataInfo(dataSendOrderBean.RelevanceForm1723191239149);
  602. if (shop != null)
  603. {
  604. dataSendOrderBean.RelevanceForm1723191239149 = shop.id;
  605. }
  606. dataSendOrderBean.RelevanceForm1723191634028 = getSupplerDataInfo(dataSendOrderBean.RelevanceForm1723191634028);
  607. string bizObjectId = checkOrderAlready(dataSendOrderBean);
  608. if (!string.IsNullOrEmpty(bizObjectId))
  609. {
  610. post_url = pUrl + "openapi/v3/bo/update";
  611. dataSendOrderBean.id = bizObjectId;
  612. }
  613. string param = JsonConvert.SerializeObject(new
  614. {
  615. schemaCode = "dingdanfahuo_01",
  616. userId = USER_ID,
  617. data = dataSendOrderBean
  618. });
  619. dataResponseVo dataResponseVos = null;
  620. try
  621. {
  622. string data = httpContent(post_url, param);
  623. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  624. return dataResponseVos;
  625. }
  626. catch (Exception ex)
  627. {
  628. dataResponseVos = new dataResponseVo();
  629. dataResponseVos.errcode = "1";
  630. dataResponseVos.errmsg = ex.Message;
  631. }
  632. return dataResponseVos;
  633. }
  634. /// <summary>
  635. /// 推送spu信息
  636. /// </summary>
  637. /// <param name="bean"></param>
  638. /// <returns></returns>
  639. public static dataResponseVo sendSpuInfo(dataSendSpuBean bean)
  640. {
  641. string post_url = pUrl + "openapi/v3/bo/create";
  642. shopInfo shop = getShopDataInfo(bean.shopId);
  643. if (shop != null)
  644. {
  645. bean.RelevanceForm1728891053364 = shop.id;
  646. bean.operation = shop.operation;
  647. }
  648. spuInfo info = getSpuInfo(bean.ShortText1728890649488);
  649. if (info != null)
  650. {
  651. return null;
  652. bean.StaffSingle1728891078584 = info.StaffSingle1728891078584;
  653. bean.Date1728891021647 = info.Date1728891021647;
  654. bean.ShortText1729677042659 = info.ShortText1729677067460;
  655. bean.ShortText1728891031267 = info.ShortText1728891031267;
  656. }
  657. string param = JsonConvert.SerializeObject(new
  658. {
  659. schemaCode = "lianjieku_01",
  660. userId = USER_ID,
  661. data = bean
  662. });
  663. dataResponseVo dataResponseVos = null;
  664. try
  665. {
  666. string data = httpContent(post_url, param);
  667. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  668. return dataResponseVos;
  669. }
  670. catch (Exception ex)
  671. {
  672. dataResponseVos = new dataResponseVo();
  673. dataResponseVos.errcode = "1";
  674. dataResponseVos.errmsg = ex.Message;
  675. }
  676. return dataResponseVos;
  677. }
  678. /// <summary>
  679. /// 主订单数据
  680. /// </summary>
  681. /// <param name="bean"></param>
  682. /// <returns></returns>
  683. public static dataResponseVo sendErpTradeInfo(dataSendTradeBean bean)
  684. {
  685. string post_url = pUrl + "openapi/v3/bo/create";
  686. string bizObjectId = checkErpTradeAlready(bean);
  687. if (!string.IsNullOrEmpty(bizObjectId))
  688. {
  689. post_url = pUrl + "openapi/v3/bo/update";
  690. bean.id = bizObjectId;
  691. }
  692. string param = JsonConvert.SerializeObject(new
  693. {
  694. schemaCode = "zhudingdan_01",
  695. userId = USER_ID,
  696. data = bean
  697. });
  698. dataResponseVo dataResponseVos = null;
  699. try
  700. {
  701. string data = httpContent(post_url, param);
  702. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  703. return dataResponseVos;
  704. }
  705. catch (Exception ex)
  706. {
  707. dataResponseVos = new dataResponseVo();
  708. dataResponseVos.errcode = "1";
  709. dataResponseVos.errmsg = ex.Message;
  710. }
  711. return dataResponseVos;
  712. }
  713. /// <summary>
  714. /// 校验主订单是否存在
  715. /// </summary>
  716. /// <param name="dataSendOrderBean"></param>
  717. /// <returns></returns>
  718. public static string checkErpTradeAlready(dataSendTradeBean dataSendOrderBean)
  719. {
  720. try
  721. {
  722. string post_url = pUrl + "openapi/v3/bo/list";
  723. string param = JsonConvert.SerializeObject(new
  724. {
  725. schemaCode = "zhudingdan_01",
  726. userId = USER_ID,
  727. queryCondition = new
  728. {
  729. operatorType = 1,
  730. propertyCode = "ShortText1724739958776",
  731. propertyValue = dataSendOrderBean.ShortText1724739958776
  732. }
  733. });
  734. string data = httpContent(post_url, param);
  735. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  736. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  737. {
  738. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  739. {
  740. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  741. }
  742. return "";
  743. }
  744. }
  745. catch (Exception ex)
  746. {
  747. }
  748. return "";
  749. }
  750. /// <summary>
  751. /// 拆订单数据
  752. /// </summary>
  753. /// <param name="bean"></param>
  754. /// <returns></returns>
  755. public static dataResponseVo sendErpTradeCellInfo(dataSendTradeCellBean bean)
  756. {
  757. string post_url = pUrl + "openapi/v3/bo/create";
  758. string bizObjectId = checkErpTradeCellAlready(bean);
  759. if (!string.IsNullOrEmpty(bizObjectId))
  760. {
  761. post_url = pUrl + "openapi/v3/bo/update";
  762. bean.id = bizObjectId;
  763. }
  764. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.tid));
  765. if (!string.IsNullOrEmpty(tid_id))
  766. {
  767. bean.RelevanceForm1724834153527 = tid_id;
  768. }
  769. shopInfo shop = getShopDataInfo(bean.shopId);
  770. if (shop != null)
  771. {
  772. bean.RelevanceForm1717742363336 = shop.id;
  773. }
  774. string param = JsonConvert.SerializeObject(new
  775. {
  776. schemaCode = "orders_01",
  777. userId = USER_ID,
  778. data = bean
  779. });
  780. dataResponseVo dataResponseVos = null;
  781. try
  782. {
  783. string data = httpContent(post_url, param);
  784. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  785. return dataResponseVos;
  786. }
  787. catch (Exception ex)
  788. {
  789. dataResponseVos = new dataResponseVo();
  790. dataResponseVos.errcode = "1";
  791. dataResponseVos.errmsg = ex.Message;
  792. }
  793. return dataResponseVos;
  794. }
  795. /// <summary>
  796. /// 校验拆订单是否存在
  797. /// </summary>
  798. /// <param name="dataSendOrderBean"></param>
  799. /// <returns></returns>
  800. public static string checkErpTradeCellAlready(dataSendTradeCellBean dataSendOrderBean)
  801. {
  802. try
  803. {
  804. string post_url = pUrl + "openapi/v3/bo/list";
  805. string param = JsonConvert.SerializeObject(new
  806. {
  807. schemaCode = "orders_01",
  808. userId = USER_ID,
  809. queryCondition = new
  810. {
  811. operatorType = 1,
  812. propertyCode = "ShortText1717720509648",
  813. propertyValue = dataSendOrderBean.ShortText1717720509648
  814. }
  815. });
  816. string data = httpContent(post_url, param);
  817. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  818. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  819. {
  820. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  821. {
  822. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  823. }
  824. return "";
  825. }
  826. }
  827. catch (Exception ex)
  828. {
  829. }
  830. return "";
  831. }
  832. /// <summary>
  833. /// 更新数据
  834. /// </summary>
  835. /// <param name="map"></param>
  836. /// <param name="ctid"></param>
  837. /// <returns></returns>
  838. public static dataResponseVo updateErpTradeCell(Dictionary<string, string> map, string ctid)
  839. {
  840. return null;
  841. string post_url = pUrl + "openapi/v3/bo/update";
  842. dataResponseVo dataResponseVos = null;
  843. dataSendTradeCellBean bean = new dataSendTradeCellBean();
  844. if (string.IsNullOrEmpty(ctid))
  845. {
  846. dataResponseVos = new dataResponseVo();
  847. dataResponseVos.errcode = "1";
  848. dataResponseVos.errmsg = "未找到订单";
  849. return dataResponseVos;
  850. }
  851. bean.ShortText1717720509648 = ctid;
  852. string bizObjectId = checkErpTradeCellAlready(bean);
  853. if (string.IsNullOrEmpty(bizObjectId))
  854. {
  855. dataResponseVos = new dataResponseVo();
  856. dataResponseVos.errcode = "1";
  857. dataResponseVos.errmsg = "未找到订单";
  858. return dataResponseVos;
  859. }
  860. map.Add("id", bizObjectId);
  861. string param = JsonConvert.SerializeObject(new
  862. {
  863. schemaCode = "orders_01",
  864. userId = USER_ID,
  865. data = map
  866. });
  867. try
  868. {
  869. string data = httpContent(post_url, param);
  870. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  871. return dataResponseVos;
  872. }
  873. catch (Exception ex)
  874. {
  875. dataResponseVos = new dataResponseVo();
  876. dataResponseVos.errcode = "1";
  877. dataResponseVos.errmsg = ex.Message;
  878. }
  879. return dataResponseVos;
  880. }
  881. /// <summary>
  882. /// 子订单数据
  883. /// </summary>
  884. /// <param name="bean"></param>
  885. /// <returns></returns>
  886. public static dataResponseVo sendErpTradeOrderInfo(dataSendTradeOrderBean bean)
  887. {
  888. string post_url = pUrl + "openapi/v3/bo/create";
  889. string bizObjectId = checkErpTradeOrderAlready(bean);
  890. if (!string.IsNullOrEmpty(bizObjectId))
  891. {
  892. post_url = pUrl + "openapi/v3/bo/update";
  893. bean.id = bizObjectId;
  894. }
  895. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.ShortText1724898549414));
  896. if (!string.IsNullOrEmpty(tid_id))
  897. {
  898. bean.RelevanceForm1724898561483 = tid_id;
  899. }
  900. string param = JsonConvert.SerializeObject(new
  901. {
  902. schemaCode = "zidingdan_01",
  903. userId = USER_ID,
  904. data = bean
  905. });
  906. dataResponseVo dataResponseVos = null;
  907. try
  908. {
  909. string data = httpContent(post_url, param);
  910. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  911. return dataResponseVos;
  912. }
  913. catch (Exception ex)
  914. {
  915. dataResponseVos = new dataResponseVo();
  916. dataResponseVos.errcode = "1";
  917. dataResponseVos.errmsg = ex.Message;
  918. }
  919. return dataResponseVos;
  920. }
  921. /// <summary>
  922. /// 校验子订单是否存在
  923. /// </summary>
  924. /// <param name="dataSendOrderBean"></param>
  925. /// <returns></returns>
  926. public static string checkErpTradeOrderAlready(dataSendTradeOrderBean dataSendOrderBean)
  927. {
  928. try
  929. {
  930. string post_url = pUrl + "openapi/v3/bo/list";
  931. string param = JsonConvert.SerializeObject(new
  932. {
  933. schemaCode = "zidingdan_01",
  934. userId = USER_ID,
  935. queryCondition = new
  936. {
  937. operatorType = 1,
  938. propertyCode = "ShortText1724898595268",
  939. propertyValue = dataSendOrderBean.ShortText1724898595268
  940. }
  941. });
  942. string data = httpContent(post_url, param);
  943. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  944. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  945. {
  946. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  947. {
  948. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  949. }
  950. return "";
  951. }
  952. }
  953. catch (Exception ex)
  954. {
  955. }
  956. return "";
  957. }
  958. static HttpClient client = new HttpClient();
  959. private static string httpSaleContent(HttpMethod httpMethod, string post_url, Dictionary<string, string> map)
  960. {
  961. var request = new HttpRequestMessage
  962. {
  963. Method = httpMethod,
  964. RequestUri = new Uri(post_url),
  965. Headers =
  966. {
  967. { "token", "Zk2ncXqH8hFyA6Rj"},
  968. }
  969. };
  970. if (map.Keys.Count > 0)
  971. {
  972. request.Content = new FormUrlEncodedContent(map);
  973. }
  974. var task = Task.Run(() =>
  975. {
  976. try
  977. {
  978. var response = client.SendAsync(request).Result;
  979. response.EnsureSuccessStatusCode();
  980. return response.Content.ReadAsStringAsync().Result;
  981. }
  982. catch (Exception ex)
  983. {
  984. return "";
  985. }
  986. });
  987. return task.Result;
  988. }
  989. private static string httpContent(string post_url, string content)
  990. {
  991. string token = getToken();
  992. var request = new HttpRequestMessage
  993. {
  994. Method = HttpMethod.Post,
  995. RequestUri = new Uri(post_url),
  996. Headers =
  997. {
  998. { "Authorization", "Bearer " + token },
  999. },
  1000. Content = new StringContent(content)
  1001. {
  1002. Headers =
  1003. {
  1004. ContentType = new MediaTypeHeaderValue("application/json")
  1005. }
  1006. }
  1007. };
  1008. var task = Task.Run(() =>
  1009. {
  1010. try
  1011. {
  1012. var response = client.SendAsync(request).Result;
  1013. response.EnsureSuccessStatusCode();
  1014. return response.Content.ReadAsStringAsync().Result;
  1015. }
  1016. catch (Exception e)
  1017. {
  1018. return "";
  1019. }
  1020. });
  1021. return task.Result;
  1022. }
  1023. }
  1024. }