public ActionResult Edit(VM_SyUser_Form m) { if (ModelState.IsValid) { using (var db = new box_omsEntities()) { sys_user dbm = db.sys_user.Find(m.Id); if (dbm.Account != m.Account && db.sys_user.Where(w => w.Account == m.Account).Count() > 0) { ModelState.AddModelError("Account", "帐号已存在。");//帐号已存在 } else { dbm.Account = m.Account; dbm.Name = m.Name; dbm.State = m.State; //先删除然后重新添加 db.sys_user_and_role.RemoveRange(db.sys_user_and_role.Where(_ => _.UserId == dbm.UserId)); if (!string.IsNullOrWhiteSpace(m.ids)) { string[] _ids = m.ids.Split(','); for (int i = 0; i < _ids.Length; i++) { if (string.IsNullOrEmpty(_ids[i])) { continue; } db.sys_user_and_role.Add(new sys_user_and_role() { UserId = dbm.UserId, RoleId = Convert.ToInt32(_ids[i]), CreateTime = DateTime.Now }); } } db.SaveChanges(); return(Json(new { success = true })); } } } return(View(m)); }
public ActionResult Add(VM_SyUser_Form m) { if (ModelState.IsValid) { using (var db = new box_omsEntities()) { if (db.sys_user.Where(w => w.Account == m.Account).Count() > 0) { ModelState.AddModelError("Account", "帐号已存在。");//帐号已存在 } else { sys_user dbm = db.sys_user.Add(new sys_user { Account = m.Account, Password = OMS.Common.Function.MD5Encrypt("123456"), Name = m.Name, State = m.State }); if (!string.IsNullOrWhiteSpace(m.ids)) { string[] _ids = m.ids.Split(','); for (int i = 0; i < _ids.Length; i++) { if (string.IsNullOrWhiteSpace(_ids[i])) { continue; } db.sys_user_and_role.Add(new sys_user_and_role() { UserId = dbm.UserId, RoleId = Convert.ToInt32(_ids[i]), CreateTime = DateTime.Now }); } } db.SaveChanges(); return(Json(new { success = true })); } } } return(View(m)); }
public ActionResult Edit(int id) { using (var db = new box_omsEntities()) { VM_SyUser_Form _m = new VM_SyUser_Form(); sys_user dbm = db.sys_user.Find(id); _m.Id = dbm.UserId; _m.Account = dbm.Account; _m.Name = dbm.Name; _m.State = dbm.State; var _list = db.sys_user_and_role.Where(_ => _.UserId == dbm.UserId).ToList(); if (_list.Count > 0) { foreach (var item in _list) { _m.ids += item.RoleId + ","; } } return(View(_m)); } }