using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     物料信息
/// </summary>
[SugarTable("MES_ITEMS")]
public class MesItems
{
    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     工厂
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string? Factory { get; set; }

    /// <summary>
    ///     公司编号
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string? Company { get; set; }

    /// <summary>
    ///     物料编码 = ERP物料编号||颜色编号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     物料名称
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NAME")]
    public string? ItemName { get; set; }

    /// <summary>
    ///     物料简称
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_SNAME")]
    public string? ItemSname { get; set; }

    /// <summary>
    ///     规格型号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_MODEL")]
    public string? ItemModel { get; set; }

    /// <summary>
    ///     物料描述
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
    public string? ItemDescription { get; set; }

    /// <summary>
    ///     物料单位
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_UNIT")]
    public string? ItemUnit { get; set; }

    /// <summary>
    ///     物料类型
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_TYPE")]
    public string? ItemType { get; set; }

    /// <summary>
    ///     产品版本
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_VERSION")]
    public string? ItemVersion { get; set; }

    /// <summary>
    ///     客户编号
    /// </summary>
    [SugarColumn(ColumnName = "CUST_NO")]
    public string? CustNo { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     最后更新人
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     最后更新时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     最低库存
    /// </summary>
    [SugarColumn(ColumnName = "LOWLIMIT")]
    public double? Lowlimit { get; set; }

    /// <summary>
    ///     最大库存
    /// </summary>
    [SugarColumn(ColumnName = "HIGHLIMIT")]
    public double? Highlimit { get; set; }

    /// <summary>
    ///     最小包装数
    /// </summary>
    [SugarColumn(ColumnName = "PRD_PACK")]
    public double? PrdPack { get; set; }

    /// <summary>
    ///     订单单位
    /// </summary>
    [SugarColumn(ColumnName = "ORDERUNIT")]
    public string? Orderunit { get; set; }

    /// <summary>
    ///     销售单位
    /// </summary>
    [SugarColumn(ColumnName = "SALEUNIT")]
    public string? Saleunit { get; set; }

    /// <summary>
    ///     库房单位
    /// </summary>
    [SugarColumn(ColumnName = "STOREUNIT")]
    public string? Storeunit { get; set; }

    /// <summary>
    ///     生产单位
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCTUNIT")]
    public string? Productunit { get; set; }

    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "E_ITEM_ID")]
    public decimal? EItemId { get; set; }

    /// <summary>
    ///     ERP料号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
    public string? ErpItemNo { get; set; }

    /// <summary>
    ///     默认仓库
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string? DepotCode { get; set; }

    /// <summary>
    ///     物料分类编号
    /// </summary>
    [SugarColumn(ColumnName = "PPBOM00019124")]
    public string? Ppbom00019124 { get; set; }

    /// <summary>
    ///     物料分组
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string? Remarks { get; set; }

    /// <summary>
    ///     采购员
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASERID")]
    public string? Fpurchaserid { get; set; }

    /// <summary>
    ///     禁用状态
    /// </summary>
    [SugarColumn(ColumnName = "FFORBIDSTATUS")]
    public string? Fforbidstatus { get; set; }

    /// <summary>
    ///     物料分组
    /// </summary>
    [SugarColumn(ColumnName = "FMATERIALGROUP")]
    public string? Fmaterialgroup { get; set; }

    /// <summary>
    ///     完工超收比例
    /// </summary>
    [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
    public decimal? Ffinishreceiptoverrate { get; set; }

    /// <summary>
    ///     发料方式
    /// </summary>
    [SugarColumn(ColumnName = "FISSUETYPE")]
    public string? Fissuetype { get; set; }

    /// <summary>
    ///     启用批号管理
    /// </summary>
    [SugarColumn(ColumnName = "FISBATCHMANAGE")]
    public decimal? Fisbatchmanage { get; set; }

    /// <summary>
    ///     采购单位
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASEUNITID")]
    public string? Fpurchaseunitid { get; set; }

    /// <summary>
    ///     创建组织
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal CreateOrg { get; set; }

    /// <summary>
    ///     使用组织
    /// </summary>
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal UseOrg { get; set; }

    /// <summary>
    ///     损耗率
    /// </summary>
    [SugarColumn(ColumnName = "LOSS_PERCENT")]
    public string? LossPercent { get; set; }

    /// <summary>
    ///     助记码
    /// </summary>
    [SugarColumn(ColumnName = "MNEMONIC_CODE")]
    public string? MnemonicCode { get; set; }

    /// <summary>
    ///     保质期
    /// </summary>
    [SugarColumn(ColumnName = "EXP_PERIOD")]
    public string? ExpPeriod { get; set; }

    /// <summary>
    ///     生产车间
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
    public string? ProductionWorkshop { get; set; }

    /// <summary>
    ///     物料属性
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
    public string? MaterialProperti { get; set; }

    /// <summary>
    ///     生产单位
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCE_UNIT")]
    public string? ProduceUnit { get; set; }

    /// <summary>
    ///     委外单位
    /// </summary>
    [SugarColumn(ColumnName = "SUBCON_UNIT")]
    public string? SubconUnit { get; set; }

    /// <summary>
    ///     图片1
    /// </summary>
    [SugarColumn(ColumnName = "BZ06")]
    public string? Bz06 { get; set; }

    /// <summary>
    ///     图片2
    /// </summary>
    [SugarColumn(ColumnName = "BZ07")]
    public string? Bz07 { get; set; }

    /// <summary>
    ///     图片3
    /// </summary>
    [SugarColumn(ColumnName = "BZ08")]
    public string? Bz08 { get; set; }

    /// <summary>
    ///     图片4
    /// </summary>
    [SugarColumn(ColumnName = "BZ09")]
    public string? Bz09 { get; set; }

    /// <summary>
    ///     图片5
    /// </summary>
    [SugarColumn(ColumnName = "BZ10")]
    public string? Bz10 { get; set; }

    /// <summary>
    ///     QC分组ID
    /// </summary>
    [SugarColumn(ColumnName = "QC_TEAMID")]
    public string? QcTeamid { get; set; }

    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }

    /// <summary>
    ///     颜色
    /// </summary>
    [SugarColumn(ColumnName = "COLOR_NAME")]
    public string? ColorName { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }

    /// <summary>
    ///     接口字段调整：标准版接口新增字段。
    /// </summary>
    /// <remarks>
    ///     修改人：
    ///     <池南骏>
    ///         修改日期：<2024-12-31>
    ///         修改说明：
    ///         - 原代码：空
    ///         - 新增：
    /// </remarks>
    /// <summary>
    ///     旧物料编码
    /// </summary>
    [SugarColumn(ColumnName = "FOLDNUMBER")]
    public string? FOLDNUMBER { get; set; }

    /// <summary>
    ///     最小库存
    /// </summary>
    [SugarColumn(ColumnName = "FMINSTOCK")]
    public double? FMINSTOCK { get; set; }

    /// <summary>
    ///     入库欠收比例(%)
    /// </summary>
    [SugarColumn(ColumnName = "FFINISHRECEIPTSHORTRATE")]
    public decimal? FFINISHRECEIPTSHORTRATE { get; set; }

    /// <summary>
    ///     默认供应商
    /// </summary>
    [SugarColumn(ColumnName = "FDEFAULTVENDOR")]
    public string? FDEFAULTVENDOR { get; set; }

    /// <summary>
    ///     数据状态(Z=暂存,A=创建,B=审核中,C=已审核,D=重新审核)
    /// </summary>
    [SugarColumn(ColumnName = "FDOCUMENTSTATUS")]
    public string? FDOCUMENTSTATUS { get; set; }

    /// <summary>
    ///     制造策略
    /// </summary>
    [SugarColumn(ColumnName = "FMFGPOLICYID")]
    public string? FMFGPOLICYID { get; set; }

    /// <summary>
    ///     子项单位
    /// </summary>
    [SugarColumn(ColumnName = "FBOMUNITID")]
    public string? FBOMUNITID { get; set; }

    /// <summary>
    ///     是否关键件
    /// </summary>
    [SugarColumn(ColumnName = "FISKITTING")]
    public string? FISKITTING { get; set; }

    /// <summary>
    ///     可为联副产品
    /// </summary>
    [SugarColumn(ColumnName = "FISCOBY")]
    public string? FISCOBY { get; set; }

    /// <summary>
    ///     超发控制方式
    /// </summary>
    [SugarColumn(ColumnName = "FOVERCONTROLMODE")]
    public string? FOVERCONTROLMODE { get; set; }

    /// <summary>
    ///     模具编号
    /// </summary>
    [SugarColumn(ColumnName = "F_MJBH")]
    public string? F_MJBH { get; set; }


    //20250407 yhj 焕媄新增字段
    /// <summary>
    ///     套件
    /// </summary>
    [SugarColumn(ColumnName = "F_TJ")]
    public string? F_TJ { get; set; }

    /// <summary>
    ///     控制
    /// </summary>
    [SugarColumn(ColumnName = "F_KZ")]
    public string? F_KZ { get; set; }
    /// <summary>
    ///     试制or量产?
    /// </summary>
    [SugarColumn(ColumnName = "F_SC")]
    public string? F_SC { get; set; }
    /// <summary>
    ///     换算方向
    /// </summary>
    [SugarColumn(ColumnName = "F_HSFX")]
    public string? F_HSFX { get; set; }
    /// <summary>
    ///     库存控制
    /// </summary>
    [SugarColumn(ColumnName = "F_KCKZ")]
    public string? F_KCKZ { get; set; }
    /// <summary>
    ///     销售控制
    /// </summary>
    [SugarColumn(ColumnName = "F_XSKZ")]
    public string? F_XSKZ { get; set; }
    /// <summary>
    ///     CRM
    /// </summary>
    [SugarColumn(ColumnName = "F_CRM")]
    public string? F_CRM { get; set; }
    /// <summary>
    ///     采购控制
    /// </summary>
    [SugarColumn(ColumnName = "F_CGKZ")]
    public string? F_CGKZ { get; set; }
    /// <summary>
    ///     委外类型
    /// </summary>
    [SugarColumn(ColumnName = "F_WWLX")]
    public string? F_WWLX { get; set; }
    /// <summary>
    ///     检验设置
    /// </summary>
    [SugarColumn(ColumnName = "F_JYSZ")]
    public string? F_JYSZ { get; set; }
    /// <summary>
    ///     复检周期（）天
    /// </summary>
    [SugarColumn(ColumnName = "F_FJZQ")]
    public string? F_FJZQ { get; set; }
    /// <summary>
    ///     生产类型
    /// </summary>
    [SugarColumn(ColumnName = "F_SCLX")]
    public string? F_SCLX { get; set; }
    /// <summary>
    ///     组织间受托类型
    /// </summary>
    [SugarColumn(ColumnName = "F_ZZSTLX")]
    public string? F_ZZSTLX { get; set; }
    /// <summary>
    ///     倒冲数量
    /// </summary>
    [SugarColumn(ColumnName = "F_DCSL")]
    public string? F_DCSL { get; set; }
    /// <summary>
    ///     标准工时
    /// </summary>
    [SugarColumn(ColumnName = "F_BZGS")]
    public string? F_BZGS { get; set; }
    /// <summary>
    ///     分组名称
    /// </summary>
    [SugarColumn(ColumnName = "WLFZMC")]
    public string? WLFZMC { get; set; }
    /// <summary>
    ///     模具编码
    /// </summary>
    [SugarColumn(ColumnName = "MJBM")]
    public string? MJBM { get; set; }
    /// <summary>
    ///     客户物料编码
    /// </summary>
    [SugarColumn(ColumnName = "KHWLBM")]
    public string? Khwlbm { get; set; }
    /// <summary>
    ///     颜色
    /// </summary>
    [SugarColumn(ColumnName = "YS")]
    public string? Ys { get; set; }
    /// <summary>
    ///     下道工序
    /// </summary>
    [SugarColumn(ColumnName = "NEXT_GX")]
    public string? NesxGx { get; set; }

}