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 = "Batch_num", IsNullable = true, Length = 50, ColumnDescription = "批号")]
|
public string Batch_num { get; set; }
|
|
[SugarColumn(ColumnName = "Exp_date", IsNullable = true, Length = 8, ColumnDescription = "校期(yyyymmmdd)")]
|
public string Exp_date { get; set; }
|
|
//是否需要下面的字段
|
//sku名称 productName
|
//sku规格 ProductSpecifications
|
//数量 quantity
|
//盘亏明细 StocktakingDetails
|
//sku名称
|
[SugarColumn(ColumnName = "ProductName", IsNullable = true, ColumnDescription = "sku名称")]
|
public string ProductName { get; set; }
|
|
//sku规格
|
[SugarColumn(ColumnName = "ProductSpecifications", IsNullable = true, ColumnDescription = "sku规格")]
|
public string ProductSpecifications { get; set; }
|
|
//盈亏明细
|
//StoktakingDetails
|
|
|
|
}
|
}
|