public void QueryFieldTypeTest()
{
DataTable table = CreateLookupWithFieldType();
Dictionary <string, SearchFieldType> types = QueryLookupHelper.GetFieldTypes(table);
Assert.AreEqual(table.Rows.Count, types.Count);
Assert.AreEqual(SearchFieldType.Bit, types["fBit"]);
Assert.AreEqual(SearchFieldType.Date, types["fDate"]);
Assert.AreEqual(SearchFieldType.Float, types["fFloat"]);
Assert.AreEqual(SearchFieldType.ID, types["fID"]);
Assert.AreEqual(SearchFieldType.Integer, types["fInteger"]);
Assert.AreEqual(SearchFieldType.String, types["fString"]);
}
private static DataTable CreateLookupWithFieldType()
{
DataTable table = QueryLookupHelper.GetQuerySearchFieldLookupTable();
table.Clear();
AddRow(table, "fBit", 10081001, DBNull.Value);
AddRow(table, "fDate", 10081002, DBNull.Value);
AddRow(table, "fFloat", 10081004, DBNull.Value);
AddRow(table, "fID", 10081005, DBNull.Value);
AddRow(table, "fInteger", 10081006, DBNull.Value);
AddRow(table, "fString", 10081007, DBNull.Value);
return(table);
}
public void QueryParamTypeTest()
{
DataTable table = CreateLookupWithFF();
Dictionary <string, SearchFieldType> types = QueryLookupHelper.GetFieldTypes(table);
Assert.AreEqual(SearchFieldType.Integer, types["fNumeric"]);
Assert.AreEqual(SearchFieldType.Bit, types["fBoolean"]);
Assert.AreEqual(SearchFieldType.String, types["fCaption"]);
Assert.AreEqual(SearchFieldType.Date, types["fDate"]);
Assert.AreEqual(SearchFieldType.Date, types["fDateTime"]);
Assert.AreEqual(SearchFieldType.Integer, types["fMonths"]);
Assert.AreEqual(SearchFieldType.String, types["fString"]);
Assert.AreEqual(SearchFieldType.Integer, types["fNumericNatural"]);
Assert.AreEqual(SearchFieldType.Integer, types["fNumericPositive"]);
Assert.AreEqual(SearchFieldType.Integer, types["fNumericInteger"]);
}
private static DataTable CreateLookupWithFF()
{
DataTable table = QueryLookupHelper.GetQuerySearchFieldLookupTable();
table.Clear();
AddRow(table, "fNumeric", 10081003, 10071007);
AddRow(table, "fBoolean", 10081003, 10071025);
AddRow(table, "fCaption", 10081003, 10071026);
AddRow(table, "fDate", 10081003, 10071029);
AddRow(table, "fDateTime", 10081003, 10071030);
AddRow(table, "fMonths", 10081003, 10071037);
AddRow(table, "fString", 10081003, 10071045);
AddRow(table, "fNumericNatural", 10081003, 10071059);
AddRow(table, "fNumericPositive", 10081003, 10071060);
AddRow(table, "fNumericInteger", 10081003, 10071061);
return(table);
}
