public ISQLQuery FindByBankCriteria(BankLang bank, bool isCount, short languageId, string sortExpression) { StringBuilder sqlBuilder = new StringBuilder(); if (!isCount) { sqlBuilder.Append(" SELECT "); sqlBuilder.Append(" DbBank.BankId AS BankId ,"); sqlBuilder.Append(" DbBank.BankNo AS BankNo ,"); sqlBuilder.Append(" DbBank.Comment AS Comment ,"); sqlBuilder.Append(" DbBank.Active AS Active ,"); sqlBuilder.Append(" DbBankLang.BankName AS BankName ,"); sqlBuilder.Append(" DbBankLang.ABBRName AS ABBRName "); sqlBuilder.Append(" FROM DbBank "); sqlBuilder.Append(" LEFT JOIN DbBankLang ON "); sqlBuilder.Append(" DbBank.BankId = DbBankLang.BankId AND "); sqlBuilder.Append(" DbBankLang.LanguageID = :LanguageId "); if (string.IsNullOrEmpty(sortExpression)) { sqlBuilder.AppendLine("ORDER BY DbBank.BankNo,DbBankLang.BankName,DbBankLang.ABBRName,DbBank.Comment,DbBank.Active"); } else { sqlBuilder.AppendLine(string.Format(" ORDER BY {0}", sortExpression)); } } else { sqlBuilder.Append(" SELECT COUNT(BankId) AS BankCount FROM DbBank "); } ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString()); if (!isCount) { QueryParameterBuilder queryParameterBuilder = new QueryParameterBuilder(); queryParameterBuilder.AddParameterData("LanguageId", typeof(Int16), languageId); queryParameterBuilder.FillParameters(query); query.AddScalar("BankId", NHibernateUtil.Int16); query.AddScalar("BankNo", NHibernateUtil.String); query.AddScalar("Comment", NHibernateUtil.String); query.AddScalar("Active", NHibernateUtil.Boolean); query.AddScalar("BankName", NHibernateUtil.String); query.AddScalar("ABBRName", NHibernateUtil.String); query.SetResultTransformer(Transformers.AliasToBean(typeof(BankLang))); } else { query.AddScalar("BankCount", NHibernateUtil.Int32); query.UniqueResult(); } return(query); }
public int CountByBankCriteria(BankLang bank) { return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbBankQuery, "FindByBankCriteria", new object[] { bank, true, Convert.ToInt16(0), string.Empty })); }
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)); }