public int InsertRole(Sys_RoleEntity _sys_RoleEntity)
{
string sql = "INSERT INTO Sys_Role ( RoleCode, RoleName,Authorities ) VALUES ( @RoleCode,@RoleName,@Authorities)";
using (SqlConnection conn = new SqlConnection(this.SqlConnectionString))
{
conn.Open();
return(conn.Execute(sql, new { RoleCode = _sys_RoleEntity.RoleCode, RoleName = _sys_RoleEntity.RoleName, Authorities = _sys_RoleEntity.Authorities }));
}
}
public int UpdateRole(Sys_RoleEntity _sys_RoleEntity)
{
string sql = "UPDATE Sys_Role SET RoleCode=@RoleCode,RoleName=@RoleName,Authorities=@Authorities WHERE RoleId=@RoleId";
using (var connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
return(connection.Execute(sql, new
{
RoleCode = _sys_RoleEntity.RoleCode,
RoleName = _sys_RoleEntity.RoleName,
RoleId = _sys_RoleEntity.RoleId,
Authorities = _sys_RoleEntity.Authorities
}));
}
}
public IActionResult Edit([FromForm] Sys_RoleEntity entity)
{
//判断是否存在维护的code
var _tempentity = _roleService.GetSys_RoleEntity(entity.RoleCode);
//修改操作
if (entity.RoleId > 0)
{
if (_tempentity == null || _tempentity.RoleId == entity.RoleId)
{
if (_roleService.UpdateRole(entity) > 0)
{
ViewData["Status"] = 1;
}
else
{
ViewData["Status"] = -2;
}
}
else
{
//已存在rolecode
ViewData["Status"] = -1;
}
}
else
{
if (_tempentity == null)
{
//新增
_roleService.InsertRole(entity);
ViewData["Status"] = 1;
}
else
{
//已存在rolecode
ViewData["Status"] = -1;
}
}
return(View());
}
