private void cbxMaVx_SelectionChangeCommitted(object sender, EventArgs e) { String maVx = (cbxMaVx.SelectedItem as Vacxin).MaVacxin; String query = String.Format("EXEC dbo.chonVacxinTheoMaVX @maVX = '{0}'", maVx); DataTable dt = DataProvider.Instance.ExcuteQuery(query); Vacxin vx = new Vacxin(dt.Rows[0]); txtDonGia.Text = (Int32.Parse(vx.GiaThanh) * 1.1).ToString(); }
public List <Vacxin> LoadVacxinList() { List <Vacxin> list = new List <Vacxin>(); DataTable data = DataProvider.Instance.ExcuteQuery("EXEC USP_GetVacxin"); foreach (DataRow item in data.Rows) { Vacxin vx = new Vacxin(item); list.Add(vx); } return(list); }
public List <String> loadMaVacxin() { List <String> list = new List <String>(); DataTable data = DataProvider.Instance.ExcuteQuery("EXEC dbo.getVacxin"); foreach (DataRow item in data.Rows) { Vacxin vx = new Vacxin(item); list.Add(vx.MaVacxin); } return(list); }
public List <Vacxin> SearchVacxinByName(string name) { List <Vacxin> list = new List <Vacxin>(); String query = string.Format("select * from Vacxin where TenVacxin like N'%{0}%'", name); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { Vacxin vx = new Vacxin(item); list.Add(vx); } return(list); }
public List <Vacxin> getVacxinByLoai(string name) { List <Vacxin> list = new List <Vacxin>(); String query = string.Format(" EXEC layVacxinTheoMaLoai @maLoai='{0}'", name); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { Vacxin vx = new Vacxin(item); list.Add(vx); } return(list); }
public List <Vacxin> SearchVacxinByID(string id) { List <Vacxin> list = new List <Vacxin>(); String query = string.Format("EXEC timVacxinTheoMaVx @maVx='{0}'", "%" + id + "%"); DataTable data = DataProvider.Instance.ExcuteQuery(query); foreach (DataRow item in data.Rows) { Vacxin vx = new Vacxin(item); list.Add(vx); } return(list); }