ProtocolProxy.cs 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262
  1. using DBHelper;
  2. using FreeRedis;
  3. using MessagePack;
  4. using MessagePack.Resolvers;
  5. using Microsoft.EntityFrameworkCore;
  6. using System;
  7. using System.Collections.Concurrent;
  8. using System.Collections.Generic;
  9. using System.Diagnostics;
  10. using System.Linq;
  11. using System.Linq.Dynamic.Core;
  12. using System.Reflection;
  13. using WCS.Core;
  14. using WCS.Entity;
  15. using WCS.Entity.Protocol;
  16. namespace WCS.Service
  17. {
  18. public class ProtocolProxy : ProtocolProxyBase
  19. {
  20. private MethodInfo SetMethod;
  21. public ProtocolProxy(string id, WCS_DATABLOCK db, ushort start, WCS_DEVICEPROTOCOL protocol) : base(id, db, start, protocol)
  22. {
  23. SetMethod = typeof(DbContext).GetMethod("Set", new Type[] { }).MakeGenericMethod(this.ProtocolDataType);
  24. }
  25. private static ConcurrentDictionary<Type, object[]> LastDatas = new ConcurrentDictionary<Type, object[]>();
  26. protected override WCS_PROTOCOLDATA GetLastData(DB db)
  27. {
  28. if (!LastDatas.ContainsKey(this.ProtocolDataType))
  29. {
  30. dynamic q = SetMethod.Invoke(db.Default, null);
  31. try
  32. {
  33. q = DynamicQueryableExtensions.Where(q, "ISLAST==@0", true);
  34. q = DynamicQueryableExtensions.OrderBy(q, "ID");
  35. q = DynamicQueryableExtensions.Select(q, "new(it.DEVICE.CODE as Code,it as Data)");
  36. var arr = Enumerable.ToArray(q);
  37. LastDatas[this.ProtocolDataType] = arr;
  38. }
  39. catch (Exception ex)
  40. {
  41. throw;
  42. }
  43. }
  44. dynamic datas = LastDatas[this.ProtocolDataType];
  45. var list = new List<WCS_PROTOCOLDATA>();
  46. foreach (var data in datas)
  47. {
  48. if (data.Code == PROTOCOL.DEVICE.CODE)
  49. list.Add(data.Data);
  50. }
  51. if (list.Count > 1)
  52. {
  53. for (int i = 0; i < list.Count - 1; i++)
  54. {
  55. var obj = list[i];
  56. db.Default.Attach(obj);
  57. obj.ISLAST = false;
  58. }
  59. db.Default.SaveChanges();
  60. }
  61. var res = Enumerable.LastOrDefault(list);
  62. return res;
  63. }
  64. private static int total;
  65. protected override WCS_PROTOCOLDATA SaveNewData(DB db, WCS_PROTOCOLDATA last, WCS_PROTOCOLDATA newobj, string user)
  66. {
  67. total++;
  68. if (last != null)
  69. {
  70. db.Default.Attach(last);
  71. last.ISLAST = false;
  72. }
  73. db.Default.Attach(PROTOCOL.DEVICE);
  74. newobj.DEVICE = PROTOCOL.DEVICE;
  75. newobj.ISLAST = true;
  76. newobj.UPDATETIME = DateTime.Now;
  77. newobj.UPDATEUSER = user;
  78. newobj.FRAME = LogicHandler.Frame;
  79. db.Default.Add(newobj);
  80. db.Default.SaveChanges();
  81. return newobj;
  82. }
  83. //static ConcurrentQueue<PackInfo> Packs = new ConcurrentQueue<PackInfo>();
  84. private static Dictionary<string, Playerback> Clients = new Dictionary<string, Playerback>();
  85. //private static RedisClient Redis;
  86. public static RedisClient YGRedis;
  87. static ProtocolProxy()
  88. {
  89. MessagePackSerializer.DefaultOptions = StandardResolver.Options.WithCompression(MessagePackCompression.Lz4Block);
  90. //Redis = new RedisClient("192.168.249.120,password=123456,database=11");
  91. #region 公用云服务器
  92. //Redis = new RedisClient("212.64.66.35,password=Aa123456,database=10");
  93. //Redis.Serialize = obj =>
  94. //{
  95. // var bytes = MessagePackSerializer.Serialize(obj);
  96. // return bytes;
  97. //};
  98. //Redis.DeserializeRaw = (bytes, type) =>
  99. //{
  100. // var obj = MessagePackSerializer.Deserialize(type, bytes);
  101. // return obj;
  102. //};
  103. #endregion 公用云服务
  104. #region 永冠服务
  105. YGRedis = new RedisClient("106.15.78.3,password=Password@123$%^,database=2");
  106. YGRedis.Serialize = obj =>
  107. {
  108. var bytes = MessagePackSerializer.Serialize(obj);
  109. return bytes;
  110. };
  111. YGRedis.DeserializeRaw = (bytes, type) =>
  112. {
  113. var obj = MessagePackSerializer.Deserialize(type, bytes);
  114. return obj;
  115. };
  116. #endregion 永冠服务
  117. }
  118. public override void Publish(string code, WCS_PROTOCOLDATA obj)
  119. {
  120. try
  121. {
  122. var Datas = AllDatas;
  123. if (code.StartsWith("SRM"))
  124. {
  125. if (!Datas.ContainsKey(code))
  126. Datas[code] = new SCData { Code = code };
  127. }
  128. else if (code.StartsWith("RGV"))
  129. {
  130. if (!Datas.ContainsKey(code))
  131. Datas[code] = new RGVData { Code = code };
  132. }
  133. else if (code == "Robot")
  134. {
  135. if (!Datas.ContainsKey(code))
  136. Datas[code] = new RobotData { Code = code };
  137. }
  138. else if (code.Length == 4)
  139. {
  140. if (!Datas.ContainsKey(code))
  141. Datas[code] = new StationData { Code = code };
  142. }
  143. if (Datas.ContainsKey(code))
  144. {
  145. var data = Datas[code];
  146. data.Frame = LogicHandler.Frame;
  147. var p = data.GetType().GetProperties().Where(v => v.PropertyType == obj.GetType()).FirstOrDefault();
  148. if (p == null)
  149. {
  150. Console.WriteLine("类型" + data.GetType().Name + "不包含类型为" + obj.GetType().Name + "的属性");
  151. }
  152. else
  153. {
  154. p.SetValue(data, obj);
  155. }
  156. }
  157. }
  158. catch (Exception ex)
  159. {
  160. Console.WriteLine(ex.Message);
  161. }
  162. }
  163. private static Dictionary<string, string> LastInfo = new Dictionary<string, string>();
  164. public static ConcurrentDictionary<string, DeviceData> AllDatas = new ConcurrentDictionary<string, DeviceData>();
  165. public static void Do()
  166. {
  167. Console.ForegroundColor = ConsoleColor.Green;
  168. Console.WriteLine($"更改:{total}");
  169. Console.ResetColor();
  170. total = 0;
  171. try
  172. {
  173. var gs = AllDatas.GroupBy(v => v.Value.GetType());
  174. DeviceDataPack pack = new DeviceDataPack();
  175. pack.Frame = LogicHandler.Frame;
  176. foreach (var g in gs)
  177. {
  178. var value = g.Select(v => v.Value).ToArray();
  179. var etype = g.Key;
  180. var type = typeof(DeviceDataCollection<>).MakeGenericType(etype);
  181. var coll = Activator.CreateInstance(type, LogicHandler.Frame, value);
  182. var p = pack.GetType().GetProperties().Where(v => v.PropertyType == type).First();
  183. p.SetValue(pack, coll);
  184. }
  185. var sw = new Stopwatch();
  186. sw.Start();
  187. //Redis.Set(nameof(DeviceDataPack), pack);
  188. YGRedis.Set(nameof(DeviceDataPack), pack);
  189. sw.Stop();
  190. Console.ForegroundColor = ConsoleColor.Blue;
  191. Console.WriteLine($"Redis耗时{sw.ElapsedMilliseconds}");
  192. Console.ResetColor();
  193. var st = new Stopwatch();
  194. st.Start();
  195. //Redis.RPush("Packs", pack);
  196. YGRedis.RPush("Packs", pack);
  197. st.Stop();
  198. Console.ForegroundColor = ConsoleColor.Blue;
  199. Console.WriteLine($"Redis耗时{st.ElapsedMilliseconds}");
  200. Console.ResetColor();
  201. //if (Redis.LLen("Packs") > 100000)
  202. //{
  203. // Redis.LTrim("Packs", 5000, -1);
  204. //}
  205. if (YGRedis.LLen("Packs") > 600000)
  206. {
  207. YGRedis.LTrim("Packs", 5000, -1);
  208. }
  209. foreach (var data in AllDatas)
  210. {
  211. LastInfo[data.Key] = data.Value.Info;
  212. data.Value.Info = "";
  213. if (data.Value is ProdLineData)
  214. {
  215. var pld = data.Value as ProdLineData;
  216. pld.TaskList.Clear();
  217. pld.Frame = LogicHandler.Frame;
  218. pld.Code = data.Key;
  219. }
  220. }
  221. }
  222. catch (Exception ex)
  223. {
  224. }
  225. }
  226. }
  227. public class PackInfo
  228. {
  229. public DateTime Frame { get; set; }
  230. public byte[] Data { get; set; }
  231. }
  232. }