public F4102GroupBPsBrowser()
{
dataServiceType = "AGGREGATION";
aggregation = new Celin.AIS.Aggregation
{
aggregations = new[]
{
new Celin.AIS.AggregationItem
{
aggregation = "COUNT",
column = "*"
}
},
groupBy = new[]
{
new Celin.AIS.AggregationItem
{
column = "MCU"
}
}
};
query = new Celin.AIS.Query
{
matchType = "MATCH_ALL",
condition = new[]
{
new Celin.AIS.Condition
{
controlId = "F4102.VEND",
@operator = "GREATER",
value = new[]
{
new Celin.AIS.Value
{
content = "0",
specialValueId = "LITERAL"
}
}
},
new Celin.AIS.Condition
{
controlId = "F4102.VEND",
@operator = "GREATER",
value = new []
{
new Celin.AIS.Value
{
content = "0",
specialValueId = "LITERAL"
}
}
}
}
};
}
public F98210DatabrowserRequest(DateTime from)
{
dataServiceType = "AGGREGATION";
targetName = "F98210";
targetType = "table";
aggregation = new Celin.AIS.Aggregation();
aggregation.aggregations.Add(new Celin.AIS.AggregationItem
{
aggregation = "COUNT",
column = "*"
});
aggregation.groupBy.Add(new Celin.AIS.AggregationItem {
column = "UPMJ"
});
query = new Celin.AIS.Query {
condition = new List <Celin.AIS.Condition>(),
matchType = "MATCH_ALL"
};
query.condition.Add(new Celin.AIS.Condition
{
value = new[]
{
new Celin.AIS.Value
{
content = "02",
specialValueId = "LITERAL"
},
new Celin.AIS.Value
{
content = "38",
specialValueId = "LITERAL"
}
},
controlId = "F98210.OMWAC",
@operator = "LIST"
});
query.condition.Add(new Celin.AIS.Condition
{
value = new[]
{
new Celin.AIS.Value
{
content = from.ToString("MM/dd/yyyy"),
specialValueId = "LITERAL"
}
},
controlId = "F98210.UPMJ",
@operator = "GREATER_EQUAL"
});
}
public F98220DatabrowserRequest(string[] groupBy, string[][] orderBy)
{
dataServiceType = "AGGREGATION";
targetName = "F98220";
targetType = "table";
aggregation = new Celin.AIS.Aggregation();
aggregation.aggregations.Add(new Celin.AIS.AggregationItem
{
aggregation = "COUNT",
column = "*"
});
if (groupBy != null)
{
aggregation.groupBy = new List <Celin.AIS.AggregationItem>(
groupBy.Select(c => new Celin.AIS.AggregationItem {
column = c
})
);
}
if (orderBy != null)
{
aggregation.orderBy = new List <Celin.AIS.AggregationItem>(
orderBy.Select(c => new Celin.AIS.AggregationItem {
column = c[0], direction = c[1]
})
);
}
query = new Celin.AIS.Query
{
condition = new List <Celin.AIS.Condition>(),
matchType = "MATCH_ALL"
};
query.condition.Add(new Celin.AIS.Condition
{
value = new[]
{
new Celin.AIS.Value
{
content = "Default",
specialValueId = "LITERAL"
}
},
controlId = "F98220.OMWDESC",
@operator = "NOT_EQUAL"
});
}