1.生产补料拆分 2.拆分通用存储过程调用

南骏 池

20 小时以前 5df60eb35037611aaa977428c5cd41ad391f72af

 Controllers/Wom/WomdaaController.cs

@@ -2,6 +2,7 @@
using Microsoft.AspNetCore.Mvc;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.service.@base;
using NewPdaSqlServer.service.Wom;
using NewPdaSqlServer.util;

@@ -12,6 +13,7 @@
public class WomdaaController : ControllerBase
{
    private readonly WomdaaManager m = new();
    private readonly MesPrintMangeer _mCf = new();

    #region 生产领料

@@ -102,7 +104,10 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanCodeCF(query);
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList.printInfo = _mCf.getPrintInfo(query);
            var scanResult = m.ScanCodeCF(query);
            resultInfos.tbBillList.cfBarInfo = _mCf.getCfInfo(scanResult);
            return new ResponseResult
            {
                status = 0,
@@ -265,7 +270,7 @@

    #region 现场管理

    //GetItemsByDaa001

    /// <summary>
    ///     扫描注塑码，获取工单和条码信息
    /// </summary>
@@ -293,9 +298,9 @@
        }
    }

    //GetItemsByDaa001

    /// <summary>
    ///     扫描注塑码，获取工单和条码信息
    ///     产品绑定，追溯码和流水码绑定
    /// </summary>
    /// <returns></returns>
    [HttpPost("ProductBinding")]
@@ -320,5 +325,263 @@
        }
    }

    /// <summary>
    ///     获取卡板信息
    /// </summary>
    /// <returns></returns>
    [HttpPost("getKbBarInfo")]
    public ResponseResult getKbBarInfo([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // 先初始化tbBillList属性
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList.KbBarInfo = m.getKbBarInfo(query);
            resultInfos.tbBillList.KbBarMxInfo = m.getKbBarMxInfo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     获取箱码信息
    /// </summary>
    /// <returns></returns>
    [HttpPost("getXBarInfo")]
    public ResponseResult getXBarInfo([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // 先初始化tbBillList属性
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList.XBarInfo = m.getXBarInfo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     绑定箱码与托板码
    /// </summary>
    /// <returns></returns>
    [HttpPost("submitAllChecked")]
    public ResponseResult submitAllChecked([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // 先初始化tbBillList属性
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList = m.submitAllChecked(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     核对送检
    /// </summary>
    /// <returns></returns>
    [HttpPost("submitInspection")]
    public ResponseResult submitInspection([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // 先初始化tbBillList属性
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList = m.SubmitKbInspection(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //GetItemsXcsl
    /// <summary>
    ///     根据工单号获取待收料物料明细
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetItemsXcsl")]
    public ResponseResult GetItemsXcsl(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetItemsXcsl(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    //GetItemsXcsl
    /// <summary>
    ///     物料条码收料
    /// </summary>
    /// <returns></returns>
    [HttpPost("ScanXcsl")]
    public ResponseResult ScanXcsl(dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanXcsl(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //GetItemsXcsl
    /// <summary>
    ///     根据线体获取仪器重量
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetWeightByXt")]
    public ResponseResult GetWeightByXt(dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetWeightByXt(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    /// <summary>
    /// 现场收料获取可选工单信息
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    [HttpPost("GetXcslDaa")]
    public ResponseResult GetXcslDaa([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetXcslDaa(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    //GetItemsXctl
    /// <summary>
    ///     根据工单号获取待投料物料明细
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetItemsXctl")]
    public ResponseResult GetItemsXctl(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetItemsXctl(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //GetItemsXcsl
    /// <summary>
    ///     物料条码投料
    /// </summary>
    /// <returns></returns>
    [HttpPost("ScanXctl")]
    public ResponseResult ScanXctl(dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanXctl(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    #endregion
}