泰莱姆接口代码

sjz

2025-01-15 afea8227dd6be19e60890d4dd67c560ac6bc5a41

泰莱姆接口代码

 MES.Service/Dto/webApi/Delivery.cs

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

public class Delivery
{
    public ErpDelivery ErpDelivery { get; set; }
    public List<ErpDeliveryData> ErpDeliveryData { get; set; }
}

 MES.Service/Dto/webApi/ErpBarcode.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,11 @@
namespace MES.Service.Dto.webApi;
public class ErpBarcode
{
    public string? Type { get; set; }
    public string? DeliveryNo { get; set; }
    public string? LineNo { get; set; }
    public string? ProductCode { get; set; }
    public string? SmallBarcode { get; set; }
    public string? IncludeQty { get; set; }
    public string? SupplierId { get; set; }
}

 MES.Service/Dto/webApi/ErpCAA.cs

@@ -2,12 +2,10 @@

public class ErpCAA
{
    public string Id { get; set; }
    public string? Id { get; set; }
    public string? Type { get; set; }

    public string? FBILLTYPE { get; set; }
    public string? FBillNo { get; set; }
    public string? FWorkShopID0 { get; set; }
    public string? FWorkShopID { get; set; }
    public string? FRoutingId { get; set; }
    public string? FREMWorkShopId { get; set; }
    public string? FStockId { get; set; }
@@ -27,7 +25,7 @@
    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? FXSHTH { get; set; }
    public string? FCreateType { get; set; }
    public string? FSrcBillType { get; set; }
    public string? FSrcBillNo { get; set; }
@@ -37,9 +35,23 @@
    public string? FForceCloserId { get; set; }
    public string? FCloseType { get; set; }
    public string? FSrcSplitBillNo { get; set; }
    public string? FMemoItem { get; set; }
    public string? PLAN_ID { get; set; }
    public string? PLAN_SEQ { get; set; }
    public string? PLAN_NUM { get; set; }
    public string? erP_SCZZ { get; set; }
    public string? erP_WTZZ { get; set; }
    public string? F_ZJXF_YHRQ { get; set; }
    public string? F_ZSXG_KH { get; set; }
    public string? FDescription { get; set; }
    public string? fsubentryid { get; set; }
    public string? FPurOrderNo { get; set; }
    public string? FPurOrderEntrySeq { get; set; }
    public string? Caa024 { get; set; }
    public string? Caa025 { get; set; }
    public string? ErpRkhz { get; set; }
    public string? ErpRkzz { get; set; }
    //委外字段
    public string? F_ZJXF_DATETIME_YHRQ { get; set; }
    public string? F_ZJXF_BASE_KH { get; set; }

    public string? planId { get; set; }
    public string? planSeq { get; set; }
    public string? planNum { get; set; }
}

 MES.Service/Dto/webApi/ErpCAB.cs

@@ -3,28 +3,32 @@
public class ErpCAB
{
    public string? FBillNo { get; set; }
    public string? FMaterialID2 { get; set; }
    public string? FNeedQty2 { get; set; }
    public string? FMaterialID { get; set; }
    public string? FNeedQty { get; set; }
    public string? FPickedQty { get; set; }
    public string? FPositionNO { get; set; }
    public string? FChildSupplyOrgId { get; set; }
    public string? FSupplyOrg { 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; }

    public string? FID { get; set; }
    public string? FENTRYID { get; set; }
    public string? FSeq { get; set; }

    public string? FFixScrapQty { get; set; }

    public string? FScrapRate { get; set; }
    public string? FSALEORDERNO { get; set; }
    public string? F_ZJXF_YHRQ { get; set; }
    public string? FXSHTBH { get; set; }
    public string? FReplaceGroup { get; set; }
    public string? FOwnerTypeId { get; set; }
    public string? FMaterialType { get; set; }
}

 MES.Service/Dto/webApi/ErpCustomer.cs

@@ -2,13 +2,16 @@

public class ErpCustomer
{
    public string? Type { get; set; }
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FNumber { get; set; }
    public string? FShortName { get; set; }
    public string? FName { get; set; }
    public string? Fcontact { get; set; }
    public string? Fmobilephone { get; set; }
    public string? Fseller { get; set; }
    public string? FContact { get; set; }
    public string? FMobilephone { get; set; }
    public string? FSeller { get; set; }
    public string? FForbidStatus { get; set; }
    public string? FCreateOrgId { get; set; }
    public string? FUseOrgId { get; set; }
    public string? FDescription { get; set; }
}

 MES.Service/Dto/webApi/ErpDelivery.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,11 @@
namespace MES.Service.Dto.webApi;
public class ErpDelivery
{
    public string? Type { get; set; }
    public string? DeliveryNo { get; set; }
    public string? DepotNo { get; set; }
    public string? FDate { get; set; }
    public string? Remark { get; set; }
    public string? SupplierId { get; set; }
    public string? ErpId { get; set; }
}

 MES.Service/Dto/webApi/ErpDeliveryData.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
namespace MES.Service.Dto.webApi;
public class ErpDeliveryData
{
    public string? LineNo { get; set; }
    public string? FBillNo { get; set; }
    public string? ProductCode { get; set; }
    public string? IncludeQty { get; set; }
    public string? PurchaseQty { get; set; }
    public string? DeliveryQty { get; set; }
    public string? SalesOrderId { get; set; }
    public string? OrderlineId { get; set; }
    public string? PurchaseUnit { get; set; }
    public string? InventoryUnit { get; set; }
    public string? FXSHTH { get; set; }
    public string? Remark { get; set; }
}

 MES.Service/Dto/webApi/ErpDepartment.cs

@@ -3,18 +3,14 @@
public class ErpDepartment
{
    public string Id { get; set; }

    public string? FNumber { get; set; }

    public string? FName { get; set; }

    public string? FDeptProperty { get; set; }

    public string? FGroup { get; set; }

    public string? FWIPStockID { get; set; }

    public string? FForbidStatus { get; set; }

    public string? Type { get; set; }
    public string? FParentID { get; set; }
    public string? FCreateOrgId { get; set; }
    public string? FUseOrgId { get; set; }
}

 MES.Service/Dto/webApi/ErpDepots.cs

@@ -2,11 +2,12 @@

public class ErpDepots
{
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FNumber { get; set; }

    public string? FName { get; set; }

    public string Id { get; set; }

    public string? FAllowMinusQty { get; set; }

@@ -18,5 +19,8 @@

    public string? FGroup { get; set; }

    public string? Type { get; set; }

    public string? FCreateOrgId { get; set; }

    public string? FUseOrgId { get; set; }
}

 MES.Service/Dto/webApi/ErpItemType.cs

@@ -2,9 +2,9 @@

public class ErpItemType
{
    public string? Type { get; set; }
    public string Id { get; set; }
    public string? FParentGroup { get; set; }
    public string? Type { get; set; }
    public string? FParentId { get; set; }
    public string? FNumber { get; set; }
    public string? FName { get; set; }
    public string? FDescription { get; set; }

 MES.Service/Dto/webApi/ErpItems.cs

@@ -25,7 +25,12 @@
    public string? FForbidStatus { get; set; }
    public string? FErpClsID { get; set; }
    public string? FWorkShopId { get; set; }

    public string? FPRODUCEUNITID { get; set; }
    public string? FSUBCONUNITID { get; set; }
    public string? FCreateOrgId { get; set; }
    public string? FUseOrgId { get; set; }
    public string? FLOSSPERCENT { get; set; }
    public string? FMnemonicCode { get; set; }
    public string? FExpPeriod { get; set; }
    public string? FColor { get; set; }
}

 MES.Service/Dto/webApi/ErpOrganize.cs

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

public class ErpOrganize
{
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FNumber { get; set; }
    public string? FName { get; set; }
    public string? FForbidStatus { get; set; }
    public string? FDescription { get; set; }
    public string? FParentID { get; set; }
    public string? fCreateDate { get; set; }
    public string? FForbidorid { get; set; }
    public string? FForbiddate { get; set; }


}

 MES.Service/Dto/webApi/ErpPosition.cs

@@ -2,12 +2,13 @@

public class ErpPosition
{

    public string Id { get; set; }
    /// <summary>
    ///     0 å¯ç”¨ 1禁用 2 å®¡æ ¸ 3反审核
    /// </summary>
    public string? Type { get; set; }

    public string Id { get; set; }

    public string? FNumber { get; set; }


 MES.Service/Dto/webApi/ErpRohIn.cs

@@ -14,22 +14,10 @@
    public string? FPurchaseOrgId { get; set; }
    public string? FPurchaseDeptId { get; set; }
    public string? FPurchaserGroupId { get; set; }
    public string? Facctype { get; set; }
    public string? FPurchaserId { get; set; }

    public string? F_UNW_Remarks_zlyq { get; set; }

    // public string? F_UNW_GYSLXR { get; set; }
    // public string? F_UNW_LXRDH { get; set; }
    // public string? FProviderJob { get; set; }
    // public string? FProviderPhone { get; set; }
    // public string? FProviderAddress { get; set; }
    public string? FSettleId { get; set; }
    public string? FChargeId { get; set; }
    public string? FProviderEMail { get; set; }
    public string? F_UNW_Text_ysfs { get; set; }
    public string? F_UNW_BZ { get; set; }
    public string? F_UNW_Combo_zjmj { get; set; }
    public string? FCancelStatus { get; set; }
    public string? FCancellerId { get; set; }
    public string? FCancelDate { get; set; }
@@ -40,7 +28,8 @@
    public string? FApproverId { get; set; }
    public string? FApproveDate { get; set; }

    public string? FCHANGEREASON { get; set; }
    public string? FChangeReason { get; set; }
    public string? FReceiveOrgId { get; set; }

    //采购订单A  é‡‡è´­è®¢å•å˜æ›´å•B    
    public string? FBILLTYPE { get; set; }

