public void TestGetItemListDict()
{
using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
{
FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1);
var result = new Dictionary <string, object>()
{
{ "ID", ID1 },
{ "Name", "Name1" },
{ "Age", 1 },
{ "Aliase", null }
};
List <Dictionary <string, object> > list = sqlBase.GetItemListDict(tableName, filter);
Assert.AreEqual(list.Count, 1);
var obj = list[0];
Assert.AreEqual(result["ID"], obj["ID"]);
Assert.AreEqual(result["Name"], obj["Name"]);
Assert.AreEqual(result["Aliase"], obj["Aliase"]);
sqlBase.Commit();
}
}
public void TestGetItemListDictPaging2()
{
InitPagingData();
using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
{
List <FilterCondition> fts = new List <FilterCondition>()
{
new FilterCondition("Age", TableCompareType.LT, 10),
new FilterCondition("Age", TableCompareType.GTE, 5),
};
List <Dictionary <string, object> > list = sqlBase.GetItemListDict(tableName, fts);
Assert.AreEqual(list.Count, 5);
sqlBase.Commit();
}
CleanPagingData();
}
public void TestGetItemListDictEmpty()
{
using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
{
FilterCondition filter2 = new FilterCondition("id", TableCompareType.EQ, Guid.NewGuid());
var result = new Dictionary <string, object>()
{
{ "ID", ID1 },
{ "Name", "d2" },
{ "Age", 1 },
{ "Aliase", null }
};
List <Dictionary <string, object> > list2 = sqlBase.GetItemListDict(tableName, filter2);
Assert.IsNotNull(list2);
Assert.AreEqual(list2.Count, 0);
sqlBase.Commit();
}
}
