DataManagerInstance.cs 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
  1. namespace SHJX.Service.Control.Common.Assets
  2. {
  3. public class DataManagerInstance
  4. {
  5. private static readonly ILogger logger = LogFactory.BuildLogger(typeof(DataManagerInstance));
  6. private static IDataManager _dataManager;
  7. private static readonly object recode_lock = new();
  8. private static IEventAggregator _ea;
  9. public static List<ShowStatusValueArgs> statusValue = new();
  10. private static string ShowStatusBefore = "";
  11. public DataManagerInstance(IEventAggregator ea, IDataManager dataManager)
  12. {
  13. _ea = ea;
  14. _dataManager = dataManager;
  15. }
  16. public static PID GetPid()
  17. {
  18. return _dataManager.Query<PID>().First();
  19. }
  20. public static MotorSpeed GetSpeed(string name)
  21. {
  22. return _dataManager.Query<MotorSpeed>().Where(it => it.SystemName.Equals(name)).First();
  23. }
  24. public static LiquidVolume GetLiquidVolume(string name)
  25. {
  26. return _dataManager.Query<LiquidVolume>().Where(it => it.LiquidName.Equals(name)).First();
  27. }
  28. public static LiquidAmount GetLiquidAmount(string name)
  29. {
  30. return _dataManager.Query<LiquidAmount>().Where(it => it.LiquidName.Equals(name)).First();
  31. }
  32. public static bool Record(EquipmentTask task, string value)
  33. {
  34. try
  35. {
  36. if (task is null )
  37. {
  38. return false;
  39. }
  40. lock (recode_lock)
  41. {
  42. int rows = _dataManager.Update<EquipmentTask>().SetValues(it => it.Record.Set(value)).Where(it => it.SerialKey.Equals(task.SerialKey) && it.Source.Equals(task.Source)).Execute();
  43. return rows > 0;
  44. }
  45. }
  46. catch
  47. {
  48. return false;
  49. }
  50. }
  51. public static bool ShowStatus(EquipmentTask task, string value)
  52. {
  53. try
  54. {
  55. if (task is null)
  56. {
  57. return false;
  58. }
  59. lock (recode_lock)
  60. {
  61. ShowStatusValueArgs status = new ShowStatusValueArgs();
  62. if (ShowStatusBefore == task.RouteStep.ToString())
  63. {
  64. return true;
  65. }
  66. ShowStatusBefore = task.RouteStep.ToString();
  67. string step = task.RouteStep.ToString() switch
  68. {
  69. "AddLiquid" => "加液",
  70. "AddLiquidGoback" => "加液返回",
  71. "Dissolve" => "消解",
  72. "DissolveGoback" => "消解结束",
  73. "Titration" => "1号滴定",
  74. "Titration2" => "2号滴定",
  75. "TitrationGoback" => "1号滴定返回",
  76. "Titration2Goback" => "2号滴定返回",
  77. };
  78. status.CurrentContent = task.Source + ":" + step + "-" + "从(" + task.From + ")到(" + task.To + ")";
  79. status.Name = task.Source.ToString();
  80. _ea.GetEvent<UpdateStausEvent>().Publish(status);
  81. return true;
  82. }
  83. }
  84. catch
  85. {
  86. return false;
  87. }
  88. }
  89. public static TitrationValue GetTitrationValue(string type)
  90. {
  91. return _dataManager.Query<TitrationValue>().Where(it => it.TitrationType.Equals(type)).First();
  92. }
  93. public static Titration2Value GetTitration2Value(string type)
  94. {
  95. return _dataManager.Query<Titration2Value>().Where(it => it.TitrationType.Equals(type)).First();
  96. }
  97. public static CameraValue GetCameraValue()
  98. {
  99. return _dataManager.Query<CameraValue>().First();
  100. }
  101. public static Camera2Value GetCamera2Value()
  102. {
  103. return _dataManager.Query<Camera2Value>().First();
  104. }
  105. public static EquipmentTask GetWaitingTaskBySource(string source)
  106. {
  107. return _dataManager.Query<EquipmentTask>().Where(it => it.Source.Equals(source) && it.Status.Equals(TaskState.Waiting)).First();
  108. }
  109. public static EquipmentTask GetTaskBySourceAndState(string source, params TaskState[] states)
  110. {
  111. return _dataManager.Query<EquipmentTask>().Where(it => it.Status.In(states) && it.Source.Equals(source)).First();
  112. }
  113. public static DissolveDate GetDissolveDateByEnable()
  114. {
  115. return _dataManager.Query<DissolveDate>().Where(it => it.Start.Equals(true)).OrderBy(it => it.LastTryTime).First();
  116. }
  117. public static EquipmentArea GetAreaByPoint(string point)
  118. {
  119. return _dataManager.Query<EquipmentArea>().Where(it => it.PointName.Equals(point)).First();
  120. }
  121. public static EquipmentArea GetAreaByAreaName(string name)
  122. {
  123. return _dataManager.Query<EquipmentArea>().Where(it => it.AreaName.Equals(name)).First();
  124. }
  125. public static List<EquipmentArea> GetEquipmentAreas(string value1, string value2)
  126. {
  127. return _dataManager.Query<EquipmentArea>().Where(it => it.PointName.In(value1, value2)).ToList();
  128. }
  129. public static List<PositionHotlist> GetPositionHotlists(string value1, string value2)
  130. {
  131. return _dataManager.Query<PositionHotlist>().Where(it => it.PositionName.In(value1, value2)).ToList();
  132. }
  133. public static List<RouteCache> GetCaches(string arg)
  134. {
  135. return _dataManager.Query<RouteCache>().Where(it => it.Source.Equals(arg)).ToList();
  136. }
  137. public static StateMachine GetStateMachine()
  138. {
  139. return _dataManager.Query<StateMachine>().Where(item => item.Name.Equals(StateMachineName.MOTOR_LOCK)).First();
  140. }
  141. public static bool Update<T>(T t) where T : class
  142. {
  143. return _dataManager.Update(t) > 0;
  144. }
  145. public static bool Delete<T>(T t) where T : class
  146. {
  147. return _dataManager.Delete(t) > 0;
  148. }
  149. public static StateMachine QueryStateMachine(string name)
  150. {
  151. return _dataManager.Query<StateMachine>().Where(it => it.Name.Equals(name)).First();
  152. }
  153. public static bool IncreaseLock(string name)
  154. {
  155. return _dataManager.Update<StateMachine>().Invoke(it => it.Status.Set(1))(it => it.Name.Equals(name)) > 0;
  156. }
  157. public static bool DecreaseLock(string name)
  158. {
  159. return _dataManager.Update<StateMachine>().Invoke(it => it.Status.Set(0))(it => it.Name.Equals(name)) > 0;
  160. }
  161. public static bool DecreaseLiquidTotal(string name, double value)
  162. {
  163. LiquidTotal liquid = _dataManager.Query<LiquidTotal>().Where(it => it.LiquidName.Equals(name)).First();
  164. var remain = liquid.Total - value;
  165. logger.LogDebug($"{name}液体总量为:{liquid.Total},扣减:{value},剩余{remain}");
  166. return _dataManager.Update<LiquidTotal>().Invoke(it => it.Total.Set(remain))(it => it.LiquidName.Equals(name)) > 0;
  167. }
  168. public static bool DecreaseLiquidReserve(string name)
  169. {
  170. double decreaseValue = name switch
  171. {
  172. "SodiumOxalate" => 10,
  173. "SodiumHydroxide" => 0.5,
  174. "PotassiumPermanganate" => 25,
  175. "Vitriol" => 5,
  176. _ => 0,
  177. };
  178. LiquidReserve liquid = _dataManager.Query<LiquidReserve>().Where(it => it.LiquidName.Equals(name)).First();
  179. var remain = liquid.Value - decreaseValue;
  180. return _dataManager.Update<LiquidReserve>().Invoke(it => it.Value.Set(remain))(it => it.LiquidName.Equals(name)) > 0;
  181. }
  182. }
  183. }