public ActionResult PostEdit(LoveBank_AdModel parm) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_m = db.T_Machine; var t_a = db.T_LoveBank_Ad; var t_s = db.T_SourceFile; #region 初始化参数 LoveBank_Ad model = t_a.Find(parm.ID); model.Title = parm.Title; model.Desc = parm.Desc; ///删除原来的,彻底以新增方式进行(修改通过删除在新增实现) var delSourceFile = from s in t_s where s.Guid == model.Guid select s; db.T_SourceFile.RemoveRange(delSourceFile); #endregion db.Update<LoveBank_Ad>(model); db.SaveChanges(); db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定 db.SaveChanges(); return Success("添加成功"); } }
public ActionResult PostAdd(LoveBank_AdModel parm) { #region 初始化参数 LoveBank_Ad model = new LoveBank_Ad(); model.AddTime = DateTime.Now; model.AddUserId = AdminUser.ID; model.State = RowState.有效; model.Guid = Guid.NewGuid().ToString(); model.LinkUrl = parm.LinkUrl; model.MachineCode = parm.MachineCode; model.Title = parm.Title; model.Desc = parm.Desc; foreach (var item in parm.SourceFileList) { item.Guid = model.Guid; item.AddTime = DateTime.Now; } #endregion using (LoveBankDBContext db = new LoveBankDBContext()) { var t_m = db.T_Machine; var mDeptId = from m in t_m where model.MachineCode == m.MachineCode select new { m.DeptId, m.ID }; var tmpObjMachine = mDeptId.SingleOrDefault(); if (tmpObjMachine == null) { return Error("机器唯未授权,请先授权"); } model.DeptId = tmpObjMachine.DeptId.ToString(); model.MachineId = tmpObjMachine.ID; db.Add(model); db.SaveChanges(); db.T_SourceFile.AddRange(parm.SourceFileList); db.SaveChanges(); return Success("添加成功"); } }
public ActionResult PostEdit(LoveBank_AdModel parm) { using (LoveBankDBContext db = new LoveBankDBContext()) { var t_m = db.T_Machine; var t_a = db.T_LoveBank_Ad; var t_s = db.T_SourceFile; #region 初始化参数 LoveBank_Ad model = t_a.Find(parm.ID); model.MachineCode = parm.MachineCode; model.Title = parm.Title; model.Desc = parm.Desc; model.LinkUrl = parm.LinkUrl; ///删除原来的,彻底以新增方式进行(修改通过删除在新增实现) var delSourceFile = from s in t_s where s.Guid == model.Guid select s; db.T_SourceFile.RemoveRange(delSourceFile); db.SaveChanges(); #endregion var mDeptId = from m in t_m where model.MachineCode == m.MachineCode select new { m.DeptId, m.ID }; var tmpObjMachine = mDeptId.SingleOrDefault(); if (tmpObjMachine == null) { return Error("机器唯未授权,请先授权"); } model.DeptId = tmpObjMachine.DeptId.ToString(); model.MachineId = tmpObjMachine.ID; db.Update<LoveBank_Ad>(model); db.SaveChanges(); foreach (var item in parm.SourceFileList) { item.Guid = model.Guid; item.AddTime = DateTime.Now; } db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定 db.SaveChanges(); return Success("修改成功"); } }
public ActionResult PostAdd(LoveBank_AdModel parm) { #region 初始化参数 LoveBank_Ad model = new LoveBank_Ad(); model.AddTime = DateTime.Now; model.AddUserId = AdminUser.ID; model.State = RowState.有效; model.Guid = Guid.NewGuid().ToString(); model.LinkUrl = parm.LinkUrl; model.Postion = parm.Postion; model.Title = parm.Title; model.Desc = parm.Desc; foreach (var item in parm.SourceFileList) { item.Guid = model.Guid; item.AddTime = DateTime.Now; } #endregion using (LoveBankDBContext db = new LoveBankDBContext()) { db.Add(model); db.SaveChanges(); db.T_SourceFile.AddRange(parm.SourceFileList); db.SaveChanges(); return Success("添加成功"); } }