 MES.Service/Dto/webApi/ErpRohinData.cs

@@ -5,10 +5,9 @@
    public string id { get; set; }
    public string Eid { get; set; }
    public string? FBillNo { get; set; }
    public string? F_UNW_Text_xsddh { get; set; }
    public string? FSeq { get; set; }
    public string? FXSHTH { get; set; }
    public string? FMaterialId { get; set; }
    public string? FMaterialName { get; set; }
    public string? FModel { get; set; }
    public string? FUnitId { get; set; }
    public string? FQty { get; set; }
    public string? FStockUnitID { get; set; }
@@ -17,11 +16,19 @@
    public string? FDeliveryDate { get; set; }
    public string? FDeliveryEarlyDate { get; set; }
    public string? FDeliveryLastDate { get; set; }
    // start
    public string? FRequireOrgId { get; set; }
    public string? FRequireDeptId { get; set; }
    public string? FReceiveOrgId { get; set; }
    public string? FReceiveDeptId { get; set; }
    public string? FEntrySettleOrgId { get; set; }
    // end
    public string? FGiveAway { get; set; }
    public string? FNote { get; set; }
    public string? FEntryNote { get; set; }
    public string? FSupMatId { get; set; }
    public string? FSupMatName { get; set; }
    public string? FSUBREQBILLNO { get; set; }
    public string? FSubreqBillNo { get; set; }
    public string? FLot { get; set; }
    public string? FMRPCloseStatus { get; set; }
    public string? FMRPFreezeStatus { get; set; }
@@ -30,23 +37,19 @@
    public string? FMRPTerminateStatus { get; set; }
    public string? FTerminaterId { get; set; }
    public string? FTerminateDate { get; set; }
    public string? FReceiveQty { get; set; }
    public string? FBaseReceiveQty { get; set; }
    public string? FRemainReceiveQty { get; set; }
    public string? FStockInQty { get; set; }
    public string? FBaseStockInQty { get; set; }
    public string? FRemainStockINQty { get; set; }
    public string? FMrbQty { get; set; }
    public string? FCHECKRETQTY { get; set; }
    public string? FSTOCKRETQTY { get; set; }
    public string? FBaseCheckRetQty { get; set; }
    public string? FBaseStockRetQty { get; set; }
    public string? FSrcBillTypeId { get; set; }
    public string? FSrcBillNo { get; set; }
    public string? FReqTraceNo { get; set; }
    public string? FMtoNo { get; set; }
    public string? FChangeFlag { get; set; }
    public string? FDEMANDTYPE { get; set; }
    public string? FDEMANDBILLNO { get; set; }
    public string? FDEMANDBILLENTRYSEQ { get; set; }
    public string? PurchaseOrderLineNumber { get; set; }
    public string? Demand { get; set; }
    public string? Receiving { get; set; }
    public string? Settlement { get; set; }
    public string? FDemandType { get; set; }
    public string? FDemandBillNo { get; set; }
    public string? FDemandBillEntrySeq { get; set; }
}

 MES.Service/Dto/webApi/ErpStaff.cs

@@ -2,8 +2,8 @@

public class ErpStaff
{
    public string? Type { get; set; }
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FStaffNumber { get; set; }
    public string? FName { get; set; }
    public string? FPostDept { get; set; }
@@ -12,4 +12,6 @@
    public string? FStaffStartDate { get; set; }
    public string? FDescription { get; set; }
    public string? FForbidStatus { get; set; }
    public string? FCreateOrgId { get; set; }
    public string? FUseOrgId { get; set; }
}

 MES.Service/Dto/webApi/ErpSupplier.cs

@@ -2,13 +2,16 @@

public class ErpSupplier
{
    public string? Type { get; set; }
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FNumber { get; set; }
    public string? FShortName { get; set; }
    public string? FName { get; set; }
    public string? F_UNW_LXR { get; set; }
    public string? F_UNW_LXRDH { get; set; }
    public string? FContact { get; set; }
    public string? FTel { get; set; }
    public string? FStaffId { get; set; }
    public string? FForbidStatus { get; set; }
    public string? FCreateOrgId { get; set; }
    public string? FUseOrgId { get; set; }
    public string? FDescription { get; set; }
}

 MES.Service/Dto/webApi/ErpUnit.cs

@@ -2,8 +2,8 @@

public class ErpUnit
{
    public string? Type { get; set; }
    public string Id { get; set; }
    public string? Type { get; set; }
    public string? FNumber { get; set; }
    public string? FName { get; set; }
    public string? FUnitGroupId { get; set; }

 MES.Service/Modes/MesCustomer.cs

@@ -141,16 +141,16 @@
    public string? Fseller { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal? CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal? UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3

 MES.Service/Modes/MesDeliveryNote.cs

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

namespace MES.Service.Modes;

/// <summary>
///     é€è´§å•æ¡ç è¡¨
/// </summary>
[SugarTable("MES_DELIVERY_NOTE")]
public class MesDeliveryNote
{
    /// <summary>
    ///     SEQ_DELIVERY
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DELIVERY")]
    public decimal Id { get; set; }

    /// <summary>
    ///     é€è´§å•å·
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_NO")]
    public string? DeliveryNo { get; set; }

    /// <summary>
    ///     ä¾›åº”商
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }

    /// <summary>
    ///     å•æ®æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public string? DeliveryDate { get; set; }

    /// <summary>
    ///     å®¡æ ¸æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public decimal? Status { get; set; }

    /// <summary>
    ///     å®¡æ ¸äºº
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_USER")]
    public string? CheckUser { get; set; }

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

    /// <summary>
    ///     å®¡æ ¸æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "SITE")]
    public string? Site { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }

    /// <summary>
    ///     ä»“库编号
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_NO")]
    public string? DepotNo { get; set; }


    /// <summary>
    ///     ERP收料通知单据头内码
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public string? ErpId { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}

 MES.Service/Modes/MesDeliveryNoteBarcode.cs

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

namespace MES.Service.Modes;

/// <summary>
///     é€è´§å•æ¡ç è¡¨
/// </summary>
[SugarTable("MES_DELIVERY_NOTE_BARCODE")]
public class MesDeliveryNoteBarcode
{
    /// <summary>
    ///     SEQ_DELIVERY
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,OracleSequenceName = "SEQ_DELIVERY")]
    public decimal Id { get; set; }

    /// <summary>
    ///     é€è´§å•å·
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_NO")]
    public string? DeliveryNo { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_CODE")]
    public string? ProductCode { get; set; }

    /// <summary>
    ///     ç‰©æ–™æ¡ç 
    /// </summary>
    [SugarColumn(ColumnName = "SMALL_BARCODE")]
    public string? SmallBarcode { get; set; }

    /// <summary>
    ///     æ¡ç æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "INCLUDE_QTY")]
    public decimal? IncludeQty { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     ä¾›åº”商
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }

    /// <summary>
    ///     é€è´§å•é¡¹æ¬¡
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public decimal? LineNo { get; set; }


    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}

 MES.Service/Modes/MesDeliveryNoteDetails.cs

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

namespace MES.Service.Modes;

/// <summary>
///     é€è´§å•æ¡ç è¡¨
/// </summary>
[SugarTable("MES_DELIVERY_NOTE_DETAILS")]
public class MesDeliveryNoteDetails
{
    /// <summary>
    ///     SEQ_DELIVERY
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DELIVERY")]
    public decimal Id { get; set; }

    /// <summary>
    ///     é€è´§å•å·
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_NO")]
    public string? DeliveryNo { get; set; }

    /// <summary>
    ///     é¡¹æ¬¡å·
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public decimal? LineNo { get; set; }

    /// <summary>
    ///     ERP采购单号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_NO")]
    public string? ErpNo { get; set; }

    /// <summary>
    ///     é‡‡è´­å•é¡¹æ¬¡
    /// </summary>
    [SugarColumn(ColumnName = "PO_LINENO")]
    public string? PoLineNo { get; set; }

    /// <summary>
    ///     äº§å“ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_CODE")]
    public string? ProductCode { get; set; }

    /// <summary>
    ///     æ”¶æ–™å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "SL_UNIT")]
    public string? SlUnit { get; set; }

