private void txtMaVacxin_TextChanged(object sender, EventArgs e) { if (dtgVacxin.SelectedCells.Count > 0) { String id = dtgVacxin.SelectedCells[0].OwningRow.Cells["MaLoai"].Value.ToString(); LoaiVacxin loai = LoaiVacxinDAO.Instance.getLoaiVacxinByMa(id); cbxLoaiVacxin.SelectedItem = loai; int index = -1; int i = 0; foreach (LoaiVacxin item in cbxLoaiVacxin.Items) { if (item.MaLoai == loai.MaLoai) { index = i; break; } i++; } cbxLoaiVacxin.SelectedIndex = index; } }
public List <LoaiVacxin> SearchLoaiVacxinByID(string id) { List <LoaiVacxin> list = new List <LoaiVacxin>(); String query = string.Format("EXEC timLoaiVxTheoMaLoai @maLoai='{0}'", "%" + id + "%"); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { LoaiVacxin vx = new LoaiVacxin(item); list.Add(vx); } return(list); }
public List <LoaiVacxin> getListLoaiVacxin() { List <LoaiVacxin> loaiVx = new List <LoaiVacxin>(); DataTable data = DataProvider.Instance.ExcuteQuery("EXEC USP_GetLoai"); foreach (DataRow item in data.Rows) { LoaiVacxin loai = new LoaiVacxin(item); loaiVx.Add(loai); } return(loaiVx); }
public LoaiVacxin getLoaiVacxinByMa(String id) { LoaiVacxin loai = null; string query = String.Format("EXEC dbo.chonVacxinTheoMaLoai @maLoai = '{0}'", id); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { loai = new LoaiVacxin(item); return(loai); } return(loai); }
public LoaiVacxin getLoaiVacxinByMa(String id) { LoaiVacxin loai = null; string query = String.Format("select * from LoaiVacxin where MaLoai='{0}'", id); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { loai = new LoaiVacxin(item); return(loai); } return(loai); }