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();
}
/// <summary>
/// 初始化用户列表显示
/// </summary>
public void DisplayUserList()
{
//设置属性对应的字段
SystemUserLogic sul2 = new SystemUserLogic();
//填充数据
dgvUserSetting.DataSource = sul2.GetAllUsers();
}
/// <summary>
/// 根据销售员id显示客户信息
/// </summary>
public void LoadCusInfo()
{
var showCusList = from customer in ccl.GetAll(saleid)
join user in sul.GetAllUsers()
on customer.SaleId equals user.Id
select new
{
Id = customer.Id,
CusCode = customer.CusCode,
CusName = customer.CusName,
Province = customer.Province,
City = customer.City,
BussinessType = customer.BussinessType,
Scale = customer.Scale,
CusType = customer.CusType,
PhoneNum = customer.PhoneNum,
HomePage = customer.HomePage,
Address = customer.Address,
UserName = user.UserName,
SaleId = customer.SaleId
};
dgvCusInfo.DataSource = showCusList.ToList();
}
