/// <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="userCheckVO"></param>
/// <returns></returns>
public string SaveRoleUserSetting(IEnumerable <UserCheckVO> userCheckVO)
{
string result = string.Empty;
string roleID;
if (userCheckVO != null && userCheckVO.Any())
{
roleID = userCheckVO.First().RoleID.ToString();
List <RoleUserDTO> roleUserDTOs = new List <RoleUserDTO>();
foreach (var item in userCheckVO)
{
RoleUserDTO roleUserDTO = new RoleUserDTO();
roleUserDTO.RoleID = item.RoleID;
roleUserDTO.UserID = item.UserID;
roleUserDTOs.Add(roleUserDTO);
}
SQLConnTran sqlConnTran = _sqlConnectionHelper.BeginTransaction();
int deleteResult = _roleUserRepo.DeleteRoleUserByRoleID(roleID, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
if (deleteResult < 0)
{
_sqlConnectionHelper.Rollback();// tran.Rollback();
result = "刪除失敗。";
return(result);
}
int insertResult = 0;
foreach (var item in roleUserDTOs)
{
insertResult += _roleUserRepo.InsertRoleUser(item, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
}
_sqlConnectionHelper.Commit();
if (insertResult < 0)
{
_sqlConnectionHelper.Rollback();// tran.Rollback();
result = "設定失敗。";
}
}
return(result);
}
/// <summary>
/// 角色編輯使用者
/// 儲存清空使用者時的變更
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public string ClearRoleUserByRoleID(string roleID)
{
string result = string.Empty;
SQLConnTran sqlConnTran = _sqlConnectionHelper.BeginTransaction();
int deleteResult = _roleUserRepo.DeleteRoleUserByRoleID(roleID, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans);
if (deleteResult < 0)
{
_sqlConnectionHelper.Rollback(); //tran.Rollback();
result = "刪除失敗。";
}
_sqlConnectionHelper.Commit(); //tran.Commit();
return(result);
}
