using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core.DB.Models;
|
|
namespace WIDESEA_Model.Models
|
{
|
[SugarTable("Dt_DeliveryOrderDetail", "出库明细表")]
|
public class Dt_DeliveryOrderDetail : BaseEntity
|
{
|
[SugarColumn(ColumnName = "Id", IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
|
public int Id { get; set; }
|
|
[SugarColumn(ColumnName = "DeliveryOrderId", IsNullable = true, ColumnDescription = "关联出库单ID")]
|
public int DeliveryOrderId { get; set; }
|
|
//区域（自己建立或者他们直接给出来）
|
[SugarColumn(ColumnName = "Reservoirarea", IsNullable = true, Length = 50, ColumnDescription = "库区")]
|
public string Reservoirarea { get; set; }
|
|
[SugarColumn(ColumnName = "Goods_no", IsNullable = true, Length = 50, ColumnDescription = "药品编码")]
|
public string Goods_no { get; set; }
|
|
|
[SugarColumn(ColumnName = "Order_qty", IsNullable = true, ColumnDescription = "出库退货时为负数")]
|
public decimal Order_qty { get; set; }
|
|
[SugarColumn(ColumnName = "Order_Outqty", IsNullable = true, ColumnDescription = "出库完成数量")]
|
public decimal Order_Outqty { get; set; }
|
|
[SugarColumn(ColumnName = "Batch_num", IsNullable = true, Length = 50, ColumnDescription = "批号")]
|
public string Batch_num { get; set; }
|
|
[SugarColumn(ColumnName = "Exp_date", IsNullable = true, Length = 50, ColumnDescription = "校期(yyyymmmdd)")]
|
public string Exp_date { get; set; }
|
/// <summary>
|
/// 订单详情状态 新建，开始，已完成
|
/// 库房号+状态+（新建）：判断是否下发给wcs
|
/// 详情开始（开始）
|
/// 详情完成（已完成，移入历史表删除信息）
|
/// </summary>
|
[SugarColumn(ColumnName = "OotDetailStatus", IsNullable = true, Length = 50, ColumnDescription = "状态")]
|
public string OotDetailStatus { get; set; }
|
|
|
[SugarColumn(ColumnName = "Status",IsNullable =true, ColumnDescription = "下游状态，同步状态：0未同步，1已同步（同步发给wcs）")]
|
public int Status { get; set; }
|
|
// 导航属性：一个明细对应一个药品信息
|
// 修正导航属性：使用 Goods_no 关联 MaterielCode
|
[Navigate(NavigateType.OneToOne, nameof(Goods_no), nameof(Dt_MaterielInfo.MaterielCode))]
|
public Dt_MaterielInfo MedicineGoods { get; set; }
|
|
//是否需要下面的字段
|
//sku名称 productName
|
//sku规格 ProductSpecifications
|
//数量 quantity
|
//盘亏明细 StocktakingDetails
|
|
}
|
}
|
