StockHoldingLookups.cs 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. using System.Collections.Generic;
  2. using System.Linq;
  3. using System.Text;
  4. using InABox.Core;
  5. namespace Comal.Classes
  6. {
  7. public class StockHoldingLookups : EntityLookup<StockHolding>, ILookupDefinition<StockHolding, RequisitionItem>
  8. {
  9. public Filter<StockHolding> DefineFilter(RequisitionItem[] items)
  10. {
  11. var item = items?.SingleOrDefault();
  12. if (item == null)
  13. return DefineFilter();
  14. return new Filter<StockHolding>(x => x.Product.ID).IsEqualTo(item.Product.ID).And(x => x.Style.ID).IsEqualTo(item.Style.ID)
  15. .And(x => x.Qty)
  16. .IsGreaterThan(0.0F);
  17. }
  18. public override Columns<StockHolding> DefineColumns()
  19. {
  20. return base.DefineColumns()
  21. .Add(x => x.Location.Code)
  22. .Add(x => x.Location.Description)
  23. .Add(x => x.Style.Description)
  24. .Add(x => x.Job.JobNumber)
  25. .Add(x => x.Units)
  26. .Add(x => x.Dimensions.UnitSize);
  27. }
  28. private bool HasValue(Dictionary<string, object> values, string key)
  29. {
  30. return values.ContainsKey(key) && values[key] != null && (values[key] is string ? !string.IsNullOrWhiteSpace((string)values[key]) : true);
  31. }
  32. public override string FormatLookup(Dictionary<string, object> values, IEnumerable<string> exclude)
  33. {
  34. var result = new StringBuilder();
  35. result.AppendFormat("{0}: {1} @ {2} {3}", values["Location.Description"], values["Units"], values["UnitSize"],
  36. values["Product.Units.Description"]);
  37. if (HasValue(values, "Style.Description"))
  38. result.AppendFormat(" ({0})", values["Style.Description"]);
  39. if (HasValue(values, "Job.JobNumber"))
  40. result.AppendFormat(" - Job {0}", values["Job.JobNumber"]);
  41. return result.ToString();
  42. }
  43. public override Filter<StockHolding> DefineFilter()
  44. {
  45. return new Filter<StockHolding>(x => x.ID).IsEqualTo(CoreUtils.FullGuid);
  46. }
  47. public override SortOrder<StockHolding> DefineSortOrder()
  48. {
  49. return new SortOrder<StockHolding>(x => x.Location.Code).ThenBy(x => x.Job.JobNumber);
  50. }
  51. }
  52. }