public byte[] GetBackupHistory(byte[] loginTicket, int topList)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(null).GetBackupHistory(topList);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] G_GetUserGroupByCode(byte[] loginTicket, string groupCode)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet ds = new dalUserGroup(loginer).GetUserGroup(groupCode);
return(ZipTools.CompressionDataSet(ds));
}
public byte[] G_GetFormTagCustomName(byte[] loginTicket)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable dt = new dalUserGroup(loginer).GetFormTagCustomName();
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(dt)));
}
public byte[] AR_GetReportData(byte[] loginTicket, string DocNoFrom, string DocNoTo, DateTime DateFrom, DateTime DateTo)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalAR(loginer).GetReportData(DocNoFrom, DocNoTo, DateFrom, DateTo);
return(ZipTools.CompressionDataSet(data));
}
public byte[] SearchOutstanding(byte[] loginTicket, string invoiceNo, string customer, DateTime dateFrom, DateTime dateTo, DateTime dateEnd, string outstandingType)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).SearchOutstanding(invoiceNo, customer, dateFrom, dateTo, dateEnd, outstandingType);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] PO_GetSummaryByParam(byte[] loginTicket, string docNoFrom, string docNoTo, DateTime docDateFrom, DateTime docDateTo, string StockCode, string Customer)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalPO(loginer).GetSummaryByParam(docNoFrom, docNoTo, docDateFrom, docDateTo, StockCode, Customer);
return(ZipTools.CompressionDataSet(data));
}
public byte[] PO_GetBusinessByKey(byte[] loginTicket, string docNo)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalPO(loginer).GetBusinessByKey(docNo);
return(ZipTools.CompressionDataSet(data));
}
public byte[] IC_GetSummaryByParam(byte[] loginTicket, string DocNoFrom, string DocNoTo, DateTime docDateFrom, DateTime docDateTo)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalIC(loginer).GetSummaryByParam(DocNoFrom, DocNoTo, docDateFrom, docDateTo);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] IC_GetBusinessByKey(byte[] loginTicket, string keyValue)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalIC(loginer).GetBusinessByKey(keyValue);
return(ZipTools.CompressionDataSet(data));
}
public byte[] SearchLog(byte[] loginTicket, string sFilter)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).SearchLog(sFilter); //dalLog.GetLog(loginer, sFilter);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] getDataTableSQL(byte[] loginTicket, string sql)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).getDataTableSQL(sql);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] G_GetSystemProfile(byte[] loginTicket)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalSystemProfile(loginer).GetSystemProfile();
return(ZipTools.CompressionDataSet(data));
}
public byte[] GetDBLinkByID(byte[] loginTicket, string key)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalDbLink(loginer).GetDBLinkByID(key);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] GetLogFieldDef(byte[] loginTicket, string tableName)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalEditLogHistory(loginer).GetLogFieldDef(tableName);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] U_GetUserAuthorities(byte[] loginTicket)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalUser(loginer).GetUserAuthorities(loginer);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] GetModules(byte[] loginTicket)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).GetModules();
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] SearchCommonType(byte[] loginTicket, string dataType)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommonDataDict(loginer).SearchBy(dataType);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] GetItemClass(byte[] loginTicket, string FNumber)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalItemClass(loginer).GetItemClass(FNumber);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] GetItemDesc(byte[] loginTicket, string FNumber)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalItemPropDesc(loginer).GetItemDesc(FNumber);
return(ZipTools.CompressionDataSet(data));
}
public byte[] SearchLog(byte[] loginTicket, string logUser, string tableName, DateTime dateFrom, DateTime dateTo)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet data = new dalEditLogHistory(loginer).SearchLog(logUser, tableName, dateFrom, dateTo);
return(ZipTools.CompressionDataSet(data));
}
public byte[] GetAttachedFiles(byte[] loginTicket, string docID)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalAttachFile(loginer).GetData(docID);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] GetTableFieldsDef(byte[] loginTicket, string tableName, bool onlyDisplayField)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).GetTableFieldsDef(tableName, onlyDisplayField);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public bool Update(System.Data.DataSet ds)
{
using (SystemSecurityServiceClient client = SoapClientFactory.CreateSecurityClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] userData = ZipTools.CompressionDataSet(ds);
return(client.U_UpdateUser(loginTicket, userData));
}
}
public bool Update(System.Data.DataSet data)
{
using (DataDictServiceClient client = SoapClientFactory.CreateDataDictClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bs = ZipTools.CompressionDataSet(data);
return(client.Update(loginTicket, bs, _ORM.FullName));
}
}
public bool SaveFieldDef(DataTable data)
{
using (CommonServiceClient client = SoapClientFactory.CreateCommonServiceClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bsData = ZipTools.CompressionDataSet(dalBase.TableToDataSet(data));
return(client.SaveFieldDef(loginTicket, bsData));
}
}
public bool Update(DataSet ds)
{
using (SGBaseUser_WClient client = SoapClientFactory.CreateSGBaseUser_WClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bDs = ZipTools.CompressionDataSet(ds);
return(client.U_UpdateUser(loginTicket, bDs));
}
}
public SaveResult Update(DataSet saveData)
{
using (InventoryModuleServiceClient client = SoapClientFactory.CreateInventoryModuleServiceClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bs = ZipTools.CompressionDataSet(saveData);
byte[] receivedData = client.IC_Update(loginTicket, bs);
return(ZipTools.DecompressionObject(receivedData) as SaveResult);
}
}
public SaveResultEx UpdateEx(System.Data.DataSet data)
{
using (DataDictServiceClient client = SoapClientFactory.CreateDataDictClient())
{
byte[] loginTicket = WebServiceSecurity.EncryptLoginer(Loginer.CurrentUser);
byte[] bs = ZipTools.CompressionDataSet(data);
byte[] rt = client.UpdateEx(loginTicket, bs, _ORM.FullName);
return((SaveResultEx)ZipTools.DecompressionObject(rt));
}
}
public void WriteLog(string logID, DataTable originalData, DataTable changes, string tableName, string keyFieldName, bool isMaster)
{
using (CommonServiceClient client = SoapClientFactory.CreateCommonServiceClient())
{
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);
}
}
public byte[] ExecuteProcedure(byte[] loginTicket, string sqlcmd)
{
try
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataSet ds = new dalBaseDataDict(loginer).ExecuteProcedure(sqlcmd);
return(ZipTools.CompressionDataSet(ds));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}