/*
|
*代码由框架生成,任何更改都可能导致被代码生成器覆盖
|
*如果数据库字段发生变化，请在代码生器重新生成此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_QueryCheckDifferenceInfo")]
|
public class VV_QueryCheckDifferenceInfo: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(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>
|
[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(100)]
|
[Column(TypeName="nvarchar(100)")]
|
public string stockdtl_lotnumber { get; set; }
|
|
/// <summary>
|
///明细状态
|
/// </summary>
|
[Display(Name ="明细状态")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockdtl_state { get; set; }
|
|
/// <summary>
|
///差异明细
|
/// </summary>
|
[Key]
|
[Display(Name ="差异明细")]
|
[Column(TypeName="uniqueidentifier")]
|
[Required(AllowEmptyStrings=false)]
|
public Guid stockrecord_id { get; set; }
|
|
/// <summary>
|
///库存数量
|
/// </summary>
|
[Display(Name ="库存数量")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Required(AllowEmptyStrings=false)]
|
public decimal stockrecord_qty { get; set; }
|
|
/// <summary>
|
///实际数量
|
/// </summary>
|
[Display(Name ="实际数量")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
public decimal? stockrecord_actualqty { get; set; }
|
|
/// <summary>
|
///当前类型
|
/// </summary>
|
[Display(Name ="当前类型")]
|
[MaxLength(80)]
|
[Column(TypeName="nvarchar(80)")]
|
public string stockrecord_type { get; set; }
|
|
/// <summary>
|
///当前状态
|
/// </summary>
|
[Display(Name ="当前状态")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockrecord_state { get; set; }
|
|
/// <summary>
|
///更新数量
|
/// </summary>
|
[Display(Name ="更新数量")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
public decimal? stockrecord_updateqty { get; set; }
|
|
/// <summary>
|
///托盘号
|
/// </summary>
|
[Display(Name ="托盘号")]
|
[MaxLength(100)]
|
[Column(TypeName="nvarchar(100)")]
|
public string stockrecord_sn { get; set; }
|
|
/// <summary>
|
///差异创建人
|
/// </summary>
|
[Display(Name ="差异创建人")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
public string stockrecord_creator { get; set; }
|
|
/// <summary>
|
///差异创建时间
|
/// </summary>
|
[Display(Name ="差异创建时间")]
|
[Column(TypeName="datetime")]
|
[Required(AllowEmptyStrings=false)]
|
public DateTime stockrecord_createtime { 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; }
|
|
|
}
|
}
|
