S0DictDataSeedData.cs 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  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. var docStatusId = types[8].Id;
  21. long seq = 1329900100001L;
  22. return new[]
  23. {
  24. // ── s0_material_type ──
  25. D(seq++, materialTypeId, "原材料", "raw", 100, ct),
  26. D(seq++, materialTypeId, "半成品", "semi", 101, ct),
  27. D(seq++, materialTypeId, "成品", "finished", 102, ct),
  28. D(seq++, materialTypeId, "辅料", "aux", 103, ct),
  29. D(seq++, materialTypeId, "工装夹具", "fixture", 104, ct),
  30. D(seq++, materialTypeId, "包装件", "packaging", 105, ct),
  31. // ── s0_pl_category ──
  32. D(seq++, plCategoryId, "采购件", "purchase", 100, ct),
  33. D(seq++, plCategoryId, "自制件", "manufacture", 101, ct),
  34. D(seq++, plCategoryId, "委外件", "outsource", 102, ct),
  35. // ── s0_stock_type ──
  36. D(seq++, stockTypeId, "正常库存", "normal", 100, ct),
  37. D(seq++, stockTypeId, "待检库存", "inspection", 101, ct),
  38. D(seq++, stockTypeId, "寄售库存", "consigned", 102, ct),
  39. D(seq++, stockTypeId, "安全库存", "safety", 103, ct),
  40. // ── s0_special_req_type ──
  41. D(seq++, specialReqTypeId, "常规", "common", 100, ct),
  42. D(seq++, specialReqTypeId, "加急", "urgent", 101, ct),
  43. D(seq++, specialReqTypeId, "出口", "export", 102, ct),
  44. D(seq++, specialReqTypeId, "定制", "custom", 103, ct),
  45. // ── s0_material_attribute ──
  46. D(seq++, materialAttributeId, "标准件", "standard", 100, ct),
  47. D(seq++, materialAttributeId, "采购件", "purchase", 101, ct),
  48. D(seq++, materialAttributeId, "自制件", "manufacture", 102, ct),
  49. D(seq++, materialAttributeId, "委外件", "outsource", 103, ct),
  50. // ── s0_customer_type ──
  51. D(seq++, customerTypeId, "内销", "domestic", 100, ct),
  52. D(seq++, customerTypeId, "外销", "overseas", 101, ct),
  53. D(seq++, customerTypeId, "经销", "dealer", 102, ct),
  54. // ── s0_currency ──
  55. D(seq++, currencyId, "CNY", "CNY", 100, ct),
  56. D(seq++, currencyId, "USD", "USD", 101, ct),
  57. D(seq++, currencyId, "EUR", "EUR", 102, ct),
  58. D(seq++, currencyId, "JPY", "JPY", 103, ct),
  59. D(seq++, currencyId, "HKD", "HKD", 104, ct),
  60. // ── s0_forbid_status ──
  61. D(seq++, forbidStatusId, "正常", "normal", 100, ct),
  62. D(seq++, forbidStatusId, "禁用", "forbidden", 101, ct),
  63. // ── s0_doc_status ──
  64. D(seq++, docStatusId, "草稿", "draft", 100, ct),
  65. D(seq++, docStatusId, "已发布", "released", 101, ct),
  66. D(seq++, docStatusId, "已作废", "obsolete", 102, ct),
  67. };
  68. }
  69. private static SysDictData D(long id, long typeId, string label, string value, int order, DateTime ct) =>
  70. new()
  71. {
  72. Id = id,
  73. DictTypeId = typeId,
  74. Label = label,
  75. Value = value,
  76. OrderNo = order,
  77. Status = StatusEnum.Enable,
  78. CreateTime = ct,
  79. };
  80. }