DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Sale/crm_seorder.cs

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

namespace Business.Domain
{
    /// <summary>
    ///销售订单表
    /// </summary>
    [Comment("销售订单表")]
    [CollectionName("dopbase", "crm_seorder")]
    [Index(nameof(bill_no), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class crm_seorder : BaseEntity
    {
        ///// <summary>
        ///// 销售订单id
        ///// </summary>
        //[Key]
        //[Comment("销售订单id")]
        //public long seorder_id { get; set; }

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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