public int GetIDLoaiGiay(string id_giay) { string query = "select * from catarogry a, ThongTinGiay b where a.id_loaigiay=b.id_loaigiay and id_giay =N'" + id_giay + "' "; DataTable datatb = DataProvider.Instance.ExecuteQuery(query); if (datatb.Rows.Count > 0) { Catarogry catarogry = new Catarogry(datatb.Rows[0]); return(catarogry.ID_LoaiGiay); } return(-1); }
public List <Catarogry> LoadLoaiHang() { List <Catarogry> list = new List <Catarogry>(); DataTable datatb = new DataTable(); string query = "select* from catarogry"; datatb = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in datatb.Rows) { Catarogry catarogry = new Catarogry(item); list.Add(catarogry); } return(list); }