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

zyf

2025-04-12 b2be3b6939b4382f9165c78857a072f1aa7b01d0

 MES.Service/Modes/Womcaa.cs

@@ -1,282 +1,242 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     工单表
/// </summary>
[SugarTable("WOMCAA")]
public class Womcaa
namespace MES.Service.Modes
{
    /// <summary>
    ///     自增列  SEQ_AOI
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
    /// 任务单表
    ///</summary>
    [SugarTable("WOMCAA")]
    public class Womcaa
    {
        /// <summary>
        /// 自增列 
        ///</summary>
         [SugarColumn(ColumnName="ID", IsPrimaryKey = true,
        OracleSequenceName = "SEQ_AOI")]
    public decimal? Id { get; set; }

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

    /// <summary>
    ///     单号
    /// </summary>
    [SugarColumn(ColumnName = "CAA001")]
    public string? Caa001 { get; set; }

    /// <summary>
    ///     单据类型 1、直接入库-普通生产 SCDD03_SYS2、直接入库-返工生产 SCDD04_SYS3、工序汇报-普通生产
    ///     SCDD01_SYS4、工序汇报-返工生产 SCDD02_SYS
    /// </summary>
    [SugarColumn(ColumnName = "CAA004")]
    public string? Caa004 { get; set; }

    /// <summary>
    ///     开单日期
    /// </summary>
    [SugarColumn(ColumnName = "CAA005")]
    public string? Caa005 { get; set; }

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

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

    /// <summary>
    ///     预计开工时间
    /// </summary>
    [SugarColumn(ColumnName = "CAA010")]
    public string? Caa010 { get; set; }

    /// <summary>
    ///     预计完工时间
    /// </summary>
    [SugarColumn(ColumnName = "CAA011")]
    public string? Caa011 { get; set; }

    /// <summary>
    ///     数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA012")]
    public decimal? Caa012 { get; set; }

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

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

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

    /// <summary>
    ///     已排数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA017")]
    public decimal? Caa017 { get; set; }

    /// <summary>
    ///     ERP源单ID
    /// </summary>
    [SugarColumn(ColumnName = "CAA018")]
    public decimal? Caa018 { get; set; }

    /// <summary>
    ///     ERP源单行号
    /// </summary>
    [SugarColumn(ColumnName = "CAA019")]
    public decimal? Caa019 { get; set; }

    /// <summary>
    ///     ERP源单单号(任务单号)
    /// </summary>
    [SugarColumn(ColumnName = "CAA020")]
    public string? Caa020 { get; set; }

    /// <summary>
    ///     工作车间
    /// </summary>
    [SugarColumn(ColumnName = "CAA021")]
    public string? Caa021 { get; set; }

