| | |
|---|
| | | using SqlSugar; |
|---|
| | | |
|---|
| | | namespace MES.Service.Models; |
|---|
| | | namespace NewPdaSqlServer.entity; |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 送货通知单据明细表 |
|---|
| | | /// 送货通知单据明细表 |
|---|
| | | /// </summary> |
|---|
| | | [SugarTable("DELIVERY_NOTICE_DETAIL")] |
|---|
| | | public class DeliveryNoticeDetail |
|---|
| | | { |
|---|
| | | /// <summary> |
|---|
| | | /// 主键Guid（SEQ_XKY） |
|---|
| | | /// 主键Guid（SEQ_XKY） |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "id")] |
|---|
| | | public Guid Id { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 项次号 |
|---|
| | | /// 项次号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "line_no")] |
|---|
| | | public string LineNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// ERP采购单号 |
|---|
| | | /// ERP采购单号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "po_erp_no")] |
|---|
| | | public string PoErpNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 采购单类型 1：一般采购；2：委外采购 |
|---|
| | | /// 采购单类型 1：一般采购；2：委外采购 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "purchase_type")] |
|---|
| | | public string PurchaseType { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 采购单项次 |
|---|
| | | /// 采购单项次 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "po_line_no")] |
|---|
| | | public string PoLineNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品编码 |
|---|
| | | /// 产品编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "product_code")] |
|---|
| | | public string ProductCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品名称 |
|---|
| | | /// 产品名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "product_name")] |
|---|
| | | public string ProductName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品规格 |
|---|
| | | /// 产品规格 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "product_scale")] |
|---|
| | | public string ProductScale { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货单位编码 |
|---|
| | | /// 出货单位编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "delivery_unit_code")] |
|---|
| | | public string DeliveryUnitCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货单位名称 |
|---|
| | | /// 出货单位名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "delivery_unit_name")] |
|---|
| | | public string DeliveryUnitName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货数量 |
|---|
| | | /// 出货数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "delivery_qty")] |
|---|
| | | public string DeliveryQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货计价数量 |
|---|
| | | /// 出货计价数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "delivery_valuation_qty")] |
|---|
| | | public string DeliveryValuationQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货产品单价 |
|---|
| | | /// 出货产品单价 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "price")] |
|---|
| | | public string Price { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 出货产品含税单价 |
|---|
| | | /// 出货产品含税单价 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "tax_price")] |
|---|
| | | public string TaxPrice { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 排程自定义项的值 |
|---|
| | | /// 排程自定义项的值 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "sch_dynamic_value")] |
|---|
| | | public string SchDynamicValue { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 排程批次号 |
|---|
| | | /// 排程批次号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "schedule_batch_no")] |
|---|
| | | public string ScheduleBatchNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 排程单号 |
|---|
| | | /// 排程单号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "schedule_order_no")] |
|---|
| | | public string ScheduleOrderNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 对应排程ItemDetail的主键列 |
|---|
| | | /// 对应排程ItemDetail的主键列 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "schedule_detail_no")] |
|---|
| | | public string ScheduleDetailNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 是否急料 0:否 ; 1：是 |
|---|
| | | /// 是否急料 0:否 ; 1：是 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "urgent_flag")] |
|---|
| | | public string UrgentFlag { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 原始单据类型 1：订单；2：排程；3：退货；4：备品 |
|---|
| | | /// 原始单据类型 1：订单；2：排程；3：退货；4：备品 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "src_bill_type")] |
|---|
| | | public string SrcBillType { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 采购项次的采购说明信息 |
|---|
| | | /// 采购项次的采购说明信息 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "purchase_desc")] |
|---|
| | | public string PurchaseDesc { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 单据备注，srcBillType=1 对应采购订单单身的备注；srcBillType=2 对应排程项次的备注 |
|---|
| | | /// 单据备注，srcBillType=1 对应采购订单单身的备注；srcBillType=2 对应排程项次的备注 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "src_order_line_remark")] |
|---|
| | | public string SrcOrderLineRemark { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 状态（1:待签收；2:签收中；3:已完成） |
|---|
| | | /// 状态（1:待签收；2:签收中；3:已完成） |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "status")] |
|---|
| | | public string Status { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 收货状态（0-未收货；1-部分收货；2-全部收货） |
|---|
| | | /// 收货状态（0-未收货；1-部分收货；2-全部收货） |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "receive_status")] |
|---|
| | | public string ReceiveStatus { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 整单毛重 |
|---|
| | | /// 整单毛重 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "gross_weight")] |
|---|
| | | public string GrossWeight { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 整单净重 |
|---|
| | | /// 整单净重 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "net_weight")] |
|---|
| | | public string NetWeight { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 重量单位编码 |
|---|
| | | /// 重量单位编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "unit_weight_code")] |
|---|
| | | public string UnitWeightCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 重量单位名称 |
|---|
| | | /// 重量单位名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "unit_weight_name")] |
|---|
| | | public string UnitWeightName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 包装数 |
|---|
| | | /// 包装数 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "packing_qty")] |
|---|
| | | public string PackingQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 品牌名称 |
|---|
| | | /// 品牌名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "brand_name")] |
|---|
| | | public string BrandName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 其他扩展字段 |
|---|
| | | /// 其他扩展字段 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "other_extend")] |
|---|
| | | public string OtherExtend { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 原产国编码 |
|---|
| | | /// 原产国编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "original_country_code")] |
|---|
| | | public string OriginalCountryCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 原产国名称 |
|---|
| | | /// 原产国名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "original_country_name")] |
|---|
| | | public string OriginalCountryName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 备注 |
|---|
| | | /// 备注 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "remark")] |
|---|
| | | public string Remark { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段1 |
|---|
| | | /// 扩展字段1 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n01")] |
|---|
| | | public string ExtendN01 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段2 |
|---|
| | | /// 扩展字段2 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n02")] |
|---|
| | | public string ExtendN02 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段3 |
|---|
| | | /// 扩展字段3 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n03")] |
|---|
| | | public string ExtendN03 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段4 |
|---|
| | | /// 扩展字段4 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n04")] |
|---|
| | | public string ExtendN04 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段5 |
|---|
| | | /// 扩展字段5 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n05")] |
|---|
| | | public string ExtendN05 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 扩展字段6 |
|---|
| | | /// 扩展字段6 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "extend_n06")] |
|---|
| | | public string ExtendN06 { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 库存地点编码 |
|---|
| | | /// 库存地点编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "store_code")] |
|---|
| | | public string StoreCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 库存地点名称 |
|---|
| | | /// 库存地点名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "store_name")] |
|---|
| | | public string StoreName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 已签收数量 |
|---|
| | | /// 已签收数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "verify_qty")] |
|---|
| | | public string VerifyQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 可入库数量 |
|---|
| | | /// 可入库数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "allow_qty")] |
|---|
| | | public string AllowQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 让步接收数量 |
|---|
| | | /// 让步接收数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "compromise_qty")] |
|---|
| | | public string CompromiseQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 拒收数量 |
|---|
| | | /// 拒收数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "refused_qty")] |
|---|
| | | public string RefusedQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 退货单ERP编号 |
|---|
| | | /// 退货单ERP编号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "rto_erp_no")] |
|---|
| | | public string RtoErpNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 退货单项次 |
|---|
| | | /// 退货单项次 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "rto_line_no")] |
|---|
| | | public string RtoLineNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品长度 |
|---|
| | | /// 产品长度 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "prod_length")] |
|---|
| | | public string ProdLength { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品宽度 |
|---|
| | | /// 产品宽度 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "prod_width")] |
|---|
| | | public string ProdWidth { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 产品高度 |
|---|
| | | /// 产品高度 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "prod_height")] |
|---|
| | | public string ProdHeight { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 采购员姓名 |
|---|
| | | /// 采购员姓名 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "buyer_name")] |
|---|
| | | public string BuyerName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 预计交期 |
|---|
| | | /// 预计交期 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "expected_date")] |
|---|
| | | public string ExpectedDate { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 回复交期 |
|---|
| | | /// 回复交期 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "answer_date")] |
|---|
| | | public string AnswerDate { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 币种编码 |
|---|
| | | /// 币种编码 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "currency_code")] |
|---|
| | | public string CurrencyCode { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 币种名称 |
|---|
| | | /// 币种名称 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "currency_name")] |
|---|
| | | public string CurrencyName { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 发送签收状态 |
|---|
| | | /// 发送签收状态 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "send_verify_status")] |
|---|
| | | public string SendVerifyStatus { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 结果标识 |
|---|
| | | /// 结果标识 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "result_flag")] |
|---|
| | | public string ResultFlag { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 申请出货数量 |
|---|
| | | /// 申请出货数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "apply_delivery_qty")] |
|---|
| | | public string ApplyDeliveryQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 申请出货计价数量 |
|---|
| | | /// 申请出货计价数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "apply_delivery_valuation_qty")] |
|---|
| | | public string ApplyDeliveryValuationQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 批号 |
|---|
| | | /// 批号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "batch_number")] |
|---|
| | | public string BatchNumber { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 已收货数量 |
|---|
| | | /// 已收货数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "receive_qty")] |
|---|
| | | public string ReceiveQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 已入库数量 |
|---|
| | | /// 已入库数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "storage_qty")] |
|---|
| | | public string StorageQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 退货数量 |
|---|
| | | /// 退货数量 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "return_qty")] |
|---|
| | | public string ReturnQty { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 优先检验:0-正常 1-优先 2-紧急 |
|---|
| | | /// 优先检验:0-正常 1-优先 2-紧急 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "first_check")] |
|---|
| | | public string FirstCheck { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 采购单项次显示用 |
|---|
| | | /// 采购单项次显示用 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "po_line_no_show")] |
|---|
| | | public string PoLineNoShow { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 多语言备注 |
|---|
| | | /// 多语言备注 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "remarks")] |
|---|
| | | public string Remarks { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 创建时间 |
|---|
| | | /// 创建时间 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "create_time")] |
|---|
| | | public string CreateTime { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 更新时间 |
|---|
| | | /// 更新时间 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "update_time")] |
|---|
| | | public string UpdateTime { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 关联主表ID |
|---|
| | | /// 关联主表ID |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "pid")] |
|---|
| | | public string Pid { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 排程项次号 |
|---|
| | | /// 排程项次号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "plan_line_no")] |
|---|
| | | public string PlanLineNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 送货单号 |
|---|
| | | /// 送货单号 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "delivery_no")] |
|---|
| | | public string DeliveryNo { get; set; } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 同步时间 |
|---|
| | | /// 同步时间 |
|---|
| | | /// </summary> |
|---|
| | | [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")] |
|---|
| | | public DateTime? SynchronousDate { get; set; } |
|---|
