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_CabinOrderDetail", "入库明细表")]
    public class Dt_CabinOrderDetail:BaseEntity
    {
        [SugarColumn(ColumnName = "Id", IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int  Id { get; set; }

        // 修正：关联字段应该是主表的Id（不是Order_no）
        [SugarColumn(ColumnName = "OrderId", ColumnDescription = "关联入库单ID")]
        public int OrderId { get; set; }

        //区域（自己建立或者他们直接给出来）
        /// <summary>
        /// 库区
        /// </summary>
        [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_Inqty", IsNullable = true, ColumnDescription = "入库完成数量")]
        public decimal Order_Inqty { 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; }

 

        //盘盈明细--》料箱号，数量
        //public List<> StocktakingDetails { get; set; }


        /// <summary>
        /// 订单详情状态 新建，开始，已完成
        /// 库房号+状态+（新建）：判断是否下发给wcs
        /// 详情开始（开始）
        /// 详情完成（已完成，移入历史表删除信息）
        /// </summary>
        [SugarColumn(ColumnName = "OrderDetailStatus", IsNullable = true, Length = 50, ColumnDescription = "状态")]
        public string OrderDetailStatus { get; set; }

        //状态
        [SugarColumn(ColumnName = "Status", IsNullable = true, ColumnDescription = "状态 同步状态：0wcs未同步 1wcs已同步 2无需同步（即同步下发给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; }
    }
}