dataHelper.cs 42 KB

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