public string GetSQLServerDbListString(string sServerName, string sUser, string sPwd)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.GetSQLServerDbListString(validationTicket, sServerName, sUser, sPwd));
}
}
public void WriteLogOP(string sFunID, string sFSubunID, string sFdesc, string sSql)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
client.WriteLogOP(loginTicket, sFunID, sFSubunID, sFdesc, sSql);
}
}
public bool TestConnection(string dbType, string Server, string database, string user, string password)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.TestConnectionD(validationTicket, dbType, Server, database, user, password));
}
}
public bool TestConnection()
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.TestConnection(validationTicket));
}
}
public System.Data.DataTable getDataTableSQL(string sql)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.getDataTableSQL(loginTicket, sql);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public string GetTableFieldValue(string sTableName, string sField, string SCon)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
return(client.C_GetTableFieldValue(loginTicket, sTableName, sField, SCon));
}
}
public DataSet SearchLog(string logUser, string tableName, DateTime dateFrom, DateTime dateTo)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.SearchLogData(loginTicket, logUser, tableName, dateFrom, dateTo);
return(ZipTools.DecompressionDataSet(receivedData));
}
}
public string GetSystemProfileVal(string key)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
//byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
return(client.G_GetSystemProfileVal(loginTicket, key));
}
}
public System.Data.DataTable GetAttachFileData(string docID)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.GetAttachedFiles(loginTicket, docID);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public System.Data.DataTable GetSystemDataSetByOrg(string sOrgID)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.GetSystemDataSetByOrg(validationTicket, sOrgID);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public bool SaveFieldDef(DataTable data)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bsData = ZipTools.CompressionDataSet(dalBase.TableToDataSet(data));
return(client.SaveFieldDef(loginTicket, bsData));
}
}
public string[] GetTracedFields(string tableName)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
string[] arr = client.GetTracedFields(loginTicket, tableName);
return(arr);
}
}
public DataTable GetLogFieldDef(string tableName)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.GetLogFieldDef(loginTicket, tableName);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public System.Data.DataSet GetSystemProfile()
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
//byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.G_GetSystemProfile(loginTicket);
return(ZipTools.DecompressionDataSet(receivedData));
}
}
public System.Data.DataTable GetDBLinkByID(string key)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
//byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] receivedData = client.GetDBLinkByID(loginTicket, key);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public void WriteLog(string logID, DataTable originalData, DataTable changes, string tableName, string keyFieldName, bool isMaster)
{
using (CommonService_WClient client = SoapClientFactory.CreateCommonService_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bsOriginal = ZipTools.CompressionDataSet(dalBase.TableToDataSet(originalData));
byte[] bsChanges = ZipTools.CompressionDataSet(dalBase.TableToDataSet(changes));
client.WriteLog(loginTicket, logID, bsOriginal, bsChanges, tableName, keyFieldName, isMaster);
}
}
/// <summary>
/// 测试WebService连接
/// </summary>
/// <returns></returns>
private static bool TestWebServiceConnection()
{
try
{
CommonService_WClient commonService = SoapClientFactory.CreateCommonService_WClient();
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(commonService.TestConnection(validationTicket));
}
catch (Exception ex)
{
Msg.ShowException(ex);
return(false);
}
}
