/// <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 }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.MaterielDemand model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.MaterielDemand model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.MaterielDemand> DataTableToList(DataTable dt) { List <Hownet.Model.MaterielDemand> modelList = new List <Hownet.Model.MaterielDemand>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.MaterielDemand model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.MaterielDemand(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["ProduceTaskID"].ToString() != "") { model.ProduceTaskID = int.Parse(dt.Rows[n]["ProduceTaskID"].ToString()); } if (dt.Rows[n]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].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]["Amount"].ToString() != "") { model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString()); } if (dt.Rows[n]["NotAllotAmount"].ToString() != "") { model.NotAllotAmount = decimal.Parse(dt.Rows[n]["NotAllotAmount"].ToString()); } if (dt.Rows[n]["stockAmount"].ToString() != "") { model.stockAmount = decimal.Parse(dt.Rows[n]["stockAmount"].ToString()); } if (dt.Rows[n]["stockNotAmount"].ToString() != "") { model.stockNotAmount = decimal.Parse(dt.Rows[n]["stockNotAmount"].ToString()); } if (dt.Rows[n]["SizeID"].ToString() != "") { model.SizeID = int.Parse(dt.Rows[n]["SizeID"].ToString()); } if (dt.Rows[n]["MeasureID"].ToString() != "") { model.MeasureID = int.Parse(dt.Rows[n]["MeasureID"].ToString()); } if (dt.Rows[n]["DepID"].ToString() != "") { model.DepID = int.Parse(dt.Rows[n]["DepID"].ToString()); } if (dt.Rows[n]["MListID"].ToString() != "") { model.MListID = int.Parse(dt.Rows[n]["MListID"].ToString()); } if (dt.Rows[n]["TableTypeID"].ToString() != "") { model.TableTypeID = int.Parse(dt.Rows[n]["TableTypeID"].ToString()); } else { model.TableTypeID = 0; } if (dt.Rows[n]["IsEnd"].ToString() != "") { model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString()); } else { model.IsEnd = 0; } if (dt.Rows[n]["RepertoryAmount"].ToString() != "") { model.RepertoryAmount = decimal.Parse(dt.Rows[n]["RepertoryAmount"].ToString()); } else { model.RepertoryAmount = 0; } if (dt.Rows[n]["NeedAmount"].ToString() != "") { model.NeedAmount = decimal.Parse(dt.Rows[n]["NeedAmount"].ToString()); } else { model.NeedAmount = 0; } if (dt.Rows[n]["HasStockAmount"].ToString() != "") { model.HasStockAmount = decimal.Parse(dt.Rows[n]["HasStockAmount"].ToString()); } else { model.HasStockAmount = 0; } if (dt.Rows[n]["OutAmount"].ToString() != "") { model.OutAmount = decimal.Parse(dt.Rows[n]["OutAmount"].ToString()); } else { model.OutAmount = 0; } modelList.Add(model); } } return(modelList); }