// 取得所有員工資料
private List<EmployeeModel> GetAllEmplDate()
{
List<EmployeeModel> emplList = new List<EmployeeModel>();
EmployeeModel emplModel = new EmployeeModel();
EmployeeService emplService = new EmployeeService(emplModel);
emplList = emplService.GetAllEmplData();
return emplList;
}
// 判斷員工ID是否存在
private Boolean JudgeEmplIDIsExist()
{
String emplID = this._workAttendanceModel.GetWAEmplID();
EmployeeModel emplModel = new EmployeeModel();
emplModel.SetEmplID(emplID);
EmployeeService emplService = new EmployeeService(emplModel);
emplModel = emplService.searchByEmplID();
if (emplModel.GetName() == null || emplModel.GetName() == "")
return false;
return true;
}
public EmployeeService(EmployeeModel employeeModel)
{
this._employeeModel = employeeModel;
}
// 取得所有員工資料
public List<EmployeeModel> GetAllEmplData()
{
List<EmployeeModel> emplList = new List<EmployeeModel>();
if (this.connectToDB())
{
try
{
DataTable dataSet = new DataTable();
String searchString = String.Format("SELECT * FROM employee");
MySqlCommand searchCommand = new MySqlCommand(searchString, myConnection);
searchCommand.ExecuteNonQuery();
MySqlDataAdapter adapter = new MySqlDataAdapter(searchCommand);
adapter.Fill(dataSet);
foreach (DataRow searchDr in dataSet.Rows)
{
EmployeeModel emplModel = new EmployeeModel();
emplModel.SetEmplID(searchDr["emplID"].ToString());
emplModel.SetAddress(searchDr["address"].ToString());
emplModel.SetBasicSalary(System.Convert.ToSingle(searchDr["basicSalary"]));
emplModel.SetBirth(System.Convert.ToDateTime(searchDr["birth"]));
emplModel.SetBlood(searchDr["blood"].ToString());
emplModel.SetDeptID(searchDr["deptID"].ToString());
emplModel.SetEmerPerson(searchDr["emerPerson"].ToString());
emplModel.SetEmerPhone(searchDr["emerPhoneNum"].ToString());
emplModel.SetEmplID(searchDr["emplID"].ToString());
emplModel.SetName(searchDr["emplName"].ToString());
emplModel.SetJobStatus(searchDr["jobStat"].ToString());
emplModel.SetMarriedStatus(searchDr["marriedStat"].ToString());
emplModel.SetMilitaryStatus(searchDr["military"].ToString());
emplModel.SetPhone(searchDr["phone"].ToString());
emplModel.SetPositoinID(searchDr["positionID"].ToString());
emplModel.SetSex(searchDr["sex"].ToString());
emplModel.SetSpouse(searchDr["spouse"].ToString());
emplModel.SetSsn(searchDr["ssn"].ToString());
emplList.Add(emplModel);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Number + " : " + ex.Message);
}
}
this.closeConnection();
return emplList;
}
// 呼叫service 利用員工ID查詢員工資料
public EmployeePresentationModel SearchDataByEmplID()
{
EmployeePresentationModel emplPresentationModel = new EmployeePresentationModel();
if (this._employeeModel.GetEmplID() == null || this._employeeModel.GetEmplID() == "")
MessageBox.Show("請輸入員工ID");
else
{
_employeeService = new EmployeeService(this._employeeModel);
_employeeModel = _employeeService.searchByEmplID();
emplPresentationModel.SetEmplID(_employeeModel.GetEmplID());
emplPresentationModel.SetName(_employeeModel.GetName());
emplPresentationModel.SetSsn(_employeeModel.GetSsn());
emplPresentationModel.SetSex(_employeeModel.GetSex());
emplPresentationModel.SetPhone(_employeeModel.GetPhone());
emplPresentationModel.SetAddress(_employeeModel.GetAddress());
emplPresentationModel.SetBlood(_employeeModel.GetBlood());
emplPresentationModel.SetBirth(_employeeModel.GetBirth());
emplPresentationModel.SetEmerPerson(_employeeModel.GetEmerPerson());
emplPresentationModel.SetEmerPhone(_employeeModel.GetEmerPhone());
emplPresentationModel.SetMilitaryStatus(_employeeModel.GetMilitaryStatus());
emplPresentationModel.SetJobStatus(_employeeModel.GetJobStatus());
emplPresentationModel.SetMarriedStatus(_employeeModel.GetMarriedStatus());
emplPresentationModel.SetSpouse(_employeeModel.GetSpouse());
emplPresentationModel.SetDeptID(_employeeModel.GetDeptID());
emplPresentationModel.SetPositoinID(_employeeModel.GetPositionID());
emplPresentationModel.SetBasicSalary(_employeeModel.GetBasicSalary());
if (_employeeModel.GetName() == null || _employeeModel.GetName() == "")
{
MessageBox.Show("此員工ID不存在!");
emplPresentationModel.SetEmplID(null);
}
}
return emplPresentationModel;
}
public void Initialize()
{
_employee = new EmployeeModel();
_target = new PrivateObject(_employee);
}