コード例 #1
0
        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"]);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
        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"]);
        }
コード例 #4
0
        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);
        }