Example #1
0
        // 取得所有員工資料
        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;
        }