S0DictDataSeedData.cs 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. namespace Admin.NET.Plugin.AiDOP;
  2. /// <summary>
  3. /// S0 业务字典值种子(灌入 SysDictData,与 S0DictTypeSeedData 配套)
  4. /// </summary>
  5. [IncreSeed]
  6. public class S0DictDataSeedData : ISqlSugarEntitySeedData<SysDictData>
  7. {
  8. public IEnumerable<SysDictData> HasData()
  9. {
  10. var ct = DateTime.Parse("2022-02-10 00:00:00");
  11. var types = new S0DictTypeSeedData().HasData().ToList();
  12. var materialTypeId = types[0].Id;
  13. var plCategoryId = types[1].Id;
  14. var stockTypeId = types[2].Id;
  15. var specialReqTypeId = types[3].Id;
  16. var materialAttributeId = types[4].Id;
  17. var customerTypeId = types[5].Id;
  18. var currencyId = types[6].Id;
  19. var forbidStatusId = types[7].Id;
  20. long seq = 1329900100001L;
  21. return new[]
  22. {
  23. // ── s0_material_type ──
  24. D(seq++, materialTypeId, "原材料", "raw", 100, ct),
  25. D(seq++, materialTypeId, "半成品", "semi", 101, ct),
  26. D(seq++, materialTypeId, "成品", "finished", 102, ct),
  27. D(seq++, materialTypeId, "辅料", "aux", 103, ct),
  28. D(seq++, materialTypeId, "工装夹具", "fixture", 104, ct),
  29. D(seq++, materialTypeId, "包装件", "packaging", 105, ct),
  30. // ── s0_pl_category ──
  31. D(seq++, plCategoryId, "采购件", "purchase", 100, ct),
  32. D(seq++, plCategoryId, "自制件", "manufacture", 101, ct),
  33. D(seq++, plCategoryId, "委外件", "outsource", 102, ct),
  34. // ── s0_stock_type ──
  35. D(seq++, stockTypeId, "正常库存", "normal", 100, ct),
  36. D(seq++, stockTypeId, "待检库存", "inspection", 101, ct),
  37. D(seq++, stockTypeId, "寄售库存", "consigned", 102, ct),
  38. D(seq++, stockTypeId, "安全库存", "safety", 103, ct),
  39. // ── s0_special_req_type ──
  40. D(seq++, specialReqTypeId, "常规", "common", 100, ct),
  41. D(seq++, specialReqTypeId, "加急", "urgent", 101, ct),
  42. D(seq++, specialReqTypeId, "出口", "export", 102, ct),
  43. D(seq++, specialReqTypeId, "定制", "custom", 103, ct),
  44. // ── s0_material_attribute ──
  45. D(seq++, materialAttributeId, "标准件", "standard", 100, ct),
  46. D(seq++, materialAttributeId, "采购件", "purchase", 101, ct),
  47. D(seq++, materialAttributeId, "自制件", "manufacture", 102, ct),
  48. D(seq++, materialAttributeId, "委外件", "outsource", 103, ct),
  49. // ── s0_customer_type ──
  50. D(seq++, customerTypeId, "内销", "domestic", 100, ct),
  51. D(seq++, customerTypeId, "外销", "overseas", 101, ct),
  52. D(seq++, customerTypeId, "经销", "dealer", 102, ct),
  53. // ── s0_currency ──
  54. D(seq++, currencyId, "CNY", "CNY", 100, ct),
  55. D(seq++, currencyId, "USD", "USD", 101, ct),
  56. D(seq++, currencyId, "EUR", "EUR", 102, ct),
  57. D(seq++, currencyId, "JPY", "JPY", 103, ct),
  58. D(seq++, currencyId, "HKD", "HKD", 104, ct),
  59. // ── s0_forbid_status ──
  60. D(seq++, forbidStatusId, "正常", "normal", 100, ct),
  61. D(seq++, forbidStatusId, "禁用", "forbidden", 101, ct),
  62. };
  63. }
  64. private static SysDictData D(long id, long typeId, string label, string value, int order, DateTime ct) =>
  65. new()
  66. {
  67. Id = id,
  68. DictTypeId = typeId,
  69. Label = label,
  70. Value = value,
  71. OrderNo = order,
  72. Status = StatusEnum.Enable,
  73. CreateTime = ct,
  74. };
  75. }