/// <summary> /// /// </summary> /// <param name="MainID"></param> /// <param name="t">真为审核,假为弃审</param> public void Verify(int MainID, bool t) { Hownet.BLL.ProduceSell bllPS = new ProduceSell(); Hownet.Model.ProduceSell modPS = bllPS.GetModel(MainID); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); Hownet.BLL.Repertory bllRe = new Repertory(); Hownet.Model.Repertory modRe = new Hownet.Model.Repertory(); List <Hownet.Model.WMSInventoryInfo> li = GetModelList("(MainID=" + MainID + ")"); if (li.Count > 0) { for (int i = 0; i < li.Count; i++) { if (li[i].RepertoryID > 0) { modRe = bllRe.GetModel(li[i].RepertoryID); modRe.Amount = li[i].NowAmount; bllRe.Update(modRe); } else { modRe = new Hownet.Model.Repertory(); modML = new Hownet.Model.MaterielList(); modRe.BrandID = modML.BrandID = li[i].BrandID; modRe.ColorID = modML.ColorID = li[i].ColorID; modRe.ColorOneID = modML.ColorOneID = li[i].ColorOneID; modRe.ColorTwoID = modML.ColorTwoID = li[i].ColorTwoID; modRe.CompanyID = li[i].CompanyID; modRe.DepartmentID = modPS.Depot; modRe.MaterielID = modML.MaterielID = li[i].MaterielID; modRe.MeasureID = modML.MeasureID = li[i].MeasureID; modRe.SizeID = modML.SizeID = li[i].SizeID; modRe.MListID = li[i].MListID = bllML.GetID(modML); modRe.Amount = li[i].NowAmount; li[i].RepertoryID = bllRe.Add(modRe); Update(li[i]); } } } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.ProduceSell model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.ProduceSell model) { return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.ProduceSell> DataTableToList(DataTable dt) { List <Hownet.Model.ProduceSell> modelList = new List <Hownet.Model.ProduceSell>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.ProduceSell model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.ProduceSell(); try { if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } else { model.ID = 0; } if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } else { model.CompanyID = 0; } if (dt.Rows[n]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString()); } else { model.DateTime = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["Depot"].ToString() != "") { model.Depot = int.Parse(dt.Rows[n]["Depot"].ToString()); } else { model.Depot = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["Money"].ToString() != "") { model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString()); } else { model.Money = 0; } if (dt.Rows[n]["IsVerify"].ToString() != "") { model.IsVerify = int.Parse(dt.Rows[n]["IsVerify"].ToString()); } if (dt.Rows[n]["LastMoney"].ToString() != "") { model.LastMoney = decimal.Parse(dt.Rows[n]["LastMoney"].ToString()); } else { model.LastMoney = 0; } if (dt.Rows[n]["BackMoney"].ToString() != "") { model.BackMoney = decimal.Parse(dt.Rows[n]["BackMoney"].ToString()); } else { model.BackMoney = 0; } if (dt.Rows[n]["Num"].ToString() != "") { model.Num = int.Parse(dt.Rows[n]["Num"].ToString()); } else { model.Num = 0; } if (dt.Rows[n]["UpData"].ToString() != "") { model.UpData = int.Parse(dt.Rows[n]["UpData"].ToString()); } else { model.UpData = 0; } if (dt.Rows[n]["VerifyMan"].ToString() != "") { model.VerifyMan = int.Parse(dt.Rows[n]["VerifyMan"].ToString()); } else { model.VerifyMan = 0; } if (dt.Rows[n]["VerifyDate"].ToString() != "") { model.VerifyDate = DateTime.Parse(dt.Rows[n]["VerifyDate"].ToString()); } else { model.VerifyDate = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["FillMan"].ToString() != "") { model.FillMan = int.Parse(dt.Rows[n]["FillMan"].ToString()); } else { model.FillMan = 0; } if (dt.Rows[n]["FillDate"].ToString() != "") { model.FillDate = DateTime.Parse(dt.Rows[n]["FillDate"].ToString()); } else { model.FillDate = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["State"].ToString() != "") { model.State = int.Parse(dt.Rows[n]["State"].ToString()); } else { model.State = 0; } if (dt.Rows[n]["BackDate"].ToString() != "") { model.BackDate = DateTime.Parse(dt.Rows[n]["BackDate"].ToString()); } else { model.BackDate = DateTime.Parse("1900-1-1"); } if (dt.Rows[n]["BackMoneyTypeID"].ToString() != "") { model.BackMoneyTypeID = int.Parse(dt.Rows[n]["BackMoneyTypeID"].ToString()); } else { model.BackMoneyTypeID = 0; } if (dt.Rows[n]["LastDate"] != null && dt.Rows[n]["LastDate"].ToString() != "") { model.LastDate = DateTime.Parse(dt.Rows[n]["LastDate"].ToString()); } model.A = int.Parse(dt.Rows[n]["A"].ToString()); } catch (Exception ex) { } modelList.Add(model); } } return(modelList); }