public QueryTreeNode AddNode(ref QueryTree view, string QReference_Version, int QReference_ID, string Name, string Title, string Description, ref QueryTreeNode[] childNodes) { QueryTreeNode tnode = new QueryTreeNode(); tnode.QueryRef = new QueryReference(); tnode.QueryRef.Id = QReference_ID; tnode.QueryRef.Version = QReference_Version; tnode.Description = Description; tnode.Name = Name; tnode.Title = Title; if (childNodes == null) { List <QueryTreeNode> L_ = new List <QueryTreeNode>(); L_.Add(tnode); childNodes = L_.ToArray(); } else { List <QueryTreeNode> L_ = childNodes.ToList(); L_.Add(tnode); childNodes = L_.ToArray(); } return(tnode); }
/// <summary> /// Generate query for operand /// </summary> /// <param name="operand"></param> /// <param name="context"></param> /// <returns> /// The query /// </returns> protected override string GenerateCommand(QueryTreeNode operand, FusionContextData context) { var visitor = new DB2QueryTreeCommandGeneratorVisitor(); visitor.ContextData = context; operand.Accept(visitor); return(visitor.NodeData[operand.Id]); }
public QueryTreeNode AddCategoryNode(ref QueryTree view, string Name, string Title, string Description) { QueryTreeNode tnode = new QueryTreeNode(); tnode.QueryRef = new QueryReference(); tnode.Description = Description; tnode.Name = Name; tnode.Title = Title; tnode.ChildNodes = null; return(tnode); }
public UtilsDef(ref QueryTree view, int ID_USER) { Class_ManageSettingInstance v_s = new Class_ManageSettingInstance(); List <SettingIRPClass> Las_NameCat = Class_ManageSettingInstance.GetSettingWebQuery("XWEB_QUERY"); string Role = v_s.GetRoleUser(ID_USER != ConnectDB.NullI ? ID_USER : -1) != "" ? v_s.GetRoleUser(ID_USER != ConnectDB.NullI ? ID_USER : -1) : RolesUsers.Guest.ToString(); view.Root = new QueryTreeNode(); view.Style = new QueryTreeStyle(); view.Root.Name = MAIN_MENU_ROOT; view.Root.Description = ""; view.Root.Title = MAIN_MENU_ROOT; List <QueryTreeNode> L_Categ = new List <QueryTreeNode>(); QueryTreeNode Tnode_PUBLIC_VIEW_SPECTRUM_MANAGEMENT = AddCategoryNode(ref view, MAIN_MENU_PUBLIC_VIEW_SPECTRUM_MANAGEMENT, MAIN_MENU_PUBLIC_VIEW_SPECTRUM_MANAGEMENT, ""); L_Categ.Add(Tnode_PUBLIC_VIEW_SPECTRUM_MANAGEMENT); QueryTreeNode Tnode_USER_CUST_STATION_LIST = AddCategoryNode(ref view, MAIN_MENU_AUTH_USER_CUST_STATION_LIST, MAIN_MENU_AUTH_USER_CUST_STATION_LIST, ""); L_Categ.Add(Tnode_USER_CUST_STATION_LIST); QueryTreeNode Tnode_USER_DELEG_STATION_LIST = AddCategoryNode(ref view, MAIN_MENU_AUTH_USER_DELEG_STATION_LIST, MAIN_MENU_AUTH_USER_DELEG_STATION_LIST, ""); L_Categ.Add(Tnode_USER_DELEG_STATION_LIST); QueryTreeNode Tnode_CUST_STATION_LIST1 = AddCategoryNode(ref view, MAIN_MENU_AUTH_USER_LT1, MAIN_MENU_AUTH_USER_LT1, ""); L_Categ.Add(Tnode_CUST_STATION_LIST1); QueryTreeNode Tnode_CUST_STATION_LIST2 = AddCategoryNode(ref view, MAIN_MENU_AUTH_USER_LT2, MAIN_MENU_AUTH_USER_LT2, ""); L_Categ.Add(Tnode_CUST_STATION_LIST2); QueryTreeNode Tnode_AUTH_USER_ISV = AddCategoryNode(ref view, MAIN_MENU_AUTH_USER_ISV, MAIN_MENU_AUTH_USER_ISV, ""); L_Categ.Add(Tnode_AUTH_USER_ISV); QueryTreeNode Tnode_AUTH_HEALTH_CARE = AddCategoryNode(ref view, MAIN_MENU_AUTH_HEALTH_CARE, MAIN_MENU_AUTH_HEALTH_CARE, ""); L_Categ.Add(Tnode_AUTH_HEALTH_CARE); if (Las_NameCat != null) { foreach (SettingIRPClass item in Las_NameCat) { if ((item.IS_TESTING_REQUEST) && (RolesUsers.Admin.ToString() != Role)) { continue; } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Provider.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role)) { if (TypeStatus.LT1 == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_CUST_STATION_LIST1.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Provider.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role)) { if (TypeStatus.LT2 == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_CUST_STATION_LIST2.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Provider.ToString() == Role) || (RolesUsers.Government.ToString() == Role) || (RolesUsers.HealthCare.ToString() == Role) || (RolesUsers.Guest.ToString() == Role) || (RolesUsers.Government_Healthcare.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role)) { if (TypeStatus.PUB == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_PUBLIC_VIEW_SPECTRUM_MANAGEMENT.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Provider.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role)) { if (TypeStatus.CUS == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_USER_CUST_STATION_LIST.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Provider.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role)) { if (TypeStatus.DSL == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_USER_DELEG_STATION_LIST.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.Government.ToString() == Role) || (RolesUsers.Provider_Government.ToString() == Role) || (RolesUsers.Government_Healthcare.ToString() == Role)) { if (TypeStatus.ISV == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_AUTH_USER_ISV.ChildNodes); } } if ((RolesUsers.Admin.ToString() == Role) || (RolesUsers.HealthCare.ToString() == Role) || (RolesUsers.Provider_Healthcare.ToString() == Role) || (RolesUsers.Government_Healthcare.ToString() == Role)) { if (TypeStatus.HCC == item.STATUS_) { AddNode(ref view, item.STATUS_.ToString(), item.ID, item.NAME, item.NAME, item.DESCRIPTION, ref Tnode_AUTH_HEALTH_CARE.ChildNodes); } } } } view.Root.ChildNodes = L_Categ.ToArray(); }