/// <summary> /// 审核/弃审入库单 /// </summary> /// <param name="ID">入库单ID</param> /// <param name="t">真为审核出库,假为弃审入库</param> public bool CheckIsOK(int ID, bool t, int Depot) { bool _isOK = true; Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); Hownet.BLL.ProduceSellOne blPSO = new ProduceSellOne(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); List <Hownet.Model.ProduceSellOne> li = blPSO.DataTableToList(blPSO.GetList("(MainID=" + ID + ")").Tables[0]); modRep.DepartmentID = Depot; for (int i = 0; i < li.Count; i++) { modRep.BrandID = modML.BrandID = li[i].BrandID; modRep.ColorID = modML.ColorID = 0; modRep.ColorOneID = modML.ColorOneID = 0; modRep.ColorTwoID = modML.ColorTwoID = 0; modRep.SizeID = modML.SizeID = 0; modRep.MaterielID = modML.MaterielID = li[i].MaterielID; modRep.MeasureID = modML.MeasureID = li[i].MeasureID; modRep.MListID = bllML.GetID(modML); if (bllRep.GetAmountByModel(modRep) < li[i].Amount) { _isOK = false; break; } } return(_isOK); }
/// <summary> /// 当生产计划被标记为完成等状态时,更新该生产计划库存数量到空闲库存 /// </summary> /// <param name="MainID"></param> public void UpPlanMD(int MainID) { Hownet.BLL.Repertory bllRep = new Repertory(); List <Hownet.Model.Repertory> li = bllRep.DataTableToList(bllRep.GetList("(PlanID=" + MainID + ")").Tables[0]); List <Hownet.Model.Repertory> ll; Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); if (li.Count > 0) { for (int i = 0; i < li.Count; i++) { if (li[i].Amount > 0) { ll = bllRep.DataTableToList(bllRep.GetList("(PlanID=0) And (DepartmentID=" + li[i].DepartmentID + ") And (MListID=" + li[i].MListID + ")").Tables[0]); if (ll.Count > 0) { ll[0].Amount += li[i].Amount; bllRep.Update(ll[0]); } else { modRep = bllRep.GetModel(li[i].ID); modRep.PlanID = 0; bllRep.Add(modRep); } li[i].Amount = 0; bllRep.Update(li[i]); } } } }
/// <summary> /// 将库存某物料的一些数量,标记为某生产计划单所使用,并在生产计划单的已有库存中,增加该数量 /// </summary> /// <param name="ID">库存ID</param> /// <param name="DemandID">物料计划表ID</param> /// <param name="TaskID">生产计划单ID</param> /// <param name="Amount">变更数量</param> /// <param name="DepotID">仓库</param> /// <param name="MListID">物料</param> public void UpTaskUseRepertoryAmount(byte[] bb, int DepotID) { DataSet ds = BaseFile.ZipDt.Byte2Ds(bb); if (ds.Tables[0].Rows.Count > 0) { Hownet.BLL.PlanUseRep bllPUR = new PlanUseRep(); List <Hownet.Model.PlanUseRep> liPUR = bllPUR.DataTableToList(ds.Tables[0]); Hownet.Model.Repertory modRep; Hownet.BLL.MaterielDemand bllMD = new MaterielDemand(); Hownet.Model.MaterielDemand modMD; for (int i = 0; i < liPUR.Count; i++) { if (liPUR[i].A == 1) { modRep = GetModel(liPUR[i].RelatedID); modMD = bllMD.GetModel(liPUR[i].DemandID); modRep.Amount -= liPUR[i].Amount;//扣减以前的数量 Update(modRep); List <Hownet.Model.Repertory> lirep = GetModelList("(PlanID=" + liPUR[i].TaskID + ") And (MListID=" + liPUR[i].MListID + ") And (DepartmentID=" + DepotID + ")"); if (lirep.Count == 0)//查找是否有需要转入的记录,没有就以变更数量插入记录 { modRep = new Hownet.Model.Repertory(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = bllML.GetModel(liPUR[i].MListID); modRep.MListID = liPUR[i].MListID; modRep.Amount = liPUR[i].Amount; modRep.MeasureID = modML.MeasureID; modRep.DepartmentID = DepotID; modRep.MaterielID = modML.MaterielID; modRep.ColorID = modML.ColorID; modRep.ColorOneID = modML.ColorOneID; modRep.ColorTwoID = modML.ColorTwoID; modRep.SizeID = modML.SizeID; modRep.BrandID = modML.BrandID; modRep.CompanyID = 0; modRep.PlanID = liPUR[i].TaskID; Add(modRep); } else//有记录则加上该数量 { lirep[0].Amount += liPUR[i].Amount; Update(lirep[0]); } bllMD.Update(modMD); } } } }
/// <summary> /// 采购退货审核 /// </summary> /// <param name="MainID"></param> /// <param name="t">真为入库,假为出库</param> public void VerifyBack(int MainID, bool t) { try { Hownet.BLL.StockBack bllSB = new StockBack(); Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo(); Hownet.Model.StockBack modSB = bllSB.GetModel(MainID); Hownet.Model.StockBackInfo modSBI = new Hownet.Model.StockBackInfo(); List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + MainID + ")").Tables[0]); if (li.Count > 0) { Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); for (int i = 0; i < li.Count; i++) { if (li[i].DemandID > 0) { modRep = GetModel(li[i].DemandID); modRep.Amount = li[i].Amount; InOrOut(modRep, t); } if (li[i].StockInfoID > 0) { modSBI = bllSBI.GetModel(li[i].StockInfoID); if (!t) { modSBI.NotAmount += li[i].Amount; modSBI.NotPriceAmount += li[i].Amount; } else { modSBI.NotAmount -= li[i].Amount; modSBI.NotPriceAmount -= li[i].Amount; } bllSBI.Update(modSBI); } } } } catch (Exception ex) { } }
/// <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> /// <param name="ID">入库单ID</param> /// <param name="t">真为审核出库,假为弃审入库</param> public void VerifyProcess(int ID, bool t, int Depot) { Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); Hownet.BLL.ProduceSellOne blPSO = new ProduceSellOne(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); List <Hownet.Model.ProduceSellOne> li = blPSO.DataTableToList(blPSO.GetList("(MainID=" + ID + ")").Tables[0]); modRep.DepartmentID = Depot; for (int i = 0; i < li.Count; i++) { modRep.BrandID = modML.BrandID = li[i].BrandID; modRep.ColorID = modML.ColorID = 0; modRep.ColorOneID = modML.ColorOneID = 0; modRep.ColorTwoID = modML.ColorTwoID = 0; modRep.SizeID = modML.SizeID = 0; modRep.MaterielID = modML.MaterielID = li[i].MaterielID; modRep.Amount = li[i].Amount; modRep.MeasureID = modML.MeasureID = li[i].MeasureID; modRep.MListID = bllML.GetID(modML); bllRep.InOrOut(modRep, !t); } }
/// <summary> /// 审核/弃审入库单 /// </summary> /// <param name="ID">入库单ID</param> /// <param name="t">真为审核出库,假为弃审入库</param> public void Verify(int ID, bool t, int Depot) { Hownet.BLL.ProduceSellInfo bllPSI = new ProduceSellInfo(); Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.BLL.RepertoryList bllRL = new RepertoryList(); Hownet.Model.RepertoryList modRL = new Model.RepertoryList(); //Hownet.BLL.Measure bllMea = new Measure(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); List <Hownet.Model.ProduceSellInfo> li = bllPSI.DataTableToList(bllPSI.GetList("(MainID=" + ID + ")").Tables[0]); Hownet.BLL.AmountInfo bllAI = new AmountInfo(); Hownet.Model.AmountInfo modAI; Hownet.BLL.OtherType bllOT = new OtherType(); DataTable dtOT = bllOT.GetList("(Name='仓储单位')").Tables[0]; int measureid = 0; if (dtOT.Rows.Count > 0) { measureid = Convert.ToInt32(dtOT.Rows[0]["Value"]); } //DataTable dt = bllMea.GetList("(Name='件')").Tables[0]; //if (dt.Rows.Count > 0) // modRep.MeasureID = int.Parse(dt.Rows[0]["ID"].ToString()); //else // modRep.MeasureID = 0; for (int i = 0; i < li.Count; i++) { try { modAI = bllAI.GetModel(li[i].SalesInfoID); modRep.BrandID = modML.BrandID = li[i].BrandID; modRep.ColorID = modML.ColorID = li[i].ColorID; modRep.ColorOneID = modML.ColorOneID = li[i].ColorOneID; modRep.ColorTwoID = modML.ColorTwoID = li[i].ColorTwoID; modRep.SizeID = modML.SizeID = li[i].SizeID; if (measureid > 0) { modRep.MeasureID = modML.MeasureID = measureid; } else { modRep.MeasureID = modML.MeasureID = li[i].MeasureID; } modRep.MaterielID = modML.MaterielID = li[i].MaterielID; modRep.Amount = li[i].Amount; modRep.DepartmentID = Depot; if (li[i].MListID == 0) { modRep.MListID = li[i].MListID = bllML.GetID(modML); bllPSI.Update(li[i]); } else { modRep.MListID = li[i].MListID; } if (li[i].RepertoryID == 0) { if (Depot > 0) { bllRep.InOrOut(modRep, !t); } } if (li[i].RepertoryID > 0) { modRep = bllRep.GetModel(li[i].RepertoryID); if (t) { modRep.Amount -= li[i].Amount; } else { modRep.Amount += li[i].Amount; } bllRep.Update(modRep); } if (li[i].RepertoryListID > 0) { modRL = bllRL.GetModel(li[i].RepertoryListID); if (t) { modRL.Amount -= li[i].Amount; } else { modRL.Amount += li[i].Amount; } bllRL.Update(modRL); } if (modAI != null) { modAI.NotAmount = Convert.ToInt32(li[i].Amount); bllAI.UpNotAmount(modAI, t); } } catch (Exception ex) { } } }
public int MDPP(int MainID) { try { Hownet.BLL.MaterielDemand bllMD = new MaterielDemand(); Hownet.BLL.Repertory bllRep = new Repertory(); DataTable dt = dal.GetPPMDList(MainID).Tables[0]; List <Hownet.Model.MaterielDemand> li = bllMD.DataTableToList(bllMD.GetList("(ProduceTaskID=" + MainID + ") And (TableTypeID=41)").Tables[0]); for (int i = 0; i < li.Count; i++) { for (int j = 0; j < dt.Rows.Count; j++) { if (li[i].MListID == Convert.ToInt32(dt.Rows[j]["MListID"])) { li[i].RepertoryAmount += Convert.ToDecimal(dt.Rows[j]["RepertoryAmount"]); bllMD.Update(li[i]); break; } } } dal.UpPPMDList(MainID); List <Hownet.Model.Repertory> liRe = bllRep.DataTableToList(bllRep.GetList("(PlanID=" + MainID + ")").Tables[0]); DataTable dtRep = bllRep.GetPPList(MainID).Tables[0]; Hownet.Model.Repertory modRe = new Hownet.Model.Repertory(); bool t = false; for (int i = 0; i < dtRep.Rows.Count; i++) { t = false; for (int j = 0; j < liRe.Count; j++) { if (liRe[j].MListID == Convert.ToInt32(dtRep.Rows[i]["MListID"]) && liRe[j].DepartmentID == Convert.ToInt32(dtRep.Rows[i]["DepartmentID"])) { liRe[j].Amount += Convert.ToDecimal(dtRep.Rows[i]["Amount"]); t = true; break; } } if (!t) { modRe = new Hownet.Model.Repertory(); modRe.A = 3; modRe.Amount = Convert.ToDecimal(dtRep.Rows[i]["Amount"]); modRe.BrandID = Convert.ToInt32(dtRep.Rows[i]["BrandID"]); modRe.ColorID = Convert.ToInt32(dtRep.Rows[i]["ColorID"]); modRe.ColorOneID = Convert.ToInt32(dtRep.Rows[i]["ColorOneID"]); modRe.ColorTwoID = Convert.ToInt32(dtRep.Rows[i]["ColorTwoID"]); modRe.CompanyID = 0; modRe.DepartmentID = Convert.ToInt32(dtRep.Rows[i]["DepartmentID"]); modRe.ID = 0; modRe.MaterielID = Convert.ToInt32(dtRep.Rows[i]["MaterielID"]); modRe.MeasureID = Convert.ToInt32(dtRep.Rows[i]["MeasureID"]); modRe.MListID = Convert.ToInt32(dtRep.Rows[i]["MListID"]); modRe.PlanID = MainID; modRe.Remark = string.Empty; modRe.SizeID = Convert.ToInt32(dtRep.Rows[i]["SizeID"]); modRe.ID = bllRep.Add(modRe); liRe.Add(modRe); } } bllRep.DelPPList(MainID); return(1); } catch { return(0); } }
public void Verify(int MainID, bool IsVerify) { Hownet.BLL.Pack2DepotMain bllPDM = new Pack2DepotMain(); Hownet.Model.Pack2DepotMain modPDM = bllPDM.GetModel(MainID); List <Hownet.Model.Pack2DepotInfo> li = DataTableToList(GetList("(MainID=" + MainID + ")").Tables[0]); Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.BLL.PackAmount bllPA = new PackAmount(); Hownet.BLL.RepertoryList bllRL = new RepertoryList(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Model.MaterielList(); Hownet.Model.RepertoryList modRL = new Model.RepertoryList(); DataTable dtRL = new DataTable(); Hownet.Model.PackAmount modPA = new Hownet.Model.PackAmount(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); modRep.BrandName = modRep.ColorName = modRep.ColorOneName = modRep.ColorTwoName = modRep.CompanyName = modRep.DeparmentName = modRep.DepotInfoName = modRep.MaterielName = modRep.MeasureName = modRep.Remark = modRep.SizeName = modRep.SpecName = modRep.SupplierName = modRep.SupplierSN = string.Empty; Hownet.BLL.OtherType bllOT = new Hownet.BLL.OtherType(); DataTable dtOT = bllOT.GetTypeList("成品单位").Tables[0]; decimal one = 1; decimal two = 1; int dM = 0; if (dtOT.Rows.Count > 0) { one = Convert.ToDecimal(dtOT.Select("(Name='车间换算')")[0]["Value"]); two = Convert.ToDecimal(dtOT.Select("(Name='仓储换算')")[0]["Value"]); dM = Convert.ToInt32(dtOT.Select("(Name='仓储单位')")[0]["Value"]); } try { for (int i = 0; i < li.Count; i++) { modPA = bllPA.GetModel(li[i].PackAmountID); if (IsVerify) { if (one > 1 || two > 1) { if (one > 0) { modPA.Amount -= ((int)(li[i].NowAmount * two / one)); } } else { modPA.Amount -= li[i].NowAmount; } if (modPA.Amount < 0) { modPA.Amount = 0; } } else { if (one > 1 || two > 1) { if (one > 0) { modPA.Amount += ((int)(li[i].NowAmount * two / one)); } } else { modPA.Amount += li[i].NowAmount; } } bllPA.Update(modPA); modRep = new Hownet.Model.Repertory(); modRep.BrandName = modRep.ColorName = modRep.ColorOneName = modRep.ColorTwoName = modRep.CompanyName = modRep.DeparmentName = modRep.DepotInfoName = modRep.MaterielName = modRep.MeasureName = modRep.Remark = modRep.SizeName = modRep.SpecName = modRep.SupplierName = modRep.SupplierSN = string.Empty; modRep.DepartmentID = modPDM.DepotID; modRep.BrandID = modML.BrandID = li[i].BrandID; modRep.ColorID = modML.ColorID = li[i].ColorID; modRep.ColorOneID = modML.ColorOneID = li[i].ColorOneID; modRep.ColorTwoID = modML.ColorTwoID = li[i].ColorTwoID; modRep.SizeID = modML.SizeID = li[i].SizeID; modRep.MaterielID = modML.MaterielID = li[i].MaterielID; if (dM > 0) { modRep.MeasureID = dM; } else { modRep.MeasureID = li[i].MeasureID; } modML.MeasureID = modRep.MeasureID; modRep.Amount = li[i].NowAmount; modRep.MListID = li[i].MListID; if (li[i].DepotBrandID > 0) { modRep.BrandID = modML.BrandID = li[i].DepotBrandID; modRep.MListID = bllML.GetID(modML); } modRep.ID = bllRep.InOrOut(modRep, IsVerify); if (li[i].DepotInfoID > 0) { dtRL = bllRL.GetList("(BatchNumber=" + li[i].MListID + ") And (DepotInfoID=" + li[i].DepotInfoID + ")").Tables[0]; if (dtRL.Rows.Count == 0) { if (IsVerify) { modRL = new Model.RepertoryList(); modRL.A = 1; modRL.NotAmount = modRL.Amount = li[i].NowAmount; modRL.BatchNumber = li[i].MListID; modRL.DateTime = DateTime.Now; modRL.DepotInfoID = li[i].DepotInfoID; modRL.DepotInfoName = string.Empty; modRL.ID = 0; modRL.IsEnd = false; modRL.MainID = modRep.ID; modRL.PlanID = 0; modRL.QRID = li[i].MListID.ToString(); modRL.Remark = string.Empty; modRL.SpecID = 0; modRL.SpecName = string.Empty; modRL.StockListID = 0; bllRL.Add(modRL); } } else if (dtRL.Rows.Count == 1) { modRL = bllRL.GetModel(Convert.ToInt32(dtRL.Rows[0]["ID"])); if (IsVerify) { modRL.Amount += li[i].NowAmount; } else { modRL.Amount -= li[i].NowAmount; } bllRL.Update(modRL); } else if (dtRL.Rows.Count > 1) { List <Hownet.Model.RepertoryList> liRL = bllRL.DataTableToList(dtRL); for (int j = 1; j < liRL.Count; j++) { liRL[0].Amount += liRL[j].Amount; bllRL.Delete(liRL[j].ID); } if (IsVerify) { liRL[0].Amount += li[i].NowAmount; } else { liRL[0].Amount -= li[i].NowAmount; } bllRL.Update(liRL[0]); } } } if (!IsVerify) { modPDM.IsVerify = 1; modPDM.VerifyDate = Convert.ToDateTime("1900-1-1"); modPDM.VerifyMan = 0; bllPDM.Update(modPDM); } } catch (Exception ex) { } }
/// <summary> /// 审核外协来料单 /// </summary> /// <param name="MainID"></param> /// <param name="IsVerify"></param> /// <param name="VerifyManID"></param> /// <returns></returns> public int VerifyWXIn(int MainID, bool IsVerify, int VerifyManID) { try { Hownet.Model.StockBack modSB = GetModel(MainID); if (IsVerify) { modSB.IsVerify = 3; modSB.VerifyDate = DateTime.Now; modSB.VerifyMan = VerifyManID; } else { modSB.IsVerify = 1; modSB.VerifyDate = Convert.ToDateTime("1900-1-1"); modSB.VerifyMan = 0; } Update(modSB); Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); Hownet.Model.StockBackInfo modSBI; List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + modSB.ID + ")").Tables[0]); Hownet.BLL.Repertory bllR = new Repertory(); Hownet.Model.Repertory modR; if (li.Count > 0) { for (int i = 0; i < li.Count; i++) { if (li[i].StockInfoID > 0) { modSBI = bllSBI.GetModel(li[i].StockInfoID); if (IsVerify) { modSBI.NotPriceAmount += li[i].Amount; modSBI.NotAmount -= li[i].Amount; } else { modSBI.NotPriceAmount -= li[i].Amount; modSBI.NotAmount += li[i].Amount; } li[i].NotPriceAmount = modSBI.NotPriceAmount; li[i].NotAmount = modSBI.NotAmount; bllSBI.Update(li[i]); 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; modML.SpecID = 0; li[i].MListID = bllML.GetID(modML); bllSBI.Update(li[i]); } modR = new Hownet.Model.Repertory(); modR.Amount = li[i].Amount; modR.MListID = li[i].MListID; modR.MeasureID = li[i].CompanyMeasureID; modR.DepartmentID = modSB.DepotID; modR.BrandID = li[i].BrandID; modR.BrandName = li[i].BrandName; modR.ColorID = li[i].ColorID; modR.ColorName = li[i].ColorName; modR.ColorOneID = li[i].ColorOneID; modR.ColorOneName = li[i].ColorOneName; modR.ColorTwoID = li[i].ColorTwoID; modR.ColorTwoName = li[i].ColorTwoName; modR.CompanyID = li[i].CompanyID; modR.CompanyName = string.Empty; modR.DeparmentName = string.Empty; modR.DepartmentID = modSB.DepotID; modR.DepotInfoID = 0; modR.DepotInfoName = string.Empty; modR.ID = 0; modR.MaterielID = li[i].MaterielID; modR.MaterielName = li[i].MaterielName; modR.MeasureName = string.Empty; modR.PlanID = 0; modR.Remark = string.Empty; modR.SizeID = li[i].SizeID; modR.SizeName = li[i].SizeName; modR.SpecID = li[i].SpecID; modR.SpecName = li[i].SpecName; modR.SupplierID = 0; modR.SupplierName = string.Empty; modR.SupplierSN = string.Empty; bllR.InOrOut(modR, IsVerify); } } return(1); } catch (Exception ex) { return(0); } }
public decimal GetAmountByModel(Hownet.Model.Repertory model) { return(dal.GetAmountByModel(model)); }
/// <summary> /// /// </summary> /// <param name="MListID"></param> /// <param name="DemandID"></param> /// <param name="StockInfoID"></param> /// <param name="Amount"></param> /// <param name="TypeID"></param> /// <param name="TaskID"></param> /// <param name="RelatedID"></param> /// <param name="t">真的添加记录,假为删除记录</param> public void UpAmount(int MListID, int DemandID, int StockInfoID, decimal Amount, int TypeID, int TaskID, int RelatedID, bool t, int DepotID) { #region 使用原仓存 if (TypeID == (int)Hownet.BLL.BaseFile.MaterielDemandClass.PlanUseRep.使用原仓存) { if (t) { //查看之前使用库存的记录,将本次使用原仓存的数更新到数据表。 Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.BLL.MaterielDemand bllMD = new MaterielDemand(); Hownet.Model.Repertory modRep = bllRep.GetModel(RelatedID); //需要转出的空闲物料 Hownet.Model.MaterielDemand modMD = bllMD.GetModel(DemandID); modRep.Amount = modRep.Amount - Amount; //扣掉有使用的空余数量 bllRep.Update(modRep); modMD.RepertoryAmount += Amount; //更新物料拆分表的已备料数量 bllMD.Update(modMD); //是否此前有本计划单的备料 DataTable dt = bllRep.GetList("(MListID=" + MListID + ") And (PlanID=" + TaskID + ") And (DepartmentID=" + DepotID + ")").Tables[0]; if (dt.Rows.Count > 0) { //已有,则加上本次数量 dt.Rows[0]["Amount"] = Convert.ToDecimal(dt.Rows[0]["Amount"]) + Amount; bllRep.UpdateByDt(dt); } else { //没有则插入此数量 modRep.Amount = Amount; modRep.PlanID = TaskID; modRep.DepartmentID = DepotID; bllRep.Add(modRep); } } else { } } #endregion #region 已申购数量 else if (TypeID == (int)Hownet.BLL.BaseFile.MaterielDemandClass.PlanUseRep.已申购数量) { if (t) { //更新这个生产计划中该物料的已申购数量 DataTable dt = GetList("(StockInfoID=" + StockInfoID + ") And (TypeID=" + (int)Hownet.BLL.BaseFile.MaterielDemandClass.PlanUseRep.已申购数量 + ")").Tables[0]; if (dt.Rows.Count > 0) { dt.Rows[0]["Amount"] = Convert.ToDecimal(dt.Rows[0]["Amount"]) + Amount; dt.Rows[0]["NotAmount"] = Convert.ToDecimal(dt.Rows[0]["NotAmount"]) + Amount; UpdateByDt(dt); } else { DataRow dr = dt.NewRow(); dr["RelatedID"] = RelatedID; dr["Amount"] = Amount; dr["DemandID"] = DemandID; dr["TypeID"] = (int)Hownet.BLL.BaseFile.MaterielDemandClass.PlanUseRep.已申购数量; dr["MListID"] = MListID; dr["TaskID"] = TaskID; dr["StockInfoID"] = 0; dr["NotAmount"] = Amount; dr["IsEnd"] = 0; dr["A"] = 1; dt.Rows.Add(dr); AddByDt(dt); } } else { } } #endregion #region 已采购数量 else if (TypeID == (int)BLL.BaseFile.MaterielDemandClass.PlanUseRep.已采购数量) { } #endregion }
/// <param name="t">真为审核入库,假为弃审出库</param> public bool VerifyStock(int MainID, int PackID, bool t, int VerifyMan) { try { Hownet.BLL.StockBack bllSB = new StockBack(); Hownet.BLL.StockBackInfo bllSBI = new StockBackInfo(); Hownet.BLL.Repertory bllRep = new Repertory(); Hownet.BLL.Deparment bllDep = new Deparment(); Hownet.BLL.PackAmount bllPA = new PackAmount(); Hownet.BLL.MaterielList bllML = new MaterielList(); Hownet.BLL.Materiel bllMat = new Materiel(); Hownet.Model.PackAmount modPA = new Hownet.Model.PackAmount(); Hownet.Model.MaterielList modML = new Hownet.Model.MaterielList(); Hownet.Model.StockBack modSB = bllSB.GetModel(MainID); Hownet.Model.StockBackInfo modSBI = new Hownet.Model.StockBackInfo(); Hownet.Model.Repertory modRep = new Hownet.Model.Repertory(); Hownet.Model.Deparment modDep = bllDep.GetModel(PackID); List <Hownet.Model.StockBackInfo> li = bllSBI.DataTableToList(bllSBI.GetList("(MainID=" + MainID + ")").Tables[0]); modPA.DepartmentID = PackID; for (int i = 0; i < li.Count; i++) { modRep.BrandID = modPA.BrandID = modML.BrandID = li[i].BrandID; modRep.ColorID = modPA.ColorID = modML.ColorID = li[i].ColorID; modRep.ColorOneID = modPA.ColorOneID = modML.ColorOneID = li[i].ColorOneID; modRep.ColorTwoID = modPA.ColorTwoID = modML.ColorTwoID = li[i].ColorTwoID; modRep.SizeID = modPA.SizeID = modML.SizeID = li[i].SizeID; modRep.MaterielID = modPA.MaterielID = modML.MaterielID = li[i].MaterielID; modRep.MeasureID = modPA.MeasureID = modML.MeasureID = bllMat.GetModel(li[i].MaterielID).MeasureID; modRep.PlanID = modPA.PlanID = 0; modRep.Remark = modPA.Remark = string.Empty; modRep.DepartmentID = modPA.DepartmentID = modSB.DepotID; modRep.Amount = modPA.Amount = li[i].Amount; modSBI = bllSBI.GetModel(li[i].StockInfoID); if (modSBI != null) { if (t) { modSBI.NotAmount -= li[i].Amount; } else { modSBI.NotAmount += li[i].Amount; } bllSBI.Update(modSBI); } if (li[i].MListID == 0) { modRep.MListID = modPA.MListID = li[i].MListID = bllML.GetID(modML); bllSBI.Update(li[i]); } else { modRep.MListID = modPA.MListID = li[i].MListID; } if (modDep.TypeID == 39) { bllPA.InOrOut(modPA, t); } else if (modDep.TypeID == 42) { bllRep.InOrOut(modRep, t); } } if (t) { modSB.IsVerify = 3; modSB.VerifyDate = DateTime.Today; modSB.VerifyMan = VerifyMan; } else { modSB.IsVerify = 1; modSB.VerifyDate = DateTime.Parse("1900-1-1"); modSB.VerifyMan = 0; } bllSB.Update(modSB); return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.Repertory model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.Repertory model) { return(dal.Add(model)); }
/// <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 List <Hownet.Model.Repertory> DataTableToList(DataTable dt) { List <Hownet.Model.Repertory> modelList = new List <Hownet.Model.Repertory>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.Repertory model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.Repertory(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["MListID"].ToString() != "") { model.MListID = int.Parse(dt.Rows[n]["MListID"].ToString()); } if (dt.Rows[n]["Amount"].ToString() != "") { model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString()); } if (dt.Rows[n]["MeasureID"].ToString() != "") { model.MeasureID = int.Parse(dt.Rows[n]["MeasureID"].ToString()); } if (dt.Rows[n]["DepartmentID"].ToString() != "") { model.DepartmentID = int.Parse(dt.Rows[n]["DepartmentID"].ToString()); } if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString()); } if (dt.Rows[n]["SizeID"].ToString() != "") { model.SizeID = int.Parse(dt.Rows[n]["SizeID"].ToString()); } if (dt.Rows[n]["ColorID"].ToString() != "") { model.ColorID = int.Parse(dt.Rows[n]["ColorID"].ToString()); } if (dt.Rows[n]["ColorOneID"].ToString() != "") { model.ColorOneID = int.Parse(dt.Rows[n]["ColorOneID"].ToString()); } if (dt.Rows[n]["ColorTwoID"].ToString() != "") { model.ColorTwoID = int.Parse(dt.Rows[n]["ColorTwoID"].ToString()); } if (dt.Rows[n]["BrandID"].ToString() != "") { model.BrandID = int.Parse(dt.Rows[n]["BrandID"].ToString()); } if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } else { model.CompanyID = 0; } if (dt.Rows[n]["PlanID"].ToString() != "") { model.PlanID = int.Parse(dt.Rows[n]["PlanID"].ToString()); } else { model.PlanID = 0; } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["SupplierID"] != null && dt.Rows[n]["SupplierID"].ToString() != "") { model.SupplierID = int.Parse(dt.Rows[n]["SupplierID"].ToString()); } model.SupplierName = dt.Rows[n]["SupplierName"].ToString(); model.SupplierSN = dt.Rows[n]["SupplierSN"].ToString(); 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(); model.MaterielName = dt.Rows[n]["MaterielName"].ToString(); model.ColorName = dt.Rows[n]["ColorName"].ToString(); model.SizeName = dt.Rows[n]["SizeName"].ToString(); model.ColorOneName = dt.Rows[n]["ColorOneName"].ToString(); model.ColorTwoName = dt.Rows[n]["ColorTwoName"].ToString(); model.BrandName = dt.Rows[n]["BrandName"].ToString(); model.CompanyName = dt.Rows[n]["CompanyName"].ToString(); model.MeasureName = dt.Rows[n]["MeasureName"].ToString(); model.DeparmentName = dt.Rows[n]["DeparmentName"].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]["Price"] != null && dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["Money"] != null && dt.Rows[n]["Money"].ToString() != "") { model.Money = decimal.Parse(dt.Rows[n]["Money"].ToString()); } model.A = int.Parse(dt.Rows[n]["A"].ToString()); modelList.Add(model); } } return(modelList); }