private void CreateProductMenu(PXGraph graph, PXDropDown dd) { PXListItem liall = new PXListItem(PXMessages.LocalizeNoPrefix(PX.SM.Messages.SearchProduct)); dd.Items.Add(liall); foreach (PXResult result in PXSelect <SPWikiProduct> .Select(graph)) { SPWikiProduct wc = result[typeof(SPWikiProduct)] as SPWikiProduct; PXListItem li = new PXListItem(wc.Description, wc.ProductID); dd.Items.Add(li); } for (int i = 0; i < dd.Items.Count; i++) { if (ProductID == dd.Items[i].Value) { dd.SelectedIndex = i; } } string path = PXUrl.SiteUrlWithPath(); path += path.EndsWith("/") ? "" : "/"; var url = string.Format("{0}Search/{1}?query={2}&adv=1", path, this.ResolveClientUrl("~/Search/Wiki.aspx"), txtSearch.Value); url = url + "&wikiid=" + WikiID + "&wikinumber=" + WikiNumber + "&categoryID=" + CategoryID + "&productID=" + SearchCaptionProduct.Value + "&orderID=" + OrderID + "&isWiki=" + IsWiki + "&globalsearchcaption=" + Globalsearchcaption; }
private void InitHeader(Guid pageID) { PXResult <WikiPage, WikiPageLanguage> result = (PXResult <WikiPage, WikiPageLanguage>) PXSelectJoin <WikiPage, InnerJoin <WikiPageLanguage, On <WikiPageLanguage.pageID, Equal <WikiPage.pageID> > >, Where <WikiPage.pageID, Equal <Required <WikiPage.pageID> > > > .SelectWindowed(new PXGraph(), 0, 1, pageID); PXResult <KBResponseSummary> resultsummary = (PXResult <KBResponseSummary>) PXSelect <KBResponseSummary, Where <KBResponseSummary.pageID, Equal <Required <KBResponseSummary.pageID> > > > .SelectWindowed(new PXGraph(), 0, 1, pageID); if (result != null) { WikiPage wp = result[typeof(WikiPage)] as WikiPage; WikiPageLanguage wpl = result[typeof(WikiPageLanguage)] as WikiPageLanguage; KBResponseSummary kbrs = new KBResponseSummary(); if (resultsummary != null) { kbrs = resultsummary[typeof(KBResponseSummary)] as KBResponseSummary; } PXKB.Text = wp.Name + ": " + wpl.Title; PXCategori.Text = PXMessages.LocalizeNoPrefix(Msg.Category) + ": "; bool firstcategory = false; foreach (PXResult <SPWikiCategoryTags, SPWikiCategory> category in PXSelectJoin <SPWikiCategoryTags, InnerJoin <SPWikiCategory, On <SPWikiCategory.categoryID, Equal <SPWikiCategoryTags.categoryID> > >, Where <SPWikiCategoryTags.pageID, Equal <Required <SPWikiCategoryTags.pageID> > > > .Select(new PXGraph(), pageID)) { SPWikiCategory wc = category[typeof(SPWikiCategory)] as SPWikiCategory; if (firstcategory) { PXCategori.Text = PXCategori.Text + ", "; } PXCategori.Text = PXCategori.Text + wc.Description; firstcategory = true; } PXProduct.Text = PXMessages.LocalizeNoPrefix(Msg.AppliesTo) + ": "; bool firstproduct = false; foreach (PXResult <SPWikiProductTags, SPWikiProduct> category in PXSelectJoin <SPWikiProductTags, InnerJoin <SPWikiProduct, On <SPWikiProduct.productID, Equal <SPWikiProductTags.productID> > >, Where <SPWikiProductTags.pageID, Equal <Required <SPWikiProductTags.pageID> > > > .Select(new PXGraph(), pageID)) { SPWikiProduct wc = category[typeof(SPWikiProduct)] as SPWikiProduct; if (firstproduct) { PXProduct.Text = PXProduct.Text + ", "; } PXProduct.Text = PXProduct.Text + wc.Description; firstproduct = true; } PXKBName.Text = PXMessages.LocalizeNoPrefix(Msg.Article) + ": " + wp.Name + ' '; PXCreateDate.Text = PXMessages.LocalizeNoPrefix(Msg.CreateDate) + ": " + wp.CreatedDateTime; PXLastPublished.Text = PXMessages.LocalizeNoPrefix(Msg.LastModified) + ": " + wpl.LastPublishedDateTime + ' '; PXViews.Text = PXMessages.LocalizeNoPrefix(Msg.Views) + ": " + kbrs.Views.ToString() + ' '; PXRating.Text = PXMessages.LocalizeNoPrefix(Msg.Rating) + ": "; if (kbrs != null && kbrs.Markcount != null && kbrs.Markcount != 0 && kbrs.Marksummary != null && kbrs.Marksummary != 0) { int AvRate = (int)((int)kbrs.Marksummary / (int)kbrs.Markcount); Int32 Marksummary = (int)kbrs.Marksummary; Int32 Markcount = (int)kbrs.Markcount; double dAvRate = (double)Marksummary / (double)Markcount; PXdAvRate.Text = "(" + Math.Round(dAvRate, 2).ToString() + ")"; switch (AvRate) { case 0: PXImage1.ImageUrl = "main@FavoritesGray"; PXImage2.ImageUrl = "main@FavoritesGray"; PXImage3.ImageUrl = "main@FavoritesGray"; PXImage4.ImageUrl = "main@FavoritesGray"; PXImage5.ImageUrl = "main@FavoritesGray"; break; case 1: PXImage1.ImageUrl = "main@Favorites"; PXImage2.ImageUrl = "main@FavoritesGray"; PXImage3.ImageUrl = "main@FavoritesGray"; PXImage4.ImageUrl = "main@FavoritesGray"; PXImage5.ImageUrl = "main@FavoritesGray"; break; case 2: PXImage1.ImageUrl = "main@Favorites"; PXImage2.ImageUrl = "main@Favorites"; PXImage3.ImageUrl = "main@FavoritesGray"; PXImage4.ImageUrl = "main@FavoritesGray"; PXImage5.ImageUrl = "main@FavoritesGray"; break; case 3: PXImage1.ImageUrl = "main@Favorites"; PXImage2.ImageUrl = "main@Favorites"; PXImage3.ImageUrl = "main@Favorites"; PXImage4.ImageUrl = "main@FavoritesGray"; PXImage5.ImageUrl = "main@FavoritesGray"; break; case 4: PXImage1.ImageUrl = "main@Favorites"; PXImage2.ImageUrl = "main@Favorites"; PXImage3.ImageUrl = "main@Favorites"; PXImage4.ImageUrl = "main@Favorites"; PXImage5.ImageUrl = "main@FavoritesGray"; break; case 5: PXImage1.ImageUrl = "main@Favorites"; PXImage2.ImageUrl = "main@Favorites"; PXImage3.ImageUrl = "main@Favorites"; PXImage4.ImageUrl = "main@Favorites"; PXImage5.ImageUrl = "main@Favorites"; break; default: PXImage1.ImageUrl = "main@FavoritesGray"; PXImage2.ImageUrl = "main@FavoritesGray"; PXImage3.ImageUrl = "main@FavoritesGray"; PXImage4.ImageUrl = "main@FavoritesGray"; PXImage5.ImageUrl = "main@FavoritesGray"; break; } } } }