标准版初始化

lg

2025-11-20 b98df034707a61fd2857dbccd5a232605076ca59

 WebApi/Gs.Ww/WWBlDJManager.cs

@@ -145,6 +145,44 @@
            dynamic m = new ExpandoObject();
            m.outSum = -1;
            m.outMsg = "";
            // 当审核时（_inFieldValue为"1"时）检查仓库
            if (_inFieldValue == "1")
            {
                try
                {
                    string warehouseCheckSql = @"
                        SELECT COUNT(1) 
                        FROM MES_INV_ITEM_OUT_ITEMS b 
                        LEFT JOIN MES_INV_ITEM_OUTS h ON h.GUID = b.ITEM_OUT_ID	 
                         left join MES_ITEM_BL_DETAIL bl on bl.id = b.item_dabid
                         left join WW_GD_DETAIL gdde on gdde.id = bl.dabGuid
                         left join WW_GD gd on gd.id = gdde.pid
                         left join (select h.ORDER_NO,b1.MATERIAL_CODE,b1.ERP_ID,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 gd.daa014 = ORDER_NO and d.MATERIAL_CODE = b.item_id
                        WHERE b.item_out_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_bldj_submit", conn))