using SnapshotWinFormsApp.Repository.Enum; using SqlSugar; using System.ComponentModel; namespace SnapshotWinFormsApp.Entities.NewHotline; /// /// 工单表扩展 /// Id 和 Order.Id 相同 /// [SugarTable("order_snapshot")] [Description("工单表扩展")] public class OrderSnapshot : CreationSoftDeleteEntity { /// /// 行业Id /// 表的Id /// [SugarColumn(ColumnDescription = "行业Id")] public string IndustryId { get; set; } /// /// 行业名称 /// 表的Name /// [SugarColumn(ColumnDescription = "行业名称")] public string IndustryName { get; set; } /// /// 社区Id /// 表的Id /// [SugarColumn(ColumnDescription = "社区Id")] public string? CommunityId { get; set; } /// /// 社区名字 /// [SugarColumn(ColumnDescription = "社区名字")] public string? CommunityName { get; set; } /// /// 社区名字 /// [SugarColumn(ColumnDescription = "社区名字")] public string? CommunityFullName { get; set; } /// /// 作业类型 /// [SugarColumn(ColumnDescription = "作业类型")] public int? JobType { get; set; } /// /// 作业类型 /// [SugarColumn(ColumnDescription ="作业类型")] public string? JobTypeName { get; set; } /// /// 经营单位类别 /// [SugarColumn(ColumnDescription = "经营单位类别")] public string? BusinessUnitType { get; set; } /// /// 作业场所 /// [SugarColumn(ColumnDescription = "作业场所")] public string? Workplace { get; set; } /// /// 场所名称(多个场所使用 - 连接) /// [SugarColumn(ColumnDescription = "场所名称")] public string? WorkplaceName { get; set; } /// /// 作业区域 /// [SugarColumn(ColumnDescription = "作业区域")] public string? WorkArea { get; set; } /// /// 作业区域Id /// [SugarColumn(ColumnDescription = "作业区域Id")] public string? WorkAreaId { get; set; } /// /// 作业时间 /// [SugarColumn(ColumnDescription = "作业时间")] public DateTime? StartWorkTime { get; set; } /// /// 作业结束时间 /// [SugarColumn(ColumnDescription = "作业时间")] public DateTime? EndWorkTime { get; set; } /// /// 是否重点 /// [SugarColumn(ColumnDescription = "是否重点")] public bool? IsEmphasis { get; set; } #region 标记工单是否安全生产字段 /// /// 部门标记是否安全生产 /// [SugarColumn(ColumnDescription = "部门标记是否安全生产")] public bool? IsSafetyDepartment { get; set; } /// /// 标记人 /// [SugarColumn(ColumnDescription = "标记人")] public string? SignUserId { get; set; } /// /// 标记人 /// [SugarColumn(ColumnDescription = "标记人")] public string? SignUserName { get; set; } /// /// 标记时间 /// [SugarColumn(ColumnDescription = "标记时间")] public DateTime? SignTime { get; set; } /// /// 标记备注 /// [SugarColumn(ColumnDescription = "标记备注")] public string? SignRemark { get; set; } #endregion /// /// 部门是否存在安全隐患 /// [SugarColumn(ColumnDescription = "部门是否存在安全隐患")] public bool? IsDangerDepartment { get; set; } /// /// 部门是否属实 /// [SugarColumn(ColumnDescription = "部门是否属实")] public bool? IsTruthDepartment { get; set; } /// /// 部门是否整改 /// [SugarColumn(ColumnDescription = "部门是否整改")] public bool? IsRectifyDepartment { get; set; } /// /// 线索分类Id /// [SugarColumn(ColumnDescription = "线索分类")] public string? IndustryCase { get; set; } /// /// 小程序公开 /// [SugarColumn(ColumnDescription = "小程序公开")] public bool? IsAppOpened { get; set; } /// /// 合规类型 /// [SugarColumn(ColumnDescription = "合规类型")] public ECompliantType? CompliantType { get; set; } /// /// 发布工单时标记的工单标签 /// [SugarColumn(ColumnDescription = "工单标签", ColumnDataType = "json", IsJson = true, IsNullable = true)] public IList? Labels { get; set; } /// /// 发布工单时标记的工单标签(多个使用 | 分隔) /// [SugarColumn(ColumnDescription = "工单标签")] public string? LabelName { get; set; } /// /// 标签用户 /// [SugarColumn(ColumnDescription = "标签用户")] public string? LabelUserName { get; set; } /// /// 标签用户Id /// [SugarColumn(ColumnDescription = "标签用户Id")] public string? LabelUserId { get; set; } /// /// 标签时间 /// [SugarColumn(ColumnDescription = "标签时间")] public DateTime? LabelTime { get; set; } /// /// 工单办理: /// 是否申请追加奖励 /// [SugarColumn(ColumnDescription = "是否申请追加奖励")] public bool? IsAward { get; set; } /// /// 追加奖励人开户银行 /// [SugarColumn(ColumnDescription = "追加奖励人开户银行")] public string? AwardOpenBank { get; set; } /// /// 追加奖励人姓名 /// [SugarColumn(ColumnDescription = "追加奖励人姓名")] public string? AwardName { get; set; } /// /// 追加奖励人银行卡号 /// [SugarColumn(ColumnDescription = "追加奖励人银行卡号")] public string? AwardBankCardNo { get; set; } /// /// 追加奖励金额(元) /// [SugarColumn(ColumnDescription = "追加奖励金额(元)")] public double? AwardAmount { get; set; } /// /// 补充奖励类型 /// [SugarColumn(ColumnDescription = "补充奖励类型")] public string? ReplenishTypeId { get; set; } /// /// 补充奖励类型 /// [SugarColumn(ColumnDescription = "补充奖励类型")] public string? ReplenishTypeName { get; set; } /// /// 核实方式 /// [SugarColumn(ColumnDescription = "核实方式")] public string? VerifyType { get; set; } /// /// 是否按清单检查 /// [SugarColumn(ColumnDescription = "是否按清单检查")] public bool? IsCheckList { get; set; } #region 网格员回复 /// /// 网格员系统交互日志 /// [SugarColumn(ColumnDescription = "网格员系统交互日志")] public string? GuiderAccLog { get; set; } /// /// 网格员回复截止日期 /// [SugarColumn(ColumnDescription = "网格员回复截止日期")] public DateTime? DeadLine { get; set; } /// /// 网格员是否办理 /// [SugarColumn(ColumnDescription = "网格员是否办理")] public bool? IsDeal { get; set; } /// /// 网格E通编号 /// [SugarColumn(ColumnDescription = "网格E通编号")] public string? NetworkENumber { get; set; } /// /// 网格员是否属实 /// [SugarColumn(ColumnDescription = "网格员是否属实")] public bool? IsTruth { get; set; } /// /// 是否重复 /// [SugarColumn(ColumnDescription = "是否重复")] public bool? IsRepetition { get; set; } /// /// 是否隐患 /// [SugarColumn(ColumnDescription = "是否隐患")] public bool? IsDanger { get; set; } /// /// 网格员回复内容 /// [SugarColumn(ColumnDescription = "网格员回复内容", Length = 2048)] public string? NetworkRemark { get; set; } /// /// 网格员办理时间 /// [SugarColumn(ColumnDescription = "网格员办理时间")] public DateTime? ReplyDate { get; set; } /// /// 网格员姓名 /// [SugarColumn(ColumnDescription = "网格员姓名")] public string? MemberName { get; set; } /// /// 网格员电话 /// [SugarColumn(ColumnDescription = "网格员电话")] public string? MemberMobile { get; set; } /// /// 办理人账号 /// [SugarColumn(ColumnDescription = "办理人账号")] public string? ReplyUserName { get; set; } /// /// 办理部门 /// [SugarColumn(ColumnDescription = "办理部门")] public string? ReplyBMName { get; set; } /// /// 办理状态 1,7:流转 2:办结 3:退回 4:网格员签收 5:消息推送 6: 超时自动退单 /// [SugarColumn(ColumnDescription ="网格员办理状态")] public int? ReplyResultType { get; set; } #endregion /// /// 购气单位/个人名称 /// [SugarColumn(ColumnDescription = "购气单位/个人名称")] public string? CompanyName { get; set; } /// /// 发送网格员系统时间 /// [SugarColumn(ColumnDescription = "发送网格员系统时间")] public DateTime? SendGuidSystemTime { get; set; } /// /// 网格员系统回调时间 /// [SugarColumn(ColumnDescription = "网格员系统回调时间")] public DateTime? GuidSystemCallBackTime { get; set; } /// /// 网格员系统是否回调 /// [SugarColumn(ColumnDescription = "网格员系统是否回调", DefaultValue = "f")] public bool IsGuidSystemCallBack { get; set; } #region 重办信息 /// /// 重办原因Id /// [SugarColumn(ColumnDescription = "重办原因Id")] public string? SpecialReasonId { get; set; } /// /// 重办原因 /// [SugarColumn(ColumnDescription = "重办原因")] public string? SpecialReasonName { get; set; } #endregion /// /// 扩展字段 /// 如果别的系统希望通过界面收集某个字段, 然后我们系统不需要使用, 就可以放这里. /// 第三方系统在获取我们系统工单时直接把这个字段数据返回即可 /// [SugarColumn(ColumnDescription = "12345不使用的扩展字段,第三方系统使用")] public string? Attach { get; set; } }