public Request(string [] keywords)
{
outputType = "GRID_DATA";
dataServiceType = "BROWSE";
targetName = "F0101";
targetType = "table";
returnControlIDs = "AN8|DC|ALPH|AT1";
maxPageSize = "20";
query = new Celin.AIS.Query
{
condition = keywords.Select(w =>
{
return(new Celin.AIS.Condition
{
value = new Celin.AIS.Value[]
{
new Celin.AIS.Value
{
content = w.ToUpper(),
specialValueId = "LITERAL"
}
},
controlId = "F0101.DC",
@operator = "STR_CONTAIN"
});
}).ToList(),
matchType = "MATCH_ALL",
autoFind = true
};
}
public F0006Browser(string[] mcus)
{
outputType = "GRID_DATA";
dataServiceType = "BROWSE";
targetName = "F0006";
targetType = "table";
returnControlIDs = "MCU|STYL|LDM|CO|DL01";
query = new Celin.AIS.Query
{
matchType = "MATCH_ALL",
condition = new[]
{
new Celin.AIS.Condition
{
controlId = "F0006.MCU",
@operator = "LIST",
value = mcus.Select(
mcu => new Celin.AIS.Value {
content = mcu, specialValueId = "LITERAL"
})
.ToArray()
}
}
};
}
public V4102XPIBrowser(string bp)
{
outputType = "GRID_DATA";
dataServiceType = "BROWSE";
targetName = "V4102XPI";
targetType = "view";
returnControlIDs = "F4102.LITM|MCU|DSC1|DSC2";
maxPageSize = "5000";
query = new Celin.AIS.Query
{
matchType = "MATCH_ALL",
condition = new[]
{
new Celin.AIS.Condition
{
controlId = "F4102.MCU",
@operator = "EQUAL",
value = new[]
{
new Celin.AIS.Value
{
content = bp,
specialValueId = "LITERAL"
}
}
}
}
};
}
public F0601161DatabrowserRequest()
{
dataServiceType = "BROWSE";
targetName = "F0601161";
targetType = "table";
returnControlIDs = "ALPH|AN8|ANPA|DST|DT|HMCU|HMLC|JBCD|JBST";
maxPageSize = "5000";
outputType = "GRID_DATA";
query = new Celin.AIS.Query
{
matchType = "MATCH_ALL",
condition = new[]
{
new Celin.AIS.Condition
{
value = new[]
{
new Celin.AIS.Value
{
content = "0",
specialValueId = "LITERAL"
}
},
controlId = "F0601161.DT",
@operator = "EQUAL"
}
}
};
}
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"
});
}
public F0005DatabrowserRequest(string SY, string[] RTs)
{
dataServiceType = "BROWSE";
targetName = "F0005";
targetType = "table";
returnControlIDs = "SY|RT|KY|DL01";
maxPageSize = "500";
query = new Celin.AIS.Query()
{
matchType = "MATCH_ALL"
};
query.condition = new List <Celin.AIS.Condition>();
query.condition.Add(new Celin.AIS.Condition
{
value = new[]
{
new Celin.AIS.Value
{
content = SY,
specialValueId = "LITERAL"
},
},
controlId = "F0005.SY",
@operator = "EQUAL"
});
query.condition.Add(new Celin.AIS.Condition
{
value = RTs.Select(RT => new Celin.AIS.Value
{
content = RT,
specialValueId = "LITERAL"
}).ToArray(),
controlId = "F0005.RT",
@operator = RTs.Length > 1 ? "LIST" : "EQUAL"
});
}