PunkHPX8/Framework/Common/DataCenter/IQueryDataService.cs

using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.ServiceModel;
using Aitex.Core.Common;
using Aitex.Core.Common.DeviceData;
using Aitex.Core.RT.Event;
using Aitex.Core.UI.ControlDataContext;
using Aitex.Core.Util;
using Aitex.Sorter.Common;
using MECF.Framework.Common.Beckhoff.AxisProvider;
using MECF.Framework.Common.Beckhoff.IOAxis;
using MECF.Framework.Common.Beckhoff.Station;
using MECF.Framework.Common.CommonData;
using MECF.Framework.Common.CommonData.DeviceData;
using MECF.Framework.Common.CommonData.Dryer;
using MECF.Framework.Common.CommonData.Loader;
using MECF.Framework.Common.CommonData.Metal;
using MECF.Framework.Common.CommonData.PowerSupplier;
using MECF.Framework.Common.CommonData.Prewet;
using MECF.Framework.Common.CommonData.PUF;
using MECF.Framework.Common.CommonData.Reservoir;
using MECF.Framework.Common.CommonData.SRD;
using MECF.Framework.Common.CommonData.TemperatureControl;
using MECF.Framework.Common.CommonData.Transporter;
using MECF.Framework.Common.ControlDataContext;
using MECF.Framework.Common.DBCore;
using MECF.Framework.Common.Device.LinMot;
using MECF.Framework.Common.Device.PowerSupplier;
using MECF.Framework.Common.Device.ResistivityProbe;
using MECF.Framework.Common.Device.Rinse;
using MECF.Framework.Common.Device.Safety;
using MECF.Framework.Common.Device.TemperatureController;
using MECF.Framework.Common.Equipment;
using MECF.Framework.Common.IOCore;
using MECF.Framework.Common.Jobs;
using MECF.Framework.Common.Layout;
using MECF.Framework.Common.Persistent.Prewet;
using MECF.Framework.Common.Persistent.Reservoirs;
using MECF.Framework.Common.Persistent.Rinse;
using MECF.Framework.Common.Persistent.SRD;
using MECF.Framework.Common.Persistent.Temperature;
using MECF.Framework.Common.Schedulers;
using MECF.Framework.Common.SubstrateTrackings;
using MECF.Framework.Common.ToolLayout;
using PunkHPX8_Core;
using VenusCommon;
using MECF.Framework.Common.RecipeCenter;
using MECF.Framework.Common.ProcessCell;
using MECF.Framework.Common.CommonData.Vpw;

namespace MECF.Framework.Common.DataCenter
{

	[ServiceContract]
    [ServiceKnownType(typeof(SignalTowerDataItem))]
    [ServiceKnownType(typeof(ControlJobInfo))]
    [ServiceKnownType(typeof(GateValveDataItem))]
	[ServiceKnownType(typeof(List<EventItem>))]
	[ServiceKnownType(typeof(List<HistoryCarrierData>))]
	[ServiceKnownType(typeof(List<HistoryProcessData>))]
	[ServiceKnownType(typeof(List<HistoryWaferData>))]
	[ServiceKnownType(typeof(List<HistoryMoveData>))]
	[ServiceKnownType(typeof(List<LeakCheckResultItem>))]

    [ServiceKnownType(typeof(List<NotifiableIoItem>))]
    [ServiceKnownType(typeof(NotifiableIoItem))]

    [ServiceKnownType(typeof(AITValveData))]
	[ServiceKnownType(typeof(AITMfcData))]
	[ServiceKnownType(typeof(AITHeaterData))]
	[ServiceKnownType(typeof(AITChillerData))]
    [ServiceKnownType(typeof(AITThermalCoupleData))]
	[ServiceKnownType(typeof(AITWaterFlowMeterData))]
	[ServiceKnownType(typeof(AITPressureMeterData))]
	[ServiceKnownType(typeof(AITRfData))]
	[ServiceKnownType(typeof(AITThrottleValveData))]
	[ServiceKnownType(typeof(AITSensorData))]
	[ServiceKnownType(typeof(AITPumpData))]
	[ServiceKnownType(typeof(AITSignalTowerData))]
	[ServiceKnownType(typeof(AITEmoData))]
	[ServiceKnownType(typeof(AITStatisticsData))]
	[ServiceKnownType(typeof(AITBoostPumpData))]
	[ServiceKnownType(typeof(AITCylinderData))]
	[ServiceKnownType(typeof(AITWaterFlowSensorData))]
	[ServiceKnownType(typeof(AITServoMotorData))]
	[ServiceKnownType(typeof(AITLidData))]
	[ServiceKnownType(typeof(ServoState))]

