public static List <SubscibeDeliveryModel> SelectSubscibeDeliveryModels()
{
var deliveryModels = new List <SubscibeDeliveryModel>();
using (var connection = new SqlConnection(Wms))
{
connection.Open();
var command = new SqlCommand("Delivery_SelectNeedSubscibeDelivery", connection);
command.CommandType = CommandType.StoredProcedure;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var deliveryModel = new SubscibeDeliveryModel();
deliveryModel.OrderID = reader.IsDBNull(0) ? 0 : reader.GetInt32(0);
deliveryModel.DeliveryCompany = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
deliveryModel.DeliveryCode = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
deliveryModel.DeliveryAddress = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
deliveryModels.Add(deliveryModel);
}
}
}
return(deliveryModels);
}
public SubscibeModel(SubscibeDeliveryModel model)
{
this.OrderId = model.OrderID;
this.SubscibeBody = new SubscibeBodyModel();
this.SubscibeBody.DeliveryCompany = model.DeliveryCompany;
this.SubscibeBody.DeliveryCode = model.DeliveryCode;
this.SubscibeBody.To = model.DeliveryAddress;
}
