public bool Display(ApplicationCommand cmd, string columns, Locator locator) { SqlBuilder builder; if (cmd.wildcard == null) { builder = new SqlBuilder().SELECT().TOP(cmd.Top).COLUMNS(columns).FROM(tname); if (locator != null) { builder.WHERE(locator); } } else { Locator where = LikeExpr(cmd.wildcard, cmd.Columns); if (locator != null) { where = locator.And(where); } builder = new SqlBuilder().SELECT().COLUMNS(columns).FROM(tname).WHERE(where); } return(Display(cmd, builder, tname, cmd.Top)); }
public Locator GetCombinedLocator(TreeNode <IDataPath> pt1) { if (pt1.Item is Locator) { Locator locator = new Locator((Locator)pt1.Item); var pt2 = pt1; while (pt2.Parent.Item is Locator) { pt2 = pt2.Parent; locator.And((Locator)pt2.Item); } return(locator); } else { return(null); } }
private bool TypeLocatorData(TreeNode <IDataPath> pt, ApplicationCommand cmd) { if (!(pt.Item is Locator)) { return(false); } TableName tname = this.GetCurrentPath <TableName>(); Locator locator = GetCombinedLocator(pt); var xnode = pt; while (xnode.Parent.Item is Locator) { xnode = xnode.Parent; locator.And((Locator)xnode.Item); } tout = new TableOut(tname); return(tout.Display(cmd, "*", locator)); }