    /// <summary>
    ///     åº“存单位
    /// </summary>
    [SugarColumn(ColumnName = "KC_UNIT")]
    public string? KcUnit { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     æœ¬æ¬¡åº”收数量
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_QTY")]
    public decimal? DeliveryQty { get; set; }

    /// <summary>
    ///     è®¢å•æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_QTY")]
    public decimal? PurchaseQty { get; set; }

    /// <summary>
    ///     äº¤è´§æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "INCLUDE_QTY")]
    public decimal? IncludeQty { get; set; }

    /// <summary>
    ///     é”€å”®è®¢å•å·
    /// </summary>
    [SugarColumn(ColumnName = "SALE_ORDER")]
    public string? SaleOrder { get; set; }

    /// <summary>
    ///     æºå•å•å·
    /// </summary>
    [SugarColumn(ColumnName = "FSRCBILL_NO")]
    public string? Fsrcbill_no { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }

    /// <summary>
    ///     æœ¬æ¬¡å®žæ”¶æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "REAL_QTY")]
    public decimal? RealQty { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}

 MES.Service/Modes/MesDepots.cs

@@ -147,16 +147,16 @@
    public string? MaterialProperti { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal? CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal? UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3

 MES.Service/Modes/MesItems.cs

@@ -18,73 +18,73 @@
    ///     å·¥åŽ‚
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }
    public string? Factory { get; set; }

    /// <summary>
    ///     å…¬å¸ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }
    public string? Company { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç¼–码 = ERP物料编号||颜色编号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string ItemNo { get; set; }
    public string? ItemNo { get; set; }

    /// <summary>
    ///     ç‰©æ–™åç§°
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NAME")]
    public string ItemName { get; set; }
    public string? ItemName { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç®€ç§°
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_SNAME")]
    public string ItemSname { get; set; }
    public string? ItemSname { get; set; }

    /// <summary>
    ///     è§„格型号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_MODEL")]
    public string ItemModel { get; set; }
    public string? ItemModel { get; set; }

    /// <summary>
    ///     ç‰©æ–™æè¿°
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
    public string ItemDescription { get; set; }
    public string? ItemDescription { get; set; }

    /// <summary>
    ///     ç‰©æ–™å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_UNIT")]
    public string ItemUnit { get; set; }
    public string? ItemUnit { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_TYPE")]
    public string ItemType { get; set; }
    public string? ItemType { get; set; }

    /// <summary>
    ///     äº§å“ç‰ˆæœ¬
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_VERSION")]
    public string ItemVersion { get; set; }
    public string? ItemVersion { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "CUST_NO")]
    public string CustNo { get; set; }
    public string? CustNo { get; set; }

    /// <summary>
    ///     åˆ›å»ºäºº
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string CreateBy { get; set; }
    public string? CreateBy { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
@@ -96,7 +96,7 @@
    ///     æœ€åŽæ›´æ–°äºº
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string LastupdateBy { get; set; }
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     æœ€åŽæ›´æ–°æ—¶é—´
@@ -126,25 +126,25 @@
    ///     è®¢å•å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "ORDERUNIT")]
    public string Orderunit { get; set; }
    public string? Orderunit { get; set; }

    /// <summary>
    ///     é”€å”®å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "SALEUNIT")]
    public string Saleunit { get; set; }
    public string? Saleunit { get; set; }

    /// <summary>
    ///     åº“房单位
    /// </summary>
    [SugarColumn(ColumnName = "STOREUNIT")]
    public string Storeunit { get; set; }
    public string? Storeunit { get; set; }

    /// <summary>
    ///     ç”Ÿäº§å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCTUNIT")]
    public string Productunit { get; set; }
    public string? Productunit { get; set; }

    /// <summary>
    ///     ç‰©æ–™ID
@@ -156,43 +156,43 @@
    ///     ERP料号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
    public string ErpItemNo { get; set; }
    public string?  ErpItemNo { get; set; }

    /// <summary>
    ///     é»˜è®¤ä»“库
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string DepotCode { get; set; }
    public string? DepotCode { get; set; }

    /// <summary>
    ///     ç‰©æ–™åˆ†ç±»ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "PPBOM00019124")]
    public string Ppbom00019124 { get; set; }
    public string? Ppbom00019124 { get; set; }

    /// <summary>
    ///     ç‰©æ–™åˆ†ç»„
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string Remarks { get; set; }
    public string? Remarks { get; set; }

    /// <summary>
    ///     é‡‡è´­å‘˜
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASERID")]
    public string Fpurchaserid { get; set; }
    public string? Fpurchaserid { get; set; }

    /// <summary>
    ///     ç¦ç”¨çŠ¶æ€
    /// </summary>
    [SugarColumn(ColumnName = "FFORBIDSTATUS")]
    public string Fforbidstatus { get; set; }
    public string? Fforbidstatus { get; set; }

    /// <summary>
    ///     ç‰©æ–™åˆ†ç»„
    /// </summary>
    [SugarColumn(ColumnName = "FMATERIALGROUP")]
    public string Fmaterialgroup { get; set; }
    public string? Fmaterialgroup { get; set; }

    /// <summary>
    ///     å®Œå·¥è¶…收比例
@@ -204,7 +204,7 @@
    ///     å‘料方式
    /// </summary>
    [SugarColumn(ColumnName = "FISSUETYPE")]
    public string Fissuetype { get; set; }
    public string? Fissuetype { get; set; }

    /// <summary>
    ///     å¯ç”¨æ‰¹å·ç®¡ç†
@@ -216,97 +216,97 @@
    ///     é‡‡è´­å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASEUNITID")]
    public string Fpurchaseunitid { get; set; }
    public string? Fpurchaseunitid { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3
    ///     æŸè€—率
    /// </summary>
    [SugarColumn(ColumnName = "REMARK3")]
    public string Remark3 { get; set; }
    [SugarColumn(ColumnName = "LOSS_PERCENT")]
    public string? LossPercent { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段4
    ///     åŠ©è®°ç 
    /// </summary>
    [SugarColumn(ColumnName = "REMARK4")]
    public string Remark4 { get; set; }
    [SugarColumn(ColumnName = "MNEMONIC_CODE")]
    public string? MnemonicCode { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段5
    ///     ä¿è´¨æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "REMARK5")]
    public string Remark5 { get; set; }
    [SugarColumn(ColumnName = "EXP_PERIOD")]
    public string? ExpPeriod { get; set; }

    /// <summary>
    ///     ç”Ÿäº§è½¦é—´
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
    public string ProductionWorkshop { get; set; }
    public string? ProductionWorkshop { get; set; }

    /// <summary>
    ///     ç‰©æ–™å±žæ€§
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
    public string MaterialProperti { get; set; }
    public string? MaterialProperti { get; set; }

    /// <summary>
    ///     ç”Ÿäº§å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCE_UNIT")]
    public string ProduceUnit { get; set; }
    public string? ProduceUnit { get; set; }

    /// <summary>
    ///     å§”外单位
    /// </summary>
    [SugarColumn(ColumnName = "SUBCON_UNIT")]
    public string SubconUnit { get; set; }
    public string? SubconUnit { get; set; }

    /// <summary>
    ///     å›¾ç‰‡1
    /// </summary>
    [SugarColumn(ColumnName = "BZ06")]
    public string Bz06 { get; set; }
    public string? Bz06 { get; set; }

    /// <summary>
    ///     å›¾ç‰‡2
    /// </summary>
    [SugarColumn(ColumnName = "BZ07")]
    public string Bz07 { get; set; }
    public string? Bz07 { get; set; }

    /// <summary>
    ///     å›¾ç‰‡3
    /// </summary>
    [SugarColumn(ColumnName = "BZ08")]
    public string Bz08 { get; set; }
    public string? Bz08 { get; set; }

    /// <summary>
    ///     å›¾ç‰‡4
    /// </summary>
    [SugarColumn(ColumnName = "BZ09")]
    public string Bz09 { get; set; }
    public string? Bz09 { get; set; }

    /// <summary>
    ///     å›¾ç‰‡5
    /// </summary>
    [SugarColumn(ColumnName = "BZ10")]
    public string Bz10 { get; set; }
    public string? Bz10 { get; set; }

    /// <summary>
    ///     QC分组ID
    /// </summary>
    [SugarColumn(ColumnName = "QC_TEAMID")]
    public string QcTeamid { get; set; }
    public string? QcTeamid { get; set; }

    /// <summary>
    ///     ç‰©æ–™ID
@@ -314,5 +314,11 @@
    [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }

    /// <summary>
    ///     é¢œè‰²
    /// </summary>
    [SugarColumn(ColumnName = "COLOR_NAME")]
    public string? ColorName { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}

 MES.Service/Modes/MesRohIn.cs

@@ -268,4 +268,16 @@
    /// </summary>
    [SugarColumn(ColumnName = "REMARK5")]
    public string? Remark5 { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "ARRIVE_DATE")]
    public DateTime? ArriveDate { get; set; }

    /// <summary>
    ///     é‡‡è´­æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVE_ORG")]
    public decimal? ReceiveOrg { get; set; }
}

 MES.Service/Modes/MesRohInData.cs

@@ -347,4 +347,22 @@
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT")]
    public string? Settlement { get; set; }

    /// <summary>
    ///     éœ€æ±‚部门
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DEPT")]
    public string? DemandDept { get; set; }

    /// <summary>
    ///     éœ€æ±‚部门
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_DEPT")]
    public string? ReceivingDept { get; set; }

    /// <summary>
    ///     é¢„计到货时间
    /// </summary>
    [SugarColumn(ColumnName = "ARRIVE_DATE")]
    public DateTime? ArriveDate { get; set; }
}

 MES.Service/Modes/MesStaff.cs

@@ -18,43 +18,43 @@
    ///     å‘˜å·¥ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "STAFF_NO")]
    public string StaffNo { get; set; }
    public string? StaffNo { get; set; }

    /// <summary>
    ///     å‘˜å·¥å§“名
    /// </summary>
    [SugarColumn(ColumnName = "STAFF_NAME")]
    public string StaffName { get; set; }
    public string? StaffName { get; set; }

    /// <summary>
    ///     éƒ¨é—¨ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENT_NO")]
    public string DepartmentNo { get; set; }
    public string? DepartmentNo { get; set; }

    /// <summary>
    ///     éƒ¨é—¨åç§°
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENT_NAME")]
    public string DepartmentName { get; set; }
    public string? DepartmentName { get; set; }

    /// <summary>
    ///     å²—位编码
    /// </summary>
    [SugarColumn(ColumnName = "POSITION_CODE")]
    public string PositionCode { get; set; }
    public string? PositionCode { get; set; }

    /// <summary>
    ///     å²—位名称
    /// </summary>
    [SugarColumn(ColumnName = "POSITION_NAME")]
    public string PositionName { get; set; }
    public string? PositionName { get; set; }

    /// <summary>
    ///     æ‰‹æœºå·
    /// </summary>
    [SugarColumn(ColumnName = "PHONE_NUMBER")]
    public string PhoneNumber { get; set; }
    public string? PhoneNumber { get; set; }

    /// <summary>
    ///     ä»»å²—开始日期
@@ -66,43 +66,43 @@
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string Remark { get; set; }
    public string? Remark { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal? CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal? UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3
    /// </summary>
    [SugarColumn(ColumnName = "REMARK3")]
    public string Remark3 { get; set; }
    public string? Remark3 { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段4
    /// </summary>
    [SugarColumn(ColumnName = "REMARK4")]
    public string Remark4 { get; set; }
    public string? Remark4 { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段5
    /// </summary>
    [SugarColumn(ColumnName = "REMARK5")]
    public string Remark5 { get; set; }
    public string? Remark5 { get; set; }

    /// <summary>
    ///     åˆ›å»ºäºº
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string CreateBy { get; set; }
    public string? CreateBy { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
@@ -114,7 +114,7 @@
    ///     æ›´æ–°äºº
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string LastupdateBy { get; set; }
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     æ›´æ–°æ—¶é—´
@@ -126,13 +126,13 @@
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "MEMO")]
    public string Memo { get; set; }
    public string? Memo { get; set; }

    /// <summary>
    ///     ç”Ÿäº§çº¿
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string LineNo { get; set; }
    public string? LineNo { get; set; }

    /// <summary>
    ///     ç”Ÿäº§å‘˜å·¥æ ‡è¯†
@@ -144,7 +144,7 @@
    ///     æ˜¯å¦ç¦ç”¨
    /// </summary>
    [SugarColumn(ColumnName = "FFORBID_STATUS")]
    public string FforbidStatus { get; set; }
    public string? FforbidStatus { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}

 MES.Service/Modes/MesSupplier.cs

@@ -141,16 +141,16 @@
    public string? Fforbidstatus { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal? CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal? UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3

 MES.Service/Modes/Organize.cs

@@ -10,27 +10,41 @@
    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "ID")]
    public decimal? Id { get; set; }
    public decimal Id { get; set; }

    /// <summary>
    ///     ç»„织英文
    ///     ç»„织id
    /// </summary>
    [SugarColumn(ColumnName = "FNUMBER")]
    public string Fnumber { get; set; }
    public string? Fnumber { get; set; }

    /// <summary>
    ///     ç»„织名
    ///     ç»„织名称
    /// </summary>
    [SugarColumn(ColumnName = "FNAME")]
    public string Fname { get; set; }
    public string? Fname { get; set; }

    /// <summary>
    /// æ˜¯å¦å¯ç”¨
    /// </summary>
    [SugarColumn(ColumnName = "FFORBIDSTATUS")]
    public string Fforbidstatus { get; set; }
    public string? Fforbidstatus { get; set; }

    /// <summary>
    /// æ“ä½œç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "TYPE")]
    public string Type { get; set; }
    public string? Type { get; set; }

    /// <summary>
    /// ä¸Šçº§ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "FPARENTID")]
    public string? Fparentid { get; set; }

    /// <summary>
    /// åˆ›å»ºæ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "FCREATEDATE")]
    public DateTime? Fcreatedate { get; set; }
}

 MES.Service/Modes/SysDepartment.cs

@@ -134,22 +134,22 @@
    public string? MaterialProperti { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1
    ///     åˆ›å»ºç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }
    [SugarColumn(ColumnName = "CREATE_ORG")]
    public decimal? CreateOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段2
    ///     ä½¿ç”¨ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }
    [SugarColumn(ColumnName = "USE_ORG")]
    public decimal? UseOrg { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段3
    ///     ä¸Šçº§éƒ¨é—¨
    /// </summary>
    [SugarColumn(ColumnName = "REMARK3")]
    public string? Remark3 { get; set; }
    [SugarColumn(ColumnName = "PARENT_ID")]
    public decimal? ParentId { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段4

 MES.Service/Modes/Womcaa.cs

@@ -9,10 +9,9 @@
public class Womcaa
{
    /// <summary>
    ///     è‡ªå¢žåˆ—  SEQ_AOI
    ///     è‡ªå¢žåˆ—  SEQ_CAA
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
        OracleSequenceName = "SEQ_AOI")]
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,OracleSequenceName = "SEQ_CAA")]
    public decimal? Id { get; set; }

    /// <summary>
@@ -104,7 +103,7 @@
    ///     ERP源单行号
    /// </summary>
    [SugarColumn(ColumnName = "CAA019")]
    public decimal? Caa019 { get; set; }
    public string? Caa019 { get; set; }

    /// <summary>
    ///     ERP源单单号(任务单号)
@@ -273,4 +272,82 @@
    /// </summary>
    [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
    public string? SrcSplitBillno { get; set; }

    /// <summary>
    ///     å®¢æˆ·
    /// </summary>
    [SugarColumn(ColumnName = "F_ZSXG_KH")]
    public string? F_ZSXG_KH { get; set; }

    /// <summary>
    ///     è¦è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "F_ZJXF_YHRQ")]
    public string? F_ZJXF_YHRQ { get; set; }

    /// <summary>
    ///     ç”Ÿäº§ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "PRD_ORG")]
    public string? PrdOrg { get; set; }

    /// <summary>
    ///     å§”托组织
    /// </summary>
    [SugarColumn(ColumnName = "TRUST_ORG")]
    public string? TrustOrg { get; set; }

    /// <summary>
    ///     åŒæ­¥æ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "TB_TIME")]
    public DateTime? TbTime { get; set; }

    /// <summary>
    ///     ç»“案时间
    /// </summary>
    [SugarColumn(ColumnName = "JA_TIME")]
    public DateTime? JaTime { get; set; }

    /// <summary>
    ///     ç»“案标识
    /// </summary>
    [SugarColumn(ColumnName = "JA_BS")]
    public string? JaBs { get; set; }

    /// <summary>
    ///     ä¿®æ”¹æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "IS_XG")]
    public decimal? IsXg { get; set; }

    /// <summary>
    ///     å§”外采购订单
    /// </summary>
    [SugarColumn(ColumnName = "FPURORDERNO")]
    public string? FPURORDERNO { get; set; }

    /// <summary>
    ///     å§”外采购订单
    /// </summary>
    [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
    public decimal? FPURORDERENTRYSEQ { get; set; }

    /// <summary>
    ///     å§”外订单分录内码
    /// </summary>
    [SugarColumn(ColumnName = "FSUBENTRYID")]
    public decimal? FSUBENTRYID { get; set; }

    /// <summary>
    ///     å§”外入库数
    /// </summary>
    [SugarColumn(ColumnName = "FSTOCKINQTY")]
    public decimal? FSTOCKINQTY { get; set; }

    /// <summary>
    ///     å§”外未入库数
    /// </summary>
    [SugarColumn(ColumnName = "FNOSTOCKINQTY")]
    public decimal? FNOSTOCKINQTY { get; set; }
}

 MES.Service/Modes/Womcab.cs

@@ -11,8 +11,7 @@
    /// <summary>
    ///     è‡ªå¢žåˆ—
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
        OracleSequenceName = "SEQ_AOI")]
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,OracleSequenceName = "SEQ_CAB")]
    public decimal? Id { get; set; }

    /// <summary>
@@ -145,13 +144,13 @@
    ///     åˆ†å­
    /// </summary>
    [SugarColumn(ColumnName = "NUMERATOR")]
    public string? Numerator { get; set; }
    public decimal? Numerator { get; set; }

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

    /// <summary>
    ///     å›ºå®šæŸè€—
@@ -164,4 +163,16 @@
    /// </summary>
    [SugarColumn(ColumnName = "SCRAPRATE")]
    public decimal? SCRAPRATE { get; set; }

    /// <summary>
    ///     é”€å”®è®¢å•å·
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER")]
    public string? SalesOrder { get; set; }

    /// <summary>
    ///     è¦è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "F_ZJXF_YHRQ")]
    public string? F_ZJXF_YHRQ { 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/MesCustomerManager.cs

@@ -56,13 +56,11 @@
                switch (customerGroup.Key)
                {
                    case "0":
                        if (!UpdateCustomerStatusBatch(db, customerGroup.Value,
                                "A"))
                        if (!UpdateCustomerStatusBatch(db, customerGroup.Value,"A"))
                            throw new NotImplementedException("启用失败");
                        break;
                    case "1":
                        if (!UpdateCustomerStatusBatch(db, customerGroup.Value,
                                "B"))
                        if (!UpdateCustomerStatusBatch(db, customerGroup.Value,"B"))
                            throw new NotImplementedException("禁用失败");
                        break;
                    case "2":
@@ -126,10 +124,13 @@
            CustNo = customer.FNumber,
            CustSname = customer.FShortName,
            CustName = customer.FName,
            Anred = customer.Fcontact,
            Telf1 = customer.Fmobilephone,
            Fseller = customer.Fseller,
            Anred = customer.FContact,
            Telf1 = customer.FMobilephone,
            Fseller = customer.FSeller,
            Fforbidstatus = customer.FForbidStatus,
            CreateDate = DateTime.Now,
            CreateOrg= Convert.ToDecimal(customer.FCreateOrgId),
            UseOrg= Convert.ToDecimal(customer.FUseOrgId),
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/BasicData/MesDeliveryNoteBarcodeManager.cs

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

namespace MES.Service.service.BasicData;

public class MesDeliveryNoteBarcodeManager : Repository<MesDeliveryNoteBarcode>
{
    //private readonly MesDeliveryNoteBarcodeManager mesDeliveryNoteBarcode = new();
    public bool Save(ErpBarcode barcode)
    {
        var mesDeliveryNoteBarcode = GetMesDeliveryNoteBarcode(barcode);

        return UseTransaction(db =>
        {
            switch (barcode.Type)
            {
                case "2":
                case "4":
                case "5":
                    return SaveOrUpdateData(db, mesDeliveryNoteBarcode) ? 1 : 0;
                case "3":
                case "6":
                    return DeleteData(db, mesDeliveryNoteBarcode) ? 1: 0;
                default:
                    throw new ArgumentNullException(
                        $"type没有{barcode.Type}这个类型的参数");
            }

            throw new NotImplementedException("操作失败");
        }) > 0;
    }

    // æ’入数据的方法
    private bool InsertData(SqlSugarScope db, MesDeliveryNoteBarcode mesDeliveryNoteBarcode)
    {

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

        var insert = base.Insert(mesDeliveryNoteBarcode);

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

    // æ›´æ–°æ•°æ®çš„方法
    private bool DeleteData(SqlSugarScope db, MesDeliveryNoteBarcode mesDeliveryNoteBarcode)
    {
        var detect = base.DeleteById(mesDeliveryNoteBarcode.Id);

        if (detect) return true;
        throw new NotImplementedException("更新失败");
    }

    // æ’入或更新数据的方法
    private bool SaveOrUpdateData(SqlSugarScope db, MesDeliveryNoteBarcode mesDeliveryNoteBarcode)
    {
        if (mesDeliveryNoteBarcode.Id != null) base.DeleteById(mesDeliveryNoteBarcode.Id);

        var orUpdate = base.Insert(mesDeliveryNoteBarcode);
        if (orUpdate) return true;
        throw new NotImplementedException("插入或更新失败");
    }


    // æ‰¹é‡ä¿å­˜è®°å½•çš„方法
    public bool SaveList(List<ErpBarcode> barcodes)
    {
        var result = barcodes.Select(Save).ToList();
        return result.All(b => b);
    /*    var list = barcodes.Select(GetMesDeliveryNoteBarcode).ToList();
        var groupBy = list.GroupBy(s => s.Type)
            .ToDictionary(g => g.Key, g => g.ToList());

        return UseTransaction(db =>
        {
            foreach (var barcodeGroup in groupBy)
                switch (barcodeGroup.Key)
                {
                    case "1":
                        if (!UpdateItemStatusBatch(db, barcodeGroup.Value, "B"))
                            throw new NotImplementedException("禁用失败");
                        break;
                    case "2":
                        if (!InsertItemBatch(db, barcodeGroup.Value))
                            throw new NotImplementedException("插入失败");
                        break;
                    default:
                        throw new ArgumentNullException(
                            $"type没有{barcodeGroup.Key}这个类型的参数");
                }

            return 1;
        }) > 0; */
    }

  /*  private bool InsertItemBatch(SqlSugarScope db, List<MesDeliveryNoteBarcode> barcodeList)
    {
        var insertRange = db.Insertable(barcodeList).ExecuteCommand();
        if (insertRange > 0)
            return true;

        throw new NotImplementedException("插入失败");
    }

    private bool DeleteItemBatch(SqlSugarScope db, List<MesDeliveryNoteBarcode> barcodeList)
    {
        var ids = barcodeList.Select(it => it.Id).ToArray();
        var deleteByIds = db.Deleteable<MesItems>().In(ids).ExecuteCommand();
        if (deleteByIds > 0)
            return true;

        throw new NotImplementedException("删除失败");
    } */


    public MesDeliveryNoteBarcode GetMesDeliveryNoteBarcode(ErpBarcode barcode)
    {
        var mesDeliveryNoteBarcode = new MesDeliveryNoteBarcode();
        var single = base.GetSingle(it => it.SmallBarcode == barcode.SmallBarcode);
        if (single != null) mesDeliveryNoteBarcode.Id = single.Id;


        mesDeliveryNoteBarcode.DeliveryNo = barcode.DeliveryNo;
        mesDeliveryNoteBarcode.ProductCode = barcode.ProductCode;
        mesDeliveryNoteBarcode.SmallBarcode= barcode.SmallBarcode;
        mesDeliveryNoteBarcode.IncludeQty= Convert.ToDecimal(barcode.IncludeQty);
        mesDeliveryNoteBarcode.LineNo=Convert.ToDecimal(barcode.LineNo);
        mesDeliveryNoteBarcode.CreateDate = DateTime.Now;
        mesDeliveryNoteBarcode.SuppNo = barcode.SupplierId;

        return mesDeliveryNoteBarcode;
    }


}

 MES.Service/service/BasicData/MesDeliveryNoteDetailsManager.cs

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

namespace MES.Service.service.BasicData;

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

    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesRohInDataManager.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(MesDeliveryNoteDetails).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 MesDeliveryNoteDetails(); //测试参数
        var insertArray = new[] { insertData };
        base.Insert(insertData); //插入
        base.InsertRange(insertArray); //批量插入
        var id = base.InsertReturnIdentity(insertData); //插入返回自增列
        AsInsertable(insertData).ExecuteCommand(); //我们可以转成 Insertable实现复杂插入


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


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

    #endregion
}

 MES.Service/service/BasicData/MesDeliveryNoteManager.cs

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

namespace MES.Service.service.BasicData;

public class MesDeliveryNoteManager : Repository<MesDeliveryNote>
{
    private readonly MesDeliveryDetailsManager mesDeliveryNoteManager= new ();

    // Save æ–¹æ³•ç”¨äºŽä¿å­˜å•ä¸ª RohIn è®°å½•ï¼Œæ ¹æ®ç±»åž‹æ‰§è¡Œä¸åŒçš„操作
    public bool Save(Delivery delivery)
    {
        var erpDelivery = delivery.ErpDelivery;
        var mesDeliveryNote = GetMesDeliveryNote(erpDelivery);
        var mesDeliveryNoteDetails = GetMesDeliveryNoteDetails(delivery.ErpDeliveryData, erpDelivery.DeliveryNo, mesDeliveryNote.Status);

        return UseTransaction(db =>
        {
            switch (erpDelivery.Type)
            {
                case "2":
                case "4":
                case "5":
                    return SaveOrUpdateData(db, mesDeliveryNote, mesDeliveryNoteDetails) ? 1 : 0;
                case "3":
                case "6":
                    return DeleteData(db, mesDeliveryNote, mesDeliveryNoteDetails) ? 1: 0;
                default:
                    throw new NotImplementedException(
                        $"type没有{erpDelivery.Type}这个类型");
            }
        }) > 0;
    }

    // æ’入数据的方法
    private bool InsertData(SqlSugarScope db, MesDeliveryNote mesDeliveryNote,List<MesDeliveryNoteDetails> mesDeliveryNoteDetails)
    {
        var decimals = mesDeliveryNoteDetails.Select(s => s.Id).ToArray();

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

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

        var insert = base.Insert(mesDeliveryNote);
        var insertRange = mesDeliveryNoteManager.InsertRange(mesDeliveryNoteDetails);

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

    // æ›´æ–°æ•°æ®çš„方法
    private bool DeleteData(SqlSugarScope db, MesDeliveryNote mesDeliveryNote,List<MesDeliveryNoteDetails> mesDeliveryNoteDetails)
    {
        var decimals = mesDeliveryNoteDetails.Select(s => s.Id).ToArray();
        var update = base.DeleteById(mesDeliveryNote.Id);
        var insertOrUpdate = db.Deleteable<MesDeliveryNoteDetails>().Where(s => s.DeliveryNo == mesDeliveryNote.DeliveryNo).ExecuteCommand() > 0;

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

    // æ’入或更新数据的方法
    private bool SaveOrUpdateData(SqlSugarScope db, MesDeliveryNote mesDeliveryNote,List<MesDeliveryNoteDetails> mesDeliveryNoteDetails)
    {
        if (mesDeliveryNote.Id != null) base.DeleteById(mesDeliveryNote.Id);

        if (mesDeliveryNoteDetails.Count > 0)
            db.Deleteable<MesDeliveryNoteDetails>().Where(s => s.DeliveryNo == mesDeliveryNote.DeliveryNo).ExecuteCommand();

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

    // æ‰¹é‡ä¿å­˜è®°å½•çš„方法
    public bool SaveList(List<Delivery> deliveries)
    {
        var result = deliveries.Select(Save).ToList();
        return result.All(b => b);
    }

    public MesDeliveryNote GetMesDeliveryNote(ErpDelivery delivery)
    {
        var mesDeliveryNote = new MesDeliveryNote();
        var single = base.GetSingle(it => it.DeliveryNo == delivery.DeliveryNo);
        if (single != null) mesDeliveryNote.Id = single.Id;

        mesDeliveryNote.DeliveryNo = delivery.DeliveryNo;
        mesDeliveryNote.SuppNo = delivery.SupplierId;
        mesDeliveryNote.DeliveryDate = delivery.FDate;
        mesDeliveryNote.Remark = delivery.Remark;
        if (single != null)
        {
            mesDeliveryNote.Status = single.Status;
            mesDeliveryNote.CheckUser = single.CheckUser;
            mesDeliveryNote.CheckDate = single.CheckDate;
        }
        else
        {
            mesDeliveryNote.Status =0;
        }
        mesDeliveryNote.CreateDate = DateTime.Now;
        mesDeliveryNote.DepotNo = delivery.DepotNo;
        mesDeliveryNote.ErpId = delivery.ErpId;

        return mesDeliveryNote;
    }
    public List<MesDeliveryNoteDetails> GetMesDeliveryNoteDetails(List<ErpDeliveryData> erpDeliveryDatas, string? type,decimal? status)
    {
        return erpDeliveryDatas.Select(s =>
        {
            var entity = new MesDeliveryNoteDetails
            {
                DeliveryNo = type,
                LineNo = Convert.ToDecimal(s.LineNo),
                ErpNo = s.FBillNo,
                PoLineNo = s.OrderlineId,
                ProductCode = s.ProductCode,
                SlUnit = s.PurchaseUnit,
                KcUnit = s.InventoryUnit,
                DeliveryQty = Convert.ToDecimal(s.DeliveryQty),
                Remark = s.Remark,
                CreateDate = DateTime.Now,
                SaleOrder = s.FXSHTH,
                PurchaseQty = Convert.ToDecimal(s.PurchaseQty),
                IncludeQty = Convert.ToDecimal(s.IncludeQty),
                Fsrcbill_no = s.SalesOrderId,
                RealQty = Convert.ToDecimal(s.IncludeQty)
            };
            var single = mesDeliveryNoteManager.GetSingle(it =>it.LineNo == entity.LineNo);
            if (single !=null && status==1) entity.RealQty = single.RealQty;

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

 MES.Service/service/BasicData/MesDepotsManager.cs

@@ -105,14 +105,17 @@
    {
        return new MesDepots
        {
            DepotId = Convert.ToDecimal(depots.Id),
            DepotCode = depots.FNumber,
            DepotName = depots.FName,
            DepotId = Convert.ToDecimal(depots.Id),
            IsFkc = depots.FAllowMinusQty,
            CreateBy = depots.FPrincipal,
            Depottype = depots.FStockProperty,
            IsNg = depots.FForbidStatus,
            Zuid = depots.FGroup,
            CreateOrg= Convert.ToDecimal(depots.FCreateOrgId),
            UseOrg= Convert.ToDecimal(depots.FUseOrgId),
            CreateDate = DateTime.Now,
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/BasicData/MesItemTypeManager.cs

@@ -53,10 +53,11 @@
        return new MesItemType
        {
            Id = Convert.ToDecimal(department.Id),
            Pgroup = department.FParentGroup,
            Pgroup = department.FParentId,
            Tcode = department.FNumber,
            Tname = department.FName,
            Description = department.FDescription,
            CreateDate = DateTime.Now,
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/BasicData/MesItemsManager.cs

@@ -130,6 +130,7 @@
        return new MesItems
        {
            Id = Convert.ToDecimal(item.Id),
            ItemId= Convert.ToDecimal(item.Id),
            ItemNo = item.FNumber,
            ItemName = item.FName,
            ItemModel = item.FSpecification,
@@ -153,6 +154,12 @@
            ProductionWorkshop = item.FWorkShopId,
            ProduceUnit = item.FPRODUCEUNITID,
            SubconUnit = item.FSUBCONUNITID,
            CreateOrg = Convert.ToDecimal(item.FCreateOrgId),
            UseOrg = Convert.ToDecimal(item.FUseOrgId),
            LossPercent = item.FLOSSPERCENT,
            MnemonicCode = item.FMnemonicCode,
            ExpPeriod = item.FExpPeriod,
            ColorName = item.FColor,
            CreateDate = DateTime.Now,
            Company = "1000",
            Factory = "1000"

 MES.Service/service/BasicData/MesPositionManager.cs

@@ -102,15 +102,9 @@
            PositionDescription = position.FDESCRIPTIONS,
            Department = position.FDept,
            Fforbidstatus = position.FForbidStatus,
            CreationDate = position.FCreateDate != null
                ? DateTime.ParseExact(position.FCreateDate,
                    "yyyy-MM-dd HH:mm:ss", null)
                : null,
            CreationDate = DateTime.Now,
            DisabledBy = position.FForbidderId,
            DisabledDate = position.FForbidDate != null
                ? DateTime.ParseExact(position.FForbidDate,
                    "yyyy-MM-dd HH:mm:ss", null)
                : null
            DisabledDate = position.FForbidDate != null? DateTime.ParseExact(position.FForbidDate, "yyyy-MM-dd HH:mm:ss", null) : null
        };
    }


 MES.Service/service/BasicData/MesRohInManager.cs

@@ -14,8 +14,7 @@
    {
        var rohInErpRohIn = rohIn.ErpRohIn;
        var mesRohIn = GetMesRohIn(rohInErpRohIn);
        var mesRohInDatas =
            GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);
        var mesRohInDatas = GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type);

        return UseTransaction(db =>
        {
@@ -30,6 +29,8 @@
                    return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0;
                case "2":
                case "4":
                case "5":
                case "B":
                    return SaveOrUpdateData(db, mesRohIn, mesRohInDatas)
                        ? 1
                        : 0;
@@ -135,25 +136,17 @@
        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.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;

@@ -163,11 +156,6 @@
                    "yyyy-MM-dd HH:mm:ss", null);

        mesRohIn.CreateBy = rohIn.FCreatorId;

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

        mesRohIn.LastupdateBy = rohIn.FModifierId;

        if (rohIn.FModifyDate != null)
@@ -176,7 +164,9 @@

        mesRohIn.ErpCheckBy = rohIn.FApproverId;
        mesRohIn.ErpCheckDate = rohIn.FApproveDate;
        mesRohIn.Changereason = rohIn.FCHANGEREASON;
        mesRohIn.Changereason = rohIn.FChangeReason;
        mesRohIn.CreateDate = DateTime.Now;
        mesRohIn.ReceiveOrg = Convert.ToDecimal(rohIn.FReceiveOrgId);

        return mesRohIn;
    }
@@ -192,7 +182,9 @@
                EbelnK3id = Convert.ToDecimal(s.id),
                ErpId = Convert.ToDecimal(s.Eid),
                BillNo = s.FBillNo,
                SalesOrderId = s.F_UNW_Text_xsddh,
                OrderLineId=s.FSeq,
                PurchaseOrderLineNumber = s.FSeq,
                SalesOrderId = s.FXSHTH,
                ItemId = s.FMaterialId,
                PurchaseUnit = s.FUnitId,
                PurchaseQty = Convert.ToDecimal(s.FQty),
@@ -212,10 +204,10 @@
                        "yyyy-MM-dd HH:mm:ss", null)
                    : null,
                IsGift = s.FGiveAway,
                Remarks = s.FEntryNote,
                Remarks = s.FNote,
                SupplierItemCode = s.FSupMatId,
                SupplierItemName = s.FSupMatName,
                OutsourcingOrderId = s.FSUBREQBILLNO,
                OutsourcingOrderId = s.FSubreqBillNo,
                BatchNumber = s.FLot,
                BusinessClose = s.FMRPCloseStatus,
                BusinessFreeze = s.FMRPFreezeStatus,
@@ -230,26 +222,29 @@
                    ? 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),
                TotalReceivedQty = Convert.ToDecimal(s.FQty)-Convert.ToDecimal(s.FRemainReceiveQty),
                RemainingReceivedQty = Convert.ToDecimal(s.FRemainReceiveQty),
                TotalStoredQty = Convert.ToDecimal(s.FQty) - Convert.ToDecimal(s.FRemainStockINQty),
                RemainingStoredQty = Convert.ToDecimal(s.FRemainStockINQty),
                TotalReturnedQty = Convert.ToDecimal(s.FMrbQty),
                ReturnableReceivedQty = Convert.ToDecimal(s.FCHECKRETQTY),
                ReturnableStoredQty = Convert.ToDecimal(s.FSTOCKRETQTY),
                ReturnableReceivedQty = Convert.ToDecimal(s.FBaseCheckRetQty),
                ReturnableStoredQty = Convert.ToDecimal(s.FBaseStockRetQty),
                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
                DemandSource = s.FDemandType,
                DemandDocumentId = s.FDemandBillNo,
                DemandDocumentLineId = s.FDemandBillEntrySeq,
                Demand = s.FRequireOrgId,
                DemandOrg = s.FRequireOrgId,
                Receiving = s.FReceiveOrgId,
                ReceivingOrg = s.FReceiveOrgId,
                Settlement = s.FEntrySettleOrgId,
                SettlementOrg = s.FEntrySettleOrgId,
                DemandDept = s.FRequireDeptId,
                ReceivingDept = s.FReceiveDeptId
            };

            var single = rohInDataManager.GetSingle(it =>

 MES.Service/service/BasicData/MesStaffManager.cs

@@ -114,9 +114,12 @@
            Id = Convert.ToDecimal(staff.Id),
            StaffNo = staff.FStaffNumber,
            StaffName = staff.FName,
            DepartmentName = staff.FPostDept,
            PositionName = staff.FPost,
            DepartmentNo = staff.FPostDept,
            PositionCode = staff.FPost,
            PhoneNumber = staff.FMobile,
            CreateOrg = Convert.ToDecimal(staff.FCreateOrgId),
            UseOrg = Convert.ToDecimal(staff.FUseOrgId),
            CreateDate = DateTime.Now,
            Remark = staff.FDescription,
            FforbidStatus = staff.FForbidStatus
        };
@@ -137,11 +140,14 @@
            Fcode = staff.FStaffNumber,
            Fname = staff.FName,
            Fpassword = "8+()./,", // åˆå§‹å¯†ç 
            Fsystem = "上格",
            Fsystem = "泰莱姆",
            Lever = 0,
            Fcompany = "1000",
            Ffactory = "1000",
            DelFlag = 0,
            Dev=0,
            Tet=0,
            Prd=1,
            Ismanager = 0,
            Isacq = 0,
            ExpField9 = "1020",
@@ -149,7 +155,10 @@
            Status = 0,
            Isdeparture = 0,
            CheckFlag = 0,
            ExpFiel12 = 0
            ExpFiel12 = 0,
            FirstLogin = 0,
            CreateDate = DateTime.Now,
            PswEditTime = DateTime.Now
        };
    }


 MES.Service/service/BasicData/MesSupplierManager.cs

@@ -123,10 +123,14 @@
            SuppNo = supplier.FNumber,
            SuppSname = supplier.FShortName,
            SuppName = supplier.FName,
            Lxr = supplier.F_UNW_LXR,
            Telf1 = supplier.F_UNW_LXRDH,
            Lxr = supplier.FContact,
            Telf1 = supplier.FTel,
            Fstaffid = supplier.FStaffId,
            Fforbidstatus = supplier.FForbidStatus,
            CreateDate = DateTime.Now,
            CreateOrg= Convert.ToDecimal(supplier.FCreateOrgId),
            UseOrg= Convert.ToDecimal(supplier.FUseOrgId),
            Remark=supplier.FDescription,
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/BasicData/MesUnitManager.cs

@@ -131,6 +131,7 @@
            Fprecision = unit.FPrecision,
            Fdescription = unit.FDescription,
            Fforbidstatus = unit.FForbidStatus,
            CreateDate = DateTime.Now,
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/BasicData/OrganizeManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,259 @@
using SqlSugar;
using System;
using System.Collections.Generic;
using MES.Service.DB;
using MES.Service.Modes;
using MES.Service.Dto.webApi;
using System.Xml.Linq;

namespace MES.Service.service
{
public class OrganizeManager : Repository<Organize>
{

        //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

        //这里面写的代码不会给覆盖,如果要重新生成请删除 OrganizeManager.cs
        public bool Save(ErpOrganize item)
        {
            var entity = GetOrganize(item);

            return UseTransaction(db =>
            {
                switch (item.Type)
                {
                    case "0":
                        if (UpdateOrganizetatus(db, entity.Id, "A"))
                            return 1;
                        break;
                    case "1":
                        if (UpdateOrganizetatus(db, entity.Id, "B"))
                            return 1;
                        break;
                    case "2":
                        if (InsertItem(db, entity))
                            return 1;
                        break;
                    case "3":
                        if (DeleteItem(db, Convert.ToDecimal(entity.Id)))
                            return 1;
                        break;
                    case "4":
                        if (InsertOrUpdate(db, entity))
                            return 1;
                        break;
                    default:
                        throw new ArgumentNullException(
                            $"type没有{item.Type}这个类型的参数");
                }

                throw new NotImplementedException("操作失败");
            }) > 0;
        }

        public bool SaveList(List<ErpOrganize> Organize)
        {
            var list = Organize.Select(GetOrganize).ToList();
            var groupBy = list.GroupBy(s => s.Type)
                .ToDictionary(g => g.Key, g => g.ToList());

            return UseTransaction(db =>
            {
                foreach (var itemGroup in groupBy)
                    switch (itemGroup.Key)
                    {
                        case "0":
                            if (!UpdateOrganizetatusBatch(db, itemGroup.Value, "A"))
                                throw new NotImplementedException("启用失败");
                            break;
                        case "1":
                            if (!UpdateOrganizetatusBatch(db, itemGroup.Value, "B"))
                                throw new NotImplementedException("禁用失败");
                            break;
                        case "2":
                            if (!InsertItemBatch(db, itemGroup.Value))
                                throw new NotImplementedException("插入失败");
                            break;
                        case "3":
                            if (!DeleteItemBatch(db, itemGroup.Value))
                                throw new NotImplementedException("删除失败");
                            break;
                        case "4":
                            if (!InsertOrUpdateBatch(db, itemGroup.Value))
                                throw new NotImplementedException("同步失败");
                            break;
                        default:
                            throw new ArgumentNullException(
                                $"type没有{itemGroup.Key}这个类型的参数");
                    }

                return 1;
            }) > 0;
        }

        private bool UpdateOrganizetatus(SqlSugarScope db, decimal itemId,
            string status)
        {
            var result = db.Updateable<Organize>()
                .SetColumns(s => s.Fforbidstatus == status)
                .Where(s => s.Id == itemId).ExecuteCommand();

            if (result > 0)
                return true;

            throw new NotImplementedException(status == "A" ? "启用失败" : "禁用失败");
        }

        private bool InsertItem(SqlSugarScope db, Organize entity)
        {
            var insert = db.Insertable(entity).ExecuteCommand();
            if (insert > 0)
                return true;

            throw new NotImplementedException("插入失败");
        }

        private bool DeleteItem(SqlSugarScope db, decimal itemId)
        {
            var deleteById = db.Deleteable<Organize>().In(itemId).ExecuteCommand();
            if (deleteById > 0)
                return true;

            throw new NotImplementedException("删除失败");
        }

        private Organize GetOrganize(ErpOrganize Organize)
        {
            return new Organize
            {

                Id = Convert.ToDecimal(Organize.Id),
                Fnumber = Organize.FNumber,
                Fname = Organize.FName,
                Fforbidstatus = Organize.FForbidStatus,
                Type = Organize.Type,
                Fparentid=Organize.FParentID,
                Fcreatedate=DateTime.Now
            };
        }

        private bool UpdateOrganizetatusBatch(SqlSugarScope db,
            List<Organize> itemList, string status)
        {
            var ids = itemList.Select(it => it.Id).ToArray();
            var result = db.Updateable<Organize>()
                .SetColumns(s => s.Fforbidstatus == status)
                .Where(s => ids.Contains(s.Id)).ExecuteCommand();

            if (result > 0)
                return true;

            throw new NotImplementedException(status == "A" ? "启用失败" : "禁用失败");
        }

        private bool InsertItemBatch(SqlSugarScope db, List<Organize> itemList)
        {
            var insertRange = db.Insertable(itemList).ExecuteCommand();
            if (insertRange > 0)
                return true;

            throw new NotImplementedException("插入失败");
        }

        private bool DeleteItemBatch(SqlSugarScope db, List<Organize> itemList)
        {
            var ids = itemList.Select(it => it.Id).ToArray();
            var deleteByIds = db.Deleteable<Organize>().In(ids).ExecuteCommand();
            if (deleteByIds > 0)
                return true;

            throw new NotImplementedException("删除失败");
        }

        private bool InsertOrUpdate(SqlSugarScope db, Organize entity)
        {
            var exists = db.Queryable<Organize>().Any(e => e.Id == entity.Id);
            if (exists)
            {
                var update = db.Updateable(entity).ExecuteCommand();
                if (update > 0)
                    return true;
            }
            else
            {
                var insert = db.Insertable(entity).ExecuteCommand();
                if (insert > 0)
                    return true;
            }

            return false;
        }

        private bool InsertOrUpdateBatch(SqlSugarScope db, List<Organize> itemList)
        {
            foreach (var entity in itemList)
                if (!InsertOrUpdate(db, entity))
                    return false;

            return true;
        }
        #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(), OrderByType.Asc);// åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        Console.Write(p.TotalCount);//返回总数
     
        List<IConditionalModel> conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel() { FieldName= typeof(Organize).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc);

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

 

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



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



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

 MES.Service/service/BasicData/SysDepartmentManager.cs

@@ -117,6 +117,10 @@
            Depextr2 = department.FGroup,
            Depextr3 = department.FWIPStockID,
            Depextr4 = department.FForbidStatus,
            CreateDate = DateTime.Now,
            CreateOrg = Convert.ToDecimal(department.FCreateOrgId),
            UseOrg = Convert.ToDecimal(department.FUseOrgId),
            ParentId = Convert.ToDecimal(department.FParentID),
            Company = "1000",
            Factory = "1000"
        };

 MES.Service/service/WomcaaManager.cs

@@ -1,7 +1,9 @@
using MES.Service.DB;
using Dm;
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
using System.Net.NetworkInformation;

namespace MES.Service.service;

@@ -32,8 +34,10 @@
            {
                case "3":
                    return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                case "1":
                case "2":
                case "4":
                case "5":
                    return SaveOrUpdateData(db, mesWomcaa, mesWomcabs)
                        ? 1
                        : 0;
@@ -44,14 +48,12 @@
        }) > 0;
    }

    private bool SaveOrUpdateData(SqlSugarScope db, Womcaa mesWomcaa,
        List<Womcab> mesWomcabs)
    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();
            db.Deleteable<Womcab>().Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand();

        var orUpdate = base.Insert(mesWomcaa);
        var baOrUpdate = _womcabManager.InsertRange(mesWomcabs);
@@ -59,14 +61,11 @@
        throw new NotImplementedException("插入或更新失败");
    }

    private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,
        List<Womcab> mesWomcabs)
    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;
        var insertOrUpdate = db.Deleteable<Womcab>().In(decimals).ExecuteCommand() > 0;

        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("更新失败");
@@ -74,47 +73,73 @@

    private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
    {
        string jabs="0";

        var entity = new Womcaa
        {
            Erpid = Convert.ToDecimal(dto.Id),
            Caa001 = dto.FBillNo,
            Caa021 = dto.FWorkShopID0,
            Caa004 = dto.FBillType,
            Caa005 = dto.FConveyDate,
            Caa006 = dto.FMaterialId,
            Caa009 = dto.FUnitId,
            Caa010 = dto.FPlanStartDate,
            Caa011 = dto.FPlanFinishDate,
            Caa012 = Convert.ToDecimal(dto.FQty),
            Caa013 = dto.FBomId,
            Caa015 = dto.FXSHTH,
            Caa015Head = dto.FSaleOrderEntrySeq,
            Caa016 = dto.FDescription,
            Caa017 = 0,
            Caa018 = Convert.ToDecimal(dto.PLAN_ID),
            Caa019 = dto.PLAN_SEQ,
            Caa020 = dto.PLAN_NUM,
            Caa021 = dto.FWorkShopID,
            Fstatus = 0,
            Caa022 = Convert.ToDecimal(dto.FQty),
            Caa023 = dto.FStatus,
            Caa024 = 0,
            RoutingId = dto.FRoutingId,
            WorkShopId = dto.FREMWorkShopId,
            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,
            SaleOrderNo = dto.FXSHTH,
            SaleOrderEntryseq = dto.FSaleOrderEntrySeq,
            ForceCloserid = dto.FForceCloserId,
            CloseType = dto.FCloseType,
            SrcSplitBillno = dto.FSrcSplitBillNo,
            Caa016 = dto.FMemoItem,
            Caa018 = Convert.ToDecimal(dto.planId),
            Caa019 = Convert.ToDecimal(dto.planSeq),
            Caa020 = dto.planNum
            F_ZSXG_KH = dto.F_ZSXG_KH,
            F_ZJXF_YHRQ = dto.F_ZJXF_YHRQ,
            PrdOrg = dto.erP_SCZZ,
            TrustOrg = dto.erP_WTZZ,
            TbTime = DateTime.Now,
            JaBs = "0"
        };

        if (dto.Type == "5")
        {
            entity.IsXg = 1;
        }
        else
        {
            entity.IsXg = 0;
        }

        if (dto.FStatus == "6" || dto.FStatus == "7")
        {
            entity.JaBs = "1";
            entity.JaTime = DateTime.Now;
        }

        var single = base.GetSingle(it => it.Erpid == entity.Erpid);
        if (single != null) entity.Id = single.Id;
@@ -130,34 +155,32 @@
        {
            var womcab = new Womcab
            {
                Erpid = Convert.ToDecimal(dto.ID),
                Erpid = Convert.ToDecimal(dto.FENTRYID),
                Cab001 = dto.FBillNo,
                Cab002 = dto.FSeq,
                Cab003 = dto.FMaterialID2,
                Cab006 = !string.IsNullOrEmpty(dto.FNeedQty2)
                    ? Convert.ToDecimal(dto.FNeedQty2)
                    : null,
                Cab007 = !string.IsNullOrEmpty(dto.FPickedQty)
                    ? Convert.ToDecimal(dto.FPickedQty)
                    : null,
                Cab003 = dto.FMaterialID,
                Cab006 = Convert.ToDecimal(dto.FNeedQty),
                Cab007 = Convert.ToDecimal(dto.FPickedQty),
                Cab009 = dto.FUnitID,
                Cab012 = Convert.ToDecimal(dto.FStdQty),
                Cab014 = dto.FIsKeyItem,
                Pid = Convert.ToDecimal(dto.FID),
                Eid = Convert.ToDecimal(dto.FID),
                PositionNo = dto.FPositionNO,
                IssuingOrganization=dto.FSupplyOrg,
                SupplyOrganization=dto.FChildSupplyOrgId,
                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),
                Numerator = Convert.ToDecimal(dto.FNumerator),
                Denominator = Convert.ToDecimal(dto.FDenominator),
                SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty),
                SCRAPRATE = Convert.ToDecimal(dto.FScrapRate)
                SCRAPRATE = Convert.ToDecimal(dto.FScrapRate),
                SalesOrder=dto.FXSHTBH,
                F_ZJXF_YHRQ=dto.F_ZJXF_YHRQ
            };

            var entity = Db.Queryable<Womcab>()

 MES.Service/service/WomcaaWWManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,200 @@
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
using System;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace MES.Service.service;

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

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

    private readonly WomcabManager _womcabWWManager = new();
    private decimal?[] decimals;
    private bool update;
    private bool insertOrUpdate;

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

    public bool SaveWw(ErpWOM wom)
    {
        var womErpCaa = wom.ErpCaa;
        var mesWomcaa = MapErpCAAtoWomcaaWw(womErpCaa);
        var mesWomcabs = MapErpCABtoWomcabWw(wom.ErpCabs);

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

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

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

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

    private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,List<Womcab> mesWomcabs)
    {
        if (mesWomcaa.Id != null)
        {
            decimals = mesWomcabs.Select(s => s.Id).ToArray();
            update = base.DeleteById(mesWomcaa.Id);
            insertOrUpdate = db.Deleteable<Womcab>().In(decimals).ExecuteCommand() > 0;
        }
        else
        {
            update = true;
            insertOrUpdate = true;
        }
        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("更新失败");
    }

    private Womcaa MapErpCAAtoWomcaaWw(ErpCAA dto)
    {
        var entity = new Womcaa
        {
            Erpid = Convert.ToDecimal(dto.Id),
            Caa001 = dto.FBillNo,
            Caa004 = dto.FBillType,
            Caa005 = dto.FConveyDate,
            Caa006 = dto.FMaterialId,
            Caa009 = dto.FUnitId,
            Caa010 = dto.FPlanStartDate,
            Caa011 = dto.FPlanFinishDate,
            Caa012 = Convert.ToDecimal(dto.FQty),
            Caa013 = dto.FBomId,
            Caa015 = dto.FXSHTH,
            Caa016 = dto.FDescription,
            Caa017 = 0,
            Caa018 = Convert.ToDecimal(dto.PLAN_ID),
            Caa019 = dto.PLAN_SEQ,
            Caa020 = dto.PLAN_NUM,
            Caa021 = dto.FWorkShopID,
            Fstatus = 0,
            Caa022 = Convert.ToDecimal(dto.FQty),
            Caa023 = dto.FStatus,
            Caa024 = 0,
            RoutingId = dto.FRoutingId,
            WorkShopId = dto.FREMWorkShopId,
            DepotCode = dto.FStockId,
            CreateDate = dto.FDate,
            WorkGroupId = dto.FWorkGroupId,
            PlanId = dto.FPlannerID,
            StockInlimith = dto.FStockInLimitH,
            StockInlimitl = dto.FStockInLimitL,
            Mtono = dto.FMTONO,
            Lot = dto.FLot,
            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,
            F_ZSXG_KH = dto.F_ZJXF_BASE_KH,
            F_ZJXF_YHRQ = dto.F_ZJXF_DATETIME_YHRQ,
            PrdOrg = dto.erP_SCZZ,
            TrustOrg = dto.erP_WTZZ,
            TbTime = DateTime.Now,
            JaBs = "0",
            FPURORDERNO = dto.FPurOrderNo,
            FPURORDERENTRYSEQ = Convert.ToDecimal(dto.FPurOrderEntrySeq),
            FSUBENTRYID = Convert.ToDecimal(dto.fsubentryid),
            FSTOCKINQTY = Convert.ToDecimal(dto.Caa024),
            FNOSTOCKINQTY = Convert.ToDecimal(dto.Caa025)
        };
        if (dto.Type == "5")
        {
            entity.IsXg = 1;
        }
        else
        {
            entity.IsXg = 0;
        }

        if (dto.FStatus == "6" || dto.FStatus == "7")
        {
            entity.JaBs = "1";
            entity.JaTime = DateTime.Now;
        }

        var single = base.GetSingle(it => it.Erpid == entity.Erpid);
        if (single != null) entity.Id = single.Id;

        return entity;
    }

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

        foreach (var dto in dtoList)
        {
            var womcab = new Womcab
            {
                Erpid = Convert.ToDecimal(dto.FENTRYID),
                Cab001 = dto.FBillNo,
                Cab002 = dto.FSeq,
                Cab003 = dto.FMaterialID,
                Cab006 = Convert.ToDecimal(dto.FNeedQty),
                Cab007 = Convert.ToDecimal(dto.FPickedQty),
                Cab009 = dto.FUnitID,
                Cab014 = dto.FIsKeyItem,
                Pid = Convert.ToDecimal(dto.FID),
                Eid = Convert.ToDecimal(dto.FID),
                PositionNo = dto.FPositionNO,
                IssuingOrganization = dto.FSupplyOrg,
                SupplyOrganization = dto.FChildSupplyOrgId,
                OwnerId = dto.FOwnerID,
                Mtono = dto.FMTONO,
                Lot = dto.FLot,
                DepotCode = dto.FStockID,
                IssueType = dto.FIssueType,
                SupplyType = dto.FSupplyType,
                Numerator = Convert.ToDecimal(dto.FNumerator),
                Denominator = Convert.ToDecimal(dto.FDenominator),
                SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty),
                SCRAPRATE = Convert.ToDecimal(dto.FScrapRate),
                SalesOrder = dto.FXSHTBH,
            };

            var entity = Db.Queryable<Womcab>().Where(s => s.Erpid == womcab.Erpid).Single();
            if (entity != null) womcab.Id = entity.Id;

            womcabList.Add(womcab);
        }

        return womcabList;
    }
}

