public static List <LoaiNhanVienCNDTO> LayLoaiNhanVien() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayLoaiNhanVien"; DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { //LoaiNhanVienDTO loaiNV = new LoaiNhanVienDTO(); int maLoaiNhanVien = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString()); string tenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString(); double luong = Int32.Parse(dt.Rows[i]["Luong"].ToString()); LoaiNhanVienCNDTO loaiNV = new LoaiNhanVienCNDTO(maLoaiNhanVien, tenLoaiNhanVien, luong); list.Add(loaiNV); //NhaHangDTO nhaHang = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai); //list.Add(nhaHang); } } return(list); }
private void loadLoaiNhanVien() { m_cboxMaLoai.Items.Clear(); //m_cboxMaLoai.Items.Add("Chon Loại Nhân Viên"); LoaiNhanVienCNDTO lnv = new LoaiNhanVienCNDTO(0, "Tất cả", 0); List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>(); list = LoaiNhanVienCNBUS.LayLoaiNhanVien(); list.Insert(0, lnv); m_cboxMaLoai.ValueMember = "MaLoaiNhanVien"; m_cboxMaLoai.DisplayMember = "TenLoaiNhanVien"; m_cboxMaLoai.DataSource = list; m_cboxMaLoai.SelectedIndex = 0; }