/// <summary>
/// 获得数据列表
/// </summary>
public List<DTcms.Model.Order> DataTableToList(DataTable dt)
{
List<DTcms.Model.Order> modelList = new List<DTcms.Model.Order>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DTcms.Model.Order model;
for (int n = 0; n < rowsCount; n++)
{
model = new DTcms.Model.Order();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["TransportOrderId"].ToString() != "")
{
model.TransportOrderId = int.Parse(dt.Rows[n]["TransportOrderId"].ToString());
}
model.Code = dt.Rows[n]["Code"].ToString();
if (dt.Rows[n]["AcceptOrderTime"].ToString() != "")
{
model.AcceptOrderTime = DateTime.Parse(dt.Rows[n]["AcceptOrderTime"].ToString());
}
if (dt.Rows[n]["ArrivedTime"].ToString() != "")
{
model.ArrivedTime = DateTime.Parse(dt.Rows[n]["ArrivedTime"].ToString());
}
if (dt.Rows[n]["ShipperId"].ToString() != "")
{
model.ShipperId = int.Parse(dt.Rows[n]["ShipperId"].ToString());
}
if (dt.Rows[n]["ReceiverId"].ToString() != "")
{
model.ReceiverId = int.Parse(dt.Rows[n]["ReceiverId"].ToString());
}
model.ContractNumber = dt.Rows[n]["ContractNumber"].ToString();
model.LoadingAddress = dt.Rows[n]["LoadingAddress"].ToString();
model.UnloadingAddress = dt.Rows[n]["UnloadingAddress"].ToString();
if (dt.Rows[n]["GoodsId"].ToString() != "")
{
model.GoodsId = int.Parse(dt.Rows[n]["GoodsId"].ToString());
}
if (dt.Rows[n]["IsCharteredCar"].ToString() != "")
{
model.IsCharteredCar = int.Parse(dt.Rows[n]["IsCharteredCar"].ToString());
}
if (dt.Rows[n]["Quantity"].ToString() != "")
{
model.Quantity = decimal.Parse(dt.Rows[n]["Quantity"].ToString());
}
if (dt.Rows[n]["DispatchedCount"].ToString() != "")
{
model.DispatchedCount = decimal.Parse(dt.Rows[n]["DispatchedCount"].ToString());
}
model.Haulway = dt.Rows[n]["Haulway"].ToString();
if (dt.Rows[n]["LoadingCapacityRunning"].ToString() != "")
{
model.LoadingCapacityRunning = decimal.Parse(dt.Rows[n]["LoadingCapacityRunning"].ToString());
}
if (dt.Rows[n]["NoLoadingCapacityRunning"].ToString() != "")
{
model.NoLoadingCapacityRunning = decimal.Parse(dt.Rows[n]["NoLoadingCapacityRunning"].ToString());
}
model.BillNumber = dt.Rows[n]["BillNumber"].ToString();
model.WeighbridgeNumber = dt.Rows[n]["WeighbridgeNumber"].ToString();
if (dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["CreateDateTime"].ToString() != "")
{
model.CreateDateTime = DateTime.Parse(dt.Rows[n]["CreateDateTime"].ToString());
}
model.Remarks = dt.Rows[n]["Remarks"].ToString();
if (dt.Rows[n]["IsWeightNote"].ToString() != "")
{
if ((dt.Rows[n]["IsWeightNote"].ToString() == "1") || (dt.Rows[n]["IsWeightNote"].ToString().ToLower() == "true"))
{
model.IsWeightNote = true;
}
else
{
model.IsWeightNote = false;
}
}
if (dt.Rows[n]["IsAllotted"].ToString() != "")
{
if ((dt.Rows[n]["IsAllotted"].ToString() == "1") || (dt.Rows[n]["IsAllotted"].ToString().ToLower() == "true"))
{
model.IsAllotted = true;
}
else
{
model.IsAllotted = false;
}
}
if (dt.Rows[n]["UnitPrice"].ToString() != "")
{
model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString());
}
if (dt.Rows[n]["Weight"].ToString() != "")
{
model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString());
}
if (dt.Rows[n]["Freight"].ToString() != "")
{
model.Freight = decimal.Parse(dt.Rows[n]["Freight"].ToString());
}
if (dt.Rows[n]["HandlingCharge"].ToString() != "")
{
model.HandlingCharge = decimal.Parse(dt.Rows[n]["HandlingCharge"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DTcms.Model.Order model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTcms.Model.Order model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <DTcms.Model.Order> DataTableToList(DataTable dt)
{
List <DTcms.Model.Order> modelList = new List <DTcms.Model.Order>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DTcms.Model.Order model;
for (int n = 0; n < rowsCount; n++)
{
model = new DTcms.Model.Order();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["TransportOrderId"].ToString() != "")
{
model.TransportOrderId = int.Parse(dt.Rows[n]["TransportOrderId"].ToString());
}
model.Code = dt.Rows[n]["Code"].ToString();
if (dt.Rows[n]["AcceptOrderTime"].ToString() != "")
{
model.AcceptOrderTime = DateTime.Parse(dt.Rows[n]["AcceptOrderTime"].ToString());
}
if (dt.Rows[n]["ArrivedTime"].ToString() != "")
{
model.ArrivedTime = DateTime.Parse(dt.Rows[n]["ArrivedTime"].ToString());
}
if (dt.Rows[n]["ShipperId"].ToString() != "")
{
model.ShipperId = int.Parse(dt.Rows[n]["ShipperId"].ToString());
}
if (dt.Rows[n]["ReceiverId"].ToString() != "")
{
model.ReceiverId = int.Parse(dt.Rows[n]["ReceiverId"].ToString());
}
model.ContractNumber = dt.Rows[n]["ContractNumber"].ToString();
model.LoadingAddress = dt.Rows[n]["LoadingAddress"].ToString();
model.UnloadingAddress = dt.Rows[n]["UnloadingAddress"].ToString();
if (dt.Rows[n]["GoodsId"].ToString() != "")
{
model.GoodsId = int.Parse(dt.Rows[n]["GoodsId"].ToString());
}
if (dt.Rows[n]["IsCharteredCar"].ToString() != "")
{
model.IsCharteredCar = int.Parse(dt.Rows[n]["IsCharteredCar"].ToString());
}
if (dt.Rows[n]["Quantity"].ToString() != "")
{
model.Quantity = decimal.Parse(dt.Rows[n]["Quantity"].ToString());
}
if (dt.Rows[n]["DispatchedCount"].ToString() != "")
{
model.DispatchedCount = decimal.Parse(dt.Rows[n]["DispatchedCount"].ToString());
}
model.Haulway = dt.Rows[n]["Haulway"].ToString();
if (dt.Rows[n]["LoadingCapacityRunning"].ToString() != "")
{
model.LoadingCapacityRunning = decimal.Parse(dt.Rows[n]["LoadingCapacityRunning"].ToString());
}
if (dt.Rows[n]["NoLoadingCapacityRunning"].ToString() != "")
{
model.NoLoadingCapacityRunning = decimal.Parse(dt.Rows[n]["NoLoadingCapacityRunning"].ToString());
}
model.BillNumber = dt.Rows[n]["BillNumber"].ToString();
model.WeighbridgeNumber = dt.Rows[n]["WeighbridgeNumber"].ToString();
if (dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["CreateDateTime"].ToString() != "")
{
model.CreateDateTime = DateTime.Parse(dt.Rows[n]["CreateDateTime"].ToString());
}
model.Remarks = dt.Rows[n]["Remarks"].ToString();
if (dt.Rows[n]["IsWeightNote"].ToString() != "")
{
if ((dt.Rows[n]["IsWeightNote"].ToString() == "1") || (dt.Rows[n]["IsWeightNote"].ToString().ToLower() == "true"))
{
model.IsWeightNote = true;
}
else
{
model.IsWeightNote = false;
}
}
if (dt.Rows[n]["IsAllotted"].ToString() != "")
{
if ((dt.Rows[n]["IsAllotted"].ToString() == "1") || (dt.Rows[n]["IsAllotted"].ToString().ToLower() == "true"))
{
model.IsAllotted = true;
}
else
{
model.IsAllotted = false;
}
}
if (dt.Rows[n]["UnitPrice"].ToString() != "")
{
model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString());
}
if (dt.Rows[n]["Weight"].ToString() != "")
{
model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString());
}
if (dt.Rows[n]["Freight"].ToString() != "")
{
model.Freight = decimal.Parse(dt.Rows[n]["Freight"].ToString());
}
if (dt.Rows[n]["HandlingCharge"].ToString() != "")
{
model.HandlingCharge = decimal.Parse(dt.Rows[n]["HandlingCharge"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
