public IActionResult AppContectList(ContactRequstPaload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = from cp in _dbContext.ContactPerson
where cp.IsDelete == 0
select new
{
cp.Id,
cp.ContactName,
cp.ContactPersonUuid,
cp.Phone,
cp.ClientUu.ClientManager,
cp.ClientUu.ClientName,
};
// 如果是我们指定的角色,可以查看所有的联系人,否则只能看自己负责的客户的联系人
if (AuthContextService.CurrentUser.RoleName != "超级管理员" && AuthContextService.CurrentUser.RoleName != "行业经理")
{
query = query.Where(x => x.ClientManager == AuthContextService.CurrentUser.Guid);
}
//如果联系人名字搜索框不为空,模糊匹配搜索框内容
if (!string.IsNullOrEmpty(payload.Kk1))
{
query = query.Where(x => x.ContactName.Contains(payload.Kk1));
}
//按照ID排序(降序)
query = query.OrderByDescending(x => x.Id);
var qu = query.ToList();
string param2 = "{\"code\":0,\"message\":\"成功\",\"ListData\":[";
//var strlist = query.ToList();
for (int i = 0; i < qu.Count; i++)
{
var phonelist = "";
if (qu[i].Phone != "")
{
string[] lists = qu[i].Phone.Split(' ');
if (lists.Length > 0)
{
for (int i1 = 0; i1 < lists.Length; i1++)
{
if (lists[i1] != "")
{
if (phonelist != "")
{
phonelist += ",\"" + lists[i1] + "\"";
}
else
{
phonelist = "\"" + lists[i1] + "\"";
}
}
}
}
}
if (i == 0)
{
param2 += "{ \"Id\": \"" + qu[i].Id + "\",\"ContactName\":\"" + qu[i].ContactName + "\",\"ContactPersonUuid\":\"" + qu[i].ContactPersonUuid + "\",\"ClientName\":\"" + qu[i].ClientName +
"\",\"phone\":[" + phonelist + "]}";
}
else
{
param2 += ",{ \"Id\": \"" + qu[i].Id + "\",\"ContactName\":\"" + qu[i].ContactName + "\",\"ContactPersonUuid\":\"" + qu[i].ContactPersonUuid + "\",\"ClientName\":\"" + qu[i].ClientName +
"\",\"phone\":[" + phonelist + "]}";
}
//phonelist = "";
}
param2 += "]}";
var result = JsonConvert.DeserializeObject <ContactRoot>(param2);
response.SetData(result);
return(Ok(response));
}
}
public IActionResult List(ContactRequstPaload payload)
{
using (_dbContext)
{
using (_dbContext)
{
//var query = from cp in _dbContext.ContactPerson
// where cp.IsDelete == 0
// select new
// {
// cp.Id,
// cp.ContactName,
// cp.AddTime,
// cp.Call,
// cp.ContactPersonUuid,
// cp.Title,
// cp.Phone,
// cp.Cellphone,
// sex = cp.Sex == "1" ? "男" : cp.Sex == "2" ? "女" : cp.Sex == "3" ? "未知" : "",
// cp.WeChat,
// cp.BgPhone,
// cp.ZjPhone,
// cp.DateBirth,
// cp.TencentQq,
// cp.OfficeAddress,
// cp.FamilyAddress,
// realName = cp.SystemUserUu.RealName,
// cp.ClientUu.ClientUuid,
// cp.ClientUu.ClientName,
// cp.ClientUu.ClientPhone,
// Manager=cp.ClientUu.ClientManager,
// ClientManager = CooM(cp.ClientUuid),
// cp.Remarks,
// };
var query = _dbContext.ContactPersonView.Select(x => new
{
x.Id,
x.ContactName,
x.AddTime,
x.Call,
x.IsDelete,
x.ContactPersonUuid,
x.Title,
x.Phone,
x.Cellphone,
sex = x.Sex == "1" ? "男" : x.Sex == "2" ? "女" : x.Sex == "3" ? "未知" : "",
x.WeChat,
x.BgPhone,
x.ZjPhone,
x.DateBirth,
x.TencentQq,
x.OfficeAddress,
x.FamilyAddress,
x.RealName,
x.ClientUuid,
x.ClientName,
x.ClientPhone,
x.Manager,
x.ClientManager,
x.Remarks,
}).Where(x => x.IsDelete == 0);
// TODO:不可以硬编码,下个版本解决
// 如果是我们指定的角色,可以查看所有的联系人,否则只能看自己的联系人
if (AuthContextService.CurrentUser.RoleName != "超级管理员" && AuthContextService.CurrentUser.RoleName != "行业经理")
{
query = query.Where(x => x.Manager == AuthContextService.CurrentUser.Guid);
}
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.ContactName.Contains(payload.Kw));
}
if (!string.IsNullOrEmpty(payload.Kw1))
{
query = query.Where(x => x.ClientName.Contains(payload.Kw1));
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
}