AppointmentOA/api_v1/Appointment.Entity/Model/ApptSummary.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Text;

namespace Appointment.Entity
{
    /// <summary>
    /// 预订主单
    /// </summary>
    [Serializable]
    [SugarTable("appt_summary")]
    public class ApptSummary
    {
        /// <summary>
        /// 递增主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int? Id { get; set; }

        /// <summary>
        /// guid
        /// </summary>
        /// <remarks>
        /// 同一个订单的的(暂订单、确认单)GUID相同
        /// </remarks>
        public string Guid { get; set; }

        /// <summary>
        /// 所属用户
        /// </summary>        
        public string UserId { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 预订类型[appt_type.id] 
        /// 1- 默认模式,
        /// 2- 江南春模式,
        /// </summary>
        [SugarColumn(ColumnName = "appt_typeid")]
        public int? ApptTypeId { get; set; }



        /// <summary>
        /// 审核状态:见EnumAuditorStatus
        /// </summary>
        [SugarColumn(ColumnName = "auditor_status")]
        public int? AuditorStatus { get; set; }

        /// <summary>
        /// 待审核角色id:0-无 appt_type
        /// </summary>
        /// <remarks>
        /// 江南春模式=0
        /// </remarks>
        [SugarColumn(ColumnName = "auditor_id")]
        public int? AuditorId { get; set; }

        /// <summary>
        /// 转审账号(当有转审时，将AuditorId=0)
        /// </summary>
        [SugarColumn(ColumnName = "transfer_audit")]
        public string TransferAudit { get; set; }

        /// <summary>
        /// 订单类型预留字段
        /// </summary>
        [SugarColumn(ColumnName = "appt_type")]
        public int? ApptType { get; set; }

        /// <summary>
        /// 编号(生成确认单时产生)
        /// </summary>
        public string No { get; set; }



        /// <summary>
        /// 组织单位
        /// </summary>
        [SugarColumn(ColumnName = "buyer_name")]
        public string BuyerName { get; set; }

        /// <summary>
        /// 公司地址
        /// </summary>
        [SugarColumn(ColumnName = "buyer_address")]
        public string BuyerAddress { get; set; }

        /// <summary>
        /// 订单名称
        /// </summary>
        [SugarColumn(ColumnName = "buyer_title")]
        public string BuyerTitle { get; set; }

        /// <summary>
        /// 组织负责人
        /// </summary>
        [SugarColumn(ColumnName = "leader_name")]
        public string LeaderName { get; set; }

        /// <summary>
        /// 组织负责人电话
        /// </summary>
        [SugarColumn(ColumnName = "leader_mobile")]
        public string LeaderMobile { get; set; }



        /// <summary>
        /// 会议组房号
        /// </summary>
        [SugarColumn(ColumnName = "leader_room")]
        public string LeaderRoom { get; set; }

        /// <summary>
        /// 营销部跟单人(发起人)
        /// </summary>
        [SugarColumn(ColumnName = "sale_name")]
        public string SaleName { get; set; }

        /// <summary>
        /// 营销部跟单电话
        /// </summary>
        [SugarColumn(ColumnName = "sale_mobile")]
        public string SaleMobile { get; set; }

        /// <summary>
        /// 营销总监 手工写
        /// </summary>
        [SugarColumn(ColumnName = "sale_director")]
        public string SaleDirector { get; set; }

        /// <summary>
        /// 客房总备注
        /// </summary>
        [SugarColumn(ColumnName = "room_remark")]
        public string RoomRemark { get; set; }



        /// <summary>
        /// 会议室总备注
        /// </summary>
        [SugarColumn(ColumnName = "meeting_remark")]
        public string MeetingRemark { get; set; }

        /// <summary>
        /// 餐饮总备注
        /// </summary>
        [SugarColumn(ColumnName = "catering_remark")]
        public string CateringRemark { get; set; }

        /// <summary>
        /// 温泉总备注
        /// </summary>
        [SugarColumn(ColumnName = "spring_remark")]
        public string SpringRemark { get; set; }

        /// <summary>
        /// 编辑之前的主键
        /// </summary>
        public int? Pid { get; set; }

        /// <summary>
        /// 团队编号
        /// </summary>
        /// <remarks>
        /// 2021-6-16 江南春模式有效
        /// </remarks>
        [SugarColumn(ColumnName = "grp_no")]
        public string GrpNo { get; set; }



        /// <summary>
        /// 预定信息最小开始日期
        /// </summary>
        [SugarColumn(ColumnName = "start_day")]
        public DateTime StartDay { get; set; }

        /// <summary>
        /// 预定信息最大结果日期
        /// </summary>
        [SugarColumn(ColumnName = "end_day")]
        public DateTime EndDay { get; set; }

        /// <summary>
        /// 申请OA单状态:0-未占用资源,1-已占用资源
        /// </summary>
        [SugarColumn(ColumnName = "apply_oa")]
        public int ApplyOA { get; set; }

        /// <summary>
        /// 为销售员再次编辑提交的时间，文件对比中使用该时间，显示什么时候改了内容
        /// </summary>
        [SugarColumn(ColumnName = "alter_time")]
        public DateTime AlterTime { get; set; }

        // 关联表信息

        /// <summary>
        /// 客房预订明细列表
        /// </summary>
        [SqlSugar.SugarColumn(IsIgnore = true)]
        public List<ApptRoom> ApptRoomList { get; set; }

        /// <summary>
        /// 会议室预订明细列表
        /// </summary>
        [SqlSugar.SugarColumn(IsIgnore = true)]
        public List<ApptMeeting> ApptMeetingList { get; set; }

        /// <summary>
        /// 餐饮预订明细列表
        /// </summary>
        [SqlSugar.SugarColumn(IsIgnore = true)]
        public List<ApptCatering> ApptCateringList { get; set; }

        /// <summary>
        /// 温泉预订明细列表
        /// </summary>
        [SqlSugar.SugarColumn(IsIgnore = true)]
        public List<ApptSpring> ApptSpringList { get; set; }

        /// <summary>
        /// 自定义备注
        /// </summary>
        [SqlSugar.SugarColumn(IsIgnore = true)]
        public List<ApptRemark> ApptRemarks { get; set; }


    }
}