xiaomiMes/MainForm/Models/OrderTable.cs

using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace MainForm.Models
{
    ///<summary>
    ///订单信息表
    ///</summary>
    [SugarTable("OrderTable")]
    public partial class OrderTable
    {
        /// <summary>
        /// Desc:车间订单号
        /// Default:
        /// Nullable:False
        /// </summary>           
        [SugarColumn(ColumnDataType = "nvarchar", Length = 36, IsNullable = false, IsPrimaryKey = true)]
        public string WorkOrderNum { get; set; }

        /// <summary>
        /// Desc:订单状态
        /// Default:
        /// Nullable:False
        /// 未处理订单\正在处理订单\正在清料中\已完成订单
        /// </summary>           
        [SugarColumn(IsNullable = false)]
        public string WorkOrderStatus { get; set; }

        /// <summary>
        /// Desc:批次号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string BatchNumber { get; set; }

        /// <summary>
        /// Desc:产品型号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string ProductMtltmrk { get; set; }

        /// <summary>
        /// Desc:产品代号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string ProductNo { get; set; }

        /// <summary>
        /// Desc:产品名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string ProductName { get; set; }

        /// <summary>
        /// Desc:供应商代码
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string SupplierCode { get; set; }

        /// <summary>
        /// Desc:计划数量
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? PlannedQuantity { get; set; }

        /// <summary>
        /// Desc:已完成数量
        /// Default:
        /// Nullable:True
        /// </summary>           
        public int? CompletedQuantity { get; set; }

        /// <summary>
        /// Desc:计划标记
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string Plnsign { get; set; }

        /// <summary>
        /// Desc:需求日期
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string Soreqdat { get; set; }

        /// <summary>
        /// Desc:所属流程
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string Process { get; set; }

        /// <summary>
        /// Desc:订单创建时间
        /// Default:
        /// Nullable:False
        /// </summary>           
        [SugarColumn(IsNullable = false)]
        public DateTime CreatedTime { get; set; } = DateTime.Now;
    }
}