public ActionResult AddRoleUser(List<int> data, int roleId) { this.Internationalization(); TugDataEntities db = new TugDataEntities(); foreach (int id in data) { System.Linq.Expressions.Expression<Func<UsersRole, bool>> exp = u => u.UserID == id && u.RoleID==roleId; UsersRole tmpUserRole = db.UsersRole.Where(exp).FirstOrDefault(); if(tmpUserRole != null) continue; //判断该用户是否已存在 UsersRole userRole = new UsersRole(); userRole.UserID = id; userRole.RoleID = roleId; userRole.IsAdmin = "否"; userRole.OwnerID = -1; userRole.CreateDate = userRole.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); userRole.AddUserID = Session.GetDataFromSession<int>("userid"); userRole.System = "Role"; userRole.UserDefinedCol1 = Request.Form["UserDefinedCol1"]; userRole.UserDefinedCol2 = Request.Form["UserDefinedCol2"]; userRole.UserDefinedCol3 = Request.Form["UserDefinedCol3"]; userRole.UserDefinedCol4 = Request.Form["UserDefinedCol4"]; if (Request.Form["UserDefinedCol5"] != "") userRole.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]); if (Request.Form["UserDefinedCol6"] != "") userRole.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); if (Request.Form["UserDefinedCol7"] != "") userRole.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); if (Request.Form["UserDefinedCol8"] != "") userRole.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); userRole.UserDefinedCol9 = Request.Form["UserDefinedCol9"]; userRole.UserDefinedCol10 = Request.Form["UserDefinedCol10"]; userRole = db.UsersRole.Add(userRole); db.SaveChanges(); } return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }); }
public ActionResult AddEditRowUser(int rolId) { //this.Internationalization(); #region Add if (Request.Form["oper"].Equals("add")) { try { TugDataEntities db = new TugDataEntities(); { TugDataModel.UsersRole userRole = new UsersRole(); userRole.UserID = Util.toint(Request.Form["UserID"]); userRole.RoleID = rolId; userRole.IsAdmin = Request.Form["IsAdmin"]; userRole.System = "Role"; userRole.CreateDate = userRole.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; userRole.OwnerID = -1; userRole.AddUserID = Session.GetDataFromSession<int>("userid"); userRole.UserDefinedCol1 = Request.Form["UserDefinedCol1"]; userRole.UserDefinedCol2 = Request.Form["UserDefinedCol2"]; userRole.UserDefinedCol3 = Request.Form["UserDefinedCol3"]; userRole.UserDefinedCol4 = Request.Form["UserDefinedCol4"]; if (Request.Form["UserDefinedCol5"] != "") userRole.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]); if (Request.Form["UserDefinedCol6"] != "") userRole.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); if (Request.Form["UserDefinedCol7"] != "") userRole.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); if (Request.Form["UserDefinedCol8"] != "") userRole.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); userRole.UserDefinedCol9 = Request.Form["UserDefinedCol9"]; userRole.UserDefinedCol10 = Request.Form["UserDefinedCol10"]; userRole = db.UsersRole.Add(userRole); db.SaveChanges(); var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret); } } catch (Exception) { var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret); } } #endregion Add #region Edit if (Request.Form["oper"].Equals("edit")) { try { TugDataEntities db = new TugDataEntities(); int idx = Util.toint(Request.Form["IDX"]); UsersRole userRole = db.UsersRole.Where(u => u.IDX == idx).FirstOrDefault(); if (userRole == null) { return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }); } else { userRole.UserID = Util.toint(Request.Form["UserID"]); userRole.RoleID = Util.toint(Request.Form["RoleID"]); userRole.IsAdmin = Request.Form["IsAdmin"]; userRole.System = "Role"; userRole.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; userRole.OwnerID = -1; userRole.AddUserID = Session.GetDataFromSession<int>("userid"); userRole.UserDefinedCol1 = Request.Form["UserDefinedCol1"]; userRole.UserDefinedCol2 = Request.Form["UserDefinedCol2"]; userRole.UserDefinedCol3 = Request.Form["UserDefinedCol3"]; userRole.UserDefinedCol4 = Request.Form["UserDefinedCol4"]; if (Request.Form["UserDefinedCol5"] != "") userRole.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]); if (Request.Form["UserDefinedCol6"] != "") userRole.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); if (Request.Form["UserDefinedCol7"] != "") userRole.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); if (Request.Form["UserDefinedCol8"] != "") userRole.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); userRole.UserDefinedCol9 = Request.Form["UserDefinedCol9"]; userRole.UserDefinedCol10 = Request.Form["UserDefinedCol10"]; db.Entry(userRole).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }); } } catch (Exception exp) { return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }); } } #endregion Edit return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }); }