public DeliveryOrderManagementResponse GetOrderDetailDAL(string OrderKey)
{
DeliveryOrderManagementResponse Responest = new DeliveryOrderManagementResponse();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
SqlCommand cmd = new SqlCommand("pro_wms_SampleReturnOrderDetail", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderKey", OrderKey);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[0].Size = 100;
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
cmd.CommandTimeout = 180;
sda.SelectCommand = cmd;
sda.Fill(ds);
Responest.EnumerableDeliveryOrder = ds.ConvertToEntityCollection <DeliveryOrder>();
conn.Close();
}
catch (Exception)
{
throw;
}
}
return(Responest);
}
public DeliveryOrderManagementResponse GetReturnOrderDAL(DeliveryOrderManagementRequest request)
{
DeliveryOrderManagementResponse Responest = new DeliveryOrderManagementResponse();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
SqlCommand cmd = new SqlCommand("pro_wms_SampleReturnOrder", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", request.UserName);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[0].Size = 100;
cmd.Parameters.AddWithValue("@PageIndex", request.PageIndex);
cmd.Parameters[1].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@PageSize", request.PageSize);
cmd.Parameters[2].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@RowCount", 0);
cmd.Parameters[3].Direction = ParameterDirection.Output;
cmd.Parameters[3].SqlDbType = SqlDbType.Int;
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
cmd.CommandTimeout = 180;
sda.SelectCommand = cmd;
sda.Fill(ds);
Responest.PageCount = (int)cmd.Parameters[3].Value;
Responest.PageIndex = request.PageIndex;
Responest.EnumerableDeliveryOrder = ds.ConvertToEntityCollection <DeliveryOrder>();
conn.Close();
}
catch (Exception)
{
throw;
}
}
return(Responest);
}
