/// <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(""); } } }