Example #1
0
 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);
     }
 }