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); }
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); }