IQueryDataService.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296
  1. using Aitex.Core.Common;
  2. using Aitex.Core.Common.DeviceData;
  3. using Aitex.Core.RT.Event;
  4. using Aitex.Core.UI.ControlDataContext;
  5. using Aitex.Core.Util;
  6. using Aitex.Sorter.Common;
  7. using MECF.Framework.Common.Beckhoff.AxisProvider;
  8. using MECF.Framework.Common.Beckhoff.IOAxis;
  9. using MECF.Framework.Common.Beckhoff.Station;
  10. using MECF.Framework.Common.CommonData;
  11. using MECF.Framework.Common.CommonData.DeviceData;
  12. using MECF.Framework.Common.CommonData.Dryer;
  13. using MECF.Framework.Common.CommonData.Loader;
  14. using MECF.Framework.Common.CommonData.Metal;
  15. using MECF.Framework.Common.CommonData.PowerSupplier;
  16. using MECF.Framework.Common.CommonData.Prewet;
  17. using MECF.Framework.Common.CommonData.PUF;
  18. using MECF.Framework.Common.CommonData.Reservoir;
  19. using MECF.Framework.Common.CommonData.SRD;
  20. using MECF.Framework.Common.CommonData.TemperatureControl;
  21. using MECF.Framework.Common.CommonData.Transporter;
  22. using MECF.Framework.Common.CommonData.Vpw;
  23. using MECF.Framework.Common.ControlDataContext;
  24. using MECF.Framework.Common.DBCore;
  25. using MECF.Framework.Common.Device.LinMot;
  26. using MECF.Framework.Common.Device.PowerSupplier;
  27. using MECF.Framework.Common.Device.ResistivityProbe;
  28. using MECF.Framework.Common.Device.Rinse;
  29. using MECF.Framework.Common.Device.Safety;
  30. using MECF.Framework.Common.Device.TemperatureController;
  31. using MECF.Framework.Common.Equipment;
  32. using MECF.Framework.Common.IOCore;
  33. using MECF.Framework.Common.Jobs;
  34. using MECF.Framework.Common.Layout;
  35. using MECF.Framework.Common.Persistent.Prewet;
  36. using MECF.Framework.Common.Persistent.Reservoirs;
  37. using MECF.Framework.Common.Persistent.Rinse;
  38. using MECF.Framework.Common.Persistent.SRD;
  39. using MECF.Framework.Common.Persistent.Temperature;
  40. using MECF.Framework.Common.Persistent.VpwMain;
  41. using MECF.Framework.Common.ProcessCell;
  42. using MECF.Framework.Common.RecipeCenter;
  43. using MECF.Framework.Common.Schedulers;
  44. using MECF.Framework.Common.SubstrateTrackings;
  45. using MECF.Framework.Common.ToolLayout;
  46. using PunkHPX8_Core;
  47. using System;
  48. using System.Collections.Concurrent;
  49. using System.Collections.Generic;
  50. using System.Collections.ObjectModel;
  51. using System.Data;
  52. using System.ServiceModel;
  53. using VenusCommon;
  54. namespace MECF.Framework.Common.DataCenter
  55. {
  56. [ServiceContract]
  57. [ServiceKnownType(typeof(SignalTowerDataItem))]
  58. [ServiceKnownType(typeof(ControlJobInfo))]
  59. [ServiceKnownType(typeof(GateValveDataItem))]
  60. [ServiceKnownType(typeof(List<EventItem>))]
  61. [ServiceKnownType(typeof(List<HistoryCarrierData>))]
  62. [ServiceKnownType(typeof(List<HistoryProcessData>))]
  63. [ServiceKnownType(typeof(List<HistoryWaferData>))]
  64. [ServiceKnownType(typeof(List<HistoryMoveData>))]
  65. [ServiceKnownType(typeof(List<LeakCheckResultItem>))]
  66. [ServiceKnownType(typeof(List<NotifiableIoItem>))]
  67. [ServiceKnownType(typeof(NotifiableIoItem))]
  68. [ServiceKnownType(typeof(AITValveData))]
  69. [ServiceKnownType(typeof(AITMfcData))]
  70. [ServiceKnownType(typeof(AITHeaterData))]
  71. [ServiceKnownType(typeof(AITChillerData))]
  72. [ServiceKnownType(typeof(AITThermalCoupleData))]
  73. [ServiceKnownType(typeof(AITWaterFlowMeterData))]
  74. [ServiceKnownType(typeof(AITPressureMeterData))]
  75. [ServiceKnownType(typeof(AITRfData))]
  76. [ServiceKnownType(typeof(AITThrottleValveData))]
  77. [ServiceKnownType(typeof(AITSensorData))]
  78. [ServiceKnownType(typeof(AITPumpData))]
  79. [ServiceKnownType(typeof(AITSignalTowerData))]
  80. [ServiceKnownType(typeof(AITEmoData))]
  81. [ServiceKnownType(typeof(AITStatisticsData))]
  82. [ServiceKnownType(typeof(AITBoostPumpData))]
  83. [ServiceKnownType(typeof(AITCylinderData))]
  84. [ServiceKnownType(typeof(AITWaterFlowSensorData))]
  85. [ServiceKnownType(typeof(AITServoMotorData))]
  86. [ServiceKnownType(typeof(AITLidData))]
  87. [ServiceKnownType(typeof(ServoState))]
  88. [ServiceKnownType(typeof(AITRfPowerData))]
  89. [ServiceKnownType(typeof(AITRfMatchData))]
  90. [ServiceKnownType(typeof(AITHVData))]
  91. [ServiceKnownType(typeof(FlowMeterAlarmItem))]
  92. [ServiceKnownType(typeof(WaferInfo))]
  93. [ServiceKnownType(typeof(WaferInfo[]))]
  94. [ServiceKnownType(typeof(CarrierInfo))]
  95. [ServiceKnownType(typeof(CarrierInfo[]))]
  96. [ServiceKnownType(typeof(NotifiableIoItem))]
  97. [ServiceKnownType(typeof(IndicatorState))]
  98. [ServiceKnownType(typeof(FoupClampState))]
  99. [ServiceKnownType(typeof(FoupDoorState))]
  100. [ServiceKnownType(typeof(LoadportCassetteState))]
  101. [ServiceKnownType(typeof(AITRfidReaderData))]
  102. [ServiceKnownType(typeof(AITAlignerData))]
  103. [ServiceKnownType(typeof(AITWaferIdReaderData))]
  104. [ServiceKnownType(typeof(AITHighTemperatureHeaterData))]
  105. [ServiceKnownType(typeof(ResRecipe))]
  106. [ServiceKnownType(typeof(DepRecipe))]
  107. [ServiceKnownType(typeof(PwtRecipe))]
  108. [ServiceKnownType(typeof(HvdRecipe))]
  109. [ServiceKnownType(typeof(SrdRecipe))]
  110. [ServiceKnownType(typeof(QdrRecipe))]
  111. [ServiceKnownType(typeof(ModuleName))]
  112. [ServiceKnownType(typeof(LidState))]
  113. [ServiceKnownType(typeof(DeviceState))]
  114. [ServiceKnownType(typeof(SorterRecipeXml))]
  115. [ServiceKnownType(typeof(SorterRecipeType))]
  116. [ServiceKnownType(typeof(SorterRecipePlaceModeOrder))]
  117. [ServiceKnownType(typeof(SorterRecipePlaceModeTransfer1To1))]
  118. [ServiceKnownType(typeof(SorterRecipePlaceModePack))]
  119. [ServiceKnownType(typeof(ObservableCollection<SorterRecipeTransferTableItem>))]
  120. [ServiceKnownType(typeof(SorterRecipeTransferTableItem))]
  121. [ServiceKnownType(typeof(SlotTransferInfo))]
  122. [ServiceKnownType(typeof(SlotTransferInfo[]))]
  123. [ServiceKnownType(typeof(List<string>))]
  124. [ServiceKnownType(typeof(SerializableDictionary<string, bool>))]
  125. [ServiceKnownType(typeof(SerializableDictionary<string, string>))]
  126. [ServiceKnownType(typeof(ConcurrentDictionary<string, bool>))]
  127. [ServiceKnownType(typeof(SerializableDictionary<string, List<string>>))]
  128. [ServiceKnownType(typeof(MoveItem))]
  129. [ServiceKnownType(typeof(RobotMoveInfo))]
  130. [ServiceKnownType(typeof(RecipeResult))]
  131. [ServiceKnownType(typeof(AITPendulumValveData))]
  132. [ServiceKnownType(typeof(ObservableCollection<MFCCalibrationData>))]
  133. [ServiceKnownType(typeof(List<PMLeakCheckResult>))]
  134. [ServiceKnownType(typeof(BeckhoffStationAxis))]
  135. [ServiceKnownType(typeof(BeckhoffAxis))]
  136. [ServiceKnownType(typeof(BeckhoffProviderAxis))]
  137. [ServiceKnownType(typeof(LinmotDeviceConfig))]
  138. [ServiceKnownType(typeof(CommandMotionData))]
  139. [ServiceKnownType(typeof(PowerSupplierData))]
  140. [ServiceKnownType(typeof(ThorntonDeviceConfig))]
  141. [ServiceKnownType(typeof(TemperatureDeviceConfig))]
  142. [ServiceKnownType(typeof(TemperatureControllerData))]
  143. [ServiceKnownType(typeof(LoaderSideData))]
  144. [ServiceKnownType(typeof(LoaderCommonData))]
  145. [ServiceKnownType(typeof(ProcessLayout))]
  146. [ServiceKnownType(typeof(PowerSupplierDevice))]
  147. [ServiceKnownType(typeof(List<CommonLimitData>))]
  148. [ServiceKnownType(typeof(TransporterData))]
  149. [ServiceKnownType(typeof(SrdCommonData))]
  150. [ServiceKnownType(typeof(SRDPersistentValue))]
  151. [ServiceKnownType(typeof(PrewetPumpData))]
  152. [ServiceKnownType(typeof(VpwMainCommonData))]
  153. [ServiceKnownType(typeof(VpwCellCommonData))]
  154. [ServiceKnownType(typeof(VpwMainPersistentValue))]
  155. [ServiceKnownType(typeof(PrewetPersistentValue))]
  156. [ServiceKnownType(typeof(SafetyData))]
  157. [ServiceKnownType(typeof(RinseData))]
  158. [ServiceKnownType(typeof(RinsePersistentValue))]
  159. [ServiceKnownType(typeof(ReservoirsPersistentValue))]
  160. [ServiceKnownType(typeof(DryerCommonData))]
  161. [ServiceKnownType(typeof(CommonLimitData))]
  162. [ServiceKnownType(typeof(RinseItem))]
  163. [ServiceKnownType(typeof(LinMotDeviceData))]
  164. [ServiceKnownType(typeof(StandardHotReservoirData))]
  165. [ServiceKnownType(typeof(CompactMembranReservoirData))]
  166. [ServiceKnownType(typeof(StandardHotMetalDeviceData))]
  167. [ServiceKnownType(typeof(CompactMembranMetalDeviceData))]
  168. [ServiceKnownType(typeof(StandardHotMetalDeviceData))]
  169. [ServiceKnownType(typeof(MetalPersistentValue))]
  170. [ServiceKnownType(typeof(TCPersistentValue))]
  171. [ServiceKnownType(typeof(ReplenData[]))]
  172. [ServiceKnownType(typeof(List<ModuleMaterial>))]
  173. [ServiceKnownType(typeof(MetalUsage))]
  174. [ServiceKnownType(typeof(ReservoirUsage))]
  175. [ServiceKnownType(typeof(Dictionary<string, ReplenPersistentValue>))]
  176. [ServiceKnownType(typeof(List<AlarmList>))]
  177. [ServiceKnownType(typeof(ObservableCollection<SignalTowerItem>))]
  178. public interface IQueryDataService
  179. {
  180. [OperationContract]
  181. object GetData(string key);
  182. [OperationContract]
  183. Dictionary<string, object> PollData(IEnumerable<string> keys);
  184. [OperationContract]
  185. Dictionary<string, object> PollConfig(IEnumerable<string> keys);
  186. [OperationContract]
  187. object GetConfig(string key);
  188. [OperationContract]
  189. List<NotifiableIoItem> GetDiList(string key);
  190. [OperationContract]
  191. List<NotifiableIoItem> GetDoList(string key);
  192. [OperationContract]
  193. List<NotifiableIoItem> GetAiList(string key);
  194. [OperationContract]
  195. List<NotifiableIoItem> GetAoList(string key);
  196. [OperationContract]
  197. string GetConfigFileContent();
  198. [OperationContract]
  199. List<EventItem> QueryDBEvent(string sql);
  200. [OperationContract]
  201. List<HistoryCarrierData> QueryDBCarrier(string sql);
  202. [OperationContract]
  203. List<HistoryProcessData> QueryDBProcess(string sql);
  204. [OperationContract]
  205. List<HistoryWaferData> QueryDBWafer(string sql);
  206. [OperationContract]
  207. List<HistoryMoveData> QueryDBMovement(string sql);
  208. [OperationContract]
  209. List<HistoryJobMoveData> QueryDBJobMovementByJobGuid(string jobGuid);
  210. [OperationContract]
  211. List<HistoryJobMoveData> QueryDBJobMovementByJobGuidAndStationName(string jobGuid,string stationName);
  212. [OperationContract]
  213. List<HistoryDataItem> GetHistoryData(IEnumerable<string> keys, string recipeRunGuid, string module);
  214. [OperationContract]
  215. List<HistoryDataItem> GetOneDayHistoryData(IEnumerable<string> keys,DateTime begin,string module);
  216. [OperationContract]
  217. List<HistoryDataItem> GetHistoryDataFromStartToEnd(IEnumerable<string> keys, DateTime begin,DateTime end, string module);
  218. [OperationContract]
  219. DataTable QueryData(string sql);
  220. [OperationContract]
  221. List<LeakCheckResultItem> GetHistoryLeakCheck(string Module);
  222. [OperationContract]
  223. List<PMLeakCheckResult> GetPMLeakCheckResult(string moduleName);
  224. [OperationContract]
  225. List<MFCVerificationData> GetMFCVerificationData(DateTime begin, DateTime end);
  226. [OperationContract]
  227. List<MFCVerificationOnePointData> GetMFCVerificationOnePointData();
  228. [OperationContract]
  229. List<MFCVerificationTenPointsData> GetMFCVerificationTenPointsData();
  230. [OperationContract]
  231. List<HistoryStepItem> GetHistorySteps(DateTime begin, DateTime end);
  232. [OperationContract]
  233. List<OffsetItem> QueryOffsetDataByTime(string moduleName, DateTime from_time, DateTime to_time);
  234. [OperationContract]
  235. string GetTypedConfigContent(string type, string contentPath);
  236. [OperationContract]
  237. void SetTypedConfigContent(string type, string contentPath, string content);
  238. [OperationContract]
  239. List<UserItem> QueryAllUsers();
  240. [OperationContract]
  241. void InserUser(UserItem userItem);
  242. [OperationContract]
  243. void DeleteUser(string userName);
  244. [OperationContract]
  245. void EditUser(UserItem userName);
  246. }
  247. }