 MESApplication/Controllers/BasicData/MesDeliveryNoteBarcodeController.cs

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

namespace MESApplication.Controllers.BasicData;

[ApiController]
[Route("api/DeliveryBarcode")]
public class MesDeliveryNoteBarcodeController : ControllerBase
{
    private readonly MessageCenterManager _manager = new();
    private readonly MesDeliveryNoteBarcodeManager m = new();

    private readonly string METHOD = "POST";

    private readonly string TableName = "MES_DELIVERY_NOTE_BARCODE";

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

    [HttpPost("Save")]
    public ResponseResult Save(ErpBarcode barcode)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "Save";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(barcode);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.Save(barcode);
            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<ErpBarcode> barcodes)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "SaveList";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(barcodes);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.SaveList(barcodes);
            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] MesDeliveryNoteBarcode 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] MesDeliveryNoteBarcode 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] MesDeliveryNoteBarcode 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/BasicData/MesDeliveryNoteController.cs

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

namespace MESApplication.Controllers.BasicData;

[ApiController]
[Route("api/DeliveryNote")]
public class MesDeliveryNoteController : ControllerBase
{
    private readonly MessageCenterManager _manager = new();
    private readonly MesDeliveryNoteManager m = new();

    private readonly string METHOD = "POST";

    private readonly string TableName = "MES_DELIVERY_NOTE";

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

