using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Text;

using?PISDK;
using?PITimeServer;
using?PISDKCommon;
using?PISDKDlg;

namespace?PiUtinity
{
????///?

????///?PI操作類
????///?

????public?class?PiHelper
????{
????????Server?server?=?null;
????????PISDK.PISDK?pisdk?=?null;
????????string?uid?=?null;
????????string?pwd?=?null;
????????int?piPort?=?5450;
????????string?hostName?=?null;
????????string?piConnectionString?=?““;
????????///?

????????///?PiHelper構造函數
????????///?

????????///?pi服務器名
????????///?登錄服務器的用戶id
????????///?登錄密碼
????????///?pi服務器端口
????????public?PiHelper（string?hostName?string?uid?string?pwd?int?piPort）
????????{
????????????this.hostName?=?hostName;
????????????this.uid?=?uid;
????????????this.pwd?=?pwd;
????????????this.piPort?=?piPort;
????????????piConnectionString?=?string.Format（“UID={0};PWD={1};port={2};Host={3};“??uid?pwd?piPorthostName）;
????????????try
????????????{
????????????????pisdk?=?new?PISDK.PISDKClass（）;
????????????????foreach?（Server?server?in?pisdk.Servers）
????????????????{
????????????????????if?（server.Name.Equals（hostName））
????????????????????{
????????????????????????this.server?=?server;
????????????????????}
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?new?Exception（“初始化PIServer發生錯誤:“?+?ex.Message）;
????????????}
????????}
????????~PiHelper（）
????????{
????????????if?（this.server?!=?null）
????????????{
????????????????this.server.Close（）;
????????????}
????????}

????????protected?void?Dispose（bool?disposing）
????????{
????????????//釋放非托管資源
????????????if?（this.server?!=?null）
????????????{
????????????????System.Runtime.InteropServices.Marshal.ReleaseComobject（this.server）;
????????????}
????????????if?（this.pisdk?!=?null）
????????????{
????????????????System.Runtime.InteropServices.Marshal.ReleaseComobject（this.pisdk）;
????????????}
????????????GC.Collect（）;
????????}

????????public?void?Dispose（）
????????{
????????????this.Dispose（true）;
????????????GC.ReRegisterForFinalize（this）;
????????}
????????///?

????????///?從Pi數據庫獲取歷史數據
????????///?

????????///?查詢條件，例如：tag=‘MM-001-1-S1-0300-S-1000672-022-001‘
????????///?起始時間
????????///?結束是假你
????????///?查詢方式，年，月，日
????????///?過濾條件，如果不需要過濾，請傳空
????????///?顯示方式
????????///?
????????public?virtual?DataTable?GetHistoryDataFromPI（string?tagName?DateTime?startTime?DateTime?endTime?string?filter?FilteredViewConstants?fvc?Querystyle?qs）
????????{
????????????if?（this.server?==?null）
????????????{
????????????????t

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????238592??2013-05-02?18:21??PiUtinity\bin\Debug\Interop.PISDK.dll

?????文件??????21504??2013-05-02?18:21??PiUtinity\bin\Debug\Interop.PISDKCommon.dll

?????文件??????12288??2013-05-02?18:21??PiUtinity\bin\Debug\Interop.PISDKDlg.dll

?????文件??????22016??2013-05-02?18:21??PiUtinity\bin\Debug\Interop.PITimeServer.dll

?????文件??????11776??2013-05-02?18:21??PiUtinity\bin\Debug\PiUtinity.dll

?????文件??????19968??2013-05-02?18:21??PiUtinity\bin\Debug\PiUtinity.pdb

?????文件???????6190??2013-05-02?18:21??PiUtinity\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件?????238592??2013-05-02?18:21??PiUtinity\obj\Debug\Interop.PISDK.dll

?????文件??????21504??2013-05-02?18:21??PiUtinity\obj\Debug\Interop.PISDKCommon.dll

?????文件??????12288??2013-05-02?18:21??PiUtinity\obj\Debug\Interop.PISDKDlg.dll

?????文件??????22016??2013-05-02?18:21??PiUtinity\obj\Debug\Interop.PITimeServer.dll

?????文件???????1650??2013-05-02?18:21??PiUtinity\obj\Debug\PiUtinity.csproj.FileListAbsolute.txt

?????文件????????904??2013-05-02?18:21??PiUtinity\obj\Debug\PiUtinity.csproj.ResolveComReference.cache

?????文件??????11776??2013-05-02?18:21??PiUtinity\obj\Debug\PiUtinity.dll

?????文件??????19968??2013-05-02?18:21??PiUtinity\obj\Debug\PiUtinity.pdb

?????文件??????14554??2013-05-02?18:21??PiUtinity\PiHelper.cs

?????文件???????3823??2013-04-24?22:24??PiUtinity\PiUtinity.csproj

?????文件???????1374??2013-04-24?21:51??PiUtinity\Properties\AssemblyInfo.cs

?????文件????????536??2013-04-25?15:52??PiUtinity\QueryStlye.cs

?????目錄??????????0??2013-04-24?21:51??PiUtinity\obj\Debug\TempPE

?????目錄??????????0??2013-05-02?18:21??PiUtinity\bin\Debug

?????目錄??????????0??2013-05-02?18:21??PiUtinity\obj\Debug

?????目錄??????????0??2013-04-24?21:51??PiUtinity\bin

?????目錄??????????0??2013-04-24?22:20??PiUtinity\lib

?????目錄??????????0??2013-04-24?21:51??PiUtinity\obj

?????目錄??????????0??2013-04-24?21:51??PiUtinity\Properties

?????目錄??????????0??2013-04-24?22:20??PiUtinity

-----------?---------??----------?-----??----

???????????????681319????????????????????27



............此處省略0個文件信息