// 取得所有員工資料 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); }