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 });
}
