public List <PhieuMH_KH> Search(PhieuMuaHang_DTO a, string diachi, string tenkh) { var pmh = DB.PhieuMuaSearch(a.SoPhieuMua, a.MaKH, a.NgayMua, a.NgayThanhToan, diachi, a.TongTien, tenkh); var MyQuery = (from mh in pmh select new PhieuMH_KH { SoPhieuMua = mh.SoPhieuMua, MaKH = mh.MaKH, NgayMua = mh.NgayMua.Value.ToShortDateString(), NgayThanhToan = mh.NgayThanhToan.Value.ToShortDateString(), TongTien = Decimal.Parse(mh.TongTien.ToString()), TenKH = mh.TenKh, DiaChi = mh.DiaChi }); return(MyQuery.ToList()); }