using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace DM_Weight.Models
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("drug_info")]
    public class DrugInfo
    {
        /// <summary>
        ///  
        ///</summary>
        //[SugarColumn(ColumnName = "pharmacy")]
        //public string Pharmacy { get; set; }
        /// <summary>
        /// ҩƷID 
        ///</summary>
        [SugarColumn(ColumnName = "drug_id", IsPrimaryKey = true)]
        public string DrugId { get; set; }
        /// <summary>
        /// ƴ 
        ///</summary>
        [SugarColumn(ColumnName = "py_code")]
        public string PyCode { get; set; }
        /// <summary>
        ///  
        ///</summary>
        //[SugarColumn(ColumnName = "BD_code")]
        //public string BdCode { get; set; }
        /// <summary>
        /// ҩƷ 
        ///</summary>
        [SugarColumn(ColumnName = "drug_barcode")]
        public string DrugBarcode { get; set; }
        
        /// <summary>
        /// ҩƷ���� 
        ///</summary>
        [SugarColumn(ColumnName = "drug_name")]
        public string DrugName { get; set; }
        /// <summary>
        ///  
        ///</summary>
        [SugarColumn(ColumnName = "drug_brand_name")]
        public string DrugBrandname { get; set; }
        /// <summary>
        /// ҩƷ��� 
        ///</summary>
        [SugarColumn(ColumnName = "drug_spec")]
        public string DrugSpec { get; set; }
        /// <summary>
        /// ���� 
        ///</summary>
        [SugarColumn(ColumnName = "dosage")]
        public string Dosage { get; set; }
        /// <summary>
        /// ��װ��λ 
        ///</summary>
        [SugarColumn(ColumnName = "pack_unit")]
        public string PackUnit { get; set; }
        /// <summary>
        /// �������� 
        ///</summary>
        [SugarColumn(ColumnName = "manufactory")]
        public string Manufactory { get; set; }
        /// <summary>
        /// ���ҩ�� 
        ///</summary>
        [SugarColumn(ColumnName = "max_stock")]
        public int? MaxStock { get; set; }
        //[SugarColumn(IsIgnore=true)]
        [Navigate(NavigateType.OneToMany, nameof(ChannelStock.DrugId), nameof(DrugId))]//BookA表中的studenId
        public List<ChannelStock> channelStocks { get; set; }


        [Navigate(NavigateType.OneToMany, nameof(DrugManuNo.DrugId))]//BookA表中的studenId
        public List<DrugManuNo>? DrugManuNos { get; set; }
        [SugarColumn(IsIgnore = true)]
        public int? StockQuantity { get; set; }

        [SugarColumn(IsIgnore = true)]
        public string drug_name_spec { get; set; }
        //[SugarColumn(ColumnName = "drug_name_spec")]
        //public string Name { get; set; }
        [Navigate(NavigateType.OneToMany, nameof(DrugManuNo.DrugId))]//BookA表中的studenId
        public DrugManuNo? drugManuNo { get; set; }
    }
}