更新erp生产订单接口

啊鑫

2024-07-18 29de86cadafc88d13b51ab4d07aa2d12de6dcab0

更新erp生产订单接口

 MES.Service/Dto/webApi/ErpCAA.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,39 @@
namespace MES.Service.Dto.webApi;

public class ErpCAA
{
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FBillNo { get; set; }
    public string? FWorkShopID0 { get; set; }
    public string? FRoutingId { get; set; }
    public string? FREMWorkShopId { get; set; }
    public string? FStockId { get; set; }
    public string? FDate { get; set; }
    public string? FBillType { get; set; }
    public string? FStatus { get; set; }
    public string? FMaterialId { get; set; }
    public string? FUnitId { get; set; }
    public string? FQty { get; set; }
    public string? FWorkGroupId { get; set; }
    public string? FPlannerID { get; set; }
    public string? FPlanStartDate { get; set; }
    public string? FPlanFinishDate { get; set; }
    public string? FConveyDate { get; set; }
    public string? FStockInLimitH { get; set; }
    public string? FStockInLimitL { get; set; }
    public string? FMTONO { get; set; }
    public string? FLot { get; set; }
    public string? FBomId { get; set; }
    public string? F_UNW_Text_xsddh { get; set; }
    public string? FCreateType { get; set; }
    public string? FSrcBillType { get; set; }
    public string? FSrcBillNo { get; set; }
    public string? FSrcBillEntrySeq { get; set; }
    public string? FSaleOrderNo { get; set; }
    public string? FSaleOrderEntrySeq { get; set; }
    public string? FForceCloserId { get; set; }
    public string? FCloseType { get; set; }
    public string? FSrcSplitBillNo { get; set; }
    public string? FMemoItem { get; set; }
}

 MES.Service/Dto/webApi/ErpCAB.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
namespace MES.Service.Dto.webApi;

public class ErpCAB
{
    public string? FBillNo { get; set; }
    public string? FMaterialID2 { get; set; }
    public string? FNeedQty2 { get; set; }
    public string? FPickedQty { get; set; }
    public string? FPositionNO { get; set; }
    public string? FOwnerID { get; set; }
    public string? FMTONO { get; set; }
    public string? FLot { get; set; }
    public string? FStockID { get; set; }
    public string? FIssueType { get; set; }
    public string? F_UNW_Text_tpgy { get; set; }
    public string? FUnitID { get; set; }
    public string? FSupplyType { get; set; }
    public string? FStdQty { get; set; }
    public string? FIsKeyItem { get; set; }
    public string? FNumerator { get; set; }
    public string? FDenominator { get; set; }
    public string ID { get; set; }
    public string PID { get; set; }
}

 MES.Service/Dto/webApi/ErpWOM.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
namespace MES.Service.Dto.webApi;

public class ErpWOM
{
    public ErpCAA ErpCaa { get; set; }
    public List<ErpCAB> ErpCabs { get; set; }
}

 MES.Service/Modes/SalesOrder.cs

@@ -11,7 +11,8 @@
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", IsPrimaryKey = true)]
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>

 MES.Service/Modes/Womcaa.cs

