using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 送货通知单主表（对应数据库表：DELIVERY_NOTICE）
|
/// </summary>
|
[SugarTable("DELIVERY_NOTICE")]
|
public class MesDeliveryNotice
|
{
|
/// <summary>
|
/// 主键（唯一标识，对应数据库 id 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
/// 送货单号（对应数据库 delivery_no 列，唯一约束）
|
/// </summary>
|
// 关键修正：用 IsUniqueConstraint=true 替代 IsUnique=true，兼容 SQL Server 2019 及早期 SqlSugar 版本
|
[SugarColumn(ColumnName = "delivery_no", IsPrimaryKey = true, IsNullable = false)]
|
public string DeliveryNo { get; set; } = string.Empty;
|
|
|
/// <summary>
|
/// 供应商编码（对应数据库 inner_vendor_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "org_id")]
|
public string? FReceiveOrgId { get; set; }
|
|
|
/// <summary>
|
/// 供应商编码（对应数据库 inner_vendor_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "inner_vendor_code")]
|
public string? SupplierId { get; set; }
|
|
/// <summary>
|
/// 供应商名称（对应数据库 inner_vendor_name 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "inner_vendor_name")]
|
public string? InnerVendorName { get; set; }
|
|
/// <summary>
|
/// 送货类型：1-普通 2-补货 3-备品 4-样品 5-VMI（对应数据库 delivery_type 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "delivery_type")]
|
public string? DeliveryType { get; set; }
|
|
/// <summary>
|
/// 送货日期(时间戳)（对应数据库 delivery_date 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "delivery_date")]
|
public string? DeliveryDate { get; set; }
|
|
/// <summary>
|
/// 预计送达日期(时间戳)（对应数据库 plan_arrived_date 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "plan_arrived_date")]
|
public string? PlanArrivedDate { get; set; }
|
|
/// <summary>
|
/// 送货联系人（对应数据库 contact_persion 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "contact_persion")]
|
public string? ContactPersion { get; set; }
|
|
/// <summary>
|
/// 送货人联系电话（对应数据库 contact_mobile 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "contact_mobile")]
|
public string? ContactMobile { get; set; }
|
|
/// <summary>
|
/// 内部收货地点编码（对应数据库 address_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "address_code")]
|
public string? AddressCode { get; set; }
|
|
/// <summary>
|
/// 收货明细地址（对应数据库 address_info 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "address_info")]
|
public string? AddressInfo { get; set; }
|
|
/// <summary>
|
/// 送货车牌号（对应数据库 delivery_car_no 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "delivery_car_no")]
|
public string? DeliveryCarNo { get; set; }
|
|
/// <summary>
|
/// 备注（对应数据库 remark 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "remark")]
|
public string? Remark { get; set; }
|
|
/// <summary>
|
/// 状态:1-待签收 2-签收中 3-已完成 4-撤回 8-已作废 5-申请中 7-同意 9-部分同意 10-已冻结 11-申请撤回（对应数据库 status 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "status")]
|
public string? Status { get; set; }
|
|
/// <summary>
|
/// 直运标识:1-是 0-否（对应数据库 direct_delivery_flag 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "direct_delivery_flag")]
|
public string? DirectDeliveryFlag { get; set; }
|
|
/// <summary>
|
/// 物流状态:0-未发出 1-已发货 2-已到货（对应数据库 logistics_status 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "logistics_status")]
|
public string? LogisticsStatus { get; set; }
|
|
/// <summary>
|
/// 最后一次发布时间（对应数据库 publish_time 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "publish_time")]
|
public string? PublishTime { get; set; }
|
|
/// <summary>
|
/// 最后一次更新时间（对应数据库 update_time 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "update_time")]
|
public string? UpdateTime { get; set; }
|
|
/// <summary>
|
/// 利润中心编码（对应数据库 profit_center_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "profit_center_code")]
|
public string? ProfitCenterCode { get; set; }
|
|
/// <summary>
|
/// 整单毛重（对应数据库 gross_weight 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "gross_weight")]
|
public string? GrossWeight { get; set; }
|
|
/// <summary>
|
/// 整单净重（对应数据库 net_weight 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "net_weight")]
|
public string? NetWeight { get; set; }
|
|
/// <summary>
|
/// 重量单位编码（对应数据库 unit_weight_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "unit_weight_code")]
|
public string? UnitWeightCode { get; set; }
|
|
/// <summary>
|
/// 重量单位名称（对应数据库 unit_weight_name 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "unit_weight_name")]
|
public string? UnitWeightName { get; set; }
|
|
/// <summary>
|
/// 总包装数（对应数据库 total_packing_qty 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "total_packing_qty")]
|
public string? TotalPackingQty { get; set; }
|
|
/// <summary>
|
/// 手工填写总包数（对应数据库 total_package_quantity 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "total_package_quantity")]
|
public string? TotalPackageQuantity { get; set; }
|
|
/// <summary>
|
/// 运输方式编码（对应数据库 transport_type_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "transport_type_code")]
|
public string? TransportTypeCode { get; set; }
|
|
/// <summary>
|
/// 运输方式名称（对应数据库 transport_type_name 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "transport_type_name")]
|
public string? TransportTypeName { get; set; }
|
|
/// <summary>
|
/// 包装方式编码（对应数据库 packing_way_code 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "packing_way_code")]
|
public string? PackingWayCode { get; set; }
|
|
/// <summary>
|
/// 包装方式名称（对应数据库 packing_way_name 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "packing_way_name")]
|
public string? PackingWayName { get; set; }
|
|
/// <summary>
|
/// 扩展字段1（对应数据库 extend_n01 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "extend_n01")]
|
public string? ExtendN01 { get; set; }
|
|
/// <summary>
|
/// 扩展字段2（对应数据库 extend_n02 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "extend_n02")]
|
public string? ExtendN02 { get; set; }
|
|
/// <summary>
|
/// 扩展字段3（对应数据库 extend_n03 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "extend_n03")]
|
public string? ExtendN03 { get; set; }
|
|
/// <summary>
|
/// 扩展字段4（对应数据库 platform_extend_n04 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "platform_extend_n04")]
|
public string? PlatformExtendN04 { get; set; }
|
|
/// <summary>
|
/// 扩展字段5（对应数据库 platform_extend_n05 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "platform_extend_n05")]
|
public string? PlatformExtendN05 { get; set; }
|
|
/// <summary>
|
/// 扩展字段6（对应数据库 platform_extend_n06 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "platform_extend_n06")]
|
public string? PlatformExtendN06 { get; set; }
|
|
/// <summary>
|
/// 扩展字段7（对应数据库 platform_extend_n07 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "platform_extend_n07")]
|
public string? PlatformExtendN07 { get; set; }
|
|
/// <summary>
|
/// 扩展字段8（对应数据库 platform_extend_n08 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "platform_extend_n08")]
|
public string? PlatformExtendN08 { get; set; }
|
|
/// <summary>
|
/// 货物送达日期(时间戳)（对应数据库 cargo_delivery_time 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "cargo_delivery_time")]
|
public string? CargoDeliveryTime { get; set; }
|
|
/// <summary>
|
/// 物流方式:1-供应商送货 2-快递 3-采购方自提（对应数据库 logistics_type 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "logistics_type")]
|
public string? LogisticsType { get; set; }
|
|
/// <summary>
|
/// 物流方式中文展示（对应数据库 logistics_type_show 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "logistics_type_show")]
|
public string? LogisticsTypeShow { get; set; }
|
|
/// <summary>
|
/// 物流单号（对应数据库 logistics_number 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "logistics_number")]
|
public string? LogisticsNumber { get; set; }
|
|
/// <summary>
|
/// 优先检验:0-正常 1-优先 2-紧急（对应数据库 first_check 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "first_check")]
|
public string? FirstCheck { get; set; }
|
|
/// <summary>
|
/// 创建日期（对应数据库 create_date 列，默认值 getdate()）
|
/// </summary>
|
[SugarColumn(ColumnName = "create_date", IsNullable = false, DefaultValue = "getdate()")]
|
public DateTime CreateDate { get; set; }
|
|
/// <summary>
|
/// 最后操作时间戳（对应数据库 last_operate_time 列）
|
/// </summary>
|
[SugarColumn(ColumnName = "last_operate_time")]
|
public string? LastOperateTime { get; set; }
|
|
/// <summary>
|
/// 是否同步到货明细（0：未同步 1：已同步）（对应数据库 is_get_detail 列，默认值 0）
|
/// </summary>
|
[SugarColumn(ColumnName = "is_get_detail", IsNullable = false, DefaultValue = "0")]
|
public int IsGetDetail { get; set; } = 0;
|
|
/// <summary>
|
/// 是否同步条码明细（0：未同步 1：已同步）（对应数据库 is_get_bar 列，默认值 0）
|
/// </summary>
|
[SugarColumn(ColumnName = "is_get_bar", IsNullable = false, DefaultValue = "0")]
|
public int IsGetBar { get; set; } = 0;
|
|
/// <summary>
|
/// 是否确认到货（0：未确认 1：已确认）（对应数据库 is_CFR 列，默认值 0）
|
/// </summary>
|
[SugarColumn(ColumnName = "is_CFR", IsNullable = false, DefaultValue = "0")]
|
public int IsCfr { get; set; } = 0;
|
|
/// <summary>
|
/// 调用获取送货单次数（对应数据库 get_detail_times 列，默认值 0）
|
/// </summary>
|
[SugarColumn(ColumnName = "get_detail_times", IsNullable = false, DefaultValue = "0")]
|
public int GetDetailTimes { get; set; } = 0;
|
|
/// <summary>
|
/// 调用获取条码次数（对应数据库 get_bar_times 列，默认值 0）
|
/// </summary>
|
[SugarColumn(ColumnName = "get_bar_times", IsNullable = false, DefaultValue = "0")]
|
public int GetBarTimes { get; set; } = 0;
|
}
|
