public ActionResult Edit(MrpExPlanItemRate MrpExPlanItemRate) { if (ModelState.IsValid) { this.genericMgr.UpdateWithTrim(MrpExPlanItemRate); SaveSuccessMessage(Resources.MRP.MrpExPlanItemRate.MrpExPlanItemRate_Updated); } return View(MrpExPlanItemRate); }
public ActionResult Edit(string section) { if (string.IsNullOrEmpty(section)) { return HttpNotFound(); } else { MrpExPlanItemRate MrpExPlanItemRate = new MrpExPlanItemRate(); MrpExPlanItemRate.Section = section; MrpExPlanItemRate.SectionDesc = itemMgr.GetCacheItem(section).Description; @ViewBag.Section = section; return View(MrpExPlanItemRate); } }
public JsonResult SaveItemRates(string section, decimal[] ItemRates, string[] Items) { try { if (Items == null || Items.Length == 0) { SaveErrorMessage(Resources.EXT.ControllerLan.Con_LackDetailCanNotUpdatedRate); return Json(null); } IList<MrpExPlanItemRate> MrpExPlanItemRates = this.genericMgr.FindAll<MrpExPlanItemRate>(" from MrpExPlanItemRate as i where i.Section=? ", section); IList<BomDetail> SectionItemLists = this.genericMgr.FindAll<BomDetail>(" from BomDetail as i where i.Item=? ", section); IList<SectionItems> groupProdLineExList = (from l in SectionItemLists group l by new { l.Bom, l.Item } into g select new SectionItems { Section = g.Key.Item, Item = g.Key.Bom }).ToList(); var quey = from c in groupProdLineExList where !(from o in MrpExPlanItemRates select o.Item).Contains(c.Item) select c; if (quey.ToList().Count() > 0) { foreach (var groupProdLineEx in quey) { MrpExPlanItemRate MrpExPlanItemRateNew = new MrpExPlanItemRate(); MrpExPlanItemRateNew.Item = groupProdLineEx.Item; MrpExPlanItemRateNew.Section = groupProdLineEx.Section; MrpExPlanItemRateNew.ItemRate = 0; MrpExPlanItemRateNew.IsNew = true; MrpExPlanItemRates.Add(MrpExPlanItemRateNew); } } for (int i = 0; i < Items.Length; i++) { MrpExPlanItemRate MrpExPlanItemRate = MrpExPlanItemRates.Where(o => o.Item == Items[i]).FirstOrDefault() ?? new MrpExPlanItemRate(); if (!string.IsNullOrWhiteSpace(MrpExPlanItemRate.Item)) { MrpExPlanItemRate.ItemRate = ItemRates[i]; } if (ModelState.IsValid) { if (!MrpExPlanItemRate.IsNew) { this.genericMgr.UpdateWithTrim(MrpExPlanItemRate); //SaveSuccessMessage(MrpExPlanItemRate.Item+"," +Resources.MRP.MrpExPlanItemRate.MrpExPlanItemRate_Updated); } else { this.genericMgr.CreateWithTrim(MrpExPlanItemRate); } } } //object obj = new { newOrder.OrderNo }; return Json(new { SuccessMessages = Resources.EXT.ControllerLan.Con_RateEditSuccessfully }); } catch (Exception ex) { SaveErrorMessage(ex); return Json(null); } }
public ActionResult _SelectSectionDet(string section) { IList<MrpExPlanItemRate> MrpExPlanItemRates = this.genericMgr.FindAll<MrpExPlanItemRate>(" from MrpExPlanItemRate as i where i.Section=? ", section); IList<BomDetail> SectionItemLists = this.genericMgr.FindAll<BomDetail>(" from BomDetail as i where i.Item=? ", section); IList<SectionItems> groupProdLineExList = (from l in SectionItemLists group l by new { l.Bom, l.Item } into g select new SectionItems { Section = g.Key.Item, Item = g.Key.Bom }).ToList(); var quey = from c in MrpExPlanItemRates where !(from o in groupProdLineExList select o.Item).Contains(c.Item) select c; if (quey.ToList().Count() > 0) { foreach (var MrpExPlanItemRate in quey) { this.genericMgr.DeleteById<MrpExPlanItemRate>(MrpExPlanItemRate.Id); MrpExPlanItemRate.IsDeleted = true; } } var quey1 = from c in groupProdLineExList where !(from o in MrpExPlanItemRates select o.Item).Contains(c.Item) select c; if (quey1.ToList().Count() > 0) { foreach (var groupProdLineEx in quey1) { MrpExPlanItemRate MrpExPlanItemRateNew = new MrpExPlanItemRate(); MrpExPlanItemRateNew.Item = groupProdLineEx.Item; MrpExPlanItemRateNew.Section = groupProdLineEx.Section; MrpExPlanItemRateNew.ItemRate = 0; //this.genericMgr.CreateWithTrim(MrpExPlanItemRateNew); MrpExPlanItemRates.Add(MrpExPlanItemRateNew); } } foreach (var MrpExPlanItemRate in MrpExPlanItemRates) { MrpExPlanItemRate.SectionDesc = itemMgr.GetCacheItem(MrpExPlanItemRate.Section).Description; MrpExPlanItemRate.ItemDesc = itemMgr.GetCacheItem(MrpExPlanItemRate.Item).Description; } return View(new GridModel(MrpExPlanItemRates.Where(o => o.IsDeleted == false).OrderBy(p => p.Item))); }