public IList ExecuteQuery(IList <IsearchDTO> criterias, int maxQueryresult)
{
_bindableResults = new BindingList <Assignment>();
Query q = _ps.CreateNewQuery("MapperAssignment");
q.SetTable("Book_Assignment");
if (maxQueryresult > 0)
{
q.SetMaxNumberOfReturnedRecords(maxQueryresult);
}
if (criterias.Count > 0)
{
CompositeCriteria c = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
foreach (IsearchDTO item in criterias)
{
if (item != null)
{
AbstractBoolCriteria crit = item.GenerateSql();
if (crit != null)
{
c.AddCriteria(crit);
}
}
}
q.AddWhereClause(c);
}
string a = q.CreateQuery(_ps);
IList l = q.Execute(_ps);
//calcolo lo stato per ogni appp ritornato
foreach (Assignment item in l)
{
_bindableResults.Add(item);
}
return(l);
}
public IList ExecuteQuery(IList <IsearchDTO> criterias)
{
_bindableResults = new BindingList <AbstractMovimentoContabile>();
Query q = _ps.CreateNewQuery("Mapper" + ObjectTypeName);
//q.SetTable("App_Appointments");
if (criterias.Count > 0)
{
CompositeCriteria c = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
foreach (IsearchDTO item in criterias)
{
if (item != null)
{
AbstractBoolCriteria crit = item.GenerateSql();
if (crit != null)
{
c.AddCriteria(crit);
}
}
}
q.AddWhereClause(c);
}
string a = q.CreateQuery(_ps);
IList l = q.Execute(_ps);
//creo la binding list
foreach (AbstractMovimentoContabile item in l)
{
_bindableResults.Add(item);
}
return(l);
}
