public void TestLoadByCriteriaSortOrderManualDesc()
{
SqlTestStore <Bean> store = new SqlTestStore <Bean>("name");
store.LoadAllByCriteria(null, new FilterCriteria().Equals(Bean.Cols.BEA_ID, 1), new QueryParameter(Bean.Cols.BEA_ID, SortOrder.Desc));
Assert.AreEqual("BEA_ID desc", store.SortOrder);
}
public void TestLoadByCriteriaSortOrderDefault()
{
SqlTestStore <Bean> store = new SqlTestStore <Bean>("name");
store.LoadAllByCriteria(null, new FilterCriteria().Equals(Bean.Cols.BEA_ID, 1), null);
Assert.AreEqual("BEA_NAME", store.SortOrder);
}
public void TestLoadByCriteriaSortOrderLibelle()
{
SqlTestStore <BeanLibelle> store = new SqlTestStore <BeanLibelle>("name");
store.LoadAllByCriteria(null, new FilterCriteria().Equals(Bean.Cols.BEA_ID, 1), null);
Assert.AreEqual("BEA_LIBELLE", store.SortOrder);
}
public void TestLoadByCriteriaSortOrderManualBoth()
{
SqlTestStore <Bean> store = new SqlTestStore <Bean>("name");
QueryParameter sort = new QueryParameter();
sort.AddSortParam(Bean.Cols.BEA_ID, SortOrder.Asc);
sort.AddSortParam(Bean.Cols.BEA_NAME, SortOrder.Desc);
store.LoadAllByCriteria(null, new FilterCriteria().Equals(Bean.Cols.BEA_ID, 1), sort);
Assert.AreEqual("BEA_ID asc, BEA_NAME desc", store.SortOrder);
}
public void TestLoadAllByCriteria()
{
SqlTestStore <Bean> store = new SqlTestStore <Bean>("name");
store.LoadAllByCriteria(null, new FilterCriteria().Equals(Bean.Cols.BEA_ID, 1), null);
}
public void TestLoadAllByCriteriaNull()
{
SqlTestStore <Bean> store = new SqlTestStore <Bean>("name");
store.LoadAllByCriteria(null, null, null);
}