public ActionResult PostEdit(ProductModel parm) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_m = db.T_Product; var t_a = db.T_LoveBank_Ad; var t_s = db.T_SourceFile; #region 初始化参数 Product model = t_m.Find(parm.Id); model.Name = parm.Name; model.Price = parm.Price; model.CostScore = parm.CostScore; model.Count = parm.Count; model.EndTime = parm.EndTime; model.StartTime = parm.StartTime; model.BarCode = parm.BarCode; model.Desc = parm.Desc; model.Type = parm.Type; model.Sponsors = parm.Sponsors; //foreach (var item in parm.SourceFileList) //{ // item.Guid = model.Guid; // item.AddTime = DateTime.Now; //} ///删除原来的,彻底以新增方式进行(修改通过删除在新增实现) var delSourceFile = from s in t_s where (!string.IsNullOrEmpty(model.Guid) && s.Guid == model.Guid) || (!string.IsNullOrEmpty(model.LogoGuid) && s.Guid == model.LogoGuid) || (!string.IsNullOrEmpty(model.AdGuid) && s.Guid == model.AdGuid) select s; db.T_SourceFile.RemoveRange(delSourceFile); db.SaveChanges(); #endregion db.Update<Product>(model); db.SaveChanges(); foreach (var item in parm.SourceFileList) { if (string.IsNullOrEmpty(model.Guid)) { model.Guid = Guid.NewGuid().ToString(); } item.AddTime = DateTime.Now; item.Guid = model.Guid; } foreach (var item in parm.SourceFileListLogo) { if (string.IsNullOrEmpty(model.LogoGuid)) { model.LogoGuid = Guid.NewGuid().ToString(); } item.AddTime = DateTime.Now; item.Guid = model.LogoGuid; } foreach (var item in parm.SourceFileListAd) { if (string.IsNullOrEmpty(model.AdGuid)) { model.AdGuid = Guid.NewGuid().ToString(); } item.AddTime = DateTime.Now; item.Guid = model.AdGuid; } db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定 if (parm.SourceFileListLogo != null &&parm.SourceFileListLogo.Count > 0) { db.T_SourceFile.AddRange(parm.SourceFileListLogo); } if (parm.SourceFileListAd!=null&&parm.SourceFileListAd.Count>0) { db.T_SourceFile.AddRange(parm.SourceFileListAd); } //db.T_SourceFile.AddRange(parm.SourceFileList); db.SaveChanges(); return Success("修改成功"); } }
public ActionResult PostAdd(ProductModel parm) { #region 初始化参数 Product model = new Product(); model.AddTime = DateTime.Now; model.AddUserId = AdminUser.ID; model.State = RowState.有效; //model.Guid = Guid.NewGuid().ToString(); IdWorker workId = new IdWorker(); model.Guid = workId.nextId().ToString(); model.DeptId = AdminUser.DeptId; model.Desc = parm.Desc; model.Name = parm.Name; model.CostScore = parm.CostScore; model.Count = parm.Count; model.EndTime = parm.EndTime; model.StartTime = parm.StartTime; model.Price = parm.Price; model.BarCode = parm.BarCode; model.Type = parm.Type; model.Sponsors = parm.Sponsors; foreach (var item in parm.SourceFileList) { item.Guid = model.Guid; item.AddTime = DateTime.Now; } model.LogoGuid = Guid.NewGuid().ToString(); foreach (var item in parm.SourceFileListLogo) { item.Guid = model.LogoGuid; item.AddTime = DateTime.Now; } model.AdGuid = Guid.NewGuid().ToString(); foreach (var item in parm.SourceFileListAd) { item.Guid = model.AdGuid; item.AddTime = DateTime.Now; } #endregion using (LoveBankDBContext db = new LoveBankDBContext()) { db.Add(model); db.SaveChanges(); db.T_SourceFile.AddRange(parm.SourceFileList); db.T_SourceFile.AddRange(parm.SourceFileListLogo); db.T_SourceFile.AddRange(parm.SourceFileListAd); db.SaveChanges(); return Success("添加成功"); } }