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

using Business.EntityFrameworkCore;
using Business.Models;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp.AuditLogging;

namespace Bussiness.Model.Tech
{
    /// <summary>
    ///销售订单表
    /// </summary>
    public class wms_seorder : BaseEntity
    {
        /// <summary>
        /// 销售订单id
        /// </summary>
        [Key]
        public long seorder_id { get; set; }

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

        /// <summary>
        /// 订单类别（销售、计划）
        /// </summary>
        public int order_type { get; set; }

        /// <summary>
        /// 贸易类型
        /// </summary>
        public int trade_type { get; set; }

        /// <summary>
        /// 销售订单类型
        /// </summary>
        public int sale_style { get; set; }

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

        /// <summary>
        /// 客户id
        /// </summary>
        public int custom_id { get; set; }

        /// <summary>
        /// 客户名称
        /// </summary>
        public int custom_name { get; set; }

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

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

        /// <summary>
        /// 签订日期
        /// </summary>
        public DateTime date { get; set; }

        /// <summary>
        /// 采购下单日期
        /// </summary>
        public DateTime rdate { get; set; }
  
        /// <summary>
        /// 加急级别
        /// </summary>
        public int urgent { get; set; }

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

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


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

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

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

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

        /// <summary>
        /// 审核日期
        /// </summary>
        public DateTime audit_date { get; set; }

        /// <summary>
        /// 是否关闭
        /// </summary>
        public int status { get; set; }

        /// <summary>
        /// 订单状态
        /// </summary>
        public bool closed { get; set; }

        /// <summary>
        /// 操作时间
        /// </summary>
        public DateTime op_time { get; set; }

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

        /// <summary>
        /// 提交人id
        /// </summary>
        public long project_name { get; set; }

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

        /// <summary>
        /// 销售出库类型
        /// </summary>
        public int out_stock_type { get; set; }

        /// <summary>
        /// 销售部门id
        /// </summary>
        public long sale_dept_id { get; set; }

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

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

        /// <summary>
        /// 创建部门id
        /// </summary>
        public long create_dept { get; set; }
    }
}