public BindingList <CTPhieuBan_DTO> Search(int sophieu, int masp,
int slmin, int slmax, decimal dongiamin, decimal dongiamax, decimal thanhtienmin, decimal thanhtienmax)
{
IEnumerable <MCT_PhieuBanHanh_SearchResult> ct;
ct = datacontext.MCT_PhieuBanHanh_Search(sophieu,
masp,
slmin, slmax,
dongiamin, dongiamax,
thanhtienmin, thanhtienmax
);
var myquery = (from x in ct
select new CTPhieuBan_DTO
{
SoPhieuBan = x.SoPhieuBan,
MaSP = x.MaSP,
SoLuong = x.SoLuong.GetValueOrDefault(),
DonGia = x.DonGia.GetValueOrDefault(),
ThanhTien = x.ThanhTien.GetValueOrDefault()
});
var r = new BindingList <CTPhieuBan_DTO>(myquery.ToList());
return(r);
}