public DataTable Select(ISelectQuery aQuery, OnRowSelect onExecute)
{
if (aQuery == null)
{
aQuery = QueryFactory.CreateSelectQuery();
}
DataRow dr = null;
RowBinder binder = new RowBinder();
int i = 0;
binder.OnBind = delegate(DataRow aRow)
{
dr = aRow;
if (onExecute != null)
{
onExecute(dr, i);
i++;
}
};
Connetion.execute(aQuery, binder);
if (dr == null)
{
return(null);
}
return(dr.Table);
}
public virtual DataTable ExecuteSelectQuery(ISelectQuery aQuery, OnRowSelect onSelect)
{
DataTable dt = null;
DBHelper.Execute(
delegate(DbSession aSession)
{
dt = aSession.Select(aQuery, onSelect);
});
return(dt);
}
public virtual DataTable GetDPager <E>(int aMinimum = 0, int aMaximum = 10, T aCriteriaModel = null, System.Linq.Expressions.Expression <Func <T, E> > aOrderBy = null, bool isAscending = true, String aSqlQuery = null, CachePreference aCachePreferences = null, OnRowSelect onSelect = null)
{
return(ExecuteSelectQuery(GetModelOrderQueryWithSql(aCriteriaModel, aOrderBy, isAscending, aSqlQuery, aCachePreferences).SetMaximum(aMaximum).SetMinimum(aMinimum), onSelect));
}
public virtual DataTable GetDByCriteria(SqlCriteria aCriteria = null, CachePreference aCachePreferences = null, OnRowSelect onSelect = null)
{
if (aCriteria == null)
{
aCriteria = GetCriteria();
}
return(ExecuteSelectQuery(GetQuery(aCachePreferences).SetCriteria(aCriteria), onSelect));
}
