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