dataHelper.cs 39 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067
  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. XLog.SaveLog(0, "getSaleOrderSn:" + ex.Message);
  366. }
  367. return orderSn;
  368. }
  369. public static void api_orderBack(string orderNumber, string state, string content)
  370. {
  371. string post_url = "http://api.presales.lingtao8.com/open/order/orderProcessReturn";
  372. //string post_url = "http://admin.lingtao.zmht888.com/prod-api/open/order/orderProcessReturn";
  373. string remoteInfo = "";
  374. string param = JsonConvert.SerializeObject(new
  375. {
  376. orderSplitNo = orderNumber,
  377. errorStatus = state,
  378. reason = content
  379. });
  380. Dictionary<string, string> map = new Dictionary<string, string>();
  381. map.Add("orderSplitNo", orderNumber);
  382. map.Add("errorStatus", state);
  383. map.Add("reason", content);
  384. try
  385. {
  386. remoteInfo = httpSaleContent(HttpMethod.Post, post_url, map);
  387. }
  388. catch (Exception ex)
  389. {
  390. XLog.SaveLog(0, "api_orderBack:" + ex.Message);
  391. }
  392. }
  393. public static long GetTimeStamp()
  394. {
  395. return DateTimeOffset.Now.ToUnixTimeSeconds();
  396. }
  397. public static string getToken()
  398. {
  399. //return "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYXBpIl0sInNjb3BlIjpbInJlYWQiLCJ3cml0ZSJdLCJleHAiOjE3MzU5NjU0ODAsImF1dGhvcml0aWVzIjpbIm9wZW5hcGkiXSwianRpIjoiYjY4NTRhZjctZjNmMy00OTU0LTk4ZmUtZDRlZTE4ZDllNzQyIiwiY2xpZW50X2lkIjoieGNsaWVudCJ9.E6U0NVMZPcUypl4P7L5718J1X8UxSJg9R7vZX_oMkuEJ-yelNXuYwu7-eAi1JTgIJ0GuuviQu-KEAH-W7sHb7t-JJJc-wLPMsLKmpwQDG2EpiRK5hW5ZmyUgL8rPuTUawKVP5k8SGrN60sVyXA2zKm4ztEQ39EGudXnam1Lld2w";
  400. string token = "";
  401. if (RedisHelper.HasKey("xclient_token"))
  402. {
  403. token = RedisHelper.StringGet("xclient_token").ToString();
  404. if (RedisHelper.HasKey("token_end"))
  405. {
  406. string token_end = RedisHelper.StringGet("token_end").ToString();
  407. long token_endtime = Convert.ToInt64(token_end);
  408. long currentTime = GetTimeStamp();
  409. if (currentTime <= token_endtime)
  410. {
  411. return token;
  412. }
  413. }
  414. }
  415. string post_url = pUrl + "oauth/token";
  416. WebClient wc = new WebClient();
  417. wc.Encoding = Encoding.GetEncoding("utf-8");
  418. List<string> headers = new List<string>();
  419. headers.Add("grant_type=client_credentials");
  420. headers.Add("client_id=" + CLIENT_Id);
  421. headers.Add("client_secret=" + CLIENT_SECRET);
  422. post_url += "?" + string.Join("&", headers);
  423. NameValueCollection PostVars = new NameValueCollection();
  424. string remoteInfo = "";
  425. try
  426. {
  427. byte[] ret = wc.UploadValues(post_url, "POST", PostVars);
  428. remoteInfo = Encoding.GetEncoding("utf-8").GetString(ret);
  429. //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\"}";
  430. dataTokenBean dataTokenBean = JsonConvert.DeserializeObject<dataTokenBean>(remoteInfo);
  431. token = dataTokenBean.access_token;
  432. string timeEnd = dataTokenBean.exp;
  433. RedisHelper.StringSet("xclient_token", token);
  434. RedisHelper.StringSet("token_end", timeEnd);
  435. }
  436. catch (Exception ex)
  437. {
  438. }
  439. return token;
  440. }
  441. /// <summary>
  442. /// 获取店铺信息
  443. /// </summary>
  444. /// <param name="shopId"></param>
  445. /// <returns></returns>
  446. public static shopInfo getShopDataInfo(string shopId)
  447. {
  448. try
  449. {
  450. string post_url = pUrl + "openapi/v3/bo/list";
  451. string param = JsonConvert.SerializeObject(new
  452. {
  453. schemaCode = "Store_01",
  454. userId = USER_ID,
  455. queryCondition = new
  456. {
  457. operatorType = 1,
  458. propertyCode = "ErpshopId",
  459. propertyValue = shopId
  460. }
  461. });
  462. string data = httpContent(post_url, param);
  463. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  464. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  465. {
  466. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  467. {
  468. return dataResponseVos.data.bizObjectPage.content[0].data;
  469. }
  470. }
  471. }
  472. catch (Exception ex)
  473. {
  474. }
  475. return null;
  476. }
  477. /// <summary>
  478. /// 获取spu信息
  479. /// </summary>
  480. /// <param name="spuId"></param>
  481. /// <returns></returns>
  482. public static spuInfo getSpuInfo(string spuId)
  483. {
  484. try
  485. {
  486. string post_url = pUrl + "openapi/v3/bo/list";
  487. string param = JsonConvert.SerializeObject(new
  488. {
  489. schemaCode = "lianjieku_01_01",
  490. userId = USER_ID,
  491. queryCondition = new
  492. {
  493. operatorType = 1,
  494. propertyCode = "ShortText1728890649488",
  495. propertyValue = spuId
  496. }
  497. });
  498. string data = httpContent(post_url, param);
  499. dataSpuInfoResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataSpuInfoResponseVo>(data);
  500. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  501. {
  502. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  503. {
  504. return dataResponseVos.data.bizObjectPage.content[0].data;
  505. }
  506. }
  507. }
  508. catch (Exception ex)
  509. {
  510. }
  511. return null;
  512. }
  513. /// <summary>
  514. /// 订单发货是否存在
  515. /// </summary>
  516. /// <param name="dataSendOrderBean"></param>
  517. /// <returns></returns>
  518. public static string checkOrderAlready(dataSendOrderBean dataSendOrderBean)
  519. {
  520. try
  521. {
  522. string post_url = pUrl + "openapi/v3/bo/list";
  523. string param = JsonConvert.SerializeObject(new
  524. {
  525. schemaCode = "dingdanfahuo_01",
  526. userId = USER_ID,
  527. queryCondition = new
  528. {
  529. operatorType = 1,
  530. propertyCode = "ShortText1723707899761",
  531. propertyValue = dataSendOrderBean.ShortText1723707899761
  532. }
  533. });
  534. string data = httpContent(post_url, param);
  535. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  536. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  537. {
  538. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  539. {
  540. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  541. }
  542. return "";
  543. }
  544. }
  545. catch (Exception ex)
  546. {
  547. }
  548. return "";
  549. }
  550. /// <summary>
  551. /// 车间id获取信息
  552. /// </summary>
  553. /// <param name="supplerId"></param>
  554. /// <returns></returns>
  555. public static string getSupplerDataInfo(string supplerId)
  556. {
  557. try
  558. {
  559. string post_url = pUrl + "openapi/v3/bo/list";
  560. string param = JsonConvert.SerializeObject(new
  561. {
  562. schemaCode = "gongyingshang_01",
  563. userId = USER_ID,
  564. queryCondition = new
  565. {
  566. operatorType = 1,
  567. propertyCode = "ErpSupplierId",
  568. propertyValue = supplerId
  569. }
  570. });
  571. string data = httpContent(post_url, param);
  572. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  573. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  574. {
  575. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  576. {
  577. return dataResponseVos.data.bizObjectPage.content[0].data.id;
  578. }
  579. }
  580. }
  581. catch (Exception ex)
  582. {
  583. }
  584. return "";
  585. }
  586. /// <summary>
  587. /// 推送发货信息
  588. /// </summary>
  589. /// <param name="dataSendOrderBean"></param>
  590. /// <returns></returns>
  591. public static dataResponseVo CreateBoFahuo(dataSendOrderBean dataSendOrderBean)
  592. {
  593. string post_url = pUrl + "openapi/v3/bo/create";
  594. shopInfo shop = getShopDataInfo(dataSendOrderBean.RelevanceForm1723191239149);
  595. if (shop != null)
  596. {
  597. dataSendOrderBean.RelevanceForm1723191239149 = shop.id;
  598. }
  599. dataSendOrderBean.RelevanceForm1723191634028 = getSupplerDataInfo(dataSendOrderBean.RelevanceForm1723191634028);
  600. string bizObjectId = checkOrderAlready(dataSendOrderBean);
  601. if (!string.IsNullOrEmpty(bizObjectId))
  602. {
  603. post_url = pUrl + "openapi/v3/bo/update";
  604. dataSendOrderBean.id = bizObjectId;
  605. }
  606. string param = JsonConvert.SerializeObject(new
  607. {
  608. schemaCode = "dingdanfahuo_01",
  609. userId = USER_ID,
  610. data = dataSendOrderBean
  611. });
  612. dataResponseVo dataResponseVos = null;
  613. try
  614. {
  615. string data = httpContent(post_url, param);
  616. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  617. return dataResponseVos;
  618. }
  619. catch (Exception ex)
  620. {
  621. dataResponseVos = new dataResponseVo();
  622. dataResponseVos.errcode = "1";
  623. dataResponseVos.errmsg = ex.Message;
  624. }
  625. return dataResponseVos;
  626. }
  627. /// <summary>
  628. /// 推送spu信息
  629. /// </summary>
  630. /// <param name="bean"></param>
  631. /// <returns></returns>
  632. public static dataResponseVo sendSpuInfo(dataSendSpuBean bean)
  633. {
  634. string post_url = pUrl + "openapi/v3/bo/create";
  635. shopInfo shop = getShopDataInfo(bean.shopId);
  636. if (shop != null)
  637. {
  638. bean.RelevanceForm1728891053364 = shop.id;
  639. bean.operation = shop.operation;
  640. }
  641. spuInfo info = getSpuInfo(bean.ShortText1728890649488);
  642. if (info != null)
  643. {
  644. bean.StaffSingle1728891078584 = info.StaffSingle1728891078584;
  645. bean.Date1728891021647 = info.Date1728891021647;
  646. bean.ShortText1729677042659 = info.ShortText1729677067460;
  647. bean.ShortText1728891031267 = info.ShortText1728891031267;
  648. }
  649. string param = JsonConvert.SerializeObject(new
  650. {
  651. schemaCode = "lianjieku_01",
  652. userId = USER_ID,
  653. data = bean
  654. });
  655. dataResponseVo dataResponseVos = null;
  656. try
  657. {
  658. string data = httpContent(post_url, param);
  659. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  660. return dataResponseVos;
  661. }
  662. catch (Exception ex)
  663. {
  664. dataResponseVos = new dataResponseVo();
  665. dataResponseVos.errcode = "1";
  666. dataResponseVos.errmsg = ex.Message;
  667. }
  668. return dataResponseVos;
  669. }
  670. /// <summary>
  671. /// 主订单数据
  672. /// </summary>
  673. /// <param name="bean"></param>
  674. /// <returns></returns>
  675. public static dataResponseVo sendErpTradeInfo(dataSendTradeBean bean)
  676. {
  677. string post_url = pUrl + "openapi/v3/bo/create";
  678. string bizObjectId = checkErpTradeAlready(bean);
  679. if (!string.IsNullOrEmpty(bizObjectId))
  680. {
  681. post_url = pUrl + "openapi/v3/bo/update";
  682. bean.id = bizObjectId;
  683. }
  684. string param = JsonConvert.SerializeObject(new
  685. {
  686. schemaCode = "zhudingdan_01",
  687. userId = USER_ID,
  688. data = bean
  689. });
  690. dataResponseVo dataResponseVos = null;
  691. try
  692. {
  693. string data = httpContent(post_url, param);
  694. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  695. return dataResponseVos;
  696. }
  697. catch (Exception ex)
  698. {
  699. dataResponseVos = new dataResponseVo();
  700. dataResponseVos.errcode = "1";
  701. dataResponseVos.errmsg = ex.Message;
  702. }
  703. return dataResponseVos;
  704. }
  705. /// <summary>
  706. /// 校验主订单是否存在
  707. /// </summary>
  708. /// <param name="dataSendOrderBean"></param>
  709. /// <returns></returns>
  710. public static string checkErpTradeAlready(dataSendTradeBean dataSendOrderBean)
  711. {
  712. try
  713. {
  714. string post_url = pUrl + "openapi/v3/bo/list";
  715. string param = JsonConvert.SerializeObject(new
  716. {
  717. schemaCode = "zhudingdan_01",
  718. userId = USER_ID,
  719. queryCondition = new
  720. {
  721. operatorType = 1,
  722. propertyCode = "ShortText1724739958776",
  723. propertyValue = dataSendOrderBean.ShortText1724739958776
  724. }
  725. });
  726. string data = httpContent(post_url, param);
  727. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  728. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  729. {
  730. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  731. {
  732. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  733. }
  734. return "";
  735. }
  736. }
  737. catch (Exception ex)
  738. {
  739. }
  740. return "";
  741. }
  742. /// <summary>
  743. /// 拆订单数据
  744. /// </summary>
  745. /// <param name="bean"></param>
  746. /// <returns></returns>
  747. public static dataResponseVo sendErpTradeCellInfo(dataSendTradeCellBean bean)
  748. {
  749. string post_url = pUrl + "openapi/v3/bo/create";
  750. string bizObjectId = checkErpTradeCellAlready(bean);
  751. if (!string.IsNullOrEmpty(bizObjectId))
  752. {
  753. post_url = pUrl + "openapi/v3/bo/update";
  754. bean.id = bizObjectId;
  755. }
  756. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.tid));
  757. if (!string.IsNullOrEmpty(tid_id))
  758. {
  759. bean.RelevanceForm1724834153527 = tid_id;
  760. }
  761. shopInfo shop = getShopDataInfo(bean.shopId);
  762. if (shop != null)
  763. {
  764. bean.RelevanceForm1717742363336 = shop.id;
  765. }
  766. string param = JsonConvert.SerializeObject(new
  767. {
  768. schemaCode = "orders_01",
  769. userId = USER_ID,
  770. data = bean
  771. });
  772. dataResponseVo dataResponseVos = null;
  773. try
  774. {
  775. string data = httpContent(post_url, param);
  776. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  777. return dataResponseVos;
  778. }
  779. catch (Exception ex)
  780. {
  781. dataResponseVos = new dataResponseVo();
  782. dataResponseVos.errcode = "1";
  783. dataResponseVos.errmsg = ex.Message;
  784. }
  785. return dataResponseVos;
  786. }
  787. /// <summary>
  788. /// 校验拆订单是否存在
  789. /// </summary>
  790. /// <param name="dataSendOrderBean"></param>
  791. /// <returns></returns>
  792. public static string checkErpTradeCellAlready(dataSendTradeCellBean dataSendOrderBean)
  793. {
  794. try
  795. {
  796. string post_url = pUrl + "openapi/v3/bo/list";
  797. string param = JsonConvert.SerializeObject(new
  798. {
  799. schemaCode = "orders_01",
  800. userId = USER_ID,
  801. queryCondition = new
  802. {
  803. operatorType = 1,
  804. propertyCode = "ShortText1717720509648",
  805. propertyValue = dataSendOrderBean.ShortText1717720509648
  806. }
  807. });
  808. string data = httpContent(post_url, param);
  809. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  810. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  811. {
  812. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  813. {
  814. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  815. }
  816. return "";
  817. }
  818. }
  819. catch (Exception ex)
  820. {
  821. }
  822. return "";
  823. }
  824. /// <summary>
  825. /// 更新数据
  826. /// </summary>
  827. /// <param name="map"></param>
  828. /// <param name="ctid"></param>
  829. /// <returns></returns>
  830. public static dataResponseVo updateErpTradeCell(Dictionary<string, string> map, string ctid)
  831. {
  832. return null;
  833. string post_url = pUrl + "openapi/v3/bo/update";
  834. dataResponseVo dataResponseVos = null;
  835. dataSendTradeCellBean bean = new dataSendTradeCellBean();
  836. if (string.IsNullOrEmpty(ctid))
  837. {
  838. dataResponseVos = new dataResponseVo();
  839. dataResponseVos.errcode = "1";
  840. dataResponseVos.errmsg = "未找到订单";
  841. return dataResponseVos;
  842. }
  843. bean.ShortText1717720509648 = ctid;
  844. string bizObjectId = checkErpTradeCellAlready(bean);
  845. if (string.IsNullOrEmpty(bizObjectId))
  846. {
  847. dataResponseVos = new dataResponseVo();
  848. dataResponseVos.errcode = "1";
  849. dataResponseVos.errmsg = "未找到订单";
  850. return dataResponseVos;
  851. }
  852. map.Add("id", bizObjectId);
  853. string param = JsonConvert.SerializeObject(new
  854. {
  855. schemaCode = "orders_01",
  856. userId = USER_ID,
  857. data = map
  858. });
  859. try
  860. {
  861. string data = httpContent(post_url, param);
  862. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  863. return dataResponseVos;
  864. }
  865. catch (Exception ex)
  866. {
  867. dataResponseVos = new dataResponseVo();
  868. dataResponseVos.errcode = "1";
  869. dataResponseVos.errmsg = ex.Message;
  870. }
  871. return dataResponseVos;
  872. }
  873. /// <summary>
  874. /// 子订单数据
  875. /// </summary>
  876. /// <param name="bean"></param>
  877. /// <returns></returns>
  878. public static dataResponseVo sendErpTradeOrderInfo(dataSendTradeOrderBean bean)
  879. {
  880. string post_url = pUrl + "openapi/v3/bo/create";
  881. string bizObjectId = checkErpTradeOrderAlready(bean);
  882. if (!string.IsNullOrEmpty(bizObjectId))
  883. {
  884. post_url = pUrl + "openapi/v3/bo/update";
  885. bean.id = bizObjectId;
  886. }
  887. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.ShortText1724898549414));
  888. if (!string.IsNullOrEmpty(tid_id))
  889. {
  890. bean.RelevanceForm1724898561483 = tid_id;
  891. }
  892. string param = JsonConvert.SerializeObject(new
  893. {
  894. schemaCode = "zidingdan_01",
  895. userId = USER_ID,
  896. data = bean
  897. });
  898. dataResponseVo dataResponseVos = null;
  899. try
  900. {
  901. string data = httpContent(post_url, param);
  902. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  903. return dataResponseVos;
  904. }
  905. catch (Exception ex)
  906. {
  907. dataResponseVos = new dataResponseVo();
  908. dataResponseVos.errcode = "1";
  909. dataResponseVos.errmsg = ex.Message;
  910. }
  911. return dataResponseVos;
  912. }
  913. /// <summary>
  914. /// 校验子订单是否存在
  915. /// </summary>
  916. /// <param name="dataSendOrderBean"></param>
  917. /// <returns></returns>
  918. public static string checkErpTradeOrderAlready(dataSendTradeOrderBean dataSendOrderBean)
  919. {
  920. try
  921. {
  922. string post_url = pUrl + "openapi/v3/bo/list";
  923. string param = JsonConvert.SerializeObject(new
  924. {
  925. schemaCode = "zidingdan_01",
  926. userId = USER_ID,
  927. queryCondition = new
  928. {
  929. operatorType = 1,
  930. propertyCode = "ShortText1724898595268",
  931. propertyValue = dataSendOrderBean.ShortText1724898595268
  932. }
  933. });
  934. string data = httpContent(post_url, param);
  935. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  936. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  937. {
  938. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  939. {
  940. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  941. }
  942. return "";
  943. }
  944. }
  945. catch (Exception ex)
  946. {
  947. }
  948. return "";
  949. }
  950. static HttpClient client = new HttpClient();
  951. private static string httpSaleContent(HttpMethod httpMethod, string post_url, Dictionary<string, string> map)
  952. {
  953. var request = new HttpRequestMessage
  954. {
  955. Method = httpMethod,
  956. RequestUri = new Uri(post_url),
  957. Headers =
  958. {
  959. { "token", "Zk2ncXqH8hFyA6Rj"},
  960. }
  961. };
  962. if (map.Keys.Count > 0)
  963. {
  964. request.Content = new FormUrlEncodedContent(map);
  965. }
  966. var task = Task.Run(() =>
  967. {
  968. try
  969. {
  970. var response = client.SendAsync(request).Result;
  971. response.EnsureSuccessStatusCode();
  972. return response.Content.ReadAsStringAsync().Result;
  973. }
  974. catch (Exception ex)
  975. {
  976. return "";
  977. }
  978. });
  979. return task.Result;
  980. }
  981. private static string httpContent(string post_url, string content)
  982. {
  983. string token = getToken();
  984. var request = new HttpRequestMessage
  985. {
  986. Method = HttpMethod.Post,
  987. RequestUri = new Uri(post_url),
  988. Headers =
  989. {
  990. { "Authorization", "Bearer " + token },
  991. },
  992. Content = new StringContent(content)
  993. {
  994. Headers =
  995. {
  996. ContentType = new MediaTypeHeaderValue("application/json")
  997. }
  998. }
  999. };
  1000. var task = Task.Run(() =>
  1001. {
  1002. try
  1003. {
  1004. var response = client.SendAsync(request).Result;
  1005. response.EnsureSuccessStatusCode();
  1006. return response.Content.ReadAsStringAsync().Result;
  1007. }
  1008. catch (Exception e)
  1009. {
  1010. return "";
  1011. }
  1012. });
  1013. return task.Result;
  1014. }
  1015. }
  1016. }