@@ -1,436 +1,276 @@
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     å·¥å•è¡¨
/// </summary>
[Table("WOMCAA")]
[SugarTable("WOMCAA")] //用于SqlSugar
[SugarTable("WOMCAA")]
public class Womcaa
{
    /// <summary>
    ///     è‡ªå¢žåˆ—  SEQ_AOI
    /// </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>
    [Column("CAA001")]
    [SugarColumn(ColumnName = "CAA001")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "单号长度不能超出50")]
    public string? Caa001 { get; set; }
    [SugarColumn(ColumnName = "CAA001")]
    public string Caa001 { get; set; }

    /// <summary>
    ///     ERP工单批次
    ///     å•æ®ç±»åž‹ 1、直接入库-普通生产 SCDD03_SYS2、直接入库-返工生产 SCDD04_SYS3、工序汇报-普通生产
    ///     SCDD01_SYS4、工序汇报-返工生产 SCDD02_SYS
    /// </summary>
    [Column("CAA002")]
    [SugarColumn(ColumnName = "CAA002")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "ERP工单批次长度不能超出50")]
    public string? Caa002 { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç¼–号
    /// </summary>
    [Column("CAA003")]
    [SugarColumn(ColumnName = "CAA003")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "客户编号长度不能超出50")]
    public string? Caa003 { get; set; }

    /// <summary>
    ///     å•æ®ç±»åž‹
    /// </summary>
    [Column("CAA004")]
    [SugarColumn(ColumnName = "CAA004")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "单据类型长度不能超出50")]
    public string? Caa004 { get; set; }
    [SugarColumn(ColumnName = "CAA004")]
    public string Caa004 { get; set; }

    /// <summary>
    ///     å¼€å•æ—¥æœŸ
    /// </summary>
    [Column("CAA005")]
    [SugarColumn(ColumnName = "CAA005")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "开单日期长度不能超出50")]
    public string? Caa005 { get; set; }
    [SugarColumn(ColumnName = "CAA005")]
    public string Caa005 { get; set; }

    /// <summary>
    ///     äº§å“ç¼–码
    /// </summary>
    [Column("CAA006")]
    [SugarColumn(ColumnName = "CAA006")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "产品编码长度不能超出50")]
    public string? Caa006 { get; set; }

    /// <summary>
    ///     äº§å“åç§°
    /// </summary>
    [Column("CAA007")]
    [SugarColumn(ColumnName = "CAA007")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "产品名称长度不能超出100")]
    public string? Caa007 { get; set; }

    /// <summary>
    ///     äº§å“è§„æ ¼
    /// </summary>
    [Column("CAA008")]
    [SugarColumn(ColumnName = "CAA008")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "产品规格长度不能超出200")]
    public string? Caa008 { get; set; }
    [SugarColumn(ColumnName = "CAA006")]
    public string Caa006 { get; set; }

    /// <summary>
    ///     å•ä½
    /// </summary>
    [Column("CAA009")]
    [SugarColumn(ColumnName = "CAA009")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "单位长度不能超出50")]
    public string? Caa009 { get; set; }
    [SugarColumn(ColumnName = "CAA009")]
    public string Caa009 { get; set; }

    /// <summary>
    ///     é¢„计开工时间
    /// </summary>
    [Column("CAA010")]
    [SugarColumn(ColumnName = "CAA010")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "预计开工时间长度不能超出50")]
    public string? Caa010 { get; set; }
    [SugarColumn(ColumnName = "CAA010")]
    public string Caa010 { get; set; }

    /// <summary>
    ///     é¢„计完工时间
    /// </summary>
    [Column("CAA011")]
    [SugarColumn(ColumnName = "CAA011")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "预计完工时间长度不能超出50")]
    public string? Caa011 { get; set; }
    [SugarColumn(ColumnName = "CAA011")]
    public string Caa011 { get; set; }

    /// <summary>
    ///     æ•°é‡
    /// </summary>
    [Column("CAA012")]
    [SugarColumn(ColumnName = "CAA012")] //用于SqlSugar
    [SugarColumn(ColumnName = "CAA012")]
    public decimal? Caa012 { get; set; }

    /// <summary>
    ///     BOM版次
    /// </summary>
    [Column("CAA013")]
    [SugarColumn(ColumnName = "CAA013")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "BOM版次长度不能超出50")]
    public string? Caa013 { get; set; }

    /// <summary>
    ///     å®¢æˆ·è®¢å•å·
    /// </summary>
    [Column("CAA014")]
    [SugarColumn(ColumnName = "CAA014")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "客户订单号长度不能超出50")]
    public string? Caa014 { get; set; }
    [SugarColumn(ColumnName = "CAA013")]
    public string Caa013 { get; set; }

    /// <summary>
    ///     é”€å”®è®¢å•å·
    /// </summary>
    [Column("CAA015")]
    [SugarColumn(ColumnName = "CAA015")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "销售订单号长度不能超出50")]
    public string? Caa015 { get; set; }
    [SugarColumn(ColumnName = "CAA015")]
    public string Caa015 { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [Column("CAA016")]
    [SugarColumn(ColumnName = "CAA016")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "备注长度不能超出200")]
    public string? Caa016 { get; set; }
    [SugarColumn(ColumnName = "CAA016")]
    public string Caa016 { get; set; }

    /// <summary>
    ///     å·²æŽ’数量
    /// </summary>
    [Column("CAA017")]
    [SugarColumn(ColumnName = "CAA017")] //用于SqlSugar
    [SugarColumn(ColumnName = "CAA017")]
    public decimal? Caa017 { get; set; }

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

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

    /// <summary>
    ///     ERP源单单号(任务单号)
    /// </summary>
    [Column("CAA020")]
    [SugarColumn(ColumnName = "CAA020")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "ERP源单单号(任务单号)长度不能超出50")]
    public string? Caa020 { get; set; }
    [SugarColumn(ColumnName = "CAA020")]
    public string Caa020 { get; set; }

    /// <summary>
    ///     å·¥ä½œè½¦é—´
    /// </summary>
    [Column("CAA021")]
    [SugarColumn(ColumnName = "CAA021")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "工作车间长度不能超出50")]
    public string? Caa021 { get; set; }
    [SugarColumn(ColumnName = "CAA021")]
    public string Caa021 { get; set; }

    /// <summary>
    ///     æœªæŽ’数量
    ///     å®¡æ ¸ç 
    /// </summary>
    [Column("CAA022")]
    [SugarColumn(ColumnName = "CAA022")] //用于SqlSugar
    public decimal? Caa022 { get; set; }

    /// <summary>
    ///     çŠ¶æ€ å®Œå·¥ï¼Œæœªå®Œå·¥
    /// </summary>
    [Column("CAA023")]
    [SugarColumn(ColumnName = "CAA023")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "状态 å®Œå·¥ï¼Œæœªå®Œå·¥é•¿åº¦ä¸èƒ½è¶…出20")]
    public string? Caa023 { get; set; }

    /// <summary>
    ///     å·²å…¥åº“数量
    /// </summary>
    [Column("CAA024")]
    [SugarColumn(ColumnName = "CAA024")] //用于SqlSugar
    public decimal? Caa024 { get; set; }

    /// <summary>
    ///     ç»“案标识
    /// </summary>
    [Column("CAA025")]
    [SugarColumn(ColumnName = "CAA025")] //用于SqlSugar
    public decimal? Caa025 { get; set; }

    /// <summary>
    ///     å¤±è´¥åŽŸå› 
    /// </summary>
    [Column("CAA026")]
    [SugarColumn(ColumnName = "CAA026")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "失败原因长度不能超出50")]
    public string? Caa026 { get; set; }

    /// <summary>
    ///     ç»“案时间
    /// </summary>
    [Column("CAA027")]
    [SugarColumn(ColumnName = "CAA027")] //用于SqlSugar
    public DateTime? Caa027 { get; set; }

    /// <summary>
    ///     ä¾›åº”商编码
    /// </summary>
    [Column("CAA028")]
    [SugarColumn(ColumnName = "CAA028")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "供应商编码长度不能超出50")]
    public string? Caa028 { get; set; }
    [SugarColumn(ColumnName = "FSTATUS")]
    public decimal? Fstatus { get; set; }

    /// <summary>
    ///     å®¡æ ¸æ—¥æœŸ
    /// </summary>
    [Column("CHECK_DATE")]
    [SugarColumn(ColumnName = "CHECK_DATE")] //用于SqlSugar
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     å®¡æ ¸äºº
    /// </summary>
    [Column("CHECK_USER")]
    [SugarColumn(ColumnName = "CHECK_USER")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "审核人长度不能超出20")]
    public string? CheckUser { get; set; }
    [SugarColumn(ColumnName = "CHECK_USER")]
    public string CheckUser { get; set; }

    /// <summary>
    ///     ERPID
    ///     æœªæŽ’数量
    /// </summary>
    [Column("ERPID")]
    [SugarColumn(ColumnName = "ERPID")] //用于SqlSugar
    public decimal? Erpid { get; set; }
    [SugarColumn(ColumnName = "CAA022")]
    public decimal? Caa022 { get; set; }

    /// <summary>
    ///     å®¡æ ¸ç 
    ///     çŠ¶æ€ å®Œå·¥ï¼Œæœªå®Œå·¥
    /// </summary>
    [Column("FSTATUS")]
    [SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar
    public decimal? Fstatus { get; set; }
    [SugarColumn(ColumnName = "CAA023")]
    public string Caa023 { get; set; }

    /// <summary>
    ///     è‡ªå¢žåˆ—
    ///     å·²å…¥åº“数量
    /// </summary>
    [Column("ID")]
    [SugarColumn(ColumnName = "ID")] //用于SqlSugar
    public decimal? Id { get; set; }

    /// <summary>
    ///     æ›´æ–°æ—¥æœŸ
    /// </summary>
    [Column("LASTTIME")]
    [SugarColumn(ColumnName = "LASTTIME")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "更新日期长度不能超出50")]
    public string? Lasttime { get; set; }

    /// <summary>
    ///     æ¨¡å…·å·
    /// </summary>
    [Column("MOLD_NO")]
    [SugarColumn(ColumnName = "MOLD_NO")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "模具号长度不能超出200")]
    public string? MoldNo { get; set; }
    [SugarColumn(ColumnName = "CAA024")]
    public decimal? Caa024 { get; set; }

    /// <summary>
    ///     å·¥è‰ºè·¯çº¿
    /// </summary>
    [Column("TLA021")]
    [SugarColumn(ColumnName = "TLA021")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "工艺路线长度不能超出50")]
    public string? Tla021 { get; set; }
    [SugarColumn(ColumnName = "ROUTING_ID")]
    public string RoutingId { get; set; }

    /// <summary>
    ///     éœ€æ±‚单据号码
    ///     äº§çº¿
    /// </summary>
    [Column("TLA022")]
    [SugarColumn(ColumnName = "TLA022")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "需求单据号码长度不能超出50")]
    public string? Tla022 { get; set; }
    [SugarColumn(ColumnName = "WORK_SHOP_ID")]
    public string WorkShopId { get; set; }

    /// <summary>
    ///     è¡Œå·
    ///     ä»“库
    /// </summary>
    [Column("TLA023")]
    [SugarColumn(ColumnName = "TLA023")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "行号长度不能超出50")]
    public string? Tla023 { get; set; }
    [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string DepotCode { get; set; }

    /// <summary>
    ///     ç”Ÿäº§è®¢å•å·ç 
    ///     å•æ®æ—¥æœŸ
    /// </summary>
    [Column("TLA024")]
    [SugarColumn(ColumnName = "TLA024")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "生产订单号码长度不能超出50")]
    public string? Tla024 { get; set; }
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public string CreateDate { get; set; }

    /// <summary>
    ///     ç”Ÿäº§è®¢å•å·ç 
    ///     è®¡åˆ’组
    /// </summary>
    [Column("TLA025")]
    [SugarColumn(ColumnName = "TLA025")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "生产订单号码长度不能超出50")]
    public string? Tla025 { get; set; }
    [SugarColumn(ColumnName = "WORK_GROUP_ID")]
    public string WorkGroupId { get; set; }

    /// <summary>
    ///     è®¡åˆ’员
    /// </summary>
    [Column("TLA025A")]
    [SugarColumn(ColumnName = "TLA025A")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "Tla025a长度不能超出50")]
    public string? Tla025a { get; set; }
    [SugarColumn(ColumnName = "PLAN_ID")]
    public string PlanId { get; set; }

    /// <summary>
    ///     å…¥åº“货主类型
    ///     å…¥åº“上限
    /// </summary>
    [Column("TLA026")]
    [SugarColumn(ColumnName = "TLA026")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "入库货主类型长度不能超出50")]
    public string? Tla026 { get; set; }
    [SugarColumn(ColumnName = "STOCK_INLIMITH")]
    public string StockInlimith { get; set; }

    /// <summary>
    ///     å…¥åº“货主
    ///     å…¥åº“下限
    /// </summary>
    [Column("TLA027")]
    [SugarColumn(ColumnName = "TLA027")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "入库货主长度不能超出50")]
    public string? Tla027 { get; set; }

    /// <summary>
    ///     å…¥åº“组织
    /// </summary>
    [Column("TLA028")]
    [SugarColumn(ColumnName = "TLA028")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "入库组织长度不能超出50")]
    public string? Tla028 { get; set; }

    /// <summary>
    /// </summary>
    [Column("TLA029")]
    [SugarColumn(ColumnName = "TLA029")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "Tla029长度不能超出50")]
    public string? Tla029 { get; set; }

    /// <summary>
    /// </summary>
    [Column("TLA030")]
    [SugarColumn(ColumnName = "TLA030")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "Tla030长度不能超出50")]
    public string? Tla030 { get; set; }
    [SugarColumn(ColumnName = "STOCK_INLIMITL")]
    public string StockInlimitl { get; set; }

    /// <summary>
    ///     è®¡åˆ’跟踪号
    /// </summary>
    [Column("TLA031")]
    [SugarColumn(ColumnName = "TLA031")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "计划跟踪号长度不能超出50")]
    public string? Tla031 { get; set; }
    [SugarColumn(ColumnName = "MTONO")]
    public string Mtono { get; set; }

    /// <summary>
    ///     å·¥å•çŠ¶æ€
    ///     æ‰¹å·
    /// </summary>
    [Column("TLA032")]
    [SugarColumn(ColumnName = "TLA032")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "工单状态长度不能超出10")]
    public string? Tla032 { get; set; }
    [SugarColumn(ColumnName = "LOT")]
    public string Lot { get; set; }

    /// <summary>
    ///     æ•´ç¯åž‹å·
    ///     é”€å”®è®¢å•è¡Œå·
    /// </summary>
    [Column("TLA033")]
    [SugarColumn(ColumnName = "TLA033")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "整灯型号长度不能超出500")]
    public string? Tla033 { get; set; }
    [SugarColumn(ColumnName = "CAA015_HEAD")]
    public string Caa015Head { get; set; }

    /// <summary>
    ///     å·¥åºè®¡åˆ’号
    ///     ç”Ÿæˆæ–¹å¼
    /// </summary>
    [Column("TLA034")]
    [SugarColumn(ColumnName = "TLA034")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "工序计划号长度不能超出100")]
    public string? Tla034 { get; set; }
    [SugarColumn(ColumnName = "CREATE_TYPE")]
    public string CreateType { get; set; }

    /// <summary>
    ///     å®¢æˆ·
    ///     æºå•ç±»åž‹
    /// </summary>
    [Column("TLA035")]
    [SugarColumn(ColumnName = "TLA035")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "客户长度不能超出100")]
    public string? Tla035 { get; set; }
    [SugarColumn(ColumnName = "SRC_BILL_TYPE")]
    public string SrcBillType { get; set; }

    /// <summary>
    ///     å•æ®ç±»åž‹
    ///     æºå•ç¼–号
    /// </summary>
    [Column("TLA036")]
    [SugarColumn(ColumnName = "TLA036")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "单据类型长度不能超出100")]
    public string? Tla036 { get; set; }
    [SugarColumn(ColumnName = "SRC_BILL_NO")]
    public string SrcBillNo { get; set; }

    /// <summary>
    ///     æ›´æ–°æ¬¡æ•°
    ///     æºå•åˆ†å½•è¡Œå·
    /// </summary>
    [Column("UPCX")]
    [SugarColumn(ColumnName = "UPCX")] //用于SqlSugar
    public decimal? Upcx { get; set; }
    [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")]
    public string SrcBillentryseq { get; set; }

    /// <summary>
    ///     æ›´æ–°æ ‡è¯†
    ///     éœ€æ±‚单据号
    /// </summary>
    [Column("UPFLAG")]
    [SugarColumn(ColumnName = "UPFLAG")] //用于SqlSugar
    [StringLength(2, ErrorMessage = "更新标识长度不能超出2")]
    public string? Upflag { get; set; }
    [SugarColumn(ColumnName = "SALE_ORDER_NO")]
    public string SaleOrderNo { get; set; }

    /// <summary>
    ///     ç‰ˆæœ¬
    ///     éœ€æ±‚单据行号
    /// </summary>
    [Column("VNO")]
    [SugarColumn(ColumnName = "VNO")] //用于SqlSugar
    public decimal? Vno { get; set; }
    [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; }
}

 MES.Service/Modes/Womcab.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,155 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     å·¥å•å­è¡¨
