public List <Phongban_DTO> SearchPB(string str) { List <Phongban_DTO> PBList = new List <Phongban_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchPB @search ", new object[] { str }); foreach (DataRow item in data.Rows) { Phongban_DTO PhongBan = new Phongban_DTO(item); PBList.Add(PhongBan); } return(PBList); }
public List <Phongban_DTO> GetPB() { List <Phongban_DTO> list = new List <Phongban_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("dbo.USP_GetDSPB"); foreach (DataRow item in data.Rows) { Phongban_DTO pb = new Phongban_DTO(item); list.Add(pb); } return(list); }