| | |
| | | item.AUTH_ORG = input.AuthOption.CurOrg; |
| | | } |
| | | } |
| | | CurInvItem = inv; |
| | | |
| | | //检查物料数量,如果没有则查询雅达条码主档,把数量返回前端确认 |
| | | if (inv.Items.Any(q => q.QTY <= 0)) |
| | | if (CurInvItem.Items.Any(q => q.QTY <= 0)) |
| | | { |
| | | var qtyList = Biz.DataSource["YadaU9C"].Client.Queryable<mes_MaterialBarCode>().Where(q => inv.Items.Select(q => q.SN).Contains(q.Code)).ToList(); |
| | | var qtyList = Biz.DataSource["YadaU9C"].Client.Queryable<mes_MaterialBarCode>().Where(q => CurInvItem.Items.Select(q => q.SN).Contains(q.Code)).ToList(); |
| | | foreach (var qty in qtyList) |
| | | { |
| | | var item = inv.Items.First(q => q.SN == qty.Code); |
| | | var item = CurInvItem.Items.First(q => q.SN == qty.Code); |
| | | item.QTY = qty.WhQty; |
| | | } |
| | | action.Data.Data = inv.Items.Select(q => new { q.SN, q.QTY }); |
| | | action.Data.Data = CurInvItem.Items.Select(q => new { q.SN, q.QTY }); |
| | | action.Data.Command = Command = "ComfirmQty"; |
| | | //action.LocaleMsg = Biz.L("请确认条码[{0}]的数量是否正确"); |
| | | action.LocaleMsg = Biz.L("WMS.Default.ScanItem.ComfirmQty", input.SN); |
| | | return action; |
| | | } |
| | | CurInvItem = inv; |
| | | } |
| | | |
| | | //更新已确认物料数量 |
| | |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_OTH_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:完工入库单(ERP)明细 |
| | | /// 实体:完工入库单(ERP)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ERP_PROD_IN_DTL")] |
| | | public class BIZ_ERP_PROD_IN_DTL : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | |
| | | /// <summary> |
| | | /// 实体:完工入库单(ERP)明细 |
| | | /// 实体:完工入库单(ERP)明细 |
| | | /// </summary> |
| | | public BIZ_ERP_PROD_IN_DTL() |
| | | { } |
| | | |
| | | #endregion 构造函数 |
| | | #endregion 构造函数 |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | |
| | | /// <summary> |
| | | /// 单据号码 |
| | | /// 单据号码 |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 单据行号 |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单据行状态 |
| | | /// 单据行状态 |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料代码 |
| | | /// 物料代码 |
| | | /// </summary> |
| | | public string ITEM_CODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单位代码 |
| | | /// 单位代码 |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 需求数量 |
| | | /// 需求数量 |
| | | /// </summary> |
| | | public decimal PRQTY { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 库存数量 |
| | | /// 库存数量 |
| | | /// </summary> |
| | | public decimal INVENTORYQTY { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库数量 |
| | | /// 入库数量 |
| | | /// </summary> |
| | | public decimal INSTOCKQTY { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库代码 |
| | | /// 仓库代码 |
| | | /// </summary> |
| | | public string WAREHOUSECODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 来源类型 |
| | | /// 来源类型 |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 来源代码 |
| | | /// 来源代码 |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 来源行号 |
| | | /// 来源行号 |
| | | /// </summary> |
| | | public string SOURCELINE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注 |
| | | /// 备注 |
| | | /// </summary> |
| | | public string REMARK { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP单据代码 |
| | | /// ERP单据代码 |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | |
| | | #endregion 公共属性 |
| | | #endregion 公共属性 |
| | | |
| | | #region 虚拟属性 |
| | | #region 虚拟属性 |
| | | |
| | | /*例子 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | |
| | | #endregion 虚拟属性 |
| | | #endregion 虚拟属性 |
| | | |
| | | #region 外键属性 |
| | | #region 外键属性 |
| | | |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PROD_IN_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PROD_IN_DTLId))]//ClassA表中的BIZ_ERP_PROD_IN_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_IN_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PROD_IN_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PROD_IN_DTLId))]//ClassA表中的BIZ_ERP_PROD_IN_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_IN_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | #endregion 外键属性 |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion 外键属性 |
| | | |
| | | #region 枚举变量 |
| | | #region 枚举变量 |
| | | |
| | | /*例子 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | #endregion 枚举变量 |
| | | #endregion 枚举变量 |
| | | }//endClass |
| | | } |
| | |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ERP_SALE_OUT_DTL")] |
| | | public class BIZ_ERP_SALE_OUT_DTL : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | public BIZ_ERP_SALE_OUT_DTL() {} |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 单据代码 |
| | | /// 单据代码 |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 单据行号 |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | /// <summary> |
| | | /// 单据行状态 |
| | | /// 单据行状态 |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 单位代码 |
| | | /// 单位代码 |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | /// <summary> |
| | | /// 需求数量 |
| | | /// 需求数量 |
| | | /// </summary> |
| | | public decimal PRQTY { get; set; } |
| | | /// <summary> |
| | | /// 数量 |
| | | /// 数量 |
| | | /// </summary> |
| | | public decimal QTY { get; set; } |
| | | /// <summary> |
| | | /// 发货日期 |
| | | /// 发货日期 |
| | | /// </summary> |
| | | public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 仓库代码 |
| | | /// 仓库代码 |
| | | /// </summary> |
| | | public string WAREHOUSECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据类型 |
| | | /// 来源单据类型 |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据代码 |
| | | /// 来源单据代码 |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据行号 |
| | | /// 来源单据行号 |
| | | /// </summary> |
| | | public string SOURCELINE { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// 备注 |
| | | /// </summary> |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 客户代码 |
| | | /// 客户代码 |
| | | /// </summary> |
| | | public string CUST_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERP单据代码 |
| | | /// ERP单据代码 |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | | /*例子 |
| | | #region 枚举变量 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | |
| | |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFER_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_OTH_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [Serializable] |
| | | [SugarTable("V_BIZ_ERP_SALE_OUT_DTL")] |
| | | public class V_BIZ_ERP_SALE_OUT_DTL : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | public V_BIZ_ERP_SALE_OUT_DTL() {} |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 单据代码 |
| | | /// 单据代码 |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 单据行号 |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | /// <summary> |
| | | /// 单据行状态 |
| | | /// 单据行状态 |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 单位代码 |
| | | /// 单位代码 |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | /// <summary> |
| | | /// 需求数量 |
| | | /// 需求数量 |
| | | /// </summary> |
| | | public decimal PRQTY { get; set; } |
| | | /// <summary> |
| | | /// 数量 |
| | | /// 数量 |
| | | /// </summary> |
| | | public decimal QTY { get; set; } |
| | | /// <summary> |
| | | /// 发货日期 |
| | | /// 发货日期 |
| | | /// </summary> |
| | | public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 仓库代码 |
| | | /// 仓库代码 |
| | | /// </summary> |
| | | public string WAREHOUSECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据类型 |
| | | /// 来源单据类型 |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据代码 |
| | | /// 来源单据代码 |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据行号 |
| | | /// 来源单据行号 |
| | | /// </summary> |
| | | public string SOURCELINE { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// 备注 |
| | | /// </summary> |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 客户代码 |
| | | /// 客户代码 |
| | | /// </summary> |
| | | public string CUST_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERP单据代码 |
| | | /// ERP单据代码 |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | /// <summary> |
| | | /// 物料名称 |
| | | /// 物料名称 |
| | | /// </summary> |
| | | public string ITEM_NAME { get;set; } |
| | | /// <summary> |
| | | /// 欠发数量 |
| | | /// 欠发数量 |
| | | /// </summary> |
| | | public decimal OWE_QTY { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | | /*例子 |
| | | #region 枚举变量 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | |
| | |
| | | // [SugarColumn(IsIgnore = true)] |
| | | // public List<WMS_ITEM_PKG> Children => ChildrenWithGhost?.Where(q => !q.GHOST_ROW).ToList() ?? new List<WMS_ITEM_PKG>(); |
| | | //BAS_ITEM, WMS_WAREHOUSE, WMS_REGION, WMS_SHELF, WMS_LOCATION |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值,只能是null |
| | | [SugarColumn(IsIgnore = true)] |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | [Navigate(NavigateType.OneToOne, nameof(SN), nameof(WMS_ITEM.SN), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 |
| | | public WMS_ITEM Item { get; set; } //注意禁止手动赋值,只能是null |
| | | [Navigate(NavigateType.OneToOne, nameof(SN), nameof(WMS_ITEM_EXT.SN), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 |