/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
{
    /// <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 = "CAB001")]
    public string Cab001 { get; set; }

    /// <summary>
    ///     åºå·
    /// </summary>
    [SugarColumn(ColumnName = "CAB002")]
    public string Cab002 { get; set; }

    /// <summary>
    ///     ææ–™ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "CAB003")]
    public string Cab003 { get; set; }

    /// <summary>
    ///     éœ€é¢†ç”¨é‡
    /// </summary>
    [SugarColumn(ColumnName = "CAB006")]
    public decimal? Cab006 { get; set; }

    /// <summary>
    ///     å·²é¢†ç”¨é‡
    /// </summary>
    [SugarColumn(ColumnName = "CAB007")]
    public decimal? Cab007 { get; set; }

    /// <summary>
    ///     å·¥è‰º
    /// </summary>
    [SugarColumn(ColumnName = "CAB008")]
    public string Cab008 { get; set; }

    /// <summary>
    ///     å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "CAB009")]
    public string Cab009 { get; set; }

    /// <summary>
    ///     ç»„成用量
    /// </summary>
    [SugarColumn(ColumnName = "CAB012")]
    public decimal? Cab012 { get; set; }

    /// <summary>
    ///     æ˜¯å¦æ›¿æ–™
    /// </summary>
    [SugarColumn(ColumnName = "CAB014")]
    public string Cab014 { get; set; }

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

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "EID")]
    public decimal? Eid { get; set; }

    /// <summary>
    ///     ä½ç½®å·
    /// </summary>
    [SugarColumn(ColumnName = "POSITION_NO")]
    public string PositionNo { get; set; }

    /// <summary>
    ///     å‘料组织
    /// </summary>
    [SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
    public string IssuingOrganization { get; set; }

    /// <summary>
    ///     ä¾›åº”组织
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
    public string SupplyOrganization { get; set; }

    /// <summary>
    ///     è´§ä¸»
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_ID")]
    public string OwnerId { 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 = "DEPOT_CODE")]
    public string DepotCode { get; set; }

    /// <summary>
    ///     å‘料方式
    /// </summary>
    [SugarColumn(ColumnName = "ISSUE_TYPE")]
    public string IssueType { get; set; }

    /// <summary>
    ///     ä¾›åº”类型
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_TYPE")]
    public string SupplyType { get; set; }

    /// <summary>
    ///     åˆ†å­
    /// </summary>
    [SugarColumn(ColumnName = "NUMERATOR")]
    public string Numerator { get; set; }

    /// <summary>
    ///     åˆ†æ¯
    /// </summary>
    [SugarColumn(ColumnName = "DENOMINATOR")]
    public string Denominator { get; set; }
}

 MES.Service/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/service/BasicData/MesRohInManager.cs

