文件补充

cnf

8 天以前 1b3db8f5683373dd8e179b006e7314783dd1f9db

 WebApi/Gs.Ww/WWTBlDJManager.cs

@@ -1,16 +1,16 @@
using System.Data;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox;
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;
using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox.ApiCore.Group;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using static Gs.Toolbox.UtilityHelper;

namespace Gs.Ww;

namespace Gs.Ww
{
[ApiGroup(ApiGroupNames.WW)]
public class WWTBlDJManager : IRomteService
{
@@ -59,8 +59,7 @@
        };
        try
        {
            dset = DbHelperSQL.RunProcedure("prc_ww_tbldj_lst", parameters,
                "0");
                dset = DbHelperSQL.RunProcedure("prc_ww_tbldj_lst", parameters, "0");
            if (dset != null && dset.Tables.Count > 0 &&
                dset.Tables[0].Rows.Count > 0) //有数据
            {
@@ -110,8 +109,7 @@
        var dset = new DataSet();
        try
        {
            dset = DbHelperSQL.RunProcedure("[prc_ww_tbldj_mx]", parameters,
                "0");
                dset = DbHelperSQL.RunProcedure("[prc_ww_tbldj_mx]", parameters, "0");
            if (dset != null && dset.Tables.Count > 0 &&
                dset.Tables[0].Rows.Count > 0)
            {
@@ -135,6 +133,7 @@
    }

    /// <summary>
        ///   
    /// </summary>
    /// <param name="mode"></param>
    /// <returns></returns>
@@ -146,48 +145,6 @@
        dynamic m = new ExpandoObject();
        m.outSum = -1;
        m.outMsg = "";
        // 当审核时（_inFieldValue为"1"时）检查仓库
        if (_inFieldValue == "1")
            try
            {
                var warehouseCheckSql = @"
                        SELECT COUNT(1) 
                        FROM MES_INV_ITEM_IN_C_DETAILS b 
                        LEFT JOIN MES_INV_ITEM_INS h ON h.GUID = b.ITEM_IN_ID	 
                        LEFT JOIN (
                            SELECT h.ORDER_NO, b1.MATERIAL_CODE, b1.WAREHOUSE, h.ERP_PRODUCTION_ORDER_NO 
                            FROM PRODUCTION_ORDER_SUB b1 
                            LEFT JOIN PRODUCTION_ORDER h ON h.ERP_PRODUCTION_ENTRY_CODE = b1.ERP_PRODUCTION_ENTRY_CODE
                        ) d ON h.work_no = d.ERP_PRODUCTION_ORDER_NO AND d.MATERIAL_CODE = b.item_id 
                        WHERE b.item_in_id = @inFieldValue
                        AND (d.WAREHOUSE IS NULL OR d.WAREHOUSE = '' OR d.WAREHOUSE = '0')";

                var parameters = new[]
                {
                    new SqlParameter("@inFieldValue", _guid)
                };

                var emptyWarehouseCount =
                    DbHelperSQL.GetSingle(warehouseCheckSql, parameters);

                if (emptyWarehouseCount != null &&
                    Convert.ToInt32(emptyWarehouseCount) > 0)
                {
                    m.outSum = -1;
                    m.outMsg = "对应的委外单的仓库为空，无法审核！";
                    return ReturnDto<dynamic>.QuickReturn(m,
                        ReturnCode.Exception, m.outMsg);
                }
            }
            catch (Exception ex)
            {
                LogHelper.Debug(ToString(), "仓库检查失败：" + ex.Message);
                m.outSum = -1;
                m.outMsg = "仓库检查失败：" + ex.Message;
                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Exception,
                    m.outMsg);
            }

        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand("prc_ww_tbldj_Submit", conn))
@@ -227,7 +184,7 @@
                }
            }
        }

        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");
    }
}
}