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