public IList <VORejectReasonLang> GetRejectReasonList(DbRejectReason dbRejectReason, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VORejectReasonLang>(
ScgDbQueryProvider.RejectReasonQuery, "FindReasonByDocumentTypeLanguageId",
new object[] { dbRejectReason, languageId, false, sortExpression }
, firstResult, maxResult, sortExpression));
}
public IList <TranslateSearchResult> GetTranslatedList(SuGlobalTranslate criteria, short languageID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <TranslateSearchResult>(
QueryProvider.SuGlobalTranslateQuery,
"FindGlobalTranslateSearchResult",
new object[] { criteria, languageID, sortExpression, false },
firstResult, maxResult, sortExpression));
}
public IList <SuRTENode> GetSuRTENodeList(short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuRTENode>(
QueryProvider.SuRTENodeQuery,
"FindSuRTENodeByLanguageId",
new object[] { languageId, sortExpression, false },
firstResult, maxResult, sortExpression));
}
public IList <VOExpenseGroup> GetExpenseGroupList(VOExpenseGroup criteria, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOExpenseGroup>(
ScgDbQueryProvider.DbExpenseGroupLangQuery,
"FindExpenseGroupByCriteria",
new object[] { criteria, languageId, false, sortExpression },
firstResult, maxResult, sortExpression));
}
public IList <VOInvoiceItem> GetInvoiceItemListByExpenseID(long expenseId, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOInvoiceItem>(
ScgeAccountingQueryProvider.FnExpenseInvoiceItemQuery,
"FindInvoiceItemByExpenseID", new object[] { expenseId, languageId, false, sortExpression },
firstResult, maxResult, sortExpression
));
}
public IList <SuPostSAPLogSearchResult> GetPostSAPLogList(string requestNo, string date, string status, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuPostSAPLogSearchResult>(
QueryProvider.SuPostSAPLogQuery
, "FindSuPostSAPLogSearchResult"
, new object[] { requestNo, date, status, sortExpression, false }
, firstResult
, maxResult
, sortExpression));
}
public IList <SueHrExpenseLog> GeteHrExpenseLogList(SueHrExpenseLog query, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SueHrExpenseLog>(
QueryProvider.SuEHRExpenseLogQuery
, "FindEHRExpenseLogResult"
, new object[] { query, false, sortExpression }
, firstResult
, maxResult
, sortExpression));
}
public IList <FnEACAdvanceImportLog> FindFnEACAdvanceImportLogListQuery(FnEACAdvanceImportLog fnEACAdvanceImportLog, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <FnEACAdvanceImportLog>(
ScgeAccountingQueryProvider.FnEACAdvanceImportLogQuery,
"FindFnEACAdvanceImportLogSearchResult",
new object[] { fnEACAdvanceImportLog, sortExpression, false },
firstResult,
maxResult,
sortExpression));
}
public IList <SuSmsLogSearchResult> GetSmsLogList(DateTime?fromDate, DateTime?toDate, string phoneNo, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuSmsLogSearchResult>(
QueryProvider.SuSmsLogQuery
, "FindSuSmsLogSearchResult"
, new object[] { fromDate, toDate, phoneNo, sortExpression, false }
, firstResult
, maxResult
, sortExpression));
}
public IList <SuUserLoginLog> FindSuUserLoginLogListQuery(DateTime?fromDate, DateTime?toDate, string UserName, string Status, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuUserLoginLog>(
QueryProvider.SuUserLogQuery,
"FindSuUserLoginLogSearchResult",
new object[] { fromDate, toDate, UserName, Status, sortExpression, false },
firstResult,
maxResult,
sortExpression));
}
public Object GetList(int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuMenuSearchResult>(
QueryProvider.SuMenuQuery
, "FindSuMenuSearchResult"
, new object[] { Convert.ToInt16("1"), sortExpression, false }
, firstResult
, maxResult
, sortExpression));
//return base.FindAll();
}
public IList <VOPB> GetPbList(VOPB pb, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOPB>(ScgDbQueryProvider.DbPBQuery, "FindPbByCriteria", new object[] { pb, sortExpression, false }, firstResult, maxResult, sortExpression));
}
public IList <VOEmailLog> GetLogList(string emailType, string sendDate, string requestNo, int status, int firstResult, int maxResult, string sortExpression, short currentLanguage)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOEmailLog>(ScgeAccountingQueryProvider.EmailLogQuery, "FindByEmailLogCriteria", new object[] { emailType, sendDate, requestNo, status, false, sortExpression, currentLanguage }, firstResult, maxResult, sortExpression));
}
public IList <FnPerdiemProfile> GetForeignPerdiemRateProfileListByCriteria(ForeignPerdiemRateProfileCriteria criteria, int startRow, int pageSize, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <FnPerdiemProfile>(ScgeAccountingQueryProvider.FnPerdiemProfileQuery, "FindForeignPerdiemRateProfileByCriteria", new object[] { criteria, sortExpression, false }, startRow, pageSize, sortExpression));
}
public IList <TADocumentObj> GetTADocumentScheduleList(int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <TADocumentObj>(ScgeAccountingQueryProvider.TADocumentScheduleQuery, "FindByTADocumentScheduleCriteria", new object[] { false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbMonitoringDocument> DataMonitoringDocumentQuery(string comCode, string colnumber, string BuName, short languageID, string sortExpression, int startRow, int pageSize)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbMonitoringDocument>(ScgeAccountingQueryProvider.DbMonitoringDocumentQuery, "FindDataMonitoringDocumentQuery", new object[] { comCode, colnumber, BuName, languageID, sortExpression, false }, startRow, pageSize, sortExpression));
}
public IList <CompanyResult> GetCompanyList(DbCompany company, bool?flagAcitive, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <CompanyResult>(ScgDbQueryProvider.DbCompanyQuery, "FindCompanyByCriteria", new object[] { company, flagAcitive, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbLanguageSearchResult> GetLanguageList(short languageID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbLanguageSearchResult>(SsDbQueryProvider.DbLanguageQuery, "FindDbLanguageSearchResult", new object[] { languageID, sortExpression, false }, firstResult, maxResult, sortExpression));
}
//public IList<SuUserRoleSearchResult> GetTranslatedList(SuUserRoleSearchResult criteria, long userID, short languageID, int firstResult, int maxResult, string sortExpression)
//{
// return NHibernateQueryHelper.FindPagingByCriteria<SuUserRoleSearchResult>(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { criteria, userID, languageID }, firstResult, maxResult, sortExpression);
//}
//public ISQLQuery FindSuUserRoleSearchResult(SuUserRoleSearchResult userRoleSearchResult, long userID, short languageID)
//{
// StringBuilder sqlBuilder = new StringBuilder();
// sqlBuilder.AppendLine(" SELECT ur.ID as UserRoleId, ur.UserID as UserId, ur.RoleId as RoleId, rl.RoleName as RoleName, ur.Comment as Comment, ur.Active as Active ");
// sqlBuilder.AppendLine(" FROM SuUserRole ur INNER JOIN SuRole r on r.RoleID = ur.RoleID ");
// sqlBuilder.AppendLine(" INNER JOIN SuRoleLang rl on rl.RoleID = r.RoleID and rl.LanguageID = :languageID ");
// sqlBuilder.AppendLine(" WHERE ur.UserID = :userID ");
// QueryParameterBuilder parameterBuilder = new QueryParameterBuilder();
// parameterBuilder.AddParameterData("languageID", typeof(short), languageID);
// parameterBuilder.AddParameterData("userID", typeof(long), userID);
// ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
// parameterBuilder.FillParameters(query);
// query.AddScalar("UserRoleId", NHibernateUtil.Int64)
// .AddScalar("UserId", NHibernateUtil.Int64)
// .AddScalar("RoleId", NHibernateUtil.Int16)
// .AddScalar("RoleName", NHibernateUtil.String)
// .AddScalar("Comment", NHibernateUtil.String)
// .AddScalar("Active", NHibernateUtil.Boolean);
// query.SetResultTransformer(Transformers.AliasToBean(typeof(SuUserRoleSearchResult)));
// return query;
//}
//public int FindCountSuUserRoleSearchResult(SuUserRoleSearchResult userRoleSearchResult, long userID, short languageID)
//{
// StringBuilder sqlBuilder = new StringBuilder();
// sqlBuilder.AppendLine(" SELECT Count(*) as Count ");
// sqlBuilder.AppendLine(" FROM SuUserRole ur INNER JOIN SuRole r on r.RoleID = ur.RoleID ");
// sqlBuilder.AppendLine(" INNER JOIN SuRoleLang rl on rl.RoleID = r.RoleID and rl.LanguageID = :languageID ");
// sqlBuilder.AppendLine(" WHERE ur.UserID = :userID ");
// ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
// query.SetInt64("userID", userID);
// query.SetInt16("languageID", languageID);
// query.AddScalar("Count", NHibernateUtil.Int32);
// return Convert.ToInt32(query.UniqueResult());
//}
#endregion
#region ISuUserRoleQuery Members
public IList <SuUserRoleSearchResult> GetSuUserRoleSearchResultList(long userID, short languageID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuUserRoleSearchResult>(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { userID, languageID, sortExpression, false }, firstResult, maxResult, sortExpression));
}
public IList <CostCenterCompany> FindCostCenterCompany(DbCostCenter costCenter, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <CostCenterCompany>(ScgDbQueryProvider.DbCostCenterQuery, "FindCostCenterCompanyByCriteria", new object[] { costCenter, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbExchangeRate> GetExchangeList(short currencyId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbExchangeRate>(SsDbQueryProvider.DbExchangeRateQuery, "FindExchangeRateByCurrencyId", new object[] { currencyId }, firstResult, maxResult, sortExpression));
}
public IList <DbTax> GetTaxList(DbTax tax, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbTax>(ScgDbQueryProvider.DbTaxQuery, "FindByTaxCriteria", new object[] { tax, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbHoliday> GetHoliday(int holidayProfileId, int startRow, int pageSize, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbHoliday>(ScgDbQueryProvider.DbHolidayQuery, "FindHolidayByCriteria", new object[] { holidayProfileId, sortExpression, false }, startRow, pageSize, sortExpression));
}
public IList <DbInternalOrder> GetInternalOrderList(DbInternalOrder io, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbInternalOrder>(ScgDbQueryProvider.DbIOQuery, "FindDataByIOCriteria", new object[] { io, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbVendor> GetVendorList(DbVendor Vendor, short languageId, int firstResult, int maxResult, string sortExpression, string VendorCode, string VendorName)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbVendor>(ScgDbQueryProvider.DbVendorQuery, "FindVendorByCriteria", new object[] { Vendor, false, languageId, sortExpression, VendorCode, VendorName }, firstResult, maxResult, sortExpression));
}
public IList <DbCostCenter> GetCostCenterList(string costCenterCode, string description, long companyID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbCostCenter>(ScgDbQueryProvider.DbCostCenterQuery, "FindByCostCenterCriteria", new object[] { costCenterCode, description, companyID, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <BankLang> GetBankList(BankLang bank, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <BankLang>(ScgDbQueryProvider.DbBankQuery, "FindByBankCriteria", new object[] { bank, false, languageId, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <VOVendor> GetVendorListByVendorCriteria(VOVendor criteria, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOVendor>(ScgDbQueryProvider.DbVendorQuery, "FindVendorByVendorCriteria", new object[] { criteria, false, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <CountryLang> GetCountryList(DbCountry country, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <CountryLang>(ScgDbQueryProvider.DbCountryQuery, "FindByCountryCriteria", new object[] { country, false, languageId, sortExpression }, firstResult, maxResult, sortExpression));
}
public IList <DbVendor> GetVendorList(string taxNo, string vendorCode, string vendorName, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <DbVendor>(ScgDbQueryProvider.DbVendorQuery, "FindByVendorCriteria", new object[] { taxNo, vendorCode, vendorName, false, sortExpression }, firstResult, maxResult, sortExpression));
}