IQueryDataService.cs 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Collections.ObjectModel;
  4. using System.Data;
  5. using System.ServiceModel;
  6. using Aitex.Core.Common;
  7. using Aitex.Core.Common.DeviceData;
  8. using Aitex.Core.RT.Event;
  9. using Aitex.Core.RT.IOCore;
  10. using Aitex.Core.UI.ControlDataContext;
  11. using Aitex.Core.Util;
  12. using Aitex.Sorter.Common;
  13. using MECF.Framework.Common.CommonData;
  14. using MECF.Framework.Common.CommonData.DeviceData;
  15. using MECF.Framework.Common.ControlDataContext;
  16. using MECF.Framework.Common.DBCore;
  17. using MECF.Framework.Common.Equipment;
  18. using MECF.Framework.Common.IOCore;
  19. using MECF.Framework.Common.Schedulers;
  20. using MECF.Framework.Common.SubstrateTrackings;
  21. using Venus_Core;
  22. using VenusCommon;
  23. namespace MECF.Framework.Common.DataCenter
  24. {
  25. [ServiceContract]
  26. [ServiceKnownType(typeof(SignalTowerDataItem))]
  27. [ServiceKnownType(typeof(GateValveDataItem))]
  28. [ServiceKnownType(typeof(List<EventItem>))]
  29. [ServiceKnownType(typeof(List<HistoryCarrierData>))]
  30. [ServiceKnownType(typeof(List<HistoryProcessData>))]
  31. [ServiceKnownType(typeof(List<HistoryWaferData>))]
  32. [ServiceKnownType(typeof(List<HistoryMoveData>))]
  33. [ServiceKnownType(typeof(List<LeakCheckResultItem>))]
  34. [ServiceKnownType(typeof(List<NotifiableIoItem>))]
  35. [ServiceKnownType(typeof(NotifiableIoItem))]
  36. [ServiceKnownType(typeof(AITValveData))]
  37. [ServiceKnownType(typeof(AITMfcData))]
  38. [ServiceKnownType(typeof(AITHeaterData))]
  39. [ServiceKnownType(typeof(AITChillerData))]
  40. [ServiceKnownType(typeof(AITThermalCoupleData))]
  41. [ServiceKnownType(typeof(AITWaterFlowMeterData))]
  42. [ServiceKnownType(typeof(AITPressureMeterData))]
  43. [ServiceKnownType(typeof(AITRfData))]
  44. [ServiceKnownType(typeof(AITThrottleValveData))]
  45. [ServiceKnownType(typeof(AITSensorData))]
  46. [ServiceKnownType(typeof(AITPumpData))]
  47. [ServiceKnownType(typeof(AITSignalTowerData))]
  48. [ServiceKnownType(typeof(AITEmoData))]
  49. [ServiceKnownType(typeof(AITStatisticsData))]
  50. [ServiceKnownType(typeof(AITBoostPumpData))]
  51. [ServiceKnownType(typeof(AITCylinderData))]
  52. [ServiceKnownType(typeof(AITWaterFlowSensorData))]
  53. [ServiceKnownType(typeof(AITServoMotorData))]
  54. [ServiceKnownType(typeof(AITLidData))]
  55. [ServiceKnownType(typeof(ServoState))]
  56. [ServiceKnownType(typeof(AITRfPowerData))]
  57. [ServiceKnownType(typeof(AITRfMatchData))]
  58. [ServiceKnownType(typeof(AITHVData))]
  59. [ServiceKnownType(typeof(FlowMeterAlarmItem))]
  60. [ServiceKnownType(typeof(WaferInfo))]
  61. [ServiceKnownType(typeof(WaferInfo[]))]
  62. [ServiceKnownType(typeof(CarrierInfo))]
  63. [ServiceKnownType(typeof(CarrierInfo[]))]
  64. [ServiceKnownType(typeof(NotifiableIoItem))]
  65. [ServiceKnownType(typeof(IndicatorState))]
  66. [ServiceKnownType(typeof(FoupClampState))]
  67. [ServiceKnownType(typeof(FoupDoorState))]
  68. [ServiceKnownType(typeof(LoadportCassetteState))]
  69. [ServiceKnownType(typeof(AITRfidReaderData))]
  70. [ServiceKnownType(typeof(AITAlignerData))]
  71. [ServiceKnownType(typeof(AITWaferIdReaderData))]
  72. [ServiceKnownType(typeof(ModuleName))]
  73. [ServiceKnownType(typeof(LidState))]
  74. [ServiceKnownType(typeof(DeviceState))]
  75. [ServiceKnownType(typeof(SorterRecipeXml))]
  76. [ServiceKnownType(typeof(SorterRecipeType))]
  77. [ServiceKnownType(typeof(SorterRecipePlaceModeOrder))]
  78. [ServiceKnownType(typeof(SorterRecipePlaceModeTransfer1To1))]
  79. [ServiceKnownType(typeof(SorterRecipePlaceModePack))]
  80. [ServiceKnownType(typeof(ObservableCollection<SorterRecipeTransferTableItem>))]
  81. [ServiceKnownType(typeof(SorterRecipeTransferTableItem))]
  82. [ServiceKnownType(typeof(SlotTransferInfo))]
  83. [ServiceKnownType(typeof(SlotTransferInfo[]))]
  84. [ServiceKnownType(typeof(List<string>))]
  85. [ServiceKnownType(typeof(SerializableDictionary<string, bool>))]
  86. [ServiceKnownType(typeof(SerializableDictionary<string, string>))]
  87. [ServiceKnownType(typeof(MoveItem))]
  88. [ServiceKnownType(typeof(RobotMoveInfo))]
  89. [ServiceKnownType(typeof(Venus_Core.RecipeResult))]
  90. [ServiceKnownType(typeof(AITPendulumValveData))]
  91. [ServiceKnownType(typeof(PMState))]
  92. [ServiceKnownType(typeof(ObservableCollection<MFCCalibrationData>))]
  93. [ServiceKnownType(typeof(List<PMLeakCheckResult>))]
  94. public interface IQueryDataService
  95. {
  96. [OperationContract]
  97. object GetData(string key);
  98. [OperationContract]
  99. Dictionary<string, object> PollData(IEnumerable<string> keys);
  100. [OperationContract]
  101. Dictionary<string, object> PollConfig(IEnumerable<string> keys);
  102. [OperationContract]
  103. object GetConfig(string key);
  104. [OperationContract]
  105. List<NotifiableIoItem> GetDiList(string key);
  106. [OperationContract]
  107. List<NotifiableIoItem> GetDoList(string key);
  108. [OperationContract]
  109. List<NotifiableIoItem> GetAiList(string key);
  110. [OperationContract]
  111. List<NotifiableIoItem> GetAoList(string key);
  112. [OperationContract]
  113. string GetConfigFileContent();
  114. [OperationContract]
  115. List<EventItem> QueryDBEvent(string sql);
  116. [OperationContract]
  117. List<HistoryCarrierData> QueryDBCarrier(string sql);
  118. [OperationContract]
  119. List<HistoryProcessData> QueryDBProcess(string sql);
  120. [OperationContract]
  121. List<HistoryWaferData> QueryDBWafer(string sql);
  122. [OperationContract]
  123. List<HistoryMoveData> QueryDBMovement(string sql);
  124. [OperationContract]
  125. List<HistoryJobMoveData> QueryDBJobMovementByJobGuid(string jobGuid);
  126. [OperationContract]
  127. List<HistoryJobMoveData> QueryDBJobMovementByJobGuidAndStationName(string jobGuid,string stationName);
  128. [OperationContract]
  129. List<HistoryDataItem> GetHistoryData(IEnumerable<string> keys, string recipeRunGuid, string module);
  130. [OperationContract]
  131. List<HistoryDataItem> GetOneDayHistoryData(IEnumerable<string> keys,DateTime begin,string module);
  132. [OperationContract]
  133. List<HistoryDataItem> GetHistoryDataFromStartToEnd(IEnumerable<string> keys, DateTime begin,DateTime end, string module);
  134. [OperationContract]
  135. DataTable QueryData(string sql);
  136. [OperationContract]
  137. List<LeakCheckResultItem> GetHistoryLeakCheck(string Module);
  138. [OperationContract]
  139. List<PMLeakCheckResult> GetPMLeakCheckResult(string moduleName);
  140. [OperationContract]
  141. List<MFCVerificationData> GetMFCVerificationData(DateTime begin, DateTime end);
  142. [OperationContract]
  143. List<MFCVerificationOnePointData> GetMFCVerificationOnePointData();
  144. [OperationContract]
  145. List<MFCVerificationTenPointsData> GetMFCVerificationTenPointsData();
  146. [OperationContract]
  147. List<HistoryStepItem> GetHistorySteps(DateTime begin, DateTime end);
  148. [OperationContract]
  149. List<OffsetItem> QueryOffsetDataByTime(string moduleName, DateTime from_time, DateTime to_time);
  150. }
  151. }