using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:送检单(ERP) /// [Description("Primary:ID")] [Serializable] [SugarTable("BIZ_ERP_IQC")] public class BIZ_ERP_IQC : DbEntityWithAuth { #region 构造函数 /// /// 实体:送检单(ERP) /// public BIZ_ERP_IQC() {} #endregion #region 公共属性 /// /// 单据号码 /// public string BILLCODE { get; set; } /// /// 来源单据类型 /// public int SOURCETYPE { get; set; } /// /// 来源单据号码 /// public string SOURCECODE { get; set; } /// /// 来源单据行号 /// public string SOURCELINE { get; set; } /// /// 检验次数 /// public int QCTIMES { get; set; } /// /// 检验状态 /// public int QCSTATUS { get; set; } /// /// 检验结果 /// public int QCRESULT { get; set; } /// /// 检验人 /// public int QCREVIEW { get; set; } /// /// 审核数量 /// public double REVIEWQTY { get; set; } /// /// 级别 /// public int QCLEVEL { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 是否测量 /// public string MEASURE { get; set; } /// /// 缺陷等级 /// public string STRICTLEVEL { get; set; } /// /// 等级代码 /// public string LEVELCODE { get; set; } /// /// 检验标准 /// public string AQL { get; set; } /// /// 样品数量 /// public double SAMPLEQTY { get; set; } /// /// 样品通过数量 /// public double SAMPLEPASSQTY { get; set; } /// /// 样品失败数量 /// public double SAMPLENGQTY { get; set; } /// /// 开始数量 /// public double BEGINQTY { get; set; } /// /// 结束数量 /// public double ENDQTY { get; set; } /// /// 致命缺陷数量 /// public double FATALQTY { get; set; } /// /// 严重缺陷数量 /// public double SERIOUSQTY { get; set; } /// /// 一般缺陷数量 /// public double COMMONLYQTY { get; set; } /// /// 轻微缺陷数量 /// public double SLIGHTQTY { get; set; } /// /// 检验数量 /// public double QCQTY { get; set; } /// /// 允收数量 /// public double RECEIVEQTY { get; set; } /// /// 拒收数量 /// public double REJECTQTY { get; set; } /// /// 入库数量 /// public double INSTOCKQTY { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// 报废数量 /// public double SCRAPQTY { get; set; } /// /// ERP单据号码 /// public string ERP_BILL_CODE { get; set; } /// /// 采购单号 /// public string PONO { get; set; } /// /// 采购行号 /// public string POLINE { get; set; } /// /// -1:未处理,0:同步处理完,>0:同步处理失败次数 /// public int HANDLED { get; set; } /// /// 最后一次同步处理日期 /// public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; /// /// 过账提交的JSON /// public string COMMIT_JSON { get; set; } /// /// 过账提交的返回信息 /// public string COMMIT_MSG { get; set; } /// /// 是否需要烘烤 /// public string NEED_BAKE { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ /// /// 检验结果 /// public enum QCSTATUSs { [Description("普通货架")] UnFinish = 2, [Description("普通货架")] Finished = 3, [Description("普通货架")] MRB = 4, [Description("普通货架")] Auditing = 5 } /// /// 检验状态 /// public enum QCRESULTs { [Description("普通货架")] OK = 1, [Description("普通货架")] Wait = 2, [Description("普通货架")] NG = 3 } public enum BillType { /// /// 送货单 /// ASN = 10, /// /// 采购订单 /// PO = 11, /// /// 委外订单 /// OutSourcePO = 12, /// /// 收料通知单(到货单) /// Receipt = 13, /// /// 来料入库单 /// PurInstock = 14, /// /// 采购退料单 /// PurReturn = 15, /// /// 拒收单 /// Reject = 16, /// /// 委外发料单 /// OutSourcePick = 20, /// /// 委外补料单 /// OutSourceFeed = 21, /// /// 委外退料单 /// OutSourceReturn = 22, /// /// 生产领料单 /// ProductPick = 23, /// /// 生产补料单 /// ProductFeed = 24, /// /// 生产退料单 /// ProductReturn = 25, /// /// 生产工单 /// Mo = 30, /// /// 领料申请单 /// PickApply = 31, /// /// 产成品入库单 /// ProductInstock = 40, /// /// 发货通知单 /// SalesDelivery = 41, /// /// 销售出库单 /// SalesOutStock = 42, /// /// 销售退货单 /// SalesReturn = 43, /// /// 销售订单 /// SalesOrder = 44, /// /// 网上订单 /// SalesNetOrder = 45, /// /// 调拨单 /// Transfer = 50, /// /// 其他入库单 /// OtherInStock = 51, /// /// 其他出库单 /// OtherOutStock = 52, /// /// 形态转换单 /// Convert = 53, /// /// 无订单入库 2022-12-12,weikaiyong /// NoPoInStock = 54, /// /// 盘点单 /// CheckStock = 60, /// /// 拣货单 /// Pick = 61, /// /// 过期送检单 /// Expired = 66, /// /// 半成品入库单 /// SelfInstock = 68, /// /// 报废 /// Scrap = 70, /// /// 来料退货 /// Return = 80, /// /// 客供料入库单 /// CustSupplyInStock = 81 } public enum QCReview { /// /// 未评审 /// UnReview = 0, /// /// 正采 /// Natural = 1, /// /// 挑选 /// Select = 2, /// /// 特采 /// SpecialSelect = 3, /// /// 全退 /// AllReturn = 4 } #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_IQC类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_IQCId))]//ClassA表中的BIZ_ERP_IQCId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_IQCId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion #region 公共方法 #endregion }//endClass }