    /// <summary>
    ///     审核码
    /// </summary>
    [SugarColumn(ColumnName = "FSTATUS")]
    public decimal? Fstatus { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_USER")]
    public string? CheckUser { get; set; }

    /// <summary>
    ///     未排数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA022")]
    public decimal? Caa022 { get; set; }

    /// <summary>
    ///     状态 完工，未完工
    /// </summary>
    [SugarColumn(ColumnName = "CAA023")]
    public string? Caa023 { get; set; }

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

    /// <summary>
    ///     工艺路线
    /// </summary>
    [SugarColumn(ColumnName = "ROUTING_ID")]
    public string? RoutingId { get; set; }

    /// <summary>
    ///     产线
    /// </summary>
    [SugarColumn(ColumnName = "WORK_SHOP_ID")]
    public string? WorkShopId { get; set; }

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

    /// <summary>
    ///     单据日期
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public string? CreateDate { get; set; }

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

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

    /// <summary>
    ///     入库上限
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_INLIMITH")]
    public string? StockInlimith { get; set; }

    /// <summary>
    ///     入库下限
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_INLIMITL")]
    public string? StockInlimitl { get; set; }

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

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

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

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

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

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

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

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

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

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

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

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

    /// <summary>
    ///     生产订单行内码
    /// </summary>
    [SugarColumn(ColumnName = "FMOENTRYID")]
    public decimal? FMOENTRYID { get; set; }
}
         public decimal? Id { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
         [SugarColumn(ColumnName="ERPID"    )]
         public decimal? Erpid { get; set; }
        /// <summary>
        /// 单据编号 
        ///</summary>
         [SugarColumn(ColumnName="CAA001"    )]
         public string? Caa001 { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
         [SugarColumn(ColumnName="CAA004"    )]
         public string? Caa004 { get; set; }
        /// <summary>
        /// 计划下达日期 
        ///</summary>
         [SugarColumn(ColumnName="CAA005"    )]
         public string? Caa005 { get; set; }
        /// <summary>
        /// 产品编码 
        ///</summary>
         [SugarColumn(ColumnName="CAA006"    )]
         public string? Caa006 { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
         [SugarColumn(ColumnName="CAA009"    )]
         public string? Caa009 { get; set; }
        /// <summary>
        /// 预计开工时间 
        ///</summary>
         [SugarColumn(ColumnName="CAA010"    )]
         public string? Caa010 { get; set; }
        /// <summary>
        /// 预计完工时间 
        ///</summary>
         [SugarColumn(ColumnName="CAA011"    )]
         public string? Caa011 { get; set; }
        /// <summary>
        /// 工单数量 
        ///</summary>
         [SugarColumn(ColumnName="CAA012"    )]
         public decimal? Caa012 { get; set; }
        /// <summary>
        /// BOM版次 
        ///</summary>
         [SugarColumn(ColumnName="CAA013"    )]
         public string? Caa013 { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
         [SugarColumn(ColumnName="CAA015"    )]
         public string? Caa015 { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="CAA016"    )]
         public string? Caa016 { get; set; }
        /// <summary>
        /// 已排数量（弃用） 
        ///</summary>
         [SugarColumn(ColumnName="CAA017"    )]
         public decimal? Caa017 { get; set; }
        /// <summary>
        /// ERP生产订单ID 
        ///</summary>
         [SugarColumn(ColumnName="CAA018"    )]
         public decimal? Caa018 { get; set; }
        /// <summary>
        /// ERP生产订单序号 
        ///</summary>
         [SugarColumn(ColumnName="CAA019"    )]
         public decimal? Caa019 { get; set; }
        /// <summary>
        /// ERP生产订单单号 
        ///</summary>
         [SugarColumn(ColumnName="CAA020"    )]
         public string? Caa020 { get; set; }
        /// <summary>
        /// 生产车间 
        ///</summary>
         [SugarColumn(ColumnName="CAA021"    )]
         public string? Caa021 { get; set; }
        /// <summary>
        /// 审核码 
        ///</summary>
         [SugarColumn(ColumnName="FSTATUS"    )]
         public decimal? Fstatus { get; set; }
        /// <summary>
        /// 审核日期 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_DATE"    )]
         public DateTime? CheckDate { get; set; }
        /// <summary>
        /// 审核人 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_USER"    )]
         public string? CheckUser { get; set; }
        /// <summary>
        /// 未排数量（弃用） 
        ///</summary>
         [SugarColumn(ColumnName="CAA022"    )]
         public decimal? Caa022 { get; set; }
        /// <summary>
        /// &quot;工单状态 1、计划 2、计划确认 3、下达 4、开工 5、完工 6、结案 7、结算&quot; 
        ///</summary>
         [SugarColumn(ColumnName="CAA023"    )]
         public string? Caa023 { get; set; }
        /// <summary>
        /// 已入库数量 
        ///</summary>
         [SugarColumn(ColumnName="CAA024"    )]
         public decimal? Caa024 { get; set; }
        /// <summary>
        /// 工艺路线 
        ///</summary>
         [SugarColumn(ColumnName="ROUTING_ID"    )]
         public string? RoutingId { get; set; }
        /// <summary>
        /// 产线 
        ///</summary>
         [SugarColumn(ColumnName="WORK_SHOP_ID"    )]
         public string? WorkShopId { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string? DepotCode { get; set; }
        /// <summary>
        /// 单据日期 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_DATE"    )]
         public string? CreateDate { get; set; }
        /// <summary>
        /// 计划组 
        ///</summary>
         [SugarColumn(ColumnName="WORK_GROUP_ID"    )]
         public string? WorkGroupId { get; set; }
        /// <summary>
        /// 计划员 
        ///</summary>
         [SugarColumn(ColumnName="PLAN_ID"    )]
         public string? PlanId { get; set; }
        /// <summary>
        /// 入库上限 
        ///</summary>
         [SugarColumn(ColumnName="STOCK_INLIMITH"    )]
         public string? StockInlimith { get; set; }
        /// <summary>
        /// 入库下限 
        ///</summary>
         [SugarColumn(ColumnName="STOCK_INLIMITL"    )]
         public string? StockInlimitl { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
         [SugarColumn(ColumnName="MTONO"    )]
         public string? Mtono { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
         [SugarColumn(ColumnName="LOT"    )]
         public string? Lot { get; set; }
        /// <summary>
        /// 销售订单行号 
        ///</summary>
         [SugarColumn(ColumnName="CAA015_HEAD"    )]
         public string? Caa015Head { get; set; }
        /// <summary>
        /// 生成方式 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_TYPE"    )]
         public string? CreateType { get; set; }
        /// <summary>
        /// 源单类型 
        ///</summary>
         [SugarColumn(ColumnName="SRC_BILL_TYPE"    )]
         public string? SrcBillType { get; set; }
        /// <summary>
        /// 源单编码 
        ///</summary>
         [SugarColumn(ColumnName="SRC_BILL_NO"    )]
         public string? SrcBillNo { get; set; }
        /// <summary>
        /// 源单分录行号 
        ///</summary>
         [SugarColumn(ColumnName="SRC_BILLENTRYSEQ"    )]
         public string? SrcBillentryseq { get; set; }
        /// <summary>
        /// 需求单据号 
        ///</summary>
         [SugarColumn(ColumnName="SALE_ORDER_NO"    )]
         public string? SaleOrderNo { get; set; }
        /// <summary>
        /// 需求单据行号 
        ///</summary>
         [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ"    )]
         public string? SaleOrderEntryseq { get; set; }
        /// <summary>
        /// 结案人 
        ///</summary>
         [SugarColumn(ColumnName="FORCE_CLOSERID"    )]
         public string? ForceCloserid { get; set; }
        /// <summary>
        /// 结案类型 
        ///</summary>
         [SugarColumn(ColumnName="CLOSE_TYPE"    )]
         public string? CloseType { get; set; }
        /// <summary>
        /// 源拆分订单编号 
        ///</summary>
         [SugarColumn(ColumnName="SRC_SPLIT_BILLNO"    )]
         public string? SrcSplitBillno { get; set; }
        /// <summary>
        /// 生产订单行内码 
        ///</summary>
         [SugarColumn(ColumnName="FMOENTRYID"    )]
         public decimal? Fmoentryid { get; set; }
        /// <summary>
        /// 排产线别 
        ///</summary>
         [SugarColumn(ColumnName="PROD_LINE"    )]
         public string? ProdLine { get; set; }
    }
}