销售订单

crz

2025-03-01 47f6ab7374c3f88ba364ea82021dd296f4bdf9e6

销售订单

 MES.Service/Dto/webApi/ErpDETAIL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,28 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.Dto.webApi
{
    public class ErpDETAIL
    {
        public string ? F_UNW_Text_xsddh { get; set; }
        public string? LineNumber { get; set; }
        public string ?  FMaterialId { get; set;}
        public string ? FMaterialName { get; set;}
        public string ? FMaterialModel { get; set;}
        public string ? FMinPlanDeliveryDate { get; set;}
        public string ? FQty { get; set;}
        public string ? FUnitID { get; set;}
        public string ? FPrice { get; set;}
        public string ? FAmount { get; set;}
        public string ? FDeliCommitQty { get; set;}
        public string ? FEntryNote { get; set;}




    }
}

 MES.Service/Dto/webApi/ErpORDER.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
namespace MES.Service.Dto.webApi
{
    public class ErpORDER
    {
        public string ? FBillNo { get; set; }

        public string? Type { get; set; }
        public string ? FBillTypeID { get; set; }
        public string ? F_UNW_Date_KHXQ { get; set; }
        public string ? FVersionNo { get; set; }
        public string ? FDate { get; set; }
        public string ? FCustId { get; set; }
        public string ? F_UNW_Text_KHDD { get; set; }
        public string ? FSaleDeptId { get; set; }
        public string ? FNote { get; set; }
        public string ? F_UNW_LargeText_TBKHBZ { get; set; }
        public string ? FApproveDate { get; set; }
        public string ? FApproverId { get; set; }
    

    }
}

 MES.Service/Dto/webApi/ErpSales.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
namespace MES.Service.Dto.webApi
{
    public class ErpSales
    {
        public ErpORDER ErpOrder { get; set; }
        public List<ErpDETAIL> ErpDetails { get; set; }
    }
}

 MES.Service/MES.Service.csproj

@@ -7,8 +7,8 @@
    </PropertyGroup>

    <ItemGroup>
        <PackageReference Include="Masuit.Tools.Core" Version="2024.3.4"/>
        <PackageReference Include="SqlSugarCore" Version="5.1.4.158"/>
        <PackageReference Include="Masuit.Tools.Core" Version="2024.3.4" />
        <PackageReference Include="SqlSugarCore" Version="5.1.4.158" />
    </ItemGroup>

</Project>

 MES.Service/Modes/MesSalesOrder.cs

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

namespace MES.Service.Modes;

/// <summary>
///     é”€å”®è®¢å•è¡¨
/// </summary>
[SugarTable("MES_SALES_ORDER")]
public class MesSalesOrder
{
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_SALES",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     è®¢å•å•å·
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_ID")]
    public string OrderId { get; set; }

    /// <summary>
    ///     è®¢å•å•åˆ«
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_TYPE")]
    public string OrderType { get; set; }

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

    /// <summary>
    ///     å•æ®ç‰ˆæœ¬
    /// </summary>
    [SugarColumn(ColumnName = "DOCUMENT_VERSION")]
    public long? DocumentVersion { get; set; }

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

    /// <summary>
    ///     å·¥åŽ‚编号
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY_ID")]
    public string FactoryId { get; set; }

    /// <summary>
    ///     å·¥åŽ‚简称
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY_NAME")]
    public string FactoryName { get; set; }

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

    /// <summary>
    ///     å®¢æˆ·ç®€ç§°
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_NAME")]
    public string CustomerName { get; set; }

    /// <summary>
    ///     å®¢æˆ·å•å·
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ORDER_ID")]
    public string CustomerOrderId { get; set; }

    /// <summary>
    ///     éƒ¨é—¨ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENT_ID")]
    public string DepartmentId { get; set; }

    /// <summary>
    ///     æ€»æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_QUANTITY")]
    public decimal? TotalQuantity { get; set; }

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

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

    /// <summary>
    ///     erp审核者
    /// </summary>
    [SugarColumn(ColumnName = "APPROVER")]
    public string Approver { get; set; }

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

 MES.Service/Modes/MesSalesOrderDetail.cs

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

namespace MES.Service.Modes;

/// <summary>
///     é”€å”®è®¢å•æ˜Žç»†è¡¨
/// </summary>
[SugarTable("MES_SALES_ORDER_DETAIL")]
public class MesSalesOrderDetail
{
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     è®¢å•å•å·
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_ID")] 
    public string OrderId { get; set; }

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

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

    /// <summary>
    ///     äº§å“åç§°
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_NAME")]
    public string ProductName { get; set; }

    /// <summary>
    ///     äº§å“è§„æ ¼
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_SPEC")]
    public string ProductSpec { get; set; }

    /// <summary>
    ///     é¢„交货日期
    /// </summary>
    [SugarColumn(ColumnName = "SCHEDULED_DELIVERY_DATE")]
    public DateTime? ScheduledDeliveryDate { get; set; }

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

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

