dataHelper.cs 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236
  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 top 1 tid FROM [dbo].[CE_ErpTradeCell] WHERE ShopId = {0} AND OrderState = 8 and IsOffLineOrder =0", row["ShopId"]);
  352. DataTable shopData = DbHelper.DbConn.ExecuteDataset(shopsql).Tables[0];
  353. if (shopData != null && shopData.Rows.Count > 0)
  354. {
  355. CeErpTrade ceErpTrade = CeErpTrade.Get(shopData.Rows[0]["tid"].ToString());
  356. if (ceErpTrade != null)
  357. {
  358. data["shopCode"] = ceErpTrade.posCode;
  359. }
  360. }
  361. }
  362. shopCode = data["shopCode"].ToString();
  363. list.Add(data);
  364. }
  365. }
  366. ReturnSuccess(JsonConvert.SerializeObject(list));
  367. return;
  368. }
  369. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=set_sys_price post请求参数(参数放body中):string tid(淘宝订单号)
  370. public void set_sys_price()
  371. {
  372. string data = GetPostString("data");
  373. if (!string.IsNullOrEmpty(data))
  374. {
  375. List<SysPriceResponseVo> list = JsonConvert.DeserializeObject<List<SysPriceResponseVo>>(data);
  376. foreach (SysPriceResponseVo item in list)
  377. {
  378. string ordersn = item.ordersn;
  379. double price = item.price;
  380. string sysPriceContent = item.sysContent;
  381. CeErpTradeCell ceErpTradeCell = CeErpTradeCell.GetByCode(ordersn);
  382. if (ceErpTradeCell == null)
  383. {
  384. ceErpTradeCell = CeErpTradeCell.GetByCtid(ordersn);
  385. }
  386. if (ceErpTradeCell == null)
  387. {
  388. returnErrorMsg("查无订单");
  389. return;
  390. }
  391. CeErpTradeCellExtend ce = CeErpTradeCellExtend.getByTid(ceErpTradeCell.ctid);
  392. if (ce == null)
  393. {
  394. ce = new CeErpTradeCellExtend();
  395. ce.ctid = ceErpTradeCell.ctid;
  396. }
  397. ce.sysPrice = price;
  398. ce.sysPriceContent = sysPriceContent;
  399. string sql = string.Format("select ptid,payment from CE_ErpTradeCell where ptid ='{0}' and IsSample = 2", ceErpTradeCell.tid);
  400. DataTable dt_price = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
  401. if (dt_price != null && dt_price.Rows.Count > 0)
  402. {
  403. double diffPirce = 0;
  404. foreach (DataRow dr in dt_price.Rows)
  405. {
  406. if (Convert.IsDBNull(dr["payment"]))
  407. {
  408. diffPirce += Convert.ToDouble(dr["payment"]);
  409. }
  410. }
  411. ce.differentAmount = diffPirce;
  412. }
  413. if (ce.ID != 0)
  414. {
  415. ce.Update();
  416. }
  417. else
  418. {
  419. ce.Create();
  420. }
  421. returnSuccessMsg("修改成功!");
  422. return;
  423. }
  424. }
  425. returnErrorMsg("缺少必要参数");
  426. }
  427. public static void get_sys_price(CeErpTradeCell ceErpTradeCell)
  428. {
  429. CeErpProduct product = CeErpProduct.GetById(ceErpTradeCell.ProductId);
  430. string param = "[{ \"product_type\": \"" + product.PType + "\", \"remark\": \"" + ceErpTradeCell.seller_memo + "\" }]";
  431. string result = sysHttpClient(param);
  432. }
  433. public static string sysHttpClient(string param)
  434. {
  435. var client = new HttpClient();
  436. var request = new HttpRequestMessage
  437. {
  438. Method = HttpMethod.Post,
  439. RequestUri = new Uri("http://47.122.57.102:11004/quotations/batch"),
  440. Content = new StringContent(param)
  441. {
  442. Headers =
  443. {
  444. ContentType = new MediaTypeHeaderValue("application/json")
  445. }
  446. }
  447. };
  448. var task = Task.Run(() =>
  449. {
  450. try
  451. {
  452. var response = client.SendAsync(request).Result;
  453. response.EnsureSuccessStatusCode();
  454. return response.Content.ReadAsStringAsync().Result;
  455. }
  456. catch (Exception e)
  457. {
  458. return "";
  459. }
  460. });
  461. return task.Result;
  462. }
  463. public void getOrderInvoiceInfo()
  464. {
  465. string tids = GetPostString("tids");
  466. List<string> list = tids.Split(',').ToList();
  467. return;
  468. }
  469. //http://47.114.150.226:88/Handler/dataHelper.ashx?t=update_spu_info post请求参数(参数放body中):string spuId(淘宝订单号)
  470. public void update_spu_info()
  471. {
  472. string spuId = GetPostString("spuId");
  473. string category = GetPostString("category");
  474. string serialNumber = GetPostString("serialNumber");
  475. string operate = GetPostString("operate");
  476. string designer = GetPostString("designer");
  477. string atta = GetPostString("atta");
  478. string upTime = GetPostString("upTime");
  479. int shopId = GetPostInt("shopId");
  480. if (!string.IsNullOrEmpty(spuId))
  481. {
  482. CeErpTradeSpu spu = CeErpTradeSpu.GetBySpuId(spuId);
  483. if (spu == null)
  484. {
  485. returnErrorMsg("找不到对应id");
  486. return;
  487. }
  488. spu.category = category;
  489. spu.serialNumber = serialNumber;
  490. spu.operate = operate;
  491. spu.designer = designer;
  492. spu.atta = atta;
  493. spu.shopId = shopId;
  494. spu.upTime = DateTime.Parse(upTime);
  495. spu.Update();
  496. returnSuccess("修改成功!");
  497. return;
  498. }
  499. returnErrorMsg("缺少必要参数");
  500. }
  501. static string pUrl = "http://36.140.138.139:688/api/";
  502. static string CLIENT_Id = "xclient";
  503. static string CLIENT_SECRET = "0a417ecce58c31b32364ce19ca8fcd15";
  504. static string USER_ID = "ca2d316357fa4e09b9c2aa9f7b2ca3d9";
  505. public static string getSaleOrderSn()
  506. {
  507. string orderSn = "";
  508. string post_url = "http://api.presales.lingtao8.com/open/order/generateSplitOrderUniqueNos/1";
  509. try
  510. {
  511. string remoteInfo = httpSaleContent(HttpMethod.Get, post_url, new Dictionary<string, string>());
  512. saleOrderResponse dataTokenBean = JsonConvert.DeserializeObject<saleOrderResponse>(remoteInfo);
  513. if ("200".Equals(dataTokenBean.code))
  514. {
  515. orderSn = dataTokenBean.data[0];
  516. }
  517. }
  518. catch (Exception ex)
  519. {
  520. XLog.SaveLog(0, "getSaleOrderSn:" + ex.Message);
  521. }
  522. return orderSn;
  523. }
  524. public static void api_orderBack(string orderNumber, string state, string content)
  525. {
  526. string post_url = "http://api.presales.lingtao8.com/open/order/orderProcessReturn";
  527. //string post_url = "http://admin.lingtao.zmht888.com/prod-api/open/order/orderProcessReturn";
  528. string remoteInfo = "";
  529. string param = JsonConvert.SerializeObject(new
  530. {
  531. orderSplitNo = orderNumber,
  532. errorStatus = state,
  533. reason = content
  534. });
  535. Dictionary<string, string> map = new Dictionary<string, string>();
  536. map.Add("orderSplitNo", orderNumber);
  537. map.Add("errorStatus", state);
  538. map.Add("reason", content);
  539. try
  540. {
  541. remoteInfo = httpSaleContent(HttpMethod.Post, post_url, map);
  542. }
  543. catch (Exception ex)
  544. {
  545. XLog.SaveLog(0, "api_orderBack:" + ex.Message);
  546. }
  547. }
  548. public static long GetTimeStamp()
  549. {
  550. return DateTimeOffset.Now.ToUnixTimeSeconds();
  551. }
  552. public static string getToken()
  553. {
  554. //return "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYXBpIl0sInNjb3BlIjpbInJlYWQiLCJ3cml0ZSJdLCJleHAiOjE3MzU5NjU0ODAsImF1dGhvcml0aWVzIjpbIm9wZW5hcGkiXSwianRpIjoiYjY4NTRhZjctZjNmMy00OTU0LTk4ZmUtZDRlZTE4ZDllNzQyIiwiY2xpZW50X2lkIjoieGNsaWVudCJ9.E6U0NVMZPcUypl4P7L5718J1X8UxSJg9R7vZX_oMkuEJ-yelNXuYwu7-eAi1JTgIJ0GuuviQu-KEAH-W7sHb7t-JJJc-wLPMsLKmpwQDG2EpiRK5hW5ZmyUgL8rPuTUawKVP5k8SGrN60sVyXA2zKm4ztEQ39EGudXnam1Lld2w";
  555. string token = "";
  556. if (RedisHelper.HasKey("xclient_token"))
  557. {
  558. token = RedisHelper.StringGet("xclient_token").ToString();
  559. if (RedisHelper.HasKey("token_end"))
  560. {
  561. string token_end = RedisHelper.StringGet("token_end").ToString();
  562. long token_endtime = Convert.ToInt64(token_end);
  563. long currentTime = GetTimeStamp();
  564. if (currentTime <= token_endtime)
  565. {
  566. return token;
  567. }
  568. }
  569. }
  570. string post_url = pUrl + "oauth/token";
  571. WebClient wc = new WebClient();
  572. wc.Encoding = Encoding.GetEncoding("utf-8");
  573. List<string> headers = new List<string>();
  574. headers.Add("grant_type=client_credentials");
  575. headers.Add("client_id=" + CLIENT_Id);
  576. headers.Add("client_secret=" + CLIENT_SECRET);
  577. post_url += "?" + string.Join("&", headers);
  578. NameValueCollection PostVars = new NameValueCollection();
  579. string remoteInfo = "";
  580. try
  581. {
  582. byte[] ret = wc.UploadValues(post_url, "POST", PostVars);
  583. remoteInfo = Encoding.GetEncoding("utf-8").GetString(ret);
  584. //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\"}";
  585. dataTokenBean dataTokenBean = JsonConvert.DeserializeObject<dataTokenBean>(remoteInfo);
  586. token = dataTokenBean.access_token;
  587. string timeEnd = dataTokenBean.exp;
  588. RedisHelper.StringSet("xclient_token", token);
  589. RedisHelper.StringSet("token_end", timeEnd);
  590. }
  591. catch (Exception ex)
  592. {
  593. }
  594. return token;
  595. }
  596. /// <summary>
  597. /// 获取店铺信息
  598. /// </summary>
  599. /// <param name="shopId"></param>
  600. /// <returns></returns>
  601. public static shopInfo getShopDataInfo(string shopId)
  602. {
  603. try
  604. {
  605. string post_url = pUrl + "openapi/v3/bo/list";
  606. string param = JsonConvert.SerializeObject(new
  607. {
  608. schemaCode = "Store_01",
  609. userId = USER_ID,
  610. queryCondition = new
  611. {
  612. operatorType = 1,
  613. propertyCode = "ErpshopId",
  614. propertyValue = shopId
  615. }
  616. });
  617. string data = httpContent(post_url, param);
  618. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  619. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  620. {
  621. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  622. {
  623. return dataResponseVos.data.bizObjectPage.content[0].data;
  624. }
  625. }
  626. }
  627. catch (Exception ex)
  628. {
  629. }
  630. return null;
  631. }
  632. /// <summary>
  633. /// 获取spu信息
  634. /// </summary>
  635. /// <param name="spuId"></param>
  636. /// <returns></returns>
  637. public static spuInfo getSpuInfo(string spuId)
  638. {
  639. try
  640. {
  641. string post_url = pUrl + "openapi/v3/bo/list";
  642. string param = JsonConvert.SerializeObject(new
  643. {
  644. schemaCode = "lianjieku_01_01",
  645. userId = USER_ID,
  646. queryCondition = new
  647. {
  648. operatorType = 1,
  649. propertyCode = "ShortText1728890649488",
  650. propertyValue = spuId
  651. }
  652. });
  653. string data = httpContent(post_url, param);
  654. dataSpuInfoResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataSpuInfoResponseVo>(data);
  655. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  656. {
  657. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  658. {
  659. return dataResponseVos.data.bizObjectPage.content[0].data;
  660. }
  661. }
  662. }
  663. catch (Exception ex)
  664. {
  665. }
  666. return null;
  667. }
  668. /// <summary>
  669. /// 订单发货是否存在
  670. /// </summary>
  671. /// <param name="dataSendOrderBean"></param>
  672. /// <returns></returns>
  673. public static string checkOrderAlready(dataSendOrderBean dataSendOrderBean)
  674. {
  675. try
  676. {
  677. string post_url = pUrl + "openapi/v3/bo/list";
  678. string param = JsonConvert.SerializeObject(new
  679. {
  680. schemaCode = "dingdanfahuo_01",
  681. userId = USER_ID,
  682. queryCondition = new
  683. {
  684. operatorType = 1,
  685. propertyCode = "ShortText1723707899761",
  686. propertyValue = dataSendOrderBean.ShortText1723707899761
  687. }
  688. });
  689. string data = httpContent(post_url, param);
  690. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  691. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  692. {
  693. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  694. {
  695. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  696. }
  697. return "";
  698. }
  699. }
  700. catch (Exception ex)
  701. {
  702. }
  703. return "";
  704. }
  705. /// <summary>
  706. /// 车间id获取信息
  707. /// </summary>
  708. /// <param name="supplerId"></param>
  709. /// <returns></returns>
  710. public static string getSupplerDataInfo(string supplerId)
  711. {
  712. try
  713. {
  714. string post_url = pUrl + "openapi/v3/bo/list";
  715. string param = JsonConvert.SerializeObject(new
  716. {
  717. schemaCode = "gongyingshang_01",
  718. userId = USER_ID,
  719. queryCondition = new
  720. {
  721. operatorType = 1,
  722. propertyCode = "ErpSupplierId",
  723. propertyValue = supplerId
  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].data.id;
  733. }
  734. }
  735. }
  736. catch (Exception ex)
  737. {
  738. }
  739. return "";
  740. }
  741. /// <summary>
  742. /// 推送发货信息
  743. /// </summary>
  744. /// <param name="dataSendOrderBean"></param>
  745. /// <returns></returns>
  746. public static dataResponseVo CreateBoFahuo(dataSendOrderBean dataSendOrderBean)
  747. {
  748. string post_url = pUrl + "openapi/v3/bo/create";
  749. shopInfo shop = getShopDataInfo(dataSendOrderBean.RelevanceForm1723191239149);
  750. if (shop != null)
  751. {
  752. dataSendOrderBean.RelevanceForm1723191239149 = shop.id;
  753. }
  754. dataSendOrderBean.RelevanceForm1723191634028 = getSupplerDataInfo(dataSendOrderBean.RelevanceForm1723191634028);
  755. string bizObjectId = checkOrderAlready(dataSendOrderBean);
  756. if (!string.IsNullOrEmpty(bizObjectId))
  757. {
  758. post_url = pUrl + "openapi/v3/bo/update";
  759. dataSendOrderBean.id = bizObjectId;
  760. }
  761. string param = JsonConvert.SerializeObject(new
  762. {
  763. schemaCode = "dingdanfahuo_01",
  764. userId = USER_ID,
  765. data = dataSendOrderBean
  766. });
  767. dataResponseVo dataResponseVos = null;
  768. try
  769. {
  770. string data = httpContent(post_url, param);
  771. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  772. return dataResponseVos;
  773. }
  774. catch (Exception ex)
  775. {
  776. dataResponseVos = new dataResponseVo();
  777. dataResponseVos.errcode = "1";
  778. dataResponseVos.errmsg = ex.Message;
  779. }
  780. return dataResponseVos;
  781. }
  782. /// <summary>
  783. /// 推送spu信息
  784. /// </summary>
  785. /// <param name="bean"></param>
  786. /// <returns></returns>
  787. public static dataResponseVo sendSpuInfo(dataSendSpuBean bean)
  788. {
  789. string post_url = pUrl + "openapi/v3/bo/create";
  790. shopInfo shop = getShopDataInfo(bean.shopId);
  791. if (shop != null)
  792. {
  793. bean.RelevanceForm1728891053364 = shop.id;
  794. bean.operation = shop.operation;
  795. }
  796. spuInfo info = getSpuInfo(bean.ShortText1728890649488);
  797. if (info != null)
  798. {
  799. return null;
  800. bean.StaffSingle1728891078584 = info.StaffSingle1728891078584;
  801. bean.Date1728891021647 = info.Date1728891021647;
  802. bean.ShortText1729677042659 = info.ShortText1729677067460;
  803. bean.ShortText1728891031267 = info.ShortText1728891031267;
  804. }
  805. string param = JsonConvert.SerializeObject(new
  806. {
  807. schemaCode = "lianjieku_01",
  808. userId = USER_ID,
  809. data = bean
  810. });
  811. dataResponseVo dataResponseVos = null;
  812. try
  813. {
  814. string data = httpContent(post_url, param);
  815. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  816. return dataResponseVos;
  817. }
  818. catch (Exception ex)
  819. {
  820. dataResponseVos = new dataResponseVo();
  821. dataResponseVos.errcode = "1";
  822. dataResponseVos.errmsg = ex.Message;
  823. }
  824. return dataResponseVos;
  825. }
  826. /// <summary>
  827. /// 主订单数据
  828. /// </summary>
  829. /// <param name="bean"></param>
  830. /// <returns></returns>
  831. public static dataResponseVo sendErpTradeInfo(dataSendTradeBean bean)
  832. {
  833. string post_url = pUrl + "openapi/v3/bo/create";
  834. string bizObjectId = checkErpTradeAlready(bean);
  835. if (!string.IsNullOrEmpty(bizObjectId))
  836. {
  837. post_url = pUrl + "openapi/v3/bo/update";
  838. bean.id = bizObjectId;
  839. }
  840. string param = JsonConvert.SerializeObject(new
  841. {
  842. schemaCode = "zhudingdan_01",
  843. userId = USER_ID,
  844. data = bean
  845. });
  846. dataResponseVo dataResponseVos = null;
  847. try
  848. {
  849. string data = httpContent(post_url, param);
  850. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  851. return dataResponseVos;
  852. }
  853. catch (Exception ex)
  854. {
  855. dataResponseVos = new dataResponseVo();
  856. dataResponseVos.errcode = "1";
  857. dataResponseVos.errmsg = ex.Message;
  858. }
  859. return dataResponseVos;
  860. }
  861. /// <summary>
  862. /// 校验主订单是否存在
  863. /// </summary>
  864. /// <param name="dataSendOrderBean"></param>
  865. /// <returns></returns>
  866. public static string checkErpTradeAlready(dataSendTradeBean dataSendOrderBean)
  867. {
  868. try
  869. {
  870. string post_url = pUrl + "openapi/v3/bo/list";
  871. string param = JsonConvert.SerializeObject(new
  872. {
  873. schemaCode = "zhudingdan_01",
  874. userId = USER_ID,
  875. queryCondition = new
  876. {
  877. operatorType = 1,
  878. propertyCode = "ShortText1724739958776",
  879. propertyValue = dataSendOrderBean.ShortText1724739958776
  880. }
  881. });
  882. string data = httpContent(post_url, param);
  883. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  884. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  885. {
  886. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  887. {
  888. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  889. }
  890. return "";
  891. }
  892. }
  893. catch (Exception ex)
  894. {
  895. }
  896. return "";
  897. }
  898. /// <summary>
  899. /// 拆订单数据
  900. /// </summary>
  901. /// <param name="bean"></param>
  902. /// <returns></returns>
  903. public static dataResponseVo sendErpTradeCellInfo(dataSendTradeCellBean bean)
  904. {
  905. string post_url = pUrl + "openapi/v3/bo/create";
  906. string bizObjectId = checkErpTradeCellAlready(bean);
  907. if (!string.IsNullOrEmpty(bizObjectId))
  908. {
  909. post_url = pUrl + "openapi/v3/bo/update";
  910. bean.id = bizObjectId;
  911. }
  912. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.tid));
  913. if (!string.IsNullOrEmpty(tid_id))
  914. {
  915. bean.RelevanceForm1724834153527 = tid_id;
  916. }
  917. shopInfo shop = getShopDataInfo(bean.shopId);
  918. if (shop != null)
  919. {
  920. bean.RelevanceForm1717742363336 = shop.id;
  921. }
  922. string param = JsonConvert.SerializeObject(new
  923. {
  924. schemaCode = "orders_01",
  925. userId = USER_ID,
  926. data = bean
  927. });
  928. dataResponseVo dataResponseVos = null;
  929. try
  930. {
  931. string data = httpContent(post_url, param);
  932. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  933. return dataResponseVos;
  934. }
  935. catch (Exception ex)
  936. {
  937. dataResponseVos = new dataResponseVo();
  938. dataResponseVos.errcode = "1";
  939. dataResponseVos.errmsg = ex.Message;
  940. }
  941. return dataResponseVos;
  942. }
  943. /// <summary>
  944. /// 校验拆订单是否存在
  945. /// </summary>
  946. /// <param name="dataSendOrderBean"></param>
  947. /// <returns></returns>
  948. public static string checkErpTradeCellAlready(dataSendTradeCellBean dataSendOrderBean)
  949. {
  950. try
  951. {
  952. string post_url = pUrl + "openapi/v3/bo/list";
  953. string param = JsonConvert.SerializeObject(new
  954. {
  955. schemaCode = "orders_01",
  956. userId = USER_ID,
  957. queryCondition = new
  958. {
  959. operatorType = 1,
  960. propertyCode = "ShortText1717720509648",
  961. propertyValue = dataSendOrderBean.ShortText1717720509648
  962. }
  963. });
  964. string data = httpContent(post_url, param);
  965. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  966. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  967. {
  968. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  969. {
  970. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  971. }
  972. return "";
  973. }
  974. }
  975. catch (Exception ex)
  976. {
  977. }
  978. return "";
  979. }
  980. /// <summary>
  981. /// 更新数据
  982. /// </summary>
  983. /// <param name="map"></param>
  984. /// <param name="ctid"></param>
  985. /// <returns></returns>
  986. public static dataResponseVo updateErpTradeCell(Dictionary<string, string> map, string ctid)
  987. {
  988. return null;
  989. string post_url = pUrl + "openapi/v3/bo/update";
  990. dataResponseVo dataResponseVos = null;
  991. dataSendTradeCellBean bean = new dataSendTradeCellBean();
  992. if (string.IsNullOrEmpty(ctid))
  993. {
  994. dataResponseVos = new dataResponseVo();
  995. dataResponseVos.errcode = "1";
  996. dataResponseVos.errmsg = "未找到订单";
  997. return dataResponseVos;
  998. }
  999. bean.ShortText1717720509648 = ctid;
  1000. string bizObjectId = checkErpTradeCellAlready(bean);
  1001. if (string.IsNullOrEmpty(bizObjectId))
  1002. {
  1003. dataResponseVos = new dataResponseVo();
  1004. dataResponseVos.errcode = "1";
  1005. dataResponseVos.errmsg = "未找到订单";
  1006. return dataResponseVos;
  1007. }
  1008. map.Add("id", bizObjectId);
  1009. string param = JsonConvert.SerializeObject(new
  1010. {
  1011. schemaCode = "orders_01",
  1012. userId = USER_ID,
  1013. data = map
  1014. });
  1015. try
  1016. {
  1017. string data = httpContent(post_url, param);
  1018. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  1019. return dataResponseVos;
  1020. }
  1021. catch (Exception ex)
  1022. {
  1023. dataResponseVos = new dataResponseVo();
  1024. dataResponseVos.errcode = "1";
  1025. dataResponseVos.errmsg = ex.Message;
  1026. }
  1027. return dataResponseVos;
  1028. }
  1029. /// <summary>
  1030. /// 子订单数据
  1031. /// </summary>
  1032. /// <param name="bean"></param>
  1033. /// <returns></returns>
  1034. public static dataResponseVo sendErpTradeOrderInfo(dataSendTradeOrderBean bean)
  1035. {
  1036. string post_url = pUrl + "openapi/v3/bo/create";
  1037. string bizObjectId = checkErpTradeOrderAlready(bean);
  1038. if (!string.IsNullOrEmpty(bizObjectId))
  1039. {
  1040. post_url = pUrl + "openapi/v3/bo/update";
  1041. bean.id = bizObjectId;
  1042. }
  1043. string tid_id = checkErpTradeAlready(new dataSendTradeBean(bean.ShortText1724898549414));
  1044. if (!string.IsNullOrEmpty(tid_id))
  1045. {
  1046. bean.RelevanceForm1724898561483 = tid_id;
  1047. }
  1048. string param = JsonConvert.SerializeObject(new
  1049. {
  1050. schemaCode = "zidingdan_01",
  1051. userId = USER_ID,
  1052. data = bean
  1053. });
  1054. dataResponseVo dataResponseVos = null;
  1055. try
  1056. {
  1057. string data = httpContent(post_url, param);
  1058. dataResponseVos = JsonConvert.DeserializeObject<dataResponseVo>(data);
  1059. return dataResponseVos;
  1060. }
  1061. catch (Exception ex)
  1062. {
  1063. dataResponseVos = new dataResponseVo();
  1064. dataResponseVos.errcode = "1";
  1065. dataResponseVos.errmsg = ex.Message;
  1066. }
  1067. return dataResponseVos;
  1068. }
  1069. /// <summary>
  1070. /// 校验子订单是否存在
  1071. /// </summary>
  1072. /// <param name="dataSendOrderBean"></param>
  1073. /// <returns></returns>
  1074. public static string checkErpTradeOrderAlready(dataSendTradeOrderBean dataSendOrderBean)
  1075. {
  1076. try
  1077. {
  1078. string post_url = pUrl + "openapi/v3/bo/list";
  1079. string param = JsonConvert.SerializeObject(new
  1080. {
  1081. schemaCode = "zidingdan_01",
  1082. userId = USER_ID,
  1083. queryCondition = new
  1084. {
  1085. operatorType = 1,
  1086. propertyCode = "ShortText1724898595268",
  1087. propertyValue = dataSendOrderBean.ShortText1724898595268
  1088. }
  1089. });
  1090. string data = httpContent(post_url, param);
  1091. dataShopResponseVo dataResponseVos = JsonConvert.DeserializeObject<dataShopResponseVo>(data);
  1092. if (dataResponseVos != null && "0".Equals(dataResponseVos.errcode))
  1093. {
  1094. if (dataResponseVos.data.bizObjectPage.content.Count > 0)
  1095. {
  1096. return dataResponseVos.data.bizObjectPage.content[0].bizObjectId;
  1097. }
  1098. return "";
  1099. }
  1100. }
  1101. catch (Exception ex)
  1102. {
  1103. }
  1104. return "";
  1105. }
  1106. static HttpClient client = new HttpClient();
  1107. private static string httpSaleContent(HttpMethod httpMethod, string post_url, Dictionary<string, string> map)
  1108. {
  1109. var request = new HttpRequestMessage
  1110. {
  1111. Method = httpMethod,
  1112. RequestUri = new Uri(post_url),
  1113. Headers =
  1114. {
  1115. { "token", "Zk2ncXqH8hFyA6Rj"},
  1116. }
  1117. };
  1118. if (map.Keys.Count > 0)
  1119. {
  1120. request.Content = new FormUrlEncodedContent(map);
  1121. }
  1122. var task = Task.Run(() =>
  1123. {
  1124. try
  1125. {
  1126. var response = client.SendAsync(request).Result;
  1127. response.EnsureSuccessStatusCode();
  1128. return response.Content.ReadAsStringAsync().Result;
  1129. }
  1130. catch (Exception ex)
  1131. {
  1132. return "";
  1133. }
  1134. });
  1135. return task.Result;
  1136. }
  1137. private static string httpContent(string post_url, string content)
  1138. {
  1139. string token = getToken();
  1140. var request = new HttpRequestMessage
  1141. {
  1142. Method = HttpMethod.Post,
  1143. RequestUri = new Uri(post_url),
  1144. Headers =
  1145. {
  1146. { "Authorization", "Bearer " + token },
  1147. },
  1148. Content = new StringContent(content)
  1149. {
  1150. Headers =
  1151. {
  1152. ContentType = new MediaTypeHeaderValue("application/json")
  1153. }
  1154. }
  1155. };
  1156. var task = Task.Run(() =>
  1157. {
  1158. try
  1159. {
  1160. var response = client.SendAsync(request).Result;
  1161. response.EnsureSuccessStatusCode();
  1162. return response.Content.ReadAsStringAsync().Result;
  1163. }
  1164. catch (Exception e)
  1165. {
  1166. return "";
  1167. }
  1168. });
  1169. return task.Result;
  1170. }
  1171. }
  1172. }