	[ServiceKnownType(typeof(AITRfPowerData))]
	[ServiceKnownType(typeof(AITRfMatchData))]

    [ServiceKnownType(typeof(AITHVData))]


    [ServiceKnownType(typeof(FlowMeterAlarmItem))]


    [ServiceKnownType(typeof(WaferInfo))]
	[ServiceKnownType(typeof(WaferInfo[]))]
	[ServiceKnownType(typeof(CarrierInfo))]
	[ServiceKnownType(typeof(CarrierInfo[]))]

    

    [ServiceKnownType(typeof(NotifiableIoItem))]

    [ServiceKnownType(typeof(IndicatorState))]
    [ServiceKnownType(typeof(FoupClampState))]
    [ServiceKnownType(typeof(FoupDoorState))]
    [ServiceKnownType(typeof(LoadportCassetteState))]

    [ServiceKnownType(typeof(AITRfidReaderData))]
	[ServiceKnownType(typeof(AITAlignerData))]
	[ServiceKnownType(typeof(AITWaferIdReaderData))]
    [ServiceKnownType(typeof(AITHighTemperatureHeaterData))]
    [ServiceKnownType(typeof(ResRecipe))]
    [ServiceKnownType(typeof(DepRecipe))]
    [ServiceKnownType(typeof(PwtRecipe))]
    [ServiceKnownType(typeof(HvdRecipe))]
    [ServiceKnownType(typeof(SrdRecipe))]
    [ServiceKnownType(typeof(QdrRecipe))]
    [ServiceKnownType(typeof(ModuleName))]
    [ServiceKnownType(typeof(LidState))]
    [ServiceKnownType(typeof(DeviceState))]

    [ServiceKnownType(typeof(SorterRecipeXml))]
    [ServiceKnownType(typeof(SorterRecipeType))]
    [ServiceKnownType(typeof(SorterRecipePlaceModeOrder))]
    [ServiceKnownType(typeof(SorterRecipePlaceModeTransfer1To1))]
    [ServiceKnownType(typeof(SorterRecipePlaceModePack))]
    [ServiceKnownType(typeof(ObservableCollection<SorterRecipeTransferTableItem>))]
    [ServiceKnownType(typeof(SorterRecipeTransferTableItem))]
    [ServiceKnownType(typeof(SlotTransferInfo))]
    [ServiceKnownType(typeof(SlotTransferInfo[]))]

	[ServiceKnownType(typeof(List<string>))]
	[ServiceKnownType(typeof(SerializableDictionary<string, bool>))]
	[ServiceKnownType(typeof(SerializableDictionary<string, string>))]
    [ServiceKnownType(typeof(ConcurrentDictionary<string, bool>))]
    [ServiceKnownType(typeof(SerializableDictionary<string, List<string>>))]
    [ServiceKnownType(typeof(MoveItem))]
	[ServiceKnownType(typeof(RobotMoveInfo))]
    [ServiceKnownType(typeof(RecipeResult))]
    [ServiceKnownType(typeof(AITPendulumValveData))]
    [ServiceKnownType(typeof(ObservableCollection<MFCCalibrationData>))]
    [ServiceKnownType(typeof(List<PMLeakCheckResult>))]
    [ServiceKnownType(typeof(BeckhoffStationAxis))]
	[ServiceKnownType(typeof(BeckhoffAxis))]
	[ServiceKnownType(typeof(BeckhoffProviderAxis))]
	[ServiceKnownType(typeof(LinmotDeviceConfig))]
	[ServiceKnownType(typeof(CommandMotionData))]
	[ServiceKnownType(typeof(PowerSupplierData))]
	[ServiceKnownType(typeof(ThorntonDeviceConfig))]
	[ServiceKnownType(typeof(TemperatureDeviceConfig))]
	[ServiceKnownType(typeof(TemperatureControllerData))]
	[ServiceKnownType(typeof(LoaderSideData))]
    [ServiceKnownType(typeof(LoaderCommonData))]
	[ServiceKnownType(typeof(ProcessLayout))]
    [ServiceKnownType(typeof(PowerSupplierDevice))]
	[ServiceKnownType(typeof(List<CommonLimitData>))]
	[ServiceKnownType(typeof(TransporterData))]
	[ServiceKnownType(typeof(SrdCommonData))]
	[ServiceKnownType(typeof(SRDPersistentValue))]
	[ServiceKnownType(typeof(PrewetPumpData))]
    [ServiceKnownType(typeof(VpwMainCommonData))]
    [ServiceKnownType(typeof(VpwCellCommonData))]
    [ServiceKnownType(typeof(PrewetPersistentValue))]
    [ServiceKnownType(typeof(SafetyData))]
    [ServiceKnownType(typeof(RinseData))]
    [ServiceKnownType(typeof(RinsePersistentValue))]
    [ServiceKnownType(typeof(ReservoirsPersistentValue))]
    [ServiceKnownType(typeof(DryerCommonData))]
    [ServiceKnownType(typeof(CommonLimitData))]
    [ServiceKnownType(typeof(RinseItem))]
    [ServiceKnownType(typeof(LinMotDeviceData))]
	[ServiceKnownType(typeof(StandardHotReservoirData))]
    [ServiceKnownType(typeof(CompactMembranReservoirData))]
    [ServiceKnownType(typeof(StandardHotMetalDeviceData))]
    [ServiceKnownType(typeof(CompactMembranMetalDeviceData))]
    [ServiceKnownType(typeof(StandardHotMetalDeviceData))]
    [ServiceKnownType(typeof(MetalPersistentValue))] 
    [ServiceKnownType(typeof(TCPersistentValue))]
    [ServiceKnownType(typeof(ReplenData[]))]
    [ServiceKnownType(typeof(List<ModuleMaterial>))]
    [ServiceKnownType(typeof(MetalUsage))]
    [ServiceKnownType(typeof(ReservoirUsage))]
    [ServiceKnownType(typeof(Dictionary<string, ReplenPersistentValue>))]
    [ServiceKnownType(typeof(List<AlarmList>))]
    [ServiceKnownType(typeof(ObservableCollection<SignalTowerItem>))]
    public interface IQueryDataService
	{
		[OperationContract]
		object GetData(string key);

