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 }));
}
