public ISQLQuery FindByProvinceCriteria(ProvinceLang province, bool isCount, short languageId, string sortExpression) { StringBuilder sqlBuilder = new StringBuilder(); if (!isCount) { sqlBuilder.Append(" SELECT "); sqlBuilder.Append(" DbProvince.ProvinceID AS ProvinceId ,"); sqlBuilder.Append(" DbProvince.RegionID AS RegionId ,"); sqlBuilder.Append(" DbProvince.Comment AS Comment ,"); sqlBuilder.Append(" DbProvince.Active AS Active ,"); sqlBuilder.Append(" DbProvinceLang.ProvinceName AS ProvinceName ,"); sqlBuilder.Append(" DbRegionLang.RegionName AS RegionName "); sqlBuilder.Append(" FROM DbProvince "); sqlBuilder.Append(" LEFT JOIN DbProvinceLang ON "); sqlBuilder.Append(" DbProvince.ProvinceId = DbProvinceLang.ProvinceId AND "); sqlBuilder.Append(" DbProvinceLang.LanguageID = :LanguageId "); sqlBuilder.Append(" LEFT JOIN DbRegionLang ON "); sqlBuilder.Append(" DbProvince.RegionId = DbRegionLang.RegionId AND "); sqlBuilder.Append(" DbRegionLang.LanguageID = :LanguageId "); if (string.IsNullOrEmpty(sortExpression)) { sqlBuilder.AppendLine("ORDER BY DbProvince.ProvinceID,DbProvince.RegionID,DbProvince.Comment,DbProvince.Active "); } else { sqlBuilder.AppendLine(string.Format(" ORDER BY {0}", sortExpression)); } } else { sqlBuilder.Append(" SELECT COUNT(ProvinceID) AS ProvinceCount FROM DbProvince "); } ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString()); if (!isCount) { QueryParameterBuilder queryParameterBuilder = new QueryParameterBuilder(); queryParameterBuilder.AddParameterData("LanguageId", typeof(Int16), languageId); queryParameterBuilder.FillParameters(query); query.AddScalar("ProvinceId", NHibernateUtil.Int16); query.AddScalar("RegionId", NHibernateUtil.Int16); query.AddScalar("Comment", NHibernateUtil.String); query.AddScalar("Active", NHibernateUtil.Boolean); query.AddScalar("ProvinceName", NHibernateUtil.String); query.AddScalar("RegionName", NHibernateUtil.String); query.SetResultTransformer(Transformers.AliasToBean(typeof(ProvinceLang))); } else { query.AddScalar("ProvinceCount", NHibernateUtil.Int32); query.UniqueResult(); } return(query); }
public int CountByProvinceCriteria(ProvinceLang province) { return(NHibernateQueryHelper.CountByCriteria(SsDbQueryProvider.DbProvinceQuery, "FindByProvinceCriteria", new object[] { province, true, Convert.ToInt16(0), string.Empty })); }
public IList <ProvinceLang> GetProvinceList(ProvinceLang province, short languageId, int firstResult, int maxResult, string sortExpression) { return(NHibernateQueryHelper.FindPagingByCriteria <ProvinceLang>(SsDbQueryProvider.DbProvinceQuery, "FindByProvinceCriteria", new object[] { province, false, languageId, sortExpression }, firstResult, maxResult, sortExpression)); }
public int CountByProvinceLovCriteria(ProvinceLang province, string ProvinceID, string ProvinceName, string RegionID) { return(NHibernateQueryHelper.CountByCriteria(SsDbQueryProvider.DbProvinceQuery, "FindByProvinceLovCriteria", new object[] { province, true, Convert.ToInt16(0), string.Empty, ProvinceID, ProvinceName, RegionID })); }