    /// <summary>
    ///     å•ä»·
    /// </summary>
    [SugarColumn(ColumnName = "UNIT_PRICE")]
    public decimal? UnitPrice { get; set; }

    /// <summary>
    ///     é‡‘额
    /// </summary>
    [SugarColumn(ColumnName = "AMOUNT")]
    public decimal? Amount { get; set; }

    /// <summary>
    ///     å®¢æˆ·äº§å“ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_PRODUCT_CODE")]
    public string CustomerProductCode { get; set; }

    /// <summary>
    ///     å·²äº¤è´§æ•°
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERED_QUANTITY")]
    public decimal? DeliveredQuantity { get; set; }

    /// <summary>
    ///     ç»“束
    /// </summary>
    [SugarColumn(ColumnName = "IS_CLOSED")]
    public string IsClosed { get; set; }

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

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

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_HEAD_ID")]
    public string ErpHeadId { 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/service/MesSalesOrderDetailManager.cs

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

namespace MES.Service.service;

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

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


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


    //    /*********删除*********/
    //    var deldata = new SalesOrderDetail(); //测试参数
    //    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/MesSalesOrderManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,177 @@
using AngleSharp.Dom;
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
using System.Data;
using System.Globalization;
using DbType = System.Data.DbType;

namespace MES.Service.service;

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

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

    private readonly MesSalesOrderDetailManager _MesSalesOrderDetailManagerManager = new();

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

    public bool Save(ErpSales sales)
    {
        var salesErpOrder = sales.ErpOrder;
        var mesSalesOrder = MapErpORDERtoMesSalesOrder(salesErpOrder);
        var mesSalesOrderDetails = MapErpDETAILtoMesSalesOrderDetail(sales.ErpDetails);

        return UseTransaction(db =>
        {
            switch (salesErpOrder.Type)
            {
                case "3":
                    return UpdateData(db, mesSalesOrder, mesSalesOrderDetails) ? 1 : 0;
                case "2":
                    return SaveOrUpdateData(db, mesSalesOrder, mesSalesOrderDetails)
                        ? 1
                        : 0;
                default:
                    throw new NotImplementedException(
                        $"type没有{salesErpOrder.Type}这个类型");
            }
        }) > 0;
    }
    private bool SaveOrUpdateData(SqlSugarScope db, MesSalesOrder mesSalesOrder,
        List<MesSalesOrderDetail> mesSalesOrderDetails)
    {

        if (mesSalesOrder.OrderId != null && mesSalesOrder.OrderType != null)
        {

            db.Deleteable<MesSalesOrder>()
           .Where(it => it.OrderId == mesSalesOrder.OrderId &&
                        it.OrderType == mesSalesOrder.OrderType)
           .ExecuteCommand();

        };
        if (mesSalesOrderDetails.Count > 0)
        {

            var mesSalesOrderDetail = mesSalesOrderDetails.Select(s => new { s.OrderId, s.LineNumber }).ToList();

            db.Deleteable<MesSalesOrderDetail>()
            .Where(it => mesSalesOrderDetails
            .Any(p => p.OrderId == it.OrderId
             && p.LineNumber == it.LineNumber))
            .ExecuteCommand();

        };

        var orUpdate = db.Insertable(mesSalesOrder).ExecuteCommand();
        var baOrUpdate = db.Insertable(mesSalesOrderDetails).ExecuteCommand();

        return orUpdate > 0 && baOrUpdate > 0;
        throw new NotImplementedException("插入或更新失败");


    }
    private bool UpdateData(SqlSugarScope db, MesSalesOrder mesSalesOrder,
        List<MesSalesOrderDetail> mesSalesOrderDetails)
    {
        //根据单别和单号进行删除
        var update = db.Deleteable<MesSalesOrder>()
        .Where(it => it.OrderId == mesSalesOrder.OrderId &&
                     it.OrderType == mesSalesOrder.OrderType)
        .ExecuteCommand() > 0;

        var mesSalesOrderDetail = mesSalesOrderDetails.Select(s => new { s.OrderId, s.LineNumber }).ToList();
        
        var insertOrUpdate = db.Deleteable<MesSalesOrderDetail>().Where(it => mesSalesOrderDetail.Any(p => p.OrderId == it.OrderId && p.LineNumber==it.LineNumber)).ExecuteCommand() > 0;


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

    private MesSalesOrder MapErpORDERtoMesSalesOrder(ErpORDER dto)
    {
        var entity = new MesSalesOrder
        {
            OrderId = dto.FBillNo,
            OrderType = dto.FBillTypeID,
            OrderDate = DateTime.TryParse(dto.F_UNW_Date_KHXQ, out DateTime orderDate) ? (DateTime?)orderDate : null,
            DocumentVersion = long.TryParse(dto.FVersionNo, out long versionNo) ? (long?)versionNo : null,
            DocumentDate = DateTime.TryParseExact(dto.FDate, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime documentDate) ? (DateTime?)documentDate : null,
            CustomerId = dto.FCustId,
            CustomerOrderId= dto.F_UNW_Text_KHDD,
            DepartmentId= dto.FSaleDeptId,
            TotalQuantity = long.TryParse(dto.FNote, out long quantity) ? (long?)quantity : null,
            Remarks =dto.F_UNW_LargeText_TBKHBZ,
            ApprovalDate = DateTime.TryParse(dto.FApproveDate, out DateTime approveDate) ? (DateTime?)approveDate : null,
            Approver = dto.FApproverId
        };



        return entity;
    }

    private List<MesSalesOrderDetail> MapErpDETAILtoMesSalesOrderDetail(List<ErpDETAIL> dtoList)
    {
        var detailList = new List<MesSalesOrderDetail>();
        
        foreach (var dto in dtoList)
        {
            var mesSalesOrderDetail = new MesSalesOrderDetail
            {
                
                OrderId= dto.F_UNW_Text_xsddh,
                LineNumber = dto.LineNumber,
                ProductCode =dto.FMaterialId,
                ProductName =dto.FMaterialName,
                ProductSpec=dto.FMaterialModel,
                ScheduledDeliveryDate = DateTime.TryParse(dto.FMinPlanDeliveryDate, out DateTime scheduledDeliveryDate) ? (DateTime?)scheduledDeliveryDate : null,
                OrderQuantity = long.TryParse(dto.FQty, out long quantity) ? (long?)quantity : null,
                Unit = dto.FUnitID,
                UnitPrice = long.TryParse(dto.FPrice, out long price) ? (long?)price : null,
                Amount = long.TryParse(dto.FAmount, out long amount) ? (long?)amount : null,
                

            };
            detailList.Add(mesSalesOrderDetail);
        }
        return detailList;
    }


    public bool Delete(YFDelete data)
    {

        return UseTransaction(db =>
        {
            var update = db.Deleteable<MesSalesOrder>()
                   .Where(it => it.OrderId == data.FBillNo &&
                                it.OrderType == data.FBillTypeID)
                   .ExecuteCommand() > 0;

            var insertOrUpdate = db.Deleteable<MesSalesOrderDetail>()
                  .Where(it => it.OrderId == data.FBillNo 
                         && it.LineNumber == data.FBillTypeID)
                  .ExecuteCommand() > 0;



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


    }


   
}

 MES.Service/service/WomcaaManager.cs

@@ -25,7 +25,7 @@

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


 MESApplication/Controllers/MesSalesOrderController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,312 @@
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 Microsoft.Extensions.Logging;
using Newtonsoft.Json;

namespace MESApplication.Controllers;

[ApiController]
[Route("api/[controller]")]
public class MesSalesOrderController : ControllerBase
{
    private readonly MessageCenterManager _manager = new();
    private readonly MesSalesOrderManager m = new();


    private readonly string METHOD = "POST";

    private readonly string TableName = "MES_SALES_ORDER";

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



    [HttpPost("Save")]
    public ResponseResult Save(ErpSales rohIn)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "Save";
        entity.Method = METHOD;
        entity.PageName = rohIn.ErpOrder.FBillTypeID + "-" + rohIn.ErpOrder.FBillNo; //单别和单号的拼接
        entity.Title = "销售订单";
        entity.Data = JsonConvert.SerializeObject(rohIn);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.Save(rohIn);

            resultInfos.tbBillList = save;

            entity.Result = 0;
            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<ErpSales> 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);
        }
    }


    [HttpPost("Delete")]
    public ResponseResult Delete(YFDelete data)
    {
        var entity = new MessageCenter();
        entity.TableName = TableName;
        entity.Url = URL + "Delete";
        entity.Method = METHOD;
        entity.PageName = data.FBillTypeID + "-" + data.FBillNo; //单别和单号的拼接
        entity.Title = "销售订单";
        entity.Data = JsonConvert.SerializeObject(data);
        entity.Status = 1;
        entity.CreateBy = "PL017";
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var save = m.Delete(data);

            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] MesSalesOrder 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] MesSalesOrder 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] MesSalesOrder data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.Update(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
}

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

Binary files differ

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

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.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.xml

@@ -822,6 +822,42 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.GetById(System.Int32)">
            <summary>
                æ ¹æ®ä¸»é”®èŽ·å–
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.DeleteByIds(System.Object[])">
            <summary>
                æ ¹æ®ä¸»é”®åˆ é™¤
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.Add(MES.Service.Modes.MesSalesOrder)">
            <summary>
                æ·»åŠ 
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.InsertReturnIdentity(MES.Service.Modes.MesSalesOrder)">
            <summary>
                æ·»åŠ è¿”回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.MesSalesOrderController.Update(MES.Service.Modes.MesSalesOrder)">
            <summary>
                ä¿®æ”¹
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.QC.MesLineUserController.GetList">
            <summary>
                èŽ·å–所有