/// <summary> /// 审核/弃审入库单 /// </summary> /// <param name="ID">入库单ID</param> /// <param name="t">真为审核入库,假为弃审出库</param> public void Verify(int ID, bool t, int Depot) { Hownet.BLL.SysTem bllST = new SysTem(); Hownet.Model.SysTem modST = bllST.GetModel(bllST.GetMaxId() - 1); Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.BLL.StockBackInfoList bllSBIL = new StockBackInfoList(); Hownet.BLL.RepertoryList bllRL = new RepertoryList(); List <Hownet.Model.StockBackInfoList> liSBIL; Hownet.Model.RepertoryList modRL; Hownet.Model.Repertory modRep; Hownet.Model.StockBackInfo modSBI; Hownet.Model.StockBack modSB = GetModel(ID); List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + ID + ")").Tables[0]); for (int i = 0; i < li.Count; i++) { if (li[i].StockInfoID > 0) { modSBI = bllSBI.GetModel(li[i].StockInfoID); modSBI.NotAmount -= li[i].Amount; //if (dt.Rows[i]["NeedIsEnd"] != null && dt.Rows[i]["NeedIsEnd"] != DBNull.Value && dt.Rows[i]["NeedIsEnd"].ToString() != string.Empty) // modSBI.IsEnd = Convert.ToInt32(dt.Rows[i]["NeedIsEnd"]); bllSBI.Update(modSBI); } if (li[i].MListID == 0) { modML.BrandID = li[i].BrandID; modML.ColorID = li[i].ColorID; modML.ColorOneID = li[i].ColorOneID; modML.ColorTwoID = li[i].ColorTwoID; modML.SizeID = li[i].SizeID; modML.MaterielID = li[i].MaterielID; modML.MeasureID = li[i].CompanyMeasureID; li[i].MListID = bllML.GetID(modML); bllSBI.Update(li[i]); } liSBIL = bllSBIL.DataTableToList(bllSBIL.GetList("(InfoID=" + li[i].ID + ")").Tables[0]); if (liSBIL.Count > 0) { for (int j = 0; j < liSBIL.Count; j++) { if (t) { liSBIL[j].BatchNumber = li[i].MListID; bllSBIL.Update(liSBIL[j]); modRL = new Hownet.Model.RepertoryList(); modRL.A = 1; modRL.Amount = modRL.NotAmount = liSBIL[j].Amount; modRL.BatchNumber = liSBIL[j].BatchNumber; modRL.DateTime = DateTime.Now; modRL.DepotInfoID = liSBIL[j].DepotInfoID; modRL.DepotInfoName = string.Empty; modRL.ID = 0; modRL.IsEnd = false; modRL.MainID = ID; modRL.Remark = liSBIL[j].Remark; modRL.SpecID = liSBIL[j].SpecID; modRL.SpecName = string.Empty; modRL.StockListID = liSBIL[j].ID; modRL.QRID = liSBIL[j].ID.ToString(); bllRL.Add(modRL); } else { bllRL.DeleteByStockInfoID(liSBIL[j].ID); } } } if ((!modST.MaterielByTask) && (modSB.State != (int)Hownet.BLL.Enums.TableType._采购部收货)) { modRep = new Hownet.Model.Repertory(); modRep.BrandID = li[i].BrandID; modRep.ColorID = li[i].ColorID; modRep.ColorOneID = li[i].ColorOneID; modRep.ColorTwoID = li[i].ColorTwoID; modRep.SizeID = li[i].SizeID; modRep.MaterielID = li[i].MaterielID; modRep.MeasureID = li[i].CompanyMeasureID; modRep.MListID = li[i].MListID; modRep.Amount = li[i].Amount; modRep.DepartmentID = Depot; modRep.Price = li[i].Price; modRep.Money = li[i].Money; bllRep.InOrOut(modRep, t); } if (modSB.State == (int)Hownet.BLL.Enums.TableType._采购部收货) { modRep = new Hownet.Model.Repertory(); modRep.BrandID = li[i].BrandID; modRep.ColorID = li[i].ColorID; modRep.ColorOneID = li[i].ColorOneID; modRep.ColorTwoID = li[i].ColorTwoID; modRep.SizeID = li[i].SizeID; modRep.MaterielID = li[i].MaterielID; modRep.MeasureID = li[i].CompanyMeasureID; modRep.MListID = li[i].MListID; modRep.Amount = li[i].Amount; modRep.DepartmentID = Depot; modRep.Price = li[i].Price; modRep.Money = li[i].Money; bllRep.InOrOut(modRep, t); } } // Hownet.Model.StockBack modSB = GetModel(ID); if (modSB.State == (int)Hownet.BLL.Enums.TableType.P2D) { if (modSB.CompanyID > 0) { Hownet.BLL.Company bllCom = new Company(); Hownet.Model.Company modCom = bllCom.GetModel(modSB.CompanyID); if (t)//收货 { modCom.Weight -= modSB.Weight; } else { modCom.Weight += modSB.Weight; } bllCom.Update(modCom); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.RepertoryList model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.RepertoryList model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.RepertoryList> DataTableToList(DataTable dt) { List <Hownet.Model.RepertoryList> modelList = new List <Hownet.Model.RepertoryList>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.RepertoryList model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.RepertoryList(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } else { model.ID = 0; } if (dt.Rows[n]["Amount"].ToString() != "") { model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString()); } else { model.Amount = 0; } if (dt.Rows[n]["MainID"].ToString() != "") { model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString()); } else { model.MainID = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["NotAmount"].ToString() != "") { model.NotAmount = decimal.Parse(dt.Rows[n]["NotAmount"].ToString()); } else { model.NotAmount = 0; } if (dt.Rows[n]["StockListID"].ToString() != "") { model.StockListID = int.Parse(dt.Rows[n]["StockListID"].ToString()); } else { model.StockListID = 0; } if (dt.Rows[n]["BatchNumber"].ToString() != "") { model.BatchNumber = int.Parse(dt.Rows[n]["BatchNumber"].ToString()); } else { model.BatchNumber = 0; } if (dt.Rows[n]["IsEnd"].ToString() != "") { if ((dt.Rows[n]["IsEnd"].ToString() == "1") || (dt.Rows[n]["IsEnd"].ToString().ToLower() == "true")) { model.IsEnd = true; } else { model.IsEnd = false; } } if (dt.Rows[n]["SpecID"] != null && dt.Rows[n]["SpecID"].ToString() != "") { model.SpecID = int.Parse(dt.Rows[n]["SpecID"].ToString()); } model.SpecName = dt.Rows[n]["SpecName"].ToString(); if (dt.Rows[n]["DepotInfoID"] != null && dt.Rows[n]["DepotInfoID"].ToString() != "") { model.DepotInfoID = int.Parse(dt.Rows[n]["DepotInfoID"].ToString()); } model.DepotInfoName = dt.Rows[n]["DepotInfoName"].ToString(); if (dt.Rows[n]["DateTime"] != null && dt.Rows[n]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(dt.Rows[n]["DateTime"].ToString()); } if (dt.Rows[n]["PlanID"] != null && dt.Rows[n]["PlanID"].ToString() != "") { model.PlanID = int.Parse(dt.Rows[n]["PlanID"].ToString()); } model.QRID = dt.Rows[n]["QRID"].ToString(); model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }