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