		[OperationContract]
		Dictionary<string, object> PollData(IEnumerable<string> keys);

	    [OperationContract]
	    Dictionary<string, object> PollConfig(IEnumerable<string> keys);

        [OperationContract]
		object GetConfig(string key);
        [OperationContract]
        List<NotifiableIoItem> GetDiList(string key);
        [OperationContract]
        List<NotifiableIoItem> GetDoList(string key);
        [OperationContract]
        List<NotifiableIoItem> GetAiList(string key);
        [OperationContract]
        List<NotifiableIoItem> GetAoList(string key);

        [OperationContract]
	    string GetConfigFileContent();

        [OperationContract]
		List<EventItem> QueryDBEvent(string sql);

	    [OperationContract]
	    List<HistoryCarrierData> QueryDBCarrier(string sql);

	    [OperationContract]
	    List<HistoryProcessData> QueryDBProcess(string sql);

	    [OperationContract]
	    List<HistoryWaferData> QueryDBWafer(string sql);

	    [OperationContract]
	    List<HistoryMoveData> QueryDBMovement(string sql);

	    [OperationContract]
	    List<HistoryJobMoveData> QueryDBJobMovementByJobGuid(string jobGuid);

	    [OperationContract]
	    List<HistoryJobMoveData> QueryDBJobMovementByJobGuidAndStationName(string jobGuid,string stationName);
		

		[OperationContract]
	    List<HistoryDataItem> GetHistoryData(IEnumerable<string> keys, string recipeRunGuid, string module);

	    [OperationContract]
	    List<HistoryDataItem> GetOneDayHistoryData(IEnumerable<string> keys,DateTime begin,string module);

	    [OperationContract]
	    List<HistoryDataItem> GetHistoryDataFromStartToEnd(IEnumerable<string> keys, DateTime begin,DateTime end, string module);

		[OperationContract]
	    DataTable QueryData(string sql);

        [OperationContract]
        List<LeakCheckResultItem> GetHistoryLeakCheck(string Module);
		[OperationContract]

		List<PMLeakCheckResult> GetPMLeakCheckResult(string moduleName);

        [OperationContract]

        List<MFCVerificationData> GetMFCVerificationData(DateTime begin, DateTime end);
        [OperationContract]

        List<MFCVerificationOnePointData> GetMFCVerificationOnePointData();
        [OperationContract]

        List<MFCVerificationTenPointsData> GetMFCVerificationTenPointsData();

        [OperationContract]

        List<HistoryStepItem> GetHistorySteps(DateTime begin, DateTime end);
        
		[OperationContract]
        List<OffsetItem> QueryOffsetDataByTime(string moduleName, DateTime from_time, DateTime to_time);
        [OperationContract]
        string GetTypedConfigContent(string type, string contentPath);

        [OperationContract]
        void SetTypedConfigContent(string type, string contentPath, string content);

        [OperationContract]
        List<UserItem> QueryAllUsers();

        [OperationContract]
        void InserUser(UserItem userItem);

        [OperationContract]
        void DeleteUser(string userName);

        [OperationContract]
        void EditUser(UserItem userName);

    }
}