AdoS0CustMaster.cs 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. namespace Admin.NET.Plugin.AiDOP.Entity.S0.Sales;
  2. /// <summary>
  3. /// 客户主数据(复刻 CustMaster)
  4. /// </summary>
  5. [SugarTable("CustMaster", "客户主数据(复刻 CustMaster)")]
  6. [SugarIndex("uk_CustMaster_factory_cust", nameof(FactoryRefId), OrderByType.Asc, nameof(Cust), OrderByType.Asc, IsUnique = true)]
  7. public class AdoS0CustMaster
  8. {
  9. [SugarColumn(ColumnName = "RecID", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
  10. public long Id { get; set; }
  11. [SugarColumn(ColumnName = "company_ref_id", ColumnDescription = "关联公司 ID", ColumnDataType = "bigint")]
  12. public long CompanyRefId { get; set; }
  13. [SugarColumn(ColumnName = "factory_ref_id", ColumnDescription = "关联工厂 ID", ColumnDataType = "bigint")]
  14. public long FactoryRefId { get; set; }
  15. [SugarColumn(ColumnName = "Domain", ColumnDescription = "工厂域编码", Length = 50, IsNullable = true)]
  16. public string? DomainCode { get; set; }
  17. [SugarColumn(ColumnName = "Cust", ColumnDescription = "客户编码", Length = 100)]
  18. public string Cust { get; set; } = string.Empty;
  19. [SugarColumn(ColumnName = "SortName", ColumnDescription = "客户简称", Length = 200, IsNullable = true)]
  20. public string? SortName { get; set; }
  21. [SugarColumn(ColumnName = "CustFullName", ColumnDescription = "客户全称/正式名称", Length = 500, IsNullable = true)]
  22. public string? CustFullName { get; set; }
  23. [SugarColumn(ColumnName = "Curr", ColumnDescription = "币种", Length = 20, IsNullable = true)]
  24. public string? Curr { get; set; }
  25. [SugarColumn(ColumnName = "Slspsn1", ColumnDescription = "主销售员", Length = 100, IsNullable = true)]
  26. public string? Slspsn1 { get; set; }
  27. [SugarColumn(ColumnName = "Slspsn2", ColumnDescription = "备用销售员", Length = 100, IsNullable = true)]
  28. public string? Slspsn2 { get; set; }
  29. [SugarColumn(ColumnName = "ShipTo", ColumnDescription = "发至", Length = 200, IsNullable = true)]
  30. public string? ShipTo { get; set; }
  31. [SugarColumn(ColumnName = "TaxClass", ColumnDescription = "税类型", Length = 50, IsNullable = true)]
  32. public string? TaxClass { get; set; }
  33. [SugarColumn(ColumnName = "TaxIn", ColumnDescription = "是否含税", ColumnDataType = "boolean")]
  34. public bool TaxIn { get; set; } = true;
  35. [SugarColumn(ColumnName = "cust_class", ColumnDescription = "客户级别", Length = 50, IsNullable = true)]
  36. public string? CustClass { get; set; }
  37. [SugarColumn(ColumnName = "address", ColumnDescription = "地址", Length = 500, IsNullable = true)]
  38. public string? Address { get; set; }
  39. [SugarColumn(ColumnName = "contact", ColumnDescription = "联系人", Length = 200, IsNullable = true)]
  40. public string? Contact { get; set; }
  41. [SugarColumn(ColumnName = "position", ColumnDescription = "职务", Length = 200, IsNullable = true)]
  42. public string? Position { get; set; }
  43. [SugarColumn(ColumnName = "contact_info", ColumnDescription = "联系方式", Length = 200, IsNullable = true)]
  44. public string? ContactInfo { get; set; }
  45. [SugarColumn(ColumnName = "CreditRating", ColumnDescription = "信用评级", Length = 50, IsNullable = true)]
  46. public string? CreditRating { get; set; }
  47. [SugarColumn(ColumnName = "Remarks", ColumnDescription = "备注", Length = 1000, IsNullable = true)]
  48. public string? Remarks { get; set; }
  49. [SugarColumn(ColumnName = "IsActive", ColumnDescription = "是否启用", ColumnDataType = "boolean")]
  50. public bool IsActive { get; set; } = true;
  51. [SugarColumn(ColumnName = "IsConfirm", ColumnDescription = "是否确认", ColumnDataType = "boolean")]
  52. public bool IsConfirm { get; set; }
  53. [SugarColumn(ColumnName = "CreateUser", ColumnDescription = "创建人", Length = 100, IsNullable = true)]
  54. public string? CreateUser { get; set; }
  55. [SugarColumn(ColumnName = "CreateTime", ColumnDescription = "创建时间")]
  56. public DateTime CreateTime { get; set; } = DateTime.Now;
  57. [SugarColumn(ColumnName = "UpdateUser", ColumnDescription = "更新人", Length = 100, IsNullable = true)]
  58. public string? UpdateUser { get; set; }
  59. [SugarColumn(ColumnName = "UpdateTime", ColumnDescription = "更新时间", IsNullable = true)]
  60. public DateTime? UpdateTime { get; set; }
  61. }