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