public BindingList <PhieuNo_DTO> Search(int sophieuno, int sophieuban, string tenkh, string ngayno, string ngaythanhtoan, decimal sotientramin, decimal sotientramax, decimal conlaimin, decimal conlaimax) { IEnumerable <MPhieuNo_SearchResult> phieuno; phieuno = datacontext.MPhieuNo_Search(sophieuno, sophieuban, tenkh, DateTime.Parse(ngayno), DateTime.Parse(ngaythanhtoan), sotientramin, sotientramax, conlaimin, conlaimax ); var myquery = (from x in phieuno select new PhieuNo_DTO { SoPhieuNo = x.SoPhieuNo, SoPhieuBan = x.SoPhieuBan.Value, NgayNo = x.NgayNo.ToString(), NgayThanhToan = x.NgayThanhToan.ToString(), SoTienTra = x.SoTienTra.Value, SoTienConLai = x.SoTienConLai.Value }); var r = new BindingList <PhieuNo_DTO>(myquery.ToList()); return(r); }