Ejemplo n.º 1
0
 public static string SelectList(bool limitOffset) => QueryFormat.Select(ColList, Tables, Filter, GroupBy, OrderBy, !limitOffset);
Ejemplo n.º 2
0
 public static string ImageList(IList <long> ids)
 => QueryFormat.Select(@"ITEMID as 'Key',MIN(FILELOCATION) AS 'Value'", "IMAGELOCATION",
                       $"ITEMID IN({string.Join(",", ids) ?? "0"})", "ITEMID");
Ejemplo n.º 3
0
 public static string SelectList(bool limitOffset) => QueryFormat.Select(OuterList,
                                                                         $"({QueryFormat.Select(InnerList, Tables, Filter, InnerGroup)}) compo",
                                                                         null,
                                                                         OuterGroup,
                                                                         OuterOrder,
                                                                         limitOffset);