AdoS0Customer.cs 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. namespace Admin.NET.Plugin.AiDOP.Entity.S0.Sales;
  2. /// <summary>
  3. /// 客户主数据(S0 Sales / sales_customer)
  4. /// </summary>
  5. [SugarTable("ado_s0_sales_customer", "S0 客户主数据")]
  6. [SugarIndex("uk_ado_s0_sales_customer_code", nameof(Code), OrderByType.Asc, true)]
  7. public class AdoS0Customer
  8. {
  9. [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
  10. public long Id { get; set; }
  11. [SugarColumn(ColumnDescription = "关联公司 ID", ColumnDataType = "bigint")]
  12. public long CompanyRefId { get; set; }
  13. [SugarColumn(ColumnDescription = "关联工厂 ID", ColumnDataType = "bigint")]
  14. public long FactoryRefId { get; set; }
  15. [SugarColumn(ColumnDescription = "客户编码", Length = 100)]
  16. public string Code { get; set; } = string.Empty;
  17. [SugarColumn(ColumnDescription = "客户名称", Length = 200)]
  18. public string Name { get; set; } = string.Empty;
  19. [SugarColumn(ColumnDescription = "英文名称", Length = 200, IsNullable = true)]
  20. public string? NameEn { get; set; }
  21. [SugarColumn(ColumnDescription = "客户类型", Length = 50, IsNullable = true)]
  22. public string? CustomerType { get; set; }
  23. [SugarColumn(ColumnDescription = "联系人", Length = 100, IsNullable = true)]
  24. public string? ContactPerson { get; set; }
  25. [SugarColumn(ColumnDescription = "联系电话", Length = 50, IsNullable = true)]
  26. public string? ContactPhone { get; set; }
  27. [SugarColumn(ColumnDescription = "地址", Length = 500, IsNullable = true)]
  28. public string? Address { get; set; }
  29. [SugarColumn(ColumnDescription = "禁用状态", Length = 50)]
  30. public string ForbidStatus { get; set; } = "normal";
  31. [SugarColumn(ColumnDescription = "币种", Length = 20, IsNullable = true)]
  32. public string? Currency { get; set; }
  33. [SugarColumn(ColumnDescription = "是否含税", ColumnDataType = "boolean")]
  34. public bool IsTaxIncluded { get; set; } = true;
  35. [SugarColumn(ColumnDescription = "主销售员", Length = 100, IsNullable = true)]
  36. public string? PrimarySales { get; set; }
  37. [SugarColumn(ColumnDescription = "备用销售员", Length = 100, IsNullable = true)]
  38. public string? BackupSales { get; set; }
  39. [SugarColumn(ColumnDescription = "客户等级")]
  40. public int CustomerLevel { get; set; } = 1;
  41. [SugarColumn(ColumnDescription = "备注", Length = 1000, IsNullable = true)]
  42. public string? Remark { get; set; }
  43. [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
  44. public bool IsEnabled { get; set; } = true;
  45. [SugarColumn(ColumnDescription = "创建时间")]
  46. public DateTime CreatedAt { get; set; } = DateTime.Now;
  47. [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
  48. public DateTime? UpdatedAt { get; set; }
  49. }