public Depart(DaoDepartment depart, DataService service, FmDb par) { InitializeComponent(); this.depart = depart; this.service = service; parent = par; labName.Text = depart.name; labInfo.Text = depart.info; }
//获取所有department 记录 public List <DaoDepartment> getAllDepartments() { List <DaoDepartment> list = null; if (con != null) { try { if (con.State != ConnectionState.Open) { con.Open(); } list = new List <DaoDepartment>(); string queryStr = @"select * from tabdepartments;"; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = queryStr; using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { DaoDepartment one = new DaoDepartment(); one.id = reader.GetInt16(0); one.name = reader.GetString(1); one.info = reader.GetString(2); list.Add(one); } } } catch (Exception ex) { Console.WriteLine("getDepartment Error!\n" + ex.Message); } } return(list); }