/// <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]);
}
}
}
}
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);
}
}