DEMOMySql/MicroServices/Business/Bussiness.Model/Sale/crm_seorder.cs

using Business.Core.Attributes;
using Business.Model;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Bussiness.Model.Sale
{
    /// <summary>
    ///销售订单表
    /// </summary>
    [Description("销售订单表")]
    [CollectionName("dopbase", "crm_seorder")]
    public class crm_seorder : BaseEntity
    {
        ///// <summary>
        ///// 销售订单id
        ///// </summary>
        //[Key]
        //[Description("销售订单id")]
        //public long seorder_id { get; set; }

        /// <summary>
        /// 订单编号
        /// </summary>
        [StringLength(50)]
        [Description("订单编号")]
        public string? bill_no { get; set; }

        /// <summary>
        /// 订单类别（销售、计划）
        /// </summary>
        [Description("订单类别(销售、计划)")]
        public int? order_type { get; set; }

        /// <summary>
        /// 贸易类型
        /// </summary>
        [Description("贸易类型")]
        public int? trade_type { get; set; }

        /// <summary>
        /// 销售订单类型
        /// </summary>
        /// </summary>
        [Description("销售订单类型")]
        public int? sale_style { get; set; }

        /// <summary>
        /// 销售订单类型编码
        /// </summary>
        [StringLength(80)]
        [Description("销售订单类型编码")]
        public string? sale_style_no { get; set; }

        /// <summary>
        /// 客户id
        /// </summary>
        [Description("客户id")]
        public int? custom_id { get; set; }

        /// <summary>
        /// 客户名称
        /// </summary>
        [Description("客户名称")]
        [StringLength(80)]
        public string? custom_name { get; set; }

        /// <summary>
        /// 客户编码
        /// </summary>
        [StringLength(80)]
        [Description("客户编码")]
        public string? custom_no { get; set; }

        /// <summary>
        /// 客户级别
        /// </summary>
        [StringLength(80)]
        [Description("客户级别")]
        public string? custom_level { get; set; }

        /// <summary>
        /// 签订日期
        /// </summary>
        [Description("签订日期")]
        public DateTime? date { get; set; }

        /// <summary>
        /// 采购下单日期
        /// </summary>
        [Description("采购下单日期")]
        public DateTime? rdate { get; set; }

        /// <summary>
        /// 加急级别
        /// </summary>
        [Description("加急级别")]
        public int? urgent { get; set; }

        /// <summary>
        /// 币种
        /// </summary>
        [StringLength(50)]
        [Description("币种")]
        public int? currency { get; set; }

        /// <summary>
        /// 汇率
        /// </summary>
        [Precision(20,8)]
        [Description("汇率")]
        public decimal? exchange_rate { get; set; }


        /// <summary>
        /// 制单人
        /// </summary>
        [StringLength(50)]
        [Description("制单人")]
        public string? biller { get; set; }

        /// <summary>
        /// 业务员工号
        /// </summary>
        [StringLength(50)]
        [Description("业务员工号")]
        public string? emp_no { get; set; }

        /// <summary>
        /// 业务员名称
        /// </summary>
        [StringLength(50)]
        [Description("业务员名称")]
        public string? emp_name { get; set; }

        /// <summary>
        /// 审核人
        /// </summary>
        [StringLength(50)]
        [Description("审核人")]
        public string? auditor { get; set; }

        /// <summary>
        /// 审核日期
        /// </summary>
        [Description("审核日期")]
        public DateTime? audit_date { get; set; }

        /// <summary>
        /// 订单状态
        /// </summary>
        [Description("订单状态")]
        public int? status { get; set; }

        /// <summary>
        /// 是否关闭1关闭0未关闭
        /// </summary>
        [DefaultValue(false)]
        [Description("是否关闭1关闭0未关闭")]
        public bool closed { get; set; }

        /// <summary>
        /// 操作时间
        /// </summary>
        [Description("操作时间")]
        public DateTime? op_time { get; set; }

        /// <summary>
        /// 订单来源
        /// </summary>
        [StringLength(255)]
        [Description("订单来源")]
        public string? bill_from { get; set; }

        /// <summary>
        /// 项目名称
        /// </summary>
        [Description("项目名称")]
        [StringLength(255)]
        public string? project_name { get; set; }

        /// <summary>
        /// 项目编号
        /// </summary>
        [StringLength(255)]
        [Description("项目编号")]
        public string? project_code { get; set; }

        /// <summary>
        /// 销售出库类型
        /// </summary>
        [Description("销售出库类型")]
        public int? out_stock_type { get; set; }

        /// <summary>
        /// 销售部门id
        /// </summary>
        [Description("销售部门id")]
        public long? sale_dept_id { get; set; }

        /// <summary>
        /// 销售部门名称
        /// </summary>
        [StringLength(80)]
        [Description("销售部门名称")]
        public string? sale_dept_name { get; set; }

        /// <summary>
        /// 销售部门编号
        /// </summary>
        [StringLength(80)]
        [Description("销售部门编号")]
        public string? sale_dept_code { get; set; }

        /// <summary>
        /// 创建部门id
        /// </summary>
        [Description("创建部门id")]
        public long? create_dept { get; set; }

        /// <summary>
        /// 计算ID
        /// </summary>
        [Description("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }
    }
}