protected LiteQuery GetRefSubQuery(string refTableName, string refKeyName, string refDisplayName, string foreignTableAlias, string foreignName)
        {
            string    tableAlias = string.Empty;
            LiteQuery query      = LiteQuery.New(refTableName, tableAlias);

            query.AddField(tableAlias, refDisplayName);
            query.Filter = FilterField.New(tableAlias, refKeyName).Equal(foreignTableAlias, foreignName);
            return(query);
        }
        public LiteQuery GetMMSubQuery(string innnerTableName, string leftFieldName, string rightFieldName, object rightValue)
        {
            string    tableAlias = string.Empty;
            LiteQuery query      = LiteQuery.New(innnerTableName, tableAlias);

            query.AddField(tableAlias, leftFieldName);
            query.Filter = FilterField.New(tableAlias, rightFieldName).Equal(rightValue);
            return(query);
        }