public List <LoaiHangHoa_DTO> SearchLHH(string str) { List <LoaiHangHoa_DTO> LHHlist = new List <LoaiHangHoa_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchLHH @search ", new object[] { str }); foreach (DataRow item in data.Rows) { LoaiHangHoa_DTO LHH = new LoaiHangHoa_DTO(item); LHHlist.Add(LHH); } return(LHHlist); }
public List <LoaiHangHoa_DTO> GetDSLHH() { List <LoaiHangHoa_DTO> list = new List <LoaiHangHoa_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("dbo.USP_GetallLHH"); foreach (DataRow item in data.Rows) { LoaiHangHoa_DTO LHH = new LoaiHangHoa_DTO(item); list.Add(LHH); } return(list); }