public ActionResult AutoMerge(string IDs, string Value) { using (DicMainDb db = new DicMainDb()) { string[] idarr = IDs.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List <int> idlist = new List <int>(); foreach (var id in idarr) { idlist.Add(Int32.Parse(id)); } var list = db.RcsDic.Where(p => idlist.Contains(p.ID)).ToList(); foreach (var t in list) { db.RcsDic.Attach(t); var entity = db.Entry(t); entity.State = System.Data.Entity.EntityState.Deleted; } var defalutTable = db.RcsTable.Where(p => p.Name == "defaultdic").First(); RcsDic newmodel = new RcsDic(); newmodel.Name = list[0].Name; newmodel.Value = Value; newmodel.Type = 1; newmodel.TableID = defalutTable.ID; db.RcsDic.Add(newmodel); db.SaveChanges(); string sql = @"update [dbo].[RcsTable] set Count=( select count(0) from [dbo].[RcsDic] t1 where t1.TableID=[RcsTable].ID )"; db.Database.ExecuteSqlCommand(sql); } return(Json(1)); }
public ActionResult EditAciton(RcsTable t) { using (DicMainDb maindb = new DicMainDb()) { if (t.ID == 0) { maindb.RcsTable.Add(t); } else { maindb.RcsTable.Attach(t); var entity = maindb.Entry(t); entity.State = System.Data.Entity.EntityState.Modified; } maindb.SaveChanges(); } return(Json(new { success = true })); }
public ActionResult EditAciton(RcsDic t) { using (DicMainDb maindb = new DicMainDb()) { if (t.ID == 0) { maindb.RcsDic.Add(t); var table = maindb.RcsTable.Where(p => p.ID == t.TableID).FirstOrDefault(); table.Count = table.Count + 1; } else { maindb.RcsDic.Attach(t); var entity = maindb.Entry(t); entity.State = System.Data.Entity.EntityState.Modified; } maindb.SaveChanges(); } return(Json(new { success = true })); }