public bool Update(DTcms.Model.TransportOrder model, IList <Model.Order> orders, IList <Model.Consumption> consumptions) { return(dal.Update(model, orders, consumptions)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DTcms.Model.TransportOrder model) { return(dal.Update(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <DTcms.Model.TransportOrder> DataTableToList(DataTable dt) { List <DTcms.Model.TransportOrder> modelList = new List <DTcms.Model.TransportOrder>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DTcms.Model.TransportOrder model; for (int n = 0; n < rowsCount; n++) { model = new DTcms.Model.TransportOrder(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } model.Code = dt.Rows[n]["Code"].ToString(); if (dt.Rows[n]["DispatchTime"].ToString() != "") { model.DispatchTime = DateTime.Parse(dt.Rows[n]["DispatchTime"].ToString()); } if (dt.Rows[n]["FactDispatchTime"].ToString() != "") { model.FactDispatchTime = DateTime.Parse(dt.Rows[n]["FactDispatchTime"].ToString()); } if (dt.Rows[n]["TimeLimit"].ToString() != "") { model.TimeLimit = int.Parse(dt.Rows[n]["TimeLimit"].ToString()); } if (dt.Rows[n]["ReceiptTime"].ToString() != "") { model.ReceiptTime = DateTime.Parse(dt.Rows[n]["ReceiptTime"].ToString()); } if (dt.Rows[n]["WarningTime"].ToString() != "") { model.WarningTime = DateTime.Parse(dt.Rows[n]["WarningTime"].ToString()); } if (dt.Rows[n]["BackTime"].ToString() != "") { model.BackTime = DateTime.Parse(dt.Rows[n]["BackTime"].ToString()); } if (dt.Rows[n]["FactBackTime"].ToString() != "") { model.FactBackTime = DateTime.Parse(dt.Rows[n]["FactBackTime"].ToString()); } if (dt.Rows[n]["DriverId"].ToString() != "") { model.DriverId = int.Parse(dt.Rows[n]["DriverId"].ToString()); } if (dt.Rows[n]["Advance"].ToString() != "") { model.Advance = decimal.Parse(dt.Rows[n]["Advance"].ToString()); } model.Payee = dt.Rows[n]["Payee"].ToString(); if (dt.Rows[n]["Repayment"].ToString() != "") { model.Repayment = decimal.Parse(dt.Rows[n]["Repayment"].ToString()); } if (dt.Rows[n]["FactRepayment"].ToString() != "") { model.FactRepayment = decimal.Parse(dt.Rows[n]["FactRepayment"].ToString()); } if (dt.Rows[n]["CarriageUnitPrice"].ToString() != "") { model.CarriageUnitPrice = decimal.Parse(dt.Rows[n]["CarriageUnitPrice"].ToString()); } if (dt.Rows[n]["Carriage"].ToString() != "") { model.Carriage = decimal.Parse(dt.Rows[n]["Carriage"].ToString()); } if (dt.Rows[n]["FactCarriage"].ToString() != "") { model.FactCarriage = decimal.Parse(dt.Rows[n]["FactCarriage"].ToString()); } if (dt.Rows[n]["CostTotal"].ToString() != "") { model.CostTotal = decimal.Parse(dt.Rows[n]["CostTotal"].ToString()); } if (dt.Rows[n]["Profit"].ToString() != "") { model.Profit = decimal.Parse(dt.Rows[n]["Profit"].ToString()); } if (dt.Rows[n]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString()); } if (dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } model.CustomerRemarks = dt.Rows[n]["CustomerRemarks"].ToString(); model.HaulwayRemarks = dt.Rows[n]["HaulwayRemarks"].ToString(); model.Remarks = dt.Rows[n]["Remarks"].ToString(); if (dt.Rows[n]["FactTotalPrice"].ToString() != "") { model.FactTotalPrice = decimal.Parse(dt.Rows[n]["FactTotalPrice"].ToString()); } if (dt.Rows[n]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(dt.Rows[n]["TotalPrice"].ToString()); } if (dt.Rows[n]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString()); } if (dt.Rows[n]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(dt.Rows[n]["FactDispatchCount"].ToString()); } if (dt.Rows[n]["DispatchCount"].ToString() != "") { model.DispatchCount = decimal.Parse(dt.Rows[n]["DispatchCount"].ToString()); } if (dt.Rows[n]["ReceivedWeight"].ToString() != "") { model.ReceivedWeight = decimal.Parse(dt.Rows[n]["ReceivedWeight"].ToString()); } if (dt.Rows[n]["UnloadingWeight"].ToString() != "") { model.UnloadingWeight = decimal.Parse(dt.Rows[n]["UnloadingWeight"].ToString()); } if (dt.Rows[n]["ArriveDate"].ToString() != "") { model.ArriveDate = DateTime.Parse(dt.Rows[n]["ArriveDate"].ToString()); } if (dt.Rows[n]["FactArriveDate"].ToString() != "") { model.FactArriveDate = DateTime.Parse(dt.Rows[n]["FactArriveDate"].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()); } if (dt.Rows[n]["Weight"].ToString() != "") { model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString()); } if (dt.Rows[n]["LoadingDate"].ToString() != "") { model.LoadingDate = DateTime.Parse(dt.Rows[n]["LoadingDate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DTcms.Model.TransportOrder model) { return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List<DTcms.Model.TransportOrder> DataTableToList(DataTable dt) { List<DTcms.Model.TransportOrder> modelList = new List<DTcms.Model.TransportOrder>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DTcms.Model.TransportOrder model; for (int n = 0; n < rowsCount; n++) { model = new DTcms.Model.TransportOrder(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } model.Code = dt.Rows[n]["Code"].ToString(); if (dt.Rows[n]["DispatchTime"].ToString() != "") { model.DispatchTime = DateTime.Parse(dt.Rows[n]["DispatchTime"].ToString()); } if (dt.Rows[n]["FactDispatchTime"].ToString() != "") { model.FactDispatchTime = DateTime.Parse(dt.Rows[n]["FactDispatchTime"].ToString()); } if (dt.Rows[n]["TimeLimit"].ToString() != "") { model.TimeLimit = int.Parse(dt.Rows[n]["TimeLimit"].ToString()); } if (dt.Rows[n]["ReceiptTime"].ToString() != "") { model.ReceiptTime = DateTime.Parse(dt.Rows[n]["ReceiptTime"].ToString()); } if (dt.Rows[n]["WarningTime"].ToString() != "") { model.WarningTime = DateTime.Parse(dt.Rows[n]["WarningTime"].ToString()); } if (dt.Rows[n]["BackTime"].ToString() != "") { model.BackTime = DateTime.Parse(dt.Rows[n]["BackTime"].ToString()); } if (dt.Rows[n]["FactBackTime"].ToString() != "") { model.FactBackTime = DateTime.Parse(dt.Rows[n]["FactBackTime"].ToString()); } if (dt.Rows[n]["DriverId"].ToString() != "") { model.DriverId = int.Parse(dt.Rows[n]["DriverId"].ToString()); } if (dt.Rows[n]["Advance"].ToString() != "") { model.Advance = decimal.Parse(dt.Rows[n]["Advance"].ToString()); } model.Payee = dt.Rows[n]["Payee"].ToString(); if (dt.Rows[n]["Repayment"].ToString() != "") { model.Repayment = decimal.Parse(dt.Rows[n]["Repayment"].ToString()); } if (dt.Rows[n]["FactRepayment"].ToString() != "") { model.FactRepayment = decimal.Parse(dt.Rows[n]["FactRepayment"].ToString()); } if (dt.Rows[n]["CarriageUnitPrice"].ToString() != "") { model.CarriageUnitPrice = decimal.Parse(dt.Rows[n]["CarriageUnitPrice"].ToString()); } if (dt.Rows[n]["Carriage"].ToString() != "") { model.Carriage = decimal.Parse(dt.Rows[n]["Carriage"].ToString()); } if (dt.Rows[n]["FactCarriage"].ToString() != "") { model.FactCarriage = decimal.Parse(dt.Rows[n]["FactCarriage"].ToString()); } if (dt.Rows[n]["CostTotal"].ToString() != "") { model.CostTotal = decimal.Parse(dt.Rows[n]["CostTotal"].ToString()); } if (dt.Rows[n]["Profit"].ToString() != "") { model.Profit = decimal.Parse(dt.Rows[n]["Profit"].ToString()); } if (dt.Rows[n]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString()); } if (dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } model.CustomerRemarks = dt.Rows[n]["CustomerRemarks"].ToString(); model.HaulwayRemarks = dt.Rows[n]["HaulwayRemarks"].ToString(); model.Remarks = dt.Rows[n]["Remarks"].ToString(); if (dt.Rows[n]["FactTotalPrice"].ToString() != "") { model.FactTotalPrice = decimal.Parse(dt.Rows[n]["FactTotalPrice"].ToString()); } if (dt.Rows[n]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(dt.Rows[n]["TotalPrice"].ToString()); } if (dt.Rows[n]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString()); } if (dt.Rows[n]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(dt.Rows[n]["FactDispatchCount"].ToString()); } if (dt.Rows[n]["DispatchCount"].ToString() != "") { model.DispatchCount = decimal.Parse(dt.Rows[n]["DispatchCount"].ToString()); } if (dt.Rows[n]["ReceivedWeight"].ToString() != "") { model.ReceivedWeight = decimal.Parse(dt.Rows[n]["ReceivedWeight"].ToString()); } if (dt.Rows[n]["UnloadingWeight"].ToString() != "") { model.UnloadingWeight = decimal.Parse(dt.Rows[n]["UnloadingWeight"].ToString()); } if (dt.Rows[n]["ArriveDate"].ToString() != "") { model.ArriveDate = DateTime.Parse(dt.Rows[n]["ArriveDate"].ToString()); } if (dt.Rows[n]["FactArriveDate"].ToString() != "") { model.FactArriveDate = DateTime.Parse(dt.Rows[n]["FactArriveDate"].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()); } if (dt.Rows[n]["Weight"].ToString() != "") { model.Weight = decimal.Parse(dt.Rows[n]["Weight"].ToString()); } if (dt.Rows[n]["LoadingDate"].ToString() != "") { model.LoadingDate = DateTime.Parse(dt.Rows[n]["LoadingDate"].ToString()); } modelList.Add(model); } } return modelList; }