S0DictDataSeedData.cs 4.8 KB

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