ProductDictionary.cs 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using Microsoft.AspNetCore.Mvc;
  6. using MySystem.Models;
  7. namespace MySystem
  8. {
  9. public class ProductDictionary
  10. {
  11. WebCMSEntities db = new WebCMSEntities();
  12. #region ProductFareTemp字典
  13. public Dictionary<string, string> getProductFareTempDic(int MerchantId)
  14. {
  15. List<ProductFareTemp> ProductFareTempList = db.ProductFareTemp.Where(m => m.MerchantId == MerchantId).ToList();
  16. Dictionary<string, string> ProductFareTempDic = new Dictionary<string, string>();
  17. foreach (ProductFareTemp subProductFareTemp in ProductFareTempList)
  18. {
  19. ProductFareTempDic.Add(subProductFareTemp.Id.ToString(), subProductFareTemp.Name.ToString());
  20. }
  21. return ProductFareTempDic;
  22. }
  23. #endregion
  24. #region 规格模板字典
  25. public Dictionary<string, string> getProductNormTempDic(int MerchantId)
  26. {
  27. List<ProductNormTemp> ProductNormTempList = db.ProductNormTemp.Where(m => m.MerchantId == MerchantId).ToList();
  28. Dictionary<string, string> ProductNormTempDic = new Dictionary<string, string>();
  29. foreach (ProductNormTemp subProductNormTemp in ProductNormTempList)
  30. {
  31. ProductNormTempDic.Add(subProductNormTemp.Id.ToString(), subProductNormTemp.Name.ToString());
  32. }
  33. return ProductNormTempDic;
  34. }
  35. #endregion
  36. #region Products字典
  37. public Dictionary<string, string> getProductsDic()
  38. {
  39. List<Products> ProductsList = db.Products.ToList();
  40. Dictionary<string, string> ProductsDic = new Dictionary<string, string>();
  41. foreach (Products subProducts in ProductsList)
  42. {
  43. ProductsDic.Add(subProducts.Id.ToString(), subProducts.ProductName.ToString());
  44. }
  45. return ProductsDic;
  46. }
  47. #endregion
  48. #region 根据字典key获取字典值
  49. public string getDictionaryNameByKey(Dictionary<string, string> data, string key)
  50. {
  51. if (data.ContainsKey(key))
  52. {
  53. return data[key];
  54. }
  55. return "";
  56. }
  57. public string getDictionaryNameById(Dictionary<int, string> data, int key)
  58. {
  59. if (data.ContainsKey(key))
  60. {
  61. return data[key];
  62. }
  63. return "";
  64. }
  65. public string getDictionaryNamesByKeys(Dictionary<string, string> data, string keys)
  66. {
  67. string result = "";
  68. string[] keylist = keys.Split(',');
  69. foreach (string subkey in keylist)
  70. {
  71. if (data.ContainsKey(subkey))
  72. {
  73. result += data[subkey] + ",";
  74. }
  75. }
  76. return result.TrimEnd(',');
  77. }
  78. #endregion
  79. }
  80. }