/// <summary>
/// 新增交接清单及明细
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public Response <string> AddDeliverAndDetail(AddDeliverAndDetailRequest request, int flag)
{
Response <string> response = new Response <string>();
string message = "";
try
{
message = new DeliverConfirmAccessor().AddDeliverAndDetail(request, flag);
//if (message == "")
//{
// response.Result = message;
// response.IsSuccess = true;
//}
//else
//{
// response.Result = message;
// response.IsSuccess = false;
//}
//return response;
response.Result = message;
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
//response.Result = message + ex.Message;
response.Result = "";
}
return(response);
}
/// <summary>
/// 交接清单及明细
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public string AddDeliverAndDetail(AddDeliverAndDetailRequest request, int flag)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
string message = "";
try
{
SqlCommand cmd = new SqlCommand("Proc_WMS_AddDeliverAndDetail", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Deliver", request.DeliverHeaderConnection.Select(p => new WMSDeliverToDb(p))); //表头
cmd.Parameters[0].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@DeliverDetail", request.DeliverDetailConnection.Select(p => new WMSDeliverDetailToDb(p))); //明细
cmd.Parameters[1].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@Flag", flag); //增加一条和保存所有类型判断
cmd.Parameters[2].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@message", message); //返回
cmd.Parameters[3].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[3].Direction = ParameterDirection.Output;
cmd.Parameters[3].Size = 500;
cmd.CommandTimeout = 300;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
message = sda.SelectCommand.Parameters["@message"].Value.ToString();//传出交接单ID
conn.Close();
return(message);
}
catch (Exception ex)
{
//return message + "(" + ex.Message + ")";
return("");
}
}
}
