/*
|
*代码由框架生成,任何更改都可能导致被代码生成器覆盖
|
*如果数据库字段发生变化，请在代码生器重新生成此Model
|
*/
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA.Entity.SystemModels;
|
|
namespace WIDESEA.Entity.DomainModels
|
{
|
[Entity(TableCnName = "当前盘点任务视图",TableName = "VV_QueryCurrentCheckTask")]
|
public class VV_QueryCurrentCheckTask:BaseEntity
|
{
|
/// <summary>
|
///盘点头ID
|
/// </summary>
|
[Display(Name ="盘点头ID")]
|
[Column(TypeName="uniqueidentifier")]
|
[Required(AllowEmptyStrings=false)]
|
public Guid stockhead_id { get; set; }
|
|
/// <summary>
|
///盘点编号
|
/// </summary>
|
[Display(Name ="盘点编号")]
|
[MaxLength(80)]
|
[Column(TypeName="nvarchar(80)")]
|
[Required(AllowEmptyStrings=false)]
|
public string stockhead_number { get; set; }
|
|
/// <summary>
|
///释放人
|
/// </summary>
|
[Display(Name ="释放人")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockhead_releaseby { get; set; }
|
|
/// <summary>
|
///释放时间
|
/// </summary>
|
[Display(Name ="释放时间")]
|
[Column(TypeName="datetime")]
|
public DateTime? stockhead_releasetime { get; set; }
|
|
/// <summary>
|
///等级
|
/// </summary>
|
[Display(Name ="等级")]
|
[Column(TypeName="int")]
|
public int? stockhead_grade { get; set; }
|
|
/// <summary>
|
///创建人
|
/// </summary>
|
[Display(Name ="创建人")]
|
[MaxLength(20)]
|
[Column(TypeName="varchar(20)")]
|
[Required(AllowEmptyStrings=false)]
|
public string stockhead_creator { get; set; }
|
|
/// <summary>
|
///创建时间
|
/// </summary>
|
[Display(Name ="创建时间")]
|
[Column(TypeName="datetime")]
|
[Required(AllowEmptyStrings=false)]
|
public DateTime stockhead_createtime { get; set; }
|
|
/// <summary>
|
///盘点类型
|
/// </summary>
|
[Display(Name ="盘点类型")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockhead_type { get; set; }
|
|
[Display(Name = "捆号")]
|
[MaxLength(40)]
|
[Column(TypeName = "nvarchar(40)")]
|
public string task_areid { get; set; }
|
|
[Display(Name = "任务类型")]
|
[MaxLength(40)]
|
[Column(TypeName = "nvarchar(40)")]
|
public string task_type { get; set; }
|
/// <summary>
|
///物料名称
|
/// </summary>
|
[Display(Name ="物料名称")]
|
[MaxLength(400)]
|
[Column(TypeName="nvarchar(400)")]
|
[Required(AllowEmptyStrings=false)]
|
public string materiel_name { get; set; }
|
|
/// <summary>
|
///物料ID
|
/// </summary>
|
[Display(Name ="物料ID")]
|
[MaxLength(200)]
|
[Column(TypeName="nvarchar(200)")]
|
[Required(AllowEmptyStrings=false)]
|
public string materiel_id { get; set; }
|
|
/// <summary>
|
///单据明细ID
|
/// </summary>
|
[Key]
|
[Display(Name ="单据明细ID")]
|
[Column(TypeName="uniqueidentifier")]
|
[Required(AllowEmptyStrings=false)]
|
public Guid stockdtl_id { get; set; }
|
|
/// <summary>
|
///区域ID
|
/// </summary>
|
[Display(Name ="区域ID")]
|
[MaxLength(80)]
|
[Column(TypeName="nvarchar(80)")]
|
public string stockdtl_areid { get; set; }
|
|
/// <summary>
|
///明细状态
|
/// </summary>
|
[Display(Name ="明细状态")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockdtl_state { get; set; }
|
|
/// <summary>
|
///任务ID
|
/// </summary>
|
[Display(Name ="任务ID")]
|
[Column(TypeName="uniqueidentifier")]
|
[Required(AllowEmptyStrings=false)]
|
public Guid task_id { get; set; }
|
|
/// <summary>
|
///任务状态
|
/// </summary>
|
[Display(Name ="任务状态")]
|
[MaxLength(80)]
|
[Column(TypeName="nvarchar(80)")]
|
[Required(AllowEmptyStrings=false)]
|
public string task_state { get; set; }
|
|
/// <summary>
|
///托盘号
|
/// </summary>
|
[Display(Name ="托盘号")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
[Required(AllowEmptyStrings=false)]
|
public string task_barcode { get; set; }
|
|
/// <summary>
|
///出库数量
|
/// </summary>
|
[Display(Name ="出库数量")]
|
[DisplayFormat(DataFormatString="18,3")]
|
[Column(TypeName="decimal")]
|
[Required(AllowEmptyStrings=false)]
|
public decimal task_qty { get; set; }
|
|
/// <summary>
|
///批号（供应商）
|
/// </summary>
|
[Display(Name ="批号（供应商）")]
|
[MaxLength(100)]
|
[Column(TypeName="nvarchar(100)")]
|
public string task_lotnumber { get; set; }
|
|
/// <summary>
|
///来源货位
|
/// </summary>
|
[Display(Name ="来源货位")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string task_fromlocationid { get; set; }
|
|
/// <summary>
|
///出库地址
|
/// </summary>
|
[Display(Name ="出库地址")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string task_outhsstation { get; set; }
|
|
/// <summary>
|
///出库站台
|
/// </summary>
|
[Display(Name ="出库站台")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string task_outstation { get; set; }
|
|
/// <summary>
|
///调度时间
|
/// </summary>
|
[Display(Name ="调度时间")]
|
[Column(TypeName="datetime")]
|
public DateTime? task_dispatchertime { get; set; }
|
|
/// <summary>
|
///任务创建人
|
/// </summary>
|
[Display(Name ="任务创建人")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
[Required(AllowEmptyStrings=false)]
|
public string task_creator { get; set; }
|
|
/// <summary>
|
///任务创建时间
|
/// </summary>
|
[Display(Name ="任务创建时间")]
|
[Column(TypeName="datetime")]
|
[Required(AllowEmptyStrings=false)]
|
public DateTime task_createtime { get; set; }
|
|
/// <summary>
|
///实际数量
|
/// </summary>
|
[Display(Name ="实际数量")]
|
[DisplayFormat(DataFormatString="18,3")]
|
[Column(TypeName="decimal")]
|
[Required(AllowEmptyStrings=false)]
|
public decimal actualqty { get; set; }
|
|
|
}
|
}
|