    [HttpPost("Save")]
    public ResponseResult Save(Delivery delivery)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "Save";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(delivery);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.Save(delivery);
            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<Delivery> deliveries)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "SaveList";
        entity.Method = METHOD;
        entity.Data = JsonConvert.SerializeObject(deliveries);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.SaveList(deliveries);
            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] MesDeliveryNote 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] MesDeliveryNote 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] MesDeliveryNote 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/BasicData/MesDeliveryNoteDetails.cs

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

namespace MESApplication.Controllers.BasicData;

[ApiController]
[Route("api/[controller]")]
public class MesDeliveryNoteDetailsController : ControllerBase
{
    private readonly MesDeliveryDetailsManager 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] MesDeliveryNoteDetails 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] MesDeliveryNoteDetails 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] MesDeliveryNoteDetails 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/BasicData/OrganizeController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,266 @@
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Dynamic;
using MES.Service.Modes;
using MES.Service.service;
using MES.Service.util;
using MES.Service.Dto.webApi;
using MES.Service.service.BasicData;
using Newtonsoft.Json;

namespace MESApplication.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class OrganizeController : ControllerBase
    {
        private readonly MessageCenterManager _manager = new();

        private readonly OrganizeManager m = new();

        private readonly string METHOD = "POST";

        private readonly string TableName = "Organize";

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

        [HttpPost("Save")]
        public ResponseResult Save(ErpOrganize unit)
        {
            var entity = new MessageCenter();
            entity.TableName = TableName;
            entity.Url = URL + "Save";
            entity.Method = METHOD;
            entity.Data = JsonConvert.SerializeObject(unit);
            entity.Status = 1;
            entity.CreateBy = "PL017";
            try
            {
                dynamic resultInfos = new ExpandoObject();
                var save = m.Save(unit);
                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<ErpOrganize> 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);
            }
        }
      //  private OrganizeManager m = new OrganizeManager();


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

        /// <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] Organize 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] Organize 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] Organize 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/WomcaaController.cs

