You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
351 lines
9.3 KiB
C#
351 lines
9.3 KiB
C#
using Estsh.Core.Base;
|
|
using System.ComponentModel;
|
|
using System.ComponentModel.DataAnnotations.Schema;
|
|
|
|
namespace Estsh.Core.Models
|
|
{
|
|
/// <summary>
|
|
/// ，数据实体对象
|
|
/// </summary>
|
|
[Table("sys_part")]
|
|
[Serializable]
|
|
public class SysPart : BaseEntity
|
|
{
|
|
[Column("part_id")]
|
|
[DisplayName("零件编号")]
|
|
public int PartId { get; set; }
|
|
|
|
[Column("part_no")]
|
|
[DisplayName("零件号")]
|
|
public string PartNo { get; set; }
|
|
|
|
[Column("part_spec")]
|
|
[DisplayName("零件描述")]
|
|
public string PartSpec { get; set; }
|
|
|
|
[Column("part_spec2")]
|
|
[DisplayName(" ")]
|
|
public string PartSpec2 { get; set; }
|
|
|
|
[Column("part_location")]
|
|
[DisplayName("零件位置")]
|
|
public string PartLocation { get; set; }
|
|
|
|
[Column("part_type")]
|
|
[DisplayName("零件类型")]
|
|
public string PartType { get; set; }
|
|
|
|
[Column("part_class")]
|
|
[DisplayName(" ")]
|
|
public string PartClass { get; set; }
|
|
|
|
[Column("model_id")]
|
|
[DisplayName("车型编号")]
|
|
public int? ModelId { get; set; }
|
|
|
|
[Column("label_file")]
|
|
[DisplayName("标签文件的文件名")]
|
|
public string LabelFile { get; set; }
|
|
|
|
[Column("label_type")]
|
|
[DisplayName("标签类型")]
|
|
public string LabelType { get; set; }
|
|
|
|
[Column("label_qty")]
|
|
[DisplayName("条码打印的份数")]
|
|
public int? LabelQty { get; set; }
|
|
|
|
[Column("rule_set")]
|
|
[DisplayName("条码规则（目前为生成条码的存储过程名）")]
|
|
public string RuleSet { get; set; }
|
|
|
|
[Column("unit")]
|
|
[DisplayName("单位")]
|
|
public string Unit { get; set; }
|
|
|
|
[Column("route_id")]
|
|
[DisplayName("流程编号")]
|
|
public int? RouteId { get; set; }
|
|
|
|
[Column("upc_code")]
|
|
[DisplayName("UPC 代码")]
|
|
public string UpcCode { get; set; }
|
|
|
|
[Column("ucc_code")]
|
|
[DisplayName("UCC 代码")]
|
|
public string UccCode { get; set; }
|
|
|
|
[Column("ean_code")]
|
|
[DisplayName("EAN 代码")]
|
|
public string EanCode { get; set; }
|
|
|
|
[Column("burnin_time")]
|
|
[DisplayName("烧机时间")]
|
|
public int? BurninTime { get; set; }
|
|
|
|
[Column("version")]
|
|
[DisplayName("版本")]
|
|
public string Version { get; set; }
|
|
|
|
[Column("mfger_id")]
|
|
[DisplayName("制造商编号")]
|
|
public int? MfgerId { get; set; }
|
|
|
|
[Column("subboard_qty")]
|
|
[DisplayName("连板数量")]
|
|
public int? SubboardQty { get; set; }
|
|
|
|
[Column("split_flag")]
|
|
[DisplayName("是否允许拆分")]
|
|
public string SplitFlag { get; set; }
|
|
|
|
[Column("batch_control")]
|
|
[DisplayName("是否批次管控")]
|
|
public string BatchControl { get; set; }
|
|
|
|
[Column("min_pack_qty")]
|
|
[DisplayName("最小包装数量")]
|
|
public decimal? MinPackQty { get; set; }
|
|
|
|
[Column("min_stock_qty")]
|
|
[DisplayName("最低库存数量")]
|
|
public decimal? MinStockQty { get; set; }
|
|
|
|
[Column("max_stock_qty")]
|
|
[DisplayName("最高库存数量")]
|
|
public decimal? MaxStockQty { get; set; }
|
|
|
|
[Column("wip_min_stock_qty")]
|
|
[DisplayName(" ")]
|
|
public decimal? WipMinStockQty { get; set; }
|
|
|
|
[Column("indate_flag")]
|
|
[DisplayName("是否管控有效期")]
|
|
public string IndateFlag { get; set; }
|
|
|
|
[Column("indate")]
|
|
[DisplayName("有效期（天）")]
|
|
public int? Indate { get; set; }
|
|
|
|
[Column("sampling_plan_id")]
|
|
[DisplayName("质检抽样计划编号")]
|
|
public int? SamplingPlanId { get; set; }
|
|
|
|
[Column("over_request")]
|
|
[DisplayName("是否允许超领")]
|
|
public string OverRequest { get; set; }
|
|
|
|
[Column("default_box_qty")]
|
|
[DisplayName("默认的每箱数量")]
|
|
public decimal? DefaultBoxQty { get; set; }
|
|
|
|
[Column("default_reel_qty")]
|
|
[DisplayName("默认的每卷数量")]
|
|
public decimal? DefaultReelQty { get; set; }
|
|
|
|
[Column("default_set_qty")]
|
|
[DisplayName("默认的每批数量")]
|
|
public decimal? DefaultSetQty { get; set; }
|
|
|
|
[Column("supply_type")]
|
|
[DisplayName(" ")]
|
|
public int? SupplyType { get; set; }
|
|
|
|
[Column("settle_type")]
|
|
[DisplayName(" ")]
|
|
public int? SettleType { get; set; }
|
|
|
|
[Column("recheck_cycle")]
|
|
[DisplayName(" ")]
|
|
public int? RecheckCycle { get; set; }
|
|
|
|
[Column("instock_type")]
|
|
[DisplayName(" ")]
|
|
public string InstockType { get; set; }
|
|
|
|
[Column("package_size")]
|
|
[DisplayName(" ")]
|
|
public string PackageSize { get; set; }
|
|
|
|
[Column("part_abc")]
|
|
[DisplayName(" ")]
|
|
public string PartAbc { get; set; }
|
|
|
|
[Column("part_group")]
|
|
[DisplayName(" ")]
|
|
public string PartGroup { get; set; }
|
|
|
|
[Column("uom1")]
|
|
[DisplayName(" ")]
|
|
public string Uom1 { get; set; }
|
|
|
|
[Column("coefficient1")]
|
|
[DisplayName(" ")]
|
|
public decimal? Coefficient1 { get; set; }
|
|
|
|
[Column("uom2")]
|
|
[DisplayName(" ")]
|
|
public string Uom2 { get; set; }
|
|
|
|
[Column("coefficient2")]
|
|
[DisplayName(" ")]
|
|
public decimal? Coefficient2 { get; set; }
|
|
|
|
[Column("uom3")]
|
|
[DisplayName(" ")]
|
|
public string Uom3 { get; set; }
|
|
|
|
[Column("coefficient3")]
|
|
[DisplayName(" ")]
|
|
public decimal? Coefficient3 { get; set; }
|
|
|
|
[Column("mc_code")]
|
|
[DisplayName(" ")]
|
|
public string McCode { get; set; }
|
|
|
|
[Column("is_sort")]
|
|
[DisplayName(" ")]
|
|
public int? IsSort { get; set; }
|
|
|
|
[Column("sort_qty")]
|
|
[DisplayName(" ")]
|
|
public int? SortQty { get; set; }
|
|
|
|
[Column("sort_type")]
|
|
[DisplayName(" ")]
|
|
public string SortType { get; set; }
|
|
|
|
[Column("sort_seq")]
|
|
[DisplayName(" ")]
|
|
public int? SortSeq { get; set; }
|
|
|
|
[Column("option1")]
|
|
[DisplayName("预留字段")]
|
|
public string Option1 { get; set; }
|
|
|
|
[Column("option2")]
|
|
[DisplayName("预留字段")]
|
|
public string Option2 { get; set; }
|
|
|
|
[Column("option3")]
|
|
[DisplayName("预留字段")]
|
|
public string Option3 { get; set; }
|
|
|
|
[Column("option4")]
|
|
[DisplayName("预留字段")]
|
|
public string Option4 { get; set; }
|
|
|
|
[Column("option5")]
|
|
[DisplayName("预留字段")]
|
|
public string Option5 { get; set; }
|
|
|
|
[Column("option6")]
|
|
[DisplayName("预留字段")]
|
|
public string Option6 { get; set; }
|
|
|
|
[Column("option7")]
|
|
[DisplayName("预留字段")]
|
|
public string Option7 { get; set; }
|
|
|
|
[Column("option8")]
|
|
[DisplayName("预留字段")]
|
|
public string Option8 { get; set; }
|
|
|
|
[Column("option9")]
|
|
[DisplayName("预留字段")]
|
|
public string Option9 { get; set; }
|
|
|
|
[Column("option10")]
|
|
[DisplayName("预留字段")]
|
|
public string Option10 { get; set; }
|
|
|
|
[Column("option11")]
|
|
[DisplayName("预留字段")]
|
|
public string Option11 { get; set; }
|
|
|
|
[Column("option12")]
|
|
[DisplayName("预留字段")]
|
|
public string Option12 { get; set; }
|
|
|
|
[Column("option13")]
|
|
[DisplayName("预留字段")]
|
|
public string Option13 { get; set; }
|
|
|
|
[Column("option14")]
|
|
[DisplayName("预留字段")]
|
|
public string Option14 { get; set; }
|
|
|
|
[Column("option15")]
|
|
[DisplayName("预留字段")]
|
|
public string Option15 { get; set; }
|
|
|
|
[Column("BKLAS")]
|
|
[DisplayName(" ")]
|
|
public string Bklas { get; set; }
|
|
|
|
[Column("remark")]
|
|
[DisplayName(" ")]
|
|
public string Remark { get; set; }
|
|
|
|
[Column("is_exemption")]
|
|
[DisplayName("是否免检")]
|
|
public string IsExemption { get; set; }
|
|
|
|
|
|
|
|
#region 扩展字段
|
|
|
|
[NotMapped]
|
|
[Column("vendor_id")]
|
|
[DisplayName("供应商编号")]
|
|
public int? VendorId { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("model_name")]
|
|
[DisplayName(" ")]
|
|
public string ModelName { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("route_name")]
|
|
[DisplayName(" ")]
|
|
public string RouteName { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("locate_id")]
|
|
[DisplayName("库位编号")]
|
|
public int? LocateId { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("locate_name")]
|
|
[DisplayName(" ")]
|
|
public string LocateName { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("enum_desc")]
|
|
[DisplayName(" ")]
|
|
public string EnumDesc { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("emp_name")]
|
|
[DisplayName(" ")]
|
|
public string EmpName { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("create_name")]
|
|
[DisplayName(" ")]
|
|
public string CreateName { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("qty")]
|
|
[DisplayName(" ")]
|
|
public string Qty { get; set; }
|
|
|
|
[NotMapped]
|
|
[Column("serial_number")]
|
|
[DisplayName(" ")]
|
|
public string SerialNumber { get; set; }
|
|
#endregion
|
|
|
|
}
|
|
}
|