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