public void Update(Model.Sys.Role entity) { using (IDbConnection conn = SqlString.GetSqlConnection(SqlString.MSSQLString)) { conn.Execute("UPDATE sys_role SET RoleName=@RoleName,ActionIds=@ActionIds WHERE Role_Id =@Role_Id", entity); } }
static void mssql_RoleTest() { try { Console.WriteLine("mssql_RoleTest Test"); mssql_role.Insert(new Model.Sys.Role() { RoleName = "RoleTest1", ActionIds = "" }); mssql_role.Insert(new Model.Sys.Role() { RoleName = "RoleTest2", ActionIds = "" }); mssql_role.Delete("2"); mssql_role.Update(new Model.Sys.Role() { RoleName = "RoleTest2222", ActionIds = "1,2,3", Role_Id = 1 }); Model.Sys.Role re = mssql_role.Find(1); Console.WriteLine("Role_Id:" + re.Role_Id); Console.WriteLine("RoleName:" + re.RoleName); Console.WriteLine("ActionIds:" + re.ActionIds); Console.WriteLine("mssql_RoleTest Ok"); } catch (Exception ex) { Console.WriteLine("mssql_RoleTest Error"); ConsoleError(ex); } }
public ActionResult RoleUpdate(string RoleName, string ActionIds, int Id) { if (string.IsNullOrEmpty(RoleName)) { return(Json(new ResultModel { msg = "角色名为空", pass = false })); } Model.Sys.Role role = this.roleService.Find(Id); if (this.roleService.IsUseName(RoleName.Trim(), role.Role_Id)) { return(Json(new ResultModel { msg = "改角色名正在使用", pass = false })); } role.RoleName = RoleName.Trim(); role.ActionIds = ActionIds; try { this.roleService.Update(role); return(Json(new ResultModel { msg = "修改成功", pass = true })); } catch { return(Json(new ResultModel { msg = "修改失败", pass = false })); } }
public List <Model.Sys.Role> GetAll() { using (IDbConnection conn = SqlString.GetSqlConnection(SqlString.MSSQLString)) { Model.Sys.Role roleTemp = new Model.Sys.Role(); return(conn.Query <Model.Sys.Role>("select a.* from sys_role as a ").ToList()); } }
//IDbConnection conn = new SqlConnection(SqlString.MSSQLString); public bool Insert(Model.Sys.Role entity) { using (IDbConnection conn = SqlString.GetSqlConnection(SqlString.MSSQLString)) { int i = conn.Execute("INSERT INTO sys_role(RoleName,ActionIds)VALUES(@RoleName,@ActionIds)", entity); if (i > 0) { return(true); } else { return(false); } } }
public ActionResult RoleUpdate(string RoleName, string ActionIds, int Id) { Model.Sys.Role maction = new Model.Sys.Role() { RoleName = RoleName, Role_Id = Id, ActionIds = ActionIds }; try { this.roleServer.Update(maction); return(Json(new ResultModel { msg = "修改成功", pass = true })); } catch { return(Json(new ResultModel { msg = "修改失败", pass = false })); } }