public OPResult SearchData() { if (StorageID == default(int)) { return(new OPResult { IsSucceed = false, Message = "请选择分货仓库." }); } //if (OrganizationIDArray == null || OrganizationIDArray.Count() == 0) //{ // return new OPResult { IsSucceed = false, Message = "请选择分货机构." }; //} if (Styles == null || Styles.Count() == 0) { return(new OPResult { IsSucceed = false, Message = "请选择分货款式." }); } var stocks = ReportDataContext.GetAvailableStock(StorageID, Styles); var pids = stocks.Select(o => o.ProductID); var orders = this.GetSubordinateOrderAggregation(pids); var table = this.GenerateDataTable(orders); pids = orders.Select(o => o.ProductID).Distinct();//可用库存和订单交集的productid var products = _linqOP.Search <ViewProduct>(o => pids.Contains(o.ProductID)).ToList().OrderBy(o => o.ProductCode); foreach (var p in products) { DataRow row = table.NewRow(); table.Rows.Add(row); row["SKU码"] = p.ProductCode; row["品牌"] = VMGlobal.PoweredBrands.Find(o => o.ID == p.BrandID).Code; row["款号"] = p.StyleCode; row["色号"] = VMGlobal.Colors.Find(o => o.ID == p.ColorID).Code; row["尺码"] = VMGlobal.Sizes.Find(o => o.ID == p.SizeID).Name; row["剩余可用库存"] = row["可用库存"] = stocks.First(s => s.ProductID == p.ProductID).Quantity; for (int i = 6; i < table.Columns.Count - 1; i++) { var on = table.Columns[i].ColumnName; var order = orders.FirstOrDefault(o => o.ProductID == p.ProductID && o.OrganizationName == on); if (order != null) { row[on] = order.Quantity; } } } Entities = table.DefaultView; return(new OPResult { IsSucceed = true }); }
protected override UriQuery GetUriQuery() { UriQuery query = base.GetUriQuery(); if (!string.IsNullOrEmpty(ArtistPick)) { query.Add("artist_pick", ArtistPick); } if (Variety.HasValue) { query.Add("variety", Variety.Value); } if (!string.IsNullOrEmpty(Distribution)) { query.Add("distribution", Distribution); } if (Adventurousness.HasValue) { query.Add("adventurousness", Adventurousness.Value); } if (!string.IsNullOrEmpty(SeedCatalog)) { query.Add("seed_catalog", SeedCatalog); } if (Description.Count() > 0) { foreach (Term description in Description) { query.Add("description", description); } } if (Styles.Count() > 0) { foreach (Term style in Styles) { query.Add("style", style); } } if (Moods.Count() > 0) { foreach (Term mood in Moods) { query.Add("mood", mood); } } if (MaxTempo.HasValue) { query.Add("max_tempo", MaxTempo.Value); } if (MinTempo.HasValue) { query.Add("min_tempo", MinTempo.Value); } if (MaxLoudness.HasValue) { query.Add("max_loudness", MaxLoudness.Value); } if (MinLoudness.HasValue) { query.Add("min_loudness", MinLoudness.Value); } if (ArtistMaxFamiliarity.HasValue) { query.Add("artist_max_familiarity", ArtistMaxFamiliarity.Value); } if (ArtistMinFamiliarity.HasValue) { query.Add("artist_min_familiarity", ArtistMinFamiliarity.Value); } if (!string.IsNullOrEmpty(ArtistEndYearAfter)) { query.Add("artist_end_year_after", ArtistEndYearAfter); } if (!string.IsNullOrEmpty(ArtistEndYearBefore)) { query.Add("artist_end_year_before", ArtistEndYearBefore); } if (!string.IsNullOrEmpty(ArtistStartYearAfter)) { query.Add("artist_start_year_after", ArtistStartYearAfter); } if (!string.IsNullOrEmpty(ArtistStartYearBefore)) { query.Add("artist_start_year_before", ArtistStartYearBefore); } if (SongMaxHotttnesss.HasValue) { query.Add("song_max_hotttnesss", SongMaxHotttnesss.Value); } if (SongMinHotttnesss.HasValue) { query.Add("song_min_hotttnesss", SongMinHotttnesss.Value); } if (ArtistMaxHotttnesss.HasValue) { query.Add("artist_max_hotttnesss", ArtistMaxHotttnesss.Value); } if (ArtistMinHotttnesss.HasValue) { query.Add("artist_min_hotttnesss", ArtistMinHotttnesss.Value); } if (MaxLongitude.HasValue) { query.Add("max_longitude", MaxLongitude.Value); } if (MinLongitude.HasValue) { query.Add("min_longitude", MinLongitude.Value); } if (MaxLatitude.HasValue) { query.Add("max_latitude", MaxLatitude.Value); } if (MinLatitude.HasValue) { query.Add("min_latitude", MinLatitude.Value); } if (MaxDanceability.HasValue) { query.Add("max_danceability", MaxDanceability.Value); } if (MinDanceability.HasValue) { query.Add("min_danceability", MinDanceability.Value); } if (MaxEnergy.HasValue) { query.Add("max_energy", MaxEnergy.Value); } if (MinEnergy.HasValue) { query.Add("min_energy", MinEnergy.Value); } if (!string.IsNullOrEmpty(Mode)) { query.Add("mode", Mode); } if (!string.IsNullOrEmpty(Key)) { query.Add("key", Key); } if (!string.IsNullOrEmpty(Sort)) { query.Add("sort", Sort); } return(query); }
//..................................................................... /// <summary> /// /// https://docs.microsoft.com/en-us/office/open-xml/how-to-apply-a-style-to-a-paragraph-in-a-word-processing-docxname /// /// Create a new style with the specified styleid and stylename and add it to the specified /// style definitions wbookpart. /// /// 追加一个新的额 STYLE , 样式。 /// </summary> /// <param name="styleDefinitionsPart"></param> /// <param name="styleid"></param> /// <param name="stylename"></param> private void AddNewStyle(StyleDefinitionsPart styleDefinitionsPart, string styleid, string stylename) { // Get access to the root element of the styles wbookpart. // Styles styles = styleDefinitionsPart.Styles; // test test test test test // foreach (Style stt in styles) { Console.WriteLine(stt.StyleName + "; " + stt.StyleId); } Console.WriteLine("styles.Count = " + styles.Count( )); // Create a new paragraph style and specify some of the properties. // Style style = new Style( ) { Type = StyleValues.Paragraph, StyleId = styleid, CustomStyle = true }; StyleName styleName1 = new StyleName( ) { Val = stylename }; BasedOn basedOn1 = new BasedOn( ) { Val = "Normal" }; NextParagraphStyle nextParagraphStyle1 = new NextParagraphStyle( ) { Val = "Normal" }; style.Append(styleName1); style.Append(basedOn1); style.Append(nextParagraphStyle1); //--------------------------------------------- Bold bold1 = new Bold( ); Color color1 = new Color( ) { ThemeColor = ThemeColorValues.Accent2 }; RunFonts font1 = new RunFonts( ) { Ascii = "Lucida Console" }; Italic italic1 = new Italic( ); // Specify a 12 point size. FontSize fontSize1 = new FontSize( ) { Val = "24" }; // Create the StyleRunProperties object and specify some of the run properties. StyleRunProperties styleRunProperties1 = new StyleRunProperties( ); styleRunProperties1.Append(bold1); styleRunProperties1.Append(color1); styleRunProperties1.Append(font1); styleRunProperties1.Append(fontSize1); styleRunProperties1.Append(italic1); //--------------------------------------------- // Add the run properties to the style. style.Append(styleRunProperties1); // Add the style to the styles wbookpart. styles.Append(style); return; }
public override string ToString() { UriQuery query = new UriQuery(BaseUrl); query.Add("api_key", ApiKey); query.Add("format", "json"); if (!string.IsNullOrEmpty(Name)) { query.Add("name", Name); } if (Styles.Count() > 0) { foreach (var style in Styles) { query.Add("style", style); } } if (Moods.Count() > 0) { foreach (var mood in Moods) { query.Add("mood", mood); } } if (!string.IsNullOrEmpty(ArtistEndYearAfter)) { query.Add("artist_end_year_after", ArtistEndYearAfter); } if (!string.IsNullOrEmpty(ArtistEndYearBefore)) { query.Add("artist_end_year_before", ArtistEndYearBefore); } if (!string.IsNullOrEmpty(ArtistStartYearAfter)) { query.Add("artist_start_year_after", ArtistStartYearAfter); } if (!string.IsNullOrEmpty(ArtistStartYearBefore)) { query.Add("artist_start_year_before", ArtistStartYearBefore); } if (Bucket.HasValue) { foreach (var bucket in Bucket.Value.GetBucketDescriptions()) { query.Add("bucket", bucket); } } if (Description.Count() > 0) { foreach (var description in Description) { query.Add("description", description); } } if (FuzzyMatch.HasValue) { query.Add("fuzzy_match", FuzzyMatch.Value); } if (Limit.HasValue) { query.Add("limit", Limit.Value); } if (MaxFamiliarity.HasValue) { query.Add("max_familiarity", MaxFamiliarity.Value); } if (MinFamiliarity.HasValue) { query.Add("min_familiarity", MinFamiliarity.Value); } if (MaxHotttnesss.HasValue) { query.Add("max_hotttnesss", MaxHotttnesss.Value); } if (MinHotttnesss.HasValue) { query.Add("min_hotttnesss", MinHotttnesss.Value); } if (RankType.HasValue) { query.Add("rank_type", RankType.Value.ToString().ToLower()); } if (Results.HasValue) { query.Add("results", Results.Value); } if (Start.HasValue) { query.Add("start", Start.Value); } if (Sort.HasValue) { query.Add("sort", EnumHelpers.GetDescription(Sort.Value)); } return(query.ToString()); }
public override string ToString() { UriQuery query = new UriQuery(BaseUrl); query.Add("api_key", ApiKey); query.Add("format", "json"); if (!string.IsNullOrEmpty(Title)) { query.Add("title", Title); } if (!string.IsNullOrEmpty(Artist)) { query.Add("artist", Artist); } if (!string.IsNullOrEmpty(Combined)) { query.Add("combined", Combined); } if (Description.Count() > 0) { foreach (var description in Description) { query.Add("description", description); } } if (Styles.Count() > 0) { foreach (var style in Styles) { query.Add("style", style); } } if (Moods.Count() > 0) { foreach (var mood in Moods) { query.Add("mood", mood); } } if (!string.IsNullOrEmpty(RankType)) { query.Add("rank_type", RankType); } if (!string.IsNullOrEmpty(ArtistID)) { query.Add("artist_id", ArtistID); } if (Results.HasValue) { query.Add("results", Results.Value); } if (Start.HasValue) { query.Add("start", Start.Value); } if (MaxTempo.HasValue) { query.Add("max_tempo", MaxTempo.Value); } if (MinTempo.HasValue) { query.Add("min_tempo", MinTempo.Value); } if (MaxLoudness.HasValue) { query.Add("max_loudness", MaxLoudness.Value); } if (MinLoudness.HasValue) { query.Add("min_loudness", MinLoudness.Value); } if (ArtistMaxFamiliarity.HasValue) { query.Add("artist_max_familiarity", ArtistMaxFamiliarity.Value); } if (ArtistMinFamiliarity.HasValue) { query.Add("artist_min_familiarity", ArtistMinFamiliarity.Value); } if (!string.IsNullOrEmpty(ArtistEndYearAfter)) { query.Add("artist_end_year_after", ArtistEndYearAfter); } if (!string.IsNullOrEmpty(ArtistEndYearBefore)) { query.Add("artist_end_year_before", ArtistEndYearBefore); } if (!string.IsNullOrEmpty(ArtistStartYearAfter)) { query.Add("artist_start_year_after", ArtistStartYearAfter); } if (!string.IsNullOrEmpty(ArtistStartYearBefore)) { query.Add("artist_start_year_before", ArtistStartYearBefore); } if (SongMaxHotttnesss.HasValue) { query.Add("song_max_hotttnesss", SongMaxHotttnesss.Value); } if (SongMinHotttnesss.HasValue) { query.Add("song_min_hotttnesss", SongMinHotttnesss.Value); } if (ArtistMaxHotttnesss.HasValue) { query.Add("artist_max_hotttnesss", ArtistMaxHotttnesss.Value); } if (ArtistMinHotttnesss.HasValue) { query.Add("artist_min_hotttnesss", ArtistMinHotttnesss.Value); } if (MaxLongitude.HasValue) { query.Add("max_longitude", MaxLongitude.Value); } if (MinLongitude.HasValue) { query.Add("min_longitude", MinLongitude.Value); } if (MaxLatitude.HasValue) { query.Add("max_latitude", MaxLatitude.Value); } if (MinLatitude.HasValue) { query.Add("min_latitude", MinLatitude.Value); } if (MaxDanceability.HasValue) { query.Add("max_danceability", MaxDanceability.Value); } if (MinDanceability.HasValue) { query.Add("min_danceability", MinDanceability.Value); } if (MaxEnergy.HasValue) { query.Add("max_energy", MaxEnergy.Value); } if (MinEnergy.HasValue) { query.Add("min_energy", MinEnergy.Value); } if (!string.IsNullOrEmpty(Mode)) { query.Add("mode", Mode); } if (!string.IsNullOrEmpty(Key)) { query.Add("key", Key); } if (Bucket.HasValue) { foreach (var bucket in Bucket.Value.GetBucketDescriptions()) { query.Add("bucket", bucket); } } if (!string.IsNullOrEmpty(Sort)) { query.Add("sort", Sort); } if (Limit.HasValue) { query.Add("limit", Limit.Value.ToString().ToLower()); } return(query.ToString()); }