public IActionResult AppCustomerList(AppAddClient mode)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
//var query = _dbContext.Customer.Where(x => x.ClientManager.ToString() == "423968DF-A15D-4B5F-9E25-005486496332" && x.IsDelete == 0);
var query = from x in _dbContext.Customer
where x.SuperiorUuid.ToString() == "00000000-0000-0000-0000-000000000000" && x.IsDelete == 0
select new
{
x.Id,
x.ClientUuid,
x.ClientName,
ClientManageruuid = x.ClientManager,
ClientManager = x.ClientManagerNavigation.RealName,
x.ClientStatusNavigation.StatusName,
x.BusinessUuid,
x.ClientPhone,
x.ClientPostcode,
x.ClientAddress,
Manager = x.ClientManager,
};
// 如果是我们指定的角色,可以查看所有的客户,否则只能看自己负责的客户
if (AuthContextService.CurrentUser.RoleName != "超级管理员" && AuthContextService.CurrentUser.RoleName != "行业经理")
{
query = query.Where(x => x.Manager == AuthContextService.CurrentUser.Guid);
}
//如果客户名称搜索框不为空,模糊匹配搜索框内容
if (!string.IsNullOrEmpty(mode.Kk1))
{
query = query.Where(x => x.ClientName.Contains(mode.Kk1));
}
//按照ID排序(降序)
query = query.OrderByDescending(x => x.Id);
var qu = query.ToList();
string param2 = "{\"code\":0,\"message\":\"成功\",\"ListData\":[";
for (int i = 0; i < qu.Count; i++)
{
if (i == 0)
{
param2 += "{ \"Id\": \"" + qu[i].Id + "\",\"ClientUuid\":\"" + qu[i].ClientUuid + "\",\"ClientName\":\"" + qu[i].ClientName + "\",\"ClientManager\":\"" + qu[i].ClientManager + "\",\"StatusName\":\"" + qu[i].StatusName
+ "\",\"BusinessUuid\":\"" + qu[i].BusinessUuid + "\",\"ClientPhone\":\"" + qu[i].BusinessUuid + "\",\"ClientPostcode\":\"" + qu[i].BusinessUuid + "\",\"ClientAddress\":\"" + qu[i].BusinessUuid + "\",\"checkbox\":\"" +
Gettruefalse(qu[i].ClientManageruuid.ToString(), mode.SystemUserUuid, qu[i].ClientName, mode.Kk1) + "\",\"children\":[" + Geterjicd(qu[i].ClientUuid.ToString(), mode.SystemUserUuid, mode.Kk1) + "]}";
}
else
{
param2 += ",{ \"Id\": \"" + qu[i].Id + "\",\"ClientUuid\":\"" + qu[i].ClientUuid + "\",\"ClientName\":\"" + qu[i].ClientName + "\",\"ClientManager\":\"" + qu[i].ClientManager + "\",\"StatusName\":\"" + qu[i].StatusName
+ "\",\"BusinessUuid\":\"" + qu[i].BusinessUuid + "\",\"ClientPhone\":\"" + qu[i].BusinessUuid + "\",\"ClientPostcode\":\"" + qu[i].BusinessUuid + "\",\"ClientAddress\":\"" + qu[i].BusinessUuid + "\",\"checkbox\":\"" +
Gettruefalse(qu[i].ClientManageruuid.ToString(), mode.SystemUserUuid, qu[i].ClientName, mode.Kk1) + "\",\"children\":[" + Geterjicd(qu[i].ClientUuid.ToString(), mode.SystemUserUuid, mode.Kk1) + "]}";
}
}
param2 += "]}";
var result = JsonConvert.DeserializeObject <CustomerRoot>(param2);
response.SetData(result);
return(Ok(response));
}
}
public IActionResult AppCustomerAdd(AppAddClient model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanCRM.Api.Entities.Customer();
var zt = _dbContext.CustomerStatus.FirstOrDefault(x => x.StatusName == model.ClientStatus);
var lx = _dbContext.CustomerTypeList.FirstOrDefault(x => x.TypeName == model.ClientType);
var entity3 = new Business();
entity3.BusinessUuid = Guid.NewGuid();
entity.BusinessUuid = entity3.BusinessUuid.ToString();
entity.ClientManager = model.ClientManager;
entity.ClientUuid = Guid.NewGuid();
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
if (model.ClmoName != null)
{
var query = _dbContext.Customer.FirstOrDefault(x => x.ClientName == model.ClmoName);
if (query != null)
{
entity.SuperiorUuid = query.ClientUuid;
entity.SuperiorMenu = query.SuperiorMenu + 1;
}
}
else
{
entity.SuperiorUuid = Guid.Empty;
entity.SuperiorMenu = 0;
}
entity.IsDelete = 0;
if (zt == null)
{
entity.ClientStatus = null;
}
else
{
entity.ClientStatus = zt.CustomerStatusUuid;
}
if (lx == null)
{
entity.ClientType = null;
}
else
{
entity.ClientType = lx.TypeUuid;
}
if (model.ClientIndustry != null)
{
entity.ClientIndustry = Guid.Parse(model.ClientIndustry);
}
entity.ClientName = model.ClienName;
//entity.ClientPhone = model.ClientPhone;
entity.ClientEmail = model.ClientEmail;
entity.ClientFax = model.ClientFax;
entity.ClientPostcode = model.ClientPostcode;
entity.ClientArea = model.ClientArea;
entity.ClientWebsite = model.ClientWebsite;
entity.ClientAddress = model.ClientAddress;
if (model.usName != "")
{
var entity6 = new SystemLog();
entity6.SystemLogUuid = Guid.NewGuid();
entity6.OperationContent = "钉钉端客户管理系统-用户(" + model.usName + ")添加了一个客户(客户名称:" + model.ClienName + ")";
entity6.UserName = model.usName;
entity6.OperationTime = DateTime.Now.ToString("yyyy-MM-dd");
entity6.Type = "钉钉端添加";
entity6.IsDelete = 0;
_dbContext.SystemLog.Add(entity6);
}
entity.Remarks = model.Remarks;
_dbContext.Customer.Add(entity);
_dbContext.Business.Add(entity3);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}