public ForeignPerdiemRateProfileCriteria GetCriteria()
{
ForeignPerdiemRateProfileCriteria mp = new ForeignPerdiemRateProfileCriteria();
mp.PerdiemProfileName = ctlPerdiemProfileName.Text;
mp.Description = ctlDescription.Text;
return(mp);
}
public ISQLQuery FindForeignPerdiemRateProfileByCriteria(ForeignPerdiemRateProfileCriteria criteria, string sortExpression, bool isCount)
{
StringBuilder sqlBuilder = new StringBuilder();
QueryParameterBuilder paramBuilder = new QueryParameterBuilder();
if (!isCount)
{
sqlBuilder.Append(" select PerdiemProfileID,PerdiemProfileName ,Description,Active ");
}
else
{
sqlBuilder.Append(" select count(*) as Count ");
}
sqlBuilder.Append(" from FnPerdiemProfile where 1=1 ");
if (!string.IsNullOrEmpty(criteria.PerdiemProfileName))
{
sqlBuilder.Append(" and PerdiemProfileName like :perdiemProfileName ");
paramBuilder.AddParameterData("perdiemProfileName", typeof(string), "%" + criteria.PerdiemProfileName + "%");
}
if (!string.IsNullOrEmpty(criteria.Description))
{
sqlBuilder.Append(" and Description like :description ");
paramBuilder.AddParameterData("description", typeof(string), "%" + criteria.Description + "%");
}
if (!string.IsNullOrEmpty(sortExpression))
{
sqlBuilder.Append(String.Format(" order by {0} ", sortExpression));
}
ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
paramBuilder.FillParameters(query);
if (isCount)
{
query.AddScalar("Count", NHibernateUtil.Int32);
}
else
{
query.AddScalar("PerdiemProfileID", NHibernateUtil.Int64);
query.AddScalar("PerdiemProfileName", NHibernateUtil.String);
query.AddScalar("Description", NHibernateUtil.String);
query.AddScalar("Active", NHibernateUtil.Boolean);
query.SetResultTransformer(Transformers.AliasToBean(typeof(FnPerdiemProfile)));
}
return(query);
}
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 int CountForeignPerdiemRateProfile(ForeignPerdiemRateProfileCriteria criteria)
{
return(NHibernateQueryHelper.CountByCriteria(ScgeAccountingQueryProvider.FnPerdiemProfileQuery, "FindForeignPerdiemRateProfileByCriteria", new object[] { criteria, string.Empty, true }));
}
public int RequestCount()
{
ForeignPerdiemRateProfileCriteria criteria = GetCriteria();
return(ScgeAccountingQueryProvider.FnPerdiemProfileQuery.CountForeignPerdiemRateProfile(criteria));
}
public Object RequestData(int startRow, int pageSize, string sortExpression)
{
ForeignPerdiemRateProfileCriteria criteria = GetCriteria();
return(ScgeAccountingQueryProvider.FnPerdiemProfileQuery.GetForeignPerdiemRateProfileListByCriteria(criteria, startRow, pageSize, sortExpression));
}
