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