@@ -1,66 +1,74 @@
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using MES.Service.util;
using SqlSugar;

namespace MES.Service.service.BasicData
namespace MES.Service.service.BasicData;

public class MesRohInManager : Repository<MesRohIn>
{
    public class MesRohInManager : Repository<MesRohIn>
    private readonly MesRohInDataManager rohInDataManager = new();

    // Save æ–¹æ³•ç”¨äºŽä¿å­˜å•ä¸ª RohIn è®°å½•ï¼Œæ ¹æ®ç±»åž‹æ‰§è¡Œä¸åŒçš„操作
    public bool Save(RohIn rohIn)
    {
        private readonly MesRohInDataManager rohInDataManager = new();
        var rohInErpRohIn = rohIn.ErpRohIn;
        var mesRohIn = GetMesRohIn(rohInErpRohIn);
        var mesRohInDatas =
            GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);

        // Save æ–¹æ³•ç”¨äºŽä¿å­˜å•ä¸ª RohIn è®°å½•ï¼Œæ ¹æ®ç±»åž‹æ‰§è¡Œä¸åŒçš„操作
        public bool Save(RohIn rohIn)
        return UseTransaction(db =>
        {
            var rohInErpRohIn = rohIn.ErpRohIn;
            var mesRohIn = GetMesRohIn(rohInErpRohIn);
            var mesRohInDatas =
                GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);

            return UseTransaction(db =>
            switch (rohInErpRohIn.Type)
            {
                switch (rohInErpRohIn.Type)
                {
                    // case "2":
                    //     return InsertData(db, mesRohIn, mesRohInDatas,
                    //         rohInErpRohIn.FBILLTYPE)
                    //         ? 1
                    //         : 0;
                    case "3":
                        return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0;
                    case "2":
                    case "4":
                        return SaveOrUpdateData(db, mesRohIn, mesRohInDatas)
                            ? 1
                            : 0;
                    default:
                        throw new NotImplementedException(
                            $"type没有{rohInErpRohIn.Type}这个类型");
                }
            }) > 0;
        }
                // case "2":
                //     return InsertData(db, mesRohIn, mesRohInDatas,
                //         rohInErpRohIn.FBILLTYPE)
                //         ? 1
                //         : 0;
                case "3":
                    return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0;
                case "2":
                case "4":
                    return SaveOrUpdateData(db, mesRohIn, mesRohInDatas)
                        ? 1
                        : 0;
                default:
                    throw new NotImplementedException(
                        $"type没有{rohInErpRohIn.Type}这个类型");
            }
        }) > 0;
    }

        // æ’入数据的方法
        private bool InsertData(SqlSugarScope db, MesRohIn mesRohIn,
            List<MesRohInData> mesRohInDatas, string FBILLTYPE)
    // æ’入数据的方法
    private bool InsertData(SqlSugarScope db, MesRohIn mesRohIn,
        List<MesRohInData> mesRohInDatas, string FBILLTYPE)
    {
        switch (FBILLTYPE)
        {
            switch (FBILLTYPE)
            case "A":
            {
                case "A":
                var decimals = mesRohInDatas.Select(s => s.Id).ToArray();

                if (mesRohIn.Id != null) base.DeleteById(mesRohIn.Id);

                if (decimals.Length > 0)
                    db.Deleteable<MesRohInData>().In(decimals).ExecuteCommand();

                var insert = base.Insert(mesRohIn);
                var insertRange =
                    rohInDataManager.InsertRange(mesRohInDatas);

                if (insert && insertRange) return true;
                throw new NotImplementedException("插入失败");
            }
            case "B":
            {
                var decimals = mesRohInDatas.Select(s => s.Id).ToArray();
                if (base.DeleteById(mesRohIn.Id) && db
                        .Deleteable<MesRohInData>().In(decimals)
                        .ExecuteCommand() > 0)
                {
                    var decimals = mesRohInDatas.Select(s => s.Id).ToArray();

                    if (mesRohIn.Id != null)
                    {
                        base.DeleteById(mesRohIn.Id);
                    }

                    if (decimals.Length > 0)
                    {
                        db.Deleteable<MesRohInData>().In(decimals).ExecuteCommand();
                    }
                    
                    var insert = base.Insert(mesRohIn);
                    var insertRange =
                        rohInDataManager.InsertRange(mesRohInDatas);
@@ -68,207 +76,187 @@
                    if (insert && insertRange) return true;
                    throw new NotImplementedException("插入失败");
                }
                case "B":
                {
                    var decimals = mesRohInDatas.Select(s => s.Id).ToArray();
                    if (base.DeleteById(mesRohIn.Id) && db
                            .Deleteable<MesRohInData>().In(decimals)
                            .ExecuteCommand() > 0)
                    {
                        var insert = base.Insert(mesRohIn);
                        var insertRange =
                            rohInDataManager.InsertRange(mesRohInDatas);

                        if (insert && insertRange) return true;
                        throw new NotImplementedException("插入失败");
                    }

                    break;
                }
                break;
            }

            throw new NotImplementedException("采购订单类型错误");
        }

        // æ›´æ–°æ•°æ®çš„方法
        private bool UpdateData(SqlSugarScope db, MesRohIn mesRohIn,
            List<MesRohInData> mesRohInDatas)
        {
            var decimals = mesRohInDatas.Select(s => s.Id).ToArray();
            var update = base.DeleteById(mesRohIn.Id);
            var insertOrUpdate = db
                .Deleteable<MesRohInData>().In(decimals)
                .ExecuteCommand() > 0;
        throw new NotImplementedException("采购订单类型错误");
    }

            if (update && insertOrUpdate) return true;
            throw new NotImplementedException("更新失败");
        }
    // æ›´æ–°æ•°æ®çš„方法
    private bool UpdateData(SqlSugarScope db, MesRohIn mesRohIn,
        List<MesRohInData> mesRohInDatas)
    {
        var decimals = mesRohInDatas.Select(s => s.Id).ToArray();
        var update = base.DeleteById(mesRohIn.Id);
        var insertOrUpdate = db
            .Deleteable<MesRohInData>().In(decimals)
            .ExecuteCommand() > 0;

        // æ’入或更新数据的方法
        private bool SaveOrUpdateData(SqlSugarScope db, MesRohIn mesRohIn,
            List<MesRohInData> mesRohInDatas)
        {
            
            if (mesRohIn.Id != null)
            {
                base.DeleteById(mesRohIn.Id);
            }
        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("更新失败");
    }

            if (mesRohInDatas.Count > 0)
            {
                db.Deleteable<MesRohInData>().Where(s=>s.ErpId == mesRohIn.EbelnK3id).ExecuteCommand();
            }
    // æ’入或更新数据的方法
    private bool SaveOrUpdateData(SqlSugarScope db, MesRohIn mesRohIn,
        List<MesRohInData> mesRohInDatas)
    {
        if (mesRohIn.Id != null) base.DeleteById(mesRohIn.Id);

            var orUpdate = base.Insert(mesRohIn);
            var baOrUpdate = rohInDataManager.InsertRange(mesRohInDatas);
            if (orUpdate && baOrUpdate) return true;
            throw new NotImplementedException("插入或更新失败");
        }
        if (mesRohInDatas.Count > 0)
            db.Deleteable<MesRohInData>()
                .Where(s => s.ErpId == mesRohIn.EbelnK3id).ExecuteCommand();

        // æ‰¹é‡ä¿å­˜è®°å½•çš„方法
        public bool SaveList(List<RohIn> rohIns)
        {
            var result = rohIns.Select(Save).ToList();
            return result.All(b => b);
        }
        var orUpdate = base.Insert(mesRohIn);
        var baOrUpdate = rohInDataManager.InsertRange(mesRohInDatas);
        if (orUpdate && baOrUpdate) return true;
        throw new NotImplementedException("插入或更新失败");
    }

        // å°† ErpRohIn å¯¹è±¡è½¬æ¢ä¸º MesRohIn å¯¹è±¡çš„方法
        public MesRohIn GetMesRohIn(ErpRohIn rohIn)
        {
            var eid = Convert.ToDecimal(rohIn.id);
            var mesRohIn = new MesRohIn();
    // æ‰¹é‡ä¿å­˜è®°å½•çš„方法
    public bool SaveList(List<RohIn> rohIns)
    {
        var result = rohIns.Select(Save).ToList();
        return result.All(b => b);
    }

            var single = base.GetSingle(it => it.EbelnK3id == eid);
            if (single != null) mesRohIn.Id = single.Id;
    // å°† ErpRohIn å¯¹è±¡è½¬æ¢ä¸º MesRohIn å¯¹è±¡çš„方法
    public MesRohIn GetMesRohIn(ErpRohIn rohIn)
    {
        var eid = Convert.ToDecimal(rohIn.id);
        var mesRohIn = new MesRohIn();

            mesRohIn.EbelnK3id = eid;
            mesRohIn.BillNo = rohIn.FBillNo;
            mesRohIn.DocumentStatus = rohIn.FDocumentStatus;
            mesRohIn.DocumentType = rohIn.FBillTypeID;
            mesRohIn.BusinessType = rohIn.FBusinessType;
        var single = base.GetSingle(it => it.EbelnK3id == eid);
        if (single != null) mesRohIn.Id = single.Id;

            if (rohIn.FDate != null)
                mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate,
        mesRohIn.EbelnK3id = eid;
        mesRohIn.BillNo = rohIn.FBillNo;
        mesRohIn.DocumentStatus = rohIn.FDocumentStatus;
        mesRohIn.DocumentType = rohIn.FBillTypeID;
        mesRohIn.BusinessType = rohIn.FBusinessType;

        if (rohIn.FDate != null)
            mesRohIn.PurchaseDate = DateTime.ParseExact(rohIn.FDate,
                "yyyy-MM-dd HH:mm:ss", null);

        mesRohIn.Supplier = rohIn.FSupplierId;
        mesRohIn.CloseStatus = rohIn.FCloseStatus;
        mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId;
        mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId;
        mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId;
        mesRohIn.QtyAcceptance = rohIn.Facctype;
        mesRohIn.Purchaser = rohIn.FPurchaserId;
        mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq;
        mesRohIn.SettlementParty = rohIn.FSettleId;
        mesRohIn.PaymentParty = rohIn.FChargeId;
        mesRohIn.Email = rohIn.FProviderEMail;
        mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs;
        mesRohIn.Remarks = rohIn.F_UNW_BZ;
        mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj;
        mesRohIn.CancellationStatus = rohIn.FCancelStatus;
        mesRohIn.CancellationPerson = rohIn.FCancellerId;

        if (rohIn.FCancelDate != null)
            mesRohIn.CancellationDate =
                DateTime.ParseExact(rohIn.FCancelDate,
                    "yyyy-MM-dd HH:mm:ss", null);

            mesRohIn.Supplier = rohIn.FSupplierId;
            mesRohIn.CloseStatus = rohIn.FCloseStatus;
            mesRohIn.PurchaseOrg = rohIn.FPurchaseOrgId;
            mesRohIn.PurchaseDept = rohIn.FPurchaseDeptId;
            mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId;
            mesRohIn.QtyAcceptance = rohIn.Facctype;
            mesRohIn.Purchaser = rohIn.FPurchaserId;
            mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq;
            mesRohIn.SettlementParty = rohIn.FSettleId;
            mesRohIn.PaymentParty = rohIn.FChargeId;
            mesRohIn.Email = rohIn.FProviderEMail;
            mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs;
            mesRohIn.Remarks = rohIn.F_UNW_BZ;
            mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj;
            mesRohIn.CancellationStatus = rohIn.FCancelStatus;
            mesRohIn.CancellationPerson = rohIn.FCancellerId;
        mesRohIn.CreateBy = rohIn.FCreatorId;

            if (rohIn.FCancelDate != null)
                mesRohIn.CancellationDate =
                    DateTime.ParseExact(rohIn.FCancelDate,
                        "yyyy-MM-dd HH:mm:ss", null);
        if (rohIn.FCreateDate != null)
            mesRohIn.CreateDate = DateTime.ParseExact(rohIn.FCreateDate,
                "yyyy-MM-dd HH:mm:ss", null);

            mesRohIn.CreateBy = rohIn.FCreatorId;
        mesRohIn.LastupdateBy = rohIn.FModifierId;

            if (rohIn.FCreateDate != null)
                mesRohIn.CreateDate = DateTime.ParseExact(rohIn.FCreateDate,
                    "yyyy-MM-dd HH:mm:ss", null);
        if (rohIn.FModifyDate != null)
            mesRohIn.LastupdateDate = DateTime.ParseExact(rohIn.FModifyDate,
                "yyyy-MM-dd HH:mm:ss", null);

            mesRohIn.LastupdateBy = rohIn.FModifierId;
        mesRohIn.ErpCheckBy = rohIn.FApproverId;
        mesRohIn.ErpCheckDate = rohIn.FApproveDate;
        mesRohIn.Changereason = rohIn.FCHANGEREASON;

            if (rohIn.FModifyDate != null)
                mesRohIn.LastupdateDate = DateTime.ParseExact(rohIn.FModifyDate,
                    "yyyy-MM-dd HH:mm:ss", null);
        return mesRohIn;
    }

            mesRohIn.ErpCheckBy = rohIn.FApproverId;
            mesRohIn.ErpCheckDate = rohIn.FApproveDate;
            mesRohIn.Changereason = rohIn.FCHANGEREASON;

            return mesRohIn;
        }

        // å°† ErpRohinData å¯¹è±¡è½¬æ¢ä¸º MesRohInData å¯¹è±¡çš„方法
        public List<MesRohInData> GetMesRohInDatas(
            List<ErpRohinData> erpRohinDatas, string type)
    // å°† ErpRohinData å¯¹è±¡è½¬æ¢ä¸º MesRohInData å¯¹è±¡çš„方法
    public List<MesRohInData> GetMesRohInDatas(
        List<ErpRohinData> erpRohinDatas, string type)
    {
        return erpRohinDatas.Select(s =>
        {
            return erpRohinDatas.Select(s =>
            var entity = new MesRohInData
            {
                var entity = new MesRohInData
                {
                    EbelnK3id = Convert.ToDecimal(s.id),
                    ErpId = Convert.ToDecimal(s.Eid),
                    BillNo = s.FBillNo,
                    SalesOrderId = s.F_UNW_Text_xsddh,
                    ItemId = s.FMaterialId,
                    PurchaseUnit = s.FUnitId,
                    PurchaseQty = Convert.ToDecimal(s.FQty),
                    InventoryUnit = s.FStockUnitID,
                    PricingUnit = s.FPriceUnitId,
                    PricingQty = Convert.ToDecimal(s.FPriceUnitQty),
                    DeliveryDate = s.FDeliveryDate != null
                        ? DateTime.ParseExact(s.FDeliveryDate,
                            "yyyy-MM-dd HH:mm:ss", null)
                        : null,
                    EarliestDeliveryDate = s.FDeliveryEarlyDate != null
                        ? DateTime.ParseExact(s.FDeliveryEarlyDate,
                            "yyyy-MM-dd HH:mm:ss", null)
                        : null,
                    LatestDeliveryDate = s.FDeliveryLastDate != null
                        ? DateTime.ParseExact(s.FDeliveryLastDate,
                            "yyyy-MM-dd HH:mm:ss", null)
                        : null,
                    IsGift = s.FGiveAway,
                    Remarks = s.FEntryNote,
                    SupplierItemCode = s.FSupMatId,
                    SupplierItemName = s.FSupMatName,
                    OutsourcingOrderId = s.FSUBREQBILLNO,
                    BatchNumber = s.FLot,
                    BusinessClose = s.FMRPCloseStatus,
                    BusinessFreeze = s.FMRPFreezeStatus,
                    Freezer = s.FFreezerId,
                    FreezeTime = s.FFreezeDate != null
                        ? DateTime.ParseExact(s.FFreezeDate,
                            "yyyy-MM-dd HH:mm:ss", null)
                        : null,
                    BusinessTerminate = s.FMRPTerminateStatus,
                    Terminator = s.FTerminaterId,
                    TerminateTime = s.FTerminateDate != null
                        ? DateTime.ParseExact(s.FTerminateDate,
                            "yyyy-MM-dd HH:mm:ss", null)
                        : null,
                    TotalReceivedQty = Convert.ToDecimal(s.FReceiveQty),
                    RemainingReceivedQty =
                        Convert.ToDecimal(s.FRemainReceiveQty),
                    TotalStoredQty = Convert.ToDecimal(s.FStockInQty),
                    RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty),
                    TotalReturnedQty = Convert.ToDecimal(s.FMrbQty),
                    ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY),
                    ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY),
                    SourceDocumentType = s.FSrcBillTypeId,
                    SourceDocumentId = s.FSrcBillNo,
                    DemandTrackingId = s.FReqTraceNo,
                    PlanTrackingId = s.FMtoNo,
                    ChangeFlag = s.FChangeFlag,
                    DemandSource = s.FDEMANDTYPE,
                    DemandDocumentId = s.FDEMANDBILLNO,
                    DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ,
                    PurchaseOrderLineNumber = s.PurchaseOrderLineNumber,
                    Demand = s.Demand,
                    Receiving = s.Receiving,
                    Settlement = s.Settlement
                };
                EbelnK3id = Convert.ToDecimal(s.id),
                ErpId = Convert.ToDecimal(s.Eid),
                BillNo = s.FBillNo,
                SalesOrderId = s.F_UNW_Text_xsddh,
                ItemId = s.FMaterialId,
                PurchaseUnit = s.FUnitId,
                PurchaseQty = Convert.ToDecimal(s.FQty),
                InventoryUnit = s.FStockUnitID,
                PricingUnit = s.FPriceUnitId,
                PricingQty = Convert.ToDecimal(s.FPriceUnitQty),
                DeliveryDate = s.FDeliveryDate != null
                    ? DateTime.ParseExact(s.FDeliveryDate,
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                EarliestDeliveryDate = s.FDeliveryEarlyDate != null
                    ? DateTime.ParseExact(s.FDeliveryEarlyDate,
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                LatestDeliveryDate = s.FDeliveryLastDate != null
                    ? DateTime.ParseExact(s.FDeliveryLastDate,
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                IsGift = s.FGiveAway,
                Remarks = s.FEntryNote,
                SupplierItemCode = s.FSupMatId,
                SupplierItemName = s.FSupMatName,
                OutsourcingOrderId = s.FSUBREQBILLNO,
                BatchNumber = s.FLot,
                BusinessClose = s.FMRPCloseStatus,
                BusinessFreeze = s.FMRPFreezeStatus,
                Freezer = s.FFreezerId,
                FreezeTime = s.FFreezeDate != null
                    ? DateTime.ParseExact(s.FFreezeDate,
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                BusinessTerminate = s.FMRPTerminateStatus,
                Terminator = s.FTerminaterId,
                TerminateTime = s.FTerminateDate != null
                    ? DateTime.ParseExact(s.FTerminateDate,
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                TotalReceivedQty = Convert.ToDecimal(s.FReceiveQty),
                RemainingReceivedQty =
                    Convert.ToDecimal(s.FRemainReceiveQty),
                TotalStoredQty = Convert.ToDecimal(s.FStockInQty),
                RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty),
                TotalReturnedQty = Convert.ToDecimal(s.FMrbQty),
                ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY),
                ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY),
                SourceDocumentType = s.FSrcBillTypeId,
                SourceDocumentId = s.FSrcBillNo,
                DemandTrackingId = s.FReqTraceNo,
                PlanTrackingId = s.FMtoNo,
                ChangeFlag = s.FChangeFlag,
                DemandSource = s.FDEMANDTYPE,
                DemandDocumentId = s.FDEMANDBILLNO,
                DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ,
                PurchaseOrderLineNumber = s.PurchaseOrderLineNumber,
                Demand = s.Demand,
                Receiving = s.Receiving,
                Settlement = s.Settlement
            };

                var single = rohInDataManager.GetSingle(it =>
                    it.EbelnK3id == entity.EbelnK3id);
                if (single != null) entity.Id = single.Id;
            var single = rohInDataManager.GetSingle(it =>
                it.EbelnK3id == entity.EbelnK3id);
            if (single != null) entity.Id = single.Id;

                return entity;
            }).ToList();
        }
            return entity;
        }).ToList();
    }
}

 MES.Service/service/BasicData/MesStaffManager.cs

