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