public bool AddCommonType(string fid, string code, string name)
{
using (SGDatabase_HClient client = WcfClientFactory.CreateSGDatabase_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.AddCommonType(validationTicket, fid, code, name));
}
}
public bool IsExistsCommonType(string code)
{
using (SGDatabase_HClient client = WcfClientFactory.CreateSGDatabase_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.IsExistsCommonType(validationTicket, code));
}
}
public bool DeleteItemDesc(string fid)
{
using (SGDatabase_WClient client = SoapClientFactory.CreateSGDatabase_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.DeleteItemDesc(validationTicket, fid));
}
}
public bool DeleteCommonType(string code)
{
using (SGDatabase_WClient client = SoapClientFactory.CreateSGDatabase_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.DeleteCommonType(validationTicket, code));
}
}
public bool TestConnection(string dbType, string Server, string database, string user, string password)
{
using (CommonService_HClient client = WcfClientFactory.CreateCommonService_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.TestConnectionD(validationTicket, dbType, Server, database, user, password));
}
}
public bool ModifyPwdDirect(string account, string pwd, string DBName)
{
using (SystemSecurityServiceClient client = SoapClientFactory.CreateSecurityClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.U_ModifyPwdDirect(validationTicket, account, pwd, DBName));
}
}
public bool TestConnection()
{
using (CommonService_HClient client = WcfClientFactory.CreateCommonService_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.TestConnection(validationTicket));
}
}
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 bool IsExistsItemClass(string FNumber)
{
using (SGDatabase_HClient client = WcfClientFactory.CreateSGDatabase_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.IsExistsItemClass(validationTicket, FNumber));
}
}
public bool SetOrder(string Upfid, string Downfid)
{
using (SGDatabase_HClient client = WcfClientFactory.CreateSGDatabase_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(client.SetOrder(validationTicket, Upfid, Downfid));
}
}
public System.Data.DataTable SearchBy(string dataType)
{
using (SGDatabase_WClient client = SoapClientFactory.CreateSGDatabase_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.SearchCommonType(validationTicket, dataType);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public System.Data.DataSet GetItemDesc(string FNumber)
{
using (SGDatabase_WClient client = SoapClientFactory.CreateSGDatabase_WClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.GetItemDesc(validationTicket, FNumber);
return(ZipTools.DecompressionDataSet(receivedData));
}
}
public System.Data.DataTable GetItemClass(string FNumber)
{
using (SGDatabase_HClient client = WcfClientFactory.CreateSGDatabase_HClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.GetItemClass(validationTicket, FNumber);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public DataTable GetUserDirect(string account, string DBName)
{
using (SystemSecurityServiceClient client = SoapClientFactory.CreateSecurityClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.U_GetUserDirect(validationTicket, account, DBName);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public System.Data.DataTable GetSystemDataSet()
{
using (CommonServiceClient client = SoapClientFactory.CreateCommonServiceClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] receivedData = client.GetSystemDataSet(validationTicket);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
public DataTable Login(LoginUser loginUser, char LoginUserType)
{
using (SystemSecurityServiceClient client = SoapClientFactory.CreateSecurityClient())
{
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
byte[] bsLoginUser = ZipTools.CompressionObject(loginUser);
byte[] receivedData = client.U_Login(validationTicket, bsLoginUser, LoginUserType);
DataSet ds = ZipTools.DecompressionDataSet(receivedData);
return(ds.Tables[0]);
}
}
public DataTable LoginByCard(LoginUser loginUser, char LoginUserType)
{
using (SGBaseUser_HClient client = WcfClientFactory.CreateSGBaseUser_HClient())
{
byte[] loginTicket = WebServiceSecurity.GetLoginTicket();
byte[] login = ZipTools.CompressionObject(loginUser);
byte[] receivedData = client.U_LoginByCard(loginTicket, login, LoginUserType);
return(ZipTools.DecompressionDataSet(receivedData).Tables[0]);
}
}
/// <summary>
/// 测试WebService连接
/// </summary>
/// <returns></returns>
private static bool TestWebServiceConnection()
{
try
{
CommonServiceClient commonService = SoapClientFactory.CreateCommonServiceClient();
byte[] validationTicket = WebServiceSecurity.GetLoginTicket();
return(commonService.TestConnection(validationTicket));
}
catch (Exception ex)
{
Msg.ShowException(ex);
return(false);
}
}