@@ -65,9 +65,9 @@
        if (exists)
        {
            var updateUser = db.Updateable<SysUser>()
                .SetColumns(s=>s.Fcode == sysUser.Fcode)
                .SetColumns(s=>s.Fname == sysUser.Fname)
                .Where(s=>s.Sid == sysUser.Sid)
                .SetColumns(s => s.Fcode == sysUser.Fcode)
                .SetColumns(s => s.Fname == sysUser.Fname)
                .Where(s => s.Sid == sysUser.Sid)
                .ExecuteCommand();
            if (updateUser > 0)
            {

 MES.Service/service/BasicData/ShipmentNoticeManager.cs

@@ -1,7 +1,6 @@
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.BasicData;

@@ -15,30 +14,26 @@
        var shipmentNotice = GetShipmentNotice(shipment.ShipmentNotice);

        var shipmentDetails = GetShipmentDetails(shipment.ShipmentDetails);
        

        return false;
    }

    private ShipmentNotice GetShipmentNotice(ErpShipmentNotice notice)
    {
        ShipmentNotice entity = new ShipmentNotice();
        var entity = new ShipmentNotice();

        entity.Creator = notice.FCreatorId;
        entity.DocId = notice.FBillNo;
        entity.Approver = notice.FApproverID;

        if (notice.FCreateDate != null)
        {
            entity.CreateDate = DateTime.ParseExact(notice.FCreateDate,
                "yyyy-MM-dd HH:mm:ss", null);
        }

        if (notice.FApproveDate != null)
        {
            entity.ApproveDate = DateTime.ParseExact(notice.FApproveDate,
                "yyyy-MM-dd HH:mm:ss", null);
        }
        

        entity.DeptCode = notice.FSaleDeptId;
        entity.CustCode = notice.FCustomerID;
        entity.ListNote = notice.FNote;
@@ -51,25 +46,25 @@
        List<ErpShipmentDetail> shipmentDetails)
    {
        return shipmentDetails.Select(s =>
        {
            var entity = new ShipmentDetail
            {
                var entity = new ShipmentDetail
                {
                    ErpId = s.ErpId,
                    ErpHeadId = s.ErpHeadId,
                    ProdCode = s.FMaterialID,
                    ProdName = s.FMaterialName,
                    Amount = Convert.ToDouble(s.FAmount),
                    UnitPrice = Convert.ToDouble(s.FPrice),
                    Quantity = Convert.ToDouble(s.FQty),
                    BatchNo = s.FLot,
                    Remarks = s.FNoteEntry,
                    OrderNo = s.F_UNW_Text_xsddh,
                    OrderId = s.FSOEntryId,
                    BasePrice = Convert.ToDouble(s.FPrice),
                    WarehouseCode = s.FStockID,
                    Unit = s.FBaseUnitID
                };
                return entity;
            }).ToList();
                ErpId = s.ErpId,
                ErpHeadId = s.ErpHeadId,
                ProdCode = s.FMaterialID,
                ProdName = s.FMaterialName,
                Amount = Convert.ToDouble(s.FAmount),
                UnitPrice = Convert.ToDouble(s.FPrice),
                Quantity = Convert.ToDouble(s.FQty),
                BatchNo = s.FLot,
                Remarks = s.FNoteEntry,
                OrderNo = s.F_UNW_Text_xsddh,
                OrderId = s.FSOEntryId,
                BasePrice = Convert.ToDouble(s.FPrice),
                WarehouseCode = s.FStockID,
                Unit = s.FBaseUnitID
            };
            return entity;
        }).ToList();
    }
}

 MES.Service/service/WomcaaManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,156 @@
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service;

