Пример #1
0
        public List <NhaPhanPhoi_DTO> SearchNPP(string str)
        {
            List <NhaPhanPhoi_DTO> NPPlist = new List <NhaPhanPhoi_DTO>();
            DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchNhaPhanPhoi @search ", new object[] { str });

            foreach (DataRow item in data.Rows)
            {
                NhaPhanPhoi_DTO NPP = new NhaPhanPhoi_DTO(item);
                NPPlist.Add(NPP);
            }
            return(NPPlist);
        }
Пример #2
0
        public List <NhaPhanPhoi_DTO> GetDSNPP()
        {
            List <NhaPhanPhoi_DTO> list = new List <NhaPhanPhoi_DTO>();
            DataTable data = DataProvider.Instance.ExecuteQuery("dbo.USP_GetallNhaPhanPhoi");

            foreach (DataRow item in data.Rows)
            {
                NhaPhanPhoi_DTO NPP = new NhaPhanPhoi_DTO(item);
                list.Add(NPP);
            }
            return(list);
        }