// 呼叫service利用departmentID查詢dept資料 public DepartmentPresentationModel SearchDepartmentByID() { DepartmentPresentationModel deptPresentModel = new DepartmentPresentationModel(); if (this._deptModel.GetDepartmentID() == null || _deptModel.GetDepartmentID() == "") { MessageBox.Show("請輸入部門ID"); } else { _deptService = new DepartmentService(this._deptModel); _deptModel = _deptService.searchByDeptID(); deptPresentModel.setDepartmentID(_deptModel.GetDepartmentID()); deptPresentModel.setDepartmentName(_deptModel.GetDepartmentName()); deptPresentModel.setDepartmentStartTime(_deptModel.GetDepartmentStartTime()); deptPresentModel.setDepartmentEndTime(_deptModel.GetDepartmentEndTime()); deptPresentModel.setDepartmentManager(_deptModel.GetDepartmentManager()); if (_deptModel.GetDepartmentName() == null || _deptModel.GetDepartmentName() == "") { MessageBox.Show("此部門ID不存在!"); deptPresentModel.setDepartmentID(null); } } return(deptPresentModel); }
// 修改部門資料至資料庫表單 public Boolean EditDepartment() { if (this.connectToDB()) { try { String addString = String.Format("UPDATE department SET departmentName='" + this._deptModel.GetDepartmentName() + "',departmentStartTime='" + this._deptModel.GetDepartmentStartTime() + "',departmentEndTime='" + this._deptModel.GetDepartmentEndTime() + "',departmentManager='" + _deptModel.GetDepartmentManager() + "' WHERE departmentID='" + this._deptModel.GetDepartmentID() + "';"); MySqlCommand updateCommand = new MySqlCommand(addString, myConnection); updateCommand.Connection = myConnection; updateCommand.ExecuteNonQuery(); } catch (MySqlException ex) { Console.WriteLine("Error " + ex.Number + " : " + ex.Message); return(false); } } this.closeConnection(); return(true); }
public void TestDepartmentManager() { _department.SetDepartmentManager("People"); Assert.AreEqual("People", _department.GetDepartmentManager()); }