public class WomcaaManager : Repository<Womcaa>
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 WomcaaManager.cs

    private readonly WomcabManager _womcabManager = new();

    public bool SaveList(List<ErpWOM> rohIns)
    {
        var result = rohIns.Select(Save).ToList();
        return result.All(b => b);
    }

    public bool Save(ErpWOM wom)
    {
        var womErpCaa = wom.ErpCaa;
        var mesWomcaa = MapErpCAAtoWomcaa(womErpCaa);
        var mesWomcabs =
            MapErpCABtoWomcab(wom.ErpCabs);

        return UseTransaction(db =>
        {
            switch (womErpCaa.Type)
            {
                case "3":
                    return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                case "2":
                case "4":
                    return SaveOrUpdateData(db, mesWomcaa, mesWomcabs)
                        ? 1
                        : 0;
                default:
                    throw new NotImplementedException(
                        $"type没有{womErpCaa.Type}这个类型");
            }
        }) > 0;
    }

    private bool SaveOrUpdateData(SqlSugarScope db, Womcaa mesWomcaa,
        List<Womcab> mesWomcabs)
    {
        if (mesWomcaa.Id != null) base.DeleteById(mesWomcaa.Id);

        if (mesWomcabs.Count > 0)
            db.Deleteable<Womcab>()
                .Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand();

        var orUpdate = base.Insert(mesWomcaa);
        var baOrUpdate = _womcabManager.InsertRange(mesWomcabs);
        if (orUpdate && baOrUpdate) return true;
        throw new NotImplementedException("插入或更新失败");
    }

    private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,
        List<Womcab> mesWomcabs)
    {
        var decimals = mesWomcabs.Select(s => s.Id).ToArray();
        var update = base.DeleteById(mesWomcaa.Id);
        var insertOrUpdate = db
            .Deleteable<Womcab>().In(decimals)
            .ExecuteCommand() > 0;

        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("更新失败");
    }

    private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
    {
        return new Womcaa
        {
            Erpid = Convert.ToDecimal(dto.Id),
            Caa001 = dto.FBillNo,
            WorkShopId = dto.FWorkShopID0,
            RoutingId = dto.FRoutingId,
            DepotCode = dto.FStockId,
            CreateDate = dto.FDate,
            Caa004 = dto.FBillType,
            Caa023 = dto.FStatus,
            Caa006 = dto.FMaterialId,
            Caa009 = dto.FUnitId,
            Caa012 = !string.IsNullOrEmpty(dto.FQty)
                ? Convert.ToDecimal(dto.FQty)
                : null,
            WorkGroupId = dto.FWorkGroupId,
            PlanId = dto.FPlannerID,
            Caa010 = dto.FPlanStartDate,
            Caa011 = dto.FPlanFinishDate,
            Caa005 = dto.FConveyDate,
            StockInlimith = dto.FStockInLimitH,
            StockInlimitl = dto.FStockInLimitL,
            Mtono = dto.FMTONO,
            Lot = dto.FLot,
            Caa013 = dto.FBomId,
            Caa015 = dto.F_UNW_Text_xsddh,
            CreateType = dto.FCreateType,
            SrcBillType = dto.FSrcBillType,
            SrcBillNo = dto.FSrcBillNo,
            SrcBillentryseq = dto.FSrcBillEntrySeq,
            SaleOrderNo = dto.FSaleOrderNo,
            SaleOrderEntryseq = dto.FSaleOrderEntrySeq,
            ForceCloserid = dto.FForceCloserId,
            CloseType = dto.FCloseType,
            SrcSplitBillno = dto.FSrcSplitBillNo,
            Caa016 = dto.FMemoItem
        };
    }

    private List<Womcab> MapErpCABtoWomcab(List<ErpCAB> dtoList)
    {
        var womcabList = new List<Womcab>();

        foreach (var dto in dtoList)
        {
            var womcab = new Womcab
            {
                Erpid = Convert.ToDecimal(dto.ID),
                Cab001 = dto.FBillNo,
                Cab003 = dto.FMaterialID2,
                Cab006 = !string.IsNullOrEmpty(dto.FNeedQty2)
                    ? Convert.ToDecimal(dto.FNeedQty2)
                    : null,
                Cab007 = !string.IsNullOrEmpty(dto.FPickedQty)
                    ? Convert.ToDecimal(dto.FPickedQty)
                    : null,
                PositionNo = dto.FPositionNO,
                OwnerId = dto.FOwnerID,
                Mtono = dto.FMTONO,
                Lot = dto.FLot,
                DepotCode = dto.FStockID,
                IssueType = dto.FIssueType,
                Cab008 = dto.F_UNW_Text_tpgy,
                Cab009 = dto.FUnitID,
                SupplyType = dto.FSupplyType,
                Cab012 = !string.IsNullOrEmpty(dto.FStdQty)
                    ? Convert.ToDecimal(dto.FStdQty)
                    : null,
                Cab014 = dto.FIsKeyItem,
                Numerator = dto.FNumerator,
                Denominator = dto.FDenominator,
                Eid = Convert.ToDecimal(dto.PID)
            };

            womcabList.Add(womcab);
        }

        return womcabList;
    }
}

 MES.Service/service/WomcabManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,78 @@
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service;

