public int GetCountTranslatedList(SuGlobalTranslate criteria, short languageId) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuGlobalTranslateQuery, "FindGlobalTranslateSearchResult", new object[] { criteria, languageId, string.Empty, true })); }
public int GetCountUserLoginLoglist(DateTime?fromDate, DateTime?toDate, string UserName, string Status) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuUserLogQuery, "FindSuUserLoginLogSearchResult", new object[] { fromDate, toDate, UserName, Status, string.Empty, true })); }
public int GetCountPostSAPLogList(string requestNo, string date, string status) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuPostSAPLogQuery, "FindSuPostSAPLogSearchResult", new object[] { requestNo, date, status, string.Empty, true })); }
public int GetCountMenuList(short languageID) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuMenuQuery, "FindSuMenuSearchResult", new object[] { languageID, string.Empty, true })); }
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 int GetRejectReasonCount(DbRejectReason dbRejectReason, short languageId) { return(NHibernateQueryHelper.CountByCriteria( ScgDbQueryProvider.RejectReasonQuery, "FindReasonByDocumentTypeLanguageId", new object[] { dbRejectReason, languageId, true, string.Empty })); }
public int GetCountList(short languageId) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuRTENodeQuery, "FindSuRTENodeByLanguageId", new object[] { languageId, string.Empty, true })); }
public int GetCountFnEACAdvanceImportLoglist(FnEACAdvanceImportLog fnEACAdvanceImportLog) { return(NHibernateQueryHelper.CountByCriteria( ScgeAccountingQueryProvider.FnEACAdvanceImportLogQuery, "FindFnEACAdvanceImportLogSearchResult", new object[] { fnEACAdvanceImportLog, string.Empty, true })); }
public int GetCountDivisionList(short languageID, short organizationId) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuDivisionQuery, "FindSuDivisionSearchResult", new object[] { languageID, organizationId, string.Empty, true })); }
public int GetExpenseGroupCount(VOExpenseGroup criteria, short languageId) { return(NHibernateQueryHelper.CountByCriteria( ScgDbQueryProvider.DbExpenseGroupLangQuery, "FindExpenseGroupByCriteria", new object[] { criteria, languageId, true, string.Empty })); }
public int GetCountSmsLogList(DateTime?fromDate, DateTime?toDate, string phoneNo) { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuSmsLogQuery, "FindSuSmsLogSearchResult", new object[] { fromDate, toDate, phoneNo, string.Empty, true })); }
public int CountInvoiceItemList(long expenseId, short languageId) { return(NHibernateQueryHelper.CountByCriteria( ScgeAccountingQueryProvider.FnExpenseInvoiceItemQuery, "FindInvoiceItemByExpenseID", new object[] { expenseId, languageId, true, string.Empty } )); }
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 int GetCount() { return(NHibernateQueryHelper.CountByCriteria( QueryProvider.SuMenuQuery, "FindSuMenuSearchResult", new object[] { Convert.ToInt16("1"), string.Empty, true })); //return base.FindAll().Count; }
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 <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 bool ChekPermission(long UerID) { int result = NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbMileageRateRevisionQuery, "FindMieagePermission", new object[] { UerID }); if (result >= 1) { return(true); } return(false); }
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 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 <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 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 int CountByCountryCriteria(DbCountry country) { return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbCountryQuery, "FindByCountryCriteria", new object[] { country, true, Convert.ToInt16(0), string.Empty })); }
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 int GetCountSuUserRoleSearchResult(long userID, short languageID) { return(NHibernateQueryHelper.CountByCriteria(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { userID, languageID, string.Empty, true })); }
//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 <ServiceTeamLocationResult> GetServiceTeamLocationList(DbServiceTeam serviceTeam, int firstResult, int maxResult, string sortExpression) { return(NHibernateQueryHelper.FindByCriteria <ServiceTeamLocationResult>(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, false, sortExpression })); }
public int CountServiceTeamLocationByServiceTeamID(DbServiceTeam serviceTeam) { return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, true, string.Empty })); }