using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Data;
using?IWCFCommunicate;

namespace?DataAcess
{
????public??class?DataServerCommuication
????{
????????///?

????????///?查詢數據
????????///?

????????///?sql語句
????????///?返回的表數據
????????///?
????????///?返回值，0成功-1失敗
????????private?int?GetData（string?sql?out?DataTable?dt?out?string?errorMessage）
????????{
????????????var?r?=?0;
????????????dt?=?null;
????????????try
????????????{
????????????????var?m_info?=?（ICommunicateService）RemotingOpen.GetRemote（typeof（ICommunicateService）?“DataAcess“）;
????????????????var?ds?=?new?DataSet（）;
????????????????errorMessage?=?string.Empty;
????????????????r?=?m_info.GetData（1?sql?out?ds?out?errorMessage）;
????????????????dt?=?ds.Tables[0];
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????errorMessage?=?ex.Message;
????????????????r?=?-1;
????????????}
????????????return?r;
????????}
????????///?

????????///?執行sql
????????///?

????????///?sql語句
????????///?錯誤信息
????????///?0成功-1失敗
????????private?int?ExceSql（string?sql?out?string?errorMessage）
????????{
????????????var?m_info?=?（ICommunicateService）RemotingOpen.GetRemote（typeof（ICommunicateService）?“DataAcess“）;
????????????errorMessage?=?string.Empty;
????????????var?r?=???m_info.ExcuteSql（1?sql?out?errorMessage）;

????????????return?r;
????????}
????????public?int?Test（string?strsqlout?DataTable?dt?out?string?errorMessage）
????????{
????????????//var?strsql?=?“select?*?from?test“;
????????????dt?=?new?DataTable（）;

????????????var?r?=?GetData（strsql?out?dt?out?errorMessage）;
????????????return?r;
????????}
????????public?int??GetStoreData（out?DataTable?dt?out?string?errorMessage）
????????{
????????????var?strsql?=??Readxml.GetSql（“倉庫管理“）;
????????????dt?=?new?DataTable（）;

????????????var?r?=?GetData（strsql?out?dt?out?errorMessage）;
????????????return?r;
????????}
??????
????????#region?重用
????????///?

????????///?用戶查詢
????????///?

????????///?
????????///?
????????///?
????????public?int?GetUser（out?DataTable?dt?out?string?errorMessage）
????????{
????????????var?strsql?=?Readxml.GetSql（“查詢用戶“）;
????????????dt?=?new?DataTable（）;

????????????var?r?=?GetData（strsql?out?dt?out?errorMessage）;
????????????return?r;
????????}
????????public?int?GetRole（out?DataTable?dt?out?string?errorMessage）
????????{
????????????var?strsql?=?Readxml.GetSql（“查詢角色“）;
????????????dt?=?new?DataTable（）;

????????????var?r?=?GetData（strsql?out?dt?out?errorMessage）;
????????????return?r;
????????}
????????public?int?GetRoleType（out?DataTable?dt?out?str

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\
?????文件?????????144??2013-11-02?12:44??WindowsFormsApplication1\DataAcess\App.config
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\bin\
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\bin\Debug\
?????文件????????5120??2013-09-01?20:37??WindowsFormsApplication1\DataAcess\bin\Debug\DataAcess.dll
?????文件???????13824??2013-09-01?20:37??WindowsFormsApplication1\DataAcess\bin\Debug\DataAcess.pdb
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\bin\Release\
?????文件???????11264??2013-11-07?23:06??WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.dll
?????文件?????????144??2013-11-02?12:44??WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.dll.config
?????文件???????24064??2013-11-07?23:06??WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.pdb
?????文件????????9216??2013-11-02?12:50??WindowsFormsApplication1\DataAcess\bin\Release\IWCFCommunicate.dll
?????文件???????11776??2013-09-19?10:37??WindowsFormsApplication1\DataAcess\bin\Release\IWCFCommunicate.pdb
?????文件????????4096??2013-11-02?12:50??WindowsFormsApplication1\DataAcess\bin\Release\PublicStruct.dll
?????文件????????7680??2013-09-19?10:37??WindowsFormsApplication1\DataAcess\bin\Release\PublicStruct.pdb
?????文件????????3609??2013-11-07?00:39??WindowsFormsApplication1\DataAcess\bin\Release\Query.xml
?????文件?????????131??2013-09-01?20:29??WindowsFormsApplication1\DataAcess\bin\Release\ServerConstring.xml
?????文件????????3264??2014-01-12?23:13??WindowsFormsApplication1\DataAcess\DataAcess.csproj
?????文件???????63091??2014-02-14?17:44??WindowsFormsApplication1\DataAcess\DataServer.cs
?????文件????????5468??2014-01-12?23:24??WindowsFormsApplication1\DataAcess\Deciphering.cs
?????文件????????6223??2014-01-17?23:58??WindowsFormsApplication1\DataAcess\Encrypt.cs
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\obj\
?????目錄???????????0??2014-02-14?22:57??WindowsFormsApplication1\DataAcess\obj\Debug\
?????文件?????????597??2014-02-14?17:20??WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.csproj.FileListAbsolute.txt
?????文件????????9382??2014-02-14?00:33??WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.csprojResolveAssemblyReference.cache
?????文件???????32256??2014-02-14?17:45??WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.dll
?????文件???????81408??2014-02-14?17:45??WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.pdb
?????文件????????6607??2014-02-14?22:58??WindowsFormsApplication1\DataAcess\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????????0??2013-09-01?18:31??WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2013-09-01?18:31??WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2013-09-01?18:31??WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
............此處省略92個文件信息