IQueryDataService.cs 7.1 KB

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