public void RefreshVisitList()
{
CRM_VisitLogic cvs = new CRM_VisitLogic();
SystemUserLogic sul = new SystemUserLogic();
CRM_CustomerLogic ccusl = new CRM_CustomerLogic();
CRM_ContactLogic cconl = new CRM_ContactLogic();
var showvisitlist = from visit in cvs.GetAll()
join customer in ccusl.GetAll()
on visit.CusId equals customer.Id
join user in sul.GetAllUsers()
on visit.VSuperiorId equals user.Id
join contact in cconl.GetAll()
on visit.ConId equals contact.Id
select new
{
Id = visit.Id,
CusCode = customer.CusCode,
CusName = customer.CusName,
UserName = user.UserName,
ContactName = contact.Name,
VTitle = visit.VTitle,
VContent = visit.VContent,
VType = visit.VType,
VPlanDate = visit.VPlanDate,
VCompleteDate = visit.VCompleteDate,
VSuperiorDate = visit.VSuperiorDate,
VSuperiorSuggestion = visit.VSuperiorSuggestion,
VStatus = visit.VStatus
};
this.dgvVisitInfo.DataSource = showvisitlist.ToList();
}
