/// <summary>
/// 更新部門資料
/// </summary>
public bool UpdateDepartmentData(DeptParams param)
{
bool result = false;
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
Department entity = empAuthDao.GetEmptyEntity <Department>(new DepartmentRequiredPropValues()
{
DeptId = param.DeptId,
DeptName = ""
});
entity.DeptName = param.DeptName;
entity.SortNo = param.SortNo;
entity.MdfAccount = param.PostAccount;
entity.MdfDate = DateTime.Now;
result = empAuthDao.UpdateDepartmentData(entity);
dbErrMsg = empAuthDao.GetErrMsg();
if (!result && empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2)
{
param.HasDeptNameBeenUsed = true;
}
}
return(result);
}
/// <summary>
/// 新增部門資料
/// </summary>
public bool InsertDepartmentData(DeptParams param)
{
InsertResult insResult = new InsertResult()
{
IsSuccess = false
};
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
Department entity = new Department()
{
DeptName = param.DeptName,
SortNo = param.SortNo,
PostAccount = param.PostAccount,
PostDate = DateTime.Now
};
insResult = empAuthDao.InsertDepartmentData(entity);
dbErrMsg = empAuthDao.GetErrMsg();
if (insResult.IsSuccess)
{
param.DeptId = (int)insResult.NewId;
}
else if (empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2)
{
param.HasDeptNameBeenUsed = true;
}
}
return(insResult.IsSuccess);
}
/// <summary>
/// 新增員工身分資料
/// </summary>
public bool InsertEmployeeRoleData(RoleParams param)
{
InsertResult insResult = new InsertResult()
{
IsSuccess = false
};
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
EmployeeRole entity = new EmployeeRole()
{
RoleName = param.RoleName,
RoleDisplayName = param.RoleDisplayName,
SortNo = param.SortNo,
PostAccount = param.PostAccount,
PostDate = DateTime.Now
};
insResult = empAuthDao.InsertEmployeeRoleData(entity, param.CopyPrivilegeFromRoleName);
dbErrMsg = empAuthDao.GetErrMsg();
if (insResult.IsSuccess)
{
param.RoleId = entity.RoleId;
}
else if (empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2)
{
param.HasRoleBeenUsed = true;
}
}
return(insResult.IsSuccess);
}
/// <summary>
/// 刪除後端作業選項
/// </summary>
public bool DeleteOperationData(OpParams param)
{
bool result = false;
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
result = empAuthDao.DeleteOperationData(param.OpId);
dbErrMsg = empAuthDao.GetErrMsg();
if (!result && empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2)
{
param.IsThereSubitemOfOp = true;
}
}
return(result);
}
/// <summary>
/// 刪除部門資料
/// </summary>
public bool DeleteDepartmentData(DeptParams param)
{
bool result = false;
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
result = empAuthDao.DeleteDepartmentData(param.DeptId);
dbErrMsg = empAuthDao.GetErrMsg();
if (!result && empAuthDao.GetSqlErrNumber() == 50000 && empAuthDao.GetSqlErrState() == 2)
{
param.IsThereAccountsOfDept = true;
}
}
return(result);
}
/// <summary>
/// 新增員工資料
/// </summary>
public bool InsertEmployeeData(AccountParams param)
{
InsertResult insResult = new InsertResult()
{
IsSuccess = false
};
using (EmployeeAuthorityDataAccess empAuthDao = new EmployeeAuthorityDataAccess())
{
insResult = empAuthDao.Insert <Employee>(new Employee()
{
EmpAccount = param.EmpAccount,
EmpPassword = param.EmpPassword,
EmpName = param.EmpName,
Email = param.Email,
Remarks = param.Remarks,
DeptId = param.DeptId,
RoleId = param.RoleId,
IsAccessDenied = param.IsAccessDenied,
StartDate = param.StartDate,
EndDate = param.EndDate,
OwnerAccount = param.OwnerAccount,
PasswordHashed = param.PasswordHashed,
DefaultRandomPassword = param.DefaultRandomPassword,
PostAccount = param.PostAccount,
PostDate = DateTime.Now
});
dbErrMsg = empAuthDao.GetErrMsg();
if (insResult.IsSuccess)
{
param.EmpId = (int)insResult.NewId;
}
else if (empAuthDao.GetSqlErrNumber() == 2601)
{
param.HasAccountBeenUsed = true;
}
}
return(insResult.IsSuccess);
}