Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }