/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.HandBackInfo> DataTableToList(DataTable dt) { List <Hownet.Model.HandBackInfo> modelList = new List <Hownet.Model.HandBackInfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.HandBackInfo model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.HandBackInfo(); if (dt.Rows[n]["InfoID"].ToString() != "") { model.InfoID = int.Parse(dt.Rows[n]["InfoID"].ToString()); } if (dt.Rows[n]["MainID"].ToString() != "") { model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString()); } if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } if (dt.Rows[n]["WorkingID"].ToString() != "") { model.WorkingID = int.Parse(dt.Rows[n]["WorkingID"].ToString()); } if (dt.Rows[n]["Amount"].ToString() != "") { model.Amount = int.Parse(dt.Rows[n]["Amount"].ToString()); } if (dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["Money"].ToString() != "") { model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString()); } if (dt.Rows[n]["PriceID"].ToString() != "") { model.PriceID = int.Parse(dt.Rows[n]["PriceID"].ToString()); } if (dt.Rows[n]["EmployeeID"] != null && dt.Rows[n]["EmployeeID"].ToString() != "") { model.EmployeeID = int.Parse(dt.Rows[n]["EmployeeID"].ToString()); } if (dt.Rows[n]["DateTime"] != null && dt.Rows[n]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.HandBackInfo model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.HandBackInfo model) { return(dal.Add(model)); }
public void Save(DataTable dt, int mainID, int EmployeeID, DateTime date) { int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.HandBackInfo model; Hownet.BLL.PayInfo bllPI = new PayInfo(); Hownet.Model.PayInfo modPI = new Hownet.Model.PayInfo(); for (int n = 0; n < rowsCount; n++) { if (dt.Rows[n].RowState != DataRowState.Deleted) { string a = dt.Rows[n]["A"].ToString(); if (a != "1") { model = new Hownet.Model.HandBackInfo(); if (dt.Rows[n]["MaterielID"].ToString() != "") { modPI.MaterielID = model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } if (dt.Rows[n]["WorkingID"].ToString() != "") { modPI.WorkingID = model.WorkingID = int.Parse(dt.Rows[n]["WorkingID"].ToString()); } if (dt.Rows[n]["Amount"].ToString() != "") { modPI.Amount = model.Amount = int.Parse(dt.Rows[n]["Amount"].ToString()); } if (dt.Rows[n]["Price"].ToString() != "") { modPI.Price = model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["Money"].ToString() != "") { model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString()); } if (dt.Rows[n]["PriceID"].ToString() != "") { modPI.ProductWorkingID = model.PriceID = int.Parse(dt.Rows[n]["PriceID"].ToString()); } modPI.BoxNum = model.InfoID = int.Parse(dt.Rows[n]["InfoID"].ToString()); modPI.EmployeeID = EmployeeID; modPI.DateTime = date; model.MainID = mainID; modPI.ColorID = modPI.SizeID = 0; modPI.OderNum = ""; modPI.IsSum = false; if (model.MaterielID != 0 && model.WorkingID != 0 && model.Amount != 0) { if (a == "3") { modPI.BoxNum = Add(model); bllPI.Add(modPI); } else if (a == "2") { modPI.ID = int.Parse(dt.Rows[n]["PayInfoID"].ToString()); Update(model); bllPI.Update(modPI); } } } } } } }