/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.Management.Tb_Management_Order model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.Management.Tb_Management_Order model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.Management.Tb_Management_Order> DataTableToList(DataTable dt) { List <MobileSoft.Model.Management.Tb_Management_Order> modelList = new List <MobileSoft.Model.Management.Tb_Management_Order>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.Management.Tb_Management_Order model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.Management.Tb_Management_Order(); model.OrderCode = dt.Rows[n]["OrderCode"].ToString(); model.CommID = dt.Rows[n]["CommID"].ToString(); model.ServiceCode = dt.Rows[n]["ServiceCode"].ToString(); model.OrderNum = dt.Rows[n]["OrderNum"].ToString(); //model.CustID=dt.Rows[n]["CustID"].ToString(); //model.RoomID=dt.Rows[n]["RoomID"].ToString(); if (dt.Rows[n]["OrderDate"].ToString() != "") { model.OrderDate = DateTime.Parse(dt.Rows[n]["OrderDate"].ToString()); } model.OrderMethod = dt.Rows[n]["OrderMethod"].ToString(); model.Contact = dt.Rows[n]["Contact"].ToString(); model.ContactTel = dt.Rows[n]["ContactTel"].ToString(); if (dt.Rows[n]["StartDate"].ToString() != "") { model.StartDate = DateTime.Parse(dt.Rows[n]["StartDate"].ToString()); } if (dt.Rows[n]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(dt.Rows[n]["EndDate"].ToString()); } if (dt.Rows[n]["OrderCount"].ToString() != "") { model.OrderCount = int.Parse(dt.Rows[n]["OrderCount"].ToString()); } if (dt.Rows[n]["OrderAmount"].ToString() != "") { model.OrderAmount = decimal.Parse(dt.Rows[n]["OrderAmount"].ToString()); } if (dt.Rows[n]["TotalAmount"].ToString() != "") { model.TotalAmount = decimal.Parse(dt.Rows[n]["TotalAmount"].ToString()); } model.IsPay = dt.Rows[n]["IsPay"].ToString(); model.Memo = dt.Rows[n]["Memo"].ToString(); model.IsAssign = dt.Rows[n]["IsAssign"].ToString(); model.AssignName = dt.Rows[n]["AssignName"].ToString(); if (dt.Rows[n]["AssignDate"].ToString() != "") { model.AssignDate = DateTime.Parse(dt.Rows[n]["AssignDate"].ToString()); } if (dt.Rows[n]["IsDeal"].ToString() != "") { model.IsDeal = dt.Rows[n]["IsDeal"].ToString(); } model.DealName = dt.Rows[n]["DealName"].ToString(); if (dt.Rows[n]["DealDate"].ToString() != "") { model.DealDate = DateTime.Parse(dt.Rows[n]["DealDate"].ToString()); } if (dt.Rows[n]["DeliveryCount"].ToString() != "") { model.DeliveryCount = int.Parse(dt.Rows[n]["DeliveryCount"].ToString()); } model.IsVisit = dt.Rows[n]["IsVisit"].ToString(); model.VisitName = dt.Rows[n]["VisitName"].ToString(); if (dt.Rows[n]["VisitDate"].ToString() != "") { model.VisitDate = DateTime.Parse(dt.Rows[n]["VisitDate"].ToString()); } model.Evaluation = dt.Rows[n]["Evaluation"].ToString(); model.CustOpinion = dt.Rows[n]["CustOpinion"].ToString(); model.IsExit = dt.Rows[n]["IsExit"].ToString(); model.ExitName = dt.Rows[n]["ExitName"].ToString(); if (dt.Rows[n]["ExitDate"].ToString() != "") { model.ExitDate = DateTime.Parse(dt.Rows[n]["ExitDate"].ToString()); } model.ExitReason = dt.Rows[n]["ExitReason"].ToString(); model.DealMemo = dt.Rows[n]["DealMemo"].ToString(); model.StanName = dt.Rows[n]["StanName"].ToString(); model.StanFormulaName = dt.Rows[n]["StanFormulaName"].ToString(); if (dt.Rows[n]["StanAmount"].ToString() != "") { model.StanAmount = decimal.Parse(dt.Rows[n]["StanAmount"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } modelList.Add(model); } } return(modelList); }