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