/// <summary>
/// 刪除角色
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string DeleteRole(string id)
{
string result = string.Empty;
SQLConnTran sqlConnTran = _sqlConnectionHelper.BeginTransaction();
int deleteRoleUserResult = _roleUserRepo.DeleteRoleUserByRoleID(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
int deleteRoleFunctionResult = _roleFunctionRepo.DeleteRoleFunctionByRoleID(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
int deleteRoleResult = _roleRepo.DeleteRole(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
if (deleteRoleUserResult >= 0 && deleteRoleFunctionResult >= 0 && deleteRoleResult > 0)
{
result = "";
}
else
{
result = "刪除失敗。";
}
_sqlConnectionHelper.Commit(); // tran.Commit();
return(result);
}
/// <summary>
/// 角色編輯功能
/// 儲存勾選功能時的變更
/// </summary>
/// <param name="functionCheckVO"></param>
/// <returns></returns>
public string SaveRoleFunctionSetting(IEnumerable <FunctionCheckVO> functionCheckVO)
{
string result = string.Empty;
string roleID;
if (functionCheckVO != null && functionCheckVO.Any())
{
roleID = functionCheckVO.First().RoleID.ToString();
List <RoleFunctionDTO> roleFunctionDTOs = new List <RoleFunctionDTO>();
foreach (var item in functionCheckVO)
{
RoleFunctionDTO roleFunctionDTO = new RoleFunctionDTO();
roleFunctionDTO.RoleID = item.RoleID;
roleFunctionDTO.FunctionID = item.FunctionID;
roleFunctionDTOs.Add(roleFunctionDTO);
}
var sqlConnTrans = _sqlConnectionHelper.BeginTransaction();
int deleteResult = _roleFunctionRepo.DeleteRoleFunctionByRoleID(roleID, ref sqlConnTrans.SqlConn, ref sqlConnTrans.SqlTrans);
if (deleteResult < 0)
{
_sqlConnectionHelper.Rollback();
result = "刪除失敗。";
return(result);
}
int insertResult = 0;
foreach (var item in roleFunctionDTOs)
{
insertResult += _roleFunctionRepo.InsertRoleFunction(item, ref sqlConnTrans.SqlConn, ref sqlConnTrans.SqlTrans);
}
_sqlConnectionHelper.Commit();
if (insertResult < 0)
{
_sqlConnectionHelper.Rollback();
result = "設定失敗。";
}
}
return(result);
}
