public ExpressPackageResponse CheckExpress(string ExpressNumber, long CustomerID, string WarehouseName)
{
ExpressPackageResponse EPR = new ExpressPackageResponse();
try
{
OrderECManagementAccessor accessor = new OrderECManagementAccessor();
EPR = accessor.CheckExpress(ExpressNumber, CustomerID, WarehouseName);
}
catch (Exception ex)
{
LogError(ex);
}
return(EPR);
}
public ExpressPackageResponse CheckExpress(string ExpressNumber, long CustomerID, string WarehouseName)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
int message = 100;
ExpressPackageResponse EPR = new ExpressPackageResponse();
try
{
DataSet dt = new DataSet();
SqlCommand cmd = new SqlCommand("Proc_WMS_CheckExpressAndGetOrder", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ExpressNumber", ExpressNumber);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.AddWithValue("@CustomerID", CustomerID);
cmd.Parameters[1].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@WarehouseName", WarehouseName);
cmd.Parameters[2].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.AddWithValue("@message", message);
cmd.Parameters[3].SqlDbType = SqlDbType.Int;
cmd.Parameters[3].Direction = ParameterDirection.Output;
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(dt);
cmd.CommandTimeout = 300;
EPR.AssociationStatus = Convert.ToInt32(sda.SelectCommand.Parameters["@message"].Value);
message = Convert.ToInt32(sda.SelectCommand.Parameters["@message"].Value);
conn.Close();
if (message > 0)
{
EPR.PackageCollection = dt.Tables[0].ConvertToEntity <PackageInfo>();
EPR.OrderDetailCollection = dt.Tables[1].ConvertToEntityCollection <OrderDetailInfo>();
}
return(EPR);
}
catch (Exception)
{
return(EPR);
}
}
}