@@ -40,13 +40,9 @@
            resultInfos.tbBillList = save;

            entity.Result = 0;
            entity.DealWith = 0;
            if (save)
            {
                entity.Result = 1;
                entity.DealWith = 1;
            }

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

            return new ResponseResult

 MESApplication/Controllers/WomcaaWWController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,261 @@

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 WomcaaWWController : ControllerBase
{
    private readonly MessageCenterManager _manager = new();
    private readonly WomcaaWWManager m = new();

    private readonly string METHOD = "POST";

    private readonly string TableName = "WOMCAA";

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

    //
    [HttpPost("Save")]
    public ResponseResult SaveWw(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.SaveWw(rohIn);

            resultInfos.tbBillList = save;

            entity.Result = 0;
            entity.DealWith = 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/MESApplication.csproj.user

@@ -5,6 +5,6 @@
  </PropertyGroup>
  <PropertyGroup>
    <ActiveDebugProfile>IIS Express</ActiveDebugProfile>
    <NameOfLastUsedPublishProfile>D:\Tools\StandardPda\MESApplication\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>E:\Tool\LTS\PDA_NEW\StandardPda\MESApplication\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
  </PropertyGroup>
</Project>

 MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user

@@ -4,8 +4,8 @@
-->
<Project>
  <PropertyGroup>
    <_PublishTargetUrl>D:\Tools\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl>
    <History>True|2024-08-20T09:12:00.2924570Z||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;True|2024-01-17T14:22:04.2552286+08:00||;True|2024-01-16T16:54:42.2316892+08:00||;True|2024-01-16T16:37:23.8028858+08:00||;True|2024-01-16T09:25:24.4007775+08:00||;True|2024-01-15T10:18:57.3362616+08:00||;True|2024-01-15T10:07:14.2044763+08:00||;True|2024-01-10T14:03:36.4451130+08:00||;True|2024-01-09T16:45:32.9601815+08:00||;True|2024-01-06T14:16:34.2732220+08:00||;True|2024-01-06T14:11:45.2134717+08:00||;True|2024-01-06T11:30:58.9198887+08:00||;</History>
    <_PublishTargetUrl>E:\Tool\LTS\PDA_NEW\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl>
    <History>True|2024-12-28T01:06:17.0669698Z||;True|2024-12-26T14:45:42.2002555+08:00||;True|2024-12-26T13:03:07.9325085+08:00||;True|2024-12-26T11:43:04.0852484+08:00||;True|2024-12-21T22:33:39.6121285+08:00||;True|2024-12-16T14:40:36.9800141+08:00||;True|2024-12-14T16:23:42.9536129+08:00||;True|2024-12-11T15:50:13.8959852+08:00||;True|2024-12-11T10:47:42.1561088+08:00||;True|2024-12-08T18:32:27.3909077+08:00||;True|2024-12-06T16:30:29.0031886+08:00||;True|2024-12-05T16:20:00.9907217+08:00||;True|2024-12-05T16:19:41.4441561+08:00||;True|2024-12-05T16:19:22.9404769+08:00||;True|2024-12-05T11:07:30.6547548+08:00||;True|2024-12-03T17:12:24.9349522+08:00||;True|2024-11-27T11:05:24.9761937+08:00||;True|2024-11-19T08:57:10.9008301+08:00||;True|2024-11-18T21:02:57.0481324+08:00||;True|2024-11-05T17:25:48.6360448+08:00||;True|2024-11-05T17:16:08.2144948+08:00||;True|2024-10-28T11:56:24.2694762+08:00||;True|2024-10-28T11:40:56.4512491+08:00||;True|2024-10-28T11:28:42.4509497+08:00||;True|2024-10-28T11:11:11.1286907+08:00||;True|2024-10-28T10:09:42.4378313+08:00||;True|2024-10-28T09:57:51.0792947+08:00||;True|2024-10-23T17:07:23.7741858+08:00||;True|2024-10-22T14:34:55.4526970+08:00||;True|2024-10-17T16:37:53.4763504+08:00||;True|2024-10-13T14:04:45.3666662+08:00||;True|2024-10-13T12:30:16.7294894+08:00||;True|2024-10-13T12:22:13.5740642+08:00||;True|2024-09-26T17:43:56.9592414+08:00||;True|2024-09-25T09:56:59.0722612+08:00||;True|2024-09-20T16:35:40.9416105+08:00||;True|2024-09-13T15:42:08.2824743+08:00||;True|2024-08-20T17:12:00.2924570+08:00||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;True|2024-01-17T14:22:04.2552286+08:00||;True|2024-01-16T16:54:42.2316892+08:00||;True|2024-01-16T16:37:23.8028858+08:00||;True|2024-01-16T09:25:24.4007775+08:00||;True|2024-01-15T10:18:57.3362616+08:00||;True|2024-01-15T10:07:14.2044763+08:00||;True|2024-01-10T14:03:36.4451130+08:00||;True|2024-01-09T16:45:32.9601815+08:00||;True|2024-01-06T14:16:34.2732220+08:00||;True|2024-01-06T14:11:45.2134717+08:00||;True|2024-01-06T11:30:58.9198887+08:00||;</History>
    <LastFailureDetails />
  </PropertyGroup>
</Project>

 MESApplication/appsettings.json

@@ -10,6 +10,6 @@
  "AppSettings": {
    "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
    "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = tlm_dev; Password=tlmdev"
  }
}

 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.deps.json

@@ -1412,7 +1412,10 @@
          "SqlSugarCore": "5.1.4.158"
        },
        "runtime": {
          "MES.Service.dll": {}
          "MES.Service.dll": {
            "assemblyVersion": "1.0.0",
            "fileVersion": "1.0.0.0"
          }
        }
      }
    }

 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/Debug/net8.0/MESApplication.staticwebassets.endpoints.json

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
{
  "Version": 1,
  "ManifestType": "Build",
  "Endpoints": []
}

 MESApplication/bin/Debug/net8.0/MESApplication.xml

