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