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