@@ -102,6 +102,114 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Add(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Update(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Add(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Update(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Add(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Update(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDepotsController.GetList">
            <summary>
                èŽ·å–所有
@@ -675,6 +783,42 @@
        <member name="M:MESApplication.Controllers.BasicData.SysDepartmentController.Update(MES.Service.Modes.SysDepartment)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetList">
            <summary>
            èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetById(System.Int32)">
            <summary>
            æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.DeleteByIds(System.Object[])">
            <summary>
            æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Add(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ  
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.InsertReturnIdentity(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Update(MES.Service.Modes.Organize)">
            <summary>
            ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
@@ -1393,6 +1537,42 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Add(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.InsertReturnIdentity(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Update(MES.Service.Modes.Womcaa)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcabController.GetList">
            <summary>
                èŽ·å–所有

 MESApplication/bin/Debug/net8.0/appsettings.json

@@ -10,6 +10,6 @@
  "AppSettings": {
    "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
    "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = tlm_dev; Password=tlmdev"
  }
}

 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/MESApplication.staticwebassets.endpoints.json

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
{
  "Version": 1,
  "ManifestType": "Build",
  "Endpoints": []
}

 MESApplication/bin/Release/net8.0/MESApplication.xml

@@ -102,6 +102,114 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Add(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Update(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Add(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Update(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Add(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Update(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDepotsController.GetList">
            <summary>
                èŽ·å–所有
@@ -675,6 +783,42 @@
        <member name="M:MESApplication.Controllers.BasicData.SysDepartmentController.Update(MES.Service.Modes.SysDepartment)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetList">
            <summary>
            èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetById(System.Int32)">
            <summary>
            æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.DeleteByIds(System.Object[])">
            <summary>
            æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Add(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ  
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.InsertReturnIdentity(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Update(MES.Service.Modes.Organize)">
            <summary>
            ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
@@ -1393,6 +1537,42 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Add(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.InsertReturnIdentity(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Update(MES.Service.Modes.Womcaa)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcabController.GetList">
            <summary>
                èŽ·å–所有

 MESApplication/bin/Release/net8.0/appsettings.json

@@ -10,6 +10,6 @@
  "AppSettings": {
    "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
    "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = tlm_dev; Password=tlmdev"
  }
}

 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.deps.json

@@ -1160,7 +1160,10 @@
          "SqlSugarCore": "5.1.4.158"
        },
        "runtime": {
          "MES.Service.dll": {}
          "MES.Service.dll": {
            "assemblyVersion": "1.0.0",
            "fileVersion": "1.0.0.0"
          }
        }
      }
    }

 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

 MESApplication/bin/Release/net8.0/publish/MESApplication.staticwebassets.endpoints.json

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
{
  "Version": 1,
  "ManifestType": "Publish",
  "Endpoints": []
}

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

@@ -102,6 +102,114 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Add(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteBarcodeController.Update(MES.Service.Modes.MesDeliveryNoteBarcode)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Add(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteController.Update(MES.Service.Modes.MesDeliveryNote)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Add(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.InsertReturnIdentity(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDeliveryNoteDetailsController.Update(MES.Service.Modes.MesDeliveryNoteDetails)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.MesDepotsController.GetList">
            <summary>
                èŽ·å–所有
@@ -675,6 +783,42 @@
        <member name="M:MESApplication.Controllers.BasicData.SysDepartmentController.Update(MES.Service.Modes.SysDepartment)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetList">
            <summary>
            èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.GetById(System.Int32)">
            <summary>
            æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.DeleteByIds(System.Object[])">
            <summary>
            æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Add(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ  
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.InsertReturnIdentity(MES.Service.Modes.Organize)">
            <summary>
            æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.OrganizeController.Update(MES.Service.Modes.Organize)">
            <summary>
            ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
@@ -1393,6 +1537,42 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Add(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.InsertReturnIdentity(MES.Service.Modes.Womcaa)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcaaWWController.Update(MES.Service.Modes.Womcaa)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.WomcabController.GetList">
            <summary>
                èŽ·å–所有

 MESApplication/bin/Release/net8.0/publish/appsettings.json

@@ -10,6 +10,6 @@
  "AppSettings": {
    "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
    "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = tlm_dev; Password=tlmdev"
  }
}

 MESApplication/bin/Release/net8.0/publish/web.config

@@ -8,4 +8,5 @@
      <aspNetCore processPath="dotnet" arguments=".\MESApplication.dll" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout" hostingModel="inprocess" />
    </system.webServer>
  </location>
</configuration>
</configuration>
<!--ProjectGuid: C0B360C5-E8CC-4BC3-AAA5-3F03A2D6C0AA-->