public class WomcabManager : Repository<Womcab>
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 WomcabManager.cs


    #region æ•™å­¦æ–¹æ³•

    /// <summary>
    ///     ä»“储方法满足不了复杂业务需求，业务代码请在这里面定义方法
    /// </summary>
    public void Study()
    {
        /*********查询*********/

        var data1 = base.GetById(1); //根据ID查询
        var data2 = base.GetList(); //查询所有
        var data3 = base.GetList(it => 1 == 1); //根据条件查询  
        //var data4 = base.GetSingle(it => 1 == 1);//根据条件查询一条,如果超过一条会报错

        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // åˆ†é¡µæŸ¥è¯¢
        var data5 = base.GetPageList(it => 1 == 1, p);
        Console.Write(p.TotalCount); //返回总数

        var data6 =
            base.GetPageList(it => 1 == 1, p,
                it => SqlFunc.GetRandom()); // åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        Console.Write(p.TotalCount); //返回总数

        var conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel
        {
            FieldName = typeof(Womcab).GetProperties()[0].Name,
            ConditionalType = ConditionalType.Equal, FieldValue = "1"
        }); //id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());

        AsQueryable().Where(x => 1 == 1)
            .ToList(); //支持了转换成queryable,我们可以用queryable实现复杂功能


        /*********插入*********/
        var insertData = new Womcab(); //测试参数
        var insertArray = new[] { insertData };
        base.Insert(insertData); //插入
        base.InsertRange(insertArray); //批量插入
        var id = base.InsertReturnIdentity(insertData); //插入返回自增列
        AsInsertable(insertData).ExecuteCommand(); //我们可以转成 Insertable实现复杂插入


        /*********更新*********/
        var updateData = new Womcab(); //测试参数
        var updateArray = new[] { updateData }; //测试参数
        base.Update(updateData); //根据实体更新
        base.UpdateRange(updateArray); //批量更新
        //base.Update(it => new Womcab() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ›´æ–°ClassName列和CreateTime列，其它列不更新，条件id=1
        AsUpdateable(updateData).ExecuteCommand(); //转成Updateable可以实现复杂的插入


        /*********删除*********/
        var deldata = new Womcab(); //测试参数
        base.Delete(deldata); //根据实体删除
        base.DeleteById(1); //根据主键删除
        base.DeleteById(new[] { 1, 2 }); //根据主键数组删除
        base.Delete(it => 1 == 2); //根据条件删除
        AsDeleteable().Where(it => 1 == 2)
            .ExecuteCommand(); //转成Deleteable实现复杂的操作
    }

    #endregion
}

 MESApplication/Controllers/BasicData/SalesOrderDetailController.cs

