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); }