1、修改送货单

kyy

10 天以前 930f389ddb381f13e0adef7bba580a7ac3c99f2b

 service/Warehouse/MesXkyShdManager.cs

@@ -42,7 +42,8 @@
       A.delivery_qty - ISNULL(dhmx.quantity, 0) as dssl,
       A.po_erp_no,
       C.PURCHASE_ORDER_LINE_NUMBER,
       dhmx.GUID AS DDHID
       dhmx.GUID                        AS DDHID,
       A.erpline_id
from DELIVERY_NOTICE_DETAIL A
         LEFT JOIN MES_ROH_IN_DATA C ON A.po_line_no = C.EBELN_K3ID
         LEFT JOIN MES_ITEMS D ON C.ITEM_ID = D.item_id
@@ -62,8 +63,8 @@
        //// 使用参数化查询防止SQL注入
        var sqlParams = new List<SugarParameter> { new("@shdh", unity.shdh) };

        var sql2 = @"SELECT A.small_barcode,
        D.item_no,
     var sql2 = @"SELECT A.small_barcode,
       D.item_no,
       D.item_name,
       D.item_model,
       A.include_qty,
@@ -159,6 +160,56 @@
            }
        }
    }

    public string ConfirmSignReceipt(dynamic unity)
    {
        var _strMsg = "";
        var _intSum = 0;
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            if (unity == null) throw new ArgumentNullException(nameof(unity), "参数对象不能为 null");
            
            if (string.IsNullOrEmpty(unity.userName?.ToString()))
                throw new ArgumentException("用户账户不允许为空", nameof(unity.userName));
            
            if (string.IsNullOrEmpty(unity.shdh?.ToString()))
                throw new ArgumentException("送货单号不允许为空", nameof(unity.shdh));

            using (var cmd = new SqlCommand("[prc_pda_inv_dhdsh_qs]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
                        new("@po_outSum", SqlDbType.Int) { Direction = ParameterDirection.Output },
                        new("@pi_user", SqlDbType.NVarChar) { Value = unity.userName.ToString() },
                        new("@pi_shdh", SqlDbType.NVarChar) { Value = unity.shdh.ToString() }
                    };

                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    cmd.ExecuteNonQuery();
                    _strMsg = parameters[0].Value.ToString();
                    _intSum = Convert.ToInt32(parameters[1].Value);

                    if (_intSum <= 0) throw new Exception(_strMsg);

                    return _strMsg;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
    }
}