@@ -10,7 +10,7 @@
[Route("api/[controller]")]
public class SalesOrderDetailController : ControllerBase
{
    private SalesOrderDetailManager m = new SalesOrderDetailManager();
    private readonly SalesOrderDetailManager m = new();


    /***进入模版管理可以修改模版***/

 MESApplication/Controllers/BasicData/SalesReturnNoticeController.cs

@@ -10,7 +10,7 @@
[Route("api/[controller]")]
public class SalesReturnNoticeController : ControllerBase
{
    private SalesReturnNoticeManager m = new SalesReturnNoticeManager();
    private readonly SalesReturnNoticeManager m = new();


    /***进入模版管理可以修改模版***/

 MESApplication/Controllers/BasicData/SalesReturnNoticeDetailController.cs

@@ -10,8 +10,7 @@
[Route("api/[controller]")]
public class SalesReturnNoticeDetailController : ControllerBase
{
    private SalesReturnNoticeDetailManager m =
        new SalesReturnNoticeDetailManager();
    private readonly SalesReturnNoticeDetailManager m = new();


    /***进入模版管理可以修改模版***/

 MESApplication/Controllers/BasicData/ShipmentDetailController.cs

@@ -10,7 +10,7 @@
[Route("api/[controller]")]
public class ShipmentDetailController : ControllerBase
{
    private ShipmentDetailManager m = new ShipmentDetailManager();
    private readonly ShipmentDetailManager m = new();


    /***进入模版管理可以修改模版***/

 MESApplication/Controllers/BasicData/ShipmentNoticeController.cs

@@ -10,7 +10,7 @@
[Route("api/[controller]")]
public class ShipmentNoticeController : ControllerBase
{
    private ShipmentNoticeManager m = new ShipmentNoticeManager();
    private readonly ShipmentNoticeManager m = new();


    /***进入模版管理可以修改模版***/

 MESApplication/Controllers/WomcaaController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,257 @@
using System.Dynamic;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using MES.Service.service;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;

namespace MESApplication.Controllers;

[ApiController]
[Route("api/[controller]")]
public class WomcaaController : ControllerBase
{
    private readonly WomcaaManager m = new();

    private readonly MessageCenterManager _manager = new();

    private readonly string METHOD = "POST";

    private readonly string TableName = "WOMCAA";

    private readonly string URL = "http://localhost:10054/api/Womcaa/";

    //
    [HttpPost("Save")]
    public ResponseResult Save(ErpWOM rohIn)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "Save";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(rohIn);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.Save(rohIn);

            resultInfos.tbBillList = save;

            entity.Result = 0;
            if (save) entity.Result = 1;

            entity.DealWith = 1;
            _manager.save(entity);

            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            entity.Result = 0;

            entity.DealWith = 0;

            entity.ResultData = ex.Message;

            _manager.save(entity);

            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("SaveList")]
    public ResponseResult SaveList(List<ErpWOM> units)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "SaveList";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(units);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.SaveList(units);
            resultInfos.tbBillList = save;

            entity.Result = 0;
            if (save) entity.Result = 1;

            entity.DealWith = 1;
            _manager.save(entity);

            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            entity.Result = 0;

            entity.DealWith = 0;

            entity.ResultData = ex.Message;

            _manager.save(entity);

            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     èŽ·å–所有
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetList")]
    public ResponseResult GetList()
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetList();
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    /// <summary>
    ///     æ ¹æ®ä¸»é”®èŽ·å–
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetById")]
    public ResponseResult GetById(int id)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetById(id);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ ¹æ®ä¸»é”®åˆ é™¤
    /// </summary>
    /// <returns></returns>
    [HttpPost("DeleteByIds")]
    public ResponseResult DeleteByIds([FromBody] object[] ids)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.DeleteByIds(ids);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ 
    /// </summary>
    /// <returns></returns>
    [HttpPost("Insert")]
    public ResponseResult Add([FromBody] Womcaa data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.Insert(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ è¿”回自增
    /// </summary>
    /// <returns></returns>
    [HttpPost("InsertReturnIdentity")]
    public ResponseResult InsertReturnIdentity([FromBody] Womcaa data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.InsertReturnIdentity(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     ä¿®æ”¹
    /// </summary>
    /// <returns></returns>
    [HttpPost("Update")]
    public ResponseResult Update([FromBody] Womcaa data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.Update(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
}

 MESApplication/Controllers/WomcabController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,162 @@
using System.Dynamic;
using MES.Service.Modes;
using MES.Service.service;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;

namespace MESApplication.Controllers;

[ApiController]
[Route("api/[controller]")]
public class WomcabController : ControllerBase
{
    private readonly WomcabManager m = new();


    /***进入模版管理可以修改模版***/

    /// <summary>
    ///     èŽ·å–所有
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetList")]
    public ResponseResult GetList()
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetList();
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    /// <summary>
    ///     æ ¹æ®ä¸»é”®èŽ·å–
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetById")]
    public ResponseResult GetById(int id)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetById(id);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ ¹æ®ä¸»é”®åˆ é™¤
    /// </summary>
    /// <returns></returns>
    [HttpPost("DeleteByIds")]
    public ResponseResult DeleteByIds([FromBody] object[] ids)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.DeleteByIds(ids);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ 
    /// </summary>
    /// <returns></returns>
    [HttpPost("Insert")]
    public ResponseResult Add([FromBody] Womcab data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.Insert(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ è¿”回自增
    /// </summary>
    /// <returns></returns>
    [HttpPost("InsertReturnIdentity")]
    public ResponseResult InsertReturnIdentity([FromBody] Womcab data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.InsertReturnIdentity(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     ä¿®æ”¹
    /// </summary>
    /// <returns></returns>
    [HttpPost("Update")]
    public ResponseResult Update([FromBody] Womcab data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.Update(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
}

 MESApplication/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.pdb

Binary files differ