using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; using Tiger.Model.Minsun; using Tiger.Model.Extensions; using Microsoft.SqlServer.Server; namespace Tiger.Model { /// /// 实体:库存信息 /// [Description("Primary:ID")] [Serializable] [SugarTable("V_WMS_ITEM_SUM")] public class V_WMS_ITEM_SUM : DbEntityWithAuth, iTableHasAuth { #region 构造函数 /// /// 实体:库存信息 /// public V_WMS_ITEM_SUM() {} #endregion #region 公共属性 /// /// 仓库 /// public string SUPP_LOTNO { get; set; } /// /// 仓库 /// public string WH_CODE { get; set; } /// /// 仓库 /// public string LOCATION_CODE { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 物料名称 /// public string ITEM_NAME { get; set; } /// /// 物料描述 /// public string ITEM_DESC { get; set; } /// /// 数量 /// public double ZK_QTY { get; set; } /// /// 单位 /// public string UNIT { get; set; } /// /// 单位 /// public DateTime FIRST_IN_DATE { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEMId))]//ClassA表中的WMS_ITEMId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 #endregion #region 公共方法 #endregion }//endClass }