更新平板功能，首检页面生成巡检单

zyf

2025-04-12 b2be3b6939b4382f9165c78857a072f1aa7b01d0

 MES.Service/Modes/ProductionOrder.cs

@@ -1,275 +1,281 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     生产订单表(委外)
/// </summary>
[SugarTable("PRODUCTION_ORDER")]
public class ProductionOrder
namespace MES.Service.Modes
{
    /// <summary>
    ///     SEQ_ORDER
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }
    /// 生产订单表(委外)
    ///</summary>
    [SugarTable("PRODUCTION_ORDER")]
    public class ProductionOrder
    {
        /// <summary>
        /// SEQ_ORDER 
        ///</summary>
        [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)]
        public decimal Id { get; set; }

    /// <summary>
    ///     单据编号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_NO")]
    public string? OrderNo { get; set; }
        /// <summary>
        /// 单据编号 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_NO")]
        public string? OrderNo { get; set; }

    /// <summary>
    ///     贴片工艺属性
    /// </summary>
    [SugarColumn(ColumnName = "SMT_PROCESS_ATTR")]
    public string? SmtProcessAttr { get; set; }
        /// <summary>
        /// 贴片工艺属性 
        ///</summary>
        [SugarColumn(ColumnName = "SMT_PROCESS_ATTR")]
        public string? SmtProcessAttr { get; set; }

    /// <summary>
    ///     仓库
    /// </summary>
    [SugarColumn(ColumnName = "WAREHOUSE")]
    public string? Warehouse { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
        [SugarColumn(ColumnName = "WAREHOUSE")]
        public string? Warehouse { get; set; }

    /// <summary>
    ///     单据日期
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_DATE")]
    public DateTime? OrderDate { get; set; }
        /// <summary>
        /// 单据日期 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_DATE")]
        public DateTime? OrderDate { get; set; }

    /// <summary>
    ///     单据类型
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_TYPE")]
    public string? OrderType { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_TYPE")]
        public string? OrderType { get; set; }

    /// <summary>
    ///     业务状态
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_STATUS")]
    public string? BusinessStatus { get; set; }
        /// <summary>
        /// 业务状态 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_STATUS")]
        public string? BusinessStatus { get; set; }

    /// <summary>
    ///     产品编码
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_CODE")]
    public string? ProductCode { get; set; }
        /// <summary>
        /// 产品编码 
        ///</summary>
        [SugarColumn(ColumnName = "PRODUCT_CODE")]
        public string? ProductCode { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
        [SugarColumn(ColumnName = "UNIT")]
        public string? Unit { get; set; }

    /// <summary>
    ///     工单数量
    /// </summary>
    [SugarColumn(ColumnName = "WORK_ORDER_QTY")]
    public decimal? WorkOrderQty { get; set; }
        /// <summary>
        /// 工单数量 
        ///</summary>
        [SugarColumn(ColumnName = "WORK_ORDER_QTY")]
        public double? WorkOrderQty { get; set; }

    /// <summary>
    ///     计划组
    /// </summary>
    [SugarColumn(ColumnName = "PLANNING_GROUP")]
    public string? PlanningGroup { get; set; }
        /// <summary>
        /// 计划组 
        ///</summary>
        [SugarColumn(ColumnName = "PLANNING_GROUP")]
        public string? PlanningGroup { get; set; }

    /// <summary>
    ///     计划员
    /// </summary>
    [SugarColumn(ColumnName = "PLANNER")]
    public string? Planner { get; set; }
        /// <summary>
        /// 计划员 
        ///</summary>
        [SugarColumn(ColumnName = "PLANNER")]
        public string? Planner { get; set; }

    /// <summary>
    ///     预计开工时间
    /// </summary>
    [SugarColumn(ColumnName = "ESTIMATED_START_TIME")]
    public DateTime? EstimatedStartTime { get; set; }
        /// <summary>
        /// 预计开工时间 
        ///</summary>
        [SugarColumn(ColumnName = "ESTIMATED_START_TIME")]
        public DateTime? PlanStartDate { get; set; }

    /// <summary>
    ///     预计完工时间
    /// </summary>
    [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
    public DateTime? EstimatedEndTime { get; set; }
        /// <summary>
        /// 预计完工时间 
        ///</summary>
        [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
        public DateTime? PlanFinishDate { get; set; }

    /// <summary>
    ///     计划下达日期
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_RELEASE_DATE")]
    public DateTime? PlanReleaseDate { get; set; }
        /// <summary>
        /// 计划下达日期 
        ///</summary>
        [SugarColumn(ColumnName = "PLAN_RELEASE_DATE")]
        public DateTime? PlanReleaseDate { get; set; }

    /// <summary>
    ///     入库上限
    /// </summary>
    [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")]
    public decimal? StorageUpperLimit { get; set; }
        /// <summary>
        /// 入库上限 
        ///</summary>
        [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")]
        public double? StorageUpperLimit { get; set; }

    /// <summary>
    ///     入库下限
    /// </summary>
    [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
    public decimal? StorageLowerLimit { get; set; }
        /// <summary>
        /// 入库下限 
        ///</summary>
        [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
        public double? StorageLowerLimit { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "TRACKING_NO")]
    public string? TrackingNo { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
        [SugarColumn(ColumnName = "TRACKING_NO")]
        public string? TrackingNo { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "BATCH_NO")]
    public string? BatchNo { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_NO")]
        public string? BatchNo { get; set; }

    /// <summary>
    ///     BOM版次
    /// </summary>
    [SugarColumn(ColumnName = "BOM_VERSION")]
    public string? BomVersion { get; set; }
        /// <summary>
        /// BOM版次 
        ///</summary>
        [SugarColumn(ColumnName = "BOM_VERSION")]
        public string? BomVersion { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER_NO")]
    public string? SalesOrderNo { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_NO")]
        public string? SalesOrderNo { get; set; }

    /// <summary>
    ///     销售订单行号
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER_LINE_NO")]
    public string? SalesOrderLineNo { get; set; }
        /// <summary>
        /// 销售订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_LINE_NO")]
        public string? SalesOrderLineNo { get; set; }

    /// <summary>
    ///     生成方式
    /// </summary>
    [SugarColumn(ColumnName = "GENERATION_METHOD")]
    public string? GenerationMethod { get; set; }
        /// <summary>
        /// 生成方式 
        ///</summary>
        [SugarColumn(ColumnName = "GENERATION_METHOD")]
        public string? GenerationMethod { get; set; }

    /// <summary>
    ///     ERP生产订单ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_ID")]
    public string? ErpProductionOrderId { get; set; }
        /// <summary>
        /// ERP生产订单ID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_ID")]
        public string? ErpProductionOrderId { get; set; }

    /// <summary>
    ///     ERP生产订单序号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_LINE_NO")]
    public string? ErpProductionOrderLineNo { get; set; }
        /// <summary>
        /// ERP生产订单序号 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_LINE_NO")]
        public string? ErpProductionOrderLineNo { get; set; }

    /// <summary>
    ///     ERP生产订单单号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_NO")]
    public string? ErpProductionOrderNo { get; set; }
        /// <summary>
        /// ERP生产订单单号 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_NO")]
        public string? ErpProductionOrderNo { get; set; }

    /// <summary>
    ///     源单类型
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_ORDER_TYPE")]
    public string? SourceOrderType { get; set; }
        /// <summary>
        /// 源单类型 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_TYPE")]
        public string? SourceOrderType { get; set; }

    /// <summary>
    ///     源单编号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_ORDER_NO")]
    public string? SourceOrderNo { get; set; }
        /// <summary>
        /// 源单编号 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_NO")]
        public string? SourceOrderNo { get; set; }

    /// <summary>
    ///     源单分录行号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_ORDER_ENTRY_NO")]
    public string? SourceOrderEntryNo { get; set; }
        /// <summary>
        /// 源单分录行号 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_ENTRY_NO")]
        public string? SourceOrderEntryNo { get; set; }

    /// <summary>
    ///     需求单据号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_ORDER_NO")]
    public string? DemandOrderNo { get; set; }
        /// <summary>
        /// 需求单据号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_ORDER_NO")]
        public string? DemandOrderNo { get; set; }

    /// <summary>
    ///     需求单据行号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_ORDER_LINE_NO")]
    public string? DemandOrderLineNo { get; set; }
        /// <summary>
        /// 需求单据行号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_ORDER_LINE_NO")]
        public string? DemandOrderLineNo { get; set; }

    /// <summary>
    ///     结案人
    /// </summary>
    [SugarColumn(ColumnName = "CLOSING_PERSON")]
    public string? ClosingPerson { get; set; }
        /// <summary>
        /// 结案人 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSING_PERSON")]
        public string? ClosingPerson { get; set; }

    /// <summary>
    ///     结案类型
    /// </summary>
    [SugarColumn(ColumnName = "CLOSING_TYPE")]
    public string? ClosingType { get; set; }
        /// <summary>
        /// 结案类型 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSING_TYPE")]
        public string? ClosingType { get; set; }

    /// <summary>
    ///     源拆分订单编号
    /// </summary>
    [SugarColumn(ColumnName = "SPLIT_ORDER_NO")]
    public string? SplitOrderNo { get; set; }
        /// <summary>
        /// 源拆分订单编号 
        ///</summary>
        [SugarColumn(ColumnName = "SPLIT_ORDER_NO")]
        public string? SplitOrderNo { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string? Remarks { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }

    /// <summary>
    ///     ERPID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public string? ErpId { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_ID")]
        public string? ErpId { get; set; }

    /// <summary>
    ///     ERP生产订单分录内码
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
    public string? ErpProductionEntryCode { get; set; }
        /// <summary>
        /// ERP生产订单分录内码 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
        public string? ErpProductionEntryCode { get; set; }

    /// <summary>
    ///     采购订单
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASEORDERNO")]
    public string? PurchaseOrderNo { get; set; }
        /// <summary>
        /// 采购订单 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASEORDERNO")]
        public string? PurchaseOrderNo { get; set; }

    /// <summary>
    ///     采购订单行号
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASEORDERENTRYSEQ")]
    public long? PurchaseOrderEntrySeq { get; set; }
        /// <summary>
        /// 采购订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASEORDERENTRYSEQ")]
        public long? PurchaseOrderEntrySeq { get; set; }

    /// <summary>
    ///     标准点数
    /// </summary>
    [SugarColumn(ColumnName = "STANDARDPOINTS")]
    public decimal? StandardPoints { get; set; }
        /// <summary>
        /// 标准点数 
        ///</summary>
        [SugarColumn(ColumnName = "STANDARDPOINTS")]
        public decimal? Standardpoints { get; set; }

    /// <summary>
    ///     计价点数
    /// </summary>
    [SugarColumn(ColumnName = "PRICINGPOINTS")]
    public decimal? PricingPoints { get; set; }
        /// <summary>
        /// 计价点数 
        ///</summary>
        [SugarColumn(ColumnName = "PRICINGPOINTS")]
        public decimal? Pricingpoints { get; set; }

    /// <summary>
    ///     入库数量
    /// </summary>
    [SugarColumn(ColumnName = "STOCKINQTY")]
    public decimal? StockInQty { get; set; }
        /// <summary>
        /// 入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "STOCKINQTY")]
        public decimal? StockInQty { get; set; }

    /// <summary>
    ///     未入库数量
    /// </summary>
    [SugarColumn(ColumnName = "NOSTOCKINQTY")]
    public decimal? NoStockInQty { get; set; }
        /// <summary>
        /// 未入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "NOSTOCKINQTY")]
        public double? NoStockInQty { get; set; }

    /// <summary>
    ///     入库货主
    /// </summary>
    [SugarColumn(ColumnName = "STOCKOWNER")]
    public string? StockOwner { get; set; }
        /// <summary>
        /// 入库货主 
        ///</summary>
        [SugarColumn(ColumnName = "STOCKOWNER")]
        public string? StockOwner { get; set; }

        /// <summary>
        /// 供应商
        ///</summary>
        [SugarColumn(ColumnName = "SUPP_NO")]
        public string? SUPPLIER { get; set; }
    }
}