ContractReviewFlow.cs 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. namespace Admin.NET.Plugin.AiDOP.Order;
  2. /// <summary>
  3. /// 合同评审流程节点表(ado_contract_review_flow)
  4. /// 与主表通过 ReviewRecID(主键关联)和 ReviewBillNo(业务编号关联)双字段关联
  5. /// </summary>
  6. [SugarTable("ado_contract_review_flow", "合同评审流程节点")]
  7. public class ContractReviewFlow
  8. {
  9. [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
  10. public int RecID { get; set; }
  11. /// <summary>关联主表 RecID(主键关联)</summary>
  12. [SugarColumn(ColumnName = "ReviewRecID")]
  13. public int ReviewRecID { get; set; }
  14. /// <summary>关联主表 BillNo(业务编号关联)</summary>
  15. [SugarColumn(ColumnName = "ReviewBillNo", Length = 64)]
  16. public string ReviewBillNo { get; set; } = string.Empty;
  17. /// <summary>审批环节编号(1=意见评审, 2=意见反馈, 3=二次评审, 4=领导意见, 5=合同盖章)</summary>
  18. [SugarColumn(ColumnName = "StageNo")]
  19. public int StageNo { get; set; }
  20. /// <summary>审批环节名称</summary>
  21. [SugarColumn(ColumnName = "StageName", Length = 64, IsNullable = true)]
  22. public string? StageName { get; set; }
  23. /// <summary>审批部门名称</summary>
  24. [SugarColumn(ColumnName = "Department", Length = 64, IsNullable = true)]
  25. public string? Department { get; set; }
  26. /// <summary>审批部门编号</summary>
  27. [SugarColumn(ColumnName = "DeptNo", Length = 64, IsNullable = true)]
  28. public string? DeptNo { get; set; }
  29. /// <summary>同一环节内的顺序(意见评审环节共4个子节点)</summary>
  30. [SugarColumn(ColumnName = "Seq", IsNullable = true)]
  31. public int? Seq { get; set; }
  32. /// <summary>审批人账号</summary>
  33. [SugarColumn(ColumnName = "ReviewerAccount", Length = 64, IsNullable = true)]
  34. public string? ReviewerAccount { get; set; }
  35. /// <summary>审批人姓名</summary>
  36. [SugarColumn(ColumnName = "ReviewerName", Length = 64, IsNullable = true)]
  37. public string? ReviewerName { get; set; }
  38. /// <summary>审批意见</summary>
  39. [SugarColumn(ColumnName = "Opinion", Length = 512, IsNullable = true)]
  40. public string? Opinion { get; set; }
  41. /// <summary>节点开始时间(进入审批时记录)</summary>
  42. [SugarColumn(ColumnName = "StartTime", IsNullable = true)]
  43. public DateTime? StartTime { get; set; }
  44. /// <summary>节点完成时间(审批完成/驳回时记录)</summary>
  45. [SugarColumn(ColumnName = "CompleteTime", IsNullable = true)]
  46. public DateTime? CompleteTime { get; set; }
  47. /// <summary>实际处理天数(CompleteTime - StartTime,自动计算)</summary>
  48. [SugarColumn(ColumnName = "ActualDays", IsNullable = true)]
  49. public decimal? ActualDays { get; set; }
  50. /// <summary>节点状态:pending / reviewing / approved / rejected</summary>
  51. [SugarColumn(ColumnName = "NodeStatus", Length = 32, IsNullable = true)]
  52. public string? NodeStatus { get; set; }
  53. }