DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Sale/crm_seorderentry.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_seorderentry")]
    [Index(nameof(bill_no), nameof(entry_seq), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class crm_seorderentry : BaseEntity
    {
        ///// <summary>
        ///// 销售订单明细表id
        ///// </summary>
        //[Key]
        //[Comment("销售订单明细表id")]
        //public long seorderentry_id { get; set; }

        /// <summary>
        /// 销售订单id
        /// </summary>
        [Comment("销售订单id")]
        public long? seorder_id { get; set; }

        /// <summary>
        /// 销售订单明细业务id
        /// </summary>
        [Comment("销售订单明细业务id")]
        public long? seorderentry_id { get; set; }

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

        /// <summary>
        /// 行号
        /// </summary>
        [Comment("行号")]
        public int? entry_seq { get; set; }

        /// <summary>
        /// 对应代码
        /// </summary>
        [StringLength(255)]
        [Comment("对应代码")]
        public string map_number { get; set; }

        /// <summary>
        /// 代码名称
        /// </summary>
        [StringLength(255)]
        [Comment("代码名称")]
        public string map_name { get; set; }

        /// <summary>
        /// 产品代码
        /// </summary>
        [StringLength(255)]
        [Comment("产品代码")]
        public string item_number { get; set; }

        /// <summary>
        /// FMS旧料号
        /// </summary>
        [StringLength(255)]
        [Comment("FMS旧料号")]
        public string fms_number { get; set; }

        /// <summary>
        /// 产品名称
        /// </summary>
        [StringLength(255)]
        [Comment("产品名称")]
        public string item_name { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(255)]
        [Comment("规格型号")]
        public string specification { get; set; }

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

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

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

        /// <summary>
        /// 订单数量
        /// </summary>
        [Precision(20, 8)]
        [Comment("订单数量")]
        public decimal? qty { get; set; }

        /// <summary>
        /// 单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("单价")]
        public decimal? price { get; set; }

        /// <summary>
        /// 含税单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("含税单价")]
        public decimal? tax_price { get; set; }

        /// <summary>
        /// 金额
        /// </summary>
        [Precision(23, 10)]
        [Comment("金额")]
        public decimal? amount { get; set; }

        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? tax_rate { get; set; }

        /// <summary>
        /// 折扣率
        /// </summary>
        [Precision(23, 10)]
        [Comment("折扣率")]
        public decimal? discount_rate { get; set; }

        /// <summary>
        /// 折扣额
        /// </summary>
        [Precision(23, 10)]
        [Comment("折扣额")]
        public decimal? discount_amount { get; set; }

        /// <summary>
        /// 实际含税单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("实际含税单价")]
        public decimal? aux_price_discount { get; set; }

        /// <summary>
        /// 销项税额
        /// </summary>
        [Precision(23, 10)]
        [Comment("销项税额")]
        public decimal? tax_amtount { get; set; }

        /// <summary>
        /// 价税合计
        /// </summary>
        [Precision(23, 10)]
        [Comment("价税合计")]
        public decimal? total_amount { get; set; }

        /// <summary>
        /// 客户要求交期
        /// </summary>
        [Comment("客户要求交期")]
        public DateTime? plan_date { get; set; }

        /// <summary>
        /// 最终交货日期
        /// </summary>
        [Comment("最终交货日期")]
        public DateTime? date { get; set; }

        /// <summary>
        /// 计划员
        /// </summary>
        [StringLength(50)]
        [Comment("计划员")]
        public string planner_name { get; set; }

        /// <summary>
        /// 计划员_工号
        /// </summary>
        [StringLength(50)]
        [Comment("计划员_工号")]
        public string planner_no { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [StringLength(255)]
        [Comment("备注")]
        public string remark { get; set; }

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

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

        /// <summary>
        /// 客户订单行号
        /// </summary>
        [Comment("客户订单行号")]
        public int? custom_order_entryid { get; set; }

        /// <summary>
        /// 系统建议交期(产能)
        /// </summary>
        [Comment("系统建议交期(产能)")]
        public DateTime? sys_capacity_date { get; set; }

        /// <summary>
        ///调整建议交期
        /// </summary>
        [Comment("调整建议交期")]
        public DateTime? adjust_date { get; set; }

        /// <summary>
        ///调整建议交期
        /// </summary>
        [Comment("mrp关闭")]
        [DefaultValue(false)]
        public bool? mrp_closed { get; set; }

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

        /// <summary>
        /// 客户料号
        /// </summary>
        [StringLength(80)]
        [Comment("客户料号")]
        public string custom_order_itemno { get; set; }

        /// <summary>
        /// 数据状态标识 0停用 1启用
        /// </summary>
        [Comment("数据状态标识 0停用 1启用")]
        [DefaultValue(true)]
        public bool? state { get; set; }

        /// <summary>
        /// 评审状态
        /// </summary>
        [Comment("评审状态")]
        public int? rstate { get; set; }

        /// <summary>
        /// 评审次数
        /// </summary>
        [Comment("评审次数")]
        public int? rnumber { get; set; }

        /// <summary>
        /// 订单进度(1,新增 2,检查 3,评审 4,执行 5,发运) 暂定，如需调整需要调整引用位置
        /// </summary>
        [StringLength(255)]
        [Comment("订单进度")]
        public string progress { get; set; }

        /// <summary>
        /// 发货通知单数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("发货通知单数量")]
        public decimal? deliver_notice_count { get; set; }

        /// <summary>
        /// 发货数量（已出库数量）
        /// </summary>
        [Precision(23, 10)]
        [Comment("发货数量（已出库数量）")]
        public decimal? deliver_count { get; set; }

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

        /// <summary>
        /// 出库类型
        /// </summary>
        [StringLength(50)]
        [Comment("出库类型")]
        public string out_stock_type { get; set; }

        /// <summary>
        /// 是否完成检测，0未完成，1完成
        /// </summary>
        [Comment("是否完成检测，0未完成，1完成")]
        public bool? is_checked { get; set; }

        /// <summary>
        /// 系统建议交期(物料)
        /// </summary>
        [Comment("系统建议交期(物料)")]
        public DateTime? sys_material_date { get; set; }

        /// <summary>
        /// 合同编号
        /// </summary>
        [Comment("合同编号")]
        [StringLength(50)]
        public string